Add a new analysis table, checked to the trial balance

Statutory Reporting

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

1. 0:00Does your analysis agree to the trial balance?
2. 0:03OSR capabilities / Add a new analysis table, checked to the TB. / Capture · Present · Reconcile · Test
3. 0:05How it works / The table, checked against the trial balance.
4. 0:1001 · The template / Start with the turnover note.
5. 0:12Sale of goods: 237,675,897
6. 0:1501 · The template / The aim: more detail on sale of goods.
7. 0:2002 · Capture the data / Open Non-Import Custom Disclosures.
8. 0:22Note 1 · Section 1 · Standard table
9. 0:2502 · Capture the data / Add three rows to Section 1.
10. 0:3002 · Capture the data / Copy the analysis from Excel.
11. 0:3502 · Capture the data / Paste the descriptions and both years.
12. 0:37Current and prior period
13. 0:4002 · Capture the data / Save, and go back to the report.
14. 0:4503 · Present it / An existing table gives you standard reports for free.
15. 0:47Standard table: profit and loss
16. 0:5003 · Present it / Cut the standard table.
17. 0:5503 · Present it / Paste it after the turnover note.
18. 1:0003 · Present it / The breakdown now sits under turnover.
19. 1:0504 · Its own note / Want a separate note? Add a report element.
20. 1:1004 · Its own note / Pick a folder with a note number and heading.
21. 1:1504 · Its own note / Cut the table, then Paste inside the new folder.
22. 1:2004 · Its own note / Paste the table inside it.
23. 1:22Note 4
24. 1:2504 · Its own note / Rename it in Options.
25. 1:27Turnover analysis
26. 1:3004 · Its own note / The note heading updates itself.
27. 1:3504 · Its own note / Remove the heading expression; tidy the text.
28. 1:37Analysis of sale of goods is as follows:
29. 1:4004 · Its own note / Note 4: turnover analysis.
30. 1:4505 · Reconcile / Open the smart table editor.
31. 1:5005 · Reconcile / Insert a new section: Section B.
32. 1:5505 · Reconcile / Bring in a category of trial balance lines.
33. 1:57Categories group trial balance codes
34. 2:0005 · Reconcile / P 1 1: sale of goods.
35. 2:02Subsection ‘Sale of goods’ added
36. 2:0505 · Reconcile / Set it never to display.
37. 2:07Used for the calculation only
38. 2:1005 · Reconcile / Section B sits behind the table.
39. 2:1505 · Reconcile / Add a calculation row.
40. 2:2005 · Reconcile / Out of balance: Section A plus Section B.
41. 2:22SectionA + SectionB (P 1 1 comes through negative)
42. 2:2505 · Reconcile / Shown only when non-zero, and coloured red.
43. 2:3005 · Reconcile / The total and the check, in the table.
44. 2:3506 · Test it / Refresh: nothing new shows. It ties.
45. 2:37Note 4 agrees to note 3
46. 2:4006 · Test it / Now remove the 26 million.
47. 2:42Components and spares
48. 2:4506 · Test it / Refresh: out of balance, in red.
49. 2:47Ledger 237,675,897 · analysis 211,019,865
50. 2:49Out of balance (26,656,032)
51. 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