Export payment applications in detail for Canadian tax forms (CRA T4 and T2200).

We need to report on:

  • How much tuition (actual tuition, not boarding or incidentals) per student was paid for by the family, based on calendar year.

  • How much financial assistance was granted to each student, based on calendar year.

Currently, it is very difficult to obtain this information. It's almost a completely manual process.

This will affect mostly post-secondary institutions, where this information is required to be produced.

  • Petra Hall
  • Nov 11 2022
  • Shipped
Blackbaud Billing Management / Reporting
  • Attach files
  • Admin
    Julia Meseck commented
    December 20, 2022 13:50

    This morning, we shipped the Payment applications export found under Reporting. The export can be filtered by date range and fee type and will provide all payment/portions of payments applied to those specific fees. The export can then be used to create a Word merge letter/receipt.

    Attachments Open full size
  • Admin
    Julia Meseck commented
    November 22, 2022 15:54

    We are working on the ability to create a data file of all payment applications for a specific time frame and for specific fees. For financial aid, you should be able to use the transaction list to filter on only credits for a specific timeframe. And then once you export the credits, you can filter in Excel for the specific credit types (we'll be adding the ability to filter within the Transaction list soon).

    Attachments Open full size
  • Victoria Little commented
    November 14, 2022 15:57

    Hi Petra, I also work at a Canadian school and would love to chat through this with you if you have some time. I am dealing with something similar currently in regards to Canadian tax receipting. Maybe we can help each other! Please feel free to contact me if you'd like to chat: vlittle@montessori.on.ca.

    Thanks,

    Victoria Little
    Registrar
    Montessori Academy of London

    Attachments Open full size

Related ideas