Accounts receivable aging report with doubtful account allowance
Age open invoices into buckets by days past due, then estimate the allowance for doubtful accounts and DSO.
4 tabs · 1,105 formulas
Templates
Accounting spreadsheet templates
Month-end and year-end workpapers with the arithmetic done in the open. Reconcile a bank statement to the general ledger, run depreciation by straight-line, declining balance or sum-of-the-years'-digits, age receivables into buckets and estimate an allowance, map a trial balance into an income statement and balance sheet that must balance, and amortize prepaid expenses and accruals month by month.
Each workpaper ends in a check that has to come to zero. The templates follow common US practice; confirm treatment and tax depreciation rules with your accountant.
Bank reconciliation template
Reconcile a bank statement to the general ledger with reconciling items, adjusted balances and journal entries.
3 tabs · 137 formulas
Financial ratio analysis dashboard (three years)
Twenty ratios for three fiscal years with trends, targets, a DuPont breakdown and a scorecard, for an example distributor.
5 tabs · 381 formulas
Fixed asset register and depreciation schedule
Straight-line, declining balance and sum-of-the-years'-digits depreciation for each asset, by fiscal year.
4 tabs · 1,320 formulas
Prepaid expense and accrual amortization schedule
Amortize prepaid expenses by month and track accrual reversals against a close month.
4 tabs · 929 formulas
Trial balance to income statement and balance sheet
Map a trial balance to an income statement and balance sheet, with checks that the books balance.
4 tabs · 512 formulas