Sage 50 departmental analysis

Sage 50 departmental analysis

Didn't find your answer?

We have a company with a number of branches and need to produce individual branch accounts.
Does anyone have any experience in using Sage's department codes in order to provide an analysis of profit and loss headings over the branches( departments). I am interested to know whether the output report is useful and also whether it always reconciles to the Nominal Ledger.

Also has anyone linked sage payroll to the nominal where you need to post gross wages apportioned over a number of operating branches? I have been told that the only way to do this is by using Sage departments.

Thanks in advance to anyone for their comments....

Replies (4)

Please login or register to join the discussion.

By Moonbeam
04th Dec 2015 18:23

Departments is the only way to do it

Departmental coding comes with its own problems. For example the program doesn't force you to enter a departmental code, so you will need to run the departmental reports for department 0 which is the number given to all transacs unless you change it, to make sure there is nothing there that should have had a different code on.

You then edit the appropriate lines and run a departmental report for all the department codes to give you the analysis. I have done this for a 4 profit centre company. All I can say is you get faster at it.

If you get a departmental report for all departments, then that report should total up to a TB figure at whatever period you've selected

Once I was happy with the data for each department I would pull it into a spreadsheet for presentation purposes.

Thanks (1)
Replying to Duggimon:
avatar
By Stephen Knowles
06th Dec 2015 16:23

Sage departmental analysis
Thanks very much for your extremely useful comments....

Thanks (0)
Routemaster image
By tom123
05th Dec 2015 09:09

Sage payroll

I use Sage payroll (in our case linked to Sage 200). You would need to assign each employee to a department in Sage payroll, and then set up the link to the relevant gross pay nominal(s) and departments in S50.

As far as I know, you cannot 'split' one person's gross pay between different nominals - although you may not really be doing that.

If you really did need to do something like that, you would need to set the employee up with two or more separate pay elements, and map each one to a specific nominal.

You would need to let any employees know if you were doing this, though, as the payslips could look a bit odd.

Thanks (1)
By Onion4Sage
05th Dec 2015 14:37

Significantly enhanced departmental reporting available

A number of third party suppliers: Optegra Financial; Trax UK; BVXL; Pendragon Systems; and, our own Onion Reporting Software (there may be others), provide products that significantly enhance the departmental reporting capabilities available in the Sage 50 family of products. They absolutely guarantee that the departmental analyses reconcile to the Nominal Ledger, accurate to the penny. Facilities to report at departmental level across a group of companies are available too, as well as "departmental splitting" to provide individual spreadsheet files for each department. 

Happy to have a chat about your requirements if you PM me.

Regards,

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Comprehensive Sage reporting packs in Excel to go. No set-up necessary.  

Thanks (1)