Skip to main content
M
MF26
October 11, 2023
Question

Transactions different on bank statement

  • October 11, 2023
  • 1 reply
  • 0 views

I'm fairly new to QBO, so this might be a dumb-ish question. I'm reconciling a bank account -- which we do have connected to our QBO -- and there are checks and deposits on the bank statement that aren't listed for that month in QBO. Thus, the balance is off by a couple thousand dollars. What's typically the best way to handle this?

1 reply

J
jeanbiverly_
October 11, 2023

Welcome to the Community, @MF26! I can help you in entering your missing bank transactions into QuickBooks Online.

 

Once the file is ready, here's how to upload it into the program:

 

  1. Go to Bookkeeping and then click Transactions.
  2. On the Bank Transactions page, choose the account you want to upload.
  3. Click the Link account ▼ dropdown and then select Upload from file.
  4. Choose Drag and drop or select files, pick the file you downloaded from your bank, and then hit Continue.
  5. Under the QuickBooks account ▼ dropdown, select the account to which you want to upload the transactions, and then click Continue.
  6. Follow the on-screen steps to match file columns with QuickBooks fields.
  7. Check the boxes of the transactions you'd like to import. Then select Continue.
  8. Click Yes.
  9. After accepting your transactions, hit Done.

 

However, if they are missing data from the current period or month, let's update your connection to obtain your available transactions. Alternatively, we can manually enter them to your bank register.

 

After completing your transactions, refer to these articles to reconcile your bank account:

 

 

Please feel free to reach out if you have other concerns about missing bank transactions. I'm always here to help. Have a great day!

M
MF26Author
October 11, 2023

Thanks for the info. So even if our bank account is syncing with Quickbooks, we need to do this any time there are missing transactions? Wouldn't this cause double posting for the transactions that did sync? Thanks again.

D
DebSheenD
October 12, 2023

Thanks for getting back to us, @MF26.

 

Let me chime in and share additional information about entering missing bank transactions in QBO.

 

With regard to your question, it's not necessary that you'll need to manually upload CSV transactions to QuickBooks every time there are missing transactions. You can manually enter it in QBO and match it.

 

Manually uploading transactions can potentially cause double posting if the transactions that were already synced through automatic syncing are uploaded again. To avoid this, we can review the transactions that were manually uploaded and ensure that they haven't already been recorded in QuickBooks.

 

Additionally, I've added this article to manage bank transactions in QBO: Categorize and match online bank transactions in QuickBooks Online. 

 

I encourage you to reconcile your accounts in QBO regularly. This helps monitor your income and expense transactions and detect possible errors accordingly. You can also check out this article to guide you in reconciliations in QBO: Learn the reconciliation workflow in QuickBooks.

 

Know that I'm here whenever you need more help handling these transactions. I'll do my best to help you. Stay safe.

    Terms & ConditionsAccessibility statement