CoreConstruction operating system

Importing from Excel

Bring in items, vendors, employees, opening stock, balances and BOQs from Excel, with every row checked first.

Who does this: Owner or administrator Head of accounts HR administrator Store keeper

Steps#

  1. Open Admin, then Data import, and choose what to import.
  2. Download the template. Each column has a note explaining what goes there.
  3. Fill it. Keep the column names as they are.
  4. Upload. Core checks every row and shows a preview: rows that will be added, rows that will update existing records, and rows with problems, with the reason for each.
  5. Fix problem rows in Excel and upload again, or go ahead with only the good rows.
  6. Import. Each import is recorded with who ran it.

What you can import#

Import Notes
Items Units and conversions in the same sheet
Vendors GSTIN is checked; PAN and state fill from it
Employees and workers With department, site and bank details
BOQ One sheet per project
Opening stock Per store, as counted on your go-live date
Opening balances Ledger, vendors, clients and bank, as on the go-live date

Tips#

  • Import in this order: items, vendors, employees, BOQs, opening stock, opening balances.
  • Start with a few rows to check the result, then import the rest.
  • An import that updates records keeps the old values in the history.