Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
ASD-NY
Level 2

Accounts Receivable - Open Invoices related to Journal Entries associated with a customer name

Background Info. - the previous Controller used JE's when recording Accrued Revenue and ACH Payment receipts against a Customer Account. Also, some the ACH Payment receipts were recorded as Sales Receipts. Now when I run an Open Invoice Report, all the entries show up, with none of the payments being applied to the Open Invoices. And while the A/R balance is correct on the Balance Sheet, but I cannot find a workaround to close out the open invoices, short of undoing all everything, including the already reconciled Bank Statements. Plus, with the payments already being reconciled with the Bank Statements, simply undoing will cause the opening balance of the next Bank Reconciliation to be incorrect. Is there an easier way to correct the Open Invoices and apply the payments to the Journal Entries/Sales Receipts?

 

Any and all input is greatly appreciated.

2 Comments 2
OnTrack Team
Level 4

Accounts Receivable - Open Invoices related to Journal Entries associated with a customer name

@ASD-NY,

 

If the issue is just that the transactions show as open, you can apply them by doing either one of the following:

 

  1. Use the 'Fix Unapplied Customer Payments' feature in the Accountant version.
  2. Open a payment (either existing or new) from that customer, select the open invoices (and other transactions) one at a time, click 'Discounts And Credits' and apply all credits available. Continue with all open transactions down the list within this payment and this will clear all unapplied amounts of this customer. Do the same on all customers with unapplied balances.

 

The second option may be time-consuming if you have many of those.

 

Let me know if this helps.

AileneA
Moderator

Accounts Receivable - Open Invoices related to Journal Entries associated with a customer name

aHello, ASD-NY. 

 

Thank you for the detailed information you've shared with us. Let me explain why your invoice still shows up as an open invoice when you run the report, even though the Payment is recorded. 

 

In QuickBooks Desktop, payments recorded as journal entries may not be identified as payments within the software. Journal entries are typically used for general accounting purposes and may have a different level of integration with other features.   

 

To ensure accurate tracking of payments and invoices, it is generally recommended to use the "Receive Payments" feature in QuickBooks Desktop. This feature allows you to apply payments directly to open invoices, providing a clear record of the Payment and its association with specific invoices with the journal entry payment. This should help close your open invoice. 

 

To receive Payment, here's how: 

 

  1. Go to the Customers menu and select Receive Payment.
  2. In the Received From drop-down, choose the customer's name.
  3. Enter the Amount received.
  4. Make sure the date is correct, then select the Payment method.
  5. Hit the invoice or invoices you'd like to pay.
  6. Click Save & Close.

 

I highly recommend checking out our Customer Transaction Workflow Guide. It's a helpful resource that can guide you through tracking your sales and receivables in QuickBooks Desktop. 

 

If you're up to reconciling your books, I highly recommend checking out this article if you need a guide: Reconcile an account in QuickBooks Desktop.

 

If you have any further questions or concerns, please don't hesitate to let me know. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us