Perth Accounting Firm
Achieves 91% Time Reduction in Report Generation

This Perth accounting firm with 20+ staff was caught in a cycle familiar to anyone who has worked in public practice: the quarterly BAS crunch. Every three months, the entire firm effectively ground to a halt. Senior accountants — the same staff commanding the highest charge-out rates—were pulled off advisory engagements to compile lodgement packages, chase client source documents, and manually reconcile figures pulled from Xero against spreadsheets maintained in Google Workspace. The bottleneck was not a skills problem. It was a workflow problem.

Beyond BAS quarters, the EOFY period amplified every pressure point. The firm was consistently turning away new clients during July and August, not for lack of headcount, but because the manual report compilation process could not scale. Each client report required pulling data from Xero, merging it with advisory notes, formatting it to the firm's branded template, and routing it for partner review before distribution. A task that should have taken fifteen minutes routinely consumed three hours. Multiplied across a client base of 80-plus entities, the maths simply did not work.

The human cost was equally significant. Skilled accountants were spending meaningful portions of their week on copy-paste work—transcribing figures between systems, reformatting headers, and chasing e-signatures on documents already approved verbally. Staff frustration was rising. The firm's principals recognised that if they wanted to grow, they needed to stop treating their most experienced people as document assemblers. Equally pressing was the error risk: manual compilation from multiple data sources (Xero, Google Workspace, and client-supplied records) created real exposure. A miskeyed figure in a BAS lodgement is not a minor inconvenience; it is an ATO compliance issue.

The firm approached Lakestone with a clear brief: remove the manual burden from BAS and EOFY reporting, reduce error risk, and free senior accountants to do the advisory work they were trained and hired to do.

After mapping the firm's data flows, we designed an end-to-end automation pipeline built on n8n as the orchestration layer. The choice of n8n over a simpler point-to-point integration tool was deliberate. Accounting data pipelines are rarely clean: Xero exports need normalising, client-supplied documents arrive in inconsistent formats, and different report types require different logic. n8n's node-based workflow model gave us the flexibility to handle these variations without locking the firm into a single vendor or requiring developer intervention each time a new report type was added. Maintainability was a core requirement—the firm has no dedicated engineering staff.

The production workflow operates as follows: when a BAS or client reporting trigger fires (scheduled or manual), n8n pulls structured financial data directly from Xero via API. The data is validated, mapped to the firm's reporting schema, and passed to GPT-4 with a prompt engineered around the firm's own templates and writing style—not a generic output. GPT-4 generates the narrative sections of the report: executive summary, key movements commentary, and compliance notes. These are assembled by n8n into a branded document, routed through Google Workspace for partner review, and dispatched via DocuSign. The DocuSign integration was a compliance requirement, not a convenience: the ATO expects accounting firms to maintain an auditable approval trail for lodgement authorisations, and a DocuSign audit log satisfies that requirement cleanly. Every signed document is automatically archived to the firm's Google Drive with a consistent naming convention, removing the end-of-EOFY filing scramble entirely.

Technology Stack

• n8n Automation Platform: Orchestrates data flow between systems and triggers automated workflows for BAS and client report generation
• OpenAI GPT-4: Generates firm-specific report narratives using custom templates and tone guidelines, not generic outputs
• Xero Integration: Direct API extraction from accounting records for automated BAS preparation and financial report generation
• Google Workspace: Automates document assembly, partner review routing, and structured archiving
• DocuSign: ATO-compliant approval audit trail with automated signature collection and document distribution

Six weeks after go-live, the numbers told a story the firm's principals had not predicted. Report generation time dropped from an average of three hours to fifteen minutes per client—a 91% reduction that, across the client base, freed up more than fifty hours of staff time every week. The impact during the next BAS quarter was immediate: lodgements went out on schedule with no overtime, senior accountants stayed on their advisory engagements throughout the quarter, and partners stopped doing document administration.

The freed capacity translated directly into revenue. With BAS and EOFY bottlenecks removed, the firm took on 40% more clients without adding headcount. Crucially, ATO compliance was strengthened rather than compromised: automated validation checks across Xero data and the DocuSign audit trail meant no more last-minute scrambles to locate signed authorisations or reconcile conflicting figures. The error risk that had been quietly accumulating in the manual process was eliminated.

The longer-term shift has been in how the firm generates revenue. Senior accountants—now freed from repetitive compilation work—are billing more hours at advisory rates, which carry a higher margin than compliance work. The principals estimate the revenue mix improvement has been as significant as the headcount efficiency gain. For an accounting firm in Perth competing against larger practices, that repositioning matters.