01
Map your own columns
Match the columns in your file to the fields Equisettle needs, rather than retyping every record.
Receivables operations
WHY IT MATTERS
Column names, dates and amounts can vary between exports. Before the data becomes useful in Equisettle, the columns need mapping and the records need checking. That is an import task, not a reminder campaign.
HOW EQUISETTLE HELPS
Match the file columns to the fields Equisettle needs, check the rows and review the import result.
01
Choose a supported CSV or Excel file and check whether the first row contains column headings. Keep a copy of the source file for comparison.

THE PROCESS
02
Match the spreadsheet columns to the required fields. Review the rows in the upload dialog and correct the formatting errors shown before submitting.
03
Review the resulting records in Equisettle. Check the customer references, dates and amounts, and investigate any errors reported during processing.

WHAT THIS GIVES YOUR TEAM
01
Match the columns in your file to the fields Equisettle needs, rather than retyping every record.
02
Review the spreadsheet data and correct the formatting errors shown in the upload dialog.
03
Upload a supported .csv.xlsx or .xls file from your existing records.
04
See the upload status and check the result, including any reported processing errors.
05
Open the resulting records in Equisettle and check the customer references, dates and amounts in context.
The upload form accepts CSV and Excel files: .csv.xlsx and .xls.
The upload dialog lets you match your spreadsheet columns to the fields Equisettle needs. Check the mapping before submitting the records.
Yes. Review the spreadsheet rows in the upload dialog and correct the formatting errors shown before submitting.
Review the processing result and investigate the reported errors. Check the records that were created before assuming the whole file imported successfully.
After processing, review the resulting records in Equisettle and check the customer references, dates and amounts against your source file.
Importing data and configuring customer communications are separate tasks. Check any workflow settings in your workspace before using the records for customer contact.
See the account, the open issues and the work already done before deciding what comes next.