Monthly Financial Reporting for Client Work

Monthly financial reporting gives your client a reconciled management pack they can use to understand profit, cash and agreed performance measures. Agree the reporting service first, close the records, build the dashboard and have a reviewer check the pack before release.

Agree the Monthly Reporting Package

Agree what the client needs to decide before choosing the reports. A business owner deciding whether upcoming bills can be paid needs a cash view. A client comparing completed jobs needs income and costs assigned consistently to each job.

Record the entity, intended recipients and reporting period in the engagement letter. Set the accounting basis, source-record cut-off and delivery deadline as an elapsed period after the close. Name who supplies records, prepares the pack, reviews it and explains the results. Specify how missing information changes delivery.

For covered members in public practice, APES 305 Terms of Engagement requires documented and communicated terms. Documenting them before work starts is recommended timing. Make before-start agreement your practice’s delivery policy.

Use this copyable outline for the monthly financial reporting package:

1. Record the entity, period, accounting basis, intended use and pack version on the cover.
2. Show the dashboard with agreed measures and comparisons.
3. Attach the profit and loss report and balance sheet.
4. Explain cash movements and balances awaiting payment or collection.
5. Add commentary, estimates and actions with an owner and agreed completion point.
6. Attach the applicable accountant’s report and restrict access to agreed recipients.

Management reporting supports internal decisions. Annual statutory statements have separate requirements, explained in the financial reporting guide. A management pack and an internal reviewer’s checks do not provide audit or review assurance.

Classify the work against APES 315 Compilation of Financial Information. Compiling financial information and analysing figures supplied by a client have different treatment. For internal-only compiled information, paragraph 10.3 recommends an Accountant’s Report Disclaimer and page-level references to restricted internal use. Reassess reporting requirements before a lender or another external recipient receives the pack.

Close and Reconcile the Reporting Period

Close the accounting records before exporting the monthly reports. Follow these checks in order and retain the supporting schedules.

1. Collect outstanding bank statements, invoices, payroll records and information about unrecorded transactions. Confirm which accounts and entities the records cover.
2. Reconcile each bank and credit-card account to its statement. Investigate unmatched receipts, duplicate transactions and transfers recorded on only one side.
3. Reconcile receivables and payables to the control accounts. Check old balances, credit notes and transactions entered after the cut-off.
4. Match payroll liabilities, tax balances and loans to their supporting records. Separate loan principal from interest and equipment purchases from operating expenses.
5. Record accruals, prepayments, depreciation and other period adjustments on the agreed basis. Check inventory and work in progress where they affect the client’s results.
6. Compare results with the previous period and budget. Investigate unexpected margins, missing recurring expenses and changed account classifications.

The close passes when each reconciliation has an explained difference of zero, or a documented timing item supported by evidence. Use the Xero bookkeeping guide for the underlying bookkeeping work.

Keep a missing-record list with the affected accounts and expected effect. A supportable estimate needs its calculation, assumption and reviewer decision. Mark the affected result as estimated in the pack. If missing records could materially mislead the client, delay release and explain the outstanding requirement.

When a late invoice arrives, compare it with the recorded accrual before posting it. Reverse or adjust the estimate so the expense appears once. Assess whether the earlier pack needs amendment, then keep the correction visible in the version record.

Build the Client’s Reporting Dashboard

Build the financial reporting dashboard from the same closed records as the attached reports. Give each measure a definition, source and comparison basis. Retain the calculation behind each dashboard tile.

This fictional service business has no inventory or work in progress. All figures are invented. It has no GST transactions for this simplified example, and profit is before income tax. The periods are consecutive months with equal comparison scope.

Financial performance	Previous period	Reporting period	Reporting-period budget
Revenue	$110,000	$120,000	$125,000
Direct costs	$58,000	$60,000	$62,500
Gross profit	$52,000	$60,000	$62,500
Operating expenses	$39,000	$40,000	$40,000
Depreciation	$2,000	$2,000	$2,000
Interest expense	$1,000	$1,000	$1,000
Profit before income tax	$10,000	$17,000	$19,500

Revenue rises by $10,000 against the previous period but falls $5,000 short of budget. The $17,000 profit exceeds the previous result by $7,000. It is $2,500 below budget. Gross margin is 50%, calculated as $60,000 divided by $120,000. The previous margin is 47.3%, rounded to one decimal place.

Use a separate cash schedule to explain why profit and bank movements differ.

Cash movement	Reporting period
Opening bank balance	$30,000
Client receipts	$105,000
Supplier payments for direct costs	-$55,000
Operating expense payments	-$38,000
Interest paid	-$1,000
Equipment purchase	-$12,000
Loan principal repayment	-$3,000
Payment of opening income tax liability	-$4,000
Closing bank balance	$22,000

