Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 2, 2019
Question

Open Invoice Reports

  • January 2, 2019
  • 2 replies
  • 0 views

When I run the Open Invoice Report  as of 12/31/2018 it does not include the invoices that were received on January 2, 2019.   I need these numbers to be correct for the accountants.  Any suggestions to make the report show all open invoices as of 12/31/2018 even if they were received in 2019? 

2 replies

qbteachmt
Level 11
January 2, 2019

"Received" date has nothing to do with anything financial. Transaction Dates control what reports; and then Cash or Accrual Basis.

 

Invoices = AR.

Bills = AP.

 

Look at the Date you entered on the transaction, and consider Basis. Open AP and AR don't typically show for Cash Basis reporting. That's the point.

January 2, 2019

You can see the open invoices as they were on a prior date.

 

To do this, start on the default Open Invoices report, click Customize Report, and then on the Display tab click Advanced, and then "Report Date" under Open Balance / Aging.

 

Then on the report enter the desired date and QB will recalculate the open balances to exclude activity after that date.

January 3, 2019

This worked - Thanks