Aged Analysis Reports

From FloristWiki

Current revision

Aged Analysis Report - Detail

Aged Analysis Report - Summary

Aged Analysis Report - Grand Total

The Aged Analysis reports provide you with an analysis of your house account balances. The report includes only those accounts with balances for the selected store(s) and reporting period. Aged Analysis reports contain account balances and aging on accounts from the sale date relative to the date you generate the report. Aging is calculated nightly. 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. To assist your collection efforts, Aged Analysis detail and summary reports include customers’ phone numbers. You will typically generate Aged Analysis reports monthly, either just before or just after you create statements. By printing each month’s Aged Analysis report, you can review account aging for a previous month or look up a customer’s balance when access to a terminal is not possible.

You can generate Aged Analysis reports for balance forward or open item accounts at individual stores or at all stores. You may sort detail and summary reports according to customer ID, sale date, or sort name. 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.

The three types of aged analysis reports are:

• 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.

The detailed Aged Analysis report contains the following information:

Generating Aged Analysis Reports

To generate Aged Analysis reports:

1. On the FTD Mercury Main Menu, click Business Reports.
2. Double-click on the Aged Analysis Report icon to open the template.
3. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
4. In the Store of Origin field, click the arrow and select the store’s data that you want to use for the report.
5. In the Customer Type section, select which customers’ information that you want to view, Balance Forward, Open Item, or both.
6. In the Report Type section, select the type of report that you want to print. See the information at the beginning of this section for the descriptions of the report types.
7. In the Past Due section, select the past due accounts that you want to view. You can choose accounts that are current (up-to-date) or accounts that are 30, 60, 90, and/or 120+ past due.
8. In the Print Order section, select how you want to sort the printing order of the data records. You can sort the records by Customer ID, Sale Date, or Sort Name (customer name).
9. In the Balance Forward Date field, click the arrow and select the balance forward date of the customers that you want to print.
10. In the Account Balance as of field, click the arrow and select the date for calculating aging. Setting the Account Balance as of date later than the current date allows you to include future transactions in the Aged Analysis report.
11. Select Include Wire Service Accounts only if you want to include wire service accounts (FTD, TEL, etc.) in the report.
12. Click Finish. The report generates and opens in Excel.
13. To print your report from Excel, on the File menu, click Print.
14. If you want to save the report from Excel, on the File menu, click Save.

Aged Analysis Report Window

Aged Analysis Report Window

The Aged Analysis Report window allows you to configure settings for the Aged Analysis report. When you have finished configuring the settings, click Finish to generate the report and open it in Microsoft Excel.

The Aged Analysis Report window contains the following settings:

Back to Business Reports