20 Free Accounting Templates: Excel & Google Sheets Practice Workbooks

Download 20 professional accounting templates in Microsoft Excel (.xlsx) format with active native formulas, automated audit balance checks, and Google Sheets compatibility.

Home › Free Accounting Templates

Every template is pre-configured with active spreadsheet formulas (SUM, IF, ROUND, SLN, DDB, NPV, IRR), automated error-checking routines, and standard GAAP/IFRS financial formatting. Free to download with zero registration, paywalls, or email forms.

Financial Accounting .XLSX • 7.6 KB

Classified Balance Sheet Template

Report-form balance sheet with current/non-current asset & liability groupings.

Features automated balance checks (Assets = Liabilities + Equity), retained earnings statement integration, and dynamic financial ratio calculations (Current Ratio, Quick Ratio, Debt-to-Equity, and Working Capital).

  • Includes working formula validation: =IF(Assets=Liabilities+Equity, 'BALANCED', 'ERROR')
  • Auto-calculates Current, Quick, and Debt-to-Equity ratios
  • Pre-formatted in standard US GAAP / IFRS classified report layout
Financial Accounting .XLSX • 7.1 KB

Multi-Step Income Statement Template

Gross profit, operating income (EBIT), and net earnings breakdown.

Separates operating revenues and cost of goods sold from general selling, administrative expenses, interest, and income tax provisions. Features automated percentage margin calculations.

  • Dynamic formulas for Gross Profit, Operating Income, and Net Profit
  • Calculates Gross Margin %, Operating Margin %, and Net Profit Margin %
  • Pre-configured for retail merchandisers, wholesalers, and service businesses
Financial Accounting .XLSX • 6.9 KB

Cash Flow Statement Template (Indirect Method)

Reconciles net income to net cash flow across Operating, Investing, and Financing.

Standard corporate indirect cash flow statement with non-cash expense adjustments (depreciation, amortization), working capital change inputs (AR, inventory, AP), and net cash reconciliation.

  • Categorized into Operating, Investing, and Financing activities
  • Automated ending cash reconciliation check against the balance sheet
  • Color-coded input cells for clean financial reporting
Bookkeeping & Cash .XLSX • 6.7 KB

Three-Column Cash Book Template

Cash, Bank, and Discount columns for daily receipt and payment entries.

Daily primary entry book for small businesses and students. Features dual-side cash and bank accounts, discount allowed / discount received tracking, and running closing balance formulas.

  • Separate Dr (Receipts) and Cr (Payments) ledger sides
  • Auto-calculates discount totals and month-end cash/bank carry-forwards
  • Clean tabular grid with printable audit-ready format
Bookkeeping & Cash .XLSX • 7.4 KB

Bank Reconciliation Statement Template

Dual-column bank statement vs. company cash book audit schedule.

Reconciles deposits in transit, outstanding checks, bank service fees, NSF customer checks, interest income, and ledger recording errors. Includes an automated true cash equality verification check.

  • Side-by-side Bank Statement Balance vs. Company Book Balance
  • Automated equality check: =IF(AdjustedBank=AdjustedBook, 'RECONCILED', 'OUT OF BALANCE')
  • Includes dedicated adjusting journal entries reference table
Fixed Assets .XLSX • 6.9 KB

Fixed Asset Depreciation Comparison Template

Straight-Line vs. Double Declining Balance multi-year schedules.

Calculates annual depreciation expense, accumulated depreciation, and ending book value across a 10-year asset lifespan using native Excel =SLN and =DDB formulas with salvage value floor protection.

  • Side-by-side comparison of Straight-Line vs. Double Declining Balance
  • Protects book value from depreciating below estimated residual/salvage value
  • Includes asset disposal gain/loss calculator module
Bookkeeping & Cash .XLSX • 7.3 KB

Petty Cash Log & Imprest Reimbursement Template

Voucher receipt tracking, expense categorization, and lockbox reconciliation.

