Importing and exporting categories

Prev Next

You can import categories in bulk using a CSV. You can also export your existing category data for reporting purposes.

Downloading the import template

  1. Go to Setup > Categories.

  2. Select Export from the Actions menu.

  3. Deselect Include data and click Download. A blank CSV template is downloaded containing the required column headers.

Completing the template

Open the downloaded file and add your category data. Name, GL Code, and VAT Code are mandatory. All other columns are optional and correspond to the settings described in the Category settings reference.

Importing categories

  1. Go to Setup > Categories.

  2. Select Import from the Actions menu.

  1. Click Find File and select your completed CSV file.

  2. Click Import. A confirmation message appears and the categories are added to Capture Expense. [IMAGE: Categories page showing imported categories]

Exporting category data

  1. Go to Setup > Categories.

  2. Select Export from the Actions menu.

  3. Ensure Include data is selected and click Download. Your category data is exported as a CSV file.