News & Special Offers

QuickBooks Sale!

Dell All-in-One w/touchscreen

Dell Inspiron One All-In-One Computer / AMD Athlon II X2 Processor

How to Fix Invoice Payments in QuickBooks

I am using QuickBooks Premier Accountant 2009. A secondary business is running QuickBooks 2008. In both cases, payments received and deposited continue to show an open balance in the "Payment Received" window. This is true for EVERY payment received, not a select few…dates are not the problem. Any ideas? (Invoices are all marked as PAID and customers have Balance Total is '0' in the customer center).
It sounds like your payments have been unconnected from their invoices. Try going to Reports > Customers & Receivables > Open Invoices. If you see any payments listed on this report (they’ll show up as a negative under the invoice), open the invoice and click on the Apply Credits button.

If you don’t see any payments on this list, but you do see invoices that you know have been paid, it’s likely that they were deposited into the bank without going through Receive Payments first. You’ll need to find the deposits and change the account to Accounts Receivable and enter the Customer name.  Once you do this, they’ll show up on the Open Invoices report and you can apply the credits as explained above.

It’s always best to use QuickBooks the way it’s designed. If you enter invoices, you should always use Receive Payment.  Never go directly to Make Deposit or enter the deposit directly into the register. If you don’t enter invoices, you should use Enter Sales Receipts so you can batch the payments using undeposited funds (see below).  

It’s also a good idea to deposit your payments into undeposited funds, and then enter the deposit on the day you’re actually going to the bank.  When you select Make Deposits, a popup box will list all the payments you’ve received into undeposited funds that haven’t been deposited yet.  Simply select the payments that you are depositing that day, and Quickbooks will batch them all in one deposit that will match your bank statement. 


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.

Buying QuickBooks for a client? Call us at 800-707-0940 to discuss what we can do to help!

QuickBooks price list | QuickBooks for sale | Free trial QuickBooks POS | Free trial QuickBooks Enterprise

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>