QuickBooksHelpIntuit

Manually upload transactions into QuickBooks Online

by Intuit•65• Updated 2 days ago

When you connect your bank and credit card accounts, QuickBooks pulls in your transactions up to a set date. If you can’t connect your bank, or need to bring in older transactions, follow these steps.

Note: When you upload your bank and credit card transactions, it is important to know if they go to one account or individual accounts. Setup parent accounts and subaccounts on your chart of accounts to smoothly upload your transactions.

Before you start

Check your bank’s website to find out how to get a copy of your transactions.
Start your record or account statement at least one day before your earliest QuickBooks transaction in that account.
Set up parent accounts and subaccounts in your chart of accounts to help your transactions upload smoothly.
Check your chart of accounts before uploading your files to avoid duplicate transactions.
To categorise your uploaded transactions as you upload them, set up bank rules in QuickBooks first.

File guidelines

Your upload file must be in English and 350 KB or less. We suggest a QuickBooks Online data (QBO) file. You can also upload Comma-separated values (CSV) files.

Each file needs either 3 (Date, Description, Amount) or 4 (Date, Description, Credit, and Debit) columns. For larger uploads, shorten the date range and download transactions in smaller batches.

Remove the word “amount” from Credit and Debit.
Leave any cells in Amount, Credit, or Debit that only contain zero (0) blank.
Remove numbers from cells in the Description column.
Enter all Dates in the same format. We recommend dd/mm/yyyy format.
Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). Split the date and the day of the week into separate columns.

Note: To categorise your uploaded transactions as you upload them, set up bank rules in QuickBooks first.

Upload a list

Follow these steps if you'd like to upload your bank statement from these file types: .csv, .txt, .qbo, or .ofx. You can include up to 1,000 lines per upload. Each line contains one transaction.

Go to All apps , select Accounting, then select Bank transactions (Take me there).
If you see a tile for the account you want to upload transactions into, select it.
Select the Link account ▼ dropdown, then select Upload from file.
Note: If your account isn't connected yet to online banking, select Upload transactions.
Select Drag and drop or select files, and select the file you downloaded from your bank. Then, select Continue.
In the Select account ▼ dropdown, select the account you want to upload the transactions into, then select Continue.
Note: If you're new to QuickBooks, you may not have an account to upload the transactions into. If you don't see one, select + Add new from the ▼ dropdown to create a new bank account.
Match the columns in the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Select Yes, then select Done.

Note: QuickBooks may add additional details if we recognise transaction descriptions, or based on your banking rules.

Next steps

Match and categorise your uploaded transactions to place them in the correct accounts. Then reconcile them to make sure they’re recorded correctly.