The 10-Column Accounting Worksheet, Explained: From Unadjusted Trial Balance to Financial Statements

Your trial balance balances. Debits equal credits, every account reconciles to its source — and your reported profit for the month is still wrong. Not because you made an error, but because the raw ledger balances do not yet reflect economic reality: a chunk of that prepaid insurance expired this month, three days of wages were earned but will not be paid until next week, and the equipment quietly used up another month of its useful life. None of those events wrote a transaction on their own, so none of them are in your books yet.

The 10-column accounting worksheet is the bridge between those raw balances and financial statements you can trust. It takes the unadjusted trial balance, layers the month-end adjustments on top, and sorts every account into its final home on the income statement or the balance sheet — all on one page, with built-in checks that catch mistakes before they reach your reports. This guide walks through what each column pair does, how to complete a worksheet step by step with a worked example, where net income appears, the five adjustments you will enter most months, and the mistakes that break the whole thing.

What a 10-Column Worksheet Actually Is​

A worksheet is a multi-column working paper — historically literal columnar pad paper, today almost always a spreadsheet — that lists every general ledger account with a balance and walks it through the rest of the accounting cycle. Account numbers and names run down the left in chart-of-accounts order: assets first, then liabilities, then equity, then revenue, then expenses. To the right sit ten amount columns, arranged as five debit-and-credit pairs:

Three things the worksheet is not. It is not a financial statement — nobody outside the accounting function ever sees it. It is not part of the formal books — nothing on it posts to the ledger until you journalize the adjusting entries separately. And it is not optional busywork from a textbook: it is the place where accrual accounting actually happens for businesses that keep manual or spreadsheet books, and the clearest possible review trail for anyone checking a close.

The Five Column Pairs, One by One​

Pair 1: The Unadjusted Trial Balance​

Copy each account's ending debit or credit balance straight from the general ledger. Asset and expense accounts normally land in the debit column; liability, equity, and revenue accounts land in the credit column. Total both columns. They must agree — if they do not, stop here, because every later pair inherits the error. The usual suspects are transposed digits, a balance copied into the wrong column, or a journal entry posted one-sided.

Pair 2: The Adjustments​

This is where accrual accounting lives. Each adjusting entry appears as a debit in one row's adjustment column and a credit in another's, keyed with a small reference letter — (a), (b), (c) — so each pair can be traced across rows. Common entries move expired insurance from prepaid to expense, recognize wages earned but unpaid, record depreciation, count down supplies on hand, and release earned portions of unearned revenue. Total both adjustment columns. Like every pair except the last two, debits must equal credits.

Pair 3: The Adjusted Trial Balance​

Combine pairs 1 and 2 row by row: unadjusted balance plus or minus the adjustment, keeping the account's normal-balance side in mind. A $1,200 debit to Supplies minus a $900 credit adjustment leaves a $300 debit. These are the true period-end balances — the numbers the financial statements will report. Total both columns; they must agree.

Pair 4: The Income Statement Columns​

Extend every revenue and expense balance from the adjusted trial balance across to this pair: expenses into debit, revenues into credit. Nothing else enters these columns. The two totals here will not agree, and that disagreement is the point — the difference is the period's net income or net loss, as the next section explains.

Pair 5: The Balance Sheet Columns​

Extend every asset, liability, and equity balance across: assets into debit; liabilities and equity into credit. Owner drawings or dividends — which carry debit balances but are not expenses — extend here too, into the debit column, because they reduce equity on the balance sheet rather than appearing on the income statement. This is the single most mis-sorted account on student and small-business worksheets alike.

How to Complete a Worksheet, Step by Step​

The procedure is the same whether the business has twelve accounts or two hundred. Work a small example alongside: suppose your unadjusted trial balance at October 31 shows Supplies $1,200 debit, Prepaid Insurance $2,400 debit, Unearned Revenue $3,000 credit, Salaries Expense $18,000 debit, and Service Revenue $31,000 credit, among other balanced accounts.

Step 1: Enter the unadjusted trial balance. List every account with a balance, prove debits equal credits, and fix any difference before moving on. A worksheet built on an out-of-balance trial balance is broken in every column to the right of it.

