x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 29 subscribers
  • Views 517 views
  • Users 0 members are here
Browse Forums
Announcements
73
topics
0
replies
Making Tax Digital
37
topics
47
replies
Sage Accounting General Discussion
1k
topics
2k
replies
Sage Accounting Start General Discussion
168
topics
280
replies
Sage Individual General Discussion
19
topics
34
replies
Jone

Trial Balance with ALL codes including zero balances

Posted By

Dear Forum,

I create my management accounts by mapping a trial balance into Excel. For this to work consistently without having to change excel formulae each month I need the same lines to be reproduced in the Trial Balance each month. I therefore plan to export a trial balance including zero balances.

But am I right in thinking each code has to have a transaction too? I have worked around this by entering dummy journals in "empty" codes ie. Dr 0.01 Cr 0.01   

Is this the only solution or is there another way to ensure my trial balance export includes all nominal codes?

Many thanks,
Jon

  • 0

    Hi Jon, 

    Thanks for your post! 

    You can export your Trial Balance with a custom filter to make sure nominals codes that have a zero balance are included in the report. To do this, go to Reporting > Trial Balance > Customise > Rows, then under the 'Exclude' option you need to untick Zero values. 

    I hope this resolves the issue you're having. If not, let me know and I'll see if there's anything else we can do to help. 

    Thanks,

    Dane
    Sage UKI

  • 0 in reply to Dane

    Thank you Dane, I will try that. I used to do something similar in my previous Sage 50 with a custom report (which Sage wrote for me actually). I'm basically looking to achieve a static TB that will populate my excel management accounts consistently. I've always done it this way and am surprised I don't find many other Sage users/book keepers asking the same question. Anyway, thanks for the tip, which I'll test to see if it brings up all nominal codes. Cheers Jon

  • 0 in reply to Dane

    Hi again Dane, I'm stuck after Reporting>Trial Balance   I can't see an option to Customise  (I can only see Custom but that just relates to dates not rows etc). Thanks again. Jon

*Community Hub is the new name for Sage City