Skip to main content
April 6, 2024
Question

I'm missing 6 months worth of transactions from my bank in QB online. Does anyone have a recommendation on how to address?

  • April 6, 2024
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

April 6, 2024

I've got the steps to address your six months' worth of missing transactions, yost.

 

QuickBooks Online (QBO) automatically downloads your bank transactions when you link your account. However, the information imported into our system depends on the data your bank shares with us. In case of any missing transactions, you can easily download a CSV file from your bank and manually upload it into our system. Here's how:

 

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions on how to download CSV files of your transactions to your computer. Every financial institution has different steps.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find.

 

Once done, you can manually upload the transaction into QBO. Refer to the steps below:

 

  1. Go to Banking, then select Bank Transactions.
  2. Choose the blue tile for the account you want to upload the transactions into.
  3. Click the Link account dropdown and then Upload from the file.
  4. Select Drag and Drop or select Files, and then choose the file you downloaded from your bank. Then, hit Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then, select Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then, click Continue.
  7. Choose the transactions you would like to import. Tap Continue.
  8. Select Yes. Then, when you've accepted your transactions, hit Done.

 

Check out this link for further information about manually uploading data to QBO: Manually upload your transactions, receipts, and bills into QuickBooks Online.

 

Moreover, I'll add this article to help you review your accounts to ensure they match your bank and credit card statements: Reconciling in QuickBooks Online.

 

Post a comment below if you have follow-up questions about managing missing bank transactions in QBO. I'll be here to assist you. 

April 7, 2024

@yostinvestments 

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110