Accounts payable payment planner
List supplier bills with partial payments, remaining balances, and days until their due dates.
2 tabs · 186 formulas
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.
List supplier bills with partial payments, remaining balances, and days until their due dates.
2 tabs · 186 formulas
Age open invoices into buckets by days past due, then estimate the allowance for doubtful accounts and DSO.
4 tabs · 1,105 formulas
Reconcile a bank statement to the general ledger with reconciling items, adjusted balances and journal entries.
3 tabs · 137 formulas
Record contractor service payments, reimbursed expenses, backup withholding, and amounts exceeding a reporting threshold.
2 tabs · 246 formulas
Track upfront customer billings, service period length, elapsed months, recognized revenue, and remaining deferred balances.
2 tabs · 246 formulas
Record employee expenses, approved amounts, reimbursements paid, and the balance still owed.
2 tabs · 186 formulas
Twenty ratios for three fiscal years with trends, targets, a DuPont breakdown and a scorecard, for an example distributor.
5 tabs · 381 formulas
Straight-line, declining balance and sum-of-the-years'-digits depreciation for each asset, by fiscal year.
4 tabs · 1,320 formulas
Track issued invoices, payments received, outstanding balances, and overdue days at a fixed review date.
2 tabs · 186 formulas
Calculate trip distance, business miles, and reimbursement using the rate entered for each trip.
2 tabs · 246 formulas
Reconcile petty cash by denomination, comparing expected cash with a physical count and recording the variance.
2 tabs · 246 formulas
Amortize prepaid expenses by month and track accrual reversals against a close month.
4 tabs · 929 formulas
Compare a manually calculated sales tax amount with tax actually collected on each sales batch.
2 tabs · 186 formulas
Compare purchase order quantities and unit prices with goods receipt quantities and billed invoice amounts.
2 tabs · 306 formulas
Map a trial balance to an income statement and balance sheet, with checks that the books balance.
4 tabs · 512 formulas