The aged trial balance allows you to identify client accounts unpaid for an excessive length of time and helps you determine those to write off as uncollectible.
For companies that do business in foreign currency, the Currency (Cur) column identifies the currency of invoices if different from the Home currency. Note: Amounts continue to display in the Home currency regardless of the currency of the invoice.
Select Accounts Receivable|Reports|Aged Trial Balance by Payer.
If you want to show each age group as a ”number of months past due,” key the month and year (MM/CCYY) you want to be reported in the Current column or if you want to show each age group as a ”number of days past due,” key the full date (MM/DD/CCYY) to age on day and year you want to be reported in the Current column. If you want a report of items billed through a certain past date, key that date in this field. This allows the system to ignore any billing performed after that date.
From the Select Report Version drop-down list, indicate the maximum number of days past due (or months past due) you want to appear on the report. 120+ days shows five age groups from current to ”more than 120 days old” (or ”more than 4 months old” if you entered an effective month). 180+ days shows shows seven age groups from current to ”more than 180 days old” (or ”more than 6 months old” if you entered an effective month). This setting is only possible if you are using a dot matrix printer. 120+ days with description shows five age groups with payer descriptions from current to more than 120 days old (or more than 4 months old if you entered an effective month).
From the Client Detail Selection drop-down list, select the client reporting level. Select Client Only to report at the client master level only. Select Client and Level 2 to report at the Client/Division level. Select Full Detail All Client Levels to report at all Client/Division/Product levels.
From the Period Selection drop-down list, select the receivable balance to come from either the current open status or from the history file. The system recreates the balance at that period in time.
Current Open Status Including Payments. Uses current balance of a receivable.
Recreate From History. Uses the history file to generate the balance.
Current Open Status Purged. Excluded paid items from printing. This purge is not permanent, it is only selected to reduce the amount of paper used when printing the report.
From History Plus Subsequent Payments. Uses the history file to generate the balance plus any following payments.
From the Select Data Types drop-down list, select All Receivables (Include all receivable accounts), Exclude Intercompany (Include all receivable accounts except intercompany accounts), or Intercompany Only (Include only intercompany receivables).
From the Invoice Sorting Selection area, click to sort in Invoice Date Order or Invoice Number Order.
From the Client (Payer) Sort area, click to sort By Client (Payer) Code or By Client Sort Name order.
From the Aging Selection area, click Age on Invoice date to age from the invoice date or click Age on Payment Due Date to age from the payment due date.
From the Page Break Selection area, click By Payer to start a new page for each payer. This allows for easy distribution of the report. Click Print Continuously to print continuously without a page break for each new payer.
From the Print Media Totals area, click Yes to print receivable amount totals by media type on the report; otherwise, click No. This field only applies if you selected to report at the client master level.
From the Office Selection drop-down list, select Job/Billing Office to run the ATB by the job/media billing office for invoice or select A/R Office to run the ATB by the Accounts Receivable office.
From the Consolidate Offices area, click Yes to consolidate offices so that clients used across offices can be viewed all together. Click No to report offices individually.
Select the types of receivables you want to include. Click Client Receivables and/or Employee Receivables, and/or Vendor receivables.
The O|X Invoice Number check box allows users who receive media bills from Mediaocean O|X to see invoice numbers as the standard eight-digit number used in Financials or prefixed with the O|X-assigned alpha code used by Mediaocean O|X. If you are an O|X user and want to see invoice numbers on media bills prefixed with the O|X-assigned alpha code, click the O|X Invoice Number checkbox. To see invoice numbers with the standard eight-digit numbers used in Financials, leave this checkbox blank.
To display the Printing Selections Window, click the Report button.
To export the report to a spreadsheet format, click the Export button.
To continue to work in another option or even log off while the information is being processed, click in the "Process in Background/Batch checkbox. This feature works with the Export function so make sure you click both the Export radio button as well as the "Process in Background/Batch" checkbox to process requested information in the background.
To limit information that displays in the collection, click the Selection buttons and select items from the list. Displayed lists show only clients assigned to you in User/Client Window Security. The <A/R Accounts> selection button only shows accounts that are set up as A/R accounts in the Chart of Accounts Definition Subsidiary Type.
Click the Next icon. If you selected Report, the Printing Selections Window displays. If you selected Export, the Columns to Include on Listing window displays. Select only the information you wish to include on the report then click the Next icon again to display the Processing Window.
You may click <Cancel> to cancel your request or if the report is large, you can take advantage of the <Send to Background> function which processes the request in the background so you can continue to work in other options. This function is also available on the Prompt as described above. As always, if you process in the background and your report is under 2MG in size, you will receive your report as an attachment in an email after processing is completed. If your report is over 2MG in size, your email will contain a link that will open a download window where you can save the file to a spreadsheet format.
.If you do not click <Cancel> or <Process in Background>, your report is output to the browser where you will see Filter, Page Number, and Max Rows functions. Click the Next Page (down) arrow to display the next page of information on the report. Click the Previous (up) arrow to return to the previous page of information. Key a Max Row to limit the amount of rows that display on a page to the specified number. To filter information, key a valid filter in any of the blank fields located below the applicable column heading and press <Enter>. Only values that match the specified filters are displayed. When filters are applied, page numbers are no longer displayed; however, you can continue to use the Next Page feature to advance to the next page of filtered information on the report. To remove all filters, click <Clear Filters> or you may remove filters separately by highlighting a filter and clicking <Delete>. Note: Total rows are not recalculated when filtering.
Click <Export to Spreadsheet> to export your report to a spreadsheet format or click the Print icon to generate a PDF of your report. If filters are used, only the information that is filtered displays on the spreadsheet or PDF.
Note: PDF processing limits the number of rows that display on the PDF to 3,000. If you receive the message “3000 row limit reached”, use the new filter function to limit the amount of information that is collected.