Manages physical petty cash floats. Records voucher receipts across Office Supplies, Postage, Travel, Meals, and Miscellaneous, with an automated lockbox cash count discrepancy audit.

  • Imprest fund replenishment formula calculates exact check requisition amount
  • Categorizes expenses for seamless monthly journal posting
  • Includes cash count audit module (bills and coins verification)
Cost & Managerial .XLSX • 7.2 KB

CVP & Break-Even Analysis Model Template

Contribution margin, break-even units, target profit, and sensitivity table.

Enter selling price, variable costs, and fixed overhead to compute Unit Contribution Margin, CM Ratio, Break-Even volume, and required sales for target profit, complete with a 10-tier volume sensitivity table.

  • Calculates Break-Even in both units and dollar revenue volume
  • Margin of Safety calculation based on current/projected sales
  • Includes 10-scenario volume-profit sensitivity schedule
Assets & Credit .XLSX • 7.5 KB

Accounts Receivable Aging Schedule Template

Aging buckets (0-30, 31-60, 61-90, 90+) and bad debt allowance estimator.

Tracks outstanding customer invoices across 0-30, 31-60, 61-90, and 90+ day aging buckets. Applies customizable default probability percentages to calculate year-end Bad Debt Expense adjustments.

  • Calculates total receivables per client and aging distribution
  • Allowance method calculator with customizable default loss percentages
  • Generates adjusting entry for Allowance for Doubtful Accounts
Bookkeeping & Cash .XLSX • 8.3 KB

General Journal & General Ledger Practice Template

Two-tab double-entry accounting practice workbook with T-accounts.

The ultimate hands-on accounting practice workbook. Tab 1 offers a formatted general journal with automated trial balance parity checks. Tab 2 provides structured T-Account ledger postings with running balances.

  • Tab 1: General Journal with automated Dr = Cr balance check
  • Tab 2: Interactive T-Accounts (Cash, AR, Inventory, AP, Equity, Revenues, Expenses)
  • Perfect for introductory accounting homework and CPA cycle drills
Bookkeeping & Cash .XLSX • 6.7 KB

Monthly Cash Budget & Liquidity Forecast Template

6-month rolling operational cash receipt and disbursement forecasting schedule.

Tracks planned cash sales, customer receivables collections, operational disbursements (supplier AP, payroll, lease, utilities, taxes, and CapEx), with dynamic opening/closing cash carry-forward and liquidity buffer alerts.

  • Auto-calculates monthly net cash flow and ending cash position
  • Formula: Ending Cash = Beginning Cash + Cash Receipts − Disbursements
  • Carries closing balance forward as next month’s opening balance
Bookkeeping & Cash .XLSX • 6.1 KB

Accounts Payable Aging & Payment Schedule Template

Vendor invoice tracking with 30, 60, and 90+ day aging buckets.

Organizes supplier liabilities by invoice date, payment terms (Net 30, 2/10 Net 30), and aging brackets. Includes cash discount optimization tracker and overdue payment alerts.

  • Automated aging bracket sorting and percentage of total payables
  • Optimizes 2/10 early settlement discounts to save operating cash
  • Pre-formatted for vendor statement reconciliations
Payroll & Tax .XLSX • 6.1 KB

Employee Payroll Register & Tax Deductions Tracker

Comprehensive gross-to-net payroll journal with automated tax withholdings.

Computes employee gross pay from hourly rates and hours worked, calculates Federal withholding (15%), Social Security (6.2%), Medicare (1.45%), voluntary health/401(k) deductions, and net take-home pay.

  • Native formulas: Gross = Rate × Hours, Net = Gross − Total Deductions
  • Automated employer payroll tax liabilities breakdown
  • Formatted for period-end payroll journal entries
Cost Accounting .XLSX • 5.9 KB

Perpetual Inventory Valuation Schedule (FIFO & Weighted Avg)

Date-by-date perpetual inventory ledger with purchases, COGS, and ending inventory.

Tracks physical inventory flow under First-In First-Out (FIFO) and moving Weighted Average methods. Compares cost of goods sold and closing inventory valuation during inflationary periods.

  • Dynamic receipt, issue, and balance calculation columns
  • Automated Cost of Goods Sold and Ending Inventory valuation
  • Side-by-side FIFO vs Average cost comparison
