client has done a year end close down, before a TB has been taken
how can we extract the prior years TB now?
Related resources
Replies (7)
Please login or register to join the discussion.
I do not have acccess to Sage, i haven't worked since last May, but from memory in the text menu, top left, you go to file/archive (or similar)/prior year(or similar).
If that fails, then I usually use run the Brought Forward TB for the Balance Sheet figures, then use the journals posted at the year end close for the P&L figures. The total of those journals deduct from the Balance Sheet P&L brought forward.
There is also a 'Transactional TB' in reports that allows a TB to be produced for any date range.
I don't use Sage much these days, but it seems to me that running the transactional trial balance over the previous financial year will pick up the journal entries that zero out each account when the year end is run, so most expense and income codes will show no net activity.
I don't know any way to get around that - always willing to learn!
I do as SkyBlue22 and find the y/e journals in the transactions list
Run the Transactional TB report for all dates up to the year-end and for all transaction numbers up to and including the last number before the year-end journal starts. That way the P&L nominals will not have been zeroed.
Alternatively, use the journal reversal feature to reverse the year-end journal, and then put the financial year back 12 months. I wouldn't get the client to do this but it's okay if working from a backup.
