How do I run a new customer reconciliation?
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.