Expenses Configure

Payroll

Click on the 'Payroll' tab of the Configuration screen. This will display a list of Claim Types, Expenses Types and Dimension Codes from Duet and their mappings to payment codes in Opera 3 Payroll.

The 'Default Payment Code' specifies a code that should be used wherever a specific mapping has not been defined. Therefore, if all expenses are to be imported to the same payment code, then only the Default Payment Code needs to be specified.

To manually edit a mapping, select the required row in the grid and click the ‘Edit Mapping’ button:

The Edit Mapping feature enables you to choose a payment code to map to the Claim Type, Expense Type or Duet Dimension value.

Selecting the 'Exclude from transfer' box will exclude the selected Claim Type, Expense Type or Dimension from Payroll imports.

It is possible to specify mappings and exclusions for each Claim Type, Expense Type and each of the 3 available Duet dimensions. A mapping or exclusion flag for an Expense Type takes precedence over Claim Type, Expense Type takes precedence over Dimension1, Dimension1 over Dimension2, and Dimension3 over Dimension2.

Selecting 'Claim Type', 'Expense Type' or the Dimension name from the 'Mapping' dropdown will refresh the list to display the values for the selected mapping.

Nominal

Click on the 'Nominal' tab of the Configuration screen. This will display a list of Claim Types & Expense Types from Duet and their mappings to Opera 3 Nominal Ledger account codes.

Claim Type

Selecting the 'Claim Type' option from the Mapping dropdown will display a list of Expense Claim Types from Duet:

The Nominal Import creates a Debit (DR) transaction against each Expense Type account (and the VAT account, if applicable), and a balancing Credit (CR) transaction for the total against the Claim Type Account.

It may be that the Claim Type account is an employee expense accrual or deferred payment, which is also mapped to the expense payment code in payroll. The accrual account would be debited when you run the payroll nominal update.

To edit a mapping, select the required row in the grid and click the 'Edit Mapping' button:

The Edit Mapping feature enables you choose a Nominal Ledger account to map the Claim Type to.

Ticking the 'Exclude from transfer' box will exclude the selected Claim Type from Nominal Imports.

Expense Type

Selecting the 'Expense Type' option from the Mapping dropdown will display a list of Expense Types from Duet:

The Nominal Import creates a Debit (DR) transaction against each Expense Type account (and the VAT account, if applicable), and a balancing Credit (CR) transaction for the total against the Claim Type Account.

To edit a mapping, select the required row in the grid and click the 'Edit Mapping' button:

The Edit Mapping feature enables you choose a Nominal Ledger account and VAT code to map the Expense Type to.

Ticking the 'Exclude from transfer' box will exclude the selected Expense Type from Nominal Imports.