AI Software / AI Trial Balance Mapper
AIAppIQ AI Trial Balance Mapper Pro
Map every entity's trial balance to your group chart
Load each entity's trial balance, your group chart of accounts and, if you have it, last period's mapping. AI Trial Balance Mapper maps what it can by rules, then a language model proposes a group account for every account left, with its confidence and the runner-up for you to accept or change. It checks existing mappings for sign, type and meaning errors, and a machine-learning model flags unusual balances. You get the mapped and combined trial balance, ready for consolidation.
- Once-off licence, no subscription
- Nothing uploaded
- Any ERP's trial balance

Watch the demo · 1 min 05 sec
Recorded from the real product running on its example files. Nothing in it is mocked up. Open the video page with the full transcript. Buyer's checklist.
"Rules mapped 50, AI proposed 86, 23 left for you" on the example.
Similarity, confidence and the runner-up; accept, reject or change.
"Rent expense" mapped to Rental income is flagged with the fix.
Your trial balances never leave your computer.
From two files to answers in four steps
Load
Each entity's trial balance, your group chart of accounts and, if you have it, last period's mapping.
Map
Rules reuse your previous mapping and exact names; the language model proposes a group account for every account left.
Check
Existing mappings are checked for sign, type and meaning conflicts; unusual balances are ranked by the anomaly model.
Combine
Accept or change the proposals, then export the mapped and combined trial balance and the mapping file to reuse next month.
Three dashboards, one click apart
Overview, what the AI found, and the trends. Click a chart or a list to see the lines behind it.
Mapped by rules, proposed by the AI and left for you, entity by entity, with the balance check.
Every proposal with its similarity, confidence and runner-up; high-confidence ones pre-selected and marked AI.
Existing mappings with sign, type or meaning conflicts, each with a suggested fix.
Big movements on the prior period, balances on the wrong side, and accounts out of line with other entities.
Combined balances by group account and statement section, by entity.
Turn off your Wi-Fi. AI Trial Balance Mapper keeps working.
Everything happens on your computer, so you can load the page, disconnect, and keep working. Your files never reach us.
Everything AI Trial Balance Mapper Pro does, on your own files.
| Included | AI Trial Balance Mapper Pro |
|---|---|
| Files | Entity trial balances (separate files or one with an entity column), group chart of accounts and optional previous mapping, CSV or Excel |
| Rules | Reuse of last period's mapping and exact or normalised name matches first |
| AI: language model | Proposes a group account by meaning for every account the rules leave, with similarity, confidence and runner-up; reads your group chart's descriptions too if you include them |
| Mapping review | Sign and type conflicts and meaning mismatches in existing mappings |
| AI: machine learning | An Isolation Forest trained on your own balances, in your browser, with plain-English reasons |
| Checks | Debits equal credits per entity and combined, with the difference shown |
| Dashboards | Three: Overview, AI & Mapping, Group view |
| Reports | Excel workbook, reusable mapping CSV and printed / PDF, stamped "Licensed to" your organisation |
| Your trial balances leave your computer | Never |
AI Trial Balance Mapper Pro: $3,997 once-off. One organisation, any number of its own staff. No subscription. Licensed separately from the other AppIQ AI products. Includes 12 months of new versions; the licence never expires. Optional updates renewal after that, about 20% a year (details). Security & data · Test results · Proof Pack: test it yourself · 7-day money-back guarantee.
7-day money-back guarantee. No questions asked. We built this software to be tested hard, and we stand behind it. Run it on your own files for 7 days. If it is not right for your team, email us and we refund you in full: no form to fill in, no reasons needed. How the guarantee works.
Secure checkout by Paddle, our merchant of record. Your licence key arrives by email within minutes. Buying through procurement? Request a quote or pay by invoice.
Finance control tips by email
Practical control tips and AI Trial Balance Mapper updates from the team behind AppIQ Finance. Unsubscribe any time. See our privacy policy.
This form is on this page only. The AI Trial Balance Mapper tool itself can't send anything, including your email.
Questions
Are my files uploaded anywhere?
No. AI Trial Balance Mapper runs in your browser. The tool page carries a Content-Security-Policy (connect-src 'none') that stops it sending data to any server, and you can confirm it by turning off your internet connection after the page loads: it keeps working.
Does the AI map everything for me?
No. Rules map what they can first. The AI proposes a group account for the rest; proposals at 65% confidence or more are pre-selected but marked AI and can be rejected or changed, and lower ones are only suggestions. On the example, 86 of 109 proposals were pre-selected and all 86 were correct; 23 were left for the user.
How do I get the best AI mappings?
Use clear account names, and add a short description to each group account (for example "Trade debtors – amounts owed by customers"). The AI reads both, which helps it with local terms like "Debtors control".
Does it post consolidation entries?
No. It produces the mapped and combined trial balance and the mapping file. Eliminations and consolidation entries stay in your own process.
Does it use AI?
Yes, in three ways, all on your own computer. A language model (all-MiniLM-L6-v2) reads the descriptions and finds matches the wording rules miss; the screen counts them by running the match with and without the AI. The same model makes suggestions for leftover lines, which are never applied for you. And an Isolation Forest, a machine-learning model, is trained on your own file in your browser to rank unusual lines, with the reasons. Nothing it reads is sent anywhere, and anything doubtful goes to you to decide.
What does it cost?
AI Trial Balance Mapper Pro is $3,997 once-off for one organisation, any number of its own staff, no subscription. There is no free version: you can see the whole product on the built-in example files before you buy, and your own files open the moment your key is activated.
Is it the same licence as the other AppIQ AI products?
No. AI Trial Balance Mapper Pro is its own once-off licence for one organisation. Each AppIQ AI product can be seen on its own example files before you buy.
Keep the controls and sign-off in Excel
AI Trial Balance Mapper does the AI work. These AppIQ Excel Systems hold the control process.
Balance Sheet Reconciliation Library
$297 one-time. A reconciliation and sign-off record for every balance sheet account in Excel.
See the Rec LibraryMonth-End Close & Controls System
$497 one-time. The close checklist with sign-off blocked while exceptions are open.
See the Month-End Close System