If you freelance, run a SaaS side project, or manage a small agency, you've probably done this: open a spreadsheet at 11 PM, copy a formula from an old file, and hope the totals are right.
Accounting math isn't hard, but it is repetitive and easy to get wrong: a wrong sign on a variance, tax calculated on the wrong base, or an overdue invoice put in the wrong bucket.
In this post I'll walk through 7 common accounting calculations, show the formulas (with JavaScript snippets for the devs), and link to free online calculators that handle each one without a spreadsheet.
๐งฐ All 7 tools in one place: Free Online Accounting Tools on Noloii
1. Accounts Receivable Aging
Aging groups unpaid invoices by how long they've been outstanding. It tells you who to chase first.
| Bucket | Example balance |
|---|---|
| Current | $3,000 |
| 1โ30 days overdue | $1,200 |
| 31โ60 days overdue | $800 |
| 61โ90 days overdue | $400 |
function agingBucket(daysOverdue) {
if (daysOverdue <= 0) return "Current";
if (daysOverdue <= 30) return "1โ30";
if (daysOverdue <= 60) return "31โ60";
if (daysOverdue <= 90) return "61โ90";
return "90+";
}
console.log(agingBucket(45)); // "31โ60"
Tip: decide whether you age from the invoice date or the due date, and stay consistent.
๐ Accounts Receivable Aging Calculator
2. Invoice Late Fees
A late fee depends on the balance, the days overdue and the rate in your agreement. A simple annualized version:
const lateFee = (balance, annualRate, daysOverdue) =>
balance * annualRate * (daysOverdue / 365);
console.log(lateFee(2000, 0.18, 45).toFixed(2)); // "44.38"
Note that whether a late fee is allowed, and how it's calculated, depends on your contract and local law. Check before you invoice it.
๐ Invoice Late Fee Calculator
3. Budget vs Actual Variance
Variance = Actual โ Budget
If budgeted expenses are $5,000 and actual expenses are $5,600, the variance is +$600 (12% over budget).
const variance = (actual, budget) => ({
amount: actual - budget,
percent: ((actual - budget) / budget) * 100,
});
console.log(variance(5600, 5000)); // { amount: 600, percent: 12 }
The sign alone doesn't tell you if it's good or bad. Revenue above budget is favorable, but expenses above budget usually aren't.
๐ Budget vs Actual Calculator
4. Sales Tax (Inclusive vs Exclusive)
// Tax-exclusive: price + tax
const addTax = (price, rate) => price * (1 + rate);
// Tax-inclusive: extract the tax from a total
const extractTax = (total, rate) => {
const net = total / (1 + rate);
return { net, tax: total - net };
};
console.log(addTax(100, 0.08)); // 108
console.log(extractTax(108, 0.08)); // { net: 100, tax: 8 }
The classic bug is multiplying a tax-inclusive total by the rate instead of dividing by 1 + rate.
๐ Sales Tax Calculator
5. Billable Hours & Revenue
Revenue = Billable Hours ร Hourly Rate
30 billable hours at $80/hour is $2,400 before discounts, taxes and collection issues. Pair it with a utilization figure (billable hours รท available hours) to see how much of your time actually earns money.
const billableRevenue = (hours, rate) => hours * rate;
const utilization = (billableHours, availableHours) =>
(billableHours / availableHours) * 100;
console.log(billableRevenue(30, 80)); // 2400
console.log(utilization(30, 40)); // 75
๐ Billable Hours & Revenue Calculator
6. Expense Reimbursements
Mileage, travel, meals and lodging add up fast. Totalling eligible expenses by category (and checking them against your policy limits) keeps reimbursement requests clean and easy to approve.
๐ Expense Reimbursement Calculator
7. Depreciation Schedules
Depreciation spreads an asset's cost over its useful life.
Straight-line:
Annual Depreciation = (Cost โ Residual Value) รท Useful Life
A $12,000 asset with a $2,000 residual value and a 5-year life depreciates $2,000 per year.
Declining-balance:
function decliningBalance(cost, residual, years, factor = 2) {
const rate = factor / years;
let book = cost;
const schedule = [];
for (let year = 1; year <= years; year++) {
const dep = Math.max(0, Math.min(book * rate, book - residual));
book -= dep;
schedule.push({ year, depreciation: dep, bookValue: book });
}
return schedule;
}
console.table(decliningBalance(12000, 2000, 5));
๐ Depreciation Schedule Calculator
A Quick Checklist Before You Trust Any Number
- โ Are your source records current?
- โ Are currencies and reporting periods consistent?
- โ Did you use the right method (aging date, tax-inclusive vs exclusive, depreciation method)?
- โ Did you reconcile the result with your ledger or invoices?
These calculators give you fast, consistent estimates, but they don't replace accounting software or professional advice for tax filings and formal financial statements.
Try Them Out
All seven calculators are free and run in your browser:
๐ noloii.com/business-office-tools/accounting-tools
Related collections on the same site:
Your Turn ๐ฌ
Which accounting calculation do you do most often: AR aging, sales tax, or depreciation? And is there a calculator you wish existed? Tell me in the comments and I'll consider building it next.
If this was useful, a โค๏ธ or ๐ฆ and a bookmark help other freelancers and founders find it too.
Top comments (0)