VAT reconciliations, automated in seconds

Alteryx

Two sources, one reconciliation. An Alteryx workflow imports the VAT line items by tax code from two ledgers in two formats, joins them, calculates the difference on every VAT-sensitive account and flags the exceptions, gaps and errors, so the review that used to take days runs in seconds.

Transcript: the words on screen

1. 0:00Two ledgers. Two formats. Sound familiar?
2. 0:02Alteryx automation / VAT reconciliations, automated in seconds. / Import / Cleanse / Join / Review
3. 0:05How it works / Two sources, one reconciliation.
4. 0:1001 · Two formats / Ledger 1A: VAT line items, by tax code.
5. 0:1401 · Two formats / Ledger 0L: account balances, by G/L account.
6. 0:1902 · Alteryx / Import both source files.
7. 0:21Two data files
8. 0:2302 · Alteryx / Cleanse and standardise both, focusing on sales accounts.
9. 0:28With tax code · no tax code
10. 0:2802 · Alteryx / Join, compare and calculate the difference.
11. 0:30Output and report
12. 0:3202 · Alteryx / Gap analysis, exceptions and error checks.
13. 0:33One workflow covers
14. 0:33Gap analysis: in one source, not the other
15. 0:34Exception reports for review
16. 0:35Error checking
17. 0:3803 · Result / VAT-sensitive accounts, reconciled in seconds.
18. 0:43Account reconciliations
19. 0:4303 · Result / Review, validate, report exceptions.
20. 0:44Exception reporting
21. 0:45Quality gaps
22. 0:4603 · Result / The review, automated.
23. 0:47Automating the review means
24. 0:47Less time
25. 0:48Less effort
26. 0:49Less risk
27. 0:5204 · Every period / Build it once. Rerun it every period.
28. 0:57In summary / Goodbye, manual reconciliations.
29. 0:57Two ledgers, any format / VAT-sensitive accounts reconciled in seconds / Exceptions, gaps and errors flagged / Less time, effort and risk