Troubleshooting Discrepancies for report 307 "Total by G/L Code"

Follow

You may find that if you run report 304 "Total by G/L Code" day-by-day and then a week, or week-by-week and then a month, or month-by-month and then a year, the totals don't balance. 

Why is that?

The reason is usually that somewhere within the original day/week/month selection, a user or users have not completed a receipt that has auto-allocated fees attached. The report will find these, but it isn't sure what date they should be attributed to (because they aren't finished), therefore they will show up for a greater bracket but be excluded for a smaller one because it can't confirm it was finalised within that time frame. 

If you are looking at more than a single date, you will find that the unfinished receipt in question will fall on the last day of the bracket chosen.

You can identify these unfinished receipts by running report 629 "Detailed Donation by GL Code" (which actually finds all receipts, not just donations) and looking for anything that has the payment type "No Payment Type - Data Import".

This denotes an unfinished receipt. If you view these using Receipts > Edit Receipts you'll see the payment method will be blank on any receipt with this appearing as a payment type on report 629 "Detailed Donation by GL Code".

These receipts are created when fees are auto allocated but the user navigates away from the page without ever clicking the "update" button for that receipt. 

To correct, you can either add a payment type and click Update to complete the receipt or use Receipts > Cancel Receipt/Refund to delete it. Either will make the report balance out. 

 

Have more questions? Submit a request

Comments

Powered by Zendesk