Cash falls $8,000. Client receipts are $15,000 below revenue, so receivables rise from $30,000 to $45,000. Supplier payments are $5,000 below direct costs, so payables rise from $20,000 to $25,000. Unpaid operating accruals rise from $4,000 to $6,000.

The profit-to-cash check starts with $17,000 profit. Add $2,000 depreciation, subtract the $15,000 receivables increase and add the $5,000 payables increase plus $2,000 accrual increase. That gives $11,000 operating cash before tax. Subtract $4,000 tax paid, $12,000 equipment and $3,000 loan principal to reach the $8,000 cash decrease.

Balance sheet item	Opening balance	Closing balance
Bank	$30,000	$22,000
Receivables	$30,000	$45,000
Equipment, net of depreciation	$70,000	$80,000
Total assets	$130,000	$147,000
Payables	$20,000	$25,000
Operating accruals	$4,000	$6,000
Loan	$50,000	$47,000
Income tax payable	$4,000	$0
Equity	$52,000	$69,000
Total liabilities and equity	$130,000	$147,000

There are no equity contributions or distributions in this example. Equity increases by the $17,000 profit. Equipment closes at $70,000 plus $12,000 purchases less $2,000 depreciation. The dashboard therefore shows revenue of $120,000, profit of $17,000, gross margin of 50% and closing cash of $22,000.

For job-by-job financial reporting, reconcile job revenue and direct costs back to the report totals. State how shared costs and incomplete jobs are treated. A margin based only on completed jobs needs that label.

A retail client might need inventory movements and gross margin by product group. Law firm financial reporting might need billed fees, work in progress and aged debtors by matter. Separate office money from client trust money, and keep statutory trust-account reporting outside the management pack. Report the agreed measures without directing the client’s operational decisions.

Choose the financial reporting software after the pack and its measures are defined.

Explain Results With the Client

Explain observed results first, then separate assumptions and forecasts from those results. Each comment needs a figure, its comparison and the supporting reason. Where the reason is unknown, assign an investigation instead of inventing one.

For the fictional pack, an observed result is that cash falls $8,000 while profit is $17,000. The reconciled cash schedule explains the difference. A claim that slow collections caused every dollar of the fall would overlook the equipment purchase and debt repayment.

An assumption could be that the outstanding $45,000 receivables are collectible in full. Support that assumption with the aged balance review. A forecast that $30,000 will arrive within two weeks needs separate expected receipt timing. It remains forecast cash until the bank records the receipts.

Use this meeting agenda:

1. Confirm the reporting period, accounting basis and estimates affecting the pack.
2. Explain the largest changes against the previous period and budget.
3. Walk through the profit-to-cash reconciliation and upcoming payment commitments.
4. Discuss unusual transactions, ageing balances and the evidence still needed.
5. Agree follow-up work, its owner and completion point. Record any forecast assumption the client changes.

Keep the discussion within the agreed accounting service. If the client asks which investment to buy, refer that question through the appropriate advice channel. A cash dashboard alone does not support an investment recommendation.

Review and Release the Pack

Have the preparer complete the reconciliation file and the reviewer check the exact pack version intended for release. Apply the practice’s review policy and any relevant professional-standard requirements. APES 315 requires sufficient engagement reviews under the firm’s policies before issuing a Compilation Report.

The preparer checks period filters, classifications, adjustment journals and the source behind each measure. The reviewer checks material estimates, unexplained variances and commentary against the reports. For compiled general or special purpose financial statements, APES 315 requires written client acknowledgement of responsibility for the records and relevant disclosures.

Use these release checks:

1. Match the dashboard’s revenue and profit to the profit and loss report. In the example, they must be $120,000 and $17,000.
2. Recalculate the 50% gross margin and match $22,000 closing cash to the bank reconciliation.
3. Confirm assets of $147,000 equal liabilities and equity of $147,000. Recheck the $8,000 cash decrease against both cash schedules.
4. Confirm estimates, intended use and applicable report wording appear in the pack. Check access for each agreed recipient.
5. Retain the issued version, reviewer approval, client acknowledgements and delivery record with the working papers.

If a dashboard total differs from its underlying report, check entity selection, period filters and account mapping before release. A revised journal requires refreshed reports and dashboard calculations. A missing source record returns to the close checklist.

For an amended pack, retain the earlier version and issue a numbered replacement with the reason for correction. Record who receives it and which version it replaces. Release only when the reviewer approves the same version your client receives.