Day End

Categories

Choose Bar for liquor categories (Whisky, Rum, Vodka, Beer, Cocktails): they get a separate Bar tab on Billing, ml/bottle size presets, and are taxed with the Bar tax (VAT) instead of GST. Categories appear in this order on Billing. Use Up to move a category up. Renaming updates all its items. Deleting a category also deletes its items (same as V1).

Import menu takes a .json menu file (or a backup .json) or a CSV, shows a preview, then you choose Merge or Replace. CSV format (header required): name,category,price,veg,available,code,section,variants — veg = veg/nonveg, available = yes/no, section = food/bar, variants = options with prices, e.g. Chicken:160|Buff:150|Pork:170 (optional code: Chicken:160:CGN-C). Old 6-column files still import. Existing items with the same name are updated; new categories are created automatically.

Google Sheet sync

Not connected

Last sync: never · Pending: 0

Correct Web App URL looks like: https://script.google.com/macros/s/AKfyc…/exec — copy it from Apps Script: Deploy > Manage deployments > Web app URL. Not the Sheet link (docs.google.com/spreadsheets/…), not the editor link.

Reliable sync needs the proxy: open this app from your Vercel URL (https://…vercel.app), not the downloaded HTML file. On Vercel the app talks to our own /api/sync, which talks to Google server-to-server and can read Google's reply. Diagnostics below shows transport=proxy when this is working.

Sync Help / diagnostics

App rb-menu-v36 · App up to date

Last sync attempt: never
Last successful sync: never
Pending bills: 0
Menu sync: never
Last pull: never
Profile sync: never

What syncs between phones (rb-menu-v36): menu, billed bills + voids, and restaurant profile (name/address/phone/GSTIN/FSSAI/footer/paper/GST/service charge/bar tax/tables); menu options/sizes and Food/Bar sections sync with the menu (rb-menu-v36 needs the new Code.gs redeployed as a New version). What stays on this phone: sync URL/token, device name/code, and open (unbilled) table orders. Sync now pushes pending bills, then pulls menu + profile + last 90 days of bills. If Profile sync says the Sheet script needs an update, paste the new Code.gs and redeploy as a New version.

No sync error recorded.

Last 5 sync attempts

NEW in rb-menu-v36 — Vercel proxy sync: use the app from your Vercel URL every day. There, sync goes phone → Vercel /api/sync → Google (server-to-server), so Google's reply can be read and bills confirm as Synced with the Sheet bill number. Opening the downloaded HTML file directly has no proxy and will still hit Google's browser block (GET-direct / no-cors+verify fallbacks only). Diagnostics transport should read proxy.

If bills stay Waiting, check in this order:

1. Web App URL ends with /exec (not /dev, not the Sheet link, not the Apps Script editor link).
2. Apps Script deployment access is Anyone with the link (Execute as: Me). If access is "Only myself", Google returns a login page and sync fails.
3. Token here matches Script Property TOKEN exactly (no spaces).
4. In the Sheet's Apps Script project, run setup() once and allow permissions.
5. After pasting a new Code.gs, redeploy as a NEW version (Deploy > Manage deployments > edit > New version) — editing code alone does not change what the /exec URL serves.
6. Phone has internet, then tap Retry sync. Waiting bills are never deleted by a failed sync.

Restaurant & GST

Profile — edits in Settings sync to other phones

Bill header preview (prints exactly like this)

If this preview looks right, your printed bill / pre-bill will too.

QR table ordering

Off

Customers scan the code on their table, enter name and mobile, and order. Orders come to the phone set as printing phone (keep the app open on it), are added to that table and a KOT prints for the new items only. Customers never see your sync token.

Menu page (public)

Browse-only menu with live prices and availability.

—

Appearance & language (this device only)

Text size and language are per-device only and are NOT included in profile sync. Hindi covers main navigation and billing essentials only.

Menu

Categories, items and short codes are managed on the Menu tab (bottom). Menu syncs to the Sheet Menu tab including the Code column.

Menu data

Sample items: —

Clearing removes only items marked SAMPLE (seeded on first run / demo). Your own items are kept. The cleared menu is then saved to the Sheet with the usual “Save menu to Sheet” sync when sync/demo is connected, so a second phone gets the cleared menu on its next menu refresh.