Do GL account mapping with AI and be confident it works
Mapping your general ledger accounts to a financial statement is one of those jobs everyone in finance knows and nobody wants to mess up. Whether you call it account mapping, GL mapping or GL coding, it is matching every account in your chart of accounts, line by line, to the right row on the P&L (income statement), balance sheet or cash flow. Miss one account or mis-map another and the numbers don't reconcile. Get it right and it takes hours but it is longer again if you're rolling the work out across multiple entities, branches or depots.
Phocas Financial Statements has just added two features that change this. A Statement Library of ready-to-use report templates and AI-suggested account mapping with confidence scoring. Together, they turn an important manual setup task into something you can replicate and trust.
Mapping accounts by hand takes times
Every new financial statement starts the same way with someone needing to map every general ledger (GL) account, cost center by cost center to the right line. Those accounts usually come out of an ERP, sometimes alongside sub-ledgers that have their own business rules, so the list can run long. It's detailed, repetitive work and it usually falls to whoever on the finance team has the patience for it. One mistake in a list of account codes can throw off a whole report, so double-checking becomes part of the job too.
It gets harder again if you're a distributor or manufacturer with several entities, branches or divisions, each wanting a report that reflects their results. A simple P&L (income statement) for one location, a detailed one for another or a more metrics focused layout for a third. Building that financial statement from a blank canvas every time and re-mapping accounts is exactly the kind of manual process that keeps finance teams from getting to the analysis or providing advice that the people working in these branches are craving. Or worse still, these statements never get created.
What's new in Phocas Financial Statements
A Statement Library to start from
Instead of building a financial statement from scratch, you now pick from a set of curated, ready-to-use templates. There's a P&L (income statement) in simple, detailed, distribution and manufacturing versions, as well as balance sheets, cashflow statements and direct and an indirect cash flow statement as well as a KPI report in these formats. Each template shows its full structure before you commit, so you can compare a simple P&L against a detailed one and pick the style that matches how your business reports, whether that's under GAAP or another framework.
AI-suggested account mapping
Once you've picked a template, the next job is mapping your accounts to it. This is where a suggest mappings button on the Map accounts tab does the heavy lifting. Built with artificial intelligence and machine learning designed specifically for account mapping, it looks at your account codes, names and properties and suggests which row in the statement each account should map to. What used to be a manual, drag-and-drop task becomes a fully mapped statement, ready to build and check.
Confidence scoring is built-in
Every suggested mapping comes with a confidence indicator. The familiar green colour for high confidence, amber for anything less certain and hovering over a suggestion shows the reasoning behind it. The steps on how it was mapped is the part finance teams care about most as they can see why an account was mapped a certain way. Users can accept mappings in bulk where they are confident, or go through the amber mappings one by one. Either way, the finance team stay in control of the final statement, and there is an audit trail for every mapping decision.
Why this is great if you report on multi-entities or branches
The two new features are designed to work together as distributors rarely want one financial statement. Their stakeholders like a P&L for the branch, different KPIs for some regions and a specific layout for head office reporting. The Statement Library gives you a starting template for each of those instead of building every one from a blank grid. AI-suggested mapping then makes light work of getting every account into the right place, for every location, without your finance team re-doing the same manual mapping again. The result is trusted financial performance for every part of your business so they can see the impact of their decisions on the profitability of their specific area.
Built on the security you'd expect from Phocas
AI features in Phocas run inside the same security and data governance controls that protect the rest of the platform. This includes the same access controls, encryption standards and operational safeguards, backed by SOC 2 Type 2 and GDPR compliance. As Phocas AI works from the same user-based permission model as the rest of the Phocas platform, whoever's using account mapping only ever sees what they're already permitted to see. The mapping suggestions are also built on your clean, structured Phocas data rather than an unvalidated export, making the mappings it suggests more accurate as well.
Customer data processed through AI features is never used to train public or shared foundation models, and where a third-party AI provider is involved, Phocas applies enterprise configurations that don't allow that provider to retain data for training. Financial and operational data, including underlying transactional records, only leaves your Phocas environment if you've enabled the relevant AI feature and given explicit authorization, and it's used solely to deliver that feature.
These tried-and -tested templates and AI-suggested account mapping means finance teams can set up one new financial statement or a dozen across every branch with less manual work and more confidence. These features help you create more valuable financial statements and start better discussions on how best to act on the results across your distribution business.
The ultimate financial planning and analysis guide
Download now
Katrina is a professional writer with a decade of experience in business and tech. She explains how data and AI can work for distribution professionals and finance teams without all the tech jargon.
Related blog posts
Business intelligence (BI) is valuable in distribution when people use the tool and it improves how they operate. Customer feedback in BARC's Analytics & AI Survey 27 proves Phocas Analytics, the flagship BI product on the Phocas platform supports this usability and benefit requirement, with top rankings for Product Satisfaction and Performance & Scalability.
Read more
For any Sales Director, the ability to measure and communicate your team’s sales performance quickly but accurately is essential.
Read more
Conversational AI security is how you control what an AI assistant can see, how your business data is used and whether you can check its answers. For distributors, that means keeping existing user permissions, ruling out model training on your data, guarding against prompt-based leaks and verifying every output.
Read more
AI is opening new possibilities for distributors to ask questions of their data and put analysis within everyone’s reach. Phocas brings those capabilities into our New Analytics experience, designed around the industry’s data and workflows. The New Phocas Analytics experience helps distributors keep pace with what’s changing through AI-powered exploration, deeper analysis, more powerful dashboards and flexible ad hoc reporting. At the center of the experience is Workspaces, powered by PACE (Phocas Agentic and Conversational Engine) giving people a conversational way to investigate challenges and uncover opportunities. The change to New Phocas Analytics is an expansion of Phocas’ distribution intelligence capabilities.
Read moreBrowse by category
Find out how our platform gives you the visibility you need to get more done.
Get your demo today