Calculations
Make Business Simple with How We Compute Sales, Taxes, and ROI
Dashboard Analysis
A sample overview of transaction summaries, operating revenue, and recharge & marketing data.
₱104,138.93
Sum of All Transaction Amount
45 ( 6 )
Number of Receipts: Total Amount of Receipts Produced • Number of Refund: Number of Refund Accumulated
₱0.00
For Credit on Hold
₱0.00
Handling Fee: ₱0.00
Payment Discount: ₱0.00
For Partnered POS Payment Terminal Transaction Payment
Total Transaction Amount: ₱104,138.93
Actual Revenue: ₱104,138.93
No Data Available
Operating Revenue: ₱104,138.93
| Payment Methods | Actual Received Amount |
|---|---|
| Cash | ₱35,784.34 |
| Credit Card | ₱30,209.94 |
| GCASH | ₱27,344.65 |
| MAYA | ₱10,800.00 |
Breakdown of Payment of Methods
Recharge & Marketing Total Revenue: ₱0.00
No Data Available
Membership Mode of Payment and Recharge Revenue
Transaction Computations
Reference formulas for how MxiPOS computes totals, expenses, profits, and mode of payments.
Total
Total = Net Sales + Service Charge
Total = (Gross - Discounts) + Service Charge
Expenses
Expenses = Sum of Cash Expenses + Non-Cash Expenses
Profits
Profits = Total - Cost - Expenses
Profits = (Net Sales + Service Charge) - Costs - Expenses
Profits = ((Gross Sale - Discounts) + Service Charge - Cost - Expenses)
Mode of Payments
Mode of Payments = Net Sales + Service Charge
• Each Mode of Payment total is equivalent to the Z-Reading Mode of Payments.
Sample Discount Computations
See how MxiPOS applies each discount type. Enter a base amount to preview every scenario at once.
Regular Discount — ₱100 Off
A fixed peso amount is deducted from the subtotal.
Regular Discount — 10% Off
A percentage is deducted from the subtotal.
Senior Citizen (20% + VAT exempt)
RA 9994 — remove 12% VAT first (÷1.12), then apply 20% discount.
PWD (20% + VAT exempt)
RA 10754 — remove 12% VAT first (÷1.12), then apply 20% discount.
National Athlete (20% + VAT restored)
RA 9064 — remove 12% VAT first (÷1.12), apply 20% discount, then add back the VAT that was removed.
Solo Parent (10% + VAT exempt)
RA 11861 — remove 12% VAT first (÷1.12), then apply 10% discount. Discount rate varies depending on the City.
PAX Discount — 4 Pax, 1 SC (20% + VAT exempt)
Discount applies only to the eligible person's share. Total bill ÷ number of pax = per-pax share; SC discount is computed on that share, the rest pay full.
PAX Discount (Non-VAT) — 4 Pax, 1 SC (20%)
Non-VAT business: no VAT to remove. Discount applies only to the eligible person's share. Total bill ÷ number of pax = per-pax share; 20% SC discount on that share, the rest pay full.
Sample computations based on standard Philippine discount rules. Actual application may vary by business type.
Sample Service Charge Computations
See how MxiPOS applies service charges for both Non-VAT and VAT-registered businesses. Enter a base amount to preview every scenario at once.
Non-VAT Service Charges
In this example, we have applied the Service Charge on the Gross Sales Value. Regardless if there are discounts, the service charge will be calculated on subtotal.
VAT Service Charges — Without Discount
When business is registered as VAT, Service Charge is computed without VAT (VATable Sales or VAT Exempt Sales) and discounts (Gross Sales).
VAT Service Charges — With Discount
Following the same behavior, Service Charge will apply on the VATable Sales / VAT Exempt Sales, without any discounts.
Sample computations based on standard Philippine service charge rules. Actual application may vary by business type.
X & Z Reading Computations
Reference formulas for how MxiPOS computes VAT, gross sales, discounts, and reading totals.
Interim report; does not reset sales counters; can be printed multiple times without affecting system memory. It usually pertains to shift report.
Sales for the Day
Sales for the Day = Gross Sales for the day
Previous Accumulated Sales
Previous Accumulated Sales = Gross Sales from Day 1 up until before the Sales for the Day
Present Accumulated Sales
Present Accumulated Sales = Previous Accumulated Sales + Sales for the Day
VAT Exempt Sales
VAT Exempt Sales = Σ of all SNR/PWD/Solo Parent discounted items and VAT-Exempted items
VAT
VAT = Sum of all Inclusive VAT
- •VAT per item is computed at = (Selling Price * 12%) / 1.12
VAT = (₱100 * 12%) / 1.12
VAT = (₱12) / 1.12
VAT = 10.71
VATable Sales
VATable Sales = (Sum of all VAT Inclusive Sales) - VAT
NON-VAT Registered Gross Sales
NON-VAT Registered Gross Sales = ∑ ( Item Price * Qty )
Gross Sale = Item * Qty
Gross Sale = ₱100 * 1 pc
Gross Sale = ₱100
Gross Sales
Gross Sales of the Day before all the discounts.
Discounts
Discounts = ∑ of Discounts applied using SNR / PWD / Solo Parent / National Athlete / Regular Discounts (inc Vouchers)
Return
Return = ∑ of Return / Refund Transactions
Void
Void = ∑ of all Void transactions
VAT Adjustment
VAT Adjustment = ∑ of all VAT Adjustment
Net Sales
Net Sales = Gross Sales - Discounts - Return - Void - VAT Adjustment
Service Charge
Service Charge = ∑ of Service Charges
- •See Service Charge computations above.
No. of Transactions
No. of Transactions = Count of receipts used
Starting Receipt: 000001
Ending Receipt: 000010
No. of Transaction: 10
No. of SKUs
No. of SKUs = Count of types of item sold
Mocha Latte Hot x3
Mocha Latte Cold x1
No. of SKUs = 2 (1 Hot, 1 Cold)
Total Quantity
Total Quantity = Number of items sold
Mocha Latte Hot x3
Mocha Latte Cold x1
Quantity = 4
ROI Calculator
Estimate the return on your MxiPOS investment.
Enter your numbers to see your ROI