cancel
Showing results for 
Search instead for 
Did you mean: 
usercustomerservice
Level 1

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

 
Solved
Best answer March 26, 2024

Best Answers
GlinetteC
Moderator

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

Yes, there is. 

 

I have all the information to import those missing transactions into QuickBooks Online.

 

You can bring those missing data by downloading them in a CSV file format and then performing a manual upload to ensure they appear in your bank register. I can walk you through the step-by-step guide.

 

  1. Log in to your bank or credit card's website.
  2. Follow the instructions provided by your bank to download CSV files containing your transaction history to your computer. Every financial institution has different steps. Here are steps for Bank of AmericaChase, and Wells Fargo.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download the transactions and save the file in a location that is easily accessible, such as your computer's desktop.

 

Then, upload the transactions to QBO:

 

  1. Navigate to the Transactions tab and click on Bank transactions
  2. Locate and click on the blue tile representing the account where you want to upload the transactions.
  3. Click the Link account ▼ dropdown and then Upload from file.
  4. Choose either the Drag and drop option or select files to locate and select the file you downloaded from your bank. Then, click on Continue.
  5. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
  6. Follow the onscreen instructions to match the columns from the file with the appropriate fields in QuickBooks. Then, click on Continue.
  7. Select the transactions you want to import, and click on Continue.
  8. Confirm by selecting Yes, then click on Done to complete the process.

 

After obtaining your banking data, take the necessary step of categorizing the transactions accurately to maintain proper accounting practices.

 

Additionally, it is crucial to reconcile the account to ensure the integrity of your financial records.

 

Let me know if you have further questions about handling missing transactions and other related issues. I'll be here to assist.

View solution in original post

7 Comments 7
GlinetteC
Moderator

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

Yes, there is. 

 

I have all the information to import those missing transactions into QuickBooks Online.

 

You can bring those missing data by downloading them in a CSV file format and then performing a manual upload to ensure they appear in your bank register. I can walk you through the step-by-step guide.

 

  1. Log in to your bank or credit card's website.
  2. Follow the instructions provided by your bank to download CSV files containing your transaction history to your computer. Every financial institution has different steps. Here are steps for Bank of AmericaChase, and Wells Fargo.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download the transactions and save the file in a location that is easily accessible, such as your computer's desktop.

 

Then, upload the transactions to QBO:

 

  1. Navigate to the Transactions tab and click on Bank transactions
  2. Locate and click on the blue tile representing the account where you want to upload the transactions.
  3. Click the Link account ▼ dropdown and then Upload from file.
  4. Choose either the Drag and drop option or select files to locate and select the file you downloaded from your bank. Then, click on Continue.
  5. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
  6. Follow the onscreen instructions to match the columns from the file with the appropriate fields in QuickBooks. Then, click on Continue.
  7. Select the transactions you want to import, and click on Continue.
  8. Confirm by selecting Yes, then click on Done to complete the process.

 

After obtaining your banking data, take the necessary step of categorizing the transactions accurately to maintain proper accounting practices.

 

Additionally, it is crucial to reconcile the account to ensure the integrity of your financial records.

 

Let me know if you have further questions about handling missing transactions and other related issues. I'll be here to assist.

4Gal
Level 11

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

@usercustomerservice 

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

 

usercustomerservice
Level 1

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

Thank you so much.  This solution worked perfectly.

usercustomerservice
Level 1

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

This solution worked perfectly.  I am good to go now.  Thanks!

Eman_E
QuickBooks Team

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

Hi there,

 

I am glad to hear that the information provided by my colleague @GlinetteC was able to address your concern. Our primary goal is to provide you with the necessary assistance whenever you need it.

 

Please do not hesitate to contact us if you require any further assistance or have any concerns related to QuickBooks. We are always here to offer you the required support and help.

MN2021CA
Level 1

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

I'm encountering a similar issue. Transactions from one of my accounts are missing between mid-June and mid-October, while for the other account, transactions are absent after mid-June until January. Unfortunately, my bank account doesn't offer the option to export CSV files for transactions older than 60 days. This situation is incredibly frustrating!

Kurt_M
QuickBooks Team

Hi, I just checked my bank transactions and everything is missing from 7/23 - 12/23. I had to reconnect my bank. Is there anyway to get those months imported?

Hello there, @MN2021CA.

 

It looks like you already posted the same query, and one of our colleagues was able to respond to it. We'll route you to her recommendation to get you going. Feel free to see this link: https://quickbooks.intuit.com/learn-support/en-us/banking/re-why-are-transactions-missi[…]g-from-my-...

 

The Community space is open 24/7 if you have follow-up questions about bank transactions inside QuickBooks. Don't hesitate to comment below so we can respond as soon as possible. Stay safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us