Home Customer Reconciliation How do I run a new customer reconciliation?

How do I run a new customer reconciliation?

Last updated on Apr 23, 2026

Short Answer: Select ‘Customer reconciliation’, choose or create a customer, upload the Customer statement and Books / Books of accounts files, then click ‘Run reconciliation’.

PreRequisites

  1. Be signed in to CleverBalance

  2. Have a Customer statement file in CSV, XLS, or XLSX format

  3. Have a Books / Books of accounts file in CSV, XLS, or XLSX format

  4. Ensure both files are 10MB or smaller

Steps

  1. Open the New reconciliation page.
    Confirm you can see ‘Select reconciliation type’, ‘Customer statement’, and ‘Books / Books of accounts’.

  2. Choose the reconciliation type.
    Click the dropdown under ‘Select reconciliation type’ and select ‘Customer reconciliation’.

  3. Select or create a customer.
    Under ‘Customer name’, choose an existing customer from ‘Select customer name’.
    If the customer does not exist, click ‘+ New’ to create one first.

  4. Upload the Customer statement file.
    In the ‘Customer statement’ section, either drag and drop the file or click ‘Upload file’ and select your CSV, XLS, or XLSX file.

  5. Upload the Books / Books of accounts file.
    In the ‘Books / Books of accounts’ section, drag and drop the file or click ‘Upload file’ and select the required file.

  6. Click ‘Run reconciliation’.
    Use the yellow ‘Run reconciliation’ button at the top-right to start the process.

Troubleshooting

  1. Upload fails with a file size error
    Likely Cause: The file is larger than 10MB
    Action: Reduce the file size, split the file, or export a smaller date range and upload again

  2. Upload fails with an unsupported format error
    Likely Cause: The file is not in CSV, XLS, or XLSX format
    Action: Save or export the file in a supported format and try again

  3. Customer name is not available in the dropdown
    Likely Cause: The customer record has not been created yet
    Action: Click ‘+ New’ next to ‘Customer name’, create the customer, then select it

  4. Clicking ‘Run reconciliation’ does not start the process
    Likely Cause: A required field or file may be missing, or a temporary issue occurred
    Action: Check that you selected the reconciliation type, selected or created a customer, and uploaded both files before trying again

Note

If needed, use ‘View sample data format’ to verify the required file structure. New users can also use the guided setup option available at the top of the page.