Overview - Before Importing Your Estimate
Make sure the Lead you’re importing into already has an empty Estimate.
If no Estimate exists, create one first.
Once the Estimate is ready, import your estimate file into JACK.
⚠️You must have an existing estimate before importing, or the file cannot be uploaded.
Step 1: Create or Select a Lead
Go to Sales > + Lead to create a new lead, or select an existing lead.
Use this Lead to set up or test your Estimate Template without affecting live data.
⚠️Dummy leads are ideal for testing workflows safely.
Step 2: Create an Estimate
Navigate to the Estimates tab and click + Estimate.
Enter a Name for your estimate, for example, “Test Import”.
Select the Project Type.
Click Create Estimate.
Step 3: Format Your Data File
Go to Settings > Import Tool > CSV Template
Scroll down and download the template 'Costings to an Estimate'.
Transfer your data into the downloaded file, following the template layout below.
💡Keep your column headings consistent with the template headings. This ensures JACK recognises your data.
Step 4: Setting Up Cost Categories and Units of Measurement
Navigate to Settings > Data Setup > Cost Categories.
Check existing categories or add new ones by entering the names.
Use ALL CAPITALS or Initial Capitals.
Once created, categories cannot be changed.
Make sure the entries in Columns B and G of your CSV match the units listed here.
Step 5: Importing Costings
Navigate to Settings > Import Tool and select Costings to an Estimate, then click Next: Add Data
Drop your CSV file onto the upload screen, then click Upload Data
Map your data. Any fields still needing mapping are shown in red. Click the arrows in a data field to map it to an existing field in JACK, or add a new field to match your import. If your file contains columns that don't exist in JACK, click Map Columns in the upper-right corner to map them. Any columns you leave unmapped won't be imported.
Once you've mapped everything you need, click Import All, then click Import on the Import All Rows confirmation screen.
When the Import Complete confirmation appears, click Done. Your costings will now show in the estimate.
⚠️ Imports can't be undone, so check your mapping carefully before you click Import.
Step 6: Creating an Estimate Template
Go to the Lead > Estimates and click the three dots next to your estimate.
Select Create Template.
Rename or adjust the data as needed.
Change the status from Draft to Published to finalise.
💡Once published, the template is ready to reuse for future estimates.
✅ You’re done! For further details, see this article.