cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online

Reply to Message

View discussion in a popup

Replying to:
Rasa-LilaM
QuickBooks Team

Reply to Message

Keeping track of transactions clearly and accurately is essential for organizing your financial records, peterbooth. This helps make the matching process and account reconciliation easier. Let me guide you in the right direction on how to resolve your concern.

 

First off, can you clarify which transaction type you’re trying to match to the bank entry? Have you encountered any error messages along the way? Any extra details will help ensure I can give you the best solution for your issue.

 

QuickBooks Online (QBO) reviews your bank data to find matches, rules, and recognized transactions. While you go through the data, you can compare the online banking transactions with the ones already in your company.

 

Furthermore, some entries might not be able to locate a match within the existing records due to various factors:

 

  • The amounts or dates don’t match.
  • The transaction is older than 6 months.
  • The bank account on the payment isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The record is already matched to another transaction. 
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

If you received less than the invoice amount due to bank fees, enter the fee as a negative amount on the Bank Deposits. This ensures your register matches the bank statement.

 

Here's how:

 

  1. In your company, head to the + New menu in the upper left and pick Receive payment.
  2. Enter all the payment information and tick the box next to the invoice you'd like the payment to be applied to.
  3. Choose Undeposited funds from Deposit to ▼ dropdown and click the Save and close button to keep the entry.

To add the fee:

  1. Navigate to the + New menu in the upper left and select Bank deposit.
  2. You'll be able to see the payment entered in the Select the payments included in this deposit section at the top.
  3. Put a check to select the payment you want to deposit.
  4. From the Add funds to this deposit section, enter the amount of the bank service fee as a negative amount.
  5. From the Account section, select the Expense account used to track your bank fees.
  6. Verify that the deposit amount is correct.
  7. Click the Save and close button once done.

After performing these steps, tick the Match function to open the Find other matches screen (look for other possible entries). If the amount doesn't match, you can resolve the difference between the invoice and the payment by performing these steps:

 

  1. Navigate to Transactions menu on the left panel and choose Bank transactions.
  2. Pick the account you're working on.
  3. In the For review tab, select the entry and tick the Match radio button to open the Find other matches screen.
  4. From there, check the box next to the correct invoice.
  5. Select the Resolve option to display the Add resolving transactions section.
  6. From the Category drop-down, select the bank fees expense account and input a negative figure in the Amount column.
  7. Click the Match button.

For future reference, explore this article for guidance in balancing your bank and credit card accounts: Reconcile an account in QuickBooks Online.

 

Feel free to comment below if you need more guidance on a specific accounting task in QBO or have any banking questions. I’m here to provide the support you need.

Need to get in touch?

Contact us