Trial balance sorting and sub-totals

Once imported the raw trial balance data should be in the correct section (if section column or section names used on input – see trial balance import) – if not it will need to be sorted as follows:

  • May drag and drop lines to change section or sequence from drag handle that appears to the right when hovering over a line (only one line at a time)
  • May also change the section by using edit option from dropdown that appears to right while hovering over line
  • May drag headings from the bottom into position if required from drag handle that appears on heading when hovering over it
  • Lines may be manually added, edited or deleted from drop-down box that appears to the right when hovering over a line: AA1.png

Once sorted the trial balance data may be subtotalled (e.g. total - GST below): 

AA1.png

  • Used to combine figures to match the trial balance amounts to the draft financial statements or for totalling divisions or classes of accounts
  • May create subtotals as required from add total option in drop-down that appears when hovering over an account line
  • Individual accounts or subtotals may be flagged (click star to right of line item) as risks for further analysis (see risk identification and analysis)
  • Subtotals may be moved by dragging and dropping into different places from drag handle that appears whole hovering over them - total will update
  • Subtotals calculate on lines above them up to section heading or to another sub-total - only one level of totals may be created
  • Subtotals created in one year are maintained for future years after roll-over and may be further edited or deleted as required
  • Once the required section lead schedules are created from A1 evidential testing area subtotals are automatically transferred onto these (with line data) from trial balance page
Have more questions? Submit a request

Subscribe to our mailing list

We have a regular newsletter which includes the latest updates in the audit and assurance space as well as on to our latest work.

Click here to view previous newsletters, enter your email bellow to subscribe.