Reconciling Credit Card Activity to Posting on the Bank Statement

Assuming one uses the batch report to record deposits in the Cash account on Quickbooks (or any GL system) is there a report or group of reports that will assist in reconciling credit card activity to the posting on the bank statement.

I was told that the Tessitura Posting by Transaction (in March there were over 9,000 entires mainly due to a conversion) and a batch total report from Transcend would be the link, but that is not apparent to me.

I am sure the finance people at Tessitura's licencees have a procedure they follow to do something as basic as a bank rec.

Thx

Parents
  • Former Member
    Former Member $organization

    The transaction by posting report is an awesome report that shows everything in detail. When you save it as an excel file it looks a bit daunting, but once you sort the columns it’s a very useful report.

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Friday, April 08, 2011 2:58 PM
    To: Jon-Paul Eddings
    Subject: RE: [Tessitura Finance Forum] Reconciling Credit Card Activity to Posting on the Bank Statement

     

    Fred -

    These are some good basic reports I'd recommend: (from the Finance folder)

    GL Posting Summary Report by Day

    GL Summary Report

    Transactions by Posting

    Income by Payment Method

    The important thing to note about the first three reports is that they are based on POSTING which usually happens at the end of the box office day (or the following day depending on your business practices). Income by Payment Method is real-time live data.

    HTH,

    Heather
    Seattle Rep 

    From: Fred Witte <bounce-fredwitte1105@tessituranetwork.com>
    Sent: 4/8/2011 1:22:16 PM

    Hi Jean, I just got access for Tessitura on my computer and would like to know what reports you use to do the day to day recording of acltivity on the GL. I only have been allowed to get a handful of reports that a non-accountant thinks I need, but I would prefer to say "Here is what I need".

    Also, you say you use the Posting Report to record deposits, do you get the Posting Report from the Finance folder in Tessitura?

    Thanks much,

    Fred Witte 978-546-7391 x104

    PS I was orignially logged in as Megan Hinckley since I was not registered until today.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance 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
  • Former Member
    Former Member $organization

    The transaction by posting report is an awesome report that shows everything in detail. When you save it as an excel file it looks a bit daunting, but once you sort the columns it’s a very useful report.

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Friday, April 08, 2011 2:58 PM
    To: Jon-Paul Eddings
    Subject: RE: [Tessitura Finance Forum] Reconciling Credit Card Activity to Posting on the Bank Statement

     

    Fred -

    These are some good basic reports I'd recommend: (from the Finance folder)

    GL Posting Summary Report by Day

    GL Summary Report

    Transactions by Posting

    Income by Payment Method

    The important thing to note about the first three reports is that they are based on POSTING which usually happens at the end of the box office day (or the following day depending on your business practices). Income by Payment Method is real-time live data.

    HTH,

    Heather
    Seattle Rep 

    From: Fred Witte <bounce-fredwitte1105@tessituranetwork.com>
    Sent: 4/8/2011 1:22:16 PM

    Hi Jean, I just got access for Tessitura on my computer and would like to know what reports you use to do the day to day recording of acltivity on the GL. I only have been allowed to get a handful of reports that a non-accountant thinks I need, but I would prefer to say "Here is what I need".

    Also, you say you use the Posting Report to record deposits, do you get the Posting Report from the Finance folder in Tessitura?

    Thanks much,

    Fred Witte 978-546-7391 x104

    PS I was orignially logged in as Megan Hinckley since I was not registered until today.




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