Set settlement reporting preferences

Make our settlement reporting export the way our controller needs it. Configure settlement reports to include daily settlement amounts, fees line-by-line, and the currency of origin, and send CSVs to finance@brightbox.co every morning at 07:00. Confirm report retention is 13 months and that the file name includes the settlement date.

Before I hand the settlement report to accounting, surface the items that will slow their reconciliation. Put total gross, total fees, refunds, and chargebacks at the top; tag rows where routing numbers or account IDs are missing; and call out any settlements that span multiple currencies. Add a note explaining which column maps to our general ledger account codes.

I just uploaded the latest settlement CSV and my controller says the totals don't match our bank deposits. The file shows daily settlements but I don't know if FX conversions or timing differences are the cause. We have the finance director, Maya, breathing down me for a reconciliation tonight. What is the most likely discrepancy and a prioritized list of checks to resolve this before COB?

We keep wasting half-days reconciling settlements because report formats and file names vary, and FX conversions are opaque. Looking across a year of reconciliations, where are we losing credibility and time, and what two changes to our reporting habit would cut those reconciliation disputes in half? Give the exact fields and a naming convention to adopt.