• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 14 views
  • Users 0 members are here
Related

Reconciling A Performance: 1 Order with Multiple Paymodes

Former Member
Former Member $organization

I have been trying to reconcile numerous performances and have come across something I need help on.  I am trying to balance cash, checks and specific credit cards but when one order has multiple payment types it doesn't pull each payment method.  For example:

Customer pays for 6 $10 tickets and pays $20 in cash, $20 in check and $20 in Visa.  When I run the closing statement it is saying the customer paid $60 in cash and is not recognizing the other payment methods.  We have talked about processing orders by payment method but that seems time consuming.

Is anyone else having this issue?  How are you making it work?

Thank you for your time,

Beth

  • $organization

    Hi Beth,

    What report are you using for the closing statement?

  • Former Member
    Former Member $organization

    Good Morning –

    I am using a custom version of the Box Office Statement.


    Beth

     

    Beth Voetsch

    Director of Ticket Operations and Services

    Stanford Ticket Office

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Joshua Peters
    Sent: Tuesday, November 05, 2013 7:28 AM
    To: bvoetsch@stanford.edu
    Subject: Re: [Tessitura Ticketing Forum] Reconciling A Performance: 1 Order with Multiple Paymodes

     

    Hi Beth,

    What report are you using for the closing statement?

    From: Beth Voetsch <bounce-bethvoetsch9016@tessituranetwork.com>
    Sent: 10/30/2013 10:01:20 PM

    I have been trying to reconcile numerous performances and have come across something I need help on.  I am trying to balance cash, checks and specific credit cards but when one order has multiple payment types it doesn't pull each payment method.  For example:

    Customer pays for 6 $10 tickets and pays $20 in cash, $20 in check and $20 in Visa.  When I run the closing statement it is saying the customer paid $60 in cash and is not recognizing the other payment methods.  We have talked about processing orders by payment method but that seems time consuming.

    Is anyone else having this issue?  How are you making it work?

    Thank you for your time,

    Beth




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • Former Member
    Former Member $organization in reply to Former Member

    Beth,

    This is a difficult nut to crack because of the way Tessitura pays off an order. There is no direct correlation between a payment and a line item.  It really isn't possible to determine which seats in an order were paid off with which payment.

    We ran into a similar issue a few months ago with users running the standard Payments by Performance report.  There is a note in the script (from Chuck I believe) that sheds some light on the problem:

    "Note that this is not an exact science. Anything that can't be calculated (usually due to exchanges) is put into a special category.  Anything that was paid for with more than one payment method will not always calculate properly either and will be arbitrarily assigned to one of the payment methods."

    The same problem will exist with any report that tries to marry payments with individual seats in an order.

    So in this case it is a bit more art than science. Payments are applied to orders and after that, the money is applied to line items independent of the payment method.

    - Levi