Skip to main content
S
ss_2019
October 16, 2023
Question

Quickbooks Not Matching Bank Transactions

  • October 16, 2023
  • 1 reply
  • 0 views

I have four transactions as below showing in my Quickbooks online as "Spent" however when I go to look for them in my bank statements there are no debt/withdrawal entries that match.  

 

9/11 - $7.00

9/11 - $33.00

9/11 - $3.00

9/11 - $10.00

 

To resolve the imbalance of $53 dollars between the two systems I excluded them from Quickbooks. 

 

The question is why are those showing in Quickbooks as entries being spent when there is no such entries at the bank level?

 

Thank you in advance. 

1 reply

Candice C
Candice C
October 16, 2023

Hey there, @ss_2019. 

 

It's great to see you back in the Community! 

 

The reason why you may not have been able to match the banking transactions are due to the amount, date, and other details not being the same as the other transaction. Review this guide for additional details: Match online bank transactions. 

 

If this isn't the case, please provide us with some more information and screenshots of the problem. 

 

I'll be waiting for your response! 

S
ss_2019Author
October 16, 2023

Hello,

 

I looked over the link that you sent however I still cannot locate the problem. I have attached a screenshot of what I am seeing in QB. I went back three months of bank transactions in Wells Fargo and there are no withdrawals or debits related to what Quickbooks says it spent. All transactions match except for the attached ones. 

 

For now the account balances because I have excluded them but I would still like to understand why these four showed up in the first place. 

 

Thank you

R
rvrfrf
October 16, 2023

Thanks for getting back with the Community, ss_2019.

 

The transaction records shown on your Bank transactions screen come directly from the financial institution you have connected with QuickBooks. If you're curious why some are showing up that aren't displayed on your account's statement, I'd recommend getting in touch with their support team to discuss the situation.

 

If you'd like to try manually importing transactions from your bank, you can check to see if the unrecognized transactions show up there as well. First you'll need to exclude everything that was already imported through online banking, this is done to avoid duplicates.

 

After you've excluded everything necessary, you can pick a start date to avoid entering duplicates during the manual upload.

 

Here's how:
 

  1. Use your Gear icon, then go to Chart of accounts.
  2. Find the account you want to upload transactions into.
  3. Select View register.
  4. Find and write down your date for the accounts oldest transaction. Usually, your oldest transaction will be the opening balance.

 

Next, you'll need to get transactions from your bank:
 

  1. Go to their website and sign it to the account.
  2. Follow your financial institution's instructions for downloading CSV files of transactions.
  3. Check the date range for your download. It should be at least one day before the date of your oldest transaction.
  4. Download the file and save it somewhere you can easily find it, like your computer's desktop.

 

After downloading the transactions, you'll want to review the file's format and size (maximum size is 350 KB). If a file's size is too large, you can try shortening your date range and downloading transactions in smaller batches. Afterwards, you can upload them into QuickBooks.

 

Please don't hesitate to send a reply if there's any additional questions. Have an awesome Monday!

Terms & ConditionsAccessibility statement