View Full Version : Monthly Reports for Management

11-06-2017, 08:42 AM
Does anyone do monthly reports for Management? When we do a report by category we get some odd numbers in the details. The totals are correct, but the details are not always.

11-06-2017, 10:45 AM
We replied to this by E-mail last week, but in case you didn't get that:

What you're using is essentially a "Receipts by Category" report (it's a Memorized report with the "Interpolated" options, so it's basically the same thing). If you enabled more fields like the Customer Last Name and Site then it would be a little more clear where they're coming from. This kind of report has to break up each payment according to all charges, discounts, credits, etc that the payment applies to, in order to calculate the actual category paid for. Therefore the Detail you're looking at is not always useful (it's intended as a Summary report only, with the Detail available primarily to track down issues with incorrectly categorized amounts). This documentation explains what it's doing and how to correct any issues: