Import Customers without Projects

Follow

You can easily import your customers from another system into Monchilla.

Format Your File

To import your cusotmers you need to put it into a format that Monchilla can understand. You can either use a free gmail account or you can use a spreadsheet application.

Desktop Spreadsheet Application

If you have a spreadsheet application like Microsoft Excel you can download the CSV Customers Template. See below for detailed information on how to populate the template.

Gmail (Google Docs)

If you don’t have a spreadsheet application you can use Gmail (from Google). Click to open theGmail Chart of Accounts Template.

Note: If you don’t already have a Google account, you can get a free one ataccounts.google.com.

Next, create an editable copy. Click File, then select Make a copy....

Enter a name for the file and click OK.

Populate Template

Now, in your copy of the spreadsheet, you can delete the sample data and paste in your existing records. Be careful not to delete or edit the column headings.

Note: the only required field in this template is the "Customer" column.

Export the Spreadsheet to .CSV Format

Once you have updated the spreadsheet entries, export the file by clicking File, selectDownload as…, and select Comma separated values (.csv, current sheet).

Note: If you are using Microsoft Excel click File, Save As and Select .CSV file.

The file is downloaded to your Downloads folder. 

Import the File to Monchilla

Now, open your Monchilla account. To navigate to the Import page, hover over Settings, and then click Import.

On the Import page, click Skip this Step to get to Step 2: Import Customers and Projects.

 

Next, click Select.

In the window that opens, select the .csv file you just exported, and click Open.

The selected filename will appear below. Then click Import Customer List.

If the import is successful, the page will move ahead to Step 3: Import Vendors.

If the import fails, you will receive an error message. Make sure that the format matches the template and that the filename only contains letters.

You can view your imported customer list on the Customer page. Hover over the Income tab, then click Customers.

Your imported customer list is shown.



Have more questions? Submit a request

Comments

Powered by Zendesk