To import a trial balance into QuickBooks Desktop, set up every account on the trial balance first, then post the balances as one general journal entry dated the last day before your start date. Build the entry in Excel, save it as an IIF file, and import it. Debits and credits must total the same.
Can a trial balance go into QuickBooks Desktop as one journal entry?
Yes. QuickBooks Desktop has no screen called "import trial balance", so the trial balance goes in as a general journal entry with one line per account. The debit balances become debit lines and the credit balances become credit lines. Because a trial balance already balances, the entry balances too.
That is the whole idea, and it explains why the rest of this post is mostly about preparation. The entry itself is simple. What makes it fail is an account name that does not match, a date in the wrong period, or a line that Desktop treats differently from the rest.
What the import route is
An answer from the QuickBooks team on Intuit's Batch Enter community thread about importing journal entries says there are two ways to import journal entries directly into Desktop: an IIF file, or a journal entries file from your accountant. The same answer says importing journal entries from an Excel sheet is not currently supported. So Excel is where you lay out the trial balance, and IIF is the file you actually import.
Typing it instead
A short trial balance does not need an import at all. If you have twenty accounts, typing them into Company > Make General Journal Entries takes a few minutes and lets Desktop check each account name as you go. The import route pays off when the trial balance runs to a hundred lines or more, or when you set up several company files from the same template.
Accounts that must exist before the trial balance import
Every account named on the trial balance must already be in the Desktop chart of accounts, spelled exactly the same way, with the right account type. Create or rename accounts first. A trial balance line that names an account Desktop cannot find does not fail cleanly, and the result is hard to undo.
Intuit's IIF overview of the import kit, sample files and headers warns that when a transaction in an IIF file names an account that does not exist, that account is created as a new bank account. Picture a trial balance line for "Prepaid Rent" when your chart says "Prepaid Expenses". The import makes a bank account called Prepaid Rent, and your balance sheet now shows cash that does not exist.
Matching names line by line
Before you build the file, put the trial balance's account column next to an exported list of your Desktop accounts and compare them. A lookup formula that flags any trial balance name with no exact match is the fastest check. Pay attention to three kinds of near miss:
- Subaccounts. Desktop names a subaccount with its parent, separated by a colon, such as "Utilities:Electric". A trial balance that lists only "Electric" will not match.
- Account numbers. If account numbers are switched on, the name the import expects may differ from the label you see on screen. Test one line before you trust the rest.
- Punctuation and spacing. A trailing space or an ampersand written as "and" is enough to miss.
Types matter as much as names
An account with the right name and the wrong type posts the right amount to the wrong part of the reports. A loan set up as an expense account sends the loan balance to the profit and loss report. Check the type of each account on the trial balance before the import, not after.
Which date should an opening trial balance carry?
Date the entry on the last day of the period the trial balance closes, which is the day before your first transaction in Desktop. A trial balance as of December 31 goes in dated December 31, and January's bank activity starts the next day. That keeps the opening position out of the new year's reports.
The date decides which reports the balances appear on. Income and expense balances from a trial balance belong to the year that just ended. If you date the entry January 1, those amounts land in the new year's profit and loss and distort it for the whole year.
Year-end or start-of-year balances
Many people who import a trial balance want only balance sheet balances, because they are starting fresh. In that case, ask your accountant for a post-closing trial balance, where income and expenses have already been closed into retained earnings. The entry then has assets, liabilities and equity lines only, and the date question becomes less sensitive.
If you are bringing in a mid-year trial balance instead, keep the income and expense lines and date the entry at the end of the last month you are not re-entering. The year-to-date profit then matches the source system.
Lining up with the bank start date
The bank side has to agree with the date. If the trial balance shows checking at 12,480.15 on December 31, the first bank file you import into Desktop should start on January 1. A bank file that starts earlier posts transactions that are already inside the trial balance figure, and the account is overstated by that amount. Importing bank transactions into QuickBooks Desktop covers the bank file side once the opening entry is in.
Turning the Excel trial balance into IIF journal lines
An IIF journal uses one signed amount per line instead of separate debit and credit columns. Debits stay positive and credits become negative, so the whole entry adds up to zero. Add a column that computes the signed amount, then copy it into the IIF layout with the TRNS, SPL and ENDTRNS rows.
A worked example
The trial balance below is an example with made-up values for a small business on December 31, 2025.
| Account | Debit | Credit | Signed amount for IIF |
|---|---|---|---|
| Business Checking | 12,480.15 | 12480.15 | |
| Equipment | 8,200.00 | 8200.00 | |
| Accumulated Depreciation | 1,640.00 | -1640.00 | |
| Credit Card Payable | 2,315.40 | -2315.40 | |
| Owner's Equity | 10,000.00 | -10000.00 | |
| Retained Earnings | 6,724.75 | -6724.75 | |
| Total | 20,680.15 | 20,680.15 | 0.00 |
The debit column and the credit column both total 20,680.15, and the signed column totals zero. If the signed column does not total zero, stop and find the line before you go further.
The signed formula is just the debit minus the credit for each row. Round it to two decimals with a formula, then paste it as values, so a hidden third decimal from the accountant's software does not throw the total off by a cent.
The matching IIF lines
Intuit's IIF overview describes transaction files as header rows starting with !TRNS, !SPL and !ENDTRNS, with each transaction closed by an ENDTRNS row. The first account goes on the TRNS row and the rest go on SPL rows. Here is the example as an IIF file, with tabs between fields:
!TRNS TRNSTYPE DATE ACCNT AMOUNT MEMO
!SPL TRNSTYPE DATE ACCNT AMOUNT MEMO
!ENDTRNS
TRNS GENERAL JOURNAL 12/31/2025 Business Checking 12480.15 Opening trial balance
SPL GENERAL JOURNAL 12/31/2025 Equipment 8200.00 Opening trial balance
SPL GENERAL JOURNAL 12/31/2025 Accumulated Depreciation -1640.00 Opening trial balance
SPL GENERAL JOURNAL 12/31/2025 Credit Card Payable -2315.40 Opening trial balance
SPL GENERAL JOURNAL 12/31/2025 Owner's Equity -10000.00 Opening trial balance
SPL GENERAL JOURNAL 12/31/2025 Retained Earnings -6724.75 Opening trial balance
ENDTRNS
Save the sheet as tab-delimited text, change the extension to .iif, and import it with File > Utilities > Import > IIF Files. Strip thousands separators and currency symbols from the amounts, and write the date the way your computer's regional settings expect. The full set of file rules, and how to test one safely, is in importing an IIF file into QuickBooks Desktop safely.
If the trial balance came from a Mac or a Numbers file
The menu paths in this post are for Desktop for Windows. Desktop for Mac has its own menus, so check them before you build the file, and a Web Connect file is the usual route there for bank lines; importing a QBO file into QuickBooks Desktop for Mac covers that case. If the trial balance arrived as a Numbers spreadsheet, export it to Excel or CSV first. The Online version of that step is in importing a Numbers spreadsheet into QuickBooks Online, and the export part works the same for a Desktop file.
Receivable, payable and bank lines in a trial balance entry
Three kinds of lines need care. Accounts receivable and accounts payable lines usually need a customer or vendor name, and a single lump sum hides which invoices are open. Bank and credit card lines become the starting point for reconciliation. Handle each one on purpose rather than letting it ride in the entry.
Receivables and payables
A trial balance shows accounts receivable as one total, such as 4,310.00. Desktop expects a customer on a receivables line in a journal entry, and that customer then shows one opening item instead of the real invoices. Many bookkeepers leave receivables and payables out of the journal entry and enter the open invoices and bills individually, dated on their original dates, so customers can be sent statements and paid against the right items. If you do that, put the difference in the entry against an equity account temporarily, then confirm it clears to zero once the open items are in.
Bank and card balances
The bank line in the entry becomes the opening balance that the first reconciliation starts from. Use the balance per the bank statement, adjusted for outstanding checks and deposits if the trial balance figure is a book balance rather than a statement balance. If you have outstanding checks at the start date, entering each one as its own check dated before the start date lets you tick them off later, instead of carrying a single difference forever.
Credit card balances work the same way. The card's closing balance on the statement dated nearest your start date is the figure to check the trial balance against.
When a trial balance import is the wrong starting point
Skip the trial balance import when you need transaction detail for the earlier period, when you are moving between two Desktop company files, or when the trial balance itself has not been reviewed. A journal entry carries balances only. It cannot recreate invoices, bank lines or payroll history, and it posts whatever errors the source already had.
Some cases call for a different route:
- You need last year's detail. If you want to run last year's reports inside Desktop, import the transactions, not a summary. For bank lines that means a Web Connect file per account and per period.
- The source is another Desktop file. Moving between two Desktop files has its own tools, and a trial balance throws away the history you could have kept.
- The trial balance does not balance. Fix it at the source. Forcing a balancing line into a suspense account just moves the problem into your new books.
- Only a handful of balances matter. If the business is new and has a bank balance and an owner contribution, two lines typed by hand beat any file.
Where the earlier period's bank activity only exists as PDF statements, SimpleBankConvert is being built to turn those PDFs into import files, so the detail can come in alongside the opening entry. It is in early access, so check what it handles today before you plan around it.
Proving the imported trial balance matches the source sheet
After the import, run Desktop's Trial Balance report as of the entry date and compare it to the source line by line. Every account should show the same debit or credit. If an extra account appears, the import created it from a mismatched name. If the totals differ, an amount or sign is wrong.
The checks to run
- Back up first. Intuit's guide to importing and exporting data in QuickBooks Desktop says an import cannot be undone, so the backup is your only way back.
- Run the Trial Balance report for the entry date only, and export it to Excel.
- Put it beside the source and compare each account's figure with a lookup formula.
- Look for accounts that were not there before, especially new bank accounts, which point at a name that did not match.
- Open the chart of accounts and confirm nothing is sitting in Opening Balance Equity that you did not put there.
- Check the first bank reconciliation starts from the bank statement balance you expected.
When the numbers differ
If one account is off, edit the journal entry in Desktop directly, since a single correction is safer than a second import. If many accounts are off, or a stray account was created, restore the backup, fix the sheet and import again. Intuit's IIF overview notes the import does limited error checking, so a file can go in without complaint and still be wrong. The report comparison is the step that proves it is right.