Accounts Receivable > Printing Reports > About Accounts Receivable Reports

About Accounts Receivable Reports

You can print a wide variety of reports that provide you with up-to-date information and a source of backup information for your Accounts Receivable system.

This article briefly describes the reports you can print in Accounts Receivable.

Customer Reports

You can print lists and statistical reports for customers, customer groups, and national accounts.

Use screens on the A/R Customer Reports menu to print these reports.

Transaction Reports

Accounts Receivable produces a complete range of reports of the transactions you enter and post. These reports include batch listings, posting journals, error reports, batch status reports, invoices, deposit slips, and the G/L Transactions report.

All of these reports are important parts of your audit trail of Accounts Receivable transactions. You should regularly print these reports, check them carefully, and file them in a secure place.

If you use Accounts Receivable to print invoices, credit notes, debit notes, and deposit slips, you should also establish procedures for ensuring that you print and check each one, and keep copies in your files.

Accounts Receivable also provides three important analytical reports that you can use to interpret, analyze, and summarize your data, including the Aged Trial Balance, Customer Transactions, and Item Sales History reports.

To print the reports, use screens on the A/R Transaction Reports menu.

Aged Trial Balance

Use the Aged Trial Balance report to review and analyze outstanding receivables. You normally print this report at period end, before you charge interest, write off amounts, print statements, or clear paid transactions. You also print the report at other times when you need precise information about your outstanding and overdue receivables.

You can print the report with full transaction details or limit it to customer account balances. It can show you the amounts that were outstanding or overdue on past dates, as well as amounts that will be outstanding or overdue on future dates.

The Aged Trial Balance report groups transactions and balances by their document dates or due dates into the aging categories you specify. You can also choose to include zero balances, paid transactions, and applied details, and you can limit the report to customers whose accounts are over their credit limits.

If you use multicurrency accounting, you can also print the report in functional currency or in the customers’ currencies.

Customer Transactions

The Customer Transactions report serves as an audit trail of posted transactions in your customer accounts, within the range of dates you specify. Use the report to obtain an overview of your customer accounts in any period for which you have Accounts Receivable data.

You can report the details of any combination of invoices, debit notes, credit notes, interest, unapplied cash, and prepayments. You can also choose to include zero balances and applied details, and print a total for each transaction type.

You can optionally include extra information (customer contact, phone number, and credit limit), and three or four blank lines for writing comments or notes.

If you use multicurrency accounting, you can also print the report in functional currency or in customers’ currencies.

Item Sales History

The Item Sales History report tracks item sales, returns, costs, and profit margins in any of the periods for which you keep item statistics. Use the report to identify successful items, items with a high rate of return, and items that do not sell well.

The report also lists the actual cost and gross margin (total sales amount minus actual costs) for each item, as well as the percentage of the sales total that is the gross profit.

You print this report only if you added items to your Accounts Receivable data and you use the Keep Statistics option on the A/R Options screen.