Skip to content
Home » User Guide » Bank & Cash Accounts Overview

Bank & Cash Accounts Overview

Accounts

Accounts in Clubtreasurer are used to record and manage where your cash is physically held. Examples might include your financial institutions, such as your club’s bank accounts (current and savings), credit cards, building societies, etc. They can also be used to record general cash, petty cash, and float balances.

Clubtreasurer also allows you to use ‘special’ accounts to record monies due (‘debtors’), monies owed (‘creditors’), offset accounts (‘contra’) and long-term loans.

Most transactions that you record in Clubtreasurer will require you to select an appropriate Account.

Sections


Managing Accounts

There are two main pages you can use to view and edit Accounts and balances:

1. Accounts

  • Menu Path: Setup > Accounts (Financial Managers only)

The Accounts page displays a summary of all your Accounts and is where you view, edit and add new Accounts.

2. Account Balances

  • Menu Path: Accounts > Account Balances

The Account Balance page shows your Accounts and balances grouped in different categories. Finance managers can also add new Accounts and edit Account settings from this page.

  • Cash & Bank Account Balances region shows all your cash-based accounts. This region also shows reconciled and unreconciled balances.
  • Non-Cash Accounts Balances are all your debtor, creditor, contra and loan accounts.
  • Stock Account Balances shows your Stock Accounts and allows you to link to the Manage Stock Accounts page.
  • Total Account Balances shows the total net balance for all of your Accounts for the current Financial Year and all future-dated transactions, if any have been entered.

Creating New Accounts

You can create new Accounts from either the Accounts or Account Balances page. Only Finance Managers can create new Accounts.

  • Click the New Account button

Enter the following fields:

  • Account (required)
    • Enter a user-friendly name for this Account. This is what you will see in the Reports or when you select an Account to create a new transaction.
  • Status? (required)
    • New Accounts are always set as ACTIVE.
    • To close (disable) an Account select CLOSED from the drop-down list. This will prevent the Account from being selected for Receipts / Payments and Transfers.
    • You can only close an Account that has no (zero) current balance.
    • You can re-open an Account at any time by selecting the Active option.
  • Account Type(required)
    • Select an appropriate type from the options that best describes your Account:
      • CASH
      • CURRENT
      • CHECKING
      • ONLINE PAYMENT
      • SAVINGS
      • INVESTMENT
      • BLDG SOCIETY
      • CREDIT CARD
      • DEBTOR *
      • CREDITOR *
      • LONG-TERM LOAN **
    • Account Type is used to set certain parameters, such as enabling Financial Institution, allowing bank reconciliations, and also for displaying transactions (see Receipts and Payments)
    • * Use the DEBTORS and CREDITORS Account Types for creating additional accounts receivables and accounts payables Accounts.
      • Debtor accounts should have a positive balance
      • Creditor accounts should have a negative balance
    • **Use the LONG-TERM LOAN Account Type to record long-term loans, mortgages, debentures, etc. to be shown as long-term liabiilities on your balance sheet. See below
  • Allow Receipts?
    • Use this to control whether you want to allow Receipts to be entered against this account. Check the box to allow.
      • Not available for DEBTORS / CREDITORS Account Types.
  • Allow Payments?
    • Use this to control whether you want to allow Payments to be entered against this account. Check the box to allow.
      • Not available for DEBTORS / CREDITORS Account Types.
  • Allow Reconciliation?
    • Use this to control whether you want to perform bank reconciliations against this account. Check the box to allow.
    • You will probably want this for bank, building society and credit card accounts to reconcile your balances and transactions against statements.
    • Not available for CASH / DEBTORS / CREDITORS Account Types.
  • Financial Institution (CASH; BANK; INVESTMENT;BLDG SOCIETY; CREDIT CARD only)
    • Record the Bank, Building Society or other Institution Name for your Account
    • Note that Clubtreasurer does not need to hold account/sort-code numbers
  • Notes
    • Enter notes for this Account.
  • Opening Balance and Date
    • Record your opening balance value (default 0.00), and date using the calendar popup (default =  today).
    • Opening Balances and Funds: The opening balance amount is always recorded against your General Fund. You can allocate the opening balance to other Funds by creating a Fund Transfer transaction
  • Hide in Cash/Bank Charts
    • If you check this box the Account will not be shown in the Cash & Bank Account charts on the Home and Account Balances pages. This allows you to fine-tune these charts by excluding specific accounts, eg. Investment or Reserve accounts to just show liquid cash accounts. This does not effect to All Accounts charts.
  • Buttons:
    • Save
      • Click to save your new Account.


