Learn how to get transactions from your bank or credit cards and manually import them into QuickBooks Online.
If you want to enter older transactions, or if your bank or credit card can't connect to QuickBooks, you can still upload transactions manually. Here's how:
Step 1: Pick a start date
To avoid entering duplicates, you need to know the date of the oldest existing transaction currently in the account:
- In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
- Find the bank or credit card account you want to upload the transactions into.
- Select Account history.
- Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.
Step 2: Get transactions from your bank
- Sign in to your bank or credit card's website.
- Follow your bank's instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps.
- Make sure the date range for the download is at least one day before your oldest transaction.
- Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.
|Tip: Your bank may offer a few file formats. Pick the CSV option as this will be the simplest to upload to QuickBooks Online.|
Step 3: Review the file format and size
The maximum file size is 350 KB. If your file is too big, shorten the date range and download your transactions in smaller batches. Ensure you have formatted the CSV file in the correct format before you upload it.
Step 4: Manually upload the transactions
Step 5: Categorise the transactions
Now that your transactions are in QuickBooks, it's time to match and categorise them. The transactions go into your accounts after you review them.
QuickBooks Online also enters certain details automatically if you set up any banking rules, or if it recognises transaction descriptions.
Step 6: Reconcile the transactions
Your transactions are now in QuickBooks. The final step is to reconcile them. This ensures your books are accurate and there aren't any duplicate transactions.