Map every entity's trial balance to your group chart
Load each entity's trial balance and the group chart of accounts. Rules reuse last month's mapping and match names; an on-device language model maps the rest by meaning, with a confidence and a runner-up for every proposal. The review flags existing mappings that don't fit, and a machine-learning anomaly model ranks the balances to look at first. You get the mapped and combined trial balances, with debits equal to credits checked to the cent. Your figures never leave this device.
Your files can't leave this page. Here's how you can check.
- Your browser blocks it. This page carries a security rule (
connect-src 'none') that stops it from sending data to any server, ours included. The browser enforces it, not us. - Test it yourself. Once this page has loaded, turn off Wi-Fi or unplug the network. AI Trial Balance Mapper keeps working, because everything happens on your computer.
- No outside code. Every script on this page, including the AI, comes from appiqfinance.com. There are no trackers and no analytics on this page.
- The AI runs here too. The language model is downloaded to your browser and works on your computer. It only reads account names. The anomaly model is trained on your accounts, in this tab, each time.
- No connection to your systems. AI Trial Balance Mapper never connects to an accounting or consolidation system. It reads only the files you choose.
1Load the trial balances and the group chart
Export each entity's trial balance (account code, name, debit and credit or a balance; a prior period and currency if you have them) and your group chart of accounts (code, name and type). Last month's mapping is optional: it is reused and checked.
Paste the key from your purchase email. It's checked on this device; nothing is sent. No key yet? Buy AI Trial Balance Mapper Pro.
Entity trial balances
One or more files, CSV or Excel (.xlsx): one file per entity, or one file with an entity column
Group chart of accounts
Code, name and type (asset, liability, equity, income, expense); a statement section and a description are optional
Previous mapping optional
Entity, local account and group account, such as the mapping file this tool saved last month
2Check what we read
We worked out the columns, the number format and the signs. Debits show as positive and credits as negative; each trial balance should add up to zero.
Currency and AI settingsevery setting goes into the workbook
One rate per currency translates every account. If you use closing rates for the balance sheet and average rates for the income statement, load trial balances that are already translated.
3Your group mapping
Accounts
Match the intercompany balances before you consolidate
AI Intercompany Match pairs each entity's intercompany lines with the other side, finds the differences and explains them.
See AI Intercompany MatchMore AppIQ AI Software
Bank, supplier, customer payment, card and intercompany matching, journal entry testing and cash flow, all running on your device like this one.
See all AI Software