Put in all the Materials & Services you use through a Spreadsheet to save on accounting overhead.

Using this guide, you can:

• Find where to import your Materials & Services

• Learn how to Map your Materials & Services

Where do I import my Materials and Services?

In Accelo, your Material and Services list live in your configurations. You need to access the list page in order to perform your import.  

To access your Materials and Services:

1. Click the Module button at the top left of the screen and select Configuration.
   
    

2. Click the Materials & Services button on the lower left.
   
    

3. Click the Material List or Service List button.

4. Click the +Import button available at the top right of the list.

How do I import my Materials and Services?

It’s important to consider whether or not you want to import in a Service or Material in Accelo before you begin your import. To decide between one or the other on your import, adhere to the following:

• For Services: Do not include a Unit Cost or Price

• For Materials: Include a Unit Cost or Price

• The Cost and Price can not be set to zero.  Zeroes are interpreted as not having a value set.

Note: All cells in your CSV file should be formatted as "Text"

To make sure your Account/Tax Codes import properly, make sure their title exactly matches your existing ledger codes in Accelo. Templates for these imports can be found at:

• Service Items Template
• Material Items Template

After constructing your desired list, it’s time to perform your import into Accelo.

To Import your Materials and Services:

1. Click the Import button from either the Material List or Service List.

2. Upload the CSV on the next page.
   
   

3. Map the Import Fields as shown above.
   
    

4. Click the Next - Preview Import button to check how your fields will come in.

5. Click the Confirm button, and you’ll be all set!