[GNC] Filtering reports on contents of Memo field
Stephen M. Butler
Stephen.M.Butler51 at gmail.com
Sun Feb 7 13:22:39 EST 2021
On 2/7/21 10:10 AM, Adrien Monteleone wrote:
> If you are treating members as 'customers' then you may have other
> options. Otherwise, you'd have to go through the equally tedious task
> of setting up sub-accounts for each member, or creating a saved report
> configuration for each member.
>
> The Transaction Report does offer filtering capabilities that you can
> use on a Memo field for that last option.
>
> Another alternative for a consolidated report might work:
>
> The Transaction Report also lets you sort by the Memo field, so if you
> choose only the Gift Aid account, and the Memo starts with/contains
> only the Member names, you might be able to get subtotals for each
> member. (if that is what you are looking for)
>
> In either case, no need to filter date range for the account view
> first, you'll do that in the report options.
>
> If you want individualized reports per member, then you can still use
> that last option, but you'll need to save each as a Report
> Configuration and just name it for each Member. Then run them one at a
> time as needed.
What if the Memo field contains "Member: member last, first name" so
that the filter was on the leading "Member: " portion but you still
sorted by the Memo field. Wouldn't each break based on the remainder of
that field trigger a total line? In that way this would be just one
report without having to know if new members were added or removed.
--Steve
>
> Hope that helps.
>
> Regards,
> Adrien
>
> On 2/6/21 5:56 AM, Michael Hendry wrote:
>> Our Rotary Club hasn’t been able to meet in the flesh since the
>> beginning of Covid, and we haven’t been able to run any fundraisers.
>>
>> One of our members suggested that each of us might consider donating
>> the cost of the meal (and the associated glass or two of wine|) to
>> the club’s charity account as a way of keeping some money coming in.
>> As this is entirely voluntary and comparisons would be invidious if
>> issued in reports, I’ve recorded the chosen a chosen destination in
>> the description field of each transaction, and recorded the donor's
>> name in the Memo. This way I can simply exclude Memo from reports.
>>
>> I’m now looking at making a Gift Aid claim for all these donations at
>> the end of March, and I’ve found that the Spreadsheet I created to
>> keep track of the Gift Aid side of the accounts has got out of step
>> with the Gnucash record.
>>
>> I’ve managed to reconcile these by opening the account which receives
>> these donations, filtering by date, using Find to pick up one member
>> at a time in this account in the Memo and Reporting the findings
>> (which provides a total in addition to the individual donations).
>>
>> This is a tedious and error-prone procedure which I would like to be
>> able to automate.
>>
>> As far as I can see, there isn’t a way of setting up multiple such
>> reports in advance and running it at the end of the tax year (or
>> indeed as an ad-hoc report during the year) to get it all done in one
>> go, and I’d have to export the account to CSV and sort by Memo to
>> separate the donations by member, and then extract the
>> total-contributions-by-member to generate the Gift Aid Claim.
>>
>> That’s unless one of you wise ones can suggest another route…
>>
>> Perhaps more in hope than expectation,
--
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
More information about the gnucash-user
mailing list