Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowBackground 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.
If the issue is just that the transactions show as open, you can apply them by doing either one of the following:
The second option may be time-consuming if you have many of those.
Let me know if this helps.
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here