Templates & Business Workflows

Build a balance sheet in Excel from your account balances with SUMIFS: current and non-current lines, a balance check, retained earnings and ratios.

Build an accounts payable aging report in Excel: due dates, days past due, aging buckets, a SUMIFS vendor summary, cash plan and ledger tie-out. Free template.

Free prepaid expense amortization schedule in Excel: months used, balance, monthly expense to the cent, a full-year grid and the month-end journal entry.

Build a trial balance in Excel from your general ledger with SUMIFS: debit and credit columns, automatic error checks, net income and a free template.

Free Excel petty cash log template: record vouchers, keep a running balance, count the cash, reconcile the imprest fund and create the replenishment entry.

Create an Excel data validation drop-down list from a Table that expands automatically when you add items, plus a check for pasted entries the list missed.

Create an inventory cycle count in Excel with blind counts, recounts, unit and value variances, investigation notes, and a follow-up schedule. Download the free template.

Calculate hours worked in Excel with lunch breaks and overnight shifts, total the week with [h]:mm, and work out overtime and gross pay. Free timesheet.

Build a depreciation schedule in Excel with SLN and DDB formulas, accumulated depreciation, book value and an asset register by in-service date. Free template.

Do a break-even analysis in Excel: contribution margin, break-even point formula in units and sales, target profit, a break-even chart and Goal Seek.