How to Import Data From Excel into QuickBooks Online Easily 2026

QuickBooks Online's Import Data tool for journal entries expects a CSV with six columns, in order: Journal No., Journal Date, Account Name, Journal/Description, Debits, and Credits. Every account name has to match the spelling in the QuickBooks chart of accounts exactly.

For a sub-account, use the parent and sub-account names separated by a colon, such as Utilities:Electric, the same way QuickBooks displays it internally. Add any account that doesn't exist yet to the chart of accounts first, since the import matches by name and won't create new accounts on the fly. Save the finished sheet as a CSV, not an XLSX, before starting the import.

Log in and land on the homepage, where Business at a glance shows bank balances, profit and loss, and invoice status across three cards. The Import Data tool lives under Settings, the gear icon in the top right, not inside the journal entry screen itself, so this dashboard is only the starting point for reaching it.

From Settings, select Import Data, then Journal Entries. Click Browse, locate the CSV built in the first step, then click Open and Next. QuickBooks offers a sample file from this same screen, worth downloading once to confirm the column order matches before attempting a real import.

The next screen maps each column in the uploaded file to a QuickBooks field using dropdown menus. Confirm every column lined up correctly, especially Account Name, since a misaligned mapping silently sends debit values into the wrong field.

Click Next, and QuickBooks flags rows it can't reconcile, most often because an account name doesn't yet exist in the chart of accounts. Fix those in the source file and re-upload instead of trying to patch them inside the mapping screen.

Once the mapping looks right, click Start import, then Done. Open the newly created entries from the Journal Entries list and confirm the Debits and Credits totals match for each one. An entry that doesn't balance to zero difference hasn't imported cleanly even when QuickBooks didn't flag it outright at upload.

The Import Data tool is built for bulk data, not a single adjusting entry. For something that small, skip the CSV: use the Create menu (the plus icon) and choose Journal entry to open a blank grid with Account, Debits, Credits, Description, and Name columns.

Typing a handful of lines directly into this grid is faster than building and uploading a file for one entry. QuickBooks' own support team has stated that pasting a full range of cells copied from Excel straight into this grid isn't something the product supports, so treat any paste that appears to work as filling individual cells, not loading a whole spreadsheet at once.