New plan10 templates a month$9/month, cancel anytime

Start your plan
Check Register watermarked preview
Accounting & Bookkeeping · Cash Flow & Petty Cash

Check Register

Track checks written with automatic balance updates and transaction reconciliation.

A check register template that records every check written with date, check number, payee description, and amounts. It automatically calculates running balances using formulas, helping you track cash outflows and maintain accurate account records. Perfect for small businesses, nonprofits, and individuals who need to monitor checking account activity and reconcile statements.

What's inside

  • Automatic running balance calculation
  • Check number and date tracking
  • Debit/credit transaction columns
  • Transaction description field
  • Balance formula with IF/AND functions
  • Blank row detection for data entry
#check tracking#cash management#bank reconciliation#accounting#balance tracking

Download this template

.xlsx · 1 sheet

$9/monthDownload up to 10 templates a month from a library of thousands. Cancel anytime.

  • 10 downloads every month
  • Cancel anytime
  • 14-day refund policy

More in Accounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule previewAccounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule

A fixed assets register template in Excel with a depreciation schedule: track each asset's location and custodian, depreciate monthly by straight-line, declining balance or sum-of-years' digits, record disposals with gain or loss, and produce the year-end roll-forward and net book value report.

  • 10 tabs, from a quick-start guide to the depreciation engine
  • Asset register with location, custodian, supplier and serial or tag
  • Straight-line, declining balance and sum-of-years' digits
intermediate.xlsx
Bank CSV to Ledger Bookkeeping & Reconciliation previewAccounting & Bookkeeping

Bank CSV to Ledger Bookkeeping & Reconciliation

A bookkeeping system in Excel that turns raw bank and card CSV exports into categorized double-entry books, flags duplicates, missing lines and other errors automatically, and reconciles every account.

  • 14 connected tabs, from a quick-start guide to Settings
  • Paste raw bank and card CSV exports as downloaded
  • CSV profiles for any bank layout, date and number format
intermediate.xlsx
Balance Sheet with Ratios and Working Capital previewAccounting & Bookkeeping

Balance Sheet with Ratios and Working Capital

Track financial position and calculate key liquidity ratios to assess business solvency instantly.

  • Current ratio calculation
  • Quick ratio formula
  • Cash ratio tracking
intermediate.xlsx
Statement of Total Recognised Gains and Losses previewAccounting & Bookkeeping

Statement of Total Recognised Gains and Losses

Financial statement tracking all recognised gains and losses for a complete accounting period.

  • Year-end comparative reporting structure
  • Line items for operating and non-operating gains/losses
  • Multi-period comparison columns
intermediate.xlsx