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.20
Illustrative Ltd
Page:
1
Time:
13:32:39
Nominal Departmental Analysis (Detailed)
N/C From
4000
Tran Date From
01/01/1980
Tran No From
1
Department From
23
N/C To
99999999
Tran Date To
31/12/2050
Tran No To
99999999
Department To
23
Dept Number
23
Dept Name
KempTown
N/C
5201
Name
Application Fees
Balance @ Mar 20
Tran Number
Type
Date
Details
Inv Ref
A/C Ref
Debit
Credit
Balance
1562
JD
28/02/2016
Tree Suppliers
JN99L 77
5201
500.00
500.00
Account Totals
500.00
500.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
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...)
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
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.
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
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.
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.
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.
__________________
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.