How We Eliminated 12 Hours of Weekly Data Entry for a Victorian Law Firm

Client: A mid-tier Victorian law firm with 15 staff, specialising in property and commercial law.

Service Vertical: Workflow Automation

Outcome: 12 hours per week reclaimed from manual data entry. Trust account reconciliation reduced from 4 hours to 20 minutes. Zero data entry errors in 6 months of operation.

The Challenge

The firm had a problem that is endemic to the Victorian legal sector: their practice management software (LEAP), their accounting software (Xero), and their client communications existed as three separate islands. Nothing talked to anything else.

Every week, the office manager spent approximately 12 hours performing manual data entry tasks that should never have required human hands:

• Invoice reconciliation: Every LEAP invoice had to be manually re-entered into Xero. The firm generated 80-120 invoices per month. Each one was typed twice.
• Trust account reporting: Trust account movements in LEAP were exported as CSV files, manually reformatted in Excel, and then uploaded to Xero. This process took 4 hours every Friday afternoon.
• Client intake: New matter creation required data entry across LEAP (matter opening), Xero (client contact creation), and the firm's email system (distribution list updates). Each new client meant 15 minutes of redundant typing.
• Disbursement tracking: Court filing fees, search fees, and other disbursements were recorded in LEAP but had to be manually mirrored in Xero for GST reporting.

The office manager was blunt: "I spend my Fridays doing robot work. I did not go to university to copy-paste numbers between two screens."

Beyond the time cost, the manual process introduced errors. In the six months before our engagement, the firm had identified three trust account discrepancies that required manual investigation — one of which triggered a compliance review by the Victorian Legal Services Board.

Our Approach

We structured the project in four phases over 8 weeks, prioritising the highest-risk automation first (trust accounts) and working outward to lower-risk but high-volume tasks.

Phase 1: Workflow Mapping (Week 1-2)

Before writing a single line of code, we spent two weeks mapping every data touchpoint between LEAP, Xero, and the firm's other systems. We shadowed the office manager through a complete weekly cycle, documenting:

• Every manual data transfer (source, destination, format, frequency)
• Every decision point ("If invoice type is trust, then...")
• Every error-prone step (manual currency formatting, GST calculation edge cases)
• Every compliance requirement (trust account audit trail, data retention obligations)

The mapping revealed 23 distinct manual data transfer tasks. We categorised them into three tiers:

1. Critical (trust accounts): Must be 100% accurate, fully auditable, zero tolerance for error
2. High volume (invoicing): 80-120 items/month, tolerates minor delay but not errors
3. Low frequency (client intake): 10-15 per month, less urgent but compounds over time

Phase 2: Trust Account Automation (Week 3-4)

Trust accounts are the most sensitive data in a law firm. A single error can trigger a regulatory investigation. We built this automation first to prove the architecture under maximum scrutiny.

Architecture:

• LEAP webhook triggers on every trust account transaction
• Make.com scenario receives the webhook, validates the payload against a schema
• Django middleware layer (the Legal Practice Portal) performs the business logic:
  • Maps LEAP transaction types to Xero trust account codes
  • Applies GST rules based on transaction category
  • Generates the Xero journal entry payload
  • Writes an immutable audit log entry before pushing to Xero
• Xero API receives the formatted journal entry
• Confirmation webhook returns to the Portal, closing the audit loop

Key design decision: We inserted a Django middleware layer rather than connecting LEAP directly to Xero via Make.com. The reason: trust account regulations require an immutable audit trail. Make.com execution logs are not sufficient for regulatory purposes. The Django Portal maintains a permanent, queryable record of every transaction that passed through the pipeline.

The Friday trust account reconciliation went from 4 hours of manual work to a 20-minute review of the automated reconciliation report.

Phase 3: Invoice & Disbursement Automation (Week 5-6)

With the trust account pipeline proven, we extended the pattern to invoicing and disbursements:

• LEAP invoice finalisation triggers a Make.com scenario
• The scenario extracts line items, maps them to Xero account codes, and creates a draft Xero invoice
• Disbursements follow a similar pipeline: LEAP disbursement entry triggers automated Xero cost coding
• All automations include error handling: if a mapping fails (e.g., unknown account code), the item is flagged for human review rather than silently dropped

Volume: The system now processes 80-120 invoices and 200+ disbursement entries per month without human intervention.

Phase 4: Client Intake & Governance (Week 7-8)

The final phase automated new client onboarding:

• New matter creation in LEAP triggers a multi-step Make.com scenario
• Client contact is created in Xero (if not already existing — deduplication logic prevents duplicates)
• Email distribution list is updated via Microsoft Graph API
• Welcome email is sent to the client with the firm's standard engagement letter
• A summary notification is posted to the firm's internal Slack channel

We also built a governance dashboard in the Django Portal that shows:

• Automation execution count (daily, weekly, monthly)
• Error rate and flagged items requiring human review
• Trust account reconciliation status
• Time saved (calculated against the pre-automation baseline)

The Outcome

6 months post-deployment:

• 12 hours per week reclaimed. The office manager now spends Friday afternoons on practice management strategy instead of data entry.
• Zero data entry errors. In six months of operation, the automated pipeline has processed over 600 invoices and 1,200+ disbursement entries without a single trust account discrepancy.
• Trust account compliance: The immutable audit trail exceeds Victorian Legal Services Board requirements. The firm's external auditor described the system as "the most rigorous trust automation I have seen in a mid-tier firm."
• 20-minute Friday reconciliation. Down from 4 hours. The office manager reviews the automated report, confirms the totals, and signs off.
• Client intake time: New matter setup reduced from 15 minutes to under 2 minutes (the time to create the matter in LEAP — everything else is automated).
• ROI: At the office manager's loaded cost rate, the automation saves the firm approximately $31,200 per year in labour. The project paid for itself in under 4 months.

Tech Stack

This project is part of our portfolio. The Legal Practice Portal was delivered under our Workflow Automation vertical.