Study guide

3.3 The 10-Column Accounting Worksheet

Certified Public Bookkeeper CPB

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Introduction & CPB Certification Overview

1.1 About the Certified Public Bookkeeper (CPB) Credential 1.2 The Role of the Bookkeeper vs. Accountant 1.3 How to Use This Study Guide & Exam Strategy 1.4 The Business Communication Certification (Required January 1, 2027)

2 Chapter 2: Core Accounting Concepts & The Accounting Equation

2.1 The Accounting Equation & Account Classifications 2.2 Transaction Analysis & T-Accounts 2.3 The General Journal, General Ledger & Posting 2.4 The Unadjusted Trial Balance & Error Detection

3 Chapter 3: Adjusting Entries, Worksheet & Financial Statements

3.1 Accruals & Deferrals (Adjusting Journal Entries) 3.2 Depreciation & Fixed Asset Accounting 3.3 The 10-Column Accounting Worksheet 3.4 Preparing the Income Statement, Statement of Owner's Equity & Balance Sheet

4 Chapter 4: The Closing Process, Merchandising & Cash Controls

4.1 The 4-Step Closing Process & Post-Closing Trial Balance 4.2 Merchandising Operations & Perpetual/Periodic Inventory 4.3 Accounts Receivable & Bad Debt Accounting 4.4 Accounts Payable, Cash & Bank Reconciliations

5 Chapter 5: QuickBooks Online Setup, Banking Feeds & Lists

5.1 QBO Architecture, Subscription Levels & Company Settings 5.2 Chart of Accounts, Products/Services & List Management 5.3 Connecting Bank Feeds, Transaction Matching & Bank Rules 5.4 Performing Bank & Credit Card Reconciliations in QBO

6 Chapter 6: QuickBooks Online Sales, Expenses & Inventory Workflows

6.1 Sales Workflows: Estimates, Invoices, Sales Receipts & Customer Payments 6.2 Expense Workflows: Expenses, Checks, Bills & Accounts Payable 6.3 Inventory Tracking, Purchase Orders & FIFO Costing in QBO 6.4 Adjusting Journal Entries, Voiding/Deleting & Closing the Books

7 Chapter 7: QuickBooks Online Payroll & Financial Reporting

7.1 QBO Payroll Setup, Employee Records & Compensation Types 7.2 Running Payroll, Direct Deposit & Automated Payroll Taxes in QBO 7.3 Core Financial Reports: Profit and Loss, Balance Sheet & Statement of Cash Flows 7.4 Management Reports, Customization, Tagging & Exporting

8 Chapter 8: Payroll Laws, Worker Classification & Gross Pay Computations

8.1 Federal Payroll Legislation: FLSA, FICA, FUTA, SUTA & Form W-4 8.2 Employee vs. Independent Contractor Classification (W-2 vs. 1099-NEC) 8.3 FLSA Overtime Rules, Regular Rate of Pay & White-Collar Exemptions 8.4 Gross Pay Computations: Hourly, Salaried, Piecework, Tips & Commissions

9 Chapter 9: Payroll Deductions, Net Pay & Employer Tax Liabilities

9.1 Voluntary Deductions: Pre-Tax vs. Post-Tax Fringe Benefits (Section 125, 401(k), HSA) 9.2 Statutory Withholdings: Federal Income Tax, Social Security, Medicare & Net Pay 9.3 Involuntary Deductions: Wage Garnishments, Child Support & Tax Levies 9.4 Employer Payroll Taxes: Matching FICA, FUTA, SUTA & Total Cost of Labor

10 Chapter 10: Payroll Tax Compliance, Deposits & Accounting Entries

10.1 Federal Tax Deposit Rules: Monthly vs. Semi-Weekly Schedules & EFTPS 10.2 Quarterly & Annual Payroll Tax Returns (Forms 941, 940 & State Filings) 10.3 Year-End Wage Reporting: Forms W-2, W-3, 1099-NEC & 1096 Compliance 10.4 Payroll Accounting: Recording Payroll Journal Entries & General Ledger Accruals 10.5 Payroll Records: The Payroll Register & Employees' Earnings Records

