The Problem

Accounting staff at property development companies spend hours manually re-keying journal entries from Excel into Accurate 5 Deluxe.

A single multi-project allocation can span 50+ rows, and one typo in a GL account code breaks the whole import — forcing them to start over.

The Solve

The tool parses the Excel file client-side using SheetJS, maps rows to the user's own department and GL account lists (persisted in Supabase), then serialises everything into the exact XML schema Accurate 5 expects.

The trade-off: transformation runs entirely in the browser to avoid uploading sensitive financial data to a server, which means large sheets (1,000+ rows) may feel slow on low-end devices.

Screens

App Flow

01User uploads .xlsx file
02App reads sheets and detects column layout
03User maps columns (description, amount) and picks target sheet
04Rows are parsed and auto-matched to saved GL accounts and departments
05User reviews and edits the journal entry table
06Balance (debit = credit) is validated in real time
07User clicks Generate XML
08Accurate-compatible XML is built and downloaded instantly
09Superadmin activates premium licence via dashboard
10User's trial quota resets and unlimited generates are unlocked

Under the Hood

Next.js
React
Supabase
TypeScript
Tailwind CSS
xlsx
Framer Motion

All parsing and XML generation happens in the browser via the `xlsx` library. This avoids any PII/financial data ever leaving the user's machine, which matters for accounting firms. The downside is that memory-intensive sheets block the main thread — a Web Worker migration is the obvious next step.

Changelog

2025-05-24
Launched per-tool subscription system; each tool now has independent trial and premium licences.
2025-05-20
Added Excel import with column mapping UI and sheet selector.
2025-05-10
Initial release: manual journal entry table with Accurate XML export and 3-day free trial.