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
- May also change the section by using edit option on the left side of the row (pencil icon)
- Totals for each section have a solid line above and double line below them. These will show at the bottom of every section and are recalculated every time something on the Trial Balance is updated.
- Lines and subtotals may be manually added from the 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):
- 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 the drop-down that appears when hovering over an account line
- Individual accounts or subtotals may be flagged (click star to the 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