Editing Accounts

From the Account Balances page click the View/Edit <spyglass icon> to open the View Account page.

The View Account window will open and Finance Managers will be able to click the Edit button.

(The Accounts page will always open to the Edit Account window)

You can make changes to the following fields:

  • Account name (required)
  • Status? (Not editable when Main Account)
    • To close the Account select CLOSED from the drop-down list.
      • If you close an Account it will no longer selectable within transaction entry forms. Note that closing an Account does NOT delete or remove transactions.
      • You can only close an Account when the current balance is zero.
      • Your Main Account must always be active and cannot be changed.
    • In the main Accounts page you can toggle between Show Active / Show Closed / Show All view options:
  • Account Type (required)
  • Allow Receipts?
  • Allow Payment?
  • Allow Reconciliation?
  • Financial Institution (CASH; BANK; INVESTMENT;BLDG SOCIETY; CREDIT CARD only)
  • Opening Balance and Date:
    • The new opening balance date must be on or before the earliest transaction for this Account.
    • Note that Clubtreasurer locks transactions from earlier financial years to protect accidental changes. You may need to temporarily change your Financial Year-End (Setup>Organisation) to update Opening Balance details. (This is shown in the example)
  • Hide in Cash/Bank Charts?
  • Buttons:
    • Save Changes
      • Click to save your changes.
    • Set as Main Account
      • This button sets the Account as your Main Account. The Main Account will be the default Account used in most transaction forms.
      • You can only set as the Main Account if the Account:
        • Allows Receipts AND Payments
        • Status is Active
        • Is not a Debtor, Creditor, Contra or Long-term Loan account.
    • Delete
      • Deletes the Account and removes the Opening Balance transaction.
      • You cannot delete an Account that has any other transactions recorded against it (you should set the status as Closed, instead).

Special Account Types

Debtors and Creditors

Debtor and Creditor Account Types are used to create additional Accounts Receivables (Monies Owed to you) and Accounts Payables (Monies owed by you) accounts.

Editing on Debtor and Creditor Accounts is limited to changing the Account name, Opening Balance details and Notes.

Contra

The Contra Account can be used to offset income and expenditure from the same supplier if no monies were actually exchanged. For instance, you provide a free annual membership to one of your Members in lieu of chargeable services they have provided to your club. No monies will be received or paid in these transaction; however, you would record them as Receipts and Payments against the Contra Account.

Because you offset income and expenditure pairs, the Contra Account balance should always be zero.

You can only edit the Account name, Status and Notes:

Long-Term Loans

Use the Long-Term Loan Account Type to record large, capital loans that your organisation takes out. You will typically record interest payments and capital repayments for the loan – see below.


How to Manage Long-Term Loans

How to Record an EXISTING loan in Clubtreasurer:

  1. Create your new loan Account:
    • Name: “Mortgage‘ (or any name…)
    • Account Type: LONG-TERM LOAN – This will create the loan account as a long-term liability.
    • Opening Balance: enter opening loan amount as a Negative value if you are bringing an existing loan liability balance into your accounts – you should enter the outstanding loan balance as at the first day you start to record your accounts in Clubtreasurer.
  2. Record your interest payments as normal Payment transactions from the cash/bank account these are paid from. These will charge your P&L
  3. Record your capital repayments as an Account Transfer: FROM cash/bank A/c > TO your Mortgage Loan A/c. This will reduce your cash/bank A/c and Mortgage Loan liability A/c balance. The Loan A/c balance will show on the Balance Sheet under Long-Term Liabilities. Capital Repayments are not shown on the P&L.

How to Record a NEW loan in Clubtreasurer:

  1. Create your new loan Account:
    • Name: “Loan‘ (or any name)
    • Account Type: LONG-TERM LOAN
    • Opening Balance: £0  (see step 2)
  2. Record your initial loan receipt as an Account Transfer: FROM Loan A/c > TO your cash/bank A/c – this creates the opening loan balance and records the fund deposit into your bank A/c – this will show on the Balance Sheet under Long-Term Liabilities.
  3. Record your interest payments as normal Payment transactions from the cash/bank account these are paid from. These will charge your P&L
  4. Record your capital repayments as an Account Transfer: FROM cash/bank A/c > TO your Mortgage Loan A/c. This will reduce your cash/bank A/c and Mortgage Loan liability A/c balance. The Loan A/c balance will show on the Balance Sheet under Long-Term Liabilities. Capital Repayments are not shown on the P&L.