Step 2: Gather your adjustment data. Count the supplies on hand, check how much prepaid coverage expired, confirm wages earned through the last day of the month, review what portion of customer prepayments you have now earned, and compute the period's depreciation. In our example: supplies on hand $400, one month of insurance expired at $200, accrued wages $1,600, $1,800 of the prepayment earned, equipment depreciation $500.

Step 3: Enter the adjustments with key letters. Post each as a balanced debit-and-credit pair across two rows: (a) debit Supplies Expense $800, credit Supplies $800; (b) debit Insurance Expense $200, credit Prepaid Insurance $200; (c) debit Salaries Expense $1,600, credit Salaries Payable $1,600; (d) debit Unearned Revenue $1,800, credit Service Revenue $1,800; (e) debit Depreciation Expense $500, credit Accumulated Depreciation $500. Note that three of these create accounts — Salaries Payable, Depreciation Expense, Accumulated Depreciation — that had no unadjusted balance at all. New rows for adjustment-only accounts are normal; add them in chart-of-accounts order.

Step 4: Foot the adjustments. Total both adjustment columns and confirm they agree — $4,900 and $4,900 in our example. If they do not, one entry is one-sided or miscopied; the key letters make the hunt fast.

Step 5: Compute the adjusted trial balance row by row. Supplies becomes $400 debit, Prepaid Insurance $2,200 debit, Salaries Expense $19,600 debit, Service Revenue $32,800 credit, Unearned Revenue $1,200 credit, plus the three new accounts at their adjustment amounts. Total both columns and confirm they agree.

Step 6: Extend to the statement columns. Revenues and expenses go to the income statement pair; everything else goes to the balance sheet pair. Drawings goes to the balance sheet debit column — not with the expenses.

Step 7: Compute net income and prove the sheet. Find the difference between the income statement columns, enter it as the balancing figure (details below), then confirm the balance sheet columns agree with it included. If they do not, an account was extended to the wrong statement — the most common failure at this stage.

Once the worksheet proves out, journalize the adjusting entries in the general journal and post them to the ledger. Only then do the books match the worksheet. The worksheet plans the adjustments; the journal entries make them real.

Where Net Income Appears​

The income statement columns never balance on their own, because revenues and expenses are different amounts. That imbalance is the answer the whole exercise exists to find. If credits exceed debits, the difference is net income; if debits exceed credits, it is a net loss.

Enter the figure twice so both statement pairs balance. For net income, write it in the income statement debit column (on the smaller side, bringing it up to the credit total) and in the balance sheet credit column — because profit increases equity, and equity lives on the credit side. Label the line clearly. For a net loss, reverse it: income statement credit column and balance sheet debit column.

Then total all four statement columns. If both pairs agree, the worksheet is internally consistent: every adjusted dollar landed on exactly one statement, and the profit linking them ties out. This cross-foot is the worksheet's quiet superpower. A trial balance proves debits equal credits; the completed worksheet additionally proves the statements articulate — that the income statement's bottom line is exactly what the balance sheet's equity section absorbs.

The Five Adjustments You Will Enter Most Months​

Nearly every month-end close draws from the same short list. Learn these five patterns and you can complete most worksheets without thinking hard about any of them.

Prepaid expenses expiring. Rent, insurance, and software paid in advance sit in asset accounts until time passes. Each period, move the used-up slice to expense: debit the expense, credit the prepaid asset. A $2,400 annual policy means a $200 monthly entry, twelve times a year.

Supplies consumed. The unadjusted balance shows what you bought; the count shows what remains. The difference is the expense: debit Supplies Expense, credit Supplies. Skip the physical count and this entry is a guess — which is why auditors ask when you last counted.

Accrued expenses. Wages earned through month-end but paid later, interest accumulating on a loan, a utility bill that has not arrived. The cost belongs to this period even though the cash leaves later: debit the expense, credit the payable. Accrued payroll is the largest adjustment on many small-business worksheets.

Unearned revenue earned. Customer deposits and annual subscriptions collected up front sit in a liability account until you deliver. As you earn them, release the earned portion: debit Unearned Revenue, credit Revenue. Getting this backwards — recognizing the whole prepayment as day-one revenue — overstates both income and tax liability.

