cancel
Showing results for 
Search instead for 
Did you mean: 
excelerategrowth
Level 1

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

I'm not following the feed here and confused how I should do this in my situation. 

We had an invoice for $129.65. When the check/payment came in, a sales receipt was created, and then later deposited along with other checks later. 

We realized today that the $129.65 was deposited without being linked to the invoice. 
What are the exact steps to link a portion of that deposit ($129.65 of $467.65) to it's appropriate invoice? 

Thank you for the specific process. 

 

Jason

MirriamM
Moderator

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

Thanks for joining us in this thread, @excelerategrowth.

 

Let me get the help you need in recording your transactions.

 

For you to link your deposit to the appropriate invoice, you'll need first to delete the sales receipt created. To do this, here's how:

  1. In the left menu, click Sales.
  2. Go to the All Sales tab.
  3. Click the Filter drop-down.
  4. From the Type drop-down menu, select Sales Receipt.
  5. Choose Apply.
  6. Locate the sales receipts that you want to delete.
  7. From the Actions column, click the drop-down.
  8. Click on Delete.
  9. Press on Yes to confirm.

 

Once done, let's locate the deposit and link it to the invoice.

  1. In the left menu, click Accounting.
  2. Locate the bank account where the payment was direct deposited, then click View register.
  3. Locate the deposit and click it.
  4. Click Edit.
  5. From the Received From column, choose the customer.
  6. Select Accounts Receivable from the Account column.
  7. Click Save and close.
  8. In the left menu, click the + New button and choose Receive Payment.
  9. Choose the customer and place a check next to the invoice and deposit.
  10. Click Save and close.

 

That's it! You're now able to link the deposit to the appropriate invoice, @excelerategrowth

 

For future help, here's a resource that can guide you to navigate and perform any tasks in QuickBooks Online:

 

Please let me know if I can be of further assistance. I’m always ready to help you. Have a good one.

WIP2013
Level 1

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

I have about fifteen invoices that are incorrect. There is an entry as accounts receivable and an entry for deposit. Will this work for all of them. I need to get rid of the duplicate deposits.

Thanks so much.

WIP2013
Level 1

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

Do I go into the Accounts Receivable Register? I already marked each invoice Received Payment in the Sales/Invoices section. Is that correct? Obviously, it isn't because the payment wasn't applied to the invoice.

 

DivinaMercy_N
Moderator

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

Hi there, @WIP2013. I'm here to provide info about the steps provided for linking a deposit to an invoice in QuickBooks Online (QBO).

 

If those deposits are the actual payment for the invoice, you can follow the steps given by my colleague above to link them. Please browse through this article to know some things you need to check before proceeding: Link a bank deposit to an invoice in QuickBooks Online. 

 

I also noticed that you posted the same concern here in the Community that my colleague answered. If you haven't notified yet, you can refer to this link for the details: https://quickbooks.intuit.com/learn-support/en-us/other-questions/invoices-accounts-receivable/01/11....

 

For reference in handling your customer's transactions in QBO, feel free to check this page: Record invoice payments in QuickBooks Online. 

 

Don't hesitate to leave a reply below if you have any other concerns about recording invoice payments and deposits in QBO. I'm always here ready to lend a hand. 

StacyLabrada
Level 1

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

So im new in my current role  and know some about QBO and i am experiencing the same issue. My invoices that are open  are from 2022. Will this effect the already completed reconciliations for this year? . i am trying to clean up a huge mess from someone that wasnt sure how to properly receive. Im nervous to adjust. 

Adrian_A
Moderator

Payment received, deposited to bank account but not applied to invoice - how to correct afterwards?

Hi, Stacy.

 

Yes, it will affect your reconciled account. I'm here to discuss more about it.

 

Changing the reconciled account can cause discrepancies in your previous and next reconciliation balances. We can un-reconcile the account and link the 2022 invoices to their payments. You can only un-reconcile one transaction at a time. If you need to start over, I'd suggest contacting your accountant. They can undo the entire period at once using QuickBooks Online Accountant.

 

If you prefer to do it by yourself, follow these instructions to undo reconciled transactions one at a time:

 

  1. Go to the Accounting menu. Then select Chart of Accounts.
  2. Find the account and select View register
  3. To help you focus on this task, filter the register to only include the last 60 days of transactions.
  4. Review the check column. If the transaction is reconciled, you'll see an "R."
  5. Select the box and keep clicking it until it's blank. It removes the transaction from the reconciliation.

 

From there, you can reconcile the account again. Here's an article for the detailed steps: Reconcile account.

 

If you encounter issues reconciling accounts in the future, this article will help you fix it: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Feel free to get back to this thread if there's anything that I can help in reconciling the transactions. I'll be around to help you some more.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us