Hi Mike_James ,
All balances are tied up after all the correcting entries I made.
The error in the out of balance is not in the general ledger anymore. It is in the receivables amount presented for such client.
Also, I just noticed, the activity statement of account reflected correct balances for the client, but the aging details below the statement (current, previos month and prior months classification), has an error. There is a negative balance in the prior months portion showing negative balance.
Would it be better if I reverse first all entries made for correction for better analysis? Hope you can help me on this. I tried several approaches and receivables out of balances can be eliminted; however, the activity statement aging portion is still showing the negative portion in the prior month.
Currently, I am not able to determine the composition of the negative portion showing in the aging but this might be connected to the error in deposit application as the deposit was initially recorded in 2021 and was converted to invoice using 2222 date.
Your responses are greatly appreciated.
-Kim
Hi kimpossible , could the aging issues be corrected by changing the due dates on the transactions involved?
Hi Mike_James ,
Thank you for responding. Okay, will not reverse of delete corrections made at the moment.
Our file is not online (no subscription).
Could the aging issues be corrected by changing the due dates on the transactions involved?
- Could you elaborate on this pls?
One of my trials involved:
1. I deleted all the correcting entries
2. Created an invoice at the future date
3. Applied the deposit (the one dated 2222) to it.
4. Then I set up another deposit at the current date and applied it to the current invoice.
All entries here resulted to:
- GL balances are okay
- Error in the table of activity statement
- Error in the aging details below the statement.
Pls bear with me on this. We encountered the same error last year and we did the same correcting entries but it is the first time to encounter this.
Hi Mike_James ,
I repeated the steps of my correcting entries and when I generated, no out of balance in the receceivables recon and statement of account table. However, we still have this negative balance reflecting in the statement.
I have attached a screenshot of the statement. table is not equal to the summary below.
Note that the converted order with error amounted to 825. However, the negative balance in the aging presented is 1361.
Is there a way to trace where 1361 came from?
Your help is ver much appreciated. Thank you!
Thank you.
Hi kimpossible , the opening balance of K2084.00 doesn't match what the actual opening balance is either (K385.00). From the facts given I can't explain that. Since this has happened before, I suggest that a moderator should comment further, it may be that there is a corruption in your file (ie that the program is mis-reporting the results of all your particular entries).
If you create an activity statement from the beginning of this account, or the earliest possible time, to 31/12/2222, do the differences disappear?