3.3 The 10-Column Accounting Worksheet

Key Takeaways Explain This Topic AI

The 10-column worksheet is an informal internal accounting working tool used at period-end to organize unadjusted trial balance data, calculate and verify adjusting entries, and separate accounts into financial statement columns before formal recording.

The 10 columns are structured in 5 pairs of Debit and Credit columns: (1-2) Unadjusted Trial Balance, (3-4) Adjustments, (5-6) Adjusted Trial Balance, (7-8) Income Statement, and (9-10) Balance Sheet.

Every adjusting entry on the worksheet must have balancing debit and credit adjustments, typically cross-referenced with letters or numbers (e.g., (a), (b), (c)) for auditability.

Net Income is calculated as the excess of the Income Statement Credit column (Revenues) over the Income Statement Debit column (Expenses); to balance the worksheet, Net Income is inserted in the Income Statement Debit column and the Balance Sheet Credit column.

A Net Loss occurs when Income Statement Debits exceed Credits, and is balanced by entering the deficit in the Income Statement Credit column and the Balance Sheet Debit column.

Last updated: August 2026

The 10-Column Accounting Worksheet

At the end of an accounting period, bookkeepers must synthesize unadjusted general ledger balances, determine multiple adjusting entries, verify mathematical equilibrium, and construct draft financial statements. Trying to execute all these steps directly into the formal general journal and general ledger can lead to posting errors and uncoordinated financial statements.

To prevent errors, bookkeepers utilize a structured working paper called the 10-Column Accounting Worksheet (often called an end-of-period spreadsheet). While software applications like QuickBooks automate calculations behind the scenes, understanding the manual mechanics of the 10-column worksheet is an essential core competency tested on the CPB examination.

1. Nature & Purpose of the Worksheet

Note

An Internal Tool, Not a Financial Statement: The 10-column worksheet is an informal internal working document . It is never published or distributed to external parties (such as banks, investors, or the IRS). Using a worksheet does not replace the legal requirement to formally record adjusting entries in the General Journal and post them to General Ledger accounts.

Primary Functions of the Worksheet:

Centralizes Period-End Adjustments: Gathers all necessary end-of-period accruals and deferrals in one clear view.

Detects Mathematical Imbalances Early: Verifies that Total Debits equal Total Credits at each sequential phase.

Separates Nominal vs. Real Accounts: Automatically directs temporary accounts to the Income Statement columns and permanent accounts to the Balance Sheet columns.

Facilitates Error-Free Statement Drafting: Serves as the master data blueprint from which formal financial statements are generated.

2. Structure of the 10 Columns

The worksheet organizes accounting data into five consecutive pairs of Debit (Dr.) and Credit (Cr.) columns: +-------------------------------------------------------------------------------------------------------------------------+

  • | THE 10-COLUMN WORKSHEET ARCHITECTURE |
  • | |
  • | COL 1 & 2: COL 3 & 4: COL 5 & 6: COL 7 & 8: COL 9 & 10: |
  • | UNADJUSTED ADJUSTMENTS ADJUSTED INCOME BALANCE SHEET & |
  • | TRIAL BALANCE TRIAL BALANCE STATEMENT STATEMENT OF OWNER'S EQUITY |
  • | +--------+--------+ +--------+-------+ +--------+--------+ +--------+--------+ +--------+--------+ |
  • | | Dr. | Cr. | | Dr. | Cr. | | Dr. | Cr. | | Dr. | Cr. | | Dr. | Cr. | |
  • | +--------+--------+ +--------+-------+ +--------+--------+ +--------+--------+ +--------+--------+ |

+-------------------------------------------------------------------------------------------------------------------------+

Detailed Column Pair Descriptions

