Description
One-line value: Cut routine bookkeeping time by 60–70% with prebuilt automations for capture, classify, reconcile, and validate.
What it does
A turnkey automation bundle that converts raw bank/PSP exports into clean, balanced ledgers. It auto-classifies transactions, flags anomalies, posts accruals, and prepares month-end journals. Designed for Excel/Google Sheets power users who want real automation without custom dev.
Who it’s for
• Freelance bookkeepers, SMB accountants, in-house finance ops
• Fast-growing Shopify/WooCommerce sellers with messy feeds
• Controllers who need repeatable close procedures
Outcomes & KPIs
• Reconciliation lead-time: ↓ 60–70%
• Manual entry: ↓ 80%
• Posting accuracy: ↑ to 99.5%+ via rule checks
• Month-end carryovers generated automatically
Inside the kit (deliverables)
• Excel & Google Sheets workbooks with VBA/Apps Script macros
• Rule engine (JSON/CSV) for categories, VAT codes, GL accounts
• Journal builder for prepaid/deferral/amortization entries
• Reconcile helper (bank ↔ GL) with unmatched exception queue
• Sample datasets + demo videos + quickstart PDF
Key features
• Auto-categorization (merchant, memo, regex, amount bands)
• VAT/GST assignment rules with override hierarchy
• Duplicates & split-payment resolver
• FX revaluation helper (monthly, EOM rate table)
• Posting templates for ERP/GL (CSV): Xero, QBO, Odoo, SAP B1
Technical
• Excel 2019+/M365; Google Sheets supported (no add-ins required)
• Macros signed; no external DLLs; offline-friendly
• Config via YAML/JSON (non-technical readable)
Security
• Local execution; no data leaves your device
• Optional hashing for audit logs
Onboarding (10 min)
1) Import your bank/PSP CSV.
2) Map columns (one-time).
3) Load rules → Preview postings → Export journals.
License & support
• Single-site commercial license, lifetime access to v1.x
• 6 months email support, updates included
Reviews
There are no reviews yet.