Open transactions report is a generic term for a report or window designed to show only open (Example: unpaid transactions). These transactions record debits or credits to Accounts Receivable or Accounts Payable. They include:
- Open Invoices Report
- A/R Ageing Summary
- A/R Ageing Detail
- Unpaid Bills Report
- A/P Ageing Summary
- A/P Ageing Detail
- A Transaction Summary or Detail report filtered for Paid Status = Open
- Reminders List
- Customer Snapshot
- The Income Tracker
When accrual transactions such as bills or invoices are paid, they should NOT show on these reports/windows. If they do, it is likely because QuickBooks does not recognise that the transactions are already paid because:
- a bill credit or bill payment is entered but not applied to a bill.
- a credit note or payment is entered but not applied to an invoice.
The following may also cause paid transactions to appear on open transactions report:
- Ageing report preferences are incorrect.
- Terms set for a bill or invoice are incorrect or terms are set up incorrectly in the Terms List.
- The date on your server or on your workstation are set incorrectly.
- The Bill Payment is dated after the date range of the report.
- Either one or both of the transactions or the link between them is damaged.
How to fix it
To resolve the issue, check one of the following:
Unapplied Bill Credits or Bill Payments
- Go to the QuickBooks Reports menu and select Suppliers & Payables then Unpaid Bills.
- Look for negative amounts that indicate unlinked bill credits or bill payments.
- From the Suppliers/Suppliers menu, choose Pay Bills to apply bill Credits and bill payments to bills.
- Be aware that matching transactions, (Ex: a bill and a bill payment), must have the same A/P account.
Unapplied Credit Notes or Customer Payments
- Go to the QuickBooks Reports menu and select Customers & Receivables then Open Invoices.
- Look for negative amounts that are unapplied Payments or Credit Notes.
- Go to the Customers menu and select Receive Payments then apply the payments and credit notes to the appropriate invoices.
- Be aware that matching transactions, (Ex: an invoice and a payment) must have the same A/R account and the same Job under the Customer.
Ageing Report Preferences
-
- Go to the QuickBooks Edit menu and select Preferences.
- Select Reports & Graphs on the left then go to the Company Preferences tab.
- Check your ageing reports preference:
- If Age from due date is selected, a transaction is "current" until the Due Date and then the ageing begins.
- If Age from transaction date is selected, the ageing begins immediately on the transaction date.
Incorrect Terms
- Go to the QuickBooks Lists menu and select Customer & Supplier Profile Lists then Terms List.
- Double-click the terms on the bill or invoice and ensure the terms are set correctly.
Server/Workstation Time/Date
- On the task bar, double-click the Date/Time icon.
- Check that the correct date and year is showing.
- Make any changes if necessary.
- Select Apply then OK.
- Ask your system administrator to check the date on the server.
- Also check that your server and workstation have the same date and time.
The bill payment or invoice payment is dated after the date of the report
- Quick-Zoom the amount in question to open a detail report.
- Quick-Zoom the bill in question to bring it to the screen.
- At the top of the Bill window, click the History button to show all of the linked transactions.
- If the linked payment is dated in the future you have 2 options:
- If the payment is incorrectly dated into the future, change the date back to the current period.
- Change the date range of the report to include the bill payment.
If the issue remains unresolved after checking everything, one or both of the transactions, or the link between them, may be damaged. Try to resolve data damage issues (basic troubleshooting).
Note that data damage of this type is often not fixed by either basic data damage utilities or the Automated Tools. Be sure to attempt the Manual Tools.
