Question

Photo of Michael Garrison

0

Statement Generator and split transactions

We are beginning to get questions from people seeing inconsistencies between their statements and their actual giving.

One family noted that a check given early in the year did not appear in their giving statement, even though it's listed on their profile under "Contributions". It was a single check designated for two separate accounts- $x for "General Fund" and $24 for a book went into the "Purchases" (non-tax-deductible account).

When we ran the statements, we included "General Fund" and excluded "Purchases". But the entire check is missing- theoretically in the giving statement it should have included $x for the General Fund contribution from that check.

Another individual pays to "Building Fund" (tax deductible), "General Fund" (tax deductible) and "Rent" (non-tax-deductible) regularly in a single check. Building Fund and General Fund were included in the statement generator batch, while Rent was excluded. And yet their statement reflects the TOTAL amount of all of their checks, including the amount for Rent, which should have been omitted.

Interestingly, these appear to be opposite symptoms (one includes the entire check, the other excludes the entire check)

How is the Statement Generator designed to handle split transactions of this type? And is anyone else seeing similar symptoms? Obviously this is quickly becoming a big issue for us as the statements have already been mailed and now we're not even sure how to tell who received accurate statements and who didn't...

(We're also having discrepancies between a DataView designed to list giving totals per family for the year compared to the total shown on the statements, but I'm trying to verify whether that's the same issue or not before listing it as a symptom. So far, the discrepancies appear to be different amounts than the split transactions so it may be different)

  • Michael Garrison

    Upon further investigation, we have resolved the DataView issue (cut transactions off at 1/1/2016 not 12/31/2015). And have a working theory on when split transactions are shown: it appears that if an included account is assigned FIRST when matching or entering transactions, the ENTIRE check is included. Likewise if an excluded account is assigned first when matching or entering the transaction, the ENTIRE check is excluded.

  • Photo of Jon Edmiston

    0

    Looks like the statement issue would not effect most churches (ran a few queries on churches that we have access to). It would only effect a church with the possibility of a single financial transaction with money going to BOTH a contribution account AND a non-contribution account. We have a fix going into v4.2.  David is going to Slack you a query to show who in your database would have been effected by this.

    • Michael Garrison

      Thank you guys. The list of affected people was significantly shorter than I'd feared, so that was good news too. It's easily managed for us on a personal basis with these people.

    • Michael Garrison

      To anyone else: this was clarified slightly in Slack-


      The issue occurs for anyone that has a transaction with an account that was included in the [Statement Generator account] selection and an account that was not, both on the same transaction. The fix will correct that.


      So it's not only a deductible and non-deductible account split, but the fix will produce correct statements in all cases, it sounds like