Home › Templates
Free Excel templates
Working spreadsheets with formulas throughout, documented inputs and built-in checks. The accounting templates share one layout: Inputs, Schedule, Journal Entry, Reconciliation and Lists. All templates are free and require no registration.
Accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
- Budget to Actual Variance TemplateMonth and year-to-date variance report to net income, with thresholds, required explanations, a department summary and a ledger reconciliation.
Personal finance templates
Format
Files are standard .xlsx workbooks for Microsoft Excel and compatible spreadsheet software. They contain no macros. Entry cells are shaded; all other cells are formulas. Each file includes example data to be replaced.
Custom templates
A template can be built to your specification. Request a quote.
To report an error or request a calculator or template, send feedback.