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

Matching Invoice Slips to Bank

Hi all, 

 

I load all my bank transactions in via the automated upload function and my accountants do the allocations directly from bank. However, I make the effort to scan all my invoice slips and load them into QB. However, very few of them match. How do I best go about getting this right? Hoping for some advise for someone who has gotten this to work well. DO you first need to work through them and put more data in or are there advanced search methods under expenses where you can match to a range of slips? Its not so intuitive and I cannot find good resources on this although It must be a massively common issue? Help!

1 Comment 1
Jovychris_A
Moderator

Matching Invoice Slips to Bank

Your invoice slips will match your bank transactions when the amounts align, Ewald. If not, you'll need to manually match and account for the differences.

 

Just to clarify, when you say "my invoice slips," are you referring to vendor bills or supplier invoices?

 

Here are factors that can prevent a match and tips to resolve them:

 

  • Mismatch in invoice details. Ensure the invoice in QuickBooks Online (QBO) matches the bank transaction’s number, amount, date, and payee. Review and update the invoice as needed to ensure these details align.
  • Reconciled transactions. If the invoice payment has already been reconciled, it won’t match the downloaded bank transaction. Consider reviewing the payment and adjusting accordingly.
  • Wrong bank account assignment. Check if the invoice payment was recorded in the correct bank account. You can either edit the invoice payment to match the proper account or delete and re-record it.
  • Taxes and fees. Differences in taxes or fees can cause mismatches. Include these details in the invoice total to match the bank transaction. If fees appear separately in the For Review tab:

 

    • Exclude them if the fee is already part of the invoice.
    • Categorize them as an expense if they are not part of the invoice.

 

  • Combining multiple invoices into one bank transaction. If one bank transaction totals several invoices or payments, you can either:

 

    • Use the Pay Bills feature to record payments.
    • Use the Find other matches tool to manually link the transaction to multiple invoices.

 

Once you have matched and categorized transactions, this article can help you determine which transactions you can reconcile, whether on a monthly or quarterly basis: Reconcile an account in QuickBooks Online.

 

Let us know if you need more assistance matching your invoice slips with bank transactions.