Skip to main content

HandiLedger - Create a Trial Balance with multiple previous years in HandiLedger

Updated over a month ago

To create a trial balance with multiple previous years balance for comparative purposes, follow the instructions below:

  1. Log in to HandiLedger.

  2. From the Reports menu, click Format Editor.

  3. Click the File menu and then click Open.

  4. Highlight the format with the name TB-CP-W to change, and then click Select.

  5. As the format is not user-defined, you must save it to another name before you can edit it.

  6. Click the File menu and then click Save As.

  7. Type in a new name for the format, change the Layout option to Wide and click OK.

  8. Click Edit.

  9. Click on the Add button under the Columns section.

    Column details window
  10. Enter in the Column properties section, You may need to adjust the width to allow all items to fit on the page:

    1. Name as DR - Prior 2.

    2. Type as Trial Balance Dr.

    3. Year as Minus 2.

    4. Width as 25.

    5. Left margin as 1.

      Column properties window
  11. Repeat steps 8 and 9 for the Credit column changing the Dr to Cr in Name and Type.

  12. When all changes have been made, click OK to return to the “Format editor” window.

  13. From the File menu, click Save to save the format, and Close. The modified format should now be available for selection.

  14. Go to Reports on the main menu and click Preferred Reports.

  15. You need to have your set of reports in the Selected Entity tab, If you have not already copied a master report over to the Selected Entity tab please press Copy on the report master required.

  16. On the Reports menu highlight the Comparative Trial Balance.

    Master preferred reports window
  17. Click on Edit to change the format to the newly created format.

  18. Click on Select Format and find the newly created format from the list​.

    Preferred report add/edit window
  19. Highlight the format and click on Select.

    Select a format window
  20. Click on Ok and Close.

  21. Check the Comparative Trial Balance to check the report has the required changes.

Did this answer your question?