Depreciation. Allocate another period of an asset's cost: debit Depreciation Expense, credit Accumulated Depreciation, the contra-asset that holds lifetime depreciation without touching the asset's original cost. No cash moves, which is exactly why it is so often forgotten until year-end.

Accrued revenues — work performed but unbilled at month-end — form the natural sixth entry for project and service businesses: debit the receivable, credit revenue.

Mistakes That Break the Worksheet​

Worksheets fail in predictable ways, and each failure announces itself in a specific column pair.

Unbalanced adjustments. If the adjustment columns disagree, exactly one entry is one-sided or miscopied. Check each key letter's debit against its credit before touching anything else.

Extending to the wrong statement. An expense carried to the balance sheet, or a liability carried to the income statement, breaks the final proof while leaving every earlier pair green. When the balance sheet columns refuse to agree after net income is entered, re-check the extension of every account, starting with the ones you added mid-close.

Drawings with the expenses. Owner withdrawals reduce equity; they are never an expense. They extend to the balance sheet debit column. Misplacing them understates net income by the withdrawal amount and misstates both statements at once.

Forgetting adjustment-only accounts. Accrued liabilities, depreciation expense, and accumulated depreciation often have no unadjusted balance. If there is no row for them, the adjustment has nowhere to go and gets forced somewhere wrong. Add the row.

Transposition and slide errors. A $1,200 balance copied as $2,100 throws the trial balance off by $900 — always divisible by 9, the classic fingerprint of swapped digits. When a column pair is out of balance, divide the difference by 9: a clean result means two adjacent digits traded places somewhere.

Treating the worksheet as the books. The worksheet changes nothing until its adjustments are journalized and posted. Close the month, file the worksheet as your audit trail, post the entries — in that order. Next month starts from posted balances, never from last month's worksheet.

Do You Still Need One When Software Closes the Books?​

Honest answer: the worksheet's original job — turning raw balances into statements by hand — is work accounting software does automatically. Modern systems post adjusting entries directly to the ledger and generate statements from adjusted balances, so a ten-column spreadsheet is no longer the only path from trial balance to financials.

But the worksheet refuses to die, for four good reasons. Businesses on manual or spreadsheet books still need it exactly as described here. Multi-entity consolidations still happen on worksheet-style spreadsheets, where eliminating entries between parent and subsidiary are visible side by side in a way no drill-down report matches. Reviewers and auditors still think in worksheet terms — unadjusted balance, adjustment, adjusted balance is the grammar of every close review. And for anyone learning accrual accounting, completing one worksheet by hand teaches more about how statements connect than a semester of lectures.

Plain-text bookkeeping keeps the same discipline with a different mechanic: instead of pencil adjustments in side columns, each month-end adjustment is an ordinary dated transaction in the ledger file, so the adjustment history is visible, version-controlled, and re-runnable rather than trapped in a spreadsheet. October's insurance amortization and wage accrual look like this:

2026-10-31 * "Amortize prepaid insurance for October"
  Expenses:Insurance           200.00 USD
  Assets:Prepaid-Insurance    -200.00 USD
 
2026-10-31 * "Accrue wages earned Oct 29-31, paid Nov 5"
  Expenses:Payroll:Salary     1600.00 USD
  Liabilities:Accrued-Payroll -1600.00 USD

Post those alongside the month's regular transactions and the ledger itself always reflects adjusted balances — the trial balance and the adjusted trial balance become the same report, and the worksheet's first three column pairs collapse into one. The Beancount documentation covers transaction syntax and account structure in depth, and once the adjustments are posted you can watch them flow through to balances and charts in Fava.

Your Last Useful Step​

Build the template once and reuse it forever. Set up a spreadsheet with the account list and the five column pairs, pre-total every pair, and save it as next month's starting point. Then shrink month-end to a twenty-minute routine: update the unadjusted balances, walk the five adjustments in the order above, extend, prove, journalize, post. The first worksheet takes an evening; the tenth takes less time than reconciling the bank statement — and it is the reason the statements you sign each month say what actually happened.