Import
Not available
This page is for managers. If you think you should have access, ask an admin.
← Back to portal
Weekly FareHarbor → Xero CSVs
Drop in this week's FareHarbor Sales export and the Payouts CSV. Everything is built right here in your browser — nothing is uploaded. FareHarbor payouts already reconciled in a previous week are skipped automatically.
All amounts are GST-inclusive — always choose “Tax Inclusive” when importing into Xero. Sales and refunds ship as one file: Xero turns the negative CN- rows into draft credit notes automatically.
Order matters: post drafts first and approve them in Xero — invoices are their own step so you can click, approve and email them without hunting through the sales — then import the payment CSVs so reconciliation has invoices to match against. When it's all in, hit Publish week — it saves the run to History and makes sure these payouts and school invoices are never generated again. (The zip still includes the invoice CSVs as a manual fallback.)
Preview
Product → GL code map
This is what turns each FareHarbor product into a Xero account code. New products that appear in a weekly export with no code are flagged before you can download — add them here and they'll map from then on.
| FareHarbor product | GL account |
|---|
School invoices
School breakdown is built into the Weekly CSVs tab — add the School Customers export (Customer type) as the third file. Bookings are matched by Booking ID: where the booking has a payment in the sales export (card, or an invoice/bank-transfer payment added in FareHarbor), that dollar amount is split into the school revenue lines. School bookings with no payment recorded yet are not invoiced — they show as “awaiting processing” until the payment is added in FareHarbor, then invoice in that week's run. Once a week is published, its school bookings are never invoiced again.
| Customer type / item | GL account |
|---|---|
| School Trail Pass / School Full Day Trail Pass | 4001.2 |
| School Ski Rentals | 4015.2 |
| School Full Day Snowshoe Rental | 4017 |
| School Lesson | 4020.2 |
| Snow Fun Zone (school students) | 4030 |
| Meadow Hut (schools) | 4036.2 |
| Musterers Hut (schools) | 4039.2 |
Mac Wednesdays and season passes are not schools — they stay as normal lines. Every download is logged to the audit trail (xero_config/audit/log).
History & audit trail
Every publish, download and P&L upload on this page, newest first. This log is append-only — nothing clears it; the “don't generate again” state (payouts & school invoices) simply rolls forward each time you publish.
Upload weekly P&L
Pick the Xero “Weekly Performance Profit and Loss” export for the week. You’ll see a full preview of the parsed numbers before anything is saved.