You do not have to move everything. Bring in the customers you will quote again, your price list, the quotes still waiting for an answer and the work you have booked. Leave finished jobs and paid invoices where they are. This page shows how to bring each piece in, and the one thing that does not move cleanly: money a customer still owes you.
What to bring over (and what not to)
| Bring over | How |
|---|---|
| Your customers | Import a CSV, or type them in |
| Your prices | Import a CSV, or type them into the price book |
| Quotes still waiting | Import them as drafts, or rebuild them |
| Work you have booked | Make a quote, mark it approved, convert it to a job |
| Money still owed | A New invoice (see below) |
Leave behind finished jobs, paid invoices and old notes. Chalk's import does not bring in jobs, visits, invoices, payments, notes, custom fields or photos. Keep your paper or spreadsheet as the archive.
Customers from a spreadsheet
- In Excel or Google Sheets, make sure the first row has headings, such as First name, Last name, Mobile, Email, Address. An Excel file must be saved as CSV first.
- In Chalk, go to Settings > Data and find Import clients from another CRM.
- Under Where is it coming from?, pick Any spreadsheet. Press Choose CSV file and pick your file.
- Chalk guesses which column is which. Check every box, and set anything that is not in your file to Not in this file.
- Press Preview. It shows how many are new, how many already exist, and how many rows cannot be used. Press Import.
Importing the same file twice is safe. A file over 500 rows goes in 500 at a time, with Preview next page after each.
Phone numbers decide who gets texts. Numbers in a Mobile or Cell column take texts. If your file has one plain Phone column and no Mobile column, those numbers take texts too. Home, work and other numbers come in marked no texts. That keeps a landline from being texted. See Quiet hours, consent and STOP.
Pin the addresses. After the import, press Pin unpinned addresses on the Map pins card under Settings > Data, so the calendar map can place them. See Import your clients and your price book.
Typing them in from paper
Go to Work > Clients and press Add client. Start with the customers you expect to quote or visit in the next month, and add the rest as they come back. Start typing the street and pick the address from the list so the visit can be mapped.
Your prices into the price book
If you have a price list in a spreadsheet, go to Settings > Data and use Import a price book. Match Name, Unit, Price and, if you have them, Description, Cost, Category and Taxable. Rows with no name are skipped, and so is any row with the same name and unit as an item already in your price book, so a file never changes a price you typed. Units like "sf", "lf", "hr" and "gal" become square feet, linear feet, hours and gallons. Anything else becomes "each".
No spreadsheet? Open Settings > Price book and type your prices. The list already holds names for your trade at $0.
Open quotes
Import open estimates on Settings > Data turns each row into a draft quote with one line and its client. Nothing is sent. Rows whose status says they are closed, such as paid, declined or expired, are skipped. The card is set up for the columns in an export file from Housecall Pro, and you can match any CSV by hand.
Because they arrive as drafts, the customer has not seen them in Chalk. Open each one, check it, and press Send to customer when you want them to get it.
Jobs already booked
Chalk has no job import. For work a customer has already agreed to:
- Make a quote with the agreed lines and price.
- Open More and press Mark approved (the customer already said yes).
- Press Convert to job.
- Press Schedule a visit for the days still ahead, and pick who is going.
See Book, move and confirm visits. If your paper estimates are numbered, set where Chalk starts counting under Settings > Documents > Numbers: Next estimate, Next invoice and Next job. A number already used is always skipped.
Old invoices: record what is still owed
Chalk has no import for invoices and no "mark as sent" button, so bring an unpaid balance in with care.
- Press New invoice under Work > Invoices. Pick the client, add one line for the balance, and press Create invoice.
- It starts as a Draft. A draft does not count in Money owed, by age on Home, and it gets no reminders.
- Press Send to customer to make it a live bill. The customer is texted or emailed a link to pay.
The Due in box counts from the day you create the invoice, and there is no date box, so the invoice will not show its real age. If you do not want to message the customer about an old balance, keep it on your paper list until it is paid.
Your first week running on Chalk
- Quote new work in Chalk from day one.
- Keep paper or the spreadsheet for the old balances.
- Add your most common job as a quote template.
- Take payments through Chalk as customers pay: Record cash and check payments.
For the full order, see Your first week with Chalk.
Good to know
- The Data tab is in Settings, so only the owner and admins can run imports.
- Imported customers are clients, not leads, and nothing is sent to them when they come in.
- Importing a price book is safe to repeat. Importing open estimates twice makes the drafts again, so run it once.
- Moving from another app instead? See Switch to Chalk from another CRM.
- Not sure you are ready? Do you need a CRM yet? is an honest test.