Mbots - V2.0

Application Flow

Select/Choose Operation

Match Prices Compare Discounts Request Matching Discounts Payouts Validation Sales Revenue Summary Sales Operation Summary Bank Statement Sales Reconciliation Itemwise Sales Reconciliation Payouts Validation Old Marked Food Ready POS Transactional Bank Statement Bank Statement For Direct Sales POS Orders TCS TDS

Operation - Payouts Validation

Compare Field For Swiggy

Orders - Sheet Details

Sheet Number

Sheet Name

Orders Fields

Order Date Field

Order No Field

Order Status Field

Cancellation Attribution

Item's total

Packing & Service charges

Merchant Trade Discount

Net bill value Field

GST liability of merchant

Customer payable (Net bill value after taxes & discount)

Service Fee Chargeable On

Platform Service Fee Field

Total Swiggy service fee (including taxes)

Buyer Cancellation Cost Sharing

Total of Order Level Adjustments

MFR Pressed?

Cancellation Policy Applied

Coupon Code Applied

Total of other charges

Call Center Service Fees

Net Payable Amount (before TCS and TDS deduction)

Net Payable Amount (after TCS and TDS deduction)

TCS

TDS

Swiggy platform service fee

Order Payment Type

Cancellation time

Pick Up Status

Delivery Fee sponsored by Merchant

Cash Pre-Payment to Merchant

GST Deduction

Invoice Summary - Sheet Details

Sheet Number

Sheet Name

Invoice Summary - Horizontal Fields - Sheet Details

Delivered Orders Field

Cancelled Orders Field

Total Orders Field

Invoice Summary - Vertical Fields - Sheet Details

Number Of Orders Field

Total Bill Value Field

Packaging And Service Charges Field

Merchant Trade Discounts Field

Net Bill Value Field

Gst On Food Field

Total Customer Payable Field

Swiggy Service Fees Field

Discount On Swiggy Service Fee Field

Merchant Cancellation Charges Field

Call Center Service Fee Field

Total Swiggy Service Fees Before Taxes Field

Total Gst Over Service Fee Field

Total Of Swiggy Service Fees Field

Cash Pre Payment At Merchant Field

Buyer Cancellation Cost Sharing Field

Delivery Fee Sponsored By Merchant Field

Refund For Disputed Orders Field

Order Level Adjustments Field

Merchant Level Deductions Field - Enter the row where the deduction starts

High Priority Field

Gst 9 5 Field

Net Payable Before Tcs And Tds Field

Tcs Field

Tds Field

Final Net Payable Amount Field

Compare Field For Zomato

Orders - Sheet Details

Sheet Number

Sheet Name

Order Date Field

Order No Field

Bank Reference Number(Bank UTR)

Order Status Field

Item's total

Customer Compensation (INR)

Customer discount amount (INR)

Commissionable amount (INR)

Commission %

Commission Value (INR)

Convenience fee (INR)

Piggybank (INR)

Logistics charge (INR)

Penalty Amount (INR)

Credits Charge (INR)

Cancellation Refund (INR)

Taxes On Zomato fees (INR)

Tax collected at source (INR)

TDS amount (INR)

Amount received in cash (INR)

Total adjustment (INR)

Net receivable (INR) Field

ORDER HISTORY

order_id Field

order_date Field

Amount Field

status Field

Reason Field

Compare Field For BharatPe

Fields Undefined

Compare Field For PhonePe

Fields Undefined

Compare Field For Paytm

Fields Undefined

Compare Field For RazorPay

Fields Undefined

Set Rules

Application

Upload

Application Flow

Select/Choose Operation

Operation - Payouts Validation