Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 29, 2025
Question

QBO - Bank transactions not matching to billable expenses.

  • September 29, 2025
  • 1 reply
  • 6 views

Hello, I am having issues with my bank transactions matching my billable expenses.

It is happening with quite a few of them.

For example.  I have a bank transaction dated the 17.9.25 for accommodation I was required to get for a job I went away for.  This was billable to the customer.

 

The actual date I stayed was the 15.9.25 and was $305.47.  I created a billable expense for this and attached it to the invoice.

 

The actual transaction on my bank account came through dated the 17.9.25 and no matter what filters and searches I do, it does not find the billable expense I created.

 

I can not change the date on the billable expense as it needs to match the date of the job.

I have unlinked the expense and tried to match it first but it still doesn't work.

 

Can anyone help me with this issue please?  Thanks in advance.

1 reply

QuickBooks Team
September 29, 2025

The system will suggest transactions to match when they have the same amount and date, JohnJTS. Since your billable expense and bank transaction dates don't align, you can manually match them.

 

You can match the bank transaction with the Invoice instead, as you already attached the Billable expense to it. Before proceeding, review the bank account you selected in the Deposit To field to verify that these records are on the same account. This way, it will appear on the Bank transactions page whether it's open or paid.

 

Alternatively, please know that QuickBooks relies on the data provided by your financial institution. While you can't change the date on the billable expense to reflect the actual date, let's exclude the bank transaction and manually import a new one with the same date (15.9.25).

 

Here's how to do that:

 

  1. Go to the My apps menu, then hover your mouse over Accounting, then Bank transactions.
  2. Locate the bank transaction dated 17.9.25.
  3. Click the transaction to expand, then click Exclude.

 

Afterwards, prepare a CSV file containing an entry with the same date (15.9.25) as the billable expense you've created in QuickBooks. Ensure to use the correct format to avoid errors in QuickBooks. Next, manually upload it to the program.

 

Once done, match the bank transaction with the invoice.

 

It's also worth noting that reconciling an account helps ensure you match your bank statements. If you need assistance, consider seeking guidance from our QuickBooks Live Expert Assisted.

 

Do you need further help managing your entries or expenses? Add the details to your reply so we can address them accordingly.