Alteryx automation for finance
Monthly income statements, in under a second
1 min 20 sec. Don't adjust your speakers: there is no sound. The captions do the talking.
Three inputs in, a statement for every company out. One Alteryx workflow imports every company's trial balance and the adjustments, cleans them, brings in your statutory mapping file, calculates the sub-totals from gross profit down with prior year and variances, puts the lines in reporting order and publishes a finished PDF for every entity, in 0.6 seconds.
Transcript: the words on screen
- 0:00Every month. Every company. An income statement each.
- 0:03Alteryx automation / Monthly income statements, in under a second. / Import · Clean · Map · Publish
- 0:05How it works / Three inputs in. A statement for every company out.
- 0:0901 · Alteryx / One workflow, start to finish.
- 0:11Import · combine · map · calculate · publish
- 0:1501 · Alteryx / Every statement, finished in 0.6 seconds.
- 0:16Every company, every month
- 0:1902 · Import / Every company's trial balance, in one go.
- 0:20Trial balances for every entity
- 0:2402 · Import / Adjustments added and cleaned automatically.
- 0:25Nulls replaced, adjustments totalled
- 0:2903 · Prepare / Account codes rolled up.
- 0:3303 · Prepare / Your statutory mapping file, brought in.
- 0:34Statutory account descriptions
- 0:3803 · Prepare / Statutory headings joined to every account.
- 0:4204 · Calculate / Summed up by statutory heading.
- 0:4704 · Calculate / Sub-totals calculated, from gross profit down.
- 0:5105 · Compare / Prior year brought in, variances calculated.
- 0:53Current year · prior year · variance
- 0:5605 · Compare / Put into reporting order.
- 0:58Revenue first, cost of sales second
- 1:0106 · Publish / A finished income statement for every company.
- 1:0606 · Publish / Exported: one PDF per company.
- 1:07A PDF for every entity
- 1:11In summary / One simple example. Endless opportunities. / Every company, every month, in seconds / Adjustments and mapping applied the same way every time / Prior year and variances built in / A finished PDF for every entity
Recorded by Osprey Consulting: Thomson Reuters ONESOURCE Certified Implementers, Alphatax partner, Registered Alteryx Solution Provider Partner.