Your accountant wants your numbers. With the accounting export you download your POS transactions in a format your accounting software can read, without retyping anything.
The accounting export is part of the Starter subscription and higher, and only an admin can download it.
Creating an export
-
Step 1: Choose the period
Go to Reporting in the sidebar and choose the period at the top: Today, Week, Month, Quarter, Year or your own from and to date. The export uses this period.
(Enlarge image) -
Step 2: Open the Export tab
Click the Export tab.
(Enlarge image) -
Step 3: Open the Format dropdown
Scroll to the Accounting Export block at the bottom and click Format.
(Enlarge image) -
Step 4: Choose your accounting software
Choose the format (see below for what each format contains).
(Enlarge image) -
Step 5: Choose the payment method and export
Under Payment Method, choose All methods, Cash only or Pin / Online (everything that isn't cash). Click Export Transactions for one line per transaction, or Export Monthly Summary for a summary per month. The file downloads right away.
(Enlarge image)
The formats
- Exact Online: a CSV with, per receipt line, the invoice number, the date, the client, the description, the amounts excl. and incl. VAT, the VAT percentage of that line and a ledger account (8100 for products, 8000 for services).
- Moneybird: a CSV with the columns Moneybird recognises (contact_name, reference, date, due_date, description, price, tax_rate_id), per receipt line, amount excl. VAT with the rate of the line.
- MT940: a bank statement (
.sta) that most Dutch accounting packages can read, with one line per receipt and an opening and closing balance. A refund is included as a debit. The monthly summary doesn't exist for MT940. - Generic CSV: one line per receipt with date, invoice number, client, description, amounts excl. and incl. VAT, tip, payment method and staff member. Works in any spreadsheet program.
The Monthly summary is a CSV with, per month, the revenue incl. VAT, the VAT amount, the revenue excl. VAT, the number of receipts and the average receipt value.
What's in the export
- Only paid POS receipts in the chosen period. An open payment link or a failed payment isn't included. Appointments that were never checked out in the POS aren't either.
- VAT per line: each receipt line with the rate that applied at checkout, so 9% for a treatment at 9% and 21% for a product at 21%.
- After discounts: a promotion, manual discount, redeemed loyalty points or package discount on the receipt is spread proportionally over the lines, just like on the VAT return tab.
- A settled deposit counts towards the revenue of the receipt. Only MT940 leaves it out: that's a bank statement and shows what was paid at the POS.
- A refund is included as a credit note with negative amounts.
- A tip has its own column in the generic CSV and falls outside revenue and VAT.
What if ...
... I don't see the Accounting Export block? Then the accounting export isn't part of your subscription. Upgrade to at least Starter via Subscription & billing.
... a staff member tries to download the export? Then Salonnare refuses: only an admin can do that.
... a client name starts with an = sign? Then the export puts an apostrophe in front of it, so Excel shows the name as text and doesn't run it as a formula.
Frequently asked questions
Which export is right for my VAT return?
For the return, use the VAT return tab in Reporting. The accounting export uses the same rates and discounts, but contains POS receipts and membership direct debits; the return also counts completed appointments that weren't checked out through the POS. Membership direct debits appear in the export as a Membership line. A refund appears as its own Membership (refunded) line with negative amounts, on the day of the refund.
I want revenue, clients or staff as separate reports.
Those are at the top of the same Export tab, as CSV or PDF. See Reports & Analytics.