ONESOURCE Statutory Reporting, how to
Add a new analysis table, checked to the trial balance
3 min 2 sec. Don't adjust your speakers: there is no sound. The captions do the talking.
Does your analysis agree to the trial balance? A how-to inside ONESOURCE Statutory Reporting: add detail to the turnover note through a data capture table, reuse the reporting table OSR builds for you, give it its own numbered note, and add a calculation row that shows a red out-of-balance figure only when the table and the trial balance do not tie.
Transcript: the words on screen
- 0:00Does your analysis agree to the trial balance?
- 0:03OSR capabilities / Add a new analysis table, checked to the TB. / Capture · Present · Reconcile · Test
- 0:05How it works / The table, checked against the trial balance.
- 0:1001 · The template / Start with the turnover note.
- 0:12Sale of goods: 237,675,897
- 0:1501 · The template / The aim: more detail on sale of goods.
- 0:2002 · Capture the data / Open Non-Import Custom Disclosures.
- 0:22Note 1 · Section 1 · Standard table
- 0:2502 · Capture the data / Add three rows to Section 1.
- 0:3002 · Capture the data / Copy the analysis from Excel.
- 0:3502 · Capture the data / Paste the descriptions and both years.
- 0:37Current and prior period
- 0:4002 · Capture the data / Save, and go back to the report.
- 0:4503 · Present it / An existing table gives you standard reports for free.
- 0:47Standard table: profit and loss
- 0:5003 · Present it / Cut the standard table.
- 0:5503 · Present it / Paste it after the turnover note.
- 1:0003 · Present it / The breakdown now sits under turnover.
- 1:0504 · Its own note / Want a separate note? Add a report element.
- 1:1004 · Its own note / Pick a folder with a note number and heading.
- 1:1504 · Its own note / Cut the table, then Paste inside the new folder.
- 1:2004 · Its own note / Paste the table inside it.
- 1:22Note 4
- 1:2504 · Its own note / Rename it in Options.
- 1:27Turnover analysis
- 1:3004 · Its own note / The note heading updates itself.
- 1:3504 · Its own note / Remove the heading expression; tidy the text.
- 1:37Analysis of sale of goods is as follows:
- 1:4004 · Its own note / Note 4: turnover analysis.
- 1:4505 · Reconcile / Open the smart table editor.
- 1:5005 · Reconcile / Insert a new section: Section B.
- 1:5505 · Reconcile / Bring in a category of trial balance lines.
- 1:57Categories group trial balance codes
- 2:0005 · Reconcile / P 1 1: sale of goods.
- 2:02Subsection ‘Sale of goods’ added
- 2:0505 · Reconcile / Set it never to display.
- 2:07Used for the calculation only
- 2:1005 · Reconcile / Section B sits behind the table.
- 2:1505 · Reconcile / Add a calculation row.
- 2:2005 · Reconcile / Out of balance: Section A plus Section B.
- 2:22SectionA + SectionB (P 1 1 comes through negative)
- 2:2505 · Reconcile / Shown only when non-zero, and coloured red.
- 2:3005 · Reconcile / The total and the check, in the table.
- 2:3506 · Test it / Refresh: nothing new shows. It ties.
- 2:37Note 4 agrees to note 3
- 2:4006 · Test it / Now remove the 26 million.
- 2:42Components and spares
- 2:4506 · Test it / Refresh: out of balance, in red.
- 2:47Ledger 237,675,897 · analysis 211,019,865
- 2:49Out of balance (26,656,032)
- 2:52In summary / What we covered. / Add your own analysis to any note / Reuse the reporting table OSR builds for you / Give it its own numbered note / A red out-of-balance row when it doesn’t tie
Recorded by Osprey Consulting: Thomson Reuters ONESOURCE Certified Implementers, Alphatax partner, Registered Alteryx Solution Provider Partner.