Exports for your accountant
Download sales, payments, tax, refunds, expenses, credit, payables, stock value and a daily summary as CSV or Excel files, or everything at once in the Accountant pack.
Export turns your Reports into files for Excel, Google Sheets or your accountant: every sale, every refund, money in by payment method, tax, discounts, expenses, what customers owe, what you owe suppliers, the value of your stock and one line per day. The numbers are the same as Reports for the same period and shop.
Exports are for owners and managers.
#Make an export
When to use: at the end of a month, or whenever your accountant asks for the numbers.
- Open Reports.
- Tap Export at the top. On phones it is the download icon.
- Under Period, keep Same as Reports or choose This month, Last month, This year, Last year or Custom dates…. The exact dates show under it.
- If you have more than one shop, choose the Shop or All shops.
- Tick what you need under What to export. Each line says what is in the file.
- Tap Export. A bar shows how many records were read. Tap Cancel to stop.
- When it is ready you see the file name and size. On the web the file is in your browser's Downloads. On Windows, Android and iPhone tap Open or Share (email, Viber, Telegram, Drive…).
#CSV or Excel
- CSV: one simple table per file. It opens in Excel, Google Sheets and most accounting apps. Myanmar names show correctly in Excel.
- Excel: one
.xlsxfile. Each export is its own sheet, with dates as real dates and the top row fixed.
If you tick more than one export with CSV, you get one .zip file with a CSV for each, plus README.txt.
Column names are in English, because most accountants want that. Turn on Column names in Myanmar if you prefer. Names of items and customers always stay as you typed them.
#Accountant pack
The Accountant pack is one .zip file with everything:
- every export as a CSV file,
- one Excel file with a sheet for each export,
README.txtthat explains every file and column, and the period's totals (sales, tax, refunds, money collected, expenses).
- Open Reports → Export.
- Choose the period and shop.
- Tap Accountant pack.
#What is in each file
| File | One row per | Good to know |
|---|---|---|
| Sales (by receipt) | sale | Gross sales, discounts, tax, tips, shipping, total, how it was paid. Voided sales are not here. |
| Sales lines | item sold | Quantity (decimals for items sold by weight), price, discounts, cost. Digital items are included; codes never are. |
| Payments by method | payment method | Paid in, refunded, net (same as Reports → Sales), and debts customers paid back. On Credit is listed too. With several QR codes, each QR account gets its own row under QR Payment, debt payments included. Layaway payments (deposits) and Repair deposits have their own columns: money customers paid on layaways and repair jobs, minus money given back. They are customer deposits, not sales. |
| Tax | day | Tax charged, tax refunded and net tax. |
| Refunds | refund | Counted on the day of the refund, like Reports. |
| Voids | voided sale | Voided sales are not counted anywhere else. |
| Discounts | sale with a discount | Item, promotion, coupon, member and typed-in discounts. |
| Expenses | expense | Rent, salaries and other expenses. |
| Receivables: customer credit ledger | entry | What customers owe you: sold on credit, payments, refunds to the balance, changes by a manager; Receivable after each entry. |
| Payables: supplier ledger | entry | What you owe suppliers: purchases on credit, payments to suppliers, returns; Payable after each entry. |
| Supplier returns | item sent back | Returns to suppliers: quantity, cost, serials, reason and how the supplier settled it (credit, money back, replacement). |
| Inventory valuation | item in a shop | Stock when you export × cost (batch costs when you keep batches). |
| Cost of goods sold | item | The cost of what customers kept, like Reports → Profit. |
| Daily summary | day | Sales, refunds, net sales, tax, money collected, each payment method, credit given and collected, expenses. |
- Amounts are plain numbers with no thousands separators. The Currency column says the currency.
- Net sales = gross sales − discounts − refunds, without tax.
- Rows of the credit and payables ledgers that are not tied to one shop appear in every shop's export.
- Gift card codes and digital codes (game codes, accounts, top-ups) are never exported.
#Exports on each plan
| Free | Plus | Pro | Ultra | |
|---|---|---|---|---|
| CSV files | Last 90 days | Any period | Any period | Any period |
| Excel | – | Yes | Yes | Yes |
| Accountant pack | – | Yes | Yes | Yes |
| All shops together | – | – | Yes | Yes |
On Free, if you choose a longer period, the file starts 90 days ago and the panel says so. Tap See plans to compare. See Compare plans.