The billing system is not the end point; daily reconciliations are long-term. Many schools go online with a big bang, no one looks at them after they do. When we make a financial discovery, we tell the school how many must be seen, and which anomalies are discovered early on. Reconciliations are not a matter of finance alone, but of a barometer of system health.
Number I: fee success rate
The amount of money that should be charged, what is the percentage actually recorded. Normally, it should be close to 100%. If one day falls below 90%, most of it is a back-writing queue or interface problem. We've seen the rate of success slip and we've been found in financial discovery for a week to have a small sum less.
Number II: variance
The difference is almost impossible to record, but the difference should be stabilized within a small range. If one day the number of different pens suddenly doubles, it is likely that the configuration changes or the exception occurs simultaneously. We suggest schools set thresholds for differences, which are too high to alert the police and prevent a breakdown at the end of the month. Differences are system temperature, so that the daily amount knows how normal it is.
Number III: Discount distribution of outstanding charges
How many students are restricted or out of the network every day, in which areas and at what time. If a region suddenly stops in large numbers, it may be low or abnormally high. We have caught one of the accommodations wrongly matched, and we've been able to transfer back half a day. The stop distribution looks like a feeder data, but it is actually a microcosm of the student experience.
Number IV: Fill-to-Consumption Ratio
The proportion of money that students charge and actually spend online is normal. If the amount is much larger than consumption, it means that the amount is too wide or that the student hoards money; if consumption is far more than consumption, there may be a gap in the bill. We suggest that finance and transporters look at this figure together, so that the system is healthy.
Number V: Unusual flow ratio
The percentage of the school-wide traffic that comes from abnormal behaviors, such as running at midnight or having a single account number. This proportion goes up for a long time, indicating that the duffling strategy is ineffective or that the equipment is controlled. We have seen anomalous share stint to 10%, and we find several machines with mining procedures.
Number VI: Discrepancies in the reconciliations of one cartoon
If a cartoon is added, the difference between the two accounts is even. Zero differences are acceptable and big differences have to be checked. We've been through the wrongs, one cartoon and each bill run separately, and only at the end of the month we find that thousands of pieces are missing. Once a day, the problem can be identified on the same day and not rolled into a single moon pit.
Give us advice.
The six figures are not counted manually, and the system is set to automatically produce the statements. The key is that someone at school really looks at them, not produces them. We're afraid of running with them when they say they have them but nobody looks at them.
The watchboards need to be seen by the right person.
Six numbers are better than that, and it is useless to just look at the board in the system. We suggest that the watchboard be pushed to the daily interface of peacekeeping finance, or even an abnormally automatic one. The numbers make sense when someone looks at them. We fear that the school says that the statements are complete but nobody looks at them, and we turn when things happen. The value of reconciliations is day-to-day, not late.
The anomaly has to catch the root.
The numbers are not enough to get in the details. One day, the unusual flow ratio is high, so we can point to a specific account number, a specific area, a specific time period. We're all doing panels that support drilling and keep the numbers off the surface. If we can catch root causes, it's signal rather than noise.
Reconciliations to budget
Reconciliations are not just flat, they can also reverse budgets. For example, a region continues to have high flows, which may be an expansion rather than a limited speed limit. We link the reconciliation conclusions and budget proposals to make figures truly decision-making, instead of stopping in the statements.
Unusual upgrade path
We suggest that schools divide the reconciliation anomalies into three levels, ordinary difference vectors, unusual traffic safety interventions, and large differences in financial leadership. The path is clear, it doesn't sound loud.
Make the reconciliation a fixed item for weekly meetings.
We pushed schools to move reconciliations into weekly meetings, six times over ten minutes. It seemed like time was taken, and the problem was first discovered. The reconciliations were made more stable than the month-end surprise checks.
The ultimate purpose of the reconciliation is to be credible.
The goal of looking at the six figures is not to produce a statement, but to convince the entire school that the bill is clear, fair and verifiable. The most important thing we do is that students and teachers mention Internet time as being free to say. If the reconciliation is credible, the system is really standing and numbers are meaningful.
The reconciliations can help with the teaching.
The reconciliation data are not just a mistake-proof, but also counter-feeding. For example, finding that the flow of practical training courses in a particular field is exceptionally high may suggest that they should be secured or expanded alone. We have promoted schools to synchronize their reconciliations with teaching services and involve online data in educational security decisions.
Small numbers can also protect against big risks.
Don't underestimate the daily numbers, many of the big failures are minor anomalies. We saw one export anomaly, and then the unusual flow ratio just snuck up a little bit, and the people who were looking at it found out in time that they avoided a complete disconnection.