Home → MediaPlus Advertising Accounting → End of Month Procedures → Aging Reports (EOM)

5.6. Aging Reports (EOM)

1.    From the Software menu, select Accounts Receivable | Reports | Aging List.

2.    In the Selection | Aging subtab, enter the last day of the month in the As of Date field, or click on the Calendar icon and make a selection.

3.    Uncheck the All box adjacent to the A/R Account field, and click on the Search icon.  Select the A/R account that applies to you location, and then click on the OK button.

4.    Ensure that the Invoice Date option is selected under the Age ref. date according to heading.

5.    Under the following headings, ensure that the All boxes are checked: Client, Agency’s Client, Salesrep, Company, Main Client Type, Terms of Payment, Classified Client Type, Invoice, Credit Code, Invoice Age, Total Due of Selected Invoices, and Total Due of Selected Invoices per Client.

6.    Uncheck the All box adjacent to the Profit Center field, and click on the Search icon.  Select the profit center(s) that apply to your location, and click on the OK button.

7.    Under the Salesrep Choice heading, ensure that the Client option is selected.

8.    Under the Report Format heading, ensure that the Summary option is selected.

9.    Click on the Print & Misc. subtab.  Under the Client Selection heading, ensure that the With positive balance and With negative balance Balance options are checked.

10.    Under the In Collection heading, ensure that the All option is selected.

11.    Under the Miscellaneous heading, ensure that the Print Selection Criteria and Preview boxes are checked.

12.    Under the Invoice Selection heading, ensure that the  Invoice Dispute – All option is selected.

13.    Click on the Sort tab.  Under the Sorting heading, arrange the list by dragging and dropping the criteria in this order: (1) Client, (2) Invoice, (3) A/R Account.  The remaining items do not need to be in any particular order.

14.    Under the Breaking heading, ensure that the Client box is checked.

15.    Under the Clients sorted by heading, ensure that the Name box is checked.

16.    Under the Salesreps sorted by heading, ensure that the Number box is checked.

17.    Under the Invoices sorted by heading, ensure that the Number box is checked.

18.    Under the Collection Agencies sorted by heading, ensure that the Number box is checked.

19.    Click on the Start Process icon, or strike the < Alt + F2> keys.  Print the generated report.