A clean trial balance import needs four things: an account number, an account name, and either separate debit and credit columns or one signed balance column. Strip headers, totals and blank rows before you import. Afterwards, confirm total debits equal total credits and that net income matches the client's own report.
Which columns does a trial balance import need?
A trial balance import needs one row per account and, at minimum, an account number, an account name and the account's balance. The balance can arrive as two columns, debit and credit, or as one signed column where debits are positive and credits are negative. Anything else, such as a period date or an account type, is helpful but optional.
The account number is the key. It is what a mapping table, a prior-year comparison and a workpaper reference all join on, so it must be present on every row and stored as text, not as a number. Account numbers such as 0150 lose their leading zero when Excel treats them as numbers. Microsoft's guide to importing text and CSV files into Excel warns that when Excel opens a CSV directly it applies its default data format to each column, and those defaults can change how values arrive. Importing through Data, From Text/CSV, and transforming the data before loading lets you set the account column to text.
The account name is for people. Two accounts with the same name and different numbers are common, for example two checking accounts both called "Checking". Keep the number as the key and the name as the label.
A sample import-ready file
This example is for a fictional dental practice, Alder Creek Dental PLLC, at December 31, 2026. All names and amounts are made up. Here is the file in debit and credit form:
Account,Name,Debit,Credit
1000,Operating Checking XXXX-3307,46250.00,0.00
1200,Accounts Receivable,18400.00,0.00
1500,Dental Equipment,92000.00,0.00
1510,Accumulated Depreciation,0.00,31500.00
2000,Accounts Payable,0.00,7850.00
2500,Equipment Loan,0.00,40000.00
3000,Member Capital,0.00,50000.00
4000,Patient Fees,0.00,214600.00
5000,Dental Supplies,38900.00,0.00
6000,Staff Wages,121300.00,0.00
6100,Rent,27100.00,0.00
The debits total 343,950.00: 46,250 plus 18,400 plus 92,000 plus 38,900 plus 121,300 plus 27,100. The credits total 343,950.00: 31,500 plus 7,850 plus 40,000 plus 50,000 plus 214,600. The file has no total row, because the import tool or a formula should compute totals rather than read them.
Trial balance import sign conventions: debit and credit or one balance column
A trial balance import uses one of two sign conventions. Two-column files put each balance under Debit or Credit, both as positive numbers. One-column files hold a signed balance, with debits positive and credits negative, so the whole column sums to zero. Converting between them is one formula each way.
To go from two columns to one, subtract: signed balance equals debit minus credit. In Excel, with debit in C2 and credit in D2, the formula is =C2-D2. To go from one column to two, split on the sign: debit is =MAX(E2,0) and credit is =MAX(-E2,0), where E2 holds the signed balance.
Here are the same Alder Creek rows in signed form:
Account,Name,Balance
1000,Operating Checking XXXX-3307,46250.00
1200,Accounts Receivable,18400.00
1500,Dental Equipment,92000.00
1510,Accumulated Depreciation,-31500.00
2000,Accounts Payable,-7850.00
2500,Equipment Loan,-40000.00
3000,Member Capital,-50000.00
4000,Patient Fees,-214600.00
5000,Dental Supplies,38900.00
6000,Staff Wages,121300.00
6100,Rent,27100.00
The signed balances sum to 0.00, which is the one-column version of debits equalling credits.
Three sign traps come up often:
- Parentheses for credits. A PDF or export that prints (31,500.00) needs converting to -31,500.00 before it counts as a number.
- Credit balances shown positive in a single column. Some reports print every balance as a positive number in one column and rely on the account type to say which side it is on. Those files need a debit or credit flag added before import, or the totals will not balance.
- Abnormal balances. An account on the opposite side from usual, such as a checking account that is overdrawn, still follows the same rule. In two-column form it moves to the other column. In signed form it changes sign.
Pick one convention for your own workpapers and convert every client file into it. Mixing conventions between clients is how a revenue account ends up positive in one file and negative in the next.
Cleaning a trial balance file before import
Cleaning a trial balance file means removing every row that is not an account balance: report titles, column headings repeated on each page, section subtotals, the grand total, blank rows and indented parent accounts that duplicate their subaccounts. What remains is one row per posting account and nothing else.
Work through the file in this order:
- Delete the report header. Company name, report title, date and basis belong in your notes, not in the data.
- Remove repeated column headings. Multi-page exports and PDFs bring them back at the top of each page.
- Remove subtotals and the grand total. If they stay in, every total doubles. Keep a note of the printed grand total so you can check against it after import.
- Resolve parent and subaccount rows. A parent account that prints its own total above or below its subaccounts counts the same money twice. Keep the subaccounts and drop the parent total, or keep the parent and drop the children, but not both.
- Split combined fields. Some reports print "1000 Operating Checking" as one cell. Split the number from the name.
- Trim spaces. Indents used for subaccounts often survive as leading spaces, which stop account numbers from matching.
Zero-balance accounts are a judgement call. Keeping them makes next year's comparison easier, because an account that was zero last year and has a balance this year still has a row to compare against. Dropping them makes a shorter file. Whichever you choose, choose it every year.
When the client uses QuickBooks Online, running the report with the right settings removes some of this work at the source. The guide to running and exporting a QuickBooks Online trial balance covers those settings.
What should you check after a trial balance import?
After a trial balance import, check two things before anything else: that total debits equal total credits, and that net income computed from the imported rows equals the net income on the client's own profit and loss report. Then compare the account count and the grand total with the source.
The first check comes straight from double-entry bookkeeping. The IRS Publication 583 says the total debits must equal the total credits after the journal entries are posted to the ledger accounts, and that if the amounts do not balance, an error has been made. An imported trial balance that does not balance has lost or changed a row on the way in.
Net income is the second check because it catches a sign or classification error that leaves totals balanced. In the Alder Creek example, revenue is 214,600.00 and the three expense accounts total 187,300.00, which is 38,900 plus 121,300 plus 27,100. Net income is 27,300.00. If the client's profit and loss report for 2026 also shows 27,300.00, the income statement accounts came across intact.
Post-import checklist
Run these after every trial balance import:
- Debits equal credits. In signed form, the balance column sums to zero.
- Net income agrees with the client's profit and loss report for the same period and basis.
- Account count agrees with the source report, after allowing for subtotal rows you removed.
- Grand total agrees with the printed total you noted while cleaning.
- Every account number is text and none lost a leading zero.
- No duplicate account numbers. A number appearing twice usually means a parent and a child both survived.
- Every account is mapped. New accounts need a statement line before anything else uses the file.
The last check leads into the next step of the workpaper process. Once balances are in, each account is assigned to a statement or tax line using a reusable map; the guide to building a reusable trial balance mapping table shows how that table is laid out.
Trial balance import edge cases: new, renamed and merged accounts
A trial balance import that runs every year meets accounts that were not there last year: new accounts the client added, accounts renamed without changing their number, and accounts merged or split. Each needs handling before the import is used, because a map and a prior-year comparison both key on account number.
New accounts appear with a number your map has never seen. They are the easiest to catch, because a lookup against last year's map returns nothing. Assign them a line before using the file. A new account with a large balance is also worth a question to the client about what it holds.
Renamed accounts keep their number but change their name, for example "Office Supplies" becoming "Office Expense". Because the number is the key, the import still works. Update the name in your map so the workpapers read correctly, and check that the account still belongs on the same line.
Renumbered accounts are harder. If the client changed 6100 Rent to 6150 Rent, the import treats 6150 as new and 6100 as gone. Prior-year comparisons then show rent dropping to zero and a new account appearing. Keep a small crosswalk table, old number to new number, and apply it before comparing years.
Merged accounts combine two prior accounts into one. Last year's two balances need adding together for a fair comparison. Split accounts do the opposite. In both cases, note the change in the file so the next person does not rediscover it.
An account that disappears is also worth a look. If last year's file had 2600 Line of Credit and this year's does not, either the loan was paid off and the account removed, or the account was left out of the export.
Importing a trial balance from a PDF instead of an export
Importing a trial balance from a PDF adds one step before cleaning: turning the printed report into rows. A PDF with selectable text can be read with Excel's PDF connector. A scanned PDF needs character recognition first. Either way, the after-import checks matter more, because a misread digit still produces a believable number.
The connector steps and the problems they cause, such as wrapped rows and repeated page headers, are covered in converting a general ledger PDF with selectable text, and the same Power Query route works here. A trial balance is usually a single table, often on one or two pages, so it tends to go more smoothly than a long ledger.
For a scan, Microsoft's guide to inserting data from a picture asks you to review and correct the results before inserting them. Read every amount against the image during that review. On a trial balance, one misread balance throws off the totals, which is at least easy to see.
A PDF has one advantage: its printed grand total is right there. If your imported rows add to the printed totals on both sides, the conversion is very likely complete.
If the client's trial balance arrives as a PDF among other uploads, Schema CPA can read it and export the rows to Excel or CSV, which gives you a starting file for the cleaning steps above. The checks still apply to that file like any other. The Schema CPA pricing section lists Excel and CSV export on the Free plan.
Some firms will later move the balances from Excel into the client's books or another system. The guide to ledgers and journal entries in a QuickBooks Online export covers what that step involves.