TallyPrime Petpooja Integration - Restaurant Sales, Aggregators, Item-Wise GST

Petpooja is India's largest restaurant POS by installed base — over 50,000 restaurants use it for orders, inventory, aggregator integrations (Zomato, Swiggy, Magicpin, EazyDiner), and daily reporting. But the Tally sync is the single biggest gap in the Petpooja workflow. Restaurant chains manually enter daily sales into Tally by re-typing from the Petpooja day-end report, aggregator settlement CSVs (which come 2-7 days after the order) are reconciled by hand against orders logged days earlier, and item-wise GST (5% for dine-in and takeaway, 18% for alcoholic beverages, ITC-restricted for restaurants under the composition scheme) has to be split by category by hand.

This connector wires the Petpooja API directly to Tally. Day-end sales voucher posts automatically at close of business — total sales, tax collected, revenue split by dine-in / delivery / takeaway / aggregator, and item-wise GST breakdown by category. Aggregator orders from Zomato, Swiggy, Magicpin, and EazyDiner come in tagged with the aggregator ID; when the aggregator settles the payout (T+2 for Swiggy, T+7 for Zomato, weekly for others), each settlement line is matched against the original orders and posted as a Receipt Voucher. Aggregator commission (typically 22-30% of gross), promotional discount funded by the restaurant (if any), and GST on commission are all split into separate ledgers for clean P&L visibility on aggregator margin — a huge gap in most restaurant accounting today.

Kitchen vs bar revenue splits are preserved via Petpooja's category master — kitchen revenue (food) goes to one revenue ledger, bar revenue (alcohol) goes to another, so the standard restaurant KPI 'liquor mix percentage' is directly readable from Tally MIS. This is the single most-asked-for metric by restaurant investors and lenders, and today it takes end-of-month effort to compute manually. Multi-outlet chains map each Petpooja outlet to a Tally cost centre, and consolidated group P&L is available across outlets.

Inventory movements (raw material consumption per menu item via the Petpooja recipe master) flow into Tally as consumption vouchers for restaurants that maintain inventory-based costing. For restaurants running the composition scheme (turnover under Rs 1.5 crore), the connector operates in composition mode with no input credit posting; when the restaurant crosses the composition threshold, it switches to standard GST mode automatically.

Liquor revenue is a specific edge case worth calling out. State-specific excise duty on liquor (levied by the state at a slab that varies from 10% to 60%+ of MRP) is posted to a state excise liability ledger, intentionally kept separate from GST because excise is not a GST liability. It flows into your state-specific excise return, not GSTR-1.