How do I create a gross to net formula with in Replicon?

(Originally posted by anna)

(Originally posted by anna)

Archived Post, Official Rep

- 2132 Posts
- 7 Reply Likes

Posted 5 years ago

Archived Post, Official Rep

- 2132 Posts
- 7 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

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)

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)