Reporting on Reversed Transactions

When a transaction is reversed, 2 transactions exist in your database: the original transaction, plus a reversal transaction for the inverse amount.

For example, the above shows a $10 camper charge created on 3/23/20 that was later reversed on 4/7/20.

On the profile page, a reversed transaction appears once, striked out with the amount set to $0. 

When it comes to financial reports, CampSite will generate the original transaction plus the reversal transaction.

For example, see above how the Transaction Log displays the charge and the reversal as two separate line items.

  • Note how the timestamp for each transaction reflects when they were created, so the reversal will reflect the date that the admin reversed the original transaction. Keep this in mind if you're filtering a report based on 'date created.'

Summed together, both transactions equal $0, to effectively remove the original transaction from being calculated into the grand total at the very bottom of the page.

Filtering for Reversals

The report filters you select determine whether or not your report results include just the original transaction or the original transaction AND the reversal transaction.

Transaction Types Filter

For all financial reports that provide an itemized log of transactions (e.g. the Transaction Log; Camper Accrual Transaction Log, etc.), you must select "Reversals" in the Transaction Types filter in order for the results to include the reversal transaction, as pictured above.

Date Created Filter

Keep in mind that the original transaction will be dated as to when it was created initially, but the reversal transaction is dated as to when the reversal occurred. If you filter by "date created," and the reversal occurred outside of your date range, your results will report the original transaction but not the reversal.

As such, filtering by 'Date created' provides a snapshot of transactions as they existed within the timeframe you selected.

Using Layla Gamble's reversed $10 charge as an example again, the "Date Created" filter on the Transaction Log would need to span from 3/23/20 to 4/7/20 in order to include both the original $10 and the -$10 reversal in the results.

If "Date Created" was filtered for 3/1/20 - 3/30/20, the results would include the original $10 charge but not the -$10 reversal, since the reversal was created outside of that time frame. As such, the grand total of the report results would include the $10 despite that it's been reversed.

Reversals Column

For financial reports that present transaction summaries (instead of itemized transactions) - like the Camper Accrual Transaction Summary; Camper Accrual Summary (By Session or Accrual Period) - reversed transactions will be summed together in a separate  "Reversals" column.

For example, in the Camper Transaction Summary as shown above, the Reversals column reflects all charge, discount, payment, credit, and refund reversals summed together. The individual Charges / Discounts / Payments / Credits / Refunds columns reflect all original transactions (without reversed transactions removed).

As such, the totals of each transaction type (highlighted in yellow above) still include transactions that were later reversed. Only the net total (in the very bottom right cell) reflects only transactions that were not later reversed, by summing all charge, discount, payment, credit, refund and reversal totals together.

That said, the Camper Transaction Summary report is not designed for identifying the total amount of certain transaction types (like total charges or total payments) as those numbers will not have reversed transactions removed. If you need the total amount for a certain type of transaction, use the Transaction Log instead.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk