cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
tuksyautocentre
Level 1

How to match one expense receipt with deposit & final payment in bank transactions.

 
3 Comments 3
MirriamM
Moderator

How to match one expense receipt with deposit & final payment in bank transactions.

I am committed to providing you with the assistance you need to effectively match your expense receipt transactions in QuickBooks Online (QBO), tuksyautocentre.

 

To ensure clarity, could you please provide additional details about the expense receipt you mentioned that you wish to associate with a deposit? It's important to note that expenses involve funds leaving your bank account, not deposits. Any further information you can provide would be greatly appreciated.

 

If you're looking to match an expense transaction in QuickBooks Online with a payment in your bank transaction, here’s how you can do it:

 

  1. Go to the Banking page and select the account where the expense is downloaded.
  2. Click the entry to expand it, then choose Find match.
  3. On the Match transactions page, mark the expenses you've entered in QuickBooks.
  4. You can also select Show to open other transactions.
  5. Click Save.

 

Feel free to explore the categorize and match online bank transactions to gain insights on how to review them after downloading.

 

For future reference, you can consult this article to ensure your accounts stay reconciled with your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

Should you have any further questions about your expense-related transactions, please let us know. I'm just a few clicks away

tuksyautocentre
Level 1

How to match one expense receipt with deposit & final payment in bank transactions.

Hi, its a transaction of £12,888 in my expenses. But on my bank there are two transactions as I couldn’t make a payment of whole amount 1 go. Now when I go to bank transaction and manual search to match it with expense invoice it doesn’t show me transaction of £12888. 

Jayson_E
QuickBooks Team

How to match one expense receipt with deposit & final payment in bank transactions.

As you navigate QuickBooks Online (QBO), it’s essential to grasp how transaction matching works, tuksyautocentre. Here’s what you need to know about matching downloaded bank transactions with your existing records.

 

In QBO, it's important to note that you are unable to match multiple downloaded bank transactions to a single existing transaction, such as your expense invoice. Instead, the system allows you to match one downloaded transaction to one or multiple existing transactions.

 

However, you can still exclude the two downloaded bank transactions.

 

After that, you can manually mark the existing transaction as cleared in your Chart of Accounts (COA). Here’s how to do it:

 

  1. Go to the Transactions menu.
  2. Navigate to the Chart of Accounts and search for the specific bank associated with the transaction.
  3. Click on View register.
    image (25).png
  4. Search for the specific transaction in the bank register.
  5. Click on the transaction, and under the ✓ column, click until it changes to C (which indicates cleared).
  6. Finally, click Save.

image (26).png

 

This process will help ensure that your financial records remain accurate and avoid potential duplication.

 

For more details about matching transactions in QBO, I recommend checking out this article: Match online bank transactions in QuickBooks Online.

 

You can also reconcile an account to ensure that your financial records in QBO match your bank and credit card statements.

 

Your questions are always welcome! Don’t hesitate to ask if you need more information on your expense transactions.