I've got a client who has gone onto Sage Business Cloud. I've done the first year and found Sage quite good, obviously copying a lot of the way Xero works. But second year, I can't seem to get a meaningful trial balance.
You have two options, "this period" which is purely the movements in this year, so the profit will work, but balance sheet obviously doesnt.
Other option is to show opening and closing balances. There are then 3 columns, opening balances, this period (same as above) and closing balances. Opening balance is exactly the same as the previous years balances, including all the previous years P&L. Middle column is the same as 'this period' above, so just the movements in the year. And closing balance adds the two. So Balance sheet is correct, but the P&L is the running total, ie last years profits and this years profits.
So none of the columns are any use as a TB.
I guess I can export to csv and splice together the balance sheet items from the 'closing balances' and the P&L from the 'this period' but surely there should just be a normal TB there ?
Has anybody else used it, or know how to get it to work ?