Tax disclosures, automated in Alteryx

Corporate TaxStatutory ReportingAlteryxAPIs

The tax note still needs completing. An Alteryx workflow takes the tax account, tax reconciliation and disclosures from ONESOURCE Corporate Tax and posts them into ONESOURCE Statutory Reporting by API, with the tax journal posted at the same time, every adjustment valued in both systems, and a red error when data is missing.

Transcript: the words on screen

1. 0:00The tax note still needs completing.
2. 0:02Alteryx + ONESOURCE / Tax disclosures, automated in Alteryx. / Import · Transform · Push · Reconcile
3. 0:04How it connects / Alteryx connects both, by API.
4. 0:0901 · The gap / In Statutory Reporting, the tax note is empty.
5. 0:11TaxTech Limited · 2023
6. 0:1301 · The gap / Rekeying between systems costs time.
7. 0:15Manual data entry between systems is / Time-consuming / Prone to error / A rather boring task
8. 0:2001 · The gap / Deferred tax is blank too.
9. 0:2401 · The gap / The disclosures already exist in Corporate Tax.
10. 0:27Corporate Tax I sheets
11. 0:2901 · The gap / Tax account, tax reconciliation, disclosures.
12. 0:3402 · Alteryx / Enter the year, then run.
13. 0:352023
14. 0:3802 · Alteryx / Import, reformat, push, with journals.
15. 0:41Disclosures and journals, one run
16. 0:4302 · Alteryx / Finished, with every step checked.
17. 0:4703 · Reconcile / Two reconciliations, built in.
18. 0:50OCT agrees to OSR · OCT does not agree
19. 0:5203 · Reconcile / Every adjustment, valued in both systems.
20. 0:55OCT value · OSR value
21. 0:5703 · Reconcile / An audit trail for you and your auditors.
22. 1:0104 · Complete / Refresh: the tax note is complete.
23. 1:0604 · Complete / Existing or outdated disclosures are updated too.
24. 1:1004 · Complete / Deferred tax, complete too.
25. 1:1504 · Complete / The tax journal, posted at the same time.
26. 1:18Tax journal · TAX001
27. 1:2004 · Complete / Every computation, every set of accounts, at once.
28. 1:22One run, the whole dataset
29. 1:24Built-in checks / Test it: delete the posted tax journals.
30. 1:29Built-in checks / Then switch off posting in Alteryx.
31. 1:31Posting disabled
32. 1:33Built-in checks / Run it again.
33. 1:360 iterations run: nothing posted
34. 1:38Built-in checks / A red error: data missing in OSR.
35. 1:415 OCT tax items have no value in OSR
36. 1:43Built-in checks / The browse tool shows exactly what’s missing.
37. 1:46OSR value: null
38. 1:48In summary / At the push of a button. / Tax disclosures from the I sheets, posted into OSR / Existing or outdated disclosures updated / Journals created at the same time / Reconciliation checks flag issues immediately