Messy TB imports & mapping
Drop .csv, .xlsx, or .xls exports from Tally, QuickBooks, Sage, or Excel. Title blocks are skipped automatically, raw files stay on record, and only the header plus 5 rows go to the LLM.
Automated Vouching, Tie-Outs, and Workpaper Prep for Modern Audit Teams.
Upload your client’s CSV or Excel trial balance as it arrives. VouchClerk maps the columns, normalizes the chart of accounts, binds figures to lead-sheet workpapers, anchors every number to PDF evidence, and seals sign-off from preparer to partner.
Click through five live stages of a sample engagement for Kilimanjaro Coffee Traders Ltd (FYE 30 Jun 2026) — from CSV column mapping to PDF tie-outs, Benford testing, and partner lock.
What your staff imports in Module A feeds lead sheets, adjusting entries, variance reviews, and partner sign-off without copying CSVs between tools.
Drop .csv, .xlsx, or .xls exports from Tally, QuickBooks, Sage, or Excel. Title blocks are skipped automatically, raw files stay on record, and only the header plus 5 rows go to the LLM.
Client accounts classify into Assets, Liabilities, Equity, Revenue, and Expenses. Ambiguous accounts get a Brass warning pill, and debits = credits is verified immediately.
Spreadsheet-style schedules bind to normalized accounts showing Prior Year, Unadjusted, Adjustments, and Final balances. Approved AJEs update the working TB live.
Anchor tags like A-1 or C-3 to an exact page and point on bank statements, invoices, or confirmations. Click any badge to inspect the PDF side by side.
Import the full general ledger for first-digit conformity checks, duplicate invoice rules, holiday/after-hours postings, and drafted period-over-period variance commentary.
Preparer, reviewer, and approver must be three separate people. Firms can enforce authenticator-app TOTP or passwordless WebAuthn passkeys across every user.
Keep the calm tabular layout auditors read fastest — while eliminating broken formulas, unversioned files, and missing review trails.
| Audit moment | Spreadsheets & shared folders | In VouchClerk |
|---|---|---|
| Client sends an Excel TB with 5 header rows | Manual row deletion, broken SUMIFS, no trace to raw client file | Table auto-detected, raw export stored immutably, columns mapped with confidence scores |
| Late client AJE arrives during manager review | Manual edits across 4 separate workbooks; lead sheets drift out of sync | Approve AJE-1 once; working trial balance and bound lead sheets recalculate live |
| Partner asks where TZS 48,650,000 came from | Hunting through nested folders for “CRDB_june_final_v3.pdf” | Click tag A-1 beside the figure; PDF opens beside the schedule at the pinned line |
| Junior staff edits a reviewed schedule | Silent cell overwrite with no record of who changed what | Three-person sign-off enforced; partner approval seals and locks the workpaper |
| Client confidentiality across engagements | Shared drive folders managed by convention | Database-enforced tenant_id isolation plus team-scoped engagement access for staff |
Preparer, reviewer, and approver of a workpaper are three different people; nobody approves an AJE they proposed; nobody signs off variance commentary they wrote.
| Role | Engagement permissions |
|---|---|
| Partner | Gives final approval (seals & locks workpapers); reopens approved work with a mandatory note. |
| Manager | Creates engagements, assigns engagement teams, reviews schedules, and approves AJEs. |
| Senior | Sees assigned engagements, reviews staff workpapers, and resolves ambiguous COA lines. |
| Staff | Sees assigned engagements, imports TBs, prepares lead sheets, proposes AJEs, and pins PDF tie-outs. |
| Admin | Manages firm users, roles, and firm-wide 2FA / passkey policies. |
Every database read and write injects tenant_id automatically, Seniors and Staff only see engagements they are staffed on, and 2FA/passkeys protect every login.
Never. AI only suggests column mappings, account categories, and draft analytical commentary — always labelled with its confidence score (for example, “Suggested by AI · High · 98%”). Every confirmation, AJE, and sign-off is performed by an auditor, and VouchClerk also runs 100% offline with deterministic heuristics.
We quote a clear annual firm fee based on your active audit team size and approximate engagement volume — with no surprise per-upload charges when importing prior-year comparatives or revised client trial balances. Send an inquiry below for a walkthrough and tailored quote.
Yes. Admins, Partners, and Managers have visibility across all firm engagements, while Seniors and Staff are restricted at the database query layer (scopedDb) to only the engagements whose team they belong to.
We encourage it. Bring a redacted CSV or Excel export from a completed engagement and watch how VouchClerk skips title blocks, classifies accounts, binds lead sheets, and anchors a PDF tie-out live on the call.
Tell us about your audit practice and we will schedule a 30-minute walkthrough for your partners and managers — followed by a straight firm quote and pilot workspace.