LEARN BUSINESS · ACCOUNTING & FINANCE
Monthly Financial Reporting Package for Small Businesses
See what to send an owner after month-end close, how to tie the figures together, and which decisions the report should prompt.
Download the Excel reporting package
Use the completed Desert Pump Services example to see how it works, then duplicate the blank template for each month. It includes the owner summary, budget variances, cash reconciliation, AR and AP exceptions, and an action tracker.
What belongs in a monthly financial reporting package?
Start with a one-page owner summary. Attach the income statement, balance sheet, and cash flow statement for the same entity and reporting period. Add budget variances, receivable and payable exceptions, and a decision log. Give every exception an owner and a deadline.
Build the package after completing the month-end close checklist. Label the reporting period, accounting basis, currency, budget version, and whether the package is preliminary or final. Keep the supporting reconciliations with the close file.
Worked example for a small service business
Desert Pump Services is fictional. Its October report uses accrual accounting and US dollars. October revenue was $100,000 against a $95,000 budget. Operating expenses, including $2,000 depreciation, were $88,000 against an $81,000 budget. Operating profit was $12,000 versus $14,000 budgeted, a $2,000 unfavorable variance. Assume no interest or income tax expense for this example.
Owner summary. Revenue was $5,000 above plan, but expenses were $7,000 above plan. Overtime contributed $4,000 of the expense variance. October generated $6,000 of operating cash, and cash fell $1,000 after buying equipment and repaying loan principal. The next cash review should focus on overdue collections and upcoming supplier payments.
| Report | October figures | What the owner should ask |
|---|---|---|
| Income statement | Revenue $100,000 less operating expenses $88,000 equals $12,000 net income. | Was overtime caused by a temporary backlog or a recurring staffing problem? |
| Balance sheet | Cash $24,000, AR $34,000, equipment net $40,000. Assets $98,000. AP $19,000, debt $29,000, equity $50,000. | How much of the $34,000 in receivables can we collect before the next payment run? |
| Cash flow statement | Beginning cash $25,000, operating cash +$6,000, equipment purchase −$5,000, debt principal −$2,000, ending cash $24,000. | Which payments and collections could push cash below our reserve next month? |
Cash from operations reconciles to net income: $12,000 + $2,000 depreciation − $10,000 increase in AR + $2,000 increase in AP = $6,000. The equipment purchase belongs in investing cash flow and the loan principal repayment belongs in financing cash flow. The closing balance sheet balances: $98,000 of assets equals $48,000 of liabilities plus $50,000 equity.
Turn exceptions into decisions
AR aging ties to $34,000. One $9,000 invoice is more than 30 days past due. AP aging ties to $19,000. An $8,000 supplier bill is due November 13. Show these as separate exceptions so the owner can see the exposure without scanning the full aging reports.
| Action | Owner | Due date | Evidence of completion |
|---|---|---|---|
| Call the customer about the $9,000 invoice and confirm the payment date. | AR lead | November 6 | Payment commitment or dispute escalation logged. |
| Confirm funding for the $8,000 supplier payment and update the cash forecast using the latest collection information. | Finance lead | November 10 | Forecast updated and payment approved under normal controls. |
| Review overtime by job and agree on one scheduling change. | Operations manager | November 12 | Cause documented and next-month overtime measure assigned. |
Review before sending
- Confirm that the statements use the same period, entity, and accounting basis.
- Tie cash to the approved reconciliation and AR and AP aging totals to their ledger balances.
- Check that opening cash plus operating, investing, and financing flows equals closing cash.
- Explain the largest decision-relevant variances and separate recurring issues from timing differences.
- Save the final version and restrict distribution to authorized recipients.
Continue with Budget vs. Actual Variance Analysis, Cash Flow Statement, and the 13-Week Cash Flow Forecast. Return to the Accounting hub.