cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
alexanderupshon-
Level 1

Bank reconciliation - transactions on the bank statement - sales and expenses not on QB transactions list - added manually. expenses not showing on reconcilation help?

the bank - QB link expired and now trying to do an OCt 23 bank recon, but transactions not showing so added manually - sales on QB bank recon but not expenses. what can i do?
1 REPLY 1
JaeAnnC
QuickBooks Team

Bank reconciliation - transactions on the bank statement - sales and expenses not on QB transactions list - added manually. expenses not showing on reconcilation help?

Hello there, Alexander. Allow me to share some troubleshooting options to resolve your missing expenses when reconciling in QuickBooks Online (QBO).

 

If you've manually uploaded the bank transactions using a CSV file, it's possible that the expenses are sitting on the For Review tab. Let's go ahead and check so you can categorise them to their appropriate expense accounts. 

 

  1. Go to Transactions and click Bank Transactions.
  2. Select the bank account and go to the For Review tab.
  3. Review the transactions and categorise them.

 

Additionally, review the format of your CSV file. Make sure to use either a 3-column or 4-column format. Then, recheck the mapping of the statement fields when uploading them into QBO. I'll attach a screenshot below for your visual.

image (2).png

If you've manually entered them into the bank register, it's most likely that the transactions are marked as reconciled. Then, review the accounts associated with each entry and make edits if necessary. Here's how:

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Locate the bank account and click View Register.
  3. Find the transaction. If it has a letter under the check () column, it means reconciled. You can unreconcile it by clicking the letter until the box becomes blank. 
  4. Review the account under the Account column and click Edit to make changes.
  5. Click Save.

 

Furthermore, I'm adding these articles in case you encounter issues when reconciling in QBO: 

 

 

Keep in touch if you have further concerns about reconciliation. I'll be happy to provide assistance whenever you need it. Take care.

Need to get in touch?

Contact us