How to prepare source extracts for a schedule tie-out

Supporting schedule verification only works when source extracts cover the same period and account structure as the schedules inside the application.

Match the period exactly

If the receivable schedule is dated 31 March, the aged trial balance must end on 31 March. A mid-month extract forces guesswork and weakens any financial audit of applications conclusion.

Keep account codes visible

Exports that strip account numbers force reviewers to match by description alone. Descriptions change; codes usually do not. Include both.

Freeze the version you submit

Once schedules enter the application pack, freeze the extract files used to build them. Later bookkeeping adjustments belong in a revised pack with a dated change note, not silent overwrites.

Flag known reconciling items

If management already knows a timing difference, document it beside the schedule. Hidden reconciling items look identical to errors until someone asks.

Bring these extracts to the first intake meeting. Doing so shortens the verification window and keeps the findings memo focused on material exceptions rather than missing files.