The Book-keepers Forum (BKF)

Post Info TOPIC: Sage Reports


Member

Status: Offline
Posts: 17
Date:
Sage Reports


Hello

Does anyone recognise which Sage programme would return an Excel file like the one below please?

It has sent to me by another company's bookkeeper (and anomalised by me)

The reason I ask is because I'm being told that Sage will not produce a report identical to this but with an extra column to show the relevant department alongside each transaction.

The reason I need that is because I need to use Excel to analyse the 2000 transactions in various ways and I need to keep track of the departments along side each transaction. The way the report is set out the only reference to the Department is as a heading to the transactions under.

Can Sage reports be changed so that I can get what I need?

Lastly, I presume that if the report "Department From" and "Department To" parameters were changed to 1 to 99999 then all departments would be reported?

Thanks very much in anticipation, I'm used to online cloud systems (eg Sage and Xero) where I know how easily such a report is generated.

Date:21.4.20Illustrative LtdPage:1
Time:13:32:39
Nominal Departmental Analysis (Detailed)
N/C From4000Tran Date From01/01/1980Tran No From1Department From23
N/C To99999999Tran Date To31/12/2050Tran No To99999999Department To23
Dept Number23Dept NameKempTown
N/C5201NameApplication FeesBalance @ Mar 20
Tran NumberTypeDateDetailsInv RefA/C RefDebitCreditBalance
1562JD28/02/2016Tree SuppliersJN99L 775201500.00500.00
Account Totals500.00500.00



-- Edited by HarryStottle on Friday 1st of May 2020 04:52:23 PM



-- Edited by HarryStottle on Friday 1st of May 2020 04:52:55 PM

__________________

Harry



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Ive not got time for this at the mo.

Perhaps add a bit more detail about what you are trying to do, might generate more of a discussion.

Or just try

onionrs.co.uk/

Ian is a regular on here.



-- Edited by Cheshire on Friday 1st of May 2020 05:34:39 PM

__________________

Joanne

Winner of Bookkeeper of the Year 2015, 2016 & 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Expert

Status: Offline
Posts: 1795
Date:

The short answer is yes, Sage reports can be changed - at least in the desktop versions, I don't know about any cloudy versions. This may vary in versions later than mine (and in fact, in some parts of my copy it varies - Sage are nothing if not inconsistent) but the common method is: Go into the reports screen to where the report is listed, and move the mouse pointer over the report. Instead of clicking one of the pop-up icons (to print, save, etc), right click to call up a menu, and from that menu choose 'Edit'. This should load the report into the report generator so that you can edit it.

Whether you can add the department number to the transaction line depends if that is offered as a field for inclusion - it probably is, but it's possible that it isn't. (If you see what I mean). How to do this is another matter, and more complicated to explain - so I won't (especially given that I'm on the wrong platform).

The answer to the question about the department range is yes - that would result in all departments being reported.

I haven't used that report (nor indeed departments) in Sage for a very long time, but I've a feeling it reports each department separately - I can't remember if it groups each department under each nominal code or the other way around, though.

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 223
Date:

Hi Harry,

There are a number of third party programs, including ours, that provide good analytical capabilities for Sage. Onion Reporting Software, Proud Numbers, Cascade BI and Pendragon Systems Ltd are a few that spring to mind - there may be others. Departmental reporting is a particular specialism of ours (including reporting on groups of departments). Most offer free trials so you can see what you get for your money.

However, if you prefer to do your own thing, and looking at the sample provided, it would be relatively easy to add a simple formula to add the relevant department number to each line. It would follow this sort of logic:

  • test each line to see if it contains the phrase "Dept Number" in the relevant column.
  • If it does, return the dept number showing in the cell to the right of it
  • Otherwise return the contents of the cell above the one you're writing the formula in.

I'd be happy to assist you with the formula if you can't work it out.

I think the report you have shown is a standard Sage departmental P&L report exported to Excel.

Kind regards,

PS you'd probably want to do the same for the nominal code and description to put them on each line as well.



-- Edited by Onion4Sage on Friday 1st of May 2020 10:15:04 PM

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free trial.



Senior Member

Status: Offline
Posts: 223
Date:

Sorry Joanne,

Missed your nod above. Thank you.


__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free trial.



Member

Status: Offline
Posts: 17
Date:

Many thanks for that, Ian. I can see the logic behind that potential formula. I'll take a look at your product too.

__________________

Harry



Senior Member

Status: Offline
Posts: 223
Date:

Hi Harry,

Another possibility is to use an ODBC link to return data from the AUDIT_JOURNAL view in Sage. Most of the fields in the report are available in that view on the same record. Once set up, a simple refresh for a different parameterised date range would deliver what you want.

Just a thought. Happy to assist if you'd like to pursue.

Regards,

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free trial.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

HarryStottle wrote:

Many thanks for that, Ian. I can see the logic behind that potential formula. I'll take a look at your product too.


I think you forgot to thank someone.

Vince's suggestion is a very valid one and he obviously took the time to respond, so I dont think its good form not to at least acknowledge his response.



__________________

Joanne

Winner of Bookkeeper of the Year 2015, 2016 & 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Newbie

Status: Offline
Posts: 4
Date:

Sage Report Designer is a creative tool that compliments various Sage Suites such as Sage 50 and Sage 200. Comprehensive reporting is a high priority for many users of these Suites, and although the standard range of reports is impressive, there might come a time when you need more information.

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:

Ignore Lewis-H, is a spammer. Talking half drivel, not actually helping, on several posts.

__________________

Joanne

Winner of Bookkeeper of the Year 2015, 2016 & 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Forum Moderator & Expert

Status: Offline
Posts: 11841
Date:

Lewis-H wrote:

Sage Report Designer is a creative tool that compliments various Sage Suites such as Sage 50 and Sage 200. Comprehensive reporting is a high priority for many users of these Suites, and although the standard range of reports is impressive, there might come a time when you need more information.


Same again. Lifted straight from the net word for word.



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11841
Date:

Shamus wrote:
Lewis-H wrote:

Sage Report Designer is a creative tool that compliments various Sage Suites such as Sage 50 and Sage 200. Comprehensive reporting is a high priority for many users of these Suites, and although the standard range of reports is impressive, there might come a time when you need more information.


Same again. Lifted straight from the net word for word.


Another person who hadn't looked out of the window and realised that they wereactually in Pune in India, not the United States at all.

Lewis Hamilton can now have their name back. biggrin



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Member

Status: Offline
Posts: 17
Date:

Yes, quite right, Cheshire.

I am indeed also grateful to Vince for his input and I should have mentioned this earlier.



__________________

Harry

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  

2007-2019 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: info@bookcert.co.uk.

Privacy & Cookie Policy  About