The age analysis does not show all the customers
The customers are active
Printing statements and other customer reports reflect the customer that is missing from the age analysis
The names missing are random
I am on the latest version 21.9.35
Thank You
The Aged Receivables report includes only customers with receivables, not all customers. That is, after all, in its title. If you want a list of receivable amounts, including zero balances, you will need to copy the Customers tab listing to a spreadsheet and create a report there.
1 Like
Thank You
Please explain why we have zero balances on our age analysis if the above is true
All the zero balances aslo show a zero amount in the 90+ days column
The customers with zero amounts in the 90+days column were made inactive
Please advice
Can you post a screen image of the report ?
@restdev, your posts are confusing. First, can you confirm that you are, in fact, discussing the Aged Receivables report? There is nothing in Manager named “age analysis.”
You have said both that the missing customers are active and inactive. You have said that “All the zero balances also show a zero amount in the 90+ days column.” Why would a zero-balance customer not show zero in the 90+ days column? It should show zero in all date ranges. But you began by complaining that customers are not showing, yet you describe what is displayed for them them. That does not make sense.
Remember, no one on the forum can see your records. We can only work with what you explicitly show us.
Sorry Tut
Age receivables
It makes sence that zero balance do not appear on the the age receivables
However what I am trying to convey is that the zero balances that appear on the report are balances that relate to inactive customers the zero appear in the 90+ days column and the balance column
My understanding is that Zero balances should not appear on the age receivables
All the zeros below belong to inactive customer
MEAN001 - Meaney,
Rebecca
- 50.00 - - - - 50.00
MORR001 - Morrissey
Emma
- 50.00 - - - - 50.00
SHIN001 - Shine, Tara 30.00 20.00 - - - - 50.00
TUBB001 - Tubbritt, Paul - 50.00 - - - - 50.00
PACU001 - Pacud, Olga - 35.00 - - - - 35.00
BOTH001 - Botha Leon - - 15.00 - - - 15.00
CLIN001 - Clinton Sinead - 10.00 - - - - 10.00
LATH001 - Latham, Patricia - 25.00 - - - 20.00 - 5.00
ARIF001 - Ariffin, Syuhada - - 9.00 - - 5.00 - 4.00
LEE001 - Lee, Melissa - 7.00 - - - 3.00 - 4.00
BIRK001 - Birkusova Corina - - - - 0.00 - 0.00
BULA001 - Bularz Agnieszka - - - - 0.00 - 0.00
BYRN001 - Byrne, Jacinta - - - - 0.00 - 0.00
COLL001 - Collom, David - - - - 0.00 - 0.00
CROK001 - Croke Annette - - - - 0.00 - 0.00
CYMA001 - Cymanowski
David
-
-
-
- 0.00 - 0.00
-
-
DENN001 - Denny, Mathew - - - - 0.00 - 0.00
Your manually typed listing are not helpful for troubleshooting. Please post a screen shot of what you are trying to illustrate.
A sceen print as requested
Another interesting observation
We tried to delete a number of age receivable reports but after deleting it was back again We create a report with today’s date and save it it seems that it automatically changes the report to the new date
The thing is “today” is dynamic.
You can create a single report with today’s date and it will always be current balance.
If you need historical reports, you can create them at date-1 or less.
Finally, I understand what you have been trying to convey. The screen shot would have saved much time if you had included it in your first post.
Let’s confine ourself to one customer: BIRK001. To figure out why this customer is included, you need to examine their Accounts receivable balance. You can do that at least three ways:
- Drill down from the Summary page on Accounts receivable and that customer
- Edit the Aged Receivables report by checking the box to
Show invoices - Drill down from the Aged Receivables report by clicking on the customer’s name
This will allow you to identify why there is a zero balance showing in the 90+ days column. It could be, for example, that you have offsetting invoices that have not been settled, but cancel each other out. But there could also be other reasons. The answer will come from examine the sales invoices responsible for the inclusion.
How did you try to delete them?
Thank you
I need your help attached two screenshots of the account BIRK001 I am not sure how to resolve that or maybe I am doing something wrong The credit note was created to write off the outstanding amount of a client that left
The second attachment shows a credit amount because the client paid more than invoiced
I hope this is clear
Things are only a little bit clearer. You should show the Edit screens of these transactions. And if you need to show the View screens (or any screen, for that matter), show the entire thing. As is, I can only guess that these might be sales invoices.
From what I can see, however, you may have issued a credit note for €25 when the balance due on a sales invoice was €40. That alone explains why the customer shows on the Aged Receivables report. And you might have received an excess payment on a different sales invoice, leaving it in an overpaid status. The two just happen to produce a net receivable of zero. But neither sales invoice is satisfactorily closed out.
The way to settle a bad debt, moreover, is not with a credit note. That implies the customer did not owe you the money. A bad debt should be written off to an appropriate expense account. See the Guide: Write off bad debts | Manager. While it is possible to achieve the same financial result with a credit note, it is easy to get the tax adjustments wrong. And you might run afoul of local regulations or accounting standards by using a credit note.
Thank you for your assistance will do