Accounting Payment Gatway Reconciliation

Problem Statement

Businesses using Pelcro need an easier way to reconcile charges, refunds, and disputes with their payment processor. Today, Pelcro’s reports don’t match the processor’s data in a clean, one-to-one way, so teams have to manually filter and adjust numbers to line everything up. This slows down reconciliation, introduces errors, and creates inconsistent financial records.

User Story

As a Finance user,

I want a simple monthly report in Pelcro showing total charges, refunds, and disputes

so that I can easily validate all Pelcro transactions against the processor monthly summary with 100% matching accuracy.

Definition of Done

The feature is complete when:

1. A new report is added under Accounting Reports → Reconciliation.

2. The report includes a monthly selector (YYYY-MM format).

3. Create a table view similar to the screenshot attached.

4. The table displays three rows:

   1. Payments

   2. Refunds

   3. Disputes

5. Each row contains the following columns:

   1. Online total

   2. Offline total

   3. Total

   4. Export button

6. The Export button downloads the related report with its current data points (payments, refunds, disputes).

7. Table layout is simple and structured (non-graphical, no revenue recognition logic).

8. Online vs. offline logic must align with Pelcro’s existing source-of-payment classification.

9. Export file (CSV) includes all displayed fields, grouped by month.