Internal · Reconciliation

Partially Payment Reconciliation

Compare paid Partially charges against the RealGreen payment ledger, using payment plan enrichment to derive customer numbers before falling back to email plus amount matching.

supadmin Return to Internal

Files

Upload all three CSV exports, then run the reconciliation. The table defaults to exceptions so the older ledger gaps stand out first.

Partially Payments

Actual charge attempts. Paid rows become the primary reconciliation set.

Choose CSV

Or drag the payments CSV onto this card.

No file selected

Partially Plans

Plan-level enrichment. Used to map `plan #` to SKU and derived customer number.

Choose CSV

Or drag the plans CSV onto this card.

No file selected

RealGreen Ledger

Posted payment export. Used as the ledger source of truth for posted rows.

Choose CSV

Or drag the ledger CSV onto this card.

No file selected

Select the three CSV files to begin.

Match Order

Use `payment plan number` from the payment export.
Join to `plan #` in the plan export.
Read the trailing numeric customer id from `line items sku` when available.
Match `CustomerNumber + PaymentAmount` in the RealGreen ledger.
Fallback to normalized `EmailAddress + PaymentAmount` if customer id is unavailable or incomplete.

Review Codes

matched-customer-amount: Exact match by derived customer number and amount.
matched-email-amount: No customer-number match, but email and amount align.
amount-mismatch: Customer exists in the ledger, but not for the same amount.
customer-not-in-ledger: No customer-number match in the ledger window.
missing-customer-id: SKU did not expose a usable customer number.
plan-canceled-no-ledger-match: Plan is canceled and no payment match exists in the ledger.
plan-refunded-no-ledger-match: Plan is refunded and no payment match exists in the ledger.
not-yet-in-ledger-window: Payment date is later than the max ledger date in the uploaded RealGreen file.
unresolved-failed-payment: Failed/declined payment attempts with no later paid row for the same plan and amount, or email and amount when the plan is blank.

Outcome	Review Code	Payment Date	Amount	Email	Name	Plan #	Customer #	Plan SKU	Plan Status	Ledger Window	Ledger Amounts	Ledger Invoices	Ledger Dates

Access restricted

Partially Payment Reconciliation

Files

Partially Payments

Partially Plans

RealGreen Ledger

Summary

Access restricted

Partially Payment Reconciliation

Files

Partially Payments

Partially Plans

RealGreen Ledger

Summary

Review Table