Receivables operations

Import invoices from CSV or Excel.

Import invoice data from CSV or Excel. Map columns, review formatting errors and check the imported records in Equisettle.
Product view using fictional demo records.
Example customer workspace in Equisettle.

WHY IT MATTERS

A spreadsheet is not yet a set of usable invoice records.

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

From spreadsheet columns to checked records.

Match the file columns to the fields Equisettle needs, check the rows and review the import result.

01

Upload the source file.

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.

Product screens use fictional demo records.

THE PROCESS

Upload the source file.
Map the columns and check the rows.
Open the imported records.

02

Map the columns and check the rows.

Match the spreadsheet columns to the required fields. Review the rows in the upload dialog and correct the formatting errors shown before submitting.

03

Open the imported records.

Review the resulting records in Equisettle. Check the customer references, dates and amounts, and investigate any errors reported during processing.

Illustrated with fictional demo records.

WHAT THIS GIVES YOUR TEAM

Bring the file in. Check what came through.

01

Map your own columns

Match the columns in your file to the fields Equisettle needs, rather than retyping every record.

02

Check rows before submitting

Review the spreadsheet data and correct the formatting errors shown in the upload dialog.

03

Use CSV or Excel

Upload a supported .csv.xlsx or .xls file from your existing records.

04

Follow the import progress

See the upload status and check the result, including any reported processing errors.

05

Work from the imported records

Open the resulting records in Equisettle and check the customer references, dates and amounts in context.

See how this fits your receivables process.

Start with your own accounts, or compare the plans before you choose.

Questions about this feature.

Which files can I upload?

The upload form accepts CSV and Excel files: .csv.xlsx and .xls.

How do I map columns from my file?

The upload dialog lets you match your spreadsheet columns to the fields Equisettle needs. Check the mapping before submitting the records.

Can I review the data before importing it?

Yes. Review the spreadsheet rows in the upload dialog and correct the formatting errors shown before submitting.

What should I do if the import reports errors?

Review the processing result and investigate the reported errors. Check the records that were created before assuming the whole file imported successfully.

Where do I find the imported records?

After processing, review the resulting records in Equisettle and check the customer references, dates and amounts against your source file.

Does importing a file mean reminders have been configured?

Importing data and configuring customer communications are separate tasks. Check any workflow settings in your workspace before using the records for customer contact.

Know what needs to happen next.

See the account, the open issues and the work already done before deciding what comes next.

Get started

Who are you managing receivables for?

My own business Owners and in-house finance teams