Man City Football Programs · Manchester · Finance

City Programmes Reconciliation

No data loaded Prepared by Coachbetter · as of

Load exports

The dashboard shows data only from the two exports you load here. Files are read in your browser – nothing is uploaded or stored, and closing or reloading the page clears the data.

1 · Stripe payments export Payments export with all columns, incl. the metadata field reference_number CSV · XLSX · Numbers Drop the file here or choose file 2 · Coachbetter invoice export Invoice export with Invoice reference and Payment reference CSV · XLSX · Numbers Drop the file here or choose file

Summary

GBP · Net = Gross ÷ 1.20 · VAT = Gross − Net · click any figure for its records

Revenue & VAT

Open items

Income by month

Collected by UK payment month (gross after refunds) · Expected by invoice due month · click a bar for its records

CollectedExpected (open)

Monthly revenue by programme

Collected in Stripe by UK payment month, after refunds · click a figure for its records

Reconciliation · Coachbetter vs Stripe

Primary key: Coachbetter Payment reference = Stripe reference_number (metadata). Each match is then validated on amount, currency, customer email, status and date.

Amounts

Record counts

Matching status

Refunds, failed payments & open items

Kept apart from revenue. Only captured Stripe charges count as revenue; refunds are deducted separately.

VAT overview

UK VAT 20%, extracted from gross (VAT fraction 1/6), calculated on unrounded values and rounded for display only.

Data-quality findings on tax

Coachbetter tax fields. All Coachbetter invoices carry Tax Rate 0%, Taxes 0 and Amount without Tax = Total. The invoice export therefore cannot be used for VAT; the VAT figures here are derived from the gross amounts.

Net collected by programme

NetVAT

Gross collected per day (UK date)

Stripe captured charges

Detailed transaction overview

Grey indented rows are additional Stripe attempts (failed or cancelled) on the same invoice. Original export values are shown unchanged in the CB and Stripe columns; Net, VAT and statuses are calculated. The full dataset with every original column is in the accompanying Excel file.

Exceptions & manual review

Sorted by severity. “Review” items need a decision; “Info” items are explained and need no action.