Cost Accounting .XLSX • 6.4 KB

Job Order Cost Sheet & Overhead Allocation Template

Direct materials, direct labor, and predetermined overhead allocation tracker.

Tracks material requisitions, direct labor time tickets, and applies manufacturing overhead based on predetermined rates (POHR per direct labor hour). Calculates total manufacturing job cost and unit cost.

  • Computes Prime Cost (DM + DL) and Total Manufacturing Cost
  • Automated overhead application: =Direct Labor Hours × POHR
  • Computes finished unit cost and markup profit pricing
Financial Accounting .XLSX • 6.4 KB

Ten-Column Comprehensive Accounting Worksheet Template

Master 10-column year-end closing worksheet from Trial Balance to Balance Sheet.

The classic accountant’s closing tool: spans Unadjusted Trial Balance (Dr/Cr), Adjusting Entries (Dr/Cr), Adjusted Trial Balance (Dr/Cr), Income Statement (Dr/Cr), and Balance Sheet (Dr/Cr) with automated net income balancing.

  • Five 2-column paired accounting sections (10 columns total)
  • Automated net income balancing entry across Income Statement and Balance Sheet
  • Pre-loaded with standard general ledger accounts
Managerial Accounting .XLSX • 6.4 KB

Annual Operating Expense Budget vs. Actual Variance Model

Departmental expense monitoring with dollar and percentage variance tracking.

Monitors annual overhead across Executive Salaries, Marketing, Lease/Rent, Cloud IT, Travel, Legal, and Benefits. Calculates exact dollar variances ($) and percentage variances (%), with automated Favorable/Unfavorable indicators.

  • Formula: Dollar Variance = Actual − Budget, % Variance = Variance / Budget
  • Automated logic: =IF(Variance<=0, 'FAVORABLE', 'UNFAVORABLE')
  • Pre-formatted executive summary row with total spending analysis
Cost Accounting .XLSX • 6.1 KB

Standard Costing & Direct Manufacturing Variance Analysis

Calculates Direct Material Price/Quantity and Labor Rate/Efficiency variances.

Reconciles actual manufacturing costs against standard cost baselines. Computes Material Price Variance (SP − AP) × AQ, Material Quantity Variance (SQ − AQ) × SP, Labor Rate Variance (SR − AR) × AH, and Labor Efficiency Variance.

  • Step-by-step 4-way variance calculation engine
  • Auto-reconciles standard cost to actual cost incurred
  • Formatted for cost accounting exams and managerial control
Corporate Finance .XLSX • 6.4 KB

Capital Budgeting & Project Evaluation Model (NPV, IRR & Payback)

Multi-year project appraisal model computing NPV, IRR, and Discounted Payback.

Evaluates long-term capital investments and equipment acquisitions. Analyzes multi-year cash flow projections using discounted cash flow (DCF), Net Present Value (=NPV), Internal Rate of Return (=IRR), and Profitability Index (PI).

  • Dynamic discount factor discounting =1/(1+WACC)^t
  • Native =IRR and =NPV formulas with customizable cost of capital
  • Automated cash recovery payback period indicator
Financial Analysis .XLSX • 6.7 KB

Financial Ratio Analysis Dashboard & DuPont ROE Model

Two-year comparative financial ratio scorecard with healthy benchmark ratings.

Enter 2-year Balance Sheet and Income Statement figures to automatically generate 10 essential financial ratios across Liquidity, Profitability, Solvency, and Efficiency, complete with DuPont 3-stage ROE breakdown.

  • Computes Current, Quick, Working Capital, Gross/Net Margins, ROE, Debt-to-Equity, and DSO
  • Includes healthy industry benchmark comparisons
  • Visual color-coded health rating badges

How to Open & Use in Google Sheets (Free)

All templates are built in open standard Microsoft Excel (.xlsx) format and are 100% compatible with Google Sheets, Apple Numbers, and LibreOffice Calc. Follow these simple steps:

