The problem
A services firm ran invoicing, contractor payouts, salaries, and bank reconciliation by hand across spreadsheets — slow, error-prone, and dependent on one person remembering the tax rules.
The system
A config-driven pipeline that generates invoices and payment schedules, books withholding tax at source with the correct rates and dates, handles multi-currency billing quirks, and reconciles bank statements against the ledger with human review only on mismatches.
How it's built
- Generators for receivable / payable / salary documents from one config
- Google Sheets + Drive integration via service account with delegated access
- Encoded tax rules: TDS at invoice date, currency-conversion conventions
- Reconciliation maps bank lines to ledger entries; exceptions surface, matches don’t
Delivery
Built on-demand by one engineer; runs monthly with a human approving exceptions only.
Results
- Monthly close work reduced from days of spreadsheet edits to a review pass
- Withholding-tax bookings consistent — rate and date rules live in code
- Every generated document traceable to its config inputs
Client anonymized by industry. Detailed numbers and references available on a call.