Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Hello there, @j45780.
It's great that you connected your bank account to QuickBooks Online (QBO). Although some financial institutions have limitations on the transactions that can be downloaded, I've got you covered. I'd be happy to help.
While some banks offer transactions up to 90 days old, others may only allow 30 days. With this, you can manually upload your transactions into QBO.
Before we start, ensure you know the date of the oldest existing transactions of your current account to avoid duplicates. Here's how:
- Go to the Settings menu, then select Chart of accounts.
- Choose the account you want to upload the transactions to and click View register.
- Find and write down the date of the oldest transaction. The oldest transaction is usually the opening balance.
Once you have the CSV files of your transactions from your bank and have reviewed the file format and size, I'll show you how to upload them:
- Go to the Transactions menu and choose Bank Transactions.
- Select the account you want to upload the transactions.
- Drag and drop or select files and choose the file you downloaded from your bank. Then, click Continue.
- In the QuickBooks account▼ dropdown, select the account. Then, select Continue.
- Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then tap Continue.
- Choose the transactions and click Continue.
- Click Yes and Done.
If you encountered errors while doing the process, here’s how you can fix errors when you upload transactions.
Uploading transactions can take some time, but well worth the effort to make sure your books are accurate. If you'd like a second set of eyes, you might also want to look into QuickBooks Live Expert Assisted. Our team of experts is available to guide businesses through getting the most out of QBO.
In addition, I've added this article to help you organize your transactions and ensure everything is accurate and up-to-date: Reconcile transactions that are older than your opening balance in QuickBooks Online.
If you have further inquiries about connecting bank accounts or handling your transactions, feel free to leave a comment below. The Community is eager to assist you. Take care.
