Fund Manager User Guide 90010
User Manual:
Open the PDF directly: View PDF .
Page Count: 122
Download | |
Open PDF In Browser | View PDF |
Fund Manager User Guide Copyright © SF Software Limited t/a PEBBLE 2017. All Rights Reserved. The software described in this document is furnished under a license agreement or nondisclosure agreement. The software may be used or copied only in accordance with the terms of those agreements. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or any means electronic or mechanical, including photocopying and recording for any purpose other than the purchaser's personal use without the written permission of Pebble. Pebble, Media Exchange 3, Coquet Street, Newcastle, Tyne and Wear, NE1-2QB Tel: 0845 310 1788. Publication Number: 90308 Date of Issue: 13/09/18 Contents How to access Fund Manager 1 Logging in 1 Getting help on the screens 1 Configuring your browser for Fund Manager 3 Dashboard 5 Administration 7 Manage Names 9 Batch Actions 10 Group Actions 10 Create New Names/Organisations 11 Consolidating pupil names 12 Manage Accounts 14 To view and edit accounts 14 To edit account details 15 Batch Actions 17 Fund Manager User Guide Group Actions 18 To create a new account 18 Manage Bank Accounts 20 Period End options 24 View Opening Balances 24 Period End Closedown 25 Joinos options Create Joinos Codes Transactions Recording transactions 26 26 27 29 Receipts 30 Payments 34 Splitting receipts and payments 37 Making transfers 39 Between accounts 39 Between names 39 Cancelling and amending transactions 41 Importing transactions 41 Reports 43 Accounts Summary 43 Search Transactions 44 Search Account Balances 45 Lists 46 List Receipts by Receipt Number 46 List Payments By Cheque/Voucher Number 46 List All Transfers 46 Cancellations List of Cancellations Special Reports 47 47 47 Who’s Not Paid 47 Journal Reports 48 Gift Aid 48 New Claim for Donations 49 Claim History 50 Bank & Cash Reports 53 53 Bank & Cash Summary 53 Bank History 54 Cash History 54 List Reconciled Bank Accounts 54 Banking Actions Pay Receipts to Bank 54 54 Fund Manager User Guide Draw Cheque for Cash 55 Reconcile a Bank Statement 56 Transfers Transfer between Bank Accounts Cancellations 57 57 57 Cancel/Amend Bank Transaction 57 Unreconcile a Bank Statement 58 List Cancelled Bank Transactions 58 VAT 58 Generate VAT 100 59 Previous VAT 100 Submissions 59 Register 61 Prerequisites 62 Record Taken Items 62 Reports 63 Taken Items 64 Name Summary 64 Statement 65 Special 66 Universal Infant Free School Meals 66 Account Summary 68 Upload Register File 68 SIMs Software Integrations 69 Joinos 70 Create Offer v2 70 Create Offer 71 Active Offers 72 Pending Offers 73 Expired Offers 73 Documents 73 How to transfer Joinos payments so you can reconcile your bank statements 74 Messaging 76 ParentPay 77 Map Names 78 Accounts 78 Reports 80 Other 80 How to transfer money so you can reconcile your bank statements 80 sQuid 81 View Offers 82 Post New Offer 82 Map Offers to Accounts 83 Fund Manager User Guide Map Contacts 84 Pending Import 84 Where’s the money 86 Configuration 86 How to transfer sQuid payments money so you can reconcile your bank statements 88 When to contact us 89 Fund Manager Action Buttons 91 Glossary 95 Index 103 Chapter 1 How to access Fund Manager Logging in 1. Go to apps.mypebble.co.uk. 2. Enter the email and password from your welcome email. If you don’t have a password: l Click on the Forgotten Your Login Details link underneath the login button. l You’ll then be prompted for your email address; enter the email address you use to log onto Fund Manager and click Reset my Password. l You should then receive an email with a link to choose a new password. Note: When you set your password, please remember that it must have at least eight characters, including at least one letter, one number and one special character e.g. $, & Getting help on the screens You can use the screen help within Fund Manager to learn more about the screen and the fields on the screen. 1 Fund Manager User Guide To access this, click on the Help icon at the bottom right hand of the screen and then select View Help. This opens a panel of help on the screen which helps you with the activity you are doing on the screen. 2 Chapter 2 Configuring your browser for Fund Manager We recommend you use Google Chrome whilst using Fund Manager as this is the highest supported browser. You can, however, use latest versions of Internet Explorer or Mozilla Firefox. For configuration, please follow the steps below for the browser you are using. See Configuring Browsers - found on the Support site 3 Fund Manager User Guide 4 Chapter 3 Dashboard The Dashboard has been designed with a report function, showing a quick overview of your accounts and as a shortcut to the most frequently used menu options. You can navigate through the application by using the tabs at the top of the screen or by clicking on the quick link buttons. 5 Fund Manager User Guide Each section has a specific purpose. l The Transactions area identifies your Opening Balance as well as Transfers in and out, Receipts, Payments and the Balance of your Accounts. l The Bank and Cash area identifies your Cash and Cheques in Hand, your Bank Accounts and their Balances. It also identifies the Financial Period start date. l The Reports area offers you short cuts to Search Account Balances and Search Transactions. l The Organisation Summary displays the number of Accounts, Names, Transactions and Days in the Financial Period. l The Tabs at the top of the screen are the way in which you navigate to the different areas of the application. Each Tab reveals a list of menu items. 6 Chapter 4 Administration The Administration menu is where you complete setup, started before or during training. So although it is the last menu on Fund Manager, we will consider what is on it first. There are a number of records set up here: l Names l Accounts l Bank Accounts l Ledger Codes In addition this is where you have period end options: l View Opening Balances l Perform year end close-down If you use Joinos, you will also see the following options on the Administration menu: l Create Joinos Codes l Manage Connections 7 Fund Manager User Guide Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see Getting help on the screens. 8 Chapter 4 Administration Manage Names You can import pupil Names from your school administration database. The *MISAPP SIMS only feature is the automatic way to add an up-to-date file of pupil names with their year and registration group details and import them quickly into Fund Manager. If you have an integration with Fund Manager e.g. ParentPay or sQuid then we can import your names within the integration. More help and information on this can be found by contacting the Support Team. Note: Pebble Support generally does this for you as part of your initial setup. Each Pupil has their own entry within Fund Manager so you can register individual transactions against them. More options are available such as Staff, Contact details and Groups. Other names, including organisations etc., can be added as required using the Manage Names/Organisation option. You will need to refresh your pupil and staff information e.g. at the start of a new year or term or when pupils move from class to class or year to year. If you use MISapp or have an integration, pupils will automatically move from class to class, year to year once you refresh the data. New names for pupils or staff will appear ready for you to import into Fund Manager - don’t forget to archive old pupils and staff when they leave school via Administration > Manage Names > Batch Actions. If you are not using MISapp or a third party integration, you will need to update names manually, with an imported CSV file. Note: It is your responsibility to handle personal data in accordance with GDPR law. In Administration > Manage Names, use the Filter box at the top of the Manage Names screen to find quickly the Name/Group/Year/Class etc. you are looking for. 9 Fund Manager User Guide Batch Actions The options in these sections can be applied to more than one name at a time. Once a name is no longer required you can mark it Out of Use. Select the box next to the name and then select Out of Use. You can return a name to ‘in use’ by clicking Show out of use. You will now see ‘out of use’ names; they will appear in grey. Select the name(s) and then select In Use in Batch Actions. Refresh the page by clicking Administration > Manage Names for the Name(s) to be returned to ‘In Use’. Group Actions Pupils are already usually imported by Class, Year or Registration group or create your own pupil group (User Defined) for your Fund Manager names, e.g. trips, off site, overseas, sixth form, etc. You can also set up groups for different groups of pupils e.g. universal infant free school meals, pupil premium, etc. Together with the filter options throughout Fund Manager, groups assist you in selecting names quickly when you want to assign transactions to the names in the group or include the names in the group within reports, such as the Who’s Not Paid report. Note: Names can be assigned to more than one group, so you can design the groups to make your workday easier. 10 Chapter 4 Administration Once you have created the groups you want to use, you assign names to the groups. This includes the names in the group and you can then apply various actions to the groups. l Open Administration > Manage Names. Create New Names/Organisations We would always suggest that you Import your pupil names from your administration database; this should avoid duplication. The *MISAPP feature is the automatic way to add an up to date file of pupil names with their year and registration group details and import them quickly into Fund Manager more help and information on this can be found by contacting the Support Team. Names can be added on an ad-hoc basis for pupils, staff and parents. Choose the entry (Create New Pupil) and enter the correct Title/Name and complete the fields below with any additional information you require. l In Use means that the record is on roll and actively in use. l Gift Aid means that the parent or other adult is a tax payer. Selecting this flag will mark the pupil for gift aid donation on the Names list and help you search on Gift Aid donors. However, in order to claim gift aid and complete the tax refund form for Registered Charities, you must fill in the gift aid donor details on the pupil details. Once you have created the pupil record, update the pupil details and select the Gift Aid tab for the pupil. There, enter the gift aid donor details (Title, First name, Last name, Address line and Postcode). 11 Fund Manager User Guide Note: You can copy in the gift aid donor information from the parent / guardian contact details you have on record. You may need to amend the copied details if they are incomplete. Tip: If you update Gift Aid Donor details for a transaction that falls in a closed period it is automatically included in the next submission. Note: Don’t forget to archive old pupils and staff when they leave school via Administration > Manage Names > Batch Actions. New organisations can be created and only need creating once, using Create New Organisation. Input the organisation’s name, you do not have to enter any other details unless you want to. Once you have filled in all the information you require click Save. Consolidating pupil names If you have duplicate pupil names you can consolidate these into one and merge the associated contact details, transactions and taken items. 1. On the Manage Names screen, click the pupil Name you want to use as the Primary Record. This opens the pupil Details screen. 2. On the Details screen, select the Consolidate Pupil tab. 3. Select the pupil in the list of names as the Secondary Record which you want to merge in with the Primary Record. 4. Click Preview Consolidation. l Check the details of the consolidation. These include Receipts, Payments, Transfers, Taken Items, Phone Numbers, Addresses, Email Addresses, Joinos Codes and sQuid Cards depending on what information is associated to each contact. 5. If you are sure you are merging the correct records, click Confirm. 12 Chapter 4 Administration 6. Because you can’t retrieve the two separate records once you complete this process, you must click Consolidate Names at the prompt to confirm that this is really what you want to do. After clicking Consolidate Names, receipts, payments, transfers and taken items transferred from the Secondary Records will now be reported as belonging to the consolidated Primary Record and the Secondary Record will be marked Out of Use. 13 Fund Manager User Guide Manage Accounts An Account (sometimes known as a cost centre) is equivalent to an individual column header in a manual ledger. Accounts can be created at any time. There is no effective limit to the number of Accounts you may have, but each one must have its own unique Code. The Account Code is a combination of between 1 and 6 letters and/or numbers. Once saved, a code and an account name can be edited but can never be deleted; instead Accounts are taken Out of Use when you have no further need of them. This prevents them from appearing on the transaction screens. They may continue to appear on the report screens if they have a balance which is relevant to the open financial period. The accounts in the group will be reported individually and with a subtotal. Note: When accounts are listed in Fund Manager, they are presented in Account Code order; numbers first and then alphabetically. To view and edit accounts 1. Open Dashboard (Organisation Summary) > Manage Accounts OR Open Administration> Manage Accounts. 2. By clicking on any of the Account names you can then edit the account 14 Chapter 4 Administration details. To edit account details 1. The unique Account Code. 2. Enter the Account Name. 3. In Use is selected by default and this means that you can select the account on the system. 4. Joinos for Parents only: If you want to share the balance through Joinos so parents can see what’s left to pay on an offer, select Share Balances. Note: You will need to create the offer as usual within Joinos, using Joinos > Create Offer, then select the Unspecified check box and enter the minimum amount you would like parents to pay, complete the offer with the relevant attachments, add names to the offer and then post to make it visible to parents. Once a parent has paid the deposit, they will be able to see what they have left to pay, via the Balances tab in Joinos. 5. Register only: If you want to register pupil attendance and take-up of meals, using the Register tab within Fund Manager, then select Register Account. 15 Fund Manager User Guide 1. Select an Exclusion Group for the account. Note: You must select an Exclusion Group even if you don’t have any pupils assigned to it. 2. If you have an Android Tablet you have purchased direct from Pebble, and you want to view and record attendance on this, select Display on Device. Note: If you have any other Tablet, you must check with Pebble Support for its compatibility. 6. If required, you can amend the account Opening Balance (the amount of money the account owned or owed on the date the account was created) although we do not recommend this. For example, if you have discovered that your user accounts and bank accounts don’t balance, and have identified the reason why you can increase or decrease the user account opening balance so that the user accounts and bank accounts balance correctly. Note: Don’t use this option as a short-cut to entering a transaction on the system to get your accounts to balance. Entering a transaction either anew if you had not entered it before, or as a contra-entry to cancel a mistaken entry - is the best way to get your accounts to balance as this provides traceability when you come to audit your accounts. Warning! If you amend the user account opening balance so that your user accounts and bank accounts don’t balance you will not be able to complete your period end close-down. If you need to amend the opening balance, click Amend Opening Balance. To increase or decrease the opening balance: 16 Chapter 4 Administration 1. Select Increase or Decrease. 2. Enter the value by which you want to increase or decrease the opening balance. For example, to increase by £10, enter 10.00 in the balance by box; to decrease by £25.30, enter 25.30 in the balance by box. 3. Click Set Opening Balance Change. 7. Enter a Budget value for the account, if required. A negative value indicates an expected level of expenditure or loss. A positive value indicates an expected level of income or profit. This might be useful for budget holders to know their budget position by simply looking in Fund Manager for the funds that remain available. 8. If you want to use the report, Who’s not paid, enter a Unit Cost (cost per pupil head). Note: If you don’t use a unit cost then the Who’s Not Paid report won’t generate any details for you to view. 9. If required, select which Groups the account Belongs to by clicking the group name in the left-hand window. Or if you need to create a new group, enter the name in the New Group field. 10. Click Save. Batch Actions The options in these sections can be applied to more than one account at a time. Once an account is no longer required for daily use you can mark it Out of Use. Select the box next to the Account then select Out of Use. If you need to report on an archived account simply click Show Out of Use. You will now see archived Accounts – they will appear in grey. To mark an account in use again, select the box next to the Account then select In Use in the Batch Actions section, Click the Update Account(s) button for the Account. 17 Fund Manager User Guide Then click the Hide out of use button again to return. Group Actions You can create your own account groups for your Fund Manager accounts, e.g. trips, off site, overseas, sixth form, etc. Together with the filter options throughout Fund Manager, groups assist you in selecting accounts quickly within reports. Note: Accounts can be assigned to more than one group, so you can design the groups to make your workday easier. Once you have created the groups you want to use, you assign accounts to the groups. This includes the accounts in the group and you can then apply various actions to the groups. l Open Administration > Manage Accounts. To create a new account To create a new account to pay receipts to and make payments from: 18 Chapter 4 Administration l Click Administration > Manage Accounts > Create New Account. 19 Fund Manager User Guide Manage Bank Accounts A Bank Account can be any account held with a bank that is used for the purposes of managing your Fund, eg current account, Savings accounts etc. Many schools operate with a single Bank Account for their School Fund. The system comes with one such Account already defined. This is called 'Current Account' but you may edit this Bank Name if you wish. Click the Current Account Name and then overtype the Name 'Current Account' with whatever you want your Bank Account to be called. If you have more than one Bank Account you may create additional accounts by clicking Create Bank Account. You will need to add a unique Code and Name. However the name of the Default Account cannot be changed from code CURR (nor can it be archived). The Name normally includes the name of the bank itself and the type of account. This information can be edited when necessary. 20 Chapter 4 Administration You can set an Opening Balance for a Bank Account. This is the value of the Reconciled Bank Balance at the date on which you are creating the account. In Use Bank Accounts can be taken Out of Use when you have no further need of them, by ticking the box 'Out of Use’ and then saving. Settlement Account This is a very particular type of Bank Account that is used for electronic transactions. If your parents are paying for items by logging into a payment portal and using Debit and Credit cards, these electronic transactions are handled using a settlement Bank Account. Default Account You can also mark an Account as your Default Account in this screen, i.e. the Account you use most frequently eg the CURR – Current Account. 21 Fund Manager User Guide Ledger Codes The Ledger Codes option is available for providing exports into other finance packages to allow you to continue providing unified reports (eg VAT reporting), whilst gaining the benefits of Fund Manager's superior transaction entry. Set up your ledger codes in Fund Manager to match the Ledger codes in your external finance package. Then you can assign debit and credit entries to the correct ledgers to make accounting easier (e.g. grouping all trip transactions etc). There are two types of Ledger Code: Ledger Code This is used to group transactions for a particular purpose. Bank Ledger Code This is used to match the bank in Fund Manager to the bank code in an external financial system. The codes can be Alphanumeric, up to 20 characters. If you integrate with an external accounting package for reporting purposes, set up the codes in Fund Manager that match the same codes in the external system you are integrating with. This ensures that the transaction appears in the external ledger that you want it to, making it easy for you to identify and track the transactions or if a bank ledger code that the transactions are posted to the expected banks in both systems. To create a Ledger code 1. Open Administration > Manage Ledger Codes. 2. Click New Ledger Code. 3. Enter the Code and the Name. 22 Chapter 4 Administration Note: The VAT and Cash in Hand ledger codes are set up in Fund Manager by default and you can’t amend the name of these codes. 4. Select In use if you want to be able to select the code for transactions. Note: It doesn’t apply to the VAT or Cash in Hand codes. 5. Click Save. To create a bank ledger code 1. Open Administration > Manage Ledger Codes. 2. Click New Bank Ledger Code. 3. Enter the Code and select the Bank account. Note: You can only select a bank account that has already been created using Administration > Manage Bank Accounts. 4. Click Save. 23 Fund Manager User Guide Period End options View Opening Balances The Opening Balances of your accounts and bank accounts are usually entered by Pebble Support when you first begin using Fund Manager. If you create additional accounts or bank accounts, you can set up their opening balances using Administration > Manage Accounts and Administration > Manage Bank Accounts. You can see all of your accounts and their balances using Administration > View Opening Balances. Bank Account opening balances are shown in the left column while Account opening balances are shown in the right column. The totals of the two columns should always match. The Difference should always be 0.00. These will also be the Opening Balances for the new financial year following a Period End Close-down. Once the end date for your financial period has passed you can perform a Period End Closedown in Fund Manager that will draw a line under your transactions and allow you to produce the necessary reports to submit to your auditor once you have reconciled all your bank accounts. During the Period End Closedown, Fund Manager will automatically carry forward your account closing balances and present them as the opening balances in the next period. 24 Chapter 4 Administration Period End Closedown Note: You do not have to stop entering transactions in your new financial year. You can close down any time after your year end date. You will need to close down Fund Manager after period end. When you confirm all transactions for the period, these become locked and Fund Manager will automatically carry forward your account closing balances and present them as the opening balance in the next period. Closedown is something that many people find difficult. Because of this we have created a guide to take you through this step-by-step. For more information, see Period End Closedown Your Financial Year End Guide 25 Fund Manager User Guide Joinos options Joinos is Pebble’s platform for helping you and the parents of your pupils communicate, pay for trips, school activities and meals. Although there are two options in the Administration menu, both of these options open the four tabs which enable you to manage the creation and issue of Joinos codes and letters and the contacts for pupils. These tabs are: l Create Joinos Codes. l Joinos Codes. l Manage Connections. l Joinos Letters. There are also Joinos options on the Joinos menu. For more information, see the section on Joinos in SIMs Software Integrations on page 69. Create Joinos Codes You use this screen to select students and staff who are waiting to be registered on Joinos and create Joinos codes for them. Joinos codes are used by parents to access Joinos and pay for trips and activitites for their child. 1. Open Administration > Create Joinos Codes. 2. Select the pupils to generate Joinos codes for. 3. Click Create Joinos Codes. The codes are displaed on the Joinos Codes tab. Note: Joinos codes expire if they aren’t used within three months by the parents/carers to register the child on Joinos. In that case you will need to issue a new Joinos code. To do this, use the procedure above, but before selecting pupils to recreate codes for, click Show Registered. 26 Chapter 5 Transactions Transactions represent the flow of money through Fund Manager. These are either Receipts (money is received) or Payments (money is paid out). Transactions are processed as follows within Fund Manager. Activity Where in Fund Manager Recording transactions Transactions > Enter a Receipt Transactions > Record a Payment Recording money received Bank & Cash > Pay Receipts to Bank as paid into the bank Reconciling transactions Bank & Cash > Reconcile a Bank Statement Closing the financial year Administration > Period End Closedown Some of the processing activities cross into the other menus and those will be covered in the relevant chapters. This chapter focuses on the options on the Transactions menu: l Recording transactions (receipts in and payments out). l Making transfers (between accounts or names). 27 Fund Manager User Guide l Cancelling and amending unreconciled transactions. l Importing transactions. Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see How to access Fund Manager. 28 Chapter 5 Transactions Recording transactions By default receipts are displayed on a green background and payments on a red background. Note: To be able to save receipts and payments you must select an Account, enter a Description and Amount and select a Name. 29 Fund Manager User Guide Receipts Use the field descriptions to help you complete the transaction entry. Receipt Field Description Account The account the cash/cheque or credit is being paid into. Click the arrow on the Select Account box to select the account from the drop-down list or enter the Account Code to the left of this. Tip: When you select an account, the View Transactions 30 Chapter 5 Transactions Receipt Field Description tab appears for the account and you can click that to view all the transactions that have been posted for the account to date. Ledger The Ledger code (if required) you want to assign the transaction to. You can select the code from the drop-down list of available codes. Ledger codes are set up within Administration. These codes allow you to continue providing unified reports (e.g. VAT reporting) when you integrate with external financial systems. Setting up and assigning the ledger code which matches the ledger code in your external system ensures that your transactions will fall in the correct ledger for reporting. Manage A short-cut to the Administration > Manage Accounts screen. Accounts Description A description (up to 81 characters) for the receipt. This should be something which makes it easy to identify, for example Trip to Isle of Man, Donation from Alumni Joe Bloggs, Unreconciled transaction receipt from previous system, etc. Tip: If required, enter more information about the receipt in the Notes box. Type The type of receipt you are entering. This can be Cash, Cheque, Direct Credit or ePayment (receipt). Bank and If Type is Direct Credit or ePayment, select the Bank to which Balance the receipt has been given from the Bank drop-down list. The balance of the bank account is displayed automatically in the Balance field once you select the bank account. 31 Fund Manager User Guide Receipt Field Description Gift Aid Indicates whether the receipt is eligible for gift aid. Selected means that it is eligible. Clear indicates it is not. Note: To be eligible, your organisation must be a charity, or have charitable status and the person making the payment must be a UK taxpayer. For more information, see HMRC requirements for claiming gift aid. Tip: If you update Gift Aid Donor details for a transaction that falls in a closed period it is automatically included in the next submission. Notes Notes (up to 81 characters)about the receipt. This is an optional field and can be used in addition to the Description if more information needs to be recorded. VAT Code The VAT rate for the transaction. You can select from a number of pre-defined VAT rates as follows: Zero(0%), Standard (20%), Reduced (5%), Exempt (0%), Outside scope (0%), or Custom (which you define yourself). For guidance on VAT rates, see the HMRC guidance - VAT rates on different goods and services. VAT Rate Only applicable if you select Custom for the VAT Code. Enter the % VAT rate to apply. Reference A reference you enter which helps you to identify or trace the receipt. The reference is optional as you will always be given an automatically generated Receipt No when you save the transaction. 32 Chapter 5 Transactions Receipt Field Description Tip: This is a useful place to record an invoice number. Date The date the transaction takes place for VAT purposes. The transaction date defaults to today’s date but you can amend this, if required. For example, you can enter the date of receipt as the date on a cheque, or the date of the direct credit. Amount The gross amount of the transaction or the individual Amount to bulk input. Receipt No The number which is automatically generated within Fund Manager for the receipt you are entering. You can’t change this number when you create the receipt, although you can change it later if you amend the receipt. Names Pupil and other names i.e. suppliers and/or staff, are displayed for you to record your receipt against. Name Filter Enter a character or characters in the name/class/year/group you want to find and the list of displayed names adjusts accordingly to show a shorter list to choose the name from. Note: The filter works by displaying all names which contain the character or characters you have entered. Manage A short-cut to the Administration > Manage Names screen. Names 33 Fund Manager User Guide Payments Use the field descriptions to help you complete the transaction entry. Payment Field Account Description The account the cash/cheque or debit is being paid out of. Click the arrow on the Select Account box to select the account from the drop-down list or enter the Account Code to the left of this. 34 Chapter 5 Transactions Payment Field Description Tip: When you select an account, the View Transactions tab appears for the account and you can click that to view all the transactions that have been posted for the account to date. Ledger The Ledger code (if required) you want to assign the transaction to. You can select the code from the drop-down list of available codes. Ledger codes are set up within Administration. These codes allow you to continue providing unified reports (e.g. VAT reporting) when you integrate with external financial systems. Setting up and assigning the ledger code which matches the ledger code in your external system ensures that your transactions will fall in the correct ledger for reporting. Manage A short-cut to the Administration > Manage Accounts screen. Accounts Description A description (up to 81 characters) for the receipt. This should be something which makes it easy to identify, for example Trip to Isle of Man, Unreconciled transaction receipt from previous system, etc. Tip: If required, enter more information about the receipt in the Notes box. Type The type of payment you are recording. This can be Cash, Cheque, Direct Debit or ePayment (payment). Bank and If Type is Cheque, Direct Debit or ePayment, select the Bank Balance from which payment has been made from the Bank drop-down 35 Fund Manager User Guide Payment Field Description list. The balance of the bank account is displayed automatically in the Balance field once you select the bank account. Notes Notes (up to 81 characters)about the payment. This is an optional field and can be used in addition to the Description if more information needs to be recorded. VAT Code The VAT rate for the transaction. You can select from a number of pre-defined VAT rates as follows: Zero(0%), Standard (20%), Reduced (5%), Exempt (0%), Outside scope (0%), or Custom (which you define yourself). For guidance on VAT rates, see the HMRC guidance - VAT rates on different goods and services. VAT Rate Only applicable if you select Custom for the VAT Code. Enter the % VAT rate to apply. Reference A reference you enter which helps you to identify or trace the payment. The reference is optional as you will always be given an automatically generated Chq/Vouch No when you save the transaction. Tip: This is a useful place to record an invoice number. Date The date the transaction takes place for VAT purposes. The transaction date defaults to today’s date but you can amend this, if required. For example, you can enter the date of payment as the date on a cheque, or the date of the direct 36 Chapter 5 Transactions Payment Field Description debit. Amount The gross amount of the transaction or the individual Amount to bulk input. Chq/Vouch The number which is automatically generated within Fund No Manager for the payment you are entering against a particular Bank Account or Cash Transaction. You can change this number when you create the payment and you can change it later if you amend the payment. Names Pupil and other names i.e. suppliers and/or staff, are displayed for you to record your payment against. Name Filter Enter a character or characters in the name/class/year/group you want to find and the list of displayed names adjusts accordingly to show a shorter list to choose the name from. Note: The filter works by displaying all names which contain the character or characters you have entered. Manage A short-cut to the Administration > Manage Names screen. Names Splitting receipts and payments You can split a receipt or payment across any number of accounts and a receipt across any number of names. This is useful, for example, if you have received money from a parent for two children at the same school who are going on different trips. When you click Save on the transaction, if the transaction Type is Cheque or Direct Credit for Receipts or Cheque or Direct Debit for Payments, then a yellow bar appears at the top of the window. For example: 37 Fund Manager User Guide 1. Click split this Receipt or split this Payment. 2. Select the Account over which the Amount is being split. 3. If a Receipt, select the Name the Amount is to be recorded against. 4. Enter the Amount you want to split from the original Receipt or Payment. 5. Click Split Receipt or Split Payment - to split further if required. 6. Continue splitting until the Balance is shown as Zero. Note: You must always Split Receipt or Split Payment before you click Finished. 7. Click Finished to complete the split. 38 Chapter 5 Transactions Making transfers You can transfer amounts between accounts or between names. Between accounts The most common transfer is between accounts without reference to names. For example, if you have a general or miscellaneous account, you might want to transfer underspend from a visit or trip to this account. 1. Open Transactions > Transfer Between User Accounts. 2. Select the Transfer From account. 3. Select the Transfer To account. 4. Enter the Amount that you want to transfer. 5. Enter the Date of the transfer. 6. Enter the reason for the transfer in the Notes field. 7. Click Transfer. Transferring a negative balance You can only transfer positive balances, so if you want to transfer the negative amount in one account to another, do it the other way around, as follows:. 1. Select the account you want to transfer the negative balance to in the Transfer From field. 2. Select the account you want to transfer the negative amount from, in the Transfer To field. 3. Enter the amount you want to transfer as a positive amount. Between names Transfer between accounts and/or two different names. 1. Open Transactions > Transfer Between Names. 2. Select the Account From. 3. Select the Name From. 4. Select the Account To. 39 Fund Manager User Guide 5. Select the Name To. 6. Enter the Amount that you want to transfer. 7. Enter the Date of the transfer. 8. Enter the reason for the transfer in the Notes field. 9. Click Transfer. 40 Chapter 5 Transactions Cancelling and amending transactions You can’t amend transactions using Transactions > Amend Receipt or Payment Transaction or cancel transactions using Transactions > Cancel Receipt or Payment Transaction if the transactions have been: l Included in a VAT 100 Report l Included in a reconciled or part-reconciled statement l Left unreconciled from a previous closed period If you need to cancel a transaction that falls in one of these categories, you can do this by entering a contra-entry transaction which has the effect of cancelling the original transaction. You can then net these transactions off your next reconciliation. Note: If you are cancelling, do not cancel the original cheque receipt or alter the original paying-in slip. 1. Select the relevant Receipts or Payments. 2. Click Continue. 3. Type in a Reason for Cancellation. 4. Click Cancel Transactions. Importing transactions You can import transactions from CSV files using Transactions > Import Transactions. This is a manual way of bringing in transactions and particularly useful if you use Fund Manager alongside SchoolComms, SchoolMoney or ParentMail. Create the CSV file from within those programs and then import it into Fund Manager, using Transactions > Import Transactions. Note: It is your responsibility to handle personal data in accordance with GDPR law. 41 Fund Manager User Guide If you use ParentPay, sQuid or Joinos alongside Fund Manager you can set up an automatic import of transactions, using the integrated SIMs menu options for each platform. For more information, see SIMs Software Integrations on page 69 42 Chapter 6 Reports Reports provide a useful way of tracking what is happening in your accounts throughout the year. They are also essential at Year End when you need to submit the accounts for the year to your auditors. All of reports you need to produce for the auditors are described in the Fund Manager Year End Guide. Below is a summary of the reports accessible from the Reports menu. Note: There are also some reports available from the Bank & Cash menu. Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see How to access Fund Manager. Accounts Summary This lists the current balance of all your accounts. You can click any of the account Codes to view transactions associated with that individual account. You can also Include Transfers and Include Out of Use accounts in the report. There is also a quick link to the Search Account Balances report at the bottom as well as the option to Print or Export CSV so you can open the report in Excel. 43 Fund Manager User Guide Note: The account balance amount you see in Accounts Summary may be different from that in Search Transactions. In the Accounts Summary report, transfer values are excluded by default although you can choose to include these when you run the report. If you include them, the values are added to the receipts and payments totals. Search Transactions This is the screen on which you can see all the details you added when entering your transactions, including Description, Notes and Reference. The total of all the displayed transactions in the summary bar is labelled Total. However this is the total of the transactions in the filtered list and is not a balance. There are no balances on the Search Transactions report because it is a list of transactions within an Account. You can find the Account details in either Account Summary or Search Account Balances. If you want to see all transactions in your system, make no changes to the fields that are presented and click on the Search button. If you want to see a filtered list, use the filter fields to select a single account or a group of accounts. If you select a single account, the Search Transactions report will display the same values and balances as the Accounts Summary report, however here the transfer values are included by default. On the Search Transactions report transfer values are specifically identified as transfers and are not added to the receipts and payments totals. The Search Transactions report is particularly useful for finding and viewing different types of transactions, for example, transactions which have VAT included or those which you have imported using Transactions > Import Transactions. To filter by Aggregated Name, just filter for ‘By Name’ in the Aggregate Box. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. 44 Chapter 6 Reports Note: It is your responsibility to handle personal data in accordance with GDPR law. The account balance amount you see in Search Transactions may be different from the Accounts Summary report as this report only displays the receipts in, payments out and balances of such from your current financial year. In the Accounts Summary report , transfer values are excluded by default although you can choose to include these when you run the report. If you include them, the values are added to the receipts and payments totals. In the Search Transactions report, transfer values are included by default but are not added to the receipts and payments totals as they are specifically identified as transfers. Search Account Balances This report is comprehensive and allows you the greatest flexibility in searching your accounts. It is often used to determine which accounts are to be closed and which are to be retained with their balance into the next financial period. Note: When you come to do your year end, if you have outstanding balances in out-of-use accounts, you may transfer these balances to an account which is in use, preferably a year end closing account, so it will be easier for you to identify this pot of money. If you don’t want to do this then you must select Include Out of Use on the report so that your overall year end figures will show your true balance for the year. If you are unsure what to do with balances at year end then we would recommend that you seek audit advice from whomever audits your accounts. You should also select Include Transfers to show internal movement of funds. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. 45 Fund Manager User Guide Lists List Receipts by Receipt Number Use this report on the Reports menu to list all receipt transactions within the current financial period and to reprint receipts that have already been entered if required. You can use the filter fields to include or exclude transaction types, or shorten the list of receipts by changing the From and To receipt number range. There is the option to Print or Reprint Receipts at the bottom of the screen. Fund Manager will print these receipts on A4 paper or on a receipt printer if you have one. List Payments By Cheque/Voucher Number Use this report on the Reports menu to list payment transactions within the current financial period and to reprint payments that have already been entered. You can use the filter fields to include or exclude cheque or cash transactions or shorten the list of payments by changing the From and To cheque or cash number range. There is the option to Print at the bottom of the screen. Note: If more than one payment is shown then this option will print the results as a table which does not have individual signature boxes. If you want signature boxes for payments then you will need to print each payment individually. List All Transfers Use this report to view transfer transactions that have been made either between accounts (List Account Transfers) or between names (List Transfers Between Names). 46 Chapter 6 Reports You can define the start and end dates for the report in order to shorten the list of transactions. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. Note: It is your responsibility to handle personal data in accordance with GDPR law. Cancellations List of Cancellations Use this to see a list of cancelled transactions between two dates. You can filter the list for names or groups. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. Note: It is your responsibility to handle personal data in accordance with GDPR law. Special Reports Who’s Not Paid Use this report to see a list of who’s not paid in a year, class or group between two dates. If you want to show who has paid along with who has not then select Show Paid Balances. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. Note: It is your responsibility to handle personal data in accordance with GDPR law. 47 Fund Manager User Guide Tip: The report will not generate any results unless you have defined a Unit Cost for the account so if the account you require is not in the list, go to Administration > Manage Accounts to enter a Unit Cost for the account. Journal Reports Use this report to produce a list of journals between the start and end date for the report, in the ledger and bank or cash account. Note: You must have defined ledger and bank ledger codes in order to run this report. Gift Aid You can create reports for Gift Aid transactions that meet the specifications for HMRC’s online submissions. Note: HMRC limits submissions to 1000 transactions. If your period under submission has more than 1000 transactions, then prepare two or more reports for submission to HMRC. In order for a transaction to be included in your Gift Aid claim, you must: 1. Set the Gift Aid l Transactions > Enter a Receipt. flag 2. Add Gift Aid donor details 1. Administration > Manage Names > Update Pupil Details. l Optionally, select Gift Aid Donor flag if you want to see the pupil is assigned a G in the GA column on the Manage Names List. Note: You don't have to select this flag for gift aid to work but it will make it visible on 48 Chapter 6 Reports the Names list that the pupil has been marked for gift aid donation. 2. Select the Gift Aid tab and enter the gift aid donor Title, First name, Last name, Address line and Postcode. Note: You can copy in the gift aid donor information from the parent / guardian contact details you have on record. You may need to amend the copied details if they are incomplete. 3. Click Save. New Claim for Donations Use this to generate a new Gift Aid claim report. Enter the date you want to claim Gift Aid donations up to and click Preview Donations. This lets you view all transactions from eligible Gift Aid donors within the donation period. Only transactions from pupils with a designated Gift Aid donor will appear in this report. Note: If Gift Aid donors exist with incomplete information, you won't be able to claim gift aid for them. You can see which donors are missing information as these are greyed out in the report. To manage Gift Aid status and donors, click the Manage Names link. Click the pupil’s name to bring up the Update Pupil screen and then select the Gift Aid tab to enter the gift aid donor information. There is the option to Print, Export CSV or Close Donation Period at the bottom of the screen. 49 Fund Manager User Guide l If you choose Export CSV you can open the report in Excel. Tip: First open Excel and then go to File > Open and select the downloaded file. An issue with HMRC's file format prevents opening by double-clicking on the downloaded file. l If you Close Donation Period, this finalises your submission and archives it to your Claim History. Note: It is your responsibility to handle personal data in accordance with GDPR law. Claim History Use this to view previously submitted Gift Aid claims. Click on the End Date link to view an archived report for the claim period in question. There is the option to Print or Export CSV at the bottom of the screen. l If you choose Export CSV you can open the report in Excel. Tip: First open Excel and then go to File > Open and select the downloaded file. An issue with HMRC's file format prevents opening by double-clicking on the downloaded file. Note: It is your responsibility to handle personal data in accordance with GDPR law. Backdated Gift Aid Claims You can backdate eligible transactions that haven’t been included within a donation period that is now closed. If you update the Gift Aid Donor details for a transaction that falls within a closed period it will be automatically included within your next submission. 50 Chapter 6 Reports 51 Fund Manager User Guide 52 Chapter 7 Bank & Cash The Bank & Cash menu contains options that are specific to your bank accounts and cash handling. The first options on this menu are reports, including the Bank & Cash Summary report that opens and displays when you click the Bank & Cash tab. Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see How to access Fund Manager. Reports Bank & Cash Summary This shows your balance position for all your bank accounts, cash and cheques in hand. You have the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. 53 Fund Manager User Guide Bank History Use this report on the Bank & Cash menu to see the debits and credits associated with the bank account displayed. This report is used during preparation for period end close-down in viewing unreconciled transactions. It’s also useful if you need to reprint paying-in slips. You can choose to filter the list by date, transaction type or reconciled/unreconciled. You have the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. Cash History This report shows the debits and credits associated with the cash in hand account. Leave the dates blank to look at the current financial year, or narrow your selection by entering the dates to view. You have the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. List Reconciled Bank Accounts Use this to view bank statements that have been reconciled. Find the statement you want to view and click on the End Date to open the statement and reveal the details. Banking Actions Pay Receipts to Bank When you enter receipt transactions on Fund Manager you also need to record the money (cash and cheques) which you are paying in to the bank. This will allow you to reconcile your bank statement correctly when it arrives from the bank. 54 Chapter 7 Bank & Cash You can pay in all the cheques by selecting the box next to the Date column or to pay in specific cheques, select the check box for those cheques. When you select a cheque, its details are added to the items selected box on the right of the screen. This is useful especially if you are selecting items on multiple pages as you can see the list of all the items selected in one place. If you are importing cash and cheque transactions from a payment platform then these transactions will appear on this page just as if you had entered them in Transactions r> Enter a Receipt. Note: If you are drawing a cheque for cash, this isn’t included in the list of cheques in hand. Use Draw Cheque for Cash for this. Enter the Amount to Pay in and select the Bank Account to pay the money into. The Paying-in Slip Number and Date are displayed automatically but you can amend this if required. Note: If Fund Manager won’t accept your paying-in slip number, it might be because you are using a duplicate paying-in slip number. For information on resolving this, see the support article How do I deal with a duplicated cheque? Click Pay In Receipts to Bank to complete the process. Draw Cheque for Cash Use this when you want to record cheques that you want to cash. This enables you to retain cash as petty cash. Enter all the relevant details: 1. Bank account the cheque is to be raised from. 2. The full value of the cheque. 3. The Cheque Number (this should match the actual cheque number you are taking to be cashed). 55 Fund Manager User Guide 4. The relevant date. 5. Click Draw Cheque. Note: You can’t cancel drawing a cheque for cash. If you make an error, pay the cash into the bank, using Pay Receipts to Bank. Enter the amount of cash and the relevant paying-in slip details and click Pay Receipts to Bank. Reconcile a Bank Statement This option on the Bank & Cash menu opens the Reconcile Bank Account screen but you can also select the Reconcile Settlement Account tab if you want to reconcile the settlement bank account. Reconciliation is the means by which you and the bank agree that the transactions recorded on each bank account are matched in Fund Manager. You can’t reconcile transactions until you receive the bank statement. Note: Some Fund Manager transactions may not appear on your bank statement for some time. 1. To reconcile a bank statement, on the Reconcile Bank Account screen, choose the bank account you want to reconcile. 2. Enter the first and last page, the end date and closing balance on the statement you are reconciling. Note: The Opening Balance on the List Unreconciled Bank Entries Report should always match the figure on the last bank statement you reconciled. 3. Select the transactions form the list of entries to reconcile that match the entries on your bank statement. Note: You can only reconcile transactions that lie inside your start and end dates. 4. Click Reconcile. 56 Chapter 7 Bank & Cash When reconciliation is complete, you can print the report from the bottom of the screen. Tip: You can leave a reconciliation part-way through but until you complete it or abandon it you won’t be able to reconcile another account. Transfers Transfer between Bank Accounts Use this option to let Fund Manager know that you have transferred money from one bank account to another bank account without issuing a cheque or using cash, and so on. Cancellations Cancel/Amend Bank Transaction Use this option to cancel or amend bank transactions (cashed cheques, payingin slips and bank transfers) that have not been reconciled. Taking the paying-in slip as an example: l To amend a paying-in slip: 1. Look for the relevant slip number in the Reference fields. 2. Click the slip number to open the slip 3. Make the necessary amendments . 4. Click Amend Paying in Slip. Note: Please ensure that the paying-in slip number is re-entered as Fund Manager will automatically choose the next one. l To cancel a paying-in slip: 1. Look for the relevant slip number in the Reference fields. 2. Click the radio button in the first column for the relevant Slip Number. 57 Fund Manager User Guide 3. Click the Cancel button at the bottom. 4. Confirm that this is the correct slip and click Cancel Transaction. Note: Reconciled items and items that are part of an incomplete bank reconciliation and have been selected in that are not included in the list for you to cancel or amend. Unreconcile a Bank Statement If you need to cancel a bank transaction that was included in a statement that has been reconciled, then you must unreconcile the bank statement first from the Bank & Cash menu. Unreconcile a Bank Statement returns all the items that have been previously reconciled back to the list of items to be reconciled. 1. Select the statement you would like to unreconcile. 2. Click Unreconcile. Note: Unreconciling a statement will cause all subsequent reconciliations to be automatically unreconciled. So if in June you unreconcile a statement from April, then statements from May and June will also be unreconciled. List Cancelled Bank Transactions Use this screen to view bank transactions that have been cancelled. You can change the display sequence of the transactions, by clicking the hyperlinked column name to re-order the display of the entries. For example, clicking on Date will order the display in ascending or descending order. Clicking on Amount will order by the amount. VAT There are two reports to help you with the reports you submit to HMRC for VAT. 58 Chapter 7 Bank & Cash Tip: Set up a separate VAT user account to keep track of any VAT refunded to you by HMRC and directly credit any VAT refunds to this account. Don’t transfer refunded VAT amounts into individual accounts because this will affect the figures provided by the Include VAT check box on the Search Account Balances report. Generate VAT 100 This report displays all the relevant fields for your HMRC return. Set an end date for the report; this is likely to be the end of your VAT reporting period. Fund Manager will total up all VAT transactions since the last report, including any that weren’t included on a previous VAT 100 report. The VAT 100 report displays the nine boxes that you are required to fill when completing the HMRC VAT Return. The boxes that appear in blue can be clicked to get a breakdown of evidence for that box, should the Inland Revenue ask for it. Previous VAT 100 Submissions You can view previous VAT 100 reports, by selecting them from a list. The display is the same as before. 59 Fund Manager User Guide 60 Chapter 8 Register Note: This menu only appears if you have requested it and Pebble has activated it for you. If you would like to make use of this please contact us and let us know. This menu allows you to record attendance for various items taken at school e.g. meals, clubs, events. You can record attendance using a Tablet device you have purchased from Pebble, via the Register App. If you haven’t purchased your Tablet from Pebble, contact us to see if your device is compatible with the Register App. Money received for a Register account is entered as a receipt and then attendance or take-up recorded on the Register tab. You can then run various reports from the Register tab on taken items. This also debits pupils’ money previously credited to the Register Account. Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see How to access Fund Manager. 61 Fund Manager User Guide Prerequisites To use the Register menu, you must ensure that the account you want to record attendance against has been set up in the following way: l The Register Account check box must be selected for the account through Administration > Manage Accounts. l You must have defined an Exclusion Group even if it has no pupils in it. This is a group that would not be expected to pay for the item you are recording as taken in the Register menu. Pupils can be added to this group through Administration > Manage Names. l Display on Device should be selected if you record attendance on a Tablet. You may need to speak to us if you haven’t purchased your Tablet direct from us so see if it is compatible with the Register App. l Attendance Group and UISFM Group boxes are for recording pupil meals and Universal Free School Meals. Record Taken Items Use this option to mark attendance or items taken for a pupil. 62 Chapter 8 Register 1. Select the Account. 2. Select the Group and or Class if applicable.. Note: Don’t select either of these if you want to produce a report for the whole school. 3. Choose the W/C (week commencing) date. 4. Click Search to display a report for you to select taken items. 5. Select the boxes of the pupils you want to record attendance against. 6. If any amount differs from the Unit Cost for the item, click and enter the different amount in the Amount box. The pupil will then be charged the altered amount. Entries are automatically saved as you enter them. If you need to make further changes, just overtype. Reports A number of reports help you to see what items have been taken, what each pupil has taken and a statement of receipts and balances for pupils. 63 Fund Manager User Guide Taken Items This report shows you which item (Account) has been recorded as taken weekly. If applicable you can filter the report by Group and Class. P - The pupil has Paid for that Item F - The pupil is receiving that Item for Free You can see the Balance of each Pupil’s Receipts to that Account, the Record of Recorded Items for the Week and the Final Balance each Pupil has remaining from Receipts entered through Fund Manager for that Account. Note: Pupils assigned to a Universal Infant Free School Meals group will show taken items as “U” (UIFSM). Pupils assigned to a Free School Meals group will show taken items as “F” (Free). Pupils assigned to neither group will show taken items as “P” (Paid). Name Summary Use this report to see individual pupil balances. 1. Select the Account, Group and Dates to display the pupils you are interested in. 2. Click Search. 64 Chapter 8 Register The Name Summary report is produced. Note: The Receipts, Payments, Balance and Final Balance columns are the sum the amount (£) for each pupil; the Paid, Free and UIFSM columns are a count of the number of meals taken. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. It is your responsibility to handle personal data in accordance with GDPR law. Statement To see a pupil’s statement, use this report. Select the Contact, the Account, the Date From the Date To then click Search. You can see the pupil’s Receipts, Payments, Paid taken items, Free taken items and Balance (the difference remaining between Receipts and Payments and the Paid taken Items). 65 Fund Manager User Guide Special Universal Infant Free School Meals From September 2014, all pupils in reception, year 1 and year 2 in state-funded schools in England became eligible for free school meals (UIFSMs). Use this report to see the total meals taken, the total number of free meals and the total number of Universal Free School Meals. In order to see anything on this report you need to set up and record items taken in the following way. How to set up and record universal infant free school meals There are a number of steps to this: 1. Create a UIFSM group and add eligible pupils. 1. Open Administration > Manage Names and click Create Group in the Group Actions section. 2. Enter a name for the group e.g. UIFSM. 3. Select User Defined as the Group Type. 4. Click Add Group. 2. Add pupils to this group. 1. Open Administration > Manage Names and select the group you created in step 1 from the Group drop-down in the Group Actions section. 2. Select the pupil names you want to add to the group by selecting the checkbox next to the pupil’s name. 3. In the Group Actions section, click Add to Group. 3. Assign the UIFSM group to your Register Account. 1. Open Administration > Manage Accounts. 2. Locate the Register Account in the list of accounts and click the Account name to open the Update Account screen. 66 Chapter 8 Register 3. Select the UIFSM Group that you have created in step 1 from the UIFSM Group drop-down. Note: Free School Meals take precedence over Universal Infant Free School Meals. If you have pupils who are eligible for Free School Meals, you need to ensure those pupils are added to the Free School Meals group and that the Free School Meals group is selected from the Exclusion Group drop-down. 4. Record UIFSM taken items. 1. Open Register > Record Taken Items 2. Select the Account, Group, Class and Week Commencing Date that you want to record the items for and click Search. 3. In the list of pupils that is displayed, select the checkbox next to each pupil for the days you want to record taken items for. 67 Fund Manager User Guide Account Summary Use this report to see statements for the user accounts. Select the Account and the Date From/To and click Search. A summary is given of the number of Groups assigned to the account, the amount in Receipts and in Payments as well as the Balance for the account, the number of items which were Paid, Free, UIFSM and in Total. There is the option to Print or Export CSV at the bottom of the screen. If you choose Export CSV you can open the report in Excel. Upload Register File Use this option to upload a CSV file of taken items for a school, where the automatic process hasn’t worked. Note: It is your responsibility to handle personal data in accordance with GDPR law. 68 Chapter 9 SIMs Software Integrations You can use Joinos - Pebble’s platform for helping you and the parents of your pupils communicate, pay for trips, school activities and meals or you can use ParentPay or sQuid - third party online e-payment SIMs which do the same. Each of these has a separate menu as outlined below. You can also integrate with ParentMail, SchoolComms and SchoolMoney but these integrations do not have a separate menu in Fund Manager. If you are integrating with these platforms, you need to export a CSV file of the information from the platform and then import it into Fund Manager, using the Transactions > Import Transactions option. Note: It is your responsibility to handle personal data in accordance with GDPR law. Tip: Remember you can get more help on anything you read in this chapter by checking the help on the Fund Manager screens. For more information, see How to access Fund Manager. 69 Fund Manager User Guide Joinos If you use Joinos there are also Joinos options available on the Administration menu (see Administration on page 7). There are two ways of creating offers at present; one is available to all while one is being beta tested currently. Create Offer v2 1. Select the Account the Offer is associated with. 2. Select a VAT Code (the default is zero). 3. Choose a Ledger, if applicable. 4. Choose the Fund Manager Settlement Account which transactions will be recorded against. 5. Enter a Title and Description for the offer. You can also choose an icon to be displayed to users within their Joinos portal. 6. Select Gift Aid if you would like to claim Gift Aid on the offer. 7. Select Consent Required if you would like your parent/carers to give online consent. 8. Select Required if you require the parent or carer to make the payment. 9. Select the Start Date and End Date for the offer. Select No end date if the Offer has no end date. Select whether the Offer can only be purchased once or the Offer can be purchased multiple times or in instalments. 10. Enter the Offer Costs, including the Total number of items you have and the Cost of the item. 11. Attach any files you would like to make available for parents to view on the offer screen. You can attach new files or files you have uploaded previously. 12. Select the names of pupils who are eligible for the Offer. You can use the Add Group button to add names to an offer in bulk by the Group they’re attached to. 70 Chapter 9 SIMs Software Integrations 13. When you are ready to post your offer to parents/carers, select Post this offer and click Save. Create Offer 1. Select the Account the offer is to be receipted against in Fund Manager. 2. Choose a VAT code if applicable. 3. Select your Settlement Account. 4. Enter the Offer Details. 1. Give your Offer a short Title. 2. Give your Offer a Description, i.e. Total cost of visit is £300. This can be paid altogether or by instalments of £50 – let your parents/carers know exactly what you want them to do, how you want them to pay and when. 3. Specify whether consent is required. Select the check box if you want to ensure that parents or carers cannot pay unless they agree to giving online consent. 4. Enter the Amount if the Offer is a set amount. 5. If the Offer is open to multiple payments or the parent/carer can decide how much to pay for each instalment, select the Unspecified check box. If you want parents/carers to see what they have paid: 1. Open Administration > Manage Accounts. 2. Select the account for the offer you want to share. 3. Ensure the account is marked In Use. 4. Select the Share Balances check box. 6. If you want to ensure parents and carers cannot pay below a certain amount, enter the amount in the Minimum box. 5. Enter the Offer Dates. 1. Choose the Start Date from when you want parents/carers to see the Offer. 71 Fund Manager User Guide 2. Choose the End Date - this is the date the Offer will no longer be available to parents/carers. Note: If you want to close an offer early, or cancel it, change the End Date to the current or previous day. 3. Select Recurring if you want parents/carers to be able to pay more than once for the same offer. 6. Enter the Offer Quantities. l Min = 1 Max = 1 Means usually one pupil one time/trip/visit/occasion. l Min = 1 Max = 2 + Means usually one or more item/ticket/place/tie can be purchased in one transaction. l Items Available means usually how many seats/tickets/coach spaces are available. Once the number of available items is sold no one else can buy, the Offer is ‘Sold Out’. l Unlimited means you will never exhaust supply. 7. Select any Attachments that you want to include with the Offer. Note: Documents are only listed here if they have been uploaded first using Upload Documents. 8. Select the names of pupils who are eligible for the Offer. 9. Either Post Offer or Save without Posting (which saves a draft for you to complete later). When you post the offer, it becomes visible to parents/carers on the Offer Start Date. An email is also sent to parents/carers notifying them of the Offer being posted. Active Offers You can access active, pending and expired offers from the Active Offers menu option. Selecting Active Offers displays a screen with three tabs - Active Offers, Pending Offers and Expired Offers. To amend an offer: 72 Chapter 9 SIMs Software Integrations 1. Locate the offer in the list of offers and click Amend. 2. Amend the details required. To close an offer or cancel it: 1. Locate the offer in the list of offers and click Amend. 2. Change the End Date to the current or previous day. To extend an offer: 1. Locate the offer in the list of offers and click Extend. 2. Enter the date you want to extend the offer to. Pending Offers You can access active, pending and expired offers from the Pending Offers menu option. Selecting Pending Offers displays a screen with three tabs - Active Offers, Pending Offers and Expired Offers. Use the Pending Offers tab to view what offers are currently pending. Offers will show up in this list as long as they have been saved but not posted or if their Start Date is in the future. You can amend pending offers, posting them or removing them as required. Expired Offers You can access active, pending and expired offers from the Active Offers or Pending Offers menu options. Selecting either menu option displays a screen with three tabs - Active Offers, Pending Offers and Expired Offers. Use the Expired Offers tab to view offers that have expired. Offers will show up in this tab if they have been posted and the End Date has passed. Documents Upload Document Use this option to upload documents that you want to attach to offers, for example, trip itineraries or cost breakdowns or newsletters. 73 Fund Manager User Guide Warning! Do not upload any private or sensitive information. Documents Use this option to view documents that you have uploaded to attach to offers. If a document is attached to an offer you can view the offer by clicking Attached Offers. To detach a document from an offer, click Attached Offers and then click Remove. How to transfer Joinos payments so you can reconcile your bank statements Within Fund Manager, you are required to have a Joinos Settlement Account that all of the money is imported into and this should have been set up for you before or during Training. Transfer the amount Once you have received your Bank Statement you will be able to transfer the total transaction net amount credited on your Bank Statement from the Joinos Settlement Account to your chosen Bank Account so you can reconcile the bank account in Fund Manager; 1. Open Bank & Cash > Transfer between Bank Accounts. 2. Select the Transfer From Settlement Account. 74 Chapter 9 SIMs Software Integrations Record Joinos Charges After the transfer(s) are complete, you must now record any ‘bank charges’ back into the Current Account. To do this, you must have a user account set up called e.g. Bank Charges. You should also have an organisation name to transact against e.g. Joinos Bank Charges. For more information on setting up bank accounts and organisation names, see Administration on page 7 1. Record a Payment (Direct Debit) against the Current Bank account of the amount of the Charges. You will already have transferred the GROSS amount from the Settlement Bank account which includes the e-payments and also includes your charge(s). Note: You MUST record these back in against your Current Account as a Direct Debit and NOT against the Settlement Account. 2. You will now be ready to record the transaction, to do this, go to Transactions > Record a Payment. 3. In this screen you will now select your user account (Bank Charges) and of course, your new name. Fill out the relevant information and the amount of your charge then select your Type as Direct Debit. You must ensure your bank account (in the centre of your payments screen) is your Current Account. 75 Fund Manager User Guide 4. Select Save. You now have your original gross transfer and the direct debit refund/charge against your current account ready to reconcile. Messaging New Message Use this screen to compose and send email messages and SMS text messages to pupils’ parents and carers. You can only send messages to people who have provided an email address or a contact phone number, preferably a mobile number. These can all be added to a student’s name, using Administration > Manage Names. Note: Using MISapp will automatically import your pupil’s names into Fund Manager if you have SIMS MIS. 1. Open Messaging > New Message. 2. Enter the Title and Body of the message. 3. Select any attachments that you want to include with the message. 76 Chapter 9 SIMs Software Integrations Note: Before you can select attachments to include with the message, you must upload these using Joinos > Upload Document. 4. Select the names in the Contacts list to send the message to. 5. To send the message as an SMS Notification, select Send selected contacts a message alert via SMS. Note: This will only work where the student has a phone number listed. Most, but not all, home telephones are able to receive test messages, but where possible a mobile number is preferable. You can specify which phone number is primary if there are two or more numbers listed for a student. For more information, use the Manage Phone Numbers tab under Administration > Manage Names. 6. Click Send. Confirmation is shown at the top of the screen. The message will appear within a short time in the parent/carers Joinos. If they are already logged on they may need to refresh their screen to see the latest messages. History Use this screen to review the messages that have been sent. Clicking the title of the message displays the message detail. This is the Title and Body of the message along with the contacts who the message was sent to. You can also see whether the message has been read or not here. ParentPay ParentPay transactions can be imported into Fund Manager manually in the same way as ParentMail, SchoolComms and SchoolMoney transactions, 77 Fund Manager User Guide manually importing via CSV files, but we recommend that you import them automatically. The automatic integration is described here. Map Names Names should map automatically in Fund Manager from your MIS or MISapp using the Pupil's unique MIS number in the same way as ParentPay uses the Pupil MIS number to collect payments. Sometimes Names are not automatically Mapped, often Staff Names or Pupils that are not part of the usual Pupil cohort and not held within your MIS system with a permanent upn. If this is the case use ParentPay > Map Names to match the Name on the right to the drop down Name on the left and, this will automatically tick the box to the left of the left hand side Name for you. If there is no Name to match it to on the right then ignore that Name for the time being and move onto the next one, repeat the process through all of the pages then click Import Names. If you click Import 100, Fund Manager will automatically import the first 100 names on the list. Note: If you import names and then have duplicate names, you will need to merge the names. For more information on this, see Consolidating Pupil Names in Administration on page 7. Accounts Map Accounts/Payment Items You will need to Map your Accounts in Fund Manager with your Payment Items (Accounts) in ParentPay in order for the Transactions to Import into the correct Names and Accounts in Fund Manager 1. Open ParentPay > Map Accounts/Payment Items. 2. Match the ParentPay account on the left with the Fund Manager account on the right. l If you don’t want to import transactions into some accounts because the money is going to a different bank account for example, click Hide alongside the account. 78 Chapter 9 SIMs Software Integrations l If you can’t find the account in Fund Manager, you will need to create a new account, using Administration > Manage Accounts > Create New Account. You can do this later and return to map those later. Finish the mappings as far as you can for now. 3. Click Map Payment Items. Note: You will need to map each new account in Fund Manager every time you create a new one in ParentPay if these Transactions need Importing into Fund Manager, however you will only see the new Payment Item in Fund Manager after the first transaction is processed, you will then be able to map this Payment Item to an Account in Fund Manager. Tip: If you prefer you can map the Payment Item in your ParentPay software. When you set up a new Payment Item you will need to populate the ‘Group 1’ Code and Description at the bottom of the setup form with the same Account Code and Description you would like the transactions to flow into in Fund Manager, before you save the Payment Item. This mapping will be mirrored in Fund Manager so please be sure you use the correct Account Code and associated Bank Account when you enter these fields in ParentPay Map Settlement Accounts Note: This is usually completed at Training, but if you add a further Bank Account to ParentPay and you wish to see these Transactions in Fund Manager then Pebble can map this Bank Account for you. Fund Manager needs to place your Imported Transactions into a Virtual Holding Bank Account called a ParentPay Settlement Account until you are ready to Reconcile your Bank Statement/s. This is because Parents/Carers pay for Payment Items in Full and this needs to be reflected in both ParentPay and in Fund Manager as a complete Payment for an Item against a Pupil Name. However ParentPay Settles to your designated Bank Account/s once a week as a NET Transaction NOT GROSS. The difference between the net amount paid to your designated Bank Account and gross figure is the Transaction Invoice/s 79 Fund Manager User Guide that ParentPay supplies you with online via: ParentPay site>Finance>Reports>Collection Service Invoices Note: You can also check via ParentPay site>Finance>Reports>Collection Service Statements that your Settlements to your designated Bank/s balances with the Transactions taken Online and through PayPoint (if used) Reports Unmapped ParentPay Transactions Any transactions that have not been or do not need to be mapped will be seen in the Unmapped Transactions tab. Once the initial Integration has taken place the most recent transactions will appear at the top of this list. If you identify a Payment Item that you cannot see in Fund Manager it might be because you have not mapped a name and/or account to this transaction type. If this is the case you will need to do this by using the option Map Accounts / Payment Items or contacting Pebble to ask for another settlement account to be mapped. Other Authenticate This screen is used to enter ParentPay credentials and specify the date from which you want to import transactions from ParentPay into Fund Manager (if this is different from the default period beginning date) but this is done for you before you complete training. How to transfer money so you can reconcile your bank statements Once your ParentPay Transactions have started Importing into Fund Manager you will see the ParentPay Settlement Bank Account credited with ‘Virtual’ money. 80 Chapter 9 SIMs Software Integrations Transfer the amount Once you have received your Bank Statement you will be able to transfer the total transaction net amount credited on your Bank Statement from the ParentPay Settlement Account to your chosen Bank Account so you can reconcile the bank account in Fund Manager; 1. Open Bank & Cash > Transfer between Bank Accounts. 2. Select the Transfer From Settlement Account. 3. Select the Transfer To Bank Account. 4. Enter Amount 5. Enter Date 6. Click Transfer Record payment You can then ‘Record a Payment’ in Fund Manager for the debited fees, the difference between the net amount paid to you and the gross amount paid by the parents on your Bank Account Statement to balance your ParentPay Settlement Account. Note: You can find these transaction service invoices in ParentPay in the reporting section. 1. Open Transactions > Record a Payment 2. Select the Settlement Bank Account. 3. Enter the transaction details and select Direct Debit for the Type against the Settlement Bank Account 4. Click Save and then split the payment to the different accounts if you want. sQuid Setting up, posting and amending offers is all done in sQuid now and so provided everything is set up and working in sQuid and you map the sQuid 81 Fund Manager User Guide offers to Fund Manager accounts, importing sQuid transactions is an automatic process. View Offers Use this to amend offers you have already posted. You will now be able to see the offers that are live on this screen, please note you must select the offer title to view. You will now be able to make any necessary adjustments to your offer, this can include adding/removing names or changing dates etc. Please ensure you select Post Offer before leaving to allow the updated information to reach the parents. To remove an offer from sQuid, you must first repeat the steps of going into amend your offer. Once inside the offer, you can simply change your current end date to BEFORE the start date. This process will immediately remove the offer from Fund Manager AND sQuid. Note: You will not be able to view expired/removed offers Post New Offer Listed below are the fields that you are required to fill in when creating an offer. To post an offer, you must go to sQuid>Post New Offer 82 Chapter 9 SIMs Software Integrations l Account - The user account into which the money will be recorded l Title - What the parents see on their sQuid portal when looking at the offers l Amount - The amount you want the parent to pay. This can be set to ‘Unspecified’ which will allow the parent to pay any amount they like towards the offer l Start Date - when the offer will appear, End Date - when the offer will be removed/deleted, Deadline - when the School would like the money to be paid Note: The offer will not display to the parents if a future date has been set as the Start Date l Min -the minimum amount of ‘slots, items or places’ available, Maximum how many the parent can buy, Items Available - how many slots e.g. seats available on a coach trip etc Note: Please ensure Maximum items does not exceed 100,000 l Recurring - can be used on offers for school uniform eg ties etc. Something that the user would like to have available for a set period of time l Mandatory Checkbox Text & Optional Checkbox - Displays a checkbox for the parent to tick, similar to a Terms and Conditions checkbox when downloading a program to your pc. Not necessary to complete these l Names - At least one name MUST be selected to post an offer correctly Map Offers to Accounts Use this to map the sQuid offers to Fund Manager accounts so that imported transactions are added to the correct user accounts and names in Fund Manager. The money will be added to the sQuid Settlement Account. sQuid offers are listed in the Name column. 1. Select a Fund ManagerAccount for each sQuid offer. 2. Click Map Payment Items. 83 Fund Manager User Guide Map Contacts In most cases, names will map automatically in Fund Manager from your MIS or MISapp. Sometimes Names are not automatically Mapped and this can mean some transactions aren’t imported. Use sQuid > Map Contacts to ensure that all the contacts have mapped and to map any that haven’t mapped automatically. 1. Open sQuid > Map Contacts. The list of contacts in sQuid is displayed. The Imported Name is the name of the contact in sQuid. 2. Select the Fund Manager name to match from the Choose Name dropdown. 3. If there is no matching Name to select in the Choose Name drop-down, you will need to import the names.To import names: 1. Select the check box to the left of the Imported Name, 2. Click Import Names. Note: If you import names and then have duplicate names, you will need to merge the names. For more information on this, see Consolidating Pupil Names in Administration on page 7. Pending Import Import of sQuid transactions into Fund Manager is automatic, provided you have mapped sQuid offers to accounts in Fund Manager. Until you have mapped sQuid offers to Fund Manager accounts, the list of transactions to import will be greyed out as in this example: 84 Chapter 9 SIMs Software Integrations When you have mapped sQuid offers to Fund Manager accounts, the list is no longer greyed out: 85 Fund Manager User Guide Where’s the money Import sQuid Sales After the offers have been posted and parents start to pay, you will use the screen below to import the transactions for the students/user account. You must: l Select the Settlement Account for the money to be imported into l Tick any transactions to be imported l Select ‘Import’ Once imported, your transactions will show in Fund Manager against the correct user accounts and names. The money will be added to the sQuid Settlement Account. Configuration Register Pupils Each pupil has an SRN (sQuid Registration Number) and a CVV (Card Verification Value). This information is provided by sQuid and is needed before registering. 86 Chapter 9 SIMs Software Integrations The students details can be viewed by going to sQuid > Register Pupils > Manual Registration. The other tabs available within sQuid > Register Pupils are: l Register Names With sQuid - You can register students here who are not already setup on sQuid - If you are an IMPACT school and receive your card numbers from a catering company, please ensure you speak to us about your file before attempting to Register these pupils. To Register a pupil, Find the name to register, click the small square to the left of the name (you can select multiple names) then click the Register Names button. This is automatically sent to Squid to process and when they have completed this, the name(s) will appear in the View Registered Names tab. l View Registered Names - You can use the tab to see who is registered with sQuid. It will also show ALL cards registered to that child (old/lost/expired etc.) Fund Manager, however, will know which card is linked to sQuid and use the correct number. These are NOT duplications in the system. Remember to ensure that the card has the correct purses added. When the new intake of pupils is registered you can then print out all their registration letters at one go. Select the year group and click Search > Print Registration Letters. l Manual Registration - If you require to add/amend a pupils sQuid information manually, you can use this screen to do that. Simply Search for and select the pupils name (in blue) and it will allow you to edit the card details. Configure sQuid Use this screen to set up the integration between the sQuid e-payment system and the school in Fund Manager. All of the information required is provided by sQuid to Pebble. 87 Fund Manager User Guide How to transfer sQuid payments money so you can reconcile your bank statements Within Fund Manager, you are required to have a sQuid Settlement Account that all of the money is imported into (via the sQuid > Import sQuid Sales). Transfer the amount Once you have imported your transactions, you will be able to transfer the total Transaction amount from the Settlement Account to your chosen Bank Account by doing the following: 1. Open Bank & Cash > Transfer Between Bank Accounts. 2. Transfer from Settlement Account. 3. Transfer to desired bank account to reconcile. 4. Enter Amount. 5. Enter Date. Record charges After the transfer(s) are complete, you must now record any ‘bank charges’ back into the Settlement Account. To do this, you must have a user account set up labeled sQuid Bank Charges. For more information, see Manage Accounts in Administration on page 7. 88 Chapter 9 SIMs Software Integrations You must record a Payment (Direct Debit) back against the sQuid Settlement Bank account for the amount needed. This will reduce the Settlement Bank account to now include your charges. When to contact us Pebble Any issues with regard to l l Registering sQuid Any issues with regard to l sQuid schedule and sQuid T&Cs l The provision of the existing SRNs/C.V.V’s from the pupils school’s chosen cashless catering provider to through FM Pebble. Posting l setup in FM offers through FM l l l Queries regarding sQuid responsibility for the Importing transfer of monies between the sQuid settlement sQuid sales account(s) and the school Bank account(s) into FM l The provision of sQuid Comms options to Pebble for l Queries from the school regarding parents l Queries from parents Mapping l sQuid schedule and sQuid T&Cs sQuid offers l Setting up, posting and amending offers in sQuid to l The provision of the existing SRNs/C.V.V’s from the FM accounts school’s chosen cashless catering provider to Importing Pebble. sQuid l Queries regarding sQuid responsibility for the transactions transfer of monies between the sQuid settlement into FM account(s) and the school Bank account(s) l Queries from the school regarding parents l Queries from parents 89 Fund Manager User Guide 90 Appendix Fund Manager Action Buttons Leave a page / Abandon a task Add pupils / staff / organisations to a Group A quick link to paying in Merge duplicate Names Continue to the next part or process Create an ad-hoc Group of your choosing Create a New Account heading to post Receipts to and send Payments from Create a new pupil / staff / organisation Name Delete an ad-hoc Group that you no longer need Use this button to draw a Cheque for Cash Allows you to open up your report in Excel 91 Fund Manager User Guide Need some help - check out our Support pages and click here if you can’t find a solution to your issue Import your pupils’ Names from your MIS via a CSV template. Note: It is your responsibility to handle personal data in accordance with GDPR law. Leave the page and return later to where you were Create a list of who has paid money Manage / Edit / Create your Accounts Manage / Edit / Create your pupil / staff / organisation Names Complete your Paying-in Slip and then click this Button Print any page using this Button Record the money taken in school A quick link to Reconciling your Statements / Reconcile your Statement Remove Names / Accounts from a Group Allows you to Reprint your Receipts Save your entries Save and Print your entries Search your query 92 Fund Manager Action Buttons Shows your current status of all your Accounts Search transactions. Reveal names or accounts that have been taken out of use Allows you to split your Receipts and Payments Action your Transfer Click to Unreconcile Bank Statements 93 Fund Manager User Guide 94 Glossary Google Chrome, Mozilla Firefox Glossary or Apple Safari. Budget B The expected level of expenditure. Bank Account An account held with a bank for Button purposes of managing your Something which you can click funds, e.g. current account, sav- in the program to make some- ings account. thing happen e.g. clicck the Save button to save the information. Box Another name for an entry field in C software e.g. a text box where you can enter text information to be used by the program. Charity An organisation - normally nonprofit-making - which has a char- Browser A program, sometimes known as itable status within the UK government's definition. a web browser, which lets you navigate and browse the Internet e.g. Microsoft Internet Explorer, Cheque in Hand A cheque or cheques which you have not yet paid into the bank. 95 Fund Manager User Guide Close a Period CVV The objectives of closing a period Three digit card security number, are to: draw a line under your trans- usually on the back of the card. actions for the period; close any accounts that will not be used in the next period; determine which accounts will have their balances transferred to the new period; balance your income and expenditure for the period with that of your bank Closedown See Close a period. Comma Separated Value The name given to a file which stores values that can be read by computer programs. Each line in the file is a record and each record is separated by a comma. CSV The name given to a file which stores values that can be read by computer programs. Each line in the file is a record and each record is separated by a comma. D Dashboard A particular screen within a program which provides you with the ability to access and use the features within a module. Database A store of information for use in a computer. Dfe Number A seven digit number, identifying English or Welsh schools. Direct Credit Payment direct into a person's or organisation's bank account. For example, payment via BACS or bank interest. Direct Debit Payment direct out of a person's or organisation's bank account. For example, payment via BACS or bill payment. 96 Glossary Draft Period End Financial Period A preview of what the period end A period of time in which financial report will show. Producing a statements are prepared. draft period end will generate all the reports required for a financial period e.g. Account Summary Income and Expenditure; Transactions; Account Balances; Bank History; Cash History; Closing Bank Balances. Fiscal Accountability Accountability for the way that money in your school is used and managed. This may be the domain of the school business manager but will more likely involve a number of senior management staff within the school. E ePayment For Profit Payment made across the Inter- This is used to describe an organ- net, for example, parent online isation whose purpose is to make transactions. a profit. Charities are not for profit. eReceipt Free School Meals Payment received across the Pupils can qualify for free school Internet, for example, Paypal meals if their parent/carer claims transactions. certain benefits. For more information, see https://www.gov.uk/apply-free-school-meals F Field The name given to a box where Pebble's fund management soft- you enter information in a com- ware, helping you to manage the puter program. This may be text, income that comes in and goes numbers or a date, depending on out of your school. the type of field. 97 Fund Manager Fund Manager User Guide G J Gift Aid Joinos This is a UK government scheme Pebble's platform for helping you which lets registered charities and the parents of your pupils com- reclaim a percentage of tax on municate, pay for trips, school activ- donations from UK taxpayers. ities and meals. Journal H Holds the details of accounting HMRC transactions in a given tinme Her Majesty's Revenue and Cus- period. toms department within the UK government. L Ledger Code I A code which integrates with an Icon external financial system, allowing A button in a computer program you to provide unified VAT report- which represents an action or an ing across both systems. object and is usually identified by a picture. Intercom MISapp Pebble's online support platform. Pebble's tool to assist you in This is what you use when you importing pupil names from your communicate with our support school administration database. team. 98 M Glossary N Payment A transaction that pays a person Negative Payments or organisation. Payments where monies are returned to the pupil for over- Pop-up payment or refund. A window in the computer program which pops up on top of O another window on a computer screen. Offline An activity which takes place on a computer while the computer is not connected to the Internet. Opening Balance The amount of money an account owns on the date the account is created in Fund Manager. R Receipt A transaction that records money received from a person or organisation. Reconciliation The process of comparing the P transactions recorded on your ParentMail An ePayment system which allows parents (also staff) to pay for items online. ParentPay An ePayment system which allows parents (also staff) to pay for items online. 99 bank statement with the transactions listed in Fund Manager. Register A Fund Manager menu that allows you to record items taken, such as attendance, meals, etc. Fund Manager User Guide S SMS Messaging Short Message System. You can School Reference Number send short messages for Joinos for A seven digit number, usually Parents using the Joinos menu. made up from three digits and four digits. sQuid An online payment system which SchoolComms can be integrated with Fund Man- An ePayment system which allows ager. parents (also staff) to pay for items online. Support Material assistance for your pro- SchoolMoney jects. Or in the case of software An ePayment system which allows queries, advice and guidance on parents (also staff) to pay for items how to provide a solution. online. Screen A window of the computer program e.g. the dashboard of a module. Settlement Account A bank account used for electronic transactions. SIMS School Information Management System. T Tab A sub-division of a screen, offering the ability to view two separate screens in one, by clicking on the tabs to swap views. Taken Items Items such as attendance, school meals etc can be recorded on the Register Menu in Fund Manager, once they have been taken. 100 Glossary Transaction Unreconciled Transactions An agreement over supply and Synonymous with Unpresented demand e.g. a contract to transactions. exchange goods and services for money. Transfer V VAT 100 Move money between accounts A report that displays the 9 boxes or names in Fund Manager. you are required to fill when completing an HMRC VAT Return. U W Universal Free School Meals From September 2014 pupils in Reception and Years 1 and 2 at A program, sometimes known as state schools in England qualify a web browser. which lets you for universal free school meals. navigate and browse the Internet For more information, see e.g. Internet Explorer, Google https://www.gov- Chrome, Mozilla Firefox or Apple .uk/guidance/universal-infant- Safari. free-school-meals-guide-forschools-and-local-authorities. Unpresented Transactions Transactions that have not been presented to the bank. For example, you have received monies in or made payments out but these have not yet been recorded by the bank and so don't appear on bank statements. 101 Web Browser Window A screen in the computer program e.g. the dashboard of a module. Fund Manager User Guide 102 Index A view 14 Accessing Fund Manager 1 help 1 Account Balances differences 44-45 Active Joinos Offers 72 Adding accounts 18 bank accounts 20 cost centres 18 Account Code 14 names 11 Account Summary Report 43 organisations 11 Accounts archive 17 Aggregated Name 44 bank accounts 20 Amend Opening Balance 16 cost centre 14 Amending create 18 Joinos for Parents offer 72 edit 14-15 opening balance 16 in use 15 paying-in slip 57 transfers 39 103 Administration 7 Fund Manager User Guide Archiving Bank Statements pupils and staff 9, 12 reconcile 56 Assigning names to groups 11 Attaching unreconcile 58 Batch Actions Joinos for Parents offer accounts 17 documents 73 Attendance Group 62 B names 10 Browser configuration 3 Budget Value 17 Backdated Gift Aid Claims 50 Balance of Accounts 6 Bank & Cash Summary Report 53 Bank Accounts add 20 balance 6 default 20 opening balance 21 reconciled bank balance 21 transfers 57 Bank and Cash 6, 53 Bank History Report 54 C Cancelling cheque for cash 56 Joinos for Parents offers 73 paying-in slip 57 payments 41 receipts 41 Cash History Report 54 Claim History Report 50 Class Group 10 Closing gift aid donation period 49 Joinos for Parents Offer 73 104 Index period end 25 who's not paid 47 Configuring Browsers 3 D Consolidating Names 12 Dashboard 5 Cost Centre 14 Default Bank Account 20 Cost Centres 18 Differences in Account Balances 4445 Creating bank accounts 20 Joinos codes 26 Joinos for Parents offers 70-71 CSV Export accounts summary 43 bank & cash summary 53 bank history 54 cash history 54 gift aid claim history 50 list all transfers 47 list of cancellations 47 new gift aid claim 49 search account balances 45 search transactions 44 user account summary 68 Display on Device 62 Draw Cheque for Cash 55 E Entering payments 34 receipts 30 Exclusion Group 62 Expired Joinos for Parents Offers 73 Exporting accounts summary 43 bank & cash summary 53 bank history 54 cash history 54 gift aid claim history 50 list all transfers 47 list of cancellations 47 105 Fund Manager User Guide new gift aid claim 49 assigning names 11 search account balances 45 attendance 62 search transactions 44 class 10 user account summary 68 exclusion 62 who's not paid 47 names actions 10 Extend Joinos for Parents Offers 73 registration 10 F UISFM 62 Financial Period user defined 10 number of days in 6 start date 6 year 10 H G Help 1 Gift Aid Hide out of use 18 backdated claims 50 I close donation period 49 Importing in a closed period 32 CSV register file 68 manage donors 49 ParentPay transactions 77 new claim for donations 49 transactions 41 preview donations 49 In Use 10-11, 15, 21 report 48 Integrated SIMS 69 Groups account actions 18 106 J Joinos 74 Index Joinos for Parents Lists active offers 72 cancellations 47 amend offer 72 payments by cheque/voucher number 46 cancel offer 73 receipts by receipt number 46 close offer 73 reconciled bank accounts 54 code expiry 26 transfers 46 create codes 26 create offer 71 create offer beta 70 expired offers 73 extend offer 73 message history 77 new message 76 offers 70 pending offers 73 share balances 15, 71 upload documents to attach to offers 73 Logging in 1 M Manage Gift Aid Donors 49 Mapping ParentPay accounts 78 ParentPay names 78 ParentPay settlement accounts 79 Menus administration 7 bank and cash 6, 53 register 61 Journal Reports 48 reports 6, 43 L transactions 6, 27 Ledger Code 31, 35 List Cancelled Bank Transactions 58 107 Merging Names 12 Fund Manager User Guide Messaging Joinos for Parents 76-77 MISapp 9 P ParentMail 41, 69 ParentPay N import transactions 77 Names 9 map accounts 78 adding 11 map names 78 consolidating 12 map settlement accounts 79 merging 12 payment items 78 summary report 64 unmapped transactions 80 transfers 39 Part-complete Reconciliation 57 Negative Balance 39 Password 1 New Claim for Donations 49 Password Reset 1 New Joinos for Parents Message 76 Pay Receipts to Bank 54 O Paying-in Slips Opening Balance 6, 16 amend 57 Organisations cancel 57 adding 11 duplicate numbers 55 names 9 reprinting 54 summary 6 Out of Use 10, 14, 17, 21 Payments cancel 41 ParentPay items 78 108 Index payment types 35 payments 46 printing 46 receipts 46 reprinting 46 search account balances 45 signature boxes 46 search transactions 44 splitting 37 user account summary 68 Pending Joinos for Parents Offers 73 Period End who's not paid 47 Pupil bank history report 54 archive 9, 12 closedown 25 attendance 15 view opening balances 24 meals 15 Petty Cash 55 names 9 Previous VAT 100 Submissions 59 statement report 65 Printing view balances 64 accounts summary 43 R bank & cash summary 53 Receipts bank history 54 cancel 41 cash history 54 printing 46 gift aid claim history 50 receipt type 31 list all transfers 47 reprinting 46 list of cancellations 47 splitting 37 new gift aid claim 49 109 Reconcile Bank Statement 56 Fund Manager User Guide Reconciled Bank Balance 21 gift aid 48 Recording gift aid claim history 50 attendance 61 journal 48 items taken 61 list all transfers 46 payments 34 list of cancellations 47 receipts 30 list receipts by receipt number 46 taken items 62 list reconciled bank accounts 54 transactions 29 name summary 64 universal free school meals 66 payments by cheque/voucher num- Register Account attendance group 62 display on device 62 exclusion group 62 setup 15, 62 UISFM group 62 Registration Group 10 Reports accounts summary 43 ber 46 previous VAT 100 submissions 59 pupil's statement 65 search account balances 45 search transactions 44 special 47 taken items 64 universal free school meals 66 unmapped ParentPay transactions 80 bank & cash summary 53 user account summary 68 bank history 54 VAT 100 59 cash history 54 who's not paid 47 110 Index Reprinting Split Payment 37 paying-in slips 54 Splitting Receipts and Payments 37 payments 46 Staff receipts 46 archive 9, 12 Reset Password 1 names 9 S T SchoolComms 41, 69 Tablet Devices 16, 61 SchoolMoney 41, 69 Taken Items Search Account Balances Report 45 recording 62 Search Transactions Report 44 report 64 Send Text Message 77 Transactions Set Up Register Account 62 cancelled bank 58 Settlement Bank Account 21, 56 import 41 Share Joinos for Parents payments 35 Balances 15, 71 Show Out of Use 10, 17 Show Paid Balances 47 Signature Boxes for Payments 46 SIMS 69 SMS send text message 77 Special Reports 47 111 processing 27 receipts 30 splitting 37 unmapped ParentPay transactions 80 VAT rate 32, 36 Transfers between accounts 39 Fund Manager User Guide between bank accounts 57 V between names 39 VAT negative balance 39 code 32, 36 Type of Payment 35 rate 32, 36 Type of Receipt 31 VAT 100 report 59 U Viewing UISFM Group 62 accounts 14 Unit Cost 17, 48 archived Gift Aid claims 50 Universal Free School Meals archived VAT 100 reports 59 record 66 cancelled bank transactions 58 report 66 expired Joinos offers 73 set up 66 Gift Aid donations 49 Unmapped ParentPay Transactions 80 help 1 Unreconciled Bank Statement 58 Joinos for Parents message Unreconciled Transactions 54 Uploading Joinos for Parents offer documents 73 register file 68 history 77 opening balances 24 pending Joinos offers 73 reconciled bank statements 54 sQuid offers 82 User Account Summary Report 68 sQuid student details 87 User Defined Group 10 transactions 30, 35, 43-44 112 Index transfer transactions 46 unreconciled transactions 54 uploaded Joinos offer documents 74 who's registered on sQuid 87 W Who's Not Paid Report 47 Y Year End 43 closing account 45 outstanding balances 45 Year Group 10 113 Fund Manager User Guide 114
Source Exif Data:
File Type : PDF File Type Extension : pdf MIME Type : application/pdf PDF Version : 1.4 Linearized : No Page Count : 122 Page Mode : UseOutlines Page Layout : SinglePage Language : en-gb Tagged PDF : Yes Producer : madbuild Create Date : 2018:09:13 12:25:39+01:00 Modify Date : 2018:09:13 12:25:39+01:00 Title : Fund Manager User Guide 90010 Author : Pebble Subject :EXIF Metadata provided by EXIF.tools