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.
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
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
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
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
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 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
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)
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
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
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
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
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
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
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
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
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
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
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
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 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:
Click any “Download Excel (.xlsx)” button above to save the workbook to your computer or phone.
Open Google Drive, click + New → File upload, and select the downloaded file.
Double-click the file in Drive and select Open with Google Sheets. All native formulas and conditional styling will transfer seamlessly.
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:
DEALER Debit & Credit Rules Master Sheet
PDF • 6.7 KBFinancial Ratios & Formulas Formula Sheet
PDF • 5.0 KB8-Step Accounting Cycle & Adjusting Entries
PDF • 5.1 KBBank Reconciliation Master Study Guide
PDF • 5.2 KBInventory Costing: FIFO vs LIFO vs Weighted Avg
PDF • 5.7 KBDepreciation Methods & Asset Disposal Guide
PDF • 5.2 KBFrequently 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
- ← 17 Financial Calculators
- Trial Balance Mini-Lab
- Financial Statement Generator
- Debit vs Credit Speed Drill
- T-Account & Ledger Visualizer
- 100 Accounting Terms Flashcards
- Worked Problems & Solutions
- Printable PDF Cheat Sheets
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.