Exports for your accountant

Owners and admins: Reports → Accountant exports → Sales for Xero downloads the receipts of the dates you pick as a Xero sales invoice import, one row per receipt line, with the column names Xero expects.

1. In Xero, open Business › Invoices › Import.
2. Choose the file and pick “Amounts are tax inclusive”.
3. Check the draft invoices, then approve them.

Orders and fees go to account 200 (Sales). Gift cards sold go to account 835: add a gift card liability account with that code to your chart of accounts once.

Reports → VAT shows a calendar month’s sales by VAT rate: net, VAT and gross at each rate, with refunds taken off. Gift cards are kept apart, as they are outside the scope of VAT until they are spent. Each month has its own Xero file.

Reports → Instructor pay works out what each instructor is owed at the rates in force on each day: per class, per attendee (with any minimum), privates and duets. Download the totals or every class as CSV, or a PDF. It is a calculation only: nothing is paid out from Joul.