Open binary1230 opened 9 years ago
The file format has changed significantly from when this app was first written.
Having just gone through this manually, here's the formula we should be doing as of 11/13/14:
Export all Stripe Transfers as a CSV for the date range you are looking to reconcile. Multiply all fee columns by -1 for report to sum correctly.
The columns we need from the CSV in order to match the numbers correctly in Stripe are:
SALES:
total gross = adjustment gross + charge gross + refund gross
FEES:
total fees = adjustment fees + charge fees + refund fees
The file format has changed significantly from when this app was first written.
Having just gone through this manually, here's the formula we should be doing as of 11/13/14:
Export all Stripe Transfers as a CSV for the date range you are looking to reconcile. Multiply all fee columns by -1 for report to sum correctly.
The columns we need from the CSV in order to match the numbers correctly in Stripe are:
SALES:
total gross = adjustment gross + charge gross + refund gross
FEES:
total fees = adjustment fees + charge fees + refund fees