Gabinete Valente & Saraiva is a 22-year-old accounting firm based in Porto with a portfolio of 40 client companies (real case — data altered under NDA), mostly SMEs in retail, services and small industry. The managing partner, João Peixoto, took pride in long-term client relationships but faced a chronic frustration with one specific process: preparing the monthly financial report. Three full days of team work, every month, consumed by manual consolidation and formatting. Clients received reports 5 to 10 days late — some accepted, others complained, and the best clients (those who valued timely information most) were starting to consider alternatives.
The Scenario Before: Excel as Nervous System
The firm's monthly process was as follows. For each of the 40 clients, a technician opened three distinct Excel sheets — monthly income and expense, evolving balance sheet, cash flows. They consolidated data imported from the Primavera accounting software, applied indicator formulas (gross margin, operating margin, debt ratios), formatted tables, inserted charts, and generated a PDF which was then emailed to each client.
Each report took on average 90 minutes. 40 reports × 90 minutes = 60 hours/month. Spread across three technicians, it represented three full days of near-exclusive dedication. During those three days, the rest of the work piled up — urgent client clarifications, tax declaration preparation, consultancy — and the team entered stress mode.
Worse: the manual process introduced errors. A cell not updated in a sheet, a copy-paste that didn't stick, a formula accidentally overwritten. João estimated that at least 4–5 reports per month had small errors that were only detected after sending — requiring corrections, apologies, and erosion of client trust. For a firm whose value proposition is reliability, this was unacceptable.
The Strategy: Automating the Pipeline from Data to PDF
Phase 1: Automatic Extraction from Accounting Software
The first step was eliminating manual data extraction from Primavera. We built a connector that, on the 1st of each month, automatically connects to the software's database and extracts, for each of the 40 clients, the required tables: P&L, balance sheet, cash flows, and details of specific accounts. Data is normalised to a consistent schema and stored in a central repository.
This step alone eliminated about 40% of manual time. Technicians stopped spending full mornings doing exports from Primavera.
Phase 2: Indicator Calculation Engine
We built a calculation engine with all the needed financial indicators: gross margin, operating margin, EBITDA, debt ratios, working capital, inventory turnover, average collection and payment terms, and comparisons vs. same month prior year and vs. year-to-date average. Indicators are calculated automatically for each client after extraction, with accounting rules applied consistently.
The engine also includes automatic alerts: if an indicator falls outside a predefined range for the client, the system flags the report for human review — this ensures anomalies are detected before sending, not after.
Phase 3: Sector-Specific Report Templates
Reports are not identical for all clients. A restaurant needs different information from a real estate agency. We created three different templates (retail, services, small industry), each with specific sections and charts tailored to the sector. The system automatically chooses the right template based on a prior client classification.
Each template was designed jointly with João and the three technicians — to ensure it reflected what they considered relevant and was technically robust. Each template was tested with 3 real clients before being adopted universally.
Does your firm lose time on monthly reports?
We automate the entire pipeline — from accounting software to PDF delivered to the client.
View Financial Reports →Phase 4: Automatic Generation and Delivery
With data extracted, indicators calculated and template selected, the final PDF generation runs automatically. The system produces branded PDFs (with firm logo and customised header per client when applicable), each including automated commentary on relevant variations ("operating margin dropped 3.2pp vs. previous month, driven by increased personnel costs"). Reports are deposited in a firm-shared area, organised per client, ready for review.
The technician responsible for each client opens the generated PDF, reads it in 5 minutes, adds 2–3 contextual comments (something automation cannot: specific knowledge of the client's business), and clicks "Send". The client receives the PDF via email with a summary in the message body.
Results After 4 Months of Operation
The numbers changed everything:
• Monthly preparation time: from 60 hours to 4 hours — a 93% reduction. The 4 hours correspond to 5-minute reviews × 40 clients = 200 minutes + startup time and contingencies.
• Delivery date: all 40 reports started being delivered by the 2nd of each month — punctuality never achieved before. Clients spontaneously commented on the change.
• Report errors: from 4–5/month (before) to 0 in 4 months (after). Automation eliminates human errors, and automatic anomaly alerts catch data issues.
• Freed-up capacity: 56 hours/month = equivalent to 0.35 FTE = capacity to take on 12–15 more clients with the current team (the firm is now in a controlled acquisition campaign).
• Client satisfaction: quarterly survey moved from NPS 48 to 71. The most cited point is "I finally receive on time".
• Return on investment: project paid back in 3 months through a single new client accepted thanks to the freed-up capacity. All following months are margin.
Lessons for Accounting Firms and Consultancies
The first lesson is that automation in accounting does not threaten accounting work — it threatens administrative work. High-value tasks (interpretation, consultancy, strategic recommendation, tax advice) continue to require humans, and indeed gain time to be done better. Low-value tasks (copying, pasting, formatting) are exactly what should be automated.
The second lesson is that the industry standard — delivering reports 5–10 days late — is treated by clients as normal until someone offers them better. When Valente & Saraiva started delivering by the 2nd, two clients immediately asked to transfer the accounting of sister companies to the firm too. Punctuality became a commercial argument.
Conclusion
Gabinete Valente & Saraiva gained what every firm tries to sell — time for quality consultancy — by freeing itself from what most firms do badly: late, error-prone reports. Today, the team dedicates the hours previously spent formatting Excel to strategic client conversations, proactive tax reviews and monthly financial monitoring meetings. The firm's image changed — from report supplier to trusted advisor. And João is already preparing expansion to accept 60 clients next year, without hiring a single additional technician.
