Every trial balance, into Statutory Reporting

Statutory ReportingAlteryxAPIs

Seven entities, seven trial balances, loaded into ONESOURCE Statutory Reporting by API from one Alteryx workflow. Set up once, it reads the entities and periods itself, posts every trial balance as a journal, flags a missing entity or period, and next year you change the year and press run.

Transcript: the words on screen

1. 0:00Seven entities. / Seven trial balances.
2. 0:02Alteryx + ONESOURCE / Every trial balance, into Statutory Reporting. / Collect · Check · Replace · Post
3. 0:03How it connects / Alteryx posts every trial balance by API.
4. 0:0901 · The start / A trial balance for each entity, in one folder.
5. 0:1301 · The start / This entity has no journals in Statutory Reporting yet.
6. 0:1702 · Alteryx / Set up once. It reads entities and periods itself.
7. 0:18Instructions built into the workflow
8. 0:21Only entities with a trial balance
9. 0:2202 · Alteryx / Run until selected: preview what gets deleted.
10. 0:25Six journals poised for deletion
11. 0:2702 · Alteryx / Old journals out, new journals posted.
12. 0:28Deletes the old journals first
13. 0:316 journals deleted successfully
14. 0:3202 · Alteryx / Every API call is counted and checked.
15. 0:34Deletions · submissions · missing accounts
16. 0:3702 · Alteryx / Done in 52.9 seconds. Errors flag problems.
17. 0:41Run summary / 6 journals deleted / 7 journals created / Finished in 52.9 seconds
18. 0:4303 · Result / The trial balance, posted as a journal.
19. 0:46Trial Balance Import · AYX Submission
20. 0:48Built-in checks / Second run: two bad trial balances dropped in.
21. 0:497 deleted · 7 created · 2 not submitted
22. 0:53Built-in checks / Missing entity or period? Alteryx flags it.
23. 0:55No matching entity and financial period
24. 0:59Built-in checks / Codes differ? Map trial balance to OSR entity.
25. 1:02TB to OSR entity mapping
26. 1:04Built-in checks / Missing accounts are caught too.
27. 1:06Alteryx flags an account does not exist
28. 1:0804 · Your settings / Credentials, year, columns and journal details: yours to set.
29. 1:11Original Trial Balance · AYX Submission
30. 1:1304 · Your settings / Each year, just change the year and press run.
31. 1:15Change the year. Press run.
32. 1:18In summary / All entities, in one go. / Loads every trial balance in the folder / Matches entities and periods; maps codes that differ / Re-run any time: old journals replaced, not duplicated / Checks deletions, submissions, missing accounts and unbalanced TBs / Can connect straight to your ERP