Pos3/Pos5/FNB: How is margin percentage calculated at POS Profit Margin Report

From AutoCount Resource Center
Jump to navigation Jump to search

Question :

When I view POS Profit Margin Report, there is a Margin (%) column. What is the formula to calculate the margin?

000125-a.png


Solution :

Formula is :

Margin = ((TotalExTax - LocalTotalCost) / A.TotalExTax) x 100

Sample 1 :

000125-b.png


Margin = ((-0.11- -4.23) / -0.11) x 100

Margin = (4.12/ -0.11) x 100

Margin = -37.4545 x 100

Margin = -3745.45%


Sample 2 :

000125-c.png


Margin = ((15- 10.07) / 15) x 100

Margin = (4.93/ 15) x 100

Margin = 0.3287 x 100

Margin = 32.87%


By: CK 20201020 , Jacky 201124, P201126 [000125]


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations