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.

TemplateAccounting

Accounts payable payment planner

List supplier bills with partial payments, remaining balances, and days until their due dates.

2 tabs · 186 formulas

TemplateAccounting

Bank reconciliation template

Reconcile a bank statement to the general ledger with reconciling items, adjusted balances and journal entries.

3 tabs · 137 formulas

TemplateAccounting

Contractor payment and threshold tracker

Record contractor service payments, reimbursed expenses, backup withholding, and amounts exceeding a reporting threshold.

2 tabs · 246 formulas

TemplateAccounting

Deferred revenue recognition schedule

Track upfront customer billings, service period length, elapsed months, recognized revenue, and remaining deferred balances.

2 tabs · 246 formulas

TemplateAccounting

Expense reimbursement log

Record employee expenses, approved amounts, reimbursements paid, and the balance still owed.

2 tabs · 186 formulas

TemplateAccounting

Invoice payment tracker

Track issued invoices, payments received, outstanding balances, and overdue days at a fixed review date.

2 tabs · 186 formulas

TemplateAccounting

Mileage reimbursement tracker

Calculate trip distance, business miles, and reimbursement using the rate entered for each trip.

2 tabs · 246 formulas

TemplateAccounting

Petty cash reconciliation

Reconcile petty cash by denomination, comparing expected cash with a physical count and recording the variance.

2 tabs · 246 formulas

TemplateAccounting

Three-way PO and invoice match

Compare purchase order quantities and unit prices with goods receipt quantities and billed invoice amounts.

2 tabs · 306 formulas