Column Pair Title Purpose & Account Types Included

1 & 2 Unadjusted Trial Balance Transcribes every account balance directly from the general ledger prior to any period-end adjustments. Column 1 (Dr.) must equal Column 2 (Cr.).

3 & 4 Adjustments Contains all period-end adjusting debits and credits. Each debit and credit leg is cross-referenced with a unique letter key ( a ) , ( b ) , ( c ) (a), (b), (c) ( a ) , ( b ) , ( c ) to ensure traceability. Column 3 (Dr.) must equal Column 4 (Cr.).

5 & 6 Adjusted Trial Balance Combines the unadjusted balance with the adjustments. Proves mathematical equality before extending to statements. Column 5 (Dr.) must equal Column 6 (Cr.).

7 & 8 Income Statement Contains only temporary (nominal) accounts : Expenses in Column 7 (Dr.) and Revenues in Column 8 (Cr.).

9 & 10 Balance Sheet & Owner's Equity Contains all permanent (real) accounts : Assets in Column 9 (Dr.), Contra-Assets & Liabilities in Column 10 (Cr.), Owner's Capital in Column 10 (Cr.), and Owner's Drawing in Column 9 (Dr.).

3. The 5-Phase Sequential Preparation Workflow +-----------------------------------------------------------------------------+

  • | 5-PHASE WORKSHEET PREPARATION WORKFLOW |
  • | |
  • | PHASE 1: Transcribe Unadjusted Trial Balance (Prove Dr = Cr) |
  • | | |
  • | v |
  • | PHASE 2: Enter Cross-Referenced AJEs in Adjustments (Prove Dr = Cr) |
  • | | |
  • | v |
  • | PHASE 3: Calculate & Total Adjusted Trial Balance (Prove Dr = Cr) |
  • | | |
  • | v |
  • | PHASE 4: Extend Balances to Income Statement OR Balance Sheet |
  • | | |
  • | v |
  • | PHASE 5: Total Statement Columns, Compute Net Income, and Balance Pairs |
  • +-----------------------------------------------------------------------------+
  • Phase 1: Transcribing the Unadjusted Trial Balance

Account numbers, titles, and ending general ledger balances are entered into Columns 1 and 2. Accounts are listed in standard chart-of-accounts order (Assets, Liabilities, Equity, Revenues, Expenses). Both columns are summed to confirm debit-credit equality.

Phase 2: Entering Adjusting Entries

Adjusting figures are placed in Columns 3 and 4 on the row of the relevant account. If an adjustment involves an account title not present on the unadjusted trial balance (e.g., Depreciation Expense or Salaries Payable ), the new account title is written on the lines immediately below the trial balance subtotal line. Crucially, each adjusting entry is tagged with an identifying letter key (e.g., ( a ) (a) ( a ) Dr. Supplies Expense / ( a ) (a) ( a ) Cr. Supplies).

Phase 3: Computing the Adjusted Trial Balance

Adjusted balances are computed by applying standard arithmetic rules across rows:

Debit + Debit = Add into Adjusted Trial Balance Debit \text{Debit} + \text{Debit} = \text{Add into Adjusted Trial Balance Debit} Debit + Debit = Add into Adjusted Trial Balance Debit

Credit + Credit = Add into Adjusted Trial Balance Credit \text{Credit} + \text{Credit} = \text{Add into Adjusted Trial Balance Credit} Credit + Credit = Add into Adjusted Trial Balance Credit

Debit + Credit Adjustment = Subtract (Place net amount in Debit if Dr > Cr, or Credit if Cr > Dr) \text{Debit} + \text{Credit Adjustment} = \text{Subtract (Place net amount in Debit if Dr} > \text{Cr, or Credit if Cr} > \text{Dr)} Debit + Credit Adjustment = Subtract (Place net amount in Debit if Dr > Cr, or Credit if Cr > Dr)

