Sage Line 50 Departmental Reports- Help!

Sage Line 50 Departmental Reports- Help!

Didn't find your answer?

I hope somebody can help me.We use sage line 50,There are 7 companies within the group for which I do the accounts for.My boss set up a series of spreadsheets years ago which he uses as a profit/loss a/c and cash flow forecast.

At present I "file" a trial balance at the month end and save as a csv excel file which is then linked into these spreadsheets he's designed which give him the profit/ loss for the month (exactly the same as the p & l which would come from sage).The reason he wants to do it this way is that its linked to all the budgets.(There's no chance of changing his mind!)

This works fine at the moment.The problem i've got for next year is that within each company he wants separate divisions set up ie departments, which I can do but can I run off a trial balance by department? which i could then save as a csv excel file.(The budgets have now been prepared by company and then by division).

So to put it in a nutshell can I (file and save as a csv file) a trial balance report by department??
Thank you for your time.
Paul Cooper

Replies (6)

Please login or register to join the discussion.

avatar
By User deleted
17th Nov 2006 10:36

In a nutshell, yes!
If you click on to the 'financials' module as normal, then click on to 'reports' (not trial balance). Scroll down the reports list until you findl 'transactional reports'. Click onto transactional trial balance and it will allow you ro specify a date rate and department range.

Thanks (0)
avatar
By derwentdelivers
17th Nov 2006 10:40

Transactional Trial Balances - very useful
Yes this is possible, if you go into financials and reports, then click on Trial balance reports you can then click on Transactional trial balance and send this to a csv file. This will work on most versions on sage but i am having trouble with the new version 13 and csv reports in excel.

If you have the sage links setup in excel called "sage integrated reporting" you can insert and update various reports such as trial balances which i find really useful and all of my management accounts are generated from these. Once again if you are on version 13 the new software doesn't like some of the reports which version 12 did.

Thanks (0)
avatar
By acmakey
24th Nov 2006 17:36

Sage departmental TB
I have had the same problem for a few years - and talked to Sage about it with no resolution. Using the transactional TB and saving to a csv file actually puts every transaction into the csv file, rather than just the account balance for that particular department - this happens even if you preview the department TB and then "Save as" a csv file.
What I do is preview the transactional TB and then "save as" a txt file - then open it in excel ensuring the delimiters are set correctly etc - this works but is a little long winded.
Am I missing something?

Thanks (0)
avatar
By David Carter
27th Nov 2006 10:39

If you have version 11....
Andrew, as Raymond mentions, if you have Sage version 11 or later you can use Sage Integrated reporting, which links Excel to the Sage database via ODBC

Go into Excel and find the Sage menu. Then run the Nominal Activity by Department report . This contains balances, rather than transactions as with csv.

[N.B. You can find other items on Sage departmental reporting in: IT - Management Reporting - Any Answers - More - Reporting Resource #16]

Thanks (0)
avatar
By excelinbusiness
29th Nov 2006 16:27

Use Sage Intelligent Reporting
Sage Intelligent Reporting, an "out-the-box" advanced reporting tool for Sage Line 50 handles this requirement in a matter of minutes. As part of the standard pack of Excel reports delivered with Sage Intelligent Reporting, you get a p&L and balance sheet by department. What makes this more impressive is that the reports are fully interactive with full drilldown capabilities (in Excel) and you can produce a departmental P&L (or balance sheet) for any period over the last 5 years in a matter of seconds.

Thanks (0)
avatar
By bsnashall
12th Nov 2009 16:57

Sage Excel add-in for departmental reporting

 

All successful businesses are built upon the ability to produce accurate, reliable and meaningful management information, but this can still be an onerous and costly task. Enter - “The Analyser”. “If you use Sage 50 then you should also have The Analyser”, was said at the recent Softworld Accounting and Finance show.    The Analyser was born out of the constraints other report writers, place upon the user. It is an impressive yet simple Reporting Tool utilising the flexibility of Excel, extracting figures directly from the Sage 50 data. The versatile and user-friendly functions can be added to any existing management reporting templates or new spreadsheets can be created within minutes. There is no need for in depth training; if you can use Excel then you can use The Analyser. At the touch of a button, The Analyser extracts both actual and budget data from non-consecutive departments, nominal codes and funds (Charity users only) for any date range. This has enabled existing users to report their own business characteristics not previously possible. An example highlighting this unique function is a company in the leisure industry which can now monitor their financial data by school holidays, along side their traditional monthly reporting, over a rolling five year period.. With this in-depth information effective and efficient decision making, planning and control can be achieved. Additional benefits of The Analyser include the option to add prior year’s data alongside the current year for comparative purposes and to report on single or multiple companies, in one workbook. Furthermore from the face of the Excel reports any value can be drilled down to show the under-lying transactions, without the need to even open the Sage application. The Analyser is a natural addition to your desktop, empowering your business reporting by exchanging re-keying with recalculating - saving time and money. For further information please contact Barry Snashall on 01227 793200 or email at [email protected]

Thanks (0)