How do other Canadian foundations produce a receipt report for their audit and T3010?

JimMartin
JimMartin Posts: 3
Conversation Starter Canada First Compass Anniversary First Comment
edited November 2023 in Finance & Operations

Hi,

I am trying figure out how to get a report that has our receipt numbers on for our auditors. There are so many fields to pull for a custom report and I have been unable to produce one. We also switched from RE to CS mid-fiscal year.

Best Answers

  • KellyScott
    KellyScott Posts: 18 ✭✭✭
    Music Fan Scholarship Lifecycle Manager (SLM) Foundant Fund Accounting Certificate Community Foundations of Canada (CFC)
    Answer ✓

    Hi Jim

    I created a basic report using, serial number, donation date, donation name, donation id, and donation amount. You then filter by timeframe you want. I use this for our auditors. Hope this helps.

    Kelly Scott

  • AlyssaHazzard
    AlyssaHazzard Posts: 6 ✭✭
    World Traveler Third Compass Anniversary Canada Grant Lifecycle Manager (GLM)
    Answer ✓

    We do the same as Kelly, but also include the fund name.

Answers

  • KellyScott
    KellyScott Posts: 18 ✭✭✭
    Music Fan Scholarship Lifecycle Manager (SLM) Foundant Fund Accounting Certificate Community Foundations of Canada (CFC)
    Answer ✓

    Hi Jim

    I created a basic report using, serial number, donation date, donation name, donation id, and donation amount. You then filter by timeframe you want. I use this for our auditors. Hope this helps.

    Kelly Scott

  • AlyssaHazzard
    AlyssaHazzard Posts: 6 ✭✭
    World Traveler Third Compass Anniversary Canada Grant Lifecycle Manager (GLM)
    Answer ✓

    We do the same as Kelly, but also include the fund name.

  • JimMartin
    JimMartin Posts: 3
    Conversation Starter Canada First Compass Anniversary First Comment

    Thank you, Kelly and Alyssa. I forgot completely about serial number. I am still thinking in RE.

  • MikePuccio
    MikePuccio Posts: 11 ✭✭✭
    Rule Breaker 10 Comments First Compass Anniversary Combo Breaker

    Hello there,

    For anyone who is not comfortable creating custom reports, CSuite has a built in serial number report that will provide a ton of information once exported. This report can be accessed from the donations module. It is behind the Receipts option.

    I do not think there is documentation for it but it is called: Donation Receipts Report

    Hope this helps.

    Mike

    Mike Puccio | Apiscommunityconsulting@gmail.com | 360-298-8881

  • MikePuccio
    MikePuccio Posts: 11 ✭✭✭
    Rule Breaker 10 Comments First Compass Anniversary Combo Breaker

    Hi there,

    If you have time, check your sandbox: This is now live in your Sandbox. - Reports: Add the T3010 and T4A Report for Canadian clients. 

    Mike Puccio | Apiscommunityconsulting@gmail.com | 360-298-8881