1
Download .XLSX

Click any “Download Excel (.xlsx)” button above to save the workbook to your computer or phone.

2
Upload to Google Drive

Open Google Drive, click + New → File upload, and select the downloaded file.

3
Open in Sheets

Double-click the file in Drive and select Open with Google Sheets. All native formulas and conditional styling will transfer seamlessly.

4
Practice & Personalize

Enter your figures into the input cells. The automated audit checks will verify your balance equality in real time.

Printable Accounting PDF Cheat Sheets & Study Guides

Prefer printable study sheets? Download our free quick-reference guides:

Browse All 6 Cheat Sheets →
Master Rules

DEALER Debit & Credit Rules Master Sheet

PDF • 6.7 KB
Download PDF
Formulas

Financial Ratios & Formulas Formula Sheet

PDF • 5.0 KB
Download PDF
Process

8-Step Accounting Cycle & Adjusting Entries

PDF • 5.1 KB
Download PDF
Controls

Bank Reconciliation Master Study Guide

PDF • 5.2 KB
Download PDF
Costing

Inventory Costing: FIFO vs LIFO vs Weighted Avg

PDF • 5.7 KB
Download PDF
Fixed Assets

Depreciation Methods & Asset Disposal Guide

PDF • 5.2 KB
Download PDF

Interactive Accounting Labs & Online Simulators

Looking to test your accounting skills in real-time without downloading a spreadsheet? Practice double-entry bookkeeping, trial balance equality, and financial modeling with our free interactive web apps:

Frequently Asked Questions

Are all 20 accounting templates completely free for personal and commercial use?

Yes, 100% free with zero paywalls, no trial expirations, and no email registration. You can download and use all 20 templates for academic coursework, CPA exam prep, internal corporate reporting, or managing small business books.

How do I open and use these .xlsx templates in Google Sheets?

Every template is built in open standard Microsoft Excel (.xlsx) format, which imports natively into Google Sheets. In Google Drive, click ‘+ New’ > ‘File upload’, choose the downloaded template, right-click the file, and select ‘Open with’ > ‘Google Sheets’. All formulas and cell formatting transfer automatically.

Do these templates include working spreadsheet formulas and audit balance checks?

Yes. Every template includes active native formulas (=SUM, =IF, =ROUND, =SLN, =DDB, =NPV, =IRR), automatic subtotals, and live balance verification indicators that alert you if figures are out of balance (e.g. Assets ≠ Liabilities + Equity).

Can I add, remove, or customize rows and account titles for my business?

Yes. None of the worksheets are locked or password-protected. You can freely insert new rows, modify the chart of accounts, adjust tax rates, or update formulas to fit your specific company structure or syllabus.

Which templates should beginners start with versus advanced corporate finance students?

Beginners and bookkeeping students should start with the General Journal & Ledger Template (#10), Three-Column Cash Book (#4), and Bank Reconciliation (#5). Advanced students and financial analysts should explore the 10-Column Accounting Worksheet (#16), Capital Budgeting Model (#19), and Financial Ratio Analysis Dashboard (#20).

How do these downloadable templates connect with the Trial Balance Lab and Statement Generator?

The templates provide offline, editable workbooks for day-to-day bookkeeping and class assignments, while our web-based Trial Balance Mini-Lab and Financial Statement Generator let you simulate and test balance scenarios directly in your browser without opening a spreadsheet.

What should I do if an audit balance check shows an error or out-of-balance warning?

If a balance sheet or trial balance shows an ‘OUT OF BALANCE’ warning, check three common culprits: 1) Verify that ending retained earnings includes the current period net income minus dividends; 2) Ensure contra-assets (accumulated depreciation, allowance for doubtful accounts) are subtracted, not added; and 3) Verify that debits equal credits in the supporting journal.

Explore More Free Accounting Resources

Disclaimer: These templates and tools are designed for general academic study, bookkeeping practice, and business planning. Always verify financial reports against applicable GAAP/IFRS standards and your local statutory reporting regulations.