How can I find out the Accounts Receivable I have outstanding?

Last modified at May 25th, 2020

Sometimes you just need to find out how much money your customers owe you overall. That's where the Aged Analysis report comes in. This report will show you the total amount due per customer and the overall total. It can also be run in a detailed mode and show you individual invoices and how many days past due they are based on terms. To get to this report, go to Reports then Reports Selector. From there, expand the Customers section. It will be the first one in the list, double click it to open it.

This will bring you to the report criteria screen. Specify your Aging Date and whether you only want to show balances over 30,60, or 90 days. If you wish to see just a summarized version of the report, to get just the balances, check the Summary checkbox. If you do not wish to include Finance Charges then un-check the box. There are also several other filters on this screen as well as under Advanced Filter if you wish to filter further. Once you are happy with your selections, click the Preview button.

If the summary box was checked, you will see report like the one below giving balances per customer.

If the summary box was not checked, you will get a more detailed balance by customer by invoice report like the one below.


Was this article helpful?