**----- Start of picture text -----**
10th Antrim
Statement of Income and Expenditure
01/09/2023 - 31/08/2024
31/8/2024 31/8/2023
Opening Bank Balances £ £
1 Ulster Bank 6,915.65 7,794.14
2 Danske Bank
3 Cash in-hand - -
Total Opening Balance 6,915.65 7,794.14
Income
Income from Membership Fees 3,040.00 3,433.00
Fund Raising 8,085.00 9,970.00
Donations
Grants 5,684.40 4,096.39
Other Income (events and other)
16,809.40 17,499.39
Expenditure
Membership Fees Paid to National Office 4,606.50 4,547.50
Amounts Paid to Counties or Provinces
Programme Costs 12,260.00 13,244.00
Training Costs - 150.00
Administrative Costs 534.62 436.38
Den Costs - -
Other Expenses (events and other) - -
Volunteer Expenses
17,401.12 18,377.88
Closing Balance 6915.65
#ERROR!
Surplus (Deficit) - 591.72 - 878.49
Closing Balances
1 Ulster Bank 6,323.93
2 Danske Bank
3 Cash-in-hand
Total Closing Balance 6,323.93
6,323.93
Bank statement Unpresented Prior period Closing reconciled
Bank Reconciliation balance cheques / Unpresente balance
lodgements d cheques /
lodgements
1 Ulster Bank 6,323.93 - 6,323.93
2 Danske Bank - -
3 Cash in-hand £0.00 - -
Total Closing Reconciled Balance 6,323.93 6,323.93
**----- End of picture text -----**
**----- Start of picture text -----**
Our balance Statement balance
Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name
Period
1 0.00 0.00 0.00 0.00 0.00 0.00 Bank
2 0.00 0.00 0.00 0.00 0.00 0.00 Bank
Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand
0.00 0.00 0.00
0.00
A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative
dd/mm/yyyy Expenditure? Lodgement
Ref
2 income 0.00 0 0.00
2 expenditure 0.00 0 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
**----- End of picture text -----**
**----- Start of picture text -----**
Our balance Statement balance
Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name
Period
1 0.00 0.00 0.00 0.00 0.00 0.00 Bank
2 0.00 0.00 0.00 0.00 0.00 0.00 Bank
Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand
0.00 0.00 0.00
0.00
A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative
dd/mm/yyyy Expenditure? Lodgement
Ref
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
**----- End of picture text -----**
**Our balance Statement balance Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name Period** 1 0.00 0.00 0.00 0.00 0.00 0.00 Bank 2 0.00 0.00 0.00 0.00 0.00 0.00 Bank Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand 0.00 0.00 0.00 0.00 **A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative dd/mm/yyyy Expenditure? Lodgement Ref** 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 **Our balance Statement balance Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name Period** 1 0.00 0.00 0.00 0.00 0.00 0.00 Bank 2 0.00 0.00 0.00 0.00 0.00 0.00 Bank Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand 0.00 0.00 0.00 0.00 **A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative dd/mm/yyyy Expenditure? Lodgement Ref** 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 **----- Start of picture text -----**
Our balance Statement balance
Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name
Period
1 0.00 0.00 0.00 0.00 0.00 0.00 Bank
2 0.00 0.00 0.00 0.00 0.00 0.00 Bank
Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand
0.00 0.00 0.00
0.00
A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative
dd/mm/yyyy Expenditure? Lodgement
Ref
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
**----- End of picture text -----**
**----- Start of picture text -----**
Our balance Statement balance
Bank A/C # Opening Movement Closing Opening Movement Unpresented Prior Closing Bank A/C Name
Period
1 0.00 0.00 0.00 0.00 0.00 0.00 Bank
2 0.00 0.00 0.00 0.00 0.00 0.00 Bank
Cash £0.00 0.00 0.00 £0.00 0.00 0.00 0.00 Cash in hand
0.00 0.00 0.00
0.00
A/C # Date Income or Cheque / Analysis Payee Amount Statement # Statement value Narrative
dd/mm/yyyy Expenditure? Lodgement
Ref
0.00
0.00
0.00
0.00
0.00
**----- End of picture text -----**
## **Treasurer's Statement** I have supervised the recording of the transactions in the financial records of the Group and to the best of my belief and knowledge the transactions recorded are complete and accurately recorded in the books of the Group. I have prepared these accounts, as Treasurer of the Scouting Ireland 10th Antrim, from the transactions recorded in the books of the Group and the information provided to me by the Scouters within the Group and, as far as I am aware and believe, the accounts are a true reflection of the Group's financial transactions during the year and of the Group's financial position the at year-end. ## **________________________** Treasurer Group Leader 00/00/00 - **Instruction on how to use the Group Accounts Template** - **12334567896789789899** Once the initial setup is complete, use 'File' and 'Save as' to save the document to your hard drive.Enter transactions on the 'Bank' tab. Transactions can be entered before appearing on the bank statement and will then be recorded in the 'unpresented cheques' section.cheques' section.For each transaction, enter the number corresponding to the appropriate account in the 'A/C' column. **2334567896789789899** Enter transactions on the 'Bank' tab. Transactions can be entered before appearing on the bank statement and will then be recorded in the 'unpresented cheques' section.cheques' section.For each transaction, enter the number corresponding to the appropriate account in the 'A/C' column. **4567896789789899** For each transaction, enter the number corresponding to the appropriate account in the 'A/C' column. **101213141511567891213141511567891314151156789141511567891511567891156789** Enter the date of the transaction in the 'Date' columnSelect whether the transaction is a payment Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Select whether the transaction is a payment Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction. _**from**_ the account (i.e. expenditure) or a lodgement _**always**_ be a positive amount - the calculation takes account of whether the _**to**_ the account (i.e. income) **16** To print the Treasurer's Statement change the Treasurer's name and the Date. **17** At the end of each financial year, once the accounts have been finalised, click the button to the right to save the file under a new name, copy figures to a new column, and start a new financial year. -->column, and start a new financial year. --> **For support with this spreadsheet please contact your PSO or County Treasurer.** **----- Start of picture text -----**
12334567896789789899 Once the initial setup is complete, use 'File' and 'Save as' to save the document to your hard drive.Enter transactions on the 'Bank' tab. Transactions can be entered before appearing on the bank statement and will then be recorded in the 'unpresented cheques' section.cheques' section.For each transaction, enter the number corresponding to the appropriate account in the 'A/C' column. from the account (i.e. expenditure) or a lodgement always be a positive amount - the calculation takes account of whether the to the account (i.e. income) 1234 At the end of each financial year, click the button belowClick 'OK' to accept the new filenameThe figures from the previous year's accounts will be copied to a new column.The transactions in the 'Bank' tab will be cleared and a new financial year started End of year procedure
101213141511567891213141511567891314151156789141511567891511567891156789 Enter the date of the transaction in the 'Date' columnSelect whether the transaction is a payment Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Select whether the transaction is a payment Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the reference number (from the cheque stub or the lodgement book) under 'Cheque/Lodgement ref'.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Select the appropriate category from the list in the 'Analysis' columnEnter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the cheque recipient in the 'Payee' columnEnter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter the amount of the cheque/lodgement in the 'Amount' column. This should transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.transaction is a cheque or a lodgement.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Once the transaction appears on the bank statement, enter the statement number under 'Statement #'.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.The 'Statement value' column is calculated automatically.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.Enter a description in the 'Narrative' column, e.g. 'Purchase 20 woggles for Beavers'There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.There are a number of built-in checks. If any cell turns red there is a problem. If you hover over the cell it will show a comment on how the error may be resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.resolved.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.If a cheque is mislaid and needs to be redrawn then a corresponding +ve transaction needs to be entered. Neither the original cheque transaction nor the reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.reversing transaction will appear on a bank statement and should not have a bank stetement number entered in column G. The replacement cheque should be entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.entered as per the original cheque with the new date and cheque ref.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.To print the Bank Transactions page you must set the print area - View, Page Break Preview and then drag the solid blue line to below the last transaction.
16 To print the Treasurer's Statement change the Treasurer's name and the Date.
17 At the end of each financial year, once the accounts have been finalised, click the button to the right to save the file under a new name, copy figures to a new column, and start a new financial year. -->column, and start a new financial year. -->
For support with this spreadsheet please contact your PSO or County Treasurer.
**----- End of picture text -----**