Upland Community Login | Fr

How can I set Expense Markup Exceptions when applying Markups based on Gross Amount?

The Exceptions capability added to the Expense Markup Settings within Expense Invoicing settings under the Client Edit page gives the ability to choose to Apply Expense Markup on Net Amount and Gross Amount for the same Client but to different expense items.

  • Net Amount; you have the option to Apply Tax on Expense Markup when invoicing (Client Tax Group will be used) or not.
  • Gross Amount; you have the option to Apply Tax on Expense Markup when invoicing for exceptions (Client Tax Group will be used) or not.

This article covers how to set the Exceptions when applying Markups based on Gross Amount.

Use case: One of Software Inc’s clients, Acme Corporation, should have its expense invoicing be set up such that the markup for the Travel Expense Item Airfare be calculated based on Net Amount, while the Books Expense Item be based on Gross Amount. The Tenrox Administrator, John Billings, can configure this requirement by selecting to Apply Expense Markup on Gross Amount, and then selecting the Travel Item Airfare from the Exception List.

Therefore, when a project team member, who creates an Expense Report against a project for client Acme Corporation with these two items, the following will occur:

  • Expense entry for Airfare will have its markup calculated based on Net Amount.
  • Expense entry for Books will have its markup calculated based on Gross Amount.
Version Note: Available as of Tenrox 2018 R1 SP10.

Note: Changes to markup calculations will be effective on new Expense Entries only.

1. Access Client Edit page

Access Client Edit page
  1. From the Icon bar click Settings.
  2. Select Work.
  3. Click Clients.
  4. From the Clients List page select the Client name to access the Client Edit page.

2. Click Expense Invoicing

Click Expense Invoicing
  1. Select the Invoice Options tab.
  2. Click the Expense Invoicing button.

3. Select Net Amount

Select Gross Amount
  1. Select Net Amount from the Apply Expense Markup on options.
  2. Select Apply Tax on Expense Markup when invoicing for exceptions (Client Tax Group will be used) option.
  3. Optionally select Apply Client Tax Group when invoicing Expenses option.
Note: Upon selecting Gross Amount the Apply Tax on Expense Markup when invoicing for exceptions (Client Tax Group will be used) option is enabled. When selected, The Client Tax Group will be used to apply the Tax on Expense Markup when an invoice for exceptions is generated.

4. Select Exceptions

Select Net Amount
  1. Click Exceptions to access the Expense Markup Exception items list.
  2. Select the Items you wish to apply the Exception on from the Available Items list.
  3. Click the right arrow button to add them to the Selected Items list.
  4. Click Back to return to the previous page.

Note: Upon clicking the arrow to add the items or remove items from the list, the page will refresh and a confirmation message will be displayed informing you of the addition or removal of items from the lists.

For more information on:

  • How to set Expense Markup Exceptions when applying Markups based on Net Amount click here.

5. Click Save

Select Net Amount
  1. Click Save to save your changes.
Warning!: Changes to markup calculations will be effective on new Expense Entries only. Changes to Taxes can be reflected on non-posted Invoices by updating the Invoice.

6. View Your Changes

View Your Changes

Note that:

  • Expense entry for Airfare has its markup calculated based on Net Amount.
  • Expense entry for Books has its markup calculated based on Gross Amount.