Learn how to download transactions from your bank or cards. Then, manually import them into QuickBooks Online.
Connecting your bank and card accounts is one of the biggest time savers in QuickBooks Online. Once you connect, QuickBooks automatically downloads the last 90 days (or more) of transactions from your bank.
If you need to get older transactions from your bank, or if your bank doesn’t connect to QuickBooks, you can upload them manually. Here’s how.
To make sure you don’t import transactions you’ve already recorded, you’ll need to get the date for the oldest transaction in your account. This prevents duplicates.
Your bank might give you options for how to download / export your transactions. Pick one of these so you can upload the file into QuickBooks Online:
If you can, go for the QBO format. QBO files from banks should already be formatted for QuickBooks.If your file isn’t formatted, you can reformat and then upload it. The maximum file size is 350 KB. If your file is too big, shorten the date range and download your transactions in smaller batches.
If your account is connected to online banking, here’s how to start your upload:
If you don’t plan to connect your account, or your bank can’t connect to QuickBooks, here’s how to start your upload:
|See an error message?
Here’s what to do if you see an error message while uploading your transactions.
Now that your transactions are in QuickBooks, it’s time to go to the Banking menu to match and categorise the transactions. They’re not fully in your accounts until you’ve reviewed them.
Now your transactions are in QuickBooks, but there’s one more thing to consider: reconciling them. This ensures your books are accurate and there aren’t any duplicate transactions.
For instance, you may need to edit your opening balance if the transactions you just uploaded are older than it. It’s likely you included some (or all) of those older transactions as part of the opening balance total. You need to reconcile the transactions to make sure QuickBooks isn’t counting them twice.