Credit + Debit Adjustment = Subtract (Place net amount in Credit if Cr > Dr, or Debit if Dr > Cr) \text{Credit} + \text{Debit Adjustment} = \text{Subtract (Place net amount in Credit if Cr} > \text{Dr, or Debit if Dr} > \text{Cr)} Credit + Debit Adjustment = Subtract (Place net amount in Credit if Cr > Dr, or Debit if Dr > Cr)

Columns 5 and 6 are summed to verify equality before proceeding.

Phase 4: Extending Amounts to Financial Statement Columns

Every single amount in the Adjusted Trial Balance is extended into exactly one of the four remaining statement columns:

Assets: Extend to Balance Sheet Debit (Col 9).

Contra-Assets (Accumulated Depreciation): Extend to Balance Sheet Credit (Col 10).

Liabilities: Extend to Balance Sheet Credit (Col 10).

Owner's Capital: Extend to Balance Sheet Credit (Col 10).

Owner's Drawing: Extend to Balance Sheet Debit (Col 9).

Revenues: Extend to Income Statement Credit (Col 8).

Expenses: Extend to Income Statement Debit (Col 7).

4. Phase 5: Balancing Net Income vs. Net Loss

Once accounts are extended, the Income Statement columns (Cols 7 & 8) and Balance Sheet columns (Cols 9 & 10) are independently totaled. Unlike the first three column pairs, these columns will not initially equal each other . +-----------------------------------------------------------------------------+

  • | NET INCOME VS. NET LOSS WORKSHEET BALANCING |
  • | |
  • | SCENARIO A: NET INCOME (Total Revenues > Total Expenses) |
  • | * Income Statement Credit (Rev) > Income Statement Debit (Exp) |
  • | * Balance Sheet Debit (Assets) > Balance Sheet Credit (Liab + Equity) |
  • | --> ACTION: Enter Net Income in: |
  • | 1. Income Statement DEBIT Column (Col 7) |
  • | 2. Balance Sheet CREDIT Column (Col 10) |
  • | |
  • | SCENARIO B: NET LOSS (Total Expenses > Total Revenues) |
  • | * Income Statement Debit (Exp) > Income Statement Credit (Rev) |
  • | * Balance Sheet Credit (Liab + Eq) > Balance Sheet Debit (Assets) |
  • | --> ACTION: Enter Net Loss in: |
  • | 1. Income Statement CREDIT Column (Col 8) |
  • | 2. Balance Sheet DEBIT Column (Col 9) |
  • +-----------------------------------------------------------------------------+

Important

The Cross-Verification Rule: The numerical difference between the Income Statement Debit and Credit columns MUST EXACTLY EQUAL the numerical difference between the Balance Sheet Debit and Credit columns. If these two difference figures are not identical, a calculation, extension, or transcription error has occurred.

5. Comprehensive 10-Column Worksheet Example

Below is a complete, fully reconciled 10-column worksheet for Highland Bookkeeping Services for the fiscal year ended December 31, 20X6.

Adjusting Information:

( a ) (a) ( a ) Physical count of supplies on Dec 31 shows $ 400 \text{\textdollar}400 $ 400 on hand (Supplies used: $ 1,500 − $ 400 = $ 1,100 \text{\textdollar}1{,}500 - \text{\textdollar}400 = \text{\textdollar}1{,}100 $ 1 , 500 − $ 400 = $ 1 , 100 ).

( b ) (b) ( b ) Unexpired prepaid insurance at year-end is $ 900 \text{\textdollar}900 $ 900 (Insurance expired: $ 2,400 − $ 900 = $ 1,500 \text{\textdollar}2{,}400 - \text{\textdollar}900 = \text{\textdollar}1{,}500 $ 2 , 400 − $ 900 = $ 1 , 500 ).

( c ) (c) ( c ) Annual straight-line depreciation on office equipment is $ 2,000 \text{\textdollar}2{,}000 $ 2 , 000 .

