Daily report for the accountant
The daily report shows sales day by day, the way the accountant needs it for the day closing.
How to get it
- Go to Analytics in the side menu
- Choose a period at the top right, for example Yesterday or Last month
- Open the Reports tab
- Under Finance, click Generate on Daily report
- Click Download Excel or Download CSV
What a row shows
- Number of orders
- Gross: amount collected before refunds
- Refunded
- Net: gross minus refunded
- Card, Vipps, Payment link, Gift card, Punch card and Manually paid: net per payment method, so the columns add up to Net. Sales with invoice are in the column Invoice when there are any, whether the invoice was sent from the accounting system or from Clubify. PayPal POS, Cash and Terminal get their own column when there are sales with them
Days without sales are shown as 0. A day runs from midnight to midnight, and the order belongs to the day it was created.
Total
The last row in the file is called Total and has the sum of each column. Gross and Number of orders are equal to the report Total revenue over time for the same period. The Excel file also has the sheet Summary with club, period and breakdown.
Long periods
Over 366 days, only the days with sales are shown. The total still applies to the whole period.
Frequently asked questions
Why is a punch card order 0 kr? The punch was used when the customer booked, so the order has no kroner. It counts in Number of orders, but not in the amounts.
Why do the figures not match the payout from Stripe? The daily report shows sales, not payouts. The report Monthly closing shows the payouts.