0 € para el club, de por vida, con acompañamiento personalizado para empezar. Reservar un horario

Hudlo
Volver al blog

Keeping a sports club's books without re-entering everything

Simon HueSimon HueCo-founder of Hudlo8 de septiembre de 20269 min de lecturaFinanzasArtículo en inglés
Keeping a sports club's books without re-entering everything

Sunday evening, you open the bank statement on one side and the club spreadsheet on the other. Line by line, you try to work out who that €85 transfer came from. Was this cheque for a membership or a jersey? And where did the insurance invoice go? The memberships, the shop and the spring training camp have already been paid once. You copy them out a second time, by hand. A new financial year starts, and the spreadsheet starts again from zero.

Para saber

In short

  • Most clubs keep cash-basis accounts: a dated list of what comes in and what goes out.
  • What takes time is re-entry: copying into a spreadsheet payments that were already collected somewhere else.
  • If memberships, the shop and ticketing go through the club's tool, they record themselves. You only enter insurance, federation fees, equipment, grants and sponsorship.
  • A category, a receipt and, when useful, an activity per entry are enough to produce the AGM accounts without a last-minute catch-up.

This article is about keeping the books through the year. The treasurer's role (budget, grants, mistakes to avoid) is covered in our sports club treasurer's guide. The figures to present at the general meeting are covered in preparing the AGM without a weekend of recounting.

What does keeping a club's books mean?

Keeping the books means recording every payment in and every payment out, in date order, with the document that proves it. This has a name: cash-basis accounting. The French government's associations portal, associations.gouv.fr, defines it as the chronological record of money received and money paid out. French association law (the 1901 Act) does not require any accounts as such. Your statutes, a grant or a commercial activity may require them, though. Outside France, check your own national rules.

It is the kind of accounts most clubs keep. It answers three questions: how much the club received, how much it spent, and what is left in each account. If your club works with an accountant, they remain responsible for the accounts.

Why the treasurer's spreadsheet eats so many evenings

The spreadsheet is not the problem. Re-entry is. In an endurance club, money comes in through five routes at once.

  • Memberships arrive by bank transfer, by cheque, in cash at the first training session.
  • The shop mixes jersey deposits, balances and swapped sizes.
  • Camps and dinners add their sign-ups and their cancellations.
  • Expenses have their invoices sitting in a committee member's inbox.
  • The bank statement shows labels that don't say who paid for what.

So every payment is recorded twice: once when it is collected, once in the spreadsheet. Each copy is a chance to make a mistake, and checking the statement mostly means hunting those mistakes down.

With Hudlo: you only enter what's left

The Treasury page brings all the club's money together. It is open to every club. Only the treasurer, the admins and the club manager can access it.

What records itself, and what you add

Your members' payments on Hudlo (memberships, shop, ticketing) are added automatically to the Entries tab, with a "Hudlo" badge. Clicking one of these rows opens its details: items, delivery, top-ups, refunds, and what goes to the club. You also get its PDF receipt there.

EntryHow it arrivesWhat you do
Membership, order or ticket paid by cardAutomatically, "Hudlo" badgeNothing
Membership or order paid by cheque or in cashUnder To do › Payments to collectMark received once you have the money
Insurance, affiliation, rentalTo enter, once+ Entry, then "Repeat"
Equipment, travel, race costsTo enter+ Entry with the receipt
Grant, sponsorship, donationTo enter+ Entry as income

Adding an entry takes three steps: income or expense, amount, category. Income shows in green with a "+", expenses in red with a "−".

Atención

Never enter a Hudlo payment twice. If a member hands you a cheque for their membership, don't add it with + Entry: confirm it under To do. Categories filled in by Hudlo are greyed out in the entry form anyway. For a membership fee collected outside Hudlo, before you joined for example, create your own category.

Categories and activities: what, and for whom

The category says what. Some categories are ready to use: Insurance, Federation licences and affiliation, Equipment, Travel and accommodation, Facility rental, Bank fees, Grants, Partnerships and sponsorship, Donations. You add your own in Settings.

