Reports - 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
Yaseen Hamed
shared this idea
Hi Yaseen, thank you for this incredibly detailed and well-thought-out suggestion for the Trial Balance report.
We can see how much manual work you're doing, combining exports from the GL Summary Report, just to create a "classic" comparative Trial Balance for your auditors. That's exactly the kind of difficult workflow we want to help improve.
Your proposal to enhance the report with separate debit/credit columns for comparatives, clear opening/closing balances, and a movement column for a selected date range is very clear.
We're grateful for your engagement and for letting us know the changes that matter to you. We've reviewed your idea and now it can gain support from other community members. Along with votes, others can now comment to share additional detail about how these reporting improvements would help them during audits and financial analysis.
