Showing results for 
Search instead for 
Did you mean: 

Manually upload transactions into QuickBooks Online

Learn how to download transactions from your bank or credit cards. Then, manually import them into QuickBooks Online.

Connecting your bank and credit 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.

Step 1: Pick a date range

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.

  1. In QuickBooks, go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the bank or credit card account you want to upload more transactions into. Then select View register.
  4. Scroll to the bottom of the list.
  5. Write down the date of the oldest transaction. In many cases, the oldest transaction is the opening balance.

Step 2: Download transactions from your bank

  1. Sign in to your bank or credit card’s website.
  2. Follow your bank’s instructions for how to download transactions to your computer. Some banks call this WebConnect. Every financial institution has different steps: here are guides for Bank of America, Chase, and Wells Fargo.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find it, like your desktop.

Step 3: Review the file format and size

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:

  • Comma-Separated Values (CSV)
  • QuickBooks Online (QBO)
  • Quicken (QFX)
  • Microsoft Money (OFX)

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.

Step 4: Start your upload

Step 5: Upload your file into QuickBooks

  1. Select Browse and select the file you downloaded from your bank. Then select Next.
    See an error message?

    Here’s what to do if you see an error message while uploading your transactions.

  2. From the QuickBooks account drop-down menu, select the account you want to upload the transactions into. Then select Next. If you haven’t connected your account to QuickBooks, you might not have an account to upload the transactions into. If you don't have one, select Add New from the drop-down menu to create a new bank account.
  3. Follow the onscreen instructions. Match the columns on the file with the banking fields in QuickBooks. Then select Next.
  4. When you’re ready, select Let's go. QuickBooks will add the transactions to your account.

Step 6: Categorize the transactions

Now that your transactions are in QuickBooks, it’s time to go to the Banking menu to match and categorize the transactions. They’re not fully in your accounts until you’ve reviewed them.

Step 7: Reconcile the transactions

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.