Exporting your data (CSV, GST and payroll files)

Your data belongs to you, and you can download it at any time as CSV files that open in Excel, Google Sheets or Numbers. There is one place to download everything at once, plus export buttons on the pages where you usually need a file. Exports stay in English on purpose, so accountants and spreadsheets can read them.

How do I download all my data at once?

Open Avatar menu → Settings → Export all data. Owners and managers can use it, and it is also in the Your data section of Avatar menu → Plan & billing:

1. Press Download all data (ZIP). The ZIP has one CSV file for each part below and a README. For a big business it can take a minute.
2. Or download one part on its own with the CSV or ZIP button next to it.

The parts are:

• Menu: menus, categories, items and prices, sizes, add-ons and outlet prices
• Orders & payments: every order, order item, payment, refund and kitchen ticket (refunds.csv has the amount, method, reason, reference, items and whether it came out of the cash drawer)
• Guests & loyalty: guest list with tags and blocks, and the loyalty points ledger
• Reservations & waitlist
• Cash drawer: drawer sessions (Z reports) and cash in / out
• Inventory: ingredients, stock levels, stock movements and recipes
• Offers & coupons with every redemption
• Campaigns and their recipients
• Feedback: ratings, comments and how they were resolved
• Staff & roles: team members, invites and what each role can do
• Shifts & attendance: roster shifts and clock-in / clock-out entries
• Tables & areas, QR codes (with scan counts), Printers, Settings
• Reports: daily sales, item sales, GST by month and by rate, busy hours and key numbers

Passwords, time clock PINs and access tokens are never included. The export covers every outlet you have access to. It keeps working after your plan ends, and after you cancel your data stays downloadable for 30 days.

How do I export just the menu?

In Menu & QR → Menu builder, click Export CSV and choose a menu or All menus. This file has the columns Import menu reads, so you can edit it in Excel and import it into a new menu or another account. See Export and re-import your menu (CSV).

How do I export orders?

• Growth → Analytics: choose the period (Today, 7 days, 30 days or 90 days) and press Export orders. The CSV has one row per order: number, outlet, time, type, source, table, guest, status, payment, subtotal, discounts, offers, points, delivery fee, packaging, service charge, whether the service charge was waived, tax, round off, tip, total and currency.
• The full backup (above) has orders plus order items, payments, refunds and kitchen tickets. Its orders file has a Service charge waived column too (Yes where staff removed the service charge from that bill).

Owners and managers can export orders. The file includes all outlets you can access.

How do I export my guest list?

Go to Growth → Guests, pick the group you want (for example returning guests or VIPs) and press Export CSV. The file has name, phone, email, visits, total spent, last visit, tags, allergies, birthday and whether they agreed to marketing. Guests is included in the Growth plan and above, and in the free trial.

Treat guest phone numbers carefully: never copy them into personal phones or groups. If a guest asks to be deleted, a manager uses Erase data on their profile. See Guests (CRM).

How do I download GST and Tally files?

Go to Back office → GST & accounts and choose the period.

• Download all (ZIP): every GST file for the period.
• A CSV button on each report: B2C (small) supplies (GSTR-1 Table 7), HSN summary, documents issued (Table 13), tax-rate summary, day-wise summary, payment-mode summary and the sales register.
• Reconciliation CSV: every bill checked line by line.
• Tally Prime import (XML): sales vouchers one per bill, or one per day per payment mode, and Ledger masters (import these first).

Set your Tally ledger names first in Settings → GST & accounts settings, which also has a Ledger masters download. See GST reports and Tally export.

How do I download payroll and tips files?

These are in the Team section (Growth plan and above), for owners and managers:

• Team → Attendance → Payroll CSV: one row per clock-in (date, staff, in, out, break, hours, late, overtime, rate, cost) and a total per person, for the period you choose. Clear every "check" badge and forgotten clock-out first.
• Team → Tips split → CSV: tips collected in the period, shared by hours worked or by position.

AirQR doesn't pay anyone; send these to your accountant or payroll provider. See Tips split and payroll.

Other downloads

• Campaign recipients: open a campaign in Growth → Campaigns and press CSV.
• QR codes: in Menu & QR → QR codes, download a code as PNG, or Download SVG (print shops) for professional printing.
• Cash drawer reports: X and Z reports can be printed from Cash drawer. See X and Z reports.

Troubleshooting exports

• I don't see the export button. Exports follow roles: orders and GST need owner or manager, the full backup needs an owner or manager (Settings → Export all data), payroll needs a manager or owner.
• I want to remove old or test data. Download a full export first, then the owner can use Settings → Clear data. See Clear data and delete an outlet.
• The file opens as one long column or odd characters. Open it with Excel's Data → From Text/CSV and choose UTF-8, or open it in Google Sheets.
• The orders file is missing an outlet. It includes only outlets you have access to. Ask the owner to give you access.
• The ZIP download takes long. Large businesses can take about a minute. Keep the page open.