Skip to main content

Match expenses with bank feed in QuickBooks Online

How to merge expenses exported from Expense Management to bank feed in QuickBooks Online.

Updated over a week ago

When exporting expenses from Expense Management to QuickBooks Online and matching them with transactions from your bank feed, it's important to understand that Expense Management’s exported expenses are different from the transactions listed in QBO. Expense Management exports expenses as separate expense records, while QuickBooks Online’s bank feed contains transactions that require categorization or matching with existing expenses. This helps prevent duplicates in your records.

QuickBooks often automatically recognizes matching transactions and indicates them as record found in the bank feed view. However, slight discrepancies in dates or amounts could prevent this from appearing. In cases where the record found is absent, QBO users can manually match expenses by using find match. This isn’t controlled by Expense Management; it’s a QuickBooks Online functionality.

Matching credit card expenses exported from Expense Management to QuickBooks Online with credit card transactions from the bank feed is an essential part of keeping financial records accurate and up to date. Here's a step-by-step guide:

  1. Sign in to your QuickBooks Online account and open the Banking section.

  2. Select the required Credit card for which you would like to reconcile the expenses.

  3. You will be able to see transactions that need to be matched under For review.

  4. Select a transaction to open it.

  5. QuickBooks Online will suggest potential matches from your existing transactions with a Record found indicator.

  6. If you see a suggested match that corresponds to a recorded expense, select Confirm or Match to match the transaction.

  7. QuickBooks Online will link the bank transaction to the expense and move it to the Categorized column.

  8. If there is no match found or the wrong expense is found, select Find match then Find other matches.

  9. Add any filters if necessary to identify the required expense and select the corresponding expense. Select Save.

If you have any more questions, reach out to our support team at support@capitalone-fylehq.com.

Did this answer your question?