Our fiscal year ended March 31 at which time I printed an Overdue Receivables report. In April we made a few AR entries and dated them back to March 31 so they would go into last fiscal year. I am not able to find a way to produce an Overdue Receivables report as of March 31 that includes the March entries that we're added in April while excluding April entries that were intended for April. I need this report to show my accountant that the balance on the Overdue Receivables as of March 31 matches the AR balance in Ledger.

Can this be done? I have the same issue with AP Open Payables.

Please let me know.

Thank-you

P.S. I'm at the Toronto Airport waiting for my flight to Vancouver for AOC. Hopefully I'll get the chance to find out the answer to this among many other things while I'm there!

Susan:

The only AR report that is intended to be reconcilable to Ledger is the Aged Trial Balance report. Make sure you select the calculate as of option.

The equivalent report in AP is the Open Payables report.