Aged Analysis Report
From FloristWiki
Aged Analysis reports provide you with an analysis of your house account balances for either open item or balance forward accounts. You can use Aged Analysis reports to:
- View potential future cash flow.
- See how much customers owe and decide what steps you need to take to recoup money that you are owed.
Aged Analysis reports include only those accounts with balances for the selected store(s) and reporting period. The reports contain account balances and aging on accounts from the sale date relative to the date you generate the report. By default, the Aged Analysis reports set the Balance Forward date one month prior to the current date. By setting the Account Balance date later than the Balance Forward date, you can include future transactions in the Aged Analysis report. Aging is calculated nightly.
You will typically generate Aged Analysis reports monthly, either just before or just after you create statements.
There are three types of Aged Analysis reports:
- Detail Report
- Lists each customer that has an open balance, as well as each individual transaction for the customer that occurred after the balance forward date. The report also prints the ticket number, product code(s) for each transaction, purchase date, and customer balance. Grand totals (for current, 30, 60, 90, 120+ days, and future, if selected) for each store are printed at the bottom of the report.
- Summary Report
- Lists each customer name and phone number, and the current, 30, 60, 90, 120+, and future balances (if selected) for each customer. Individual transactions are not listed.
- Grand Total Report
- Does not list individual customers. Total amounts for all customers are listed, separated by current, 30, 60, 90, 120+, and future balances.
