Skip to content

Search documentation

Find a documentation page by the words on it.

Documentation

Importing a Procedure Price List

If your price list already lives in a spreadsheet or another system, you can import it instead of typing each procedure. You choose a CSV file, check a preview, and only then save. Nothing is added until you select Import procedures.

This feature is controlled by the Billing feature flag. If you do not see it in your clinic, contact Serelora at support@serelora.com and ask for it to be turned on.

Before you start

You need a CSV file with one procedure per row and a header row. Two columns are required, a description and a price. Serelora finds the columns by their headings, so a file exported from another system usually works as it is. These headings are recognized, in any capitals:

  • Description: description, name, procedure or service.
  • Price: charge, price, fee, amount or rate.
  • Code (optional): code, cpt, cpt code or procedure code.
  • Place of service (optional): pos or place of service.
  • Modifiers (optional): any column whose heading starts with mod, modifier or modifiers, such as Mod 1 and Mod 2.

Other columns are ignored. A dollar sign or thousands commas in a price are fine, and blank padding columns and rows are skipped. The file can be up to 1 MB.

Only Admins and Office Managers can import by default.

Step 1: Open the import

Select Manage Clinic in the sidebar, open the Procedures tab and select Import CSV. The dialog is titled "Import procedures from CSV".

The Import procedures from CSV dialog

Step 2: Choose the file

Choose your file. The dialog says "Parsing…" and then shows a preview of every row it read. Nothing is saved yet.

Step 3: Read the preview

Each row shows its Line number in the file, the Code, Name, Price, POS and Modifiers, and any Warnings in amber. Warnings never block the import. You may see:

  • "no procedure code (custom cash-pay item)"
  • "no place-of-service code"
  • a note that the price is zero
  • a note that a code appears twice in the file, or is already in your price list, and is "kept as a separate service"

If a problem would stop the import, a red box above the table says "1 row must be fixed before this file can be imported:" or the same with a number of rows, and lists each one as "Line 12: ...". Fix the file and select Choose another file. See Procedure Import Problems for each message. Import procedures stays unavailable until the list is clear.

Step 4: Select Import procedures

Select Import procedures. A message says "Imported 5 procedures", or "Imported 1 procedure". The import is all or nothing, so either every row is added or none is.

The rows are new entries. An import never changes or replaces a procedure that is already in your catalog, so importing the same file twice adds every row twice. The System column fills in for you: a five-digit code is marked CPT, and a letter followed by four digits is marked HCPCS.

Afterwards

The new procedures appear in the Procedures tab and in the picker when you add a charge. To change one, see Procedure Catalog.