Management Accounting Software

Management Accounting Software

Didn't find your answer?

Can anyone recomend a software which uses a similar input process as sage but which can produce management account reports which show month by month totals leading to an annual total.
Currently I am using sage to produce the monthly accounts and then I have to transfer the figures to excel on a monthly basis in order to produce a easily understandable report.

If anyone knows any please reply.
Trevor Fishbit

Replies (6)

Please login or register to join the discussion.

avatar
By AnonymousUser
11th Feb 2003 17:52

Sageforcast or Sagewinforecast
Have you looked at sageforecast which you get free if you have a sage line 50. It has some limitation. You can setup a hot link between sage line 50 and sagewinforecast, which will produce, monthly and YTD (JAN, FEB ETC YTD). Also it allows you to do budgeting as well. If you enter your budget figure for P & L and balance sheet opening figures then it will do a cash flow forecast, once you input actual (either manual or hotlink) then it will produce variance report comparing actual v/s budget etc.

This software would take you at least to set it up and learning etc. But once its done then it easy.

I hope this helps.

Nilesh Mandvia

Thanks (0)
avatar
By dclark
11th Feb 2003 17:25

Excel (sorry !)
Trevor,

We struggled looking at many many products to find such a solution. For a software vendor (at a reasonable price) to offer every view you want - columns, sub totals, expanded, etc ,etc - is unlikely to be good time spent by them, so some offer close, but not all

A few offer close to what you want, but the real sticking point was, although it was OK for one view, a few days later the request was "but can I compare this years quarter to lasts years in columns 2&3 and this month to last month in columns 4&5, compared to budget, summarised and not summarised, etc, etc"

At the end of the day excel is one of the best reporting tools (colours, fonts, headers ,footers, sub totals, totols, etc, etc) out there for the cost. Hyperion and others are fantastic, but generally outside the price range of many. 4 main options to get the data into the spreadsheet

1 export from accounting system
OK, but a repeated process and not totally satifactory, as you've highlighted

2 ODBC
OK, but you need to understand the data structure and the funny names packages use for fields (ie they've added two at the end of the file structure written 5 years ago, but they are completely at odds with any English we know)

3 excel add-in
great. Everything done for you by the software vendor. If you can manage the Sum function in excel, you've hit the hardest part. Once setup you merely open your spreadsheet and it re-calculates. Design your monthly accounts at will.

4 excel dump
some vendors have what I call an excel dump. What you see on screen is dumped with a hot key into excel. If the basic layout is there it bypasses the exports issues, so is great. However, it means you need to re-insert the totalling. Some packges can go both ways (ie from excel to the accounts pacakge and vice-versa), but the key often it is get the 'view' right so when you do dump WYSIWYG (rather than the detail behind)


All our products offer excel add-ins !!! (of course I'd say that)....come and see us at Softworld Stand 538)

Kind Regards

Daniel Clark
Ryba Macaulay Ltd
[email protected]


Thanks (0)
avatar
By AnonymousUser
14th Feb 2003 14:00

WinForecast
I have to agree with Nilesh on this one. I'm a bit of a WinForecast advocate.

The program will produce all of your standard Management reports (P&L, cash flow, balance sheet and funds flow)

It'll integrate with Sage Line 50, Line 100 and with Line 200 too. It will also allow you to link into your Excel spreadsheets.

You can produce all of your forecasts, variance reports etc. There's a consolidation function if you have multiple centres to be budgeted.

definitely worth a look...

Thanks (0)
avatar
By janesorganic
12th Aug 2010 14:52

Sage Line 50 all-singing all-dancing management report

I have given up on any expectation that Sage Line 50 reporting will be able to meet the ever-changing reporting requirements of my Chief Exec and Senior Management Team.

Instead I've developed an Excel-based spreadsheet that is completely flexible, takes 5 minutes max to populate and check with live data at any time, and incorporates annual accounts (SOFA in my case), forecasting, 6 year history report - practically anything you've ever wanted from Sage. Also possibly would work on Sage 100, but don't have data to test it....

I'm constantly expanding it, swapping lines from one category to another, presenting the reports in a different way, writing different reports for different audiences et cetera et cetera et cetera. And as our activities develop, I can incorporate new Sage codes in the same 5 minutes max.

It's on offer, with user notes. It should take about half an hour to set up with your Sage data.

Anybody interested? As I work for a charity, I would ask for a modest donation

Thanks (0)
avatar
By BigBadWolf
12th Aug 2010 16:43

Xero

Try Xero, the online accounting system , it produces some very good manangement reports, I know Adrian Pearson had uploaded a sample report on hear a while ago ...but i can't find the link now ... perhaps he would be kind enough to repost it.

Thanks (0)
avatar
By Louise_Kennerley
12th Aug 2010 18:34

Quickbooks

Have you considered using Quickbooks for the management accounts?  You can run most financial reports for the whole year then select the report to show it by a monthly column with a cumulative total.

Hope this helps.

Thanks (0)