Alteryx automation

One tax-sensitised master trial balance

1 min 14 sec. No narration, captions on screen.

Three ERPs into one tax-sensitised master trial balance, in 1 minute 14 seconds. No narration, captions on screen.

Alteryx

Three ERPs, three trial balances, three formats. One Alteryx workflow maps SAP, Oracle and NetSuite trial balances to a single master chart of accounts, tax-sensitises them in the same flow, and produces one master trial balance with the accounts that need tax analysis identified, in under a second.

Alteryx for tax and finance → Book a 30-minute call Also on YouTube
Transcript: the words on screen
  1. 0:00Three ERPs. Three trial balances. Three formats.
  2. 0:02Alteryx automation / One tax-sensitised master trial balance. / Combine · Map · Check · Flag
  3. 0:04How it works / Every ERP, one master trial balance.
  4. 0:0901 · Alteryx / One workflow for SAP, Oracle and NetSuite.
  5. 0:1301 · Alteryx / Mapped to a single master chart of accounts.
  6. 0:15Master trial balance for all entities
  7. 0:1801 · Alteryx / Tax-sensitised in the same flow.
  8. 0:19Codes for tax analysis, identified
  9. 0:2201 · Alteryx / Finished in 0.6 seconds.
  10. 0:2602 · Combine / Each has its own codes and column format.
  11. 0:26SAP: distinct code structure
  12. 0:29NetSuite: its own naming convention
  13. 0:3102 · Combine / A master mapping file brings them together.
  14. 0:31SAP · Oracle · NetSuite → master code
  15. 0:3502 · Combine / Also mapped, ready for the statutory accounts.
  16. 0:37Statutory account description
  17. 0:4003 · Output / The full master trial balance, ready for tax.
  18. 0:43Ready for further tax automation
  19. 0:4603 · Output / One source of truth for tax.
  20. 0:46A master trial balance means / Every ERP on one chart of accounts / Built once, automated every period / One tax rule set, applied to every entity
  21. 0:51Built-in checks / New, unmapped codes land in an error report.
  22. 0:52CHECK: new unmapped account codes
  23. 0:5604 · Tax-sensitised / Tax-sensitive codes and key words, flagged.
  24. 0:58Damages · Repairs · Legal · Entertainment · Fines
  25. 1:0004 · Tax-sensitised / The output: accounts ready for tax analysis.
  26. 1:02Account codes requiring tax analysis
  27. 1:05In summary / One simple example. Endless opportunities. / One chart of accounts across ERPs / Automated every period / One tax rule set to maintain, not many / Accounts flagged for tax analysis
More short videos

Three more, each with its own page

30 sec From four weeks to four minutes, in 30 seconds 1 min 16 sec Review every tax computation at once 1 min 6 sec VAT reconciliations, automated in seconds
The whole library