Field Notes · 2 June 2026
Preparing settlement files before an audit week
A short checklist so your first audit week is spent reading numbers, not hunting missing CSVs.
Audit weeks stall when settlement files arrive late or incomplete. The following preparation keeps fieldwork focused on reconciliations rather than inbox chasing.
What to gather
- Settlement exports for three consecutive months, including fee deductions.
- Enrolment or invoice exports covering the same dates, with learner or order IDs.
- Refund and chargeback logs with reason codes where available.
- The exact spreadsheet or slide your board saw for those months.
Naming that helps
Save files with period and source in the name — for example 2026-03-ipay88-settlement.csv. Avoid “final_v7”. When multiple gateways are in play, keep one folder per merchant account.
Access without risk
Read-only exports are enough for most reviews. You do not need to share production admin passwords. If a portal blocks bulk export, screenshot limits and tell us early so we can adjust the sample.
Bring these items to your audit brief, and we will confirm whether anything else is needed before kickoff.