Search Results for

    Show / Hide Table of Contents

    Expense Products

    The Expense products in this section will be available for use throughout the Expense functions.

    Note

    To view the legacy version, please select Legacy User Guide.

    How to view Expense products

    Viewing Expense products

    As per Generic Navigation options, either from left-hand navigation panel, expand Settings and select Expense products from the Expenses folder or enter Expense products in the Search option.

    This will then show the Expense products on the system where normal customisation of Sets can be used.

    • Code: This is the code that was chosen when the product was first created.
    • Description: This will describe the expense product.
    • Expense, Sale, Purchase, Job, Loan, Stock and Payroll: These boxes are ticked showing the other features that the Product can be used in.
    Tip

    To modify the columns displayed, select option on the right of the column display, then tick/untick the information you want to hide or display.

    How to create an Expense product

    Creating a new Expense product
    1. Select Expense products from one of the options as shown above in Viewing Expense products.

    2. Select New.

      Enter the appropriate fields.

    3. Tick the features you would like the products to be available for.

    4. Select Create.

    How to Import/Export Expense Products

    Import/Export Expense products
    • Import
    • Export
    • File information
    1. Select Expense products from one of the options as shown above in Viewing Expense products.

    2. Select Expense Product Import from the option.

    3. Enter the name of the Excel file, which is saved on an external source, and other options.

      Tip

      To create an Import file with the correct field names and formatting, Export a file first and save to your external source. Then use this file to add details ready to import.

    4. Select Submit.

      Selecting Queue from the dropdown option will queue the import process until other actions in iplicit are completed.

      Warning

      iplicit allows a maximum of 5,000 rows in a single Import.

      If your Import is too large, an error message will tell you that the Import cannot be processed and will advise you to create smaller Import files.

      If the latter is not possible, please contact Customer support.

    1. Select Expense products from one of the options as shown above in Viewing Expense products.

    2. Select Expense Product Export from the option.

    3. Tick include closed if required, then select Submit to create an Excel file on an external source.

    4. The Export file is created as an Excel spreadsheet on your local data source.

    Below are the options for filling out the Excel file with the information available for Expense products.

    • Is Active: True or False.

    • Is Expense: True or False.

    • Is Purchase: True or False.

    • Code: Unique Product code.

    • Description: Description of Expense Product.

    • Enforce description change flag: True or False.

    • Legacy_ref: Reference only (optional).

    • Product group: Product group code.

    • Product type: Product type code.

      • S = Services
      • G = Goods
      • O = Others
    • uom group: Enter Unit of measure group code as pre-defined in the Unit of measure group file.

    • uom: Enter the Unit of measure code.

    • p.account: The unique Account code, as defined in Chart of accounts, as entered on the Accounting tab.

    • p.post.cost_centre: Cost centre as entered on the Accounting tab.

    • p.post.department: Department as entered on the Accounting tab.

    • p.post.tax_band: Tax band as entered on the Accounting tab.

    • p.post.fund: Fund as entered on the Accounting tab.

    • p.is_resale: Resale option found on the Accounting tab.

    • Resources: Resource as entered on the Resource availability tab.

    • Resource groups: Resource groups code.


    Updated October 2026

    In this article
    Back to top Generated by DocFX