Business Software Solutions from Trax UK

Reporting in Microsoft® Excel for Sage 50 Accounts

Simple management accounts...

• Do you need to produce reports that show information by department as well as time period?

• Do you re-key management accounts information into Excel each month?

• Would you benefit from the time saving of having your management accounts template directly linked to your Sage 50 Accounts data, refreshable at the touch of a button?

To complement our Departmental View for Sage 50 Accounts, we have created an Excel function which allows you to report a balance on a nominal code by department.

This allows you to create fully customisable management reports within Excel,  grouping funds, departments or nominal codes together with ease.

Your management accounts production becomes a matter of changing your reporting dates and clicking ‘refresh’.

Templates can be created to fit your existing layouts, and are easy to modify when you need to make a change, such as adding a new nominal code or department.

Sage Reporting:

• Date(s)

• Nominal(s)

• Department(s)

• Fund(s)

• Transaction type(s)

• Actuals

• Budgets

• Forecasts

	Efficiently create integrated Excel management accounts Group non-consecutive department or nominal code ranges within your Excel reports Refresh your accounts at the touch of a button Easily reformat your reports using the additional functionality provided by Microsoft® Excel Charities can report by nominal code, department and fund number

Click here to download brochure.

Click here to download sample accounts.

Click here to download the installation guide.

Click here to download transation type information.

Click here to view the demo.

Click Here to download the flyer