Blog · Finance metrics and formulas · Finance and FP&A teams
Financial analysis for small business connects profit, bank cash and customer payment timing. Follow a worked review using accounting exports, margin calculations and a cash reconciliation.
Financial analysis for small business connects monthly profit, bank cash and unpaid customer invoices so an owner can choose the next action. Begin with accounting exports that already exist, then reconcile the totals before interpreting trends. A compact review is enough when every change can be traced to a cost category, customer or payment.
Export the income statement, balance sheet, reconciled bank cash and accounts receivable aging at each month end. Keep an invoice register and customer receipts export available for follow-up. Use one company, one currency and the same accounting basis throughout.
The SBA's finance guidance describes the balance sheet as a snapshot of business assets, liabilities and equity. Use that snapshot alongside the income statement: one reports balances at a date, while the other reports performance over a period.
Label any changes made during the close, including credit memos, inventory adjustments and costs moved between categories. An owner-operated company may have limited finance time, but a changed classification still needs an explanation. Otherwise an apparent improvement may be bookkeeping rather than better trading.
A US commercial-supplies company reviews January through March 2027. It buys and resells products, invoices some sales on credit and collects the rest immediately. Cost of goods sold uses the same purchasing and freight categories each month. Operating expenses cover labor, rent and administration below gross profit.
Amounts are exact whole dollars. Displayed ratios are rounded to one decimal place, using unrounded inputs.
| Month | Revenue (USD) | Cost of goods sold (USD) | Operating expenses (USD) | Gross profit (USD) | Gross margin | Operating profit (USD) |
|---|---|---|---|---|---|---|
| January | 120,000 | 72,000 | 30,000 | 48,000 | 40.0% | 18,000 |
| February | 135,000 | 83,700 | 32,000 | 51,300 | 38.0% | 19,300 |
| March | 150,000 | 99,000 | 33,000 | 51,000 | 34.0% | 18,000 |
| Quarter | 405,000 | 254,700 | 95,000 | 150,300 | 37.1% | 55,300 |
Using the displayed order as columns A through G, put January in row 2. Calculate gross profit in E2, margin in F2 and operating profit in G2:
=B2-C2
=IF(B2=0,NA(),E2/B2)
=E2-D2
Fill down through March. The quarter's margin is =SUM(E2:E4)/SUM(B2:B4), not the average of the monthly percentages. The gross profit margin guide explains the denominator and cost definitions in detail.
Revenue grew 25.0% from January to March, but gross margin fell by 6.0 percentage points. March gross profit is only $3,000 above January, and operating profit is unchanged. That is a specific investigation: did discounts, supplier costs or the mix of products absorb the extra sales?
The cash export produces a different picture. Supplier payments can differ from cost of goods sold because bills are paid in a different month. Equipment payments and loan principal belong in the cash review even though they are not operating expenses in the table above.
This simplified example has no depreciation, income tax, owner distributions or other cash movements. Operating expenses are paid in the month recorded; inventory balances are unchanged. Loan payments shown here are principal only.
| Month | Customer receipts (USD) | Supplier payments (USD) | Other operating payments (USD) | Equipment payments (USD) | Loan principal paid (USD) | Cash movement (USD) | Closing bank cash (USD) |
|---|---|---|---|---|---|---|---|
| January | 115,000 | 70,000 | 30,000 | 0 | 5,000 | 10,000 | 70,000 |
| February | 120,000 | 84,000 | 32,000 | 10,000 | 5,000 | -11,000 | 59,000 |
| March | 130,000 | 104,000 | 33,000 | 0 | 5,000 | -12,000 | 47,000 |
| Quarter | 365,000 | 258,000 | 95,000 | 10,000 | 15,000 | -13,000 | 47,000 |
Opening bank cash is $60,000. With these columns A through H on a separate sheet, G2 is =B2-SUM(C2:F2) and H2 is =60000+G2. In H3 enter =H2+G3 and fill down.
The quarter check is $60,000 + $365,000 − $378,000 = $47,000. Match that to the reconciled bank balance, with outstanding checks and deposits handled consistently. A positive quarter operating profit of $55,300 has coincided with a $13,000 cash decrease; the next step is to explain the difference.
Under accrual accounting, sales are recorded when earned rather than when cash arrives; IRS Publication 538 explains this timing distinction. Separate credit sales from immediately paid sales when checking receivables.
| Month | Credit sales (USD) | Credit-customer receipts (USD) | Closing receivables (USD) | Days in month | Closing-balance DSO (days) |
|---|---|---|---|---|---|
| January | 90,000 | 85,000 | 45,000 | 31 | 15.5 |
| February | 105,000 | 90,000 | 60,000 | 28 | 16.0 |
| March | 120,000 | 100,000 | 80,000 | 31 | 20.7 |
The company began with $40,000 of receivables. Its quarter reconciliation is $40,000 + $315,000 of credit sales − $275,000 of collections = $80,000. The example has no write-offs, credit memos or other receivable adjustments; a real export needs those movements too.
With the displayed columns A through F, the DSO formula in F2 is:
=IF(B2=0,NA(),D2/B2*E2)
The days sales outstanding guide covers the metric's limitations. Here it flags a payment-timing question; it does not prove delinquency. Open the aging report and check contractual due dates, invoice disputes and whether a large late-month sale explains the balance.
Receivables absorbed $40,000. Supplier payments of $258,000 exceeded cost of goods sold of $254,700 by $3,300; with inventory unchanged, payables fell by that amount. The full bridge is $55,300 operating profit − $40,000 receivables increase − $3,300 payables decrease − $10,000 equipment − $15,000 principal = a $13,000 cash decrease. That proves the difference between cash flow and profit using this company's rows.
Choose an action for each finding. The purchasing manager can check rising product costs; the sales owner can review discounts; the bookkeeper can send a named list of disputed or overdue invoices. Record an owner and due date, then compare the next month's result with the expected effect.
Keep this operating review separate from financial analysis for a business plan, which explains assumptions for a different deliverable. If the next question concerns broader uses of the files, AI for small business covers that nearby topic.
Upload your monthly accounting export and invoice file; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the supporting business context.
Start with monthly income statements, balance sheets, a bank reconciliation and an accounts receivable aging report. Add invoice and payment exports when a total needs investigation. A simple review works best when those reports share the same cutoff date and accounting basis.
Yes. Customers may owe more, inventory may absorb funds, or the company may buy equipment and repay debt. Profit records revenue and expenses; cash also reflects payment timing and transactions outside operating profit. Reconcile the difference before deciding the accounting report is wrong.
Use a short monthly table for revenue, gross margin, operating profit, bank cash and customer receivables. Investigate the largest meaningful movements rather than adding ratios. Record the action, owner and due date, then check whether the action worked at the next review.