How to match up postings in Tessitura with postings (deposits?) from WorldPay?

Danette's tip about the provider batch time is a great one. It pairs really well with some advice we have in our batch management documentation, which says in part: 

In order to facilitate accurate reconciliation, the Tessitura Network recommends developing organization-wide practices to align all transaction dates, payment dates, batch dates, and posting dates. This allows the various Tessitura financial reports, which deliberately draw against different date sources depending on the report's intended use, to reflect results that match. It also allows Tessitura reports to reconcile against credit card payment provider reporting.

• The transaction date refers to the system-generated date and time that a user took an action, such as saving new contributions or orders, taking payments, and making adjustments or refunds. All transactions take place inside batches. The transaction date (along with the payment date, if applicable) is a key component of Tessitura’s audit trail, and is not editable.
• The batch date refers to the date the batch was opened. Reconciliation is easiest when all transactions in a batch have transaction dates that match the batch date. In practice, this means that users should only record transactions in batches with today's date. Do not use a batch from an earlier date to record new transactions.
• All postings are dated with a posting date, and the posting date is editable. Within a single posting, all batches should have the same batch date, and the posting date should be edited to match.
• Order dates and contribution dates are not commonly used in financial reconciliation. While they often reflect the original transaction date, they can be edited, such as when fulfilling rollover orders or when entering mailed or lockbox contributions. Additionally, a single order or contribution may contain many transactions over time. Financial reconciliation should be based on the transaction, payment, batch and posting dates as described above.

If you have these recommended pieces in place, and you still are having trouble reconciling with WorldPay, we'd love to help you further in a support ticket. Just email hello@tessituranetwork.com to get started. Also happy to hear if the community has more advice on this one. 

-Michael Flaherty-Wilcox 

Director of Practice Management, Tessitura Network

Danette's tip about the provider batch time is a great one. It pairs really well with some advice we have in our batch management documentation, which says in part: 

In order to facilitate accurate reconciliation, the Tessitura Network recommends developing organization-wide practices to align all transaction dates, payment dates, batch dates, and posting dates. This allows the various Tessitura financial reports, which deliberately draw against different date sources depending on the report's intended use, to reflect results that match. It also allows Tessitura reports to reconcile against credit card payment provider reporting.

• The transaction date refers to the system-generated date and time that a user took an action, such as saving new contributions or orders, taking payments, and making adjustments or refunds. All transactions take place inside batches. The transaction date (along with the payment date, if applicable) is a key component of Tessitura’s audit trail, and is not editable.
• The batch date refers to the date the batch was opened. Reconciliation is easiest when all transactions in a batch have transaction dates that match the batch date. In practice, this means that users should only record transactions in batches with today's date. Do not use a batch from an earlier date to record new transactions.
• All postings are dated with a posting date, and the posting date is editable. Within a single posting, all batches should have the same batch date, and the posting date should be edited to match.
• Order dates and contribution dates are not commonly used in financial reconciliation. While they often reflect the original transaction date, they can be edited, such as when fulfilling rollover orders or when entering mailed or lockbox contributions. Additionally, a single order or contribution may contain many transactions over time. Financial reconciliation should be based on the transaction, payment, batch and posting dates as described above.

If you have these recommended pieces in place, and you still are having trouble reconciling with WorldPay, we'd love to help you further in a support ticket. Just email hello@tessituranetwork.com to get started. Also happy to hear if the community has more advice on this one. 

-Michael Flaherty-Wilcox 

Director of Practice Management, Tessitura Network