When looking at the Offering view, you may notice that some offerings display two dates. The difference between the two dates relates to the difference between when an offering is initially received by Vanco and when the offering is received by a church's bank.
For Vanco offerings, there are two dates that we take into consideration:
- Given Date - This is when the money is recognized as having officially left the giver's control and has been received by Vanco. In Vanco, this date is called the settlement date.
- Batch Date—This is the date the offering was deposited into your church's bank account. It may also be called the deposit date on Vanco reports.
After receiving much feedback from customers encouraging us to bring in the Batch date along with the given date, CTS has implemented a new import process with Vanco that allows both dates to be displayed.
When looking at a Vanco offering on the detailed Offering view, the batch date is displayed along with the given date in parentheses.
Grouping
To better handle financial reconciliations, offerings are grouped into batches by batch date and sub-divided by giving method, if their Vanco encryption key is entered in Vanco Integration. This may cause batch dates to have up to three batches on a particular day.
This allows Church360° Members to better organize offerings, before sending them as a batch to Church360° Ledger as a pending deposit. Batches also show account fees paid to Vanco by the giver separately within their batch calculations.
Sorting
The detailed Offering view is sorted based on a hierarchy of levels:
- If your site does not use a Vanco encryption key,
- Offerings are sorted by batch date (which, for manually entered offerings, this date is considered the same as the given date)
- Offerings are then sorted by Created At date
- If your site does use a Vanco encryption key,
- Offerings are first sorted by batch date (when it was deposited into the church's bank account)
- Offerings are then sorted by given date (when the donation settles with Vanco)
- Offerings are then sorted by Created At date
Filtering
For other reporting based on giving status, the Offering view's date range filters based on the given date and shows the total given by the donor, including fees. This is to help with annual giving reports like fund summaries and contribution statements.