• Replies 19 replies
  • Subscribers 244 subscribers
  • Views 290 views
  • Users 0 members are here
Related

Billing Schedules

Brian Kerr
$organization

Hi all,  does anyone know of any transaction reports that output payment with billing schedule type? (monthly/annually etc?)  I've had a good search around the network but not found anything relating to it so far. Many thanks, Brian

Parents
  • $organization

    Hi Brian,

    Hope you're well. Could you confirm if you're looking for a report that looks at contributions or orders? I'm having a think if there is anything that might fit your needs. I think once you schedule payments the actual schedule type you used is lost as it's done its job, so this might not be possible but I'll definitely have a ponder on it if you let me know.

    Thanks,

    Paul

  • $organization in reply to Paul Walster

    Hi there Paul, many thanks for your reply. The payments I'm trying to analyse are just in contributions (membership payments) really grateful for the help! Brian

  • $organization in reply to Brian Kerr

    Hi Brian,

    Thanks for getting back to me. I've had a chat with some colleagues and I was right; once you've scheduled payments using a particular schedule type, it is lost from that schedule. It's purely a mechanism for deciding which payment dates you're going to schedule. So it might not be possible to report in the way that you wanted to.

    What I was able to find was a report that shows scheduled payments over 12 months to a particular fund. It sits under Finance > Yearly Cash Planning Report and you can get an output something like this:

    Meaning you could then look at the contributions and see what was scheduled for each month. The documentation on that report is here:

    https://www.tessituranetwork.com/Help_System/Tessitura.htm#Reports/Yearly%20Cash%20Planning%20Report.htm

    I've also checked if this is achievable in Analytics, but it looks like payment schedules aren't there to analyse in this way yet.

    It would be possible to produce a custom report which would show scheduled payments and amount due with more options for filtering, so if this is of interest then please do raise a support ticket so we can estimate cost. The other option would be to create some output set elements which could output a row for each scheduled payment, but this is less clean.

    I hope those suggestions help. If you have more specific questions please do raise a support ticket by emailing hello@tessituranetwork.com and we'll be able to dig a bit further!

    Thanks,

    Paul

  • $organization in reply to Paul Walster

    Many thanks Paul, The Yearly Cash Planning Report may help, I’m wondering if I can do a match up with the Batch detail on reference no. (pure speculation at the moment!) Will need to arrange some time in to take a look at it but thanks very much – I can’t remember looking at that report before. Will let you know how I get on!

     

    Cheers,

     

    Brian

  • $organization in reply to Brian Kerr

    Hi Brian,  I might be completely off what you need but I wrote a report that lists out Contribution schedules like this

Reply Children