Reporting

I am running an Aged Receivables report and the amounts in the aging columns are not correct. For example, there are no invoices showing up for the current period or in the periods following the current period; all of the invoices show as over 90 days past due. Yet, I know that some of them were issued this month and should show as current. What can I do?

Go to the Options tab on this report. The most common cause of this issue is an incorrect "aging date" for the report. Make sure that the aging date selected is the date that you want the report to use. Also, on the Options tab, note that this report will age invoices by "invoice date" or the invoices' "due date." Make sure that the setting you have chosen is the one that you want.

If this does not resolve your issue, use the steps detailed in the last question of the Adjusting A/R Invoices and Credits topic. It explains the steps to take to determine the source of the incorrect figures by running the Detailed A/R Ledger report.

I run an A/R report and the report's balance does not match my G/L balance for my A/R account. What is wrong?

First, make sure you are running a Summary or Detailed Accounts Receivable Ledger, instead of an Aged Receivables Ledger. The Aged Receivables Ledger seldom matches the Accounts Receivable G/L balance because of timing issues related to due date, invoice date, and effective date being different.

Next, verify that the report setups match, such as they report on the same period of time and ask for the same information.

Additionally, data integrity checks may be run to verify that the A/R subledger ties to the General Ledger (Organization>Data Integrity Checks).