Validating GL Mapping Before Accounting Export with a Dust Agent — A 2-Minute Check
Invoices with missing or invalid GL codes silently block ERP exports. A Dust agent connected to the Spendesk MCP identifies them in bulk and suggests corrections before the problem hits at month-end close.
The Problem
Validating GL mapping before accounting export is one of the most time-consuming steps in the monthly close — and paradoxically one of the least visible. It doesn't appear in any dashboard, it generates no automatic alert in Spendesk, yet it's what determines whether the ERP export succeeds.
In practice, here's what happens: the controller team exports the month's invoices, launches the import into Sage, SAP, or Cegid — and then discovers that 18 invoices have a missing or unrecognised GL code. These invoices cause the import to fail. The team has to go back into Spendesk, identify the affected invoices, correct the codes one by one, re-run the export, and retry the import. This cycle can repeat two or three times before it succeeds. Total time lost: two to three hours on the day of close.
The worst part: these errors are predictable. A GL code "6150" used in Spendesk for SaaS subscriptions isn't in the current chart of accounts — it was renamed "6151" in the last update. Nobody propagated that change in Spendesk. This kind of silent discrepancy accumulates for weeks before exploding at close.
What a Dust agent connected to the Spendesk MCP changes
A Dust agent configured with the Spendesk MCP tools can cross-reference the month's invoices against the official chart of accounts in real time. It immediately identifies discrepancies, ranks them by severity, and suggests corrections — before the export is even launched, right in the Dust chat or via @Dust in Slack.
@Dust check all invoices from June 2026 and identify any with a missing or unrecognised GL code in our chart of accounts.
GL Mapping Audit — June 2026 Invoices
Invoices analysed: 247 | Chart of accounts loaded: 412 active GL codes
Results:
Detail of the 14 invoices without a GL code:
| Invoice | Supplier | Amount | Date | Category |
|---|---|---|---|---|
| INV-2026-1847 | Notion Enterprise | 2,400 € | 3 Jun | SaaS |
| INV-2026-1863 | Doctolib | 1,800 € | 5 Jun | Health SaaS |
| INV-2026-1891 | Meetup Pro | 890 € | 8 Jun | Marketing |
| INV-2026-1924 | Typeform | 540 € | 12 Jun | SaaS |
| … | … | … | … | … |
| Total | 18,740 € |
9 invoices with invalid GL code:
Would you like me to generate the list of corrections in CSV format for bulk import?
A shared agent for the whole accounting team
Unlike a skill installed individually, a Dust agent published on the workspace is immediately available to any accountant who needs to check GL mapping — no need for each person to reconfigure the same check.
Identifying categories with the highest GL error rates
Knowing which spend categories generate the most GL errors allows you to target structural fixes — for example, updating the default mapping in Spendesk for those categories so the problem doesn't recur every month.
@Dust which spend categories have the highest rate of missing GL codes?
GL Anomaly Rate by Category — June 2026
| Category | Total invoices | Missing GL | Invalid GL | Anomaly rate |
|---|---|---|---|---|
| SaaS / Software | 68 | 9 | 5 | 20.6% 🔴 |
| Marketing & Events | 31 | 3 | 2 | 16.1% 🟡 |
| Contractors | 44 | 2 | 1 | 6.8% 🟡 |
| Cloud Infrastructure | 28 | 0 | 1 | 3.6% 🟢 |
| General Expenses | 76 | 0 | 0 | 0% ✅ |
Analysis:
Would you like the list of affected SaaS suppliers to check whether the issue is tied to a specific invoice type?
Detecting GL codes used in Spendesk that don't exist in the chart of accounts
Over time, obsolete or incorrectly entered GL codes accumulate in Spendesk. This cross-reference analysis lets you clean house once and for all before the year-end close.
@Dust are there GL codes used in Spendesk that don't exist in our current chart of accounts?
Consistency Audit — Spendesk GL Codes vs Current Chart of Accounts
I've compared all GL codes used in your invoices over the past 12 months against the 412 active codes in your chart of accounts.
GL codes used in Spendesk but absent from the chart of accounts:
| GL Code | Uses (12 months) | Total billed | Last used | Likely status |
|---|---|---|---|---|
| 6150 | 34 | 28,400 € | 15 Jun 2026 | Replaced by 6151 |
| 6280 | 8 | 9,100 € | 3 Jun 2026 | Unknown — verify |
| 4401 | 3 | 4,200 € | 28 Feb 2026 | Old nomenclature |
| 6063 | 2 | 1,800 € | 15 Jan 2026 | Merged with 6062 |
Total affected: 47 invoices — 43,500 €
Would you like me to prepare the correction file with suggested replacements?
Automating the check before every export
Once validated manually, this check can be re-run automatically by a Dust Trigger a few days before every monthly export — the result lands in the close channel before anyone launches the ERP import.
Key Takeaways
- GL mapping errors are predictable — catching them before export saves 2–3 hours of emergency fixes on close day
- A Dust agent cross-references the month's invoices against the official chart of accounts in real time, with no manual export
- Categories with the highest anomaly rates can be structurally corrected once to prevent recurrence
- Obsolete GL codes accumulate silently — an annual audit prevents year-end surprises
- A published agent saves every accountant from reconfiguring the same check
Related skills