I'm looking for some kind of report that produces all credit card transactions for a given day to reconcile with bank deposits. We've been using several different reports (Daily Ticket Reconciliation, New Contributions Report, Gift Certificate Listing, and Payment Details for Refunds) to try and reconcile the credit card bank deposit with all the credit card transactions that are processed through Tessitura, and it has gotten overwhelming. It would be great if we could see all of the credit card payments and what they paid to put them into our accounting system (QuickBooks). Any help would be great!
If you print out the Batch Payment Detail, it will list the detail of payments (by ticket holder/donor), by payment type for each batch. Depending on how many batches you post at once you may need to print out a report for several batches to tie to the Posting Report that matches up to your daily G/L entries. This will get you to all the individual transactions. You may still find some discrepancies based on when your credit card stops processing for a day and starts processing transactions as the next day. But your detail will line up with the journal entry at least. Most credit card processors allow you to run reports that will list by deposit the individual payments that were processed that make up that deposit. Using that to compare to your report, you will get an idea of how they align (or don't).
Hope this helps!