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 by clicking the row while moving the mouse
  • May select multiple lines to drag by holding ctrl/cmd or shift while clicking rows (selected line show as blue)
  • Selected lines may also be deleted using delete key

        Screen_Shot_2019-08-19_at_10.58.09_AM.png

  • May also change the section by using edit option on the left side of the row (pencil icon)
  • Lines and subtotals may be manually added from drop-down box that appears to the right when hovering over a line:

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.