Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
yostinvestments
Level 1

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

 
2 Comments 2
CamelleT
Moderator

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

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. 

4Gal
Level 11

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

@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

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us