The activity, which is optional, says for whom: a section, an activity or an event. A club with a trail section and a youth cycling school creates those two activities. You can rename this field (Section, Division, Project) in the settings. The Summary then shows the result of each one. You know whether the spring camp broke even without redoing the sums.

The receipt, at the time of entry

You attach the invoice or the till receipt to each expense, as a PDF or a photo. A photo of the receipt taken at the shop counter is enough. The "No receipt" filter and the Missing receipts section of the To do tab show what is missing. You chase the invoice in March, not the night before the AGM.

Recurring entries

Insurance, affiliation or the clubhouse rental come back every year or every quarter. Tick Repeat when you enter them. The next instalments arrive under To do, to confirm with the actual amount, which may vary. In the settings, you can edit a recurring entry (amount, label, frequency, end) or stop it.

Accounts and balances

The club has a bank account, often a cash box for the bar, sometimes a savings account. In the settings, enter the balance of each one on a given date, for example the first day of the financial year. Hudlo then works out the balances. You can add other bank accounts or another cash box.

When you pay the cash box takings into the bank, record a Transfer. A transfer between two club accounts is neither income nor an expense: it does not change the result.

Con Hudlo

Hudlo's Treasury picks up membership, shop and ticket payments on its own. You add the rest in three steps, with its category, its activity and its receipt. Recurring entries arrive under To do, and Hudlo works out your account balances. This is cash-basis accounting, the kind most clubs keep; your accountant, if you have one, remains responsible for the accounts. See the club management features

From day to day to the AGM: references, summary, exports

Each entry gets a reference: R-001 for income, D-001 for an expense. A deleted reference is never reused. The person checking the accounts can find every document with no gaps in the numbering.

The Summary tab shows the year's result, compared with the previous year, with the balances and a month-by-month chart. The Export menu produces the Year's ledger (CSV) for your accountant. It also offers the ledger as a PDF and the Year's receipts (ZIP). The AGM PDF button produces the financial report to put on screen. What these documents contain, and in what order to prepare them, is covered in our article on the AGM figures.

Once the accounts are approved at the AGM, close the financial year in the settings. Nothing can be added or changed in it after that. Only the club manager can reopen it. By default, the financial year follows the club's season; you can change its start month in the settings as long as no year has been closed.

What about the Hudlo fee in your accounts?

Treasurers ask this a lot. The answer depends on who pays it, and how.

  • Paid by card by the member: it goes straight to Hudlo. It does not appear in your treasury.
  • Collected by the club with a membership paid in cash or by cheque: that money belongs to Hudlo. It shows as "on behalf of Hudlo", outside your result. The amount owed appears under To do.
  • Covered by the club for its members: that payment is a real club expense, in the Hudlo membership fee category.

The full model (€0 for the club, a member subscription, optional cover by the club) is explained in club management software with no budget to vote at the AGM.

A cash book template

A sports association's cash book fits on one sheet, with one row per movement. The amounts below are examples.

DateRef.LabelCategoryActivityAccountIncomeExpenseReceipt
12/01D-001Club insuranceInsuranceBank640.00yes
15/01R-001Town council grantGrantsBank1,200.00yes
20/01D-002Trail race refreshmentsEvent costsTrailCash box85.40yes

This is the information each entry carries in Hudlo. With a tool that collects payments, you only write the rows that did not go through it.

Consejo

If you don't use a tool

  • Keep a fixed list of categories, written at the top of the file.
  • Number receipts when you enter them, never afterwards.
  • Once a month, compare the file's balance with the bank statement. Write down the difference, even when it is zero.
  • File receipts in a shared club folder, named by reference (D-001.pdf).

What changes for the treasurer

Checking the statement becomes a different job. You no longer copy out memberships, shop orders and camps: you check they have arrived. Your time goes on the week's few expenses and their receipts.

The end of the year changes too. The books are kept as you go, so the Summary is right on the day you open it. Donations that need a tax receipt follow the same path: see how to issue donation tax receipts in France without a Word template. To see the other modules of the management area, visit the club management page.


Further reading

  • #treasury
  • #cash book
  • #cash-basis accounting
  • #receipts
  • #treasurer
  • #sports association