An “Out of Balance” error message displays when the General Ledger is out of balance with Accounts Receivable. This message displays in the area of the report where account number totals are found. Note: Keep in mind that if you exclude any data when making selections on the Prompt, then the A/R detail will not match the General Ledger.
Also, we have added functionality that allows you to run this report in the background then receive an email with a PDF of the report when it has completed collecting information. This feature saves you time by allowing you to work with other options while the report is being generated.
Select Accounts Receivable|Reports|ATB by Account Aging Table.
ATB by Account Aging Table Prompt
Accept the default system date or key the date by which you want receivables aged.
Accept the default As of Date (Full Date) or key a date to request A/R transactions on as ”as of” date basis.
Accept the default or key a month/year to collect transactions based on an Accounting Month/Year. This field works in conjunction with the As of Date field by including A/R transactions posted through the requested accounting period up to the specified As of Date. Example: If you key 02/2011 in the Accounting Month/Year field and key 03/15/2011 in the As of Date field, A/R transactions are collected for the month of February up to March 15, 2011.
From the Period Selection drop-down list, select From History or Current. Select Current (if you want the receivables to be aged by days) or History (if you want a statement of items billed through a certain past date). These selections work in conjunction with the date fields. If you selected Current and if you want the receivables to be aged by days, key the full date to be reported as current. The system will show receivables that are 30, 60, and more than 60 days old. If you selected History and if you want a statement of items billed through a certain past date, key that full date to be reported. This results in the system ignoring any billing performed after that date.
From the Aging Selection drop-down list, select how you want to age invoices for reporting.
Age on Invoice Date. Ages from the invoice date.
Age on Payment Due Date. Ages from the payment due date.
Age on Periods. Ages on the specified aging periods.
From the Client Type drop-down list select Billing to print client ATBs by the billing client/product. Select A/R to print the client ATBs by the A/R client/product.
As with A/R Client Statements, unapplied cash items will still print under the A/R Client/Product since the cash is not associated with a particular billing client/product.
The Print Credit Limit option is not applicable if you request Print Billing Client/Product.
The term ”billing/client/product” refers to the client and product code established in Client Profile. Clients are billed using this client/product, but can be represented as a different A/R client/product for use within A/R.
If you want the client credit limit to print on the report, select Yes from the Print Credit Limit drop-down list; otherwise, select No.
From the Report Version Selection drop-down list, select to run the report in one of the following orders.
Invoice Date Order Detail (This report shows all invoice detail in invoice date sequence as well as the client credit limit).
Invoice Number Order Detail (This report shows all invoice detail data in invoice number sequence.).
Client/Product Summary (The Net Due column is the total open invoices less unapplied amount. If unapplied is not aged, the percentages are calculated by dividing the column total amounts by total of open invoices. If unapplied is aged, the percentages are calculated by dividing the column by the net amount (total of invoices less Unapplied).
Client Summary (The Net Due column is the total open invoices less unapplied amount. If unapplied is not aged, the percentages are calculated by dividing the column total amounts by total of open invoices. If unapplied is aged, the percentages are calculated by dividing the column by the net amount (total of invoices less unapplied).
From the Data Type Selection drop-down list, indicate which receivables to include on the report.
All receivables. Includes all receivable accounts.
Exclude intercompany. Include all receivable accounts except intercompany accounts.
Intercompany only. Include only intercompany receivables.
From the Client Payer Sorting drop down list, select Code Order to print in client code order or select Sort Field to print in client sort name order.
From the Print Media Totals drop-down list, select Yes to print media totals (receivable amounts total by media type) or select No to exclude media totals (totals by media type do not print).
Key a Client Group code in the optional Enter Client Group field to collect information for only clients that belong to the specified group.
Click in the ”Send to Batch - an Email Will be Sent” box to run this report in the background then receive an email with a PDF of the report when it has completed collecting information. This feature saves you time by allowing you to work with other options while the report is being generated.
To limit the collection of information, click any of the selection buttons and make selections from the displayed lists. Information is collect for only the specified items. 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 to display the ATB Aging Periods Window. This window allows you to request the Trial Balance using different aging periods rather than the ones specified in the Agency Office Profile. You may also use this window to change the headings of the aging periods. If you selected Age on Invoice Date, a Days column displays. If you selected Age on Periods, a Period column displays. Note: If you age of periods, you must remember to click the Reset icon to change the values in the Period Column to Periods.
ATB by Account Aging Periods Window
Accept or change the Aging Period Days.
From the C/P drop-down list, select Current to include this period in the current total that prints after each total level. Select Past Due to include this period in the past due total that prints after each total level.
Accept or change the Heading of the aging periods. If aging is based on invoice due date, column 1 is current and is calculated by subtracting the report run date from the invoice due date to determine if the invoice is current or past due.
Click the Next icon to display the Printing Selections Window.
