Management reports from Sage.

Management reports from Sage.

Didn't find your answer?

I am looking for an Excel add-on that will take the data from Sage to produce a monthly management report based on the P&L and a cash flow based on bank transactions, both showing monthly columns for the year.

I am sure I have seen this discussed in the past so can anyone point me in the right direction.

Replies (3)

Please login or register to join the discussion.

Man of Kent
By Kent accountant
16th Dec 2011 14:01

VT

Quick and simple to use you can export data in TB format straight to VT transaction which will then generate P&L and Balance Sheet for you.

 

Plus you can post 'management accounts' adjustments as journals that you don't necessarily want to appear in Sage.

 

Cash flow - what type of report are you looking for, you say using bank transactions, do you mean simply receipts and payments?

 

 

Thanks (0)
Routemaster image
By tom123
17th Dec 2011 20:34

ODBC links and pivot tables

They take a bit of getting used to, but I always try and use ODBC links, together with autoformat pivot tables in Excel,

Ideally, you also use another table to group nominal codes into levels of headings. I usually have about four levels in the tree.

ie, on the final report, I am not usually showing information at nominal code level.

This also gives flexibility to group nominal codes together that are not in numerical sequence - unlike the standard sage reports.

A bit of a difficult concept to explain, but once you get there you wont bother with another piece of software in between. Updating is 'one click' refresh.

 

Good luck

 

 

Thanks (0)
avatar
By thacca
18th Dec 2011 09:11

Optegra
I think the product you're looking for is called optegra (or something similar).

Thanks (0)