When you work in the Business Office, you have to stick your nose into everyone’s business. For example I remember getting involved in a controversy about job descriptions for clerical positions at school sites. Wouldn’t that be an issue between Human Resources and school principals, you ask? Well, no. Not when you are charged with
Hiring an Analyst: Inside Scoop
In a school district business office there is usually a position called Budget Analyst. When I first went to the Pretty Big School District I needed to fill a Budget Analyst vacancy. I started by talking to current staff to see who would be interested in applying. One (I thought) promising employee asked “do you need to
Interdepartmental Charges
What kinds of charges are billed between departments? Custodial costs for school civic center use and custodial services provided to lessees, charter schools, preschools, food services Field trips Vehicle repair Maintenance charges to schools, charter schools, and lessees Catering provided by the Food Services department Duplicating Fingerprinting and other on-boarding costs Mailing costs Here’s an example
Data Woes
Every business transaction creates data. Ensuring easy and efficient transaction entry is on the top of everyone’s list when evaluating a new financial system. However, information must not only get into a system it must get out again. The main methods of retrieving data are canned reports, and dumping data into Excel for ad hoc analysis. The Dangers
Spreadsheet Best Practices
Many of us have worked with Excel spreadsheets for years and consider ourselves to be pretty good at them. Then I ran across the website Best Practices Modeling website. I learned a lot and I’ve been converting some of my more complicated models into the Best Practices system. My main takeaways are: Use separate, differently