Trial Balance Checker

Enter account balances or upload a CSV to verify your debits equal your credits.

Account Rows

Account NameDebitCredit
TOTALS0.000.00
CSV format: account,debit,credit — one row per account, header row optional.
✓

In Balance

Total Debits0.00
Total Credits0.00

Summary

Accounts entered0
Accounts with debits0
Accounts with credits0

Sign up to connect your books directly and never manually check again.

Bookkipa maintains double-entry books automatically as you categorize transactions. Your trial balance is always current — no spreadsheets, no manual entry, no year-end scramble.

Try Bookkipa free

What Is a Trial Balance and Why Does It Matter?

A trial balance is a bookkeeping worksheet that lists every account in your general ledger along with its ending balance. Accounts are split into two columns: debits on the left, credits on the right. In a correctly maintained set of books, total debits will always equal total credits. This equality is the fundamental check that double-entry bookkeeping provides.

The Purpose of a Trial Balance

The trial balance serves as an internal check before you prepare financial statements. If debits don’t equal credits, something went wrong in recording — a transaction was entered with unequal amounts, posted to only one account, or omitted entirely. Catching these errors at the trial balance stage is far easier than finding them after you’ve prepared your P&L and balance sheet.

Historically, accountants prepared trial balances by hand to detect arithmetic errors before adding up the full set of books. Today, accounting software does this continuously — every time you post a transaction, the software checks that debits equal credits. But when you’re working from spreadsheets, bank exports, or manually maintained records, the trial balance checker is an essential verification step.

Debits and Credits: The Basics

In double-entry bookkeeping, every transaction has two sides. A debit increases assets and expenses; it decreases liabilities, equity, and revenue. A credit does the opposite: it increases liabilities, equity, and revenue; it decreases assets and expenses. This feels counterintuitive at first, but it follows from the accounting equation (Assets = Liabilities + Equity).

When you deposit a check from a client, you debit cash (an asset goes up) and credit service revenue (income goes up). When you pay rent, you debit rent expense (an expense goes up) and credit cash (an asset goes down). Every transaction must have at least one debit and one credit, and total debits must always equal total credits.

What a Balanced Trial Balance Does (and Does Not) Tell You

A balanced trial balance means your books are mathematically consistent — every debit has a corresponding credit. It does not mean your books are accurate. Several errors can exist in a balanced trial balance: transactions posted to the wrong account (debit office supplies instead of equipment), compensating errors (one entry is $100 too high and another is $100 too low), or complete omissions (a transaction that was never recorded at all, affecting both sides equally).

This is why a trial balance is a necessary but not sufficient condition for accurate books. You also need to reconcile your bank accounts and review your account balances for reasonableness.

How to Use This Trial Balance Checker

Enter each account from your general ledger with either its debit balance or its credit balance — not both. Asset and expense accounts normally carry debit balances; liability, equity, and revenue accounts normally carry credit balances. If an account has a balance on its abnormal side (a credit-balance asset, for example), enter it on that side.

If you have your data in a spreadsheet, export it as a CSV with columns named “account,” “debit,” and “credit” and upload it directly. The tool will parse your accounts automatically.

Common Causes of an Out-of-Balance Trial Balance

When your trial balance doesn’t balance, the debugging process follows a logical sequence. First, check if the difference is divisible by 9 — if so, you almost certainly have a transposition error (e.g., you entered 8,100 where you meant 8,010). If the difference equals the amount of a specific transaction, that transaction was likely posted to only one account. If the difference is a round number, look for a missing entry or an incorrectly added column.

When debits and credits are correctly maintained throughout the year, your trial balance will naturally balance before any adjusting entries. After adjusting entries (for depreciation, prepaid expense amortization, accruals, etc.) and closing entries, the adjusted trial balance forms the basis for your financial statements.