Guides Settings & Configuration Guide Import Data Import Data From CSV Import Materials and Services from CSV File

Import Materials and Services from CSV File

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

Using this guide, you can:


 

Where do I import my Materials and Services?

In Accelo, your Material and Services lists live within your configuration section. You can access the import from either list or from the Import page within your configuration.  

To access your Materials and Services lists:

  1. Click the Settings button. 

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

    ConfigMaterialsServices 

  3. Click the Material List or Service List button.

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

Screen Shot 2016 08 19 at 2.51.40 PM

To access the Imports page:

  1. On the Configuration page, navigate to the Import & Export tab, then select Import Data.

    Import Data 5
  2. On the Import Data page, scroll down to the CSV Import: Materials & Services section, then click the Import button.

    CSV Imports 2

 

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:

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, Service List, or Import Data page.

  2. Upload the CSV on the next page.

    ConfigMaterialsServicesImport

  3. Map the Import Fields as shown above.

    pasted image 0 9 

  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!

Accelo uses cookies to give you the best possible experience - by clicking 'Continue' you agree to our use of cookies. Refer to our Privacy Policy for details. Continue