I am using Sage Line 50 for my business and have changed my accounting date from March to June
I would be grateful if someone can guide me to print a trial balance at 30th June 2014 (incorporating opening balances at 1st April 2013 with transactions for the 15 month period to 30th June 2014)
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Trial Balance Query
-
brucedenney
- Site Admin
- Posts: 4628
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Trial Balance Query
There are 2 ways to do this.
You can use the "transactional" TB in financial Reports, however, this is not available in some versions.
When you extend the year, the first months become part of the "Brought Forward" figure. So if you run as report including the Brought Forward figure then it will be the entire year.
You can use the "transactional" TB in financial Reports, however, this is not available in some versions.
When you extend the year, the first months become part of the "Brought Forward" figure. So if you run as report including the Brought Forward figure then it will be the entire year.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
Geordie613
- User
- Posts: 46
- Joined: 03 Feb 2015, 17:31
- Sage Version: v2018 24 UK/Europe/Africa
Re: Trial Balance Query
Hi Bruce,
The reply above helped me today. My client's accountant asked me why the nominal balances on the P&L didn't match the balances on the TB. A quick search on here revealed the existence of the Transactional Trial Balance which was spot on.
Thank you for your help, now and always, directly and indirectly.
Aaron
The reply above helped me today. My client's accountant asked me why the nominal balances on the P&L didn't match the balances on the TB. A quick search on here revealed the existence of the Transactional Trial Balance which was spot on.
Thank you for your help, now and always, directly and indirectly.
Aaron
"Difficulties mastered are opportunities won."
Sir Winston Churchill
Sir Winston Churchill
Who is online
Users browsing this forum: No registered users and 10 guests