Trial Balance with OPENING / CLOSING balance and and Movement from GL Summary Report
Team Xero
currently TB report shows ending balances for current year in db/cr two columns AND in single column Clubbed up remaining balances +/- in when COMPANRED to previous periods.
I propose/request IT to make TB more classic by
- showing ALL remaining balances in two columns DB/CR when comparing previous years
- OPENING and CLOSING balances columns to be available (year selected from starting of fiscal year Jan20xx)
- TB report to ALLOW us to SELECT RANGE of dates (Range based TB)
- MOVEMENT (total Debits Total Credits) for the selected DATE and/OR RANGE should be available. CURRENTLY this is available in GL SUMMARY REPORT
my personal case experience for you all
to produce comparative last two years classic TB for my auditor
1. I set rand compare 2 years TB by setting date as 30/03/2025 this gives me +/- one line ending balances for two years.
2. now from GL summary I selected Range 1/1/2024 till 31/12/2024 and downloaded MOvement and vlookedup against account numbers and constructed Movement between two comparitve years.
but still the ending and opening balances were in one line which is confusing for external auditor at first to learn charts of accounts. however for now my work for TB was done but this could be easier
