How an Accounting Firm Reclaims 8 Hours Every Week

The Problem: 8 Hours Swallowed Every Week by Busywork

A 5-person accounting firm based in Lyon reached out to us with a simple observation: they spent more time chasing documents than doing actual accounting work.

Here's how those 8 lost hours broke down each week:

• 2h30 — Manually following up with clients for missing supporting documents
• 1h30 — Downloading, renaming, and filing attachments received via email
• 1h45 — Manually updating Excel tracking spreadsheets
• 1h15 — Sending monthly summaries and tax deadline reminders
• 1h00 — Checking file completeness before period close

None of these tasks require accounting expertise. They're repetitive, predictable, and perfectly automatable. So that's exactly what we did.

The 4-Block Accounting Firm Automation Strategy

We broke the project into 4 functional blocks, each targeting a specific time drain. The goal: zero unnecessary tools, zero unnecessary complexity.

Block 1 — Automated Follow-Ups for Missing Documents

Problem: The team member responsible for document collection was manually sending 15-25 follow-up emails per week.

Solution deployed:

• An n8n workflow triggered every Monday and Thursday at 9 AM
• Connected to a Supabase database listing expected documents per client per month
• Automatic generation of a personalized email using dynamic templates
• If no response after 5 days, a second follow-up is sent automatically with slightly different wording

Trigger (Cron) → Query Supabase (missing documents)
→ Filter (deadline < today + 7d)
→ Generate email (Handlebars template)
→ Send via SMTP → Log to Supabase

Result: 2h30 reclaimed, client response rate jumped from 45% to 72% thanks to consistent follow-up cadence.

Block 2 — Intelligent Processing of Emailed Documents

Problem: Clients sent invoices, bank statements, and payslips in bulk via email. Every document had to be manually renamed, classified, and stored.

Solution deployed:

• n8n workflow monitoring a dedicated inbox (IMAP)
• Attachment extraction and content analysis via Claude AI (Anthropic API)
• Automatic classification: document type, associated client, period
• Renaming following the firm's convention (CLIENT_TYPE_YYYYMM.pdf)
• Auto-upload to the client folder on Google Drive or Nextcloud

Claude AI prompt used:

Analyze this PDF document. Return a JSON with:
- "client": client or company name
- "type": invoice | bank_statement | payslip | other
- "period": in YYYYMM format
- "confidence": score from 0 to 1

Result: 1h30 reclaimed, correct classification in 94% of cases. The remaining 6% are flagged for human review.

Block 3 — Real-Time Tracking Dashboard

Problem: Client file tracking was done on a shared Excel file — a constant source of version conflicts and oversights.

Solution deployed:

• Supabase database with clients, expected_documents, received_documents, and deadlines tables
• Lightweight web interface deployed on Vercel (Next.js) accessible to all team members
• Auto-updated via n8n workflows (document received = status update)
• Synthetic client view: green (complete), orange (pending), red (overdue)

Result: 1h45 reclaimed. Zero manual updates. The firm's manager checks the dashboard every morning in 2 minutes.

Block 4 — Automatic Monthly Summaries and Deadline Reminders

Problem: Every month-end, the assistant manually prepared a summary per client and sent tax deadline reminders.

Solution deployed:

• n8n workflow triggered on the 25th of each month
• Supabase query to generate each client's summary (received documents, missing items, upcoming deadlines)
• Clean HTML email generation with a visual summary
• Automated sending + copy to the assigned accountant
• Tax deadline reminders (VAT, corporate tax, property tax) sent at D-10, D-5, and D-1

Result: 2h15 reclaimed (1h15 on summaries + 1h00 on completeness checks, now nearly instant thanks to the dashboard).

Complete Tech Stack

Component	Tool	Role
Orchestration	n8n (self-hosted)	All workflow automation
Database	Supabase	Structured storage, real-time API
Document AI	Claude AI (API)	Classification and data extraction
Interface	Next.js + Vercel	Team tracking dashboard
File storage	Google Drive / Nextcloud	Classified document archiving
Email	Dedicated SMTP	Sending follow-ups and summaries

What It Actually Costs

Let's be transparent about monthly operating costs:

• n8n (self-hosted on VPS): ~€15/month
• Supabase (Pro plan): ~€25/month
• Claude AI (API, ~200 documents/month): ~€12/month
• Vercel (Hobby/Pro plan): €0-20/month
• Total: ~€55-70/month

For a firm billing staff time at €50-80/hour, the 8 hours reclaimed weekly represent €1,600-2,560 in recovered productive capacity every month. ROI is achieved within the first week.

3 Mistakes to Avoid When Automating an Accounting Firm

1. Trying to automate everything at once. Start with the block causing the most frustration. For this firm, it was follow-ups. The quick win motivates the team for what comes next.

2. Skipping the mapping phase. Before touching a single tool, we spent half a day mapping every micro-task with the team. Without this work, you automate the wrong processes.

3. Forgetting the human fallback. AI makes mistakes sometimes. Every workflow includes a flagging mechanism when the confidence score is low. Humans stay in the loop — but only when necessary.

What Happened Next

This firm now uses its reclaimed 8 hours to develop a higher-value advisory offering. The managing partner told us: "We went from firefighters to advisors. Our clients can feel the difference."

Accounting firm automation isn't a technology project. It's a strategic one. Technology is just the lever.

Do you run an accounting firm and recognize these pain points? Contact Otomy for a free process audit. We identify the hours you can reclaim within 48 hours — and we build the solution.