Payment Plan Discrepancy report

So we use payment plans for both Credit Card billing and Normal Billing in our school.  What we are looking for is a report or utility that notifies us when a payment is made that does not follow the Payment Plan (different amount paid than what is currently due).  Example - next payment due is $70 by 11/22 - payment is made on order for amount not $70

 

Thanks

Mary

Parents
  • Here is the example

    Payment via auto bill happens for 6/8

    Then a charge is processed for $165 on the order

    So 9/1 is ”paid” 10/1 is “paid”  and part of 11/1

    But the 9/1 auto billing runs nothing because the $165 should have been attributed to the 11/22 payment.

     

    We need to catch the mismatch And have the schedule updated before auto billing happens.

     

     

    Mary French | Operations Director | Atlanta Ballet | 404.873.5811 ext. 201
    mfrench@atlantaballet.com | Michael C. Carlos Dance Centre | 1695 Marietta Blvd. NW | Atlanta, GA 30318

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Bill Waugh
    Sent: Wednesday, November 16, 2016 10:41 AM
    To: Mary French <MFrench@atlantaballet.com>
    Subject: Re: [Tessitura Shared Reports Forum] Payment Plan Discrepancy report

     

    We have a draft of a report that is somewhat similar to what you're asking for.  The report finds any orders that are unpaid (or partially paid) and then provides a summary of the current amount due on the order compared to the future billings that are due on the order.    If the future billings are not the same as the amount due, then the order needs some investigation.

    What would be the scenario wherein you get a payment for the wrong amount?   

     

    Cheers,

    Bill Waugh

    Starlight Theatre

    From: Mary French <bounce-maryfrench5367@tessituranetwork.com>
    Sent: 11/16/2016 9:09:03 AM

    So we use payment plans for both Credit Card billing and Normal Billing in our school.  What we are looking for is a report or utility that notifies us when a payment is made that does not follow the Payment Plan (different amount paid than what is currently due).  Example - next payment due is $70 by 11/22 - payment is made on order for amount not $70

     

    Thanks

    Mary




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Here is the example

    Payment via auto bill happens for 6/8

    Then a charge is processed for $165 on the order

    So 9/1 is ”paid” 10/1 is “paid”  and part of 11/1

    But the 9/1 auto billing runs nothing because the $165 should have been attributed to the 11/22 payment.

     

    We need to catch the mismatch And have the schedule updated before auto billing happens.

     

     

    Mary French | Operations Director | Atlanta Ballet | 404.873.5811 ext. 201
    mfrench@atlantaballet.com | Michael C. Carlos Dance Centre | 1695 Marietta Blvd. NW | Atlanta, GA 30318

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Bill Waugh
    Sent: Wednesday, November 16, 2016 10:41 AM
    To: Mary French <MFrench@atlantaballet.com>
    Subject: Re: [Tessitura Shared Reports Forum] Payment Plan Discrepancy report

     

    We have a draft of a report that is somewhat similar to what you're asking for.  The report finds any orders that are unpaid (or partially paid) and then provides a summary of the current amount due on the order compared to the future billings that are due on the order.    If the future billings are not the same as the amount due, then the order needs some investigation.

    What would be the scenario wherein you get a payment for the wrong amount?   

     

    Cheers,

    Bill Waugh

    Starlight Theatre

    From: Mary French <bounce-maryfrench5367@tessituranetwork.com>
    Sent: 11/16/2016 9:09:03 AM

    So we use payment plans for both Credit Card billing and Normal Billing in our school.  What we are looking for is a report or utility that notifies us when a payment is made that does not follow the Payment Plan (different amount paid than what is currently due).  Example - next payment due is $70 by 11/22 - payment is made on order for amount not $70

     

    Thanks

    Mary




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data