7.1 Financial Ledger

Beacon's Financial Ledger is a collection of transactions showing all monies received or paid.  All transactions are associated with an Account. These can mirror bank account(s), PayPal accounts, Cash in hand or be transitory accounts to represent unbanked cheques and cash. Refer to section 7.10 for guidance on how to configure your Beacon Accounts.

All transactions are assigned to one or more Financial Categories in order to group together similar expenditure and income for analysis and reporting.

The Ledger may be displayed by Account, Category or Group by selecting the appropriate option on the Home Page. All options produce a similar listing. The Account, Category or Group is selected at the top of the page together with the Financial Year. By default, the current financial year is shown. The Ledger may be sorted by clicking any of the column headings that are in blue text.

Note: While any Transaction can be associated with a Group, the Transactions in the main ledger described below are completely separate to those in the individual Group Ledgers (see 5.5).

Ledger by Account
Click Ledger (by account) from the Home page and choose the Account and the Year to be viewed.

To download the Ledger in Excel or pdf format, click one of the buttons below the table (see the  example downloads at the bottom of this page).

 Click a Transaction number in the left column to view details of the Transaction.             

Ledger by Category
Click Ledger (by category) from the Home page and choose the Category and the Year to be viewed.

The operations available from this page are similar to those described above for Ledger by Account.

Ledger by Group
Click Ledger (by group) from the Home page and choose the Year to be viewed and the Group (or select all to see all Groups).

The operations available from this page are similar to those described above for Ledger by Account.

Updating the Brought Forward
When the financial year rolls over, a Brought Forward for each account is calculated automatically by Beacon. However, it may happen that by the end of a financial year not all of last year's transactions will have been entered, or it may be necessary subsequently to change one or more transactions.

To update the Brought Forward amount, press the Update B/F button at the top of the Ledger by account.

 Note 1: The Update B/F button is only present when the current year's ledger is displayed. It is not possible to change the brought forward to any year except the present. It is therefore important that the user does update the current year’s B/F before the financial year-end if changes have been made to last year’s data.

Note 2: The function operates only on the currently displayed account. To update other accounts, they must be displayed individually and updated.

Note 3: These are special Transaction Records, always dated the first day of the year in which they belong, and represent the amount brought forward in each Account from the previous year.

For each active Account, the B/F is automatically calculated at the start of the year, within the Rollover function. Note that the Rollover function does various jobs and runs once a day, currently during the first login of a user for the specific U3A.

Sometimes there may be changes required to the previous year's Account, either because some payments are entered into Beacon late or because errors need to be corrected. Beacon does NOT automatically recalculate this year’s B/F record when changes are made to last year’s transactions. Instead, a user may press Update B/F for this year’s B/F.

Transaction Records
Refer to section 7.2 for details of how to create and edit a Transaction.

Transferring Money
 Refer to section 7.3 for details of how to transfer money between Accounts.

Credit Batches
When several payments (cheques and cash) are paid into a bank at the same time, it is usual for a bank statement to record only the total amount, not each individual cheque. This can make it difficult to reconcile the statement against individual transactions.

Credit batches are a facility to make reconciliation simpler. All cheques and cash paid in at one time are each assigned to a credit batch and the batch will then appear in the reconciliation listing. When the bank statement entry is reconciled against the credit batch, the component transactions are reconciled automatically.

Refer to section 7.4 for further details.

Reconciling
Reconciliation is the process of ensuring that Beacon's ledger and your U3A’s bank statements are synchronised, enabling any discrepancies to be identified.

Refer to section 7.5 for further details.

Financial statement
Refer to section 7.6 for details of how to download a Financial Statement for any year or account.

Groups Statement
Refer to section 7.7 for details of how to view a summary of every Group's accounts (as held in the Group Ledgers, see 5.5).

Gift Aid
As registered charities, U3As are eligible to claim Gift Aid relief on membership subscriptions and donations. Refer to section 7.8 for further details.

PayPal
To accept payment online for members joining or renewing their membership, your U3A will need to set up its own PayPal account and register as a charity with PayPal.  Refer to section 7.9 for further details.

Example Excel Download 

 Example pdf Download

Revision History

v2	2021-04-23	Lyn Bossons	Merged KB 'Brought Forward' article at beginning