( d ) (d) ( d ) Accrued salaries unpaid at Dec 31 are $ 1,200 \text{\textdollar}1{,}200 $ 1 , 200 .

( e ) (e) ( e ) Consulting revenue earned from unearned retainer is $ 3,000 \text{\textdollar}3{,}000 $ 3 , 000 .

Account Title (1) Unadj TB Dr (2) Unadj TB Cr (3) Adjust Dr (4) Adjust Cr (5) Adj TB Dr (6) Adj TB Cr (7) IS Dr (8) IS Cr (9) BS Dr (10) BS Cr

Cash $ 14,200 \text{\textdollar}14{,}200 $ 14 , 200 $ 14,200 \text{\textdollar}14{,}200 $ 14 , 200 $ 14,200 \text{\textdollar}14{,}200 $ 14 , 200

Accounts Receivable $ 8,600 \text{\textdollar}8{,}600 $ 8 , 600 $ 8,600 \text{\textdollar}8{,}600 $ 8 , 600 $ 8,600 \text{\textdollar}8{,}600 $ 8 , 600

Supplies $ 1,500 \text{\textdollar}1{,}500 $ 1 , 500 ( a ) $ 1,100 (a)\,\text{\textdollar}1{,}100 ( a ) $ 1 , 100 $ 400 \text{\textdollar}400 $ 400 $ 400 \text{\textdollar}400 $ 400

Prepaid Insurance $ 2,400 \text{\textdollar}2{,}400 $ 2 , 400 ( b ) $ 1,500 (b)\,\text{\textdollar}1{,}500 ( b ) $ 1 , 500 $ 900 \text{\textdollar}900 $ 900 $ 900 \text{\textdollar}900 $ 900

Office Equipment $ 24,000 \text{\textdollar}24{,}000 $ 24 , 000 $ 24,000 \text{\textdollar}24{,}000 $ 24 , 000 $ 24,000 \text{\textdollar}24{,}000 $ 24 , 000

Accum. Depr.—Equip. $ 4,000 \text{\textdollar}4{,}000 $ 4 , 000 ( c ) $ 2,000 (c)\,\text{\textdollar}2{,}000 ( c ) $ 2 , 000 $ 6,000 \text{\textdollar}6{,}000 $ 6 , 000 $ 6,000 \text{\textdollar}6{,}000 $ 6 , 000

Accounts Payable $ 5,100 \text{\textdollar}5{,}100 $ 5 , 100 $ 5,100 \text{\textdollar}5{,}100 $ 5 , 100 $ 5,100 \text{\textdollar}5{,}100 $ 5 , 100

Unearned Revenue $ 4,500 \text{\textdollar}4{,}500 $ 4 , 500 ( e ) $ 3,000 (e)\,\text{\textdollar}3{,}000 ( e ) $ 3 , 000 $ 1,500 \text{\textdollar}1{,}500 $ 1 , 500 $ 1,500 \text{\textdollar}1{,}500 $ 1 , 500

Owner's Capital $ 28,000 \text{\textdollar}28{,}000 $ 28 , 000 $ 28,000 \text{\textdollar}28{,}000 $ 28 , 000 $ 28,000 \text{\textdollar}28{,}000 $ 28 , 000

Owner's Drawing $ 6,000 \text{\textdollar}6{,}000 $ 6 , 000 $ 6,000 \text{\textdollar}6{,}000 $ 6 , 000 $ 6,000 \text{\textdollar}6{,}000 $ 6 , 000

Service Revenue $ 32,000 \text{\textdollar}32{,}000 $ 32 , 000 ( e ) $ 3,000 (e)\,\text{\textdollar}3{,}000 ( e ) $ 3 , 000 $ 35,000 \text{\textdollar}35{,}000 $ 35 , 000 $ 35,000 \text{\textdollar}35{,}000 $ 35 , 000

