If you've been using another system (or multiple systems) to manage your business and clients, you may want to bring all of your records into Dubsado so that everything is in one place.
We do offer a White Glove Data Migration service to all users on paid plans, but if you would rather go the DIY route, this guide is for you!
Here's an overview of the process:
- Step 1: Import your client list
- Step 2: Set up projects
- Step 3: Upload existing forms and contracts as PDFs
- Step 4: Create payment schedule and package templates
- Step 5: Re-create invoices
This article is a guide to the migration process, but does not go over every single step and feature in detail. Please follow links to the supporting articles for each step!
👋 Here's a tip... if you are brand new to Dubsado, we don't recommend starting here! It's best to learn your way around the system first. Start with our Dubsado Basics series.
Step 1: Import your client list
The first step is to bulk import your client list using a CSV file. If you've been using Excel or Google Sheets to keep track of your clients, you can save your spreadsheet as a CSV to import into Dubsado. Otherwise, you'll want to locate the export function in your current system, which will generate a CSV file for you.
Import your client list under Utilities >> Address Book >> Import.
Follow the instructions in the article below for tips on how to optimize your CSV file for Dubsado:
👋 Here's a tip... to save time in Step 2, you might consider turning on the "Import as leads" option during your import so that a new project will be created automatically for each of your clients. This is NOT recommended if you do not have contracts, invoices, or ongoing work for the majority of your clients.
Step 2: Set up projects
In Dubsado, a project is the communication hub with your client, and is used for sending contracts and invoices along with emails, scheduling invites, and other forms. Generally we recommend setting up one project for each "encounter" or new contract with the client. For example, a photographer would create a new project for each session, but a consultant might have one project per client.
If you did not have something similar to projects in your previous system, we recommend checking out the following articles first to understand how projects are used in Dubsado and how they will work for your business:
To create a new project, go to Projects >> New Project. Give the project a title. With your client list already imported, simply search for or select a client from the dropdown menu to associate the project with them.
For the project status, set the status to:
- Job: No Status if you consider the client to be booked with you, usually meaning that you already have a signed contract or paid invoice
- Lead: No Status if the client is still in the inquiry or onboarding stage
If you've already created custom project statuses, you could use one of those instead.
Finally, you may also want to set a project date at the bottom of the window when creating your project.
Step 3: Upload existing forms and contracts as PDFs
Now that your projects are created, any contracts or other forms your clients have completed have a place to go!
First, make sure all of the contracts and forms you want to upload have been saved or exported as PDFs on your computer.
- Open the project from the Projects page or use the search bar at the top of your screen to find it.
- Under Contract in the project sidebar, select Upload PDF file as signed contract.
- Select your file and click Add to upload it.
All Other Forms
- Inside the project, go to the Forms tab.
- Use the dropdown to select Upload New PDF as Form.
- Select your file and click Add.
- Hover over the file and click Apply to Portal to mark it as already having been sent to the client.
If you have any general notes to add to the project, you can go to the Notes tab and enter them there!
Step 4: Create payment schedule and package templates
Setting up your payment schedule and package templates will save you time in Step 5 when you re-create your existing invoices.
If you invoice your clients in installments or charge a deposit, you'll want to set up a payment schedule. Payment schedule templates can be applied to invoices to list out the due dates and amounts due. Setting up the templates now will allow you to quickly add one to any invoice that needs it.
A package is anything with a price point in your business. Essentially, it is a template for a line item or a set of line items that you can use to build an invoice.
If you didn't have something similar in your previous system, take a look at your invoices and see if there are any line items you frequently repeat. You will have the opportunity to edit each line item after applying a package to an invoice, so anything you can set up as a template ahead of time will help!
Step 5: Re-create invoices
The best way to record existing payments and invoices in Dubsado is to recreate each invoice. While you could upload a PDF copy of the existing invoice under the Forms tab on the project, this would not allow you to record a payment.
- Open the project and go to the Invoices tab.
- Click Add to start a new invoice.
- Use the Packages dropdown to click and add package templates to the invoice.
- For any line items that weren't created as packages, click New Line Item to fill in the item name, description, price, etc.
- Use the Apply dropdown and select Payment to record any payments that have been made on the invoice. Enter the date, method, and amount.
- If you would like to add a payment schedule, use the Payment Schedules dropdown to select one of your templates (recommended for open/unpaid invoices only).
What if I have multiple invoices?
If you need to add more than one invoice to a project, just click on the Invoice List tab and repeat!
How about recurring invoices?
Click on the Recurring Invoices tab to add a new recurring invoice. You'll set up the line items the same as before, except you also need to define the recurring settings. Set the invoice to start on the date the client should receive their next invoice.
👋 Here's a tip... to save time recording past payments, you may want to create a single invoice with a line item for the total amount you've invoiced the client on their recurring plan so far and apply the payments to that single invoice.