Chart of accounts and how income ends up in the right place

Under Finance → Accounting, in the Setup tab, the Accounts part, you choose under VAT rules per sales type which account and VAT rate each sales type should be posted to, so that the income ends up in the right place without you having to correct it by hand afterwards.

The sales types

The setup has 21 rows: Court hire, Court in private lesson, Room rental, Courses and training, Private lessons, Punch cards, Membership, Tournaments, Events, Shop and equipment, Food and drink, Equipment rental, String service, Shipping, Locker rental, Locker rental deposit, Gift cards sold, Gift cards redeemed, Reminder fee, Discount codes and Other / default. If a row has no account, the sale ends up on Default sales account at the top of Default account and VAT. It does not fail, but it posts the revenue in one place. The button Fill in … rows from the chart of accounts fills only empty rows and does not touch accounts you have chosen yourself.

The default rates for a sports club

  • Court hire, membership, training, private lessons, tournaments and events are normally exempt from VAT
  • Equipment rental, string service and goods in the shop are normally 25%. Food and drink are normally 15%
  • The reminder fee is the club's income outside VAT, VAT code 6. The account in the default setup is a placeholder in the 3200 series. Agree the right account with the accountant
  • A gift card has no VAT when sold. It is not revenue, but a liability the club owes the customer until the card is redeemed. The redemption automatically inherits the account from the item or service paid for with the card

The account and the VAT code must match

General ledger accounts often have a locked VAT code. If you change the rate on a sales type, you will usually also have to change the account, in consultation with the accountant. If the club sells something at a different rate, such as groceries, the rate is set on the product itself rather than on the sales type, see VAT on goods, pickup and equipment rental.

Accounts for different VAT rates

Goods at 15% (food and drink) or 12% (passenger transport, accommodation) need their own account, because the account locks the VAT code. You choose them in the part Accounts for different VAT rates, which is shown when the club is connected. At 15% you can click Use the same as Food and drink.

The sales type Food and drink (kiosk) applies to kiosk items without their own rate. An item with 15% VAT is always posted to the account for 15%, not to the kiosk account. So set both if the kiosk sells items at 15%. If the field is empty and the club sells something at that rate, the sync stops on the order and tells you. It does not guess an account.

A private lesson becomes two lines

A private lesson is posted as two lines: the coach's part on Private lessons and the court part on Court in private lesson. If no account has been chosen for the court part, it uses the account for Court hire. Applies to both Tripletex and PowerOffice Go.

Settlement account per payment method

Vipps and Stripe pay out to the club at different intervals and often to different accounts. So set a separate settlement account per payment method if the club is to be able to reconcile against the bank, not just one common account for everything. If a payment method has no account of its own while the common account is set, the notice Common settlement account is at the top of Overview, with a link to Accounts. The sales have then been posted to the common account. On Home, 1 payment method is posted to the common account is under To do at checkout, even without PayPal POS. Choose a separate account under Finance → Accounting → Setup → Accounts, and the issue goes away. If Sales type Clubify does not recognise is on Finance → Accounting → Overview, the sales have been posted with the account and rate for Other. It is only information, and is not under To do at checkout. Clubify corrects it, and nothing is to be posted by hand. If Sales without a known amount in the accounts is on the same page, the accounting system has received the sale, but Clubify does not know which amount it was posted with, so the payment has not been settled against it. That is also only information: Clubify corrects it, and nothing is to be posted by hand.

Vipps entered at the checkout on the PayPal POS terminal has its own settlement account, Vipps at checkout, separate from Card at checkout and Vipps. The row appears when the club has such sales. A sale paid in several ways is posted with one settlement line per method. Vipps keeps the fee for the club's Vipps number in the settlement. With Post transaction fee on, Clubify posts it per sale, from the fee account against Vipps at checkout, so the account shows what Vipps pays out.

Sales paid with a gift card from PayPal POS have their own settlement account, Gift card at checkout, separate from Card at checkout. PayPal POS pays out nothing for them, so they are not part of the card payout.

Card at checkout has two more accounts: Fee account and Bank account, in the same card as the settlement account, under Card at checkout. Clubify suggests them from the chart of accounts. They are used when card sales at checkout are posted. Cash at checkout has its own cash account, typically the till account. It must be chosen: cash sales are never posted to the common settlement account, and are synced only once the account has been set.

If something goes wrong

If the settlement account for a payment method is missing, or the account for a different VAT rate the club sells with, the voucher stops until the account has been set. See when the sync fails.