Hi guys
I am doing exercises on Sage and in one exercise I am suppposed to print Audit Trial for May ( detailed-transactions only including bank reconciled ). Do you know guys how to do it in Sage ? I haven't found so far any report that links Audit Trial with transactions reconciled. Please, help me in this matter.
-- Edited by rafapak on Friday 7th of April 2017 12:43:26 AM
Hi Rafal
You will find that the Audit trial automatically includes the Bank reconciled and indeed unreconciled items in it - you can see from the latter columns if items are Bank and indeed VAT reconciled.
By virtue of it being an audit then everything generally is included in the full detailed report, unless you tick the option to exclude the deleted items. My view - leave the deleted items in as it makes it easier to see what has happened with certain entries/allows further checks if eg Bank doesnt reconcile, although if you want a tidier cleaner report then I guess you would exclude them.
__________________
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
Beat me to it, Joanne - but because the audit trail reports would automatically include them, it leaves me wondering about the actual wording of the question: Why would it specifically state that they must be included?
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Hi Rafapak - the only way I've found to do this is through the Sage Report Designer which can be a bit daunting to use but very useful once you get the hang of it, especially for things like wanting to print reports in date order rather than transaction number order.
If you go to Transactions and click the Reports button, go to Audit Trail and click once on the report called Audit Trail (Detailed), then click Edit at the top of the window. This opens up the Report Designer.
From here, click Report, then Criteria, and it brings up a small window which is essentially a summary of the criteria that comes up when you usually run reports (like date range, transaction number etc).
Click New Criteria, and then choose Audit Header > Bank Flag in the drop down boxes. Press OK three times to close all the windows now open, and then go to File>Save As and save it in the location that automatically comes up.
Now you can access this new report in Sage from Transactions > Reports > My Transaction Reports. You'll notice when you try to open it that the criteria window now has an extra line for "Bank Reconciled Flag" which you can change in the dropdown box to "Is" and then "R" in the one next to it.
Hi Rafapak - the only way I've found to do this is through the Sage Report Designer which can be a bit daunting to use but very useful once you get the hang of it, especially for things like wanting to print reports in date order rather than transaction number order.
If you go to Transactions and click the Reports button, go to Audit Trail and click once on the report called Audit Trail (Detailed), then click Edit at the top of the window. This opens up the Report Designer.
From here, click Report, then Criteria, and it brings up a small window which is essentially a summary of the criteria that comes up when you usually run reports (like date range, transaction number etc).
Click New Criteria, and then choose Audit Header > Bank Flag in the drop down boxes. Press OK three times to close all the windows now open, and then go to File>Save As and save it in the location that automatically comes up.
Now you can access this new report in Sage from Transactions > Reports > My Transaction Reports. You'll notice when you try to open it that the criteria window now has an extra line for "Bank Reconciled Flag" which you can change in the dropdown box to "Is" and then "R" in the one next to it.
Hope this helps :)
It makes me wonder if doing so complicated procedures in Sage is required for computerised accounting exam on aat level 2 ? In some exercises they tell you to print reports and this printing involves only simple procedures whereas this one where they tell you to print audit trial with only reconciled transactions requires complicated procedures. Something is wrong here I think.
Hi Rafal
No you will NOT be required to do such in the exam so dont worry on that score.
I dont know if Faye knows your background and therefore the reasons for your questions, so has provided an answer which would be very helpful to someone in practice. Great for you to know in the longer term, albeit I know you are on a tme limit at the moment!
__________________
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
