Gross to Net Calculation in Gen2

  • 1
  • Question
  • Updated 4 years ago
How do I create a gross to net formula with in Replicon?

(Originally posted by anna)
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes

Posted 4 years ago

  • 1
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes
Hi Anna,

The "gross to net" formula instructs Replicon how to calculate backwards from the gross (total expense amount) to the net (pre-tax amount) for an individual expense. Providing this formula will ensure expense amounts are correct, whether the user enters the net or the gross amount for a specific expense.

Below is the expansion of the formula on how gross to net is calculated.

Considering that tax is 7% of Net

 Gross = Tax + Net

 Tax = 0.07*Net

 Substituting Tax with the formula mentioned above,

 Gross = 0.07*net+Net

 Gross = Net(0.07+1)

 Therefore,

 Gross = Net * 1.07

 Net = Gross/1.07

Note:
More information about gross to net formula is available in the below given KB article.
http://www.replicon.com/customer-zone/kb-1000426

Steps to add the above formula are as follows:-

1. Log into Replicon as Administrator.
2. Go to Administration > Expense Setup.
3. Click on the required Expense code.
4. Enter the formula in the Gross To Net Formula.
5. Click on Save.

Thanks,
Lingaraj




(Originally posted by Lingaraj Dharwad)