I’m reviewing Tracks and SchoolBooks enhancement requests that pertain to audits. These are either requests you’ve made because your auditor asked for them or things you think would help you have an easier time with the whole audit process. We get a lot of compliments on our SchoolBooks Audit Selection Report, but I think we could do more. I would appreciate your feedback: Are your auditors requesting different types of information than they were a couple years ago? Are there any reports that need one more function added to be just perfect for you and them? Is there something else we could give you that would make your audit go more smoothly?
I’m listing the current enhancement requests that contain the word “audit” so you can comment and tell me whether these are important to you or if you have something completely new to add. Whatever we discover together, I’ll report it back here.
SchoolBooks: - Audit Selection Report – Add option to print all deposits over X amount. Add option to print all receipts over X amount.
- Add option to summarize accounts on the Balance Sheet. She got an exception on her audit because they saw sub-accounts on her Balance Sheet and didn’t like that some of them had negative balances.
- Master Audit Report – Needs to show changes and additions to User Codes.
- New audit report to show changes to master files – like Vendor Maintenance and GL Account Maintenance.
- New consolidated report - Vendor Check History for 1099 vendors only across all schools.
- New consolidated report - Consolidated Category Report across all schools.
Tracks:
- Master Audit Report – display all WebStore sales under ” WebStore” User Code.
- Importing transactions. When using Import Manager, auditors want to see a list of imported sales listed by receipt number.
- Add option to Sales by Receipt Report – allow for grouping/selection by Payment Type (so she can get a separate list of all credit card sales).
Posts
Audit Selection Report - I would like to see the option to select a random sample size of a predetermined number, say 25 or 60, receipts and checks.
ReplyDeleteConsolidated Report - I would also love a consolidated report that takes each school's account analysis summary report and combines them into one report so that I can print one report as opposed to 53 (the # of schools in our district).
OK. I get the first one about the Audit Selection Report.
ReplyDeleteFor the Consolidated Report, how would this be different from the existing report? Currently, you get this:
GL Account #1000
* School A $100
* School B $200
* School C $300
Subtotal $600
GL Account #1001
* School A $100
* School B $100
* School C $200
Subtotal $400
And you can select for a range of accounts.
Or do you just want the ability to print the AA Summary Reports for each school as is, but chain them together?
I would like to see an option that would allow you to enter a "fundraiser" so you could make sure the money was deposited. Is there currently a way to track that?
ReplyDeleteCurrently I have a fundrasing request however, no way to make sure the fundrasing money was ever deposited.
Auditor came yesterday and was unable to match up fundrasing requests with actual deposits.
Hi Shelley! Someone from our support department will be contacting you to discuss the FundRaiser module that is available in Tracks. That should have all the reports and tracking that your auditors need.
ReplyDelete