SandQuery Reports Log in

Reversal and refund pairing

by SandQuery ยท Free

What it needs

  1. Generic Bank StatementDownload a blank CSV

About this report

Pairs each debit with an offsetting same-vendor credit within 30 days, and lists the debits that never came back.

What you'll get

  • Vendor Key string
  • Currency string
  • Magnitude decimal
  • Debit Date date
  • Credit Date date
  • Days To Reverse integer
  • Pair Status string