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

How can I import bank statements from November 2019 to January 2021?

I have the bank statements from before then that have been reconciled, and from this year (none of which have been reconciled), but I’m missing over a year’s worth of bank statements. And I can’t reconcile the 2021 statements because it’s still showing the previous balance from 11/2019. How do I import all the missing bank statements?
2 Comments 2
Fiat Lux - ASIA
Level 15

How can I import bank statements from November 2019 to January 2021?

Is the bank statement file in .qbo, .csv, or another format?

Jovychris_A
Moderator

How can I import bank statements from November 2019 to January 2021?

Thanks for posting into the Community, @BritoPlumbingandMechanical. I can help you import the bank transactions that went missing.

 

Usually, QuickBooks Online (QBO) automatically downloads transactions up to a specific date. If you want to enter older transactions, you can still upload them manually.

 

To avoid entering duplicates, you need to know the date of the oldest existing transaction you can find in the bank account register.

 

Here's how:

  1. Go to the Accounting menu and then select Chart of accounts.
  2. Find the bank account in question where you wanted to upload the transactions.
  3. Select View register.
  4. Find and take note of the date of the oldest transaction.

 

Once you get the oldest transaction, it's time to get entries from your bank dated November 2019 to January 2021.

 

  1. Sign in to your bank's website.
  2. Follow the instructions for how to download CSV files from your bank to your computer.
  3. Check the date range (it should be dated November 2019 to January 2021).
  4. Once done, download them to some somewhere you can easily find, like your PC's desktop.

 

Then you can follow Step 3: Review the file format and size and the rest of the details through this article: Manually upload transactions into QuickBooks Online. Also, make sure that you mapped out each column accordingly when importing the transactions. This may be in a different region, but here are additional insight about importing prior transactions from a bank that I've shared with one of our Community members: Upload CSV file bank transactions.

 

Once you've successfully imported banking entries, you're now ready to categorize and reconcile your bank.

 

Is it your first time connecting your online bank accounts? Here's what you can do if you can't find downloaded transactions in QuickBooks Online.

 

If you have additional questions in mind about importing bank transactions to QBO, feel free to post them below. Anytime I can help you here. Stay safe, and have a nice day ahead!

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

Need to get in touch?

Contact us