Free tools for accountants
Calculators that show their formulas, reference tables from the official source, and templates to adapt. They run in your browser, and results copy straight into Excel.
Calculators
Depreciation and tax
- CalculatorDepreciation calculatorStraight-line, declining balance, sum-of-the-years'-digits, units of production, and MACRS from the IRS tables.
- CalculatorStraight-line depreciation calculatorAnnual and monthly straight-line depreciation, partial first years, the entry to post and the Excel SLN check.
- CalculatorMACRS depreciation calculatorTax depreciation from the IRS Publication 946 tables, with section 179 and bonus depreciation applied first.
- CalculatorSection 179 calculatorThis year's section 179 deduction: dollar limit, phase-out, business income limit, SUV cap and carryover.
- Calculator1099 checkerWhether a payment needs a Form 1099-NEC or 1099-MISC, which box, and when it's due, at the $2,000 threshold.
Investment, loans and interest
- CalculatorPresent value calculatorPresent value of a future amount or a series of payments, with the formula and a schedule.
- CalculatorNPV and IRR calculatorNet present value, IRR, MIRR, payback and profitability index, with an Excel check.
- CalculatorIRR calculatorInternal rate of return for uneven cash flows, its annual equivalent, MIRR and the matching Excel formula.
- CalculatorPayback period calculatorSimple and discounted payback for even or uneven cash flows, with the cumulative schedule.
- CalculatorLoan amortization schedulePayment, interest and balance for each period, extra principal, a yearly summary and an Excel template.
- CalculatorAccrued interest calculatorInterest earned or owed between two dates on Actual/365, Actual/360 or 30/360, with the entry to post.
Margins and financial ratios
- CalculatorGross margin calculatorGross margin, gross profit and markup from price and cost, or the price that hits a target margin.
- CalculatorBreak-even calculatorBreak-even units and sales from fixed costs, price and variable cost, plus the volume for a target profit.
- CalculatorEBITDA calculatorEBITDA and EBIT built up from net income, with the EBITDA margin.
- CalculatorCurrent ratio calculatorCurrent assets over current liabilities, with working capital.
- CalculatorQuick ratio calculatorThe acid-test ratio: cash, marketable securities and receivables over current liabilities.
- CalculatorInventory turnover calculatorTurnover from cost of goods sold and average inventory, with days in inventory.
- CalculatorDSO calculatorDays sales outstanding and receivables turnover from average receivables and credit sales.
Reference tables
- TableMACRS depreciation tablesIRS Publication 946 Tables A-1 to A-7a: half-year, mid-quarter and real property rates.
- TableFinancial ratios cheat sheetLiquidity, activity, leverage and profitability ratios on one printable page: the formula and what each one measures.
- TablePresent value tablesPresent value of $1, ordinary annuity and annuity due, and future value factors, 1% to 20%.
Templates
Bookkeeping
- TemplateJournal entry templateA journal entry form for Excel with header, support, approvals and a check that debits equal credits.
- TemplateGeneral ledger templateA transaction ledger with running balances by account and a trial balance that builds itself.
- TemplateTrial balance templateUnadjusted balances, adjusting entries and an adjusted trial balance, with balance checks.
- TemplateChart of accounts templateA numbered starting chart for a small U.S. business, with type, statement and normal balance.
Close and reconciliation
- TemplateBank reconciliation templateReconcile online or in Excel: deposits in transit, outstanding checks, fees and errors, with the entries to post.
- TemplateMonth-end close checklistClose tasks by account area with owners, due workdays and status. Track it here or in Excel.
- TemplateAccount reconciliation templateReconcile any balance sheet account to its support, with reconciling items and sign-offs.
- TemplateYear-end close checklistThe year-end tasks on top of a month-end close, with owners, due dates and status.
Receivables, payables and fixed assets
- TemplateAR aging report templateOpen customer invoices by days past due, in aging buckets, with totals.
- TemplateAP aging report templateOpen vendor invoices by days past due, in aging buckets, with totals.
- TemplateFixed asset register templateAssets with cost, life and location, and straight-line depreciation to any date.
Cash and forecasting
For accounting and tax firms
- TemplateSection 7216 consent form generatorA consent to use or disclose tax return information, with Rev. Proc. 2013-14's required wording. Print-ready.
- TemplateEngagement letter AI clausesClauses for your engagement letter on how the firm uses AI, review, providers and client consent.
- TemplateAI acceptable use policy templateA starting AI policy for accounting and tax firms. Copy or print it.
- TemplateAI vendor questionnaireThe questions to send a vendor before client data goes in.
- TemplateWISP templateThe IRS outline for a tax practice's written information security plan, section by section.
How these tools are built
Where a tool uses official figures, such as the IRS MACRS percentages or the ASC 842 measurement rules, the page quotes and links the source and shows the date it was last reviewed. The calculators’ math is covered by automated tests, run on each proposed change, that check results against published examples and closed-form formulas. If you find an error, the about page explains how to report it.