CIFF Calgary - Refund Discrepancy
solved (uba)
Kimberley Busato
Phyllis Lizachich (Book Keeper for CIFF Calgary) asks:
" I just did the reconciliation for January between Stripe and Eventive and there is a difference that I believe is related to two Top Doc refunds and fees processed in Stripe in January. There was also a difference in payouts but that is just a timing difference of when we actually received the money in our bank account so no need to worry about that. I am attaching some spreadsheets of my analysis between Stripe and Eventive that show what I believe is causing the difference. Can you take a look and let me know what you think?"
Phyllis Provided the following supporting documentation for review:
Stripe Summary Report PDF --> https://drive.google.com/file/d/1LmG_93uPYMplHBt8OYkTW7UySOnYBq8H/view?usp=sharing
Eventive Summary Report PDF --> https://drive.google.com/file/d/18vgYDSsaxFoo52rMBoZvbs2M9dzPiuzE/view?usp=sharing
Eventive Sales - January --> https://docs.google.com/spreadsheets/d/1Yj4bDywHdWojOwB6HRVjQqJ1v476WvnD/edit?usp=sharing&ouid=115767116185706162474&rtpof=true&sd=true
Eventive Payouts - January --> https://docs.google.com/spreadsheets/d/1UYxXlHdOs_FLcqODF2InWMG2T2BezHN9/edit?usp=sharing&ouid=115767116185706162474&rtpof=true&sd=true
Stripe Summary Report - January --> https://docs.google.com/spreadsheets/d/1VQQGlyq-ut4o5YNLPiCbIz1flsHfA_mg/edit?usp=sharing&ouid=115767116185706162474&rtpof=true&sd=true
Log In
Kimberley Busato
solved (uba)
Kimberley Busato
I think they are seeing this because they are looking at the old bank transfer log well after the event rather than looking at the ledger based report. When the old report is compiled, the refund is deducted from the order at the time the order was placed rather than the refund being accounted for in the transfer log at the time the transfer was issued (like the way the ledger report accounts for all actions at the time they actually occurred).
Kimberley Busato
Have not yet heard back from CIFF Calgary re: question about credit disputes.
Will try running new ledger-based bank transfer reconciliation report to see if this helps expose the discrepancy for this UBA.
Kimberley Busato
Looking into the documentation provided by the org. They suspected that the discrepancy has to do with ticket refunds related to the January Top Docs screening, but an initial look into these transactions hasn't yielded any useful information at this time.
I've reached back out to Phyllis and Katherine at CIFF Calgary to see if they know of any credit card disputes around the time of these reports.
Also trying to cast a wider net when generating ledger reports for investigative purposes / think of other reasons that the settlement amount is $58.36 higher in Eventive reports than it is in the Stripe summary report. Brainstorming.
Kimberley Busato
info needed (uba)
Kimberley Busato
I'll take this one.