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.

Reply to message

View discussion in a popup

Replying to:
Rasa-LilaM
QuickBooks Team

Reply to message

Thanks for following this thread, amv.


I can see how important for you to be able to match the invoice to the deposit. This will help ensure your financial records are correct including the data shown on the report (Profit and Loss).


When deposits are downloaded via bank feeds, match them to the existing transactions in QuickBooks Online (QBO). Adding them will result in doubling your income.


Also, there are instances where some of the entries are unable to find their match from existing records. Let me share the reasons for this occurrence.

 

  • The amounts don't match and dates don't match or are not close.
  • The bank account on the payment is not the same as the bank where the match is located.
  • The payment has been reconciled.
  • The transaction is already matched to something else.
  • There’s a multi-currency issue with the exchange rates.

 

Since the invoice is already paid in QBO, make sure to use the Undeposited Funds as the posting account for your deposit. Let’s go to the Chart of accounts page to edit the information.


Here’s how:

 

  1. In your company, navigate the Accounting menu on the left panel and select Chart of accounts.
  2. Look for the bank you’re working on and tap the View register link to see the entries.
  3. From there, click the deposit to expand the line item.
  4. Then press the Edit button to see the transaction detail.deposit.png
  5. Go to the Deposit to section and pick the Undeposited Funds account from the drop-down.deposit.1.png
  6. Tap the Save and close button and choose Yes to confirm.

 

After performing these steps, go to the Bank Deposit page to record the entry. In case there are bank or processing fees, don’t edit the original transaction. Instead, add the fee in the Bank Deposit window. Here’s an article that will guide you through the step-by-step process: Record and make bank deposits in QuickBooks Online.


Once done, you can match the bank deposit to your downloaded entry. Otherwise, exclude the one in your online banking to prevent duplication.


This reference will help in your future tasks. It outlines the complete steps on how to undo or unmatch transactions downloaded into QuickBooks Online. This way, you can categorize them to the correct account. Also, this link contains topics that will guide you on how to efficiently manage your bank activities.


Keep me posted below if you have other questions about managing invoices and deposits. I’ll get back to assist further. Wishing your business continued success.

Need to get in touch?

Contact us