Mercato
Export for your accountant
Mercato → Payouts & payments → Export for your accountant. Choose the dates, then the file:
Watch the video
Customers, Discounts and Reports3:00 video| Xero sales invoices | For Xero's invoice import (Business → Invoices → Import). |
|---|---|
| QuickBooks Online invoices | For QuickBooks Online's invoice import (Settings → Import data → Invoices). |
| Payments and refunds | Every payment and refund in those dates, refunds as negative amounts, for matching against your bank and Stripe's payouts. A gift card spent is a payment from your gift card account. |
| Gift cards | Every gift card's movements in those dates: sold, issued by hand, spent, returned to the card, voided. |
The invoice files hold your sent invoices and paid orders (shipping as its own line), one row per line, and each adds up to its total to the cent. Quotes, drafts and void invoices are not sales and are left out. Each gift card sold is a document of its own (GC- and 8 characters) on your gift card account, with no tax: it is money owed until it is spent. See Gift cards.
Settings → Accounting export sets what the files carry: the Xero sales account code and tax types, the QuickBooks product or service name, the Xero gift card account and QuickBooks gift card product or service (map both to a liability account), and the date format.