Salaries Expense $ 13,500 \text{\textdollar}13{,}500 $ 13 , 500 ( d ) $ 1,200 (d)\,\text{\textdollar}1{,}200 ( d ) $ 1 , 200 $ 14,700 \text{\textdollar}14{,}700 $ 14 , 700 $ 14,700 \text{\textdollar}14{,}700 $ 14 , 700

Rent Expense $ 3,400 \text{\textdollar}3{,}400 $ 3 , 400 $ 3,400 \text{\textdollar}3{,}400 $ 3 , 400 $ 3,400 \text{\textdollar}3{,}400 $ 3 , 400

Supplies Expense ( a ) $ 1,100 (a)\,\text{\textdollar}1{,}100 ( a ) $ 1 , 100 $ 1,100 \text{\textdollar}1{,}100 $ 1 , 100 $ 1,100 \text{\textdollar}1{,}100 $ 1 , 100

Insurance Expense ( b ) $ 1,500 (b)\,\text{\textdollar}1{,}500 ( b ) $ 1 , 500 $ 1,500 \text{\textdollar}1{,}500 $ 1 , 500 $ 1,500 \text{\textdollar}1{,}500 $ 1 , 500

Depreciation Expense ( c ) $ 2,000 (c)\,\text{\textdollar}2{,}000 ( c ) $ 2 , 000 $ 2,000 \text{\textdollar}2{,}000 $ 2 , 000 $ 2,000 \text{\textdollar}2{,}000 $ 2 , 000

Salaries Payable ( d ) $ 1,200 (d)\,\text{\textdollar}1{,}200 ( d ) $ 1 , 200 $ 1,200 \text{\textdollar}1{,}200 $ 1 , 200 $ 1,200 \text{\textdollar}1{,}200 $ 1 , 200

SUBTOTALS $ 73,600 \text{\textdollar}73{,}600 $ 73 , 600 $ 73,600 \text{\textdollar}73{,}600 $ 73 , 600 $ 8,800 \text{\textdollar}8{,}800 $ 8 , 800 $ 8,800 \text{\textdollar}8{,}800 $ 8 , 800 $ 76,800 \text{\textdollar}76{,}800 $ 76 , 800 $ 76,800 \text{\textdollar}76{,}800 $ 76 , 800 $ 23,700 \text{\textdollar}23{,}700 $ 23 , 700 $ 35,000 \text{\textdollar}35{,}000 $ 35 , 000 $ 54,100 \text{\textdollar}54{,}100 $ 54 , 100 $ 41,800 \text{\textdollar}41{,}800 $ 41 , 800

Net Income $ 11,300 \text{\textdollar}11{,}300 $ 11 , 300 $ 11,300 \text{\textdollar}11{,}300 $ 11 , 300

TOTALS $ 35,000 \text{\textdollar}35{,}000 $ 35 , 000 $ 35,000 \text{\textdollar}35{,}000 $ 35 , 000 $ 54,100 \text{\textdollar}54{,}100 $ 54 , 100 $ 54,100 \text{\textdollar}54{,}100 $ 54 , 100

Mathematical Verification of Net Income:

Income Statement Difference = $ 35,000 − $ 23,700 = $ 11,300 (Net Income) \text{Income Statement Difference} = \text{\textdollar}35{,}000 - \text{\textdollar}23{,}700 = \text{\textdollar}11{,}300 \text{ (Net Income)} Income Statement Difference = $ 35 , 000 − $ 23 , 700 = $ 11 , 300 (Net Income) .

Balance Sheet Difference = $ 54,100 − $ 41,800 = $ 11,300 \text{Balance Sheet Difference} = \text{\textdollar}54{,}100 - \text{\textdollar}41{,}800 = \text{\textdollar}11{,}300 Balance Sheet Difference = $ 54 , 100 − $ 41 , 800 = $ 11 , 300 .

Both differences match perfectly, proving the mathematical integrity of the accounting worksheet.

Loading diagram... Account Extension and Worksheet Balancing Flow