Black Friday and Cyber Week, Fri 20 Nov to Tue 1 Dec: the AppIQ AI Suite, all ten AI products, for $19,997 (bought separately $29,970). See the Suite

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
AI Trial Balance Mapper dashboard on the example files
AI onTrial balance mapping for group reporting and consolidation, worked out on your own computer.

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 first, then AI

"Rules mapped 50, AI proposed 86, 23 left for you" on the example.

Every proposal explained

Similarity, confidence and the runner-up; accept, reject or change.

Mapping errors caught

"Rent expense" mapped to Rental income is flagged with the fix.

Nothing uploaded

Your trial balances never leave your computer.

How it works

From two files to answers in four steps

1

Load

Each entity's trial balance, your group chart of accounts and, if you have it, last period's mapping.

2

Map

Rules reuse your previous mapping and exact names; the language model proposes a group account for every account left.

3

Check

Existing mappings are checked for sign, type and meaning conflicts; unusual balances are ranked by the anomaly model.

4

Combine

Accept or change the proposals, then export the mapped and combined trial balance and the mapping file to reuse next month.

What you see

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.

Mapping progress

Mapped by rules, proposed by the AI and left for you, entity by entity, with the balance check.

AI proposals

Every proposal with its similarity, confidence and runner-up; high-confidence ones pre-selected and marked AI.

Mapping review

Existing mappings with sign, type or meaning conflicts, each with a suggested fix.

Unusual balances

Big movements on the prior period, balances on the wrong side, and accounts out of line with other entities.

Group view

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.

What you get

Everything AI Trial Balance Mapper Pro does, on your own files.

IncludedAI Trial Balance Mapper Pro
FilesEntity trial balances (separate files or one with an entity column), group chart of accounts and optional previous mapping, CSV or Excel
RulesReuse of last period's mapping and exact or normalised name matches first
AI: language modelProposes 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 reviewSign and type conflicts and meaning mismatches in existing mappings
AI: machine learningAn Isolation Forest trained on your own balances, in your browser, with plain-English reasons
ChecksDebits equal credits per entity and combined, with the difference shown
DashboardsThree: Overview, AI & Mapping, Group view
ReportsExcel workbook, reusable mapping CSV and printed / PDF, stamped "Licensed to" your organisation
Your trial balances leave your computerNever

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.

See it on the example files

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.

Pairs well with

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 Library

Month-End Close & Controls System

$497 one-time. The close checklist with sign-off blocked while exceptions are open.

See the Month-End Close System
AppIQ Finance in your language: Deutsch · Nederlands · Français · Español · Português · Türkçe · العربية · 日本語 · 한국어 · Bahasa Indonesia · All countries