Quick start

This walk-through reconciles a bank statement against a cash book using the built-in Bank reconciliation template. Use your own files, or any two CSV or Excel files that share a reference and an amount.

Tip

No files to hand? On the dashboard of a new workspace, Set up your first reconciliation offers a sample ledger and a sample bank statement to download. Use those two.

1. Upload your files

1. In the navigation, open Data → Data sources and choose New data source.
2. Drop your bank statement on the upload area, or click it to browse. CSV and Excel files work, and bank files in MT940, CAMT.053 or OFX are read directly.
3. RefinePoint reads the columns. Check what it found, then save.
4. Do the same for the cash book.

Read more in Data sources.

2. Create the reconciliation from a template

1. Open Reconciliations and choose New process.

2. Pick Bank reconciliation. The preview shows its sides, matching passes and checks.

   

3. Choose Use this template. The designer opens on the first of its ten steps.

3. Connect your data and map the columns

1. On Details, name it, for example HDFC current account.

2. On Sides, choose your bank statement as the data source of the Bank statement side and the cash book for the Cash book side.

   

3. On Fields, check that each of your columns is mapped onto the right field: the reference, the date and the amount. Columns are suggested from names your workspace mapped before and from similar names.

The template already has sensible matching passes and checks; you can leave them as they are for now.

4. Save and run it

1. Go to Review. It lists anything still missing before the reconciliation can run.
2. Choose Create reconciliation.
3. On the reconciliation’s page, choose Reconcile now.

5. Review the results

When the run finishes, its summary shows how many records matched, partly matched or did not match. Open Results to see each record: the values from both sides, the difference, and why it did not match.

Where to go next

• Explain known differences automatically with reason codes.
• Work what is left in Breaks: assign, comment, match by hand and resolve.
• Run it on a schedule, or whenever a new file arrives, with file routing.
• Learn to write rules for filters, fields and conditions.