OpenCharities

This text was generated using OCR and may contain errors. Check the original PDF to see the document submitted to the regulator.

2024-04-05-accounts

ABOUT THE EXCEL CASH BOOK EASY

This Excel workbook has been developed by Sarah Booysen of Beginner Bookkeeping. - www.beginner bookkeeping.com

This template can be used to track your income and expenses and to calculate if the business is making a profit or a loss. This workbook is not for sale or re-sale. It is for private business or individual use only.

If you have any questions about how to use this workbook or about bookkeeping for your business please use the Contact form. www.beginner-bookkeeping.com/contact-me.html Thanks for using this cashbook!

THIS CASHBOOK

Excel Cashbook Easy 7 Income Accounts 20 Expense Accounts Profit and Loss Report Bank Reconciliation Worksheet One Bank Account per Cashbook

----- Start of picture text -----
UPGRADE TO
Cash Book Excel with Balance Sheet
14 Income Accounts
10 Cost of Goods Sold Accounts
30 Expense Accounts
10 Balance Sheet Accounts
Inventory Balances Input Sheet
Bank Reconciliation Worksheet
Profit and Loss Report
Balance Sheet Report
e-Book Help Guide - printable
One Bank Account per Cashbook
Try Before Buy Sample : Free
Full Template: USD7.99
VIEW DETAILS
----- End of picture text -----

If the VIEW NOW button doesn't work, you can type this URL into your web browser https://www.beginner-bookkeeping.com/cash-book-excel.html

Excel Cas

LINKS TO BOOKKEEPING GUIDES

On the Beginner Bookkeeping website

Guide to Bookkeeping Procedures

Other Excel Templates to Use Alongside This One

Learn About Proft and Loss Reports

Learn About Balance Sheets Accounts Receivables Procedures

Accounts Payables Procedures

Home Ofce Expenses Bank Reconciliation Year-End Preparations Cashbook Excel with Balance Sheet

-hbook Easy

Excel Cashbook Easy

QUICK START TIPS

1 Example Page

This Excel Cash Book version only has Income and Expense accounts. There are no Cost of Sales accounts and no Balance Sheet.. Look at the Example page to see how transactions look when they are entered.

4 Bank Reconciliation

Once a month (at least), check that your bank statement and cashbook balances match - fix any errors. Use the Reconciliation tab to reconcile your bank account with undeposited funds or unpresented checks/cheques.

7 More Accounts

If you require more account columns in the Monthly tabs, you can insert more Columns. First insert new Account Headings onto the Accounts page, then insert new Account columns into the Months. Then link the monthly headers to the Accounts/Headers Page. Also, insert new account rows on the P&L and link the cells from there to the Total cells of the new columns for every month.

10 Formatting the Cashbook

If you want to change the overall color and font schemes for the whole workbook, go to the Page Layout tab on the top menu of Excel, and select Themes. Select different themes to see what the Cashbook looks like until you find one you like. Change it once a month for fun to prevent boredom if you are an arty visual person!

2 Months and Accounts Headers

On the MonthsHeaders and Accounts Headers pages - enter the names of your business/club, your accounts and your months - these are all linked to every month and the P&L. You can also rename the monthly tabs to change them from Month1, Month2 etc. to the name of your months.

5 Profit and Loss Report

The Profit and Loss Report (P&L) will tell you if your business is making a profit. This report is often also called the Income Statement or Income Summary - you can re-name it if required. All the totals rows from the Monthly tabs are linked to the P&L sheet. Note : There is an Adjustments section for items that should be on a Balance Sheet which are listed here.

8 Tips for Printing

If the monthly sheets are too large, try hiding rows and columns not used to make the sheets smaller for printing and viewing. Use Custom Scaling Options under print settings to fit the month onto the number of pages best for you.

11 Reports Custom Views

I love this feature! To view only one month at a time on the Reports, go to either the P&L, then select View > Custom Views > Select the month you want to see . There are two lists, one for the P&L and one for the BS. You can also select All Months to go back to the standard view.

3 Data Entry

Every month enter your Income and Expenses into the Month tabs. Do this weekly, daily or fortnightly, whatever works for you.

6 Balance Sheet

There is no Balance Sheet with this version of the Excel Cash Book. You can get one prepared by your Accountant, or download the version of Excel Cash Book that does have a Balance Sheet. (look at the About sheet in this Cash Book for the link to the Cash Book website page.)

9 Formatting the Cashbook

For a quick way to adjust all 12 months at the same time you must 'group' them. Click on the first month tab, hold down shift on your keyboard, and click on the last month tab - this selects all months. Now go into the first month and change your formatting - (row heights, column widths, insert new columns etc). When finished, right click any month tab, and select 'Ungroup' sheets.

12

If any features don't work for you, it may be that your version of Excel is quite old? If it's a serious issue, please Contact me (see About page)

In the top right corner of some of the cells is a red triangle - this

EXAMPLE PAGE

My Example Business

In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this In the top right corner of some of the cells is a red triangle - this
January Description
Ref
TOTALS
Funds raised from auction
Payment for Invoice
Inv 0001
Bank fees
Fuel for Club President
Receipt 1
New Games
10001
Stapler, pens, envelopes
Receipt 2
Payment received
Inv 0003
Bank Interest received
Office Rent Payment
Phone
Printing of Club Rules Booklet
10002
Grant received from Government		 MONEY IN M
Details Income
Date Payment
Type		 Name Description Ref Club Fees Fund
Raising		 Government
Grants		 Bank
Interest
Received		 Total Money
In
TOTALS 200.00 800.00 500.00 2.00 1,502.00
4-Jan Deposit Annual Fundraiser Funds raised from auction 800.00 800.00
6-Jan ATM Mrs Smith Member Payment for Invoice Inv 0001 100.00 100.00
8-Jan Bank Pmt Big Bank Bank fees 0.00
11-Jan XX Gas Station Fuel for Club President Receipt 1 0.00
18-Jan Chk Club Games Suplies New Games 10001 0.00
21-Jan POS Stationery Retailers Stapler, pens, envelopes Receipt 2 0.00
21-Jan Deposit Ms Issa Member Payment received Inv 0003 100.00 100.00
28-Jan Bank Pmt Big Bank Bank Interest received 2.00 2.00
30-Jan DC Mr Landlord Office Rent Payment 0.00
30-Jan DD Telephone Company Phone 0.00
31-Jan Chk Printers LLC Printing of Club Rules Booklet 10002 0.00
Jan-31 Deposit Government Grant received from Government 500.00 500.00

Excel Cashbook Easy

s indictes helpful information

s indictes helpful information s indictes helpful information s indictes helpful information s indictes helpful information Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy
ONEYOUT
Expenses
Bank
Charges		 Office Rent Phone Printing and
Stationery
Vehicle
Expenses		 Games
Supplies		 Total
Money Out		 BANK
BALANCE		 R
5.00 250.00 80.00 91.00 40.00 280.00 746.00 273.00 Open ing Bank Balance
0.00 1,073.00
0.00 1,173.00 R
5.00 5.00 1,168.00 R
40.00 40.00 1,128.00 R
280.00 280.00 848.00 R
26.00 26.00 822.00 R
0.00 922.00 R
0.00 924.00 R
250.00 250.00 674.00 R
80.00 80.00 594.00 R
65.00 65.00 529.00 R
0.00 1,029.00
1,029.00 Clos ing Bank Balance

MONEY OUT

MONTHS

Typing Information into the HEADERS will carry thr

MONTH HEADERS

Month1 Month2 Month3 Month4 Month5 Month6 Month7
January February March April May June July
2022 2022 2022 2022 2022 2022 2022
Type in the months of your financial year - if Month1 of your financial year is April, type
also rename the tab names for each monthly worksheet along the bottom of this
automatically in Excel without VBA coding - I have left VBA coding out of this Cashbo
Excel Help Centre. You can also change the year which i

Type in the months of your financial year - if Month1 of your financial year is April, type also rename the tab names for each monthly worksheet along the bottom of this C automatically in Excel without VBA coding - I have left VBA coding out of this Cashboo Excel Help Centre. You can also change the year which i

Excel Cashbook Easy

rough to each page of this workbook

Month8 Month9 Month10 Month11 Month12
August September October November December
2022 2022 2022 2022 2022
''April'' underneath Month1, ''May'' under Month2 etc. You can
Cashbook. You have to do it manually. It cannot be done
ok to keep it simple. Type 'How to rename worksheet' in your
s linked to every monthly sheet.

''April'' underneath Month1, ''May'' under Month2 etc. You can Cashbook. You have to do it manually. It cannot be done ok to keep it simple. Type 'How to rename worksheet' in your s linked to every monthly sheet.

Excel Cashbook Easy

ACCOUNTS

Typing Information into the HEADERS will carry through to each page of this workbook

BUSINESS NAME HEADER

Enter Your Business Name Here

ACCOUNT HEADERS

ACCOUNT HEADERS
Details
Date
Name
Descripton
Ref
Payment
Type		 Type your headers into the green boxes titled Account 1, Account 2 and so on. You can rena
Income
1
2
3
4
5
6
7
Income
Account 1
Income
Account 2
Income
Account 3
Income
Account 4
Income
Account 5
Income
Account 6
Income
Account 7
Total
Money In
Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses Expenses
Expense
Account 1		 Expense
Account 2		 Expense
Account 3		 Expense
Account 4		 Expense
Account 5		 Expense
Account 6		 Expense
Account 7		 Expense
Account 8		 Expense
Account 9		 Expense
Account 10		 Expense
Account 11		 Expense
Account 12		 Expense
Account 13		 Expense
Account 14

Expense Expense Expense Expense Expense Expense Total Account 15 Account 16 Account 17 Account 18 Account 19 Account 20 Money Out 15 16 17 18 19 20

Excel Cashbook Easy

S.C Head & Neck Charity Account

April 21-March 22
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
20-May-21
Miles Weston Gift
16-Jun-21
Transfer in from original S.C. Account
20-Sep-21
Deposit Cranleigh School Fair
21-Sep-21
Just GivingCharityWalk(Lucy)
27-Sep-21
Sum UpMachine
28-Sep-21
Just Giving (Lucy)
1-Oct-21
Gift to NALC
4-Oct-21
Careprint Leafets
4-Oct-22
Just Giving (Lucy)
7-Oct-22
Tea Room(Members Walk)
20-Oct-21
Sum upDonation
1-Nov-21
Just Giving (Lucy)
11-Nov-21
Sum Updonation
8-Nov-21
Xmas Fair Cranleigh
8-Nov-21
Ink Cartridge Invitations
8-Nov-21
Xmas Fair Cranleigh
9-Nov-21
Postage
4-Nov-21
Xmas Fair Cranleigh
13-Dec-21
GHSC Xmas Party
13-Dec-21
Xmas Partyfundraising
18-Jan-22
Computer Van
2-Feb-22
Deposit Masonic Lodge ClosingDown(Margaret)
CLOSING BANK BALANCE ROW
Payment
Type		 April 21-March 22
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
20-May-21
Miles Weston Gift
16-Jun-21
Transfer in from original S.C. Account
20-Sep-21
Deposit Cranleigh School Fair
21-Sep-21
Just GivingCharityWalk(Lucy)
27-Sep-21
Sum UpMachine
28-Sep-21
Just Giving (Lucy)
1-Oct-21
Gift to NALC
4-Oct-21
Careprint Leafets
4-Oct-22
Just Giving (Lucy)
7-Oct-22
Tea Room(Members Walk)
20-Oct-21
Sum upDonation
1-Nov-21
Just Giving (Lucy)
11-Nov-21
Sum Updonation
8-Nov-21
Xmas Fair Cranleigh
8-Nov-21
Ink Cartridge Invitations
8-Nov-21
Xmas Fair Cranleigh
9-Nov-21
Postage
4-Nov-21
Xmas Fair Cranleigh
13-Dec-21
GHSC Xmas Party
13-Dec-21
Xmas Partyfundraising
18-Jan-22
Computer Van
2-Feb-22
Deposit Masonic Lodge ClosingDown(Margaret)
CLOSING BANK BALANCE ROW
Payment
Type		 April 21-March 22
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
20-May-21
Miles Weston Gift
16-Jun-21
Transfer in from original S.C. Account
20-Sep-21
Deposit Cranleigh School Fair
21-Sep-21
Just GivingCharityWalk(Lucy)
27-Sep-21
Sum UpMachine
28-Sep-21
Just Giving (Lucy)
1-Oct-21
Gift to NALC
4-Oct-21
Careprint Leafets
4-Oct-22
Just Giving (Lucy)
7-Oct-22
Tea Room(Members Walk)
20-Oct-21
Sum upDonation
1-Nov-21
Just Giving (Lucy)
11-Nov-21
Sum Updonation
8-Nov-21
Xmas Fair Cranleigh
8-Nov-21
Ink Cartridge Invitations
8-Nov-21
Xmas Fair Cranleigh
9-Nov-21
Postage
4-Nov-21
Xmas Fair Cranleigh
13-Dec-21
GHSC Xmas Party
13-Dec-21
Xmas Partyfundraising
18-Jan-22
Computer Van
2-Feb-22
Deposit Masonic Lodge ClosingDown(Margaret)
CLOSING BANK BALANCE ROW
Payment
Type		 April 21-March 22
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
20-May-21
Miles Weston Gift
16-Jun-21
Transfer in from original S.C. Account
20-Sep-21
Deposit Cranleigh School Fair
21-Sep-21
Just GivingCharityWalk(Lucy)
27-Sep-21
Sum UpMachine
28-Sep-21
Just Giving (Lucy)
1-Oct-21
Gift to NALC
4-Oct-21
Careprint Leafets
4-Oct-22
Just Giving (Lucy)
7-Oct-22
Tea Room(Members Walk)
20-Oct-21
Sum upDonation
1-Nov-21
Just Giving (Lucy)
11-Nov-21
Sum Updonation
8-Nov-21
Xmas Fair Cranleigh
8-Nov-21
Ink Cartridge Invitations
8-Nov-21
Xmas Fair Cranleigh
9-Nov-21
Postage
4-Nov-21
Xmas Fair Cranleigh
13-Dec-21
GHSC Xmas Party
13-Dec-21
Xmas Partyfundraising
18-Jan-22
Computer Van
2-Feb-22
Deposit Masonic Lodge ClosingDown(Margaret)
CLOSING BANK BALANCE ROW
Payment
Type		 April 21-March 22
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
20-May-21
Miles Weston Gift
16-Jun-21
Transfer in from original S.C. Account
20-Sep-21
Deposit Cranleigh School Fair
21-Sep-21
Just GivingCharityWalk(Lucy)
27-Sep-21
Sum UpMachine
28-Sep-21
Just Giving (Lucy)
1-Oct-21
Gift to NALC
4-Oct-21
Careprint Leafets
4-Oct-22
Just Giving (Lucy)
7-Oct-22
Tea Room(Members Walk)
20-Oct-21
Sum upDonation
1-Nov-21
Just Giving (Lucy)
11-Nov-21
Sum Updonation
8-Nov-21
Xmas Fair Cranleigh
8-Nov-21
Ink Cartridge Invitations
8-Nov-21
Xmas Fair Cranleigh
9-Nov-21
Postage
4-Nov-21
Xmas Fair Cranleigh
13-Dec-21
GHSC Xmas Party
13-Dec-21
Xmas Partyfundraising
18-Jan-22
Computer Van
2-Feb-22
Deposit Masonic Lodge ClosingDown(Margaret)
CLOSING BANK BALANCE ROW
Payment
Type		 MONEY IN MONEY IN MONEY IN
Details Income
Date Payment
Type		 Name Descripton Ref Xmas Party Donations Fundraising Transfers Total Money
In
DO NOT DELETE THIS TOTALS ROW 0.00 1,250.00 1,010.88 3,000.00 5,260.88
20-May-21 Miles Weston Gift 0.00
16-Jun-21 Transfer in from orig inal S.C. Account 3,000.00 3,000.00
20-Sep-21 Deposit Cranleigh Sc hool Fair 0.00
21-Sep-21 Just GivingCharityW alk(Lucy) 214.22 214.22
27-Sep-21 Sum UpMachine 0.00
28-Sep-21 Just Giving (Lucy) 180.08 180.08
1-Oct-21 Gift to NALC 0.00
4-Oct-21 Careprint Leafets 0.00
4-Oct-22 Just Giving (Lucy) 221.65 221.65
7-Oct-22 Tea Room(Members Walk) 0.00
20-Oct-21 Sum upDonation 3.92 3.92
1-Nov-21 Just Giving (Lucy) 15.53 15.53
11-Nov-21 Sum Updonation 3.44 3.44
8-Nov-21 Xmas Fair Cranleigh 71.76 71.76
8-Nov-21 Ink Cartridge Invitati ons 0.00
8-Nov-21 Xmas Fair Cranleigh 229.00 229.00
9-Nov-21 Postage 0.00
4-Nov-21 Xmas Fair Cranleigh 12.28 12.28
13-Dec-21 GHSC Xmas Party 0.00
13-Dec-21 Xmas Partyfundraisi ng 59.00 59.00
18-Jan-22 Computer Van 0.00
2-Feb-22 Deposit Masonic Lod ge ClosingDown(Ma rgaret) 1,250.00 1,250.00
0.00
CLOSING BANK BALANCE ROW

MONEY OUT

MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT
Overheads &
Equiptment		 Catering Printing &
Postage		 Gifts Total Money
Out		 BANK
BALANCE		 R
175.99 116.95 99.83 565.00
957.77		 3,521.78 Open ing Bank Balance
65.00
65.00		 3,456.78
0.00 6,456.78
20.00 20.00 6,436.78
0.00 6,651.00
35.99 35.99 6,615.01
0.00 6,795.09
500.00
500.00		 6,295.09
58.52 58.52 6,236.57
0.00 6,458.22
26.95 26.95 6,431.27
0.00 6,435.19
0.00 6,450.72
0.00 6,454.16
0.00 6,525.92
20.91 20.91 6,505.01
0.00 6,734.01
20.40 20.40 6,713.61
0.00 6,725.89
90.00 90.00 6,635.89
0.00 6,694.89
120.00 120.00 6,574.89
0.00 7,824.89
0.00 7,824.89
7,824.89 Clos ing Bank Balance

Excel Cashbook Easy

S.C. Head & Neck Charity Account

April 22- March 23
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
11-May-23
Stamps
16-May-23
(Mary) Just Givingdonation
5-Jul-23
Pantomime Tickets
16-Aug-23
LoseleyPark Visit/Tea
20-Aug-23
New SC Banner
5-Sep-23
PrintingLeafets/Cards
7-Sep-23
Repayment Loseleyfrom Committee members
28-Sep-23
DepCranleigh School Xmas fair booking
28-Sep-23
Shalford Vill Hall Hire Fees
13-Oct-23
Cateringfor Brooklands Visit
7-Oct-23
Donations Xmas Fair
22-Oct-23
RadioJackie Advert
22-Oct-23
Reimbursementpayment to committee member
23-Nov-23
Computer van Problem SolvingWebsite
28-Dec-23
Just GivingDonation(unknown)
11-Jan-23
Katie Woods School Fair
11-Jan-23
Panto tickets sold
11-Jan-23
Sweets boughtpanto
11-Jan-23
Xmas Party
11-Jan-23
Xmas Fair Cranleigh
11-Jan-23
Food receipts Xmas Party
13-Feb-23
Room Hire shalford
14-Feb-23
Social Club Bill Xmas Party
23-Feb-23
PrintingMary's Card
CLOSING BANK BALANCE ROW
Payment
Type		 April 22- March 23
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
11-May-23
Stamps
16-May-23
(Mary) Just Givingdonation
5-Jul-23
Pantomime Tickets
16-Aug-23
LoseleyPark Visit/Tea
20-Aug-23
New SC Banner
5-Sep-23
PrintingLeafets/Cards
7-Sep-23
Repayment Loseleyfrom Committee members
28-Sep-23
DepCranleigh School Xmas fair booking
28-Sep-23
Shalford Vill Hall Hire Fees
13-Oct-23
Cateringfor Brooklands Visit
7-Oct-23
Donations Xmas Fair
22-Oct-23
RadioJackie Advert
22-Oct-23
Reimbursementpayment to committee member
23-Nov-23
Computer van Problem SolvingWebsite
28-Dec-23
Just GivingDonation(unknown)
11-Jan-23
Katie Woods School Fair
11-Jan-23
Panto tickets sold
11-Jan-23
Sweets boughtpanto
11-Jan-23
Xmas Party
11-Jan-23
Xmas Fair Cranleigh
11-Jan-23
Food receipts Xmas Party
13-Feb-23
Room Hire shalford
14-Feb-23
Social Club Bill Xmas Party
23-Feb-23
PrintingMary's Card
CLOSING BANK BALANCE ROW
Payment
Type		 April 22- March 23
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
11-May-23
Stamps
16-May-23
(Mary) Just Givingdonation
5-Jul-23
Pantomime Tickets
16-Aug-23
LoseleyPark Visit/Tea
20-Aug-23
New SC Banner
5-Sep-23
PrintingLeafets/Cards
7-Sep-23
Repayment Loseleyfrom Committee members
28-Sep-23
DepCranleigh School Xmas fair booking
28-Sep-23
Shalford Vill Hall Hire Fees
13-Oct-23
Cateringfor Brooklands Visit
7-Oct-23
Donations Xmas Fair
22-Oct-23
RadioJackie Advert
22-Oct-23
Reimbursementpayment to committee member
23-Nov-23
Computer van Problem SolvingWebsite
28-Dec-23
Just GivingDonation(unknown)
11-Jan-23
Katie Woods School Fair
11-Jan-23
Panto tickets sold
11-Jan-23
Sweets boughtpanto
11-Jan-23
Xmas Party
11-Jan-23
Xmas Fair Cranleigh
11-Jan-23
Food receipts Xmas Party
13-Feb-23
Room Hire shalford
14-Feb-23
Social Club Bill Xmas Party
23-Feb-23
PrintingMary's Card
CLOSING BANK BALANCE ROW
Payment
Type		 April 22- March 23
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
11-May-23
Stamps
16-May-23
(Mary) Just Givingdonation
5-Jul-23
Pantomime Tickets
16-Aug-23
LoseleyPark Visit/Tea
20-Aug-23
New SC Banner
5-Sep-23
PrintingLeafets/Cards
7-Sep-23
Repayment Loseleyfrom Committee members
28-Sep-23
DepCranleigh School Xmas fair booking
28-Sep-23
Shalford Vill Hall Hire Fees
13-Oct-23
Cateringfor Brooklands Visit
7-Oct-23
Donations Xmas Fair
22-Oct-23
RadioJackie Advert
22-Oct-23
Reimbursementpayment to committee member
23-Nov-23
Computer van Problem SolvingWebsite
28-Dec-23
Just GivingDonation(unknown)
11-Jan-23
Katie Woods School Fair
11-Jan-23
Panto tickets sold
11-Jan-23
Sweets boughtpanto
11-Jan-23
Xmas Party
11-Jan-23
Xmas Fair Cranleigh
11-Jan-23
Food receipts Xmas Party
13-Feb-23
Room Hire shalford
14-Feb-23
Social Club Bill Xmas Party
23-Feb-23
PrintingMary's Card
CLOSING BANK BALANCE ROW
Payment
Type		 April 22- March 23
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
11-May-23
Stamps
16-May-23
(Mary) Just Givingdonation
5-Jul-23
Pantomime Tickets
16-Aug-23
LoseleyPark Visit/Tea
20-Aug-23
New SC Banner
5-Sep-23
PrintingLeafets/Cards
7-Sep-23
Repayment Loseleyfrom Committee members
28-Sep-23
DepCranleigh School Xmas fair booking
28-Sep-23
Shalford Vill Hall Hire Fees
13-Oct-23
Cateringfor Brooklands Visit
7-Oct-23
Donations Xmas Fair
22-Oct-23
RadioJackie Advert
22-Oct-23
Reimbursementpayment to committee member
23-Nov-23
Computer van Problem SolvingWebsite
28-Dec-23
Just GivingDonation(unknown)
11-Jan-23
Katie Woods School Fair
11-Jan-23
Panto tickets sold
11-Jan-23
Sweets boughtpanto
11-Jan-23
Xmas Party
11-Jan-23
Xmas Fair Cranleigh
11-Jan-23
Food receipts Xmas Party
13-Feb-23
Room Hire shalford
14-Feb-23
Social Club Bill Xmas Party
23-Feb-23
PrintingMary's Card
CLOSING BANK BALANCE ROW
Payment
Type		 MONEY IN MONEY IN MONEY IN MONEY IN
Details Income
Date Payment
Type		 Name Descripton Ref Xmas Party Donations Fundraising Transfers Income
Account 5
DO NOT DELETE THIS TOTALS ROW 155.00
566.57		 922.23 0.00 0.00
11-May-23 Stamps
16-May-23 (Mary) Just Givingdo nation 410.22
5-Jul-23 Pantomime Tickets
16-Aug-23 LoseleyPark Visit/Te a
20-Aug-23 New SC Banner
5-Sep-23 PrintingLeafets/Car ds
7-Sep-23 Repayment Loseleyf rom Committee mem bers 107.50
28-Sep-23 DepCranleigh Schoo l Xmas fair booking
28-Sep-23 Shalford Vill Hall Hire Fees
13-Oct-23 Cateringfor Brookla nds Visit
7-Oct-23 Donations Xmas Fair 39.31
22-Oct-23 RadioJackie Advert
22-Oct-23 Reimbursementpay ment to committee m ember
23-Nov-23 Computer van Proble m SolvingWebsite
28-Dec-23 Just GivingDonation (unknown) 48.85
11-Jan-23 Katie Woods School Fair 525.81
11-Jan-23 Panto tickets sold 240.00
11-Jan-23 Sweets boughtpanto
11-Jan-23 Xmas Party 155.00
11-Jan-23 Xmas Fair Cranleigh 117.11
11-Jan-23 Food receipts Xmas Party
13-Feb-23 Room Hire shalford
14-Feb-23 Social Club Bill Xmas Party
23-Feb-23 PrintingMary's Card
CLOSING BANK BALANCE ROW

MONEY OUT
Income
Account 6		 Income
Account 7		 Total Money
In
0.00 0.00 1,643.80
0.00
410.22
0.00
0.00
0.00
0.00
107.50
0.00
0.00
0.00
39.31
0.00
0.00
0.00
48.85
525.81
240.00
0.00
155.00
117.11
0.00
0.00
0.00
0.00
0.00
MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT MONEYOUT
Overheads Catering &
Outings		 Printing &
Postage		 Gifts Expense
Account 5		 Expense
Account 6		 Total Money
Out		 BANK
BALANCE
1,187.50 1,290.32 513.76 42.00 0.00 0.00
3,033.58		 7,824.89
27.30 27.30 7,797.59
0.00 8,207.81
344.00 344.00 7,863.81
592.01 592.01 7,271.80
180.00 180.00 7,091.80
207.00 207.00 6,884.80
0.00 6,992.30
40.00 40.00 6,952.30
112.50 112.50 6,839.80
113.40 113.40 6,726.40
0.00 6,765.71
504.00 504.00 6,261.71
42.00 42.00 6,219.71
300.00 300.00 5,919.71
0.00 5,968.56
0.00 6,494.37
0.00 6,734.37
25.00 25.00 6,709.37
0.00 6,864.37
0.00 6,981.48
73.31 73.31 c
231.00 231.00 #VALUE!
142.60 142.60 #VALUE!
99.46 99.46 #VALUE!
0.00
#VALUE!

i

Ope ing Bank Balance Clos ng Bank Balance

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
March 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
April 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
May 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
June 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
July 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

----- Start of picture text -----
Enter Your Business Name Here Excel Cashbook Easy
August 2022 MONEY IN MONEY OUT
Details Income
Date Payment Type Name Descripton Ref Account 1Income Account 2Income Account 3Income Account 4Income Account 5Income Account 6Income Account 7Income Total Money In Account 1Expense Account 2Expense Account 3Expense Account 4Expense Account 5Expense Account 6Expense Account 7Expense Account 8Expense Account 9Expense Account 10Expense Account 11Expense Account 12Expense Account 13Expense Account 14Expense Account 15Expense Account 16Expense Account 17Expense Account 18Expense Account 19Expense Account 20Expense Total Money Out BALANCEBANK R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! Opening Bank Balance
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
0.00 0.00 #VALUE!
CLOSING BANK BALANCE ROW #VALUE! Closing Bank Balance
----- End of picture text -----

Excel Cashbook Easy

S.C. HEAD & NECK CHARITY ACCOUNT

S.C. HEAD & NECK CHARITY ACCOUNT S.C. HEAD & NECK CHARITY ACCOUNT S.C. HEAD & NECK CHARITY ACCOUNT S.C. HEAD & NECK CHARITY ACCOUNT S.C. HEAD & NECK CHARITY ACCOUNT Excel Cashb ook Easy ook Easy ook Easy
APRIL 23- MARCH 24
Details
Date
Name
Descripton
Ref
DO NOT DELETE THIS TOTALS ROW
21-Apr-23
Thi Chi Instructor
21-Apr-23
Tea/Cofee Purchases
21-Apr-23
Stamps
25-Apr-23
Tea Cofee Purchases
26-Apr-23
Transfer of funds fro Current A/c now closed
27-Apr-23
Tea/Cakes Farnham Castle
4-May-23
Compensation Payment Bank non-closure A/c
1-Jul-23
Income from Fete
15-Jul-23
8 member tickets Denbies
9-Aug-23
Donation from member
31-Aug-23
Donation to C Cofls
12-Sep-23
Payment Sandra Hospital Chocs
15-Sep-24
Careprint Donation chequeprint
20-Sep-24
Donation Cheque Beaverbrook
6-Dec-24
Gift to Alan Baker
11-Dec-24
Stamps
11-Dec-24
Xmaspartysweets
11-Dec-24
Xmas PartyFood
11-Dec-24
School Fete Collection(Katie)
16-Jan-24
Xmas PartyPresents/Books(Me)
16-Apr-24
Xmas PartyHall hire + drinks
5-Feb-24
Donation topatient RJMatheson
5-Feb-24
Special committee MeetingCofee
9-Feb-24
Cofee for meetingwith members
12-Feb-24
Stamps
14-Jan-24
Xmasparty
21-Feb-24
Biscuits,Shalford Meeting
23-Feb-24
Donation' Immaculate' Friends(Collection box)
26-Feb-24
Donation
28-Feb-24
Donation Oracle Cancer Trust('Immaculate'
5-Mar-24
Stamps
28-Mar-24
Donation 'Margaret's Church Elder'
CLOSING BANK BALANCE ROW
Payment
Type		 MONEY IN
Details Income
Date Payment
Type		 Name Descripton Ref Xmas Party Donations Fundrasing Transfers Total Money Overheads
DO NOT DELETE THIS TOTALS ROW 80.67 4,376.43 740.87 2,292.02
5,197.97		 188.00
21-Apr-23 Thi Chi Instructor 0.00 50.00
21-Apr-23 Tea/Cofee Purchase s 0.00
21-Apr-23 Stamps 0.00
25-Apr-23 Tea Cofee Purchase s 0.00
26-Apr-23 Transfer of funds fro Current A/c now clos ed 2,292.02
2,292.02
27-Apr-23 Tea/Cakes Farnham Castle 0.00
4-May-23 Compensation Paym ent Bank non-closure A/c 25.00 25.00
1-Jul-23 Income from Fete 69.00 69.00
15-Jul-23 8 member tickets De nbies 0.00
9-Aug-23 Donation from mem ber 21.50 21.50
31-Aug-23 Donation to C Cofls 0.00
12-Sep-23 Payment Sandra Hos pital Chocs 0.00
15-Sep-24 Careprint Donation c hequeprint 0.00
20-Sep-24 Donation Cheque Be averbrook 1,800.00 1,800.00
6-Dec-24 Gift to Alan Baker 0.00
11-Dec-24 Stamps 0.00
11-Dec-24 Xmaspartysweets 0.00
11-Dec-24 Xmas PartyFood 0.00
11-Dec-24 School Fete Collectio n(Katie) 671.87 671.87
16-Jan-24 Xmas PartyPresents /Books(Me) 0.00
16-Apr-24 Xmas PartyHall hire + drinks 0.00 138.00
5-Feb-24 Donation topatient RJMatheson 0.00
5-Feb-24 Special committee M eetingCofee 0.00
9-Feb-24 Cofee for meetingw ith members 0.00
12-Feb-24 Stamps 0.00
14-Jan-24 Xmasparty 80.67 80.67
21-Feb-24 Biscuits,Shalford Me eting 0.00
23-Feb-24 Donation' Immaculat e' Friends(Collection box) 19.93 19.93
26-Feb-24 Donation 10.00 10.00
28-Feb-24 Donation Oracle Can cer Trust('Immacula te' 1,000.00 1,000.00
5-Mar-24 Stamps 0.00
28-Mar-24 Donation 'Margaret's Church Elder' 1,500.00 1,500.00
CLOSING BANK BALANCE ROW

MONEY OUT

MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT
Catering &
Outings		 Printing &
Postage		 Gifts Expense
Account 5		 Expense
Account 6		 Total Money
Out		 BANK
BALANCE		 R
268.64 94.17 269.79 0.00 0.00 820.60 6,435.11 Open ing Bank Balance
50.00 6,385.11
22.29 22.29 6,362.82
0.79 0.79 6,362.03
4.40 4.40 6,357.63
0.00 8,649.65
61.60 61.60 8,588.05
0.00 8,613.05
0.00 8,682.05
68.00 68.00 8,614.05
0.00 8,635.55
100.00 100.00 8,535.55
19.79 19.79 8,515.76
40.38 40.38 8,475.38
0.00 10,275.38
100.00 100.00 10,175.38
3.50 3.50 10,171.88
7.50 7.50 10,164.38
31.15 31.15 10,133.23
0.00 10,805.10
46.00 46.00 10,759.10
138.00 10,621.10
50.00 50.00 10,571.10
12.00 12.00 10,559.10
10.45 10.45 10,548.65
39.50 39.50 10,509.15
0.00 10,589.82
5.25 5.25 10,584.57
0.00 10,604.50
0.00 10,614.50
0.00 11,614.50
10.00 10.00 11,604.50
0.00 13,104.50
13,104.50 Clos ing Bank Balance

f

Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy
October
2022		 MONEY IN MONEYOUT R
BANK
BALANCE
Details Income
Date Payment
Type		 Name Descripton Ref Income
Account 1		 Income
Account 2		 Income
Account 3		 Income
Account 4		 Income
Account 5		 Income
Account 6		 Income
Account 7		 Total Money
In		 Expense
Account 1		 Expense
Account 2		 Expense
Account 3		 Expense
Account 4		 Expense
Account 5		 Expense
Account 6		 Expense
Account 7		 Expense
Account 8		 Expense
Account 9		 Expense
Account 10		 Expense
Account 11		 Expense
Account 12		 Expense
Account 13		 Expense
Account 14		 Expense
Account 15		 Expense
Account 16		 Expense
Account 17		 Expense
Account 18		 Expense
Account 19		 Expense
Account 20		 Total Money
Out		 BANK
BALANCE		 R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13,104.50 Ope ning Bank Balance
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
CLOSING BANK BALANCE ROW 13,104.50 Clos ing Bank Balance
Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Enter Your Business Name Here Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy
November
2022		 MONEY IN MONEYOUT R
BANK
BALANCE
Details Income
Date Payment
Type		 Name Descripton Ref Income
Account 1		 Income
Account 2		 Income
Account 3		 Income
Account 4		 Income
Account 5		 Income
Account 6		 Income
Account 7		 Total Money
In		 Expense
Account 1		 Expense
Account 2		 Expense
Account 3		 Expense
Account 4		 Expense
Account 5		 Expense
Account 6		 Expense
Account 7		 Expense
Account 8		 Expense
Account 9		 Expense
Account 10		 Expense
Account 11		 Expense
Account 12		 Expense
Account 13		 Expense
Account 14		 Expense
Account 15		 Expense
Account 16		 Expense
Account 17		 Expense
Account 18		 Expense
Account 19		 Expense
Account 20		 Total Money
Out		 BANK
BALANCE		 R
DO NOT DELETE THIS TOTALS ROW 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13,104.50 Ope ning Bank Balance
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
0.00 0.00 13,104.50
CLOSING BANK BALANCE ROW 13,104.50 Clos ing Bank Balance

Enter Your Business Name Here

December 2022

Details
Date Payment
Type		 Name Descripton Ref
DO NOT DELETE THIS TOTALS ROW

Excel Cashbook Easy

MONEY IN MONEY IN MONEY IN
Income
Income Income Income Income Income Income Income
Account 1 Account 2 Account 3 Account 4 Account 5 Account 6 Account 7
0.00 0.00 0.00 0.00 0.00 0.00 0.00

CLOSING BANK BALANCE ROW

MONEY OUT

MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT MONEY OUT
Total Money
In		 Expense
Account 1		 Expense
Account 2		 Expense
Account 3		 Expense
Account 4		 Expense
Account 5		 Expense
Account 6		 Expense
Account 7		 Expense
Account 8		 Expense
Account 9		 Expense
Account 10		 Expense
Account 11		 Expense
Account 12
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Expense
Account 13		 Expense
Account 14		 Expense
Account 15		 Expense
Account 16		 Expense
Account 17		 Expense
Account 18		 Expense
Account 19		 Expense
Account 20		 Total Money
Out		 BANK
BALANCE		 R
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13,104.50 Open ing Bank Balance
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50 13,104.50

0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
0.00 13,104.50
13,104.50 Clos ing Bank Balance

FINAL BALANCE FOR THE YEAR

START A NEW CASHBOOK FOR THE NEW FINANCIAL YEAR

Profit and Loss Statement [Summary of all Income and Expenses]

Excel Cashbook Easy

Enter Your Business Name Here

In 2022 Month1
Month2
Month3
Month4
Month5
Month6
Month7
Month8
Month9
Month10
Month11
Month12
January
February
March
April
May
June
July
August
September
October
November
December		 YTD
YTD

235.67

6,193.00

2,673.98

5,292.02

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

1,551.49

1,675.91

707.76

876.79

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

Total YTD
 YTD
YTD

235.67

6,193.00

2,673.98

5,292.02

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

1,551.49

1,675.91

707.76

876.79

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

Total YTD
come
Income Account 1 0.00
155.00
0.00
0.00
0.00
0.00
0.00
0.00
80.67
0.00
0.00
0.00		 235.67
Income Account 2 1,250.00
566.57
0.00
0.00
0.00
0.00
0.00
0.00
4,376.43
0.00
0.00
0.00		 6,193.00
Income Account 3 1,010.88
922.23
0.00
0.00
0.00
0.00
0.00
0.00
740.87
0.00
0.00
0.00		 2,673.98
Income Account 4 3,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2,292.02
0.00
0.00
0.00		 5,292.02
Income Account 5 #NAME?
0.00
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Income Account 6 #NAME?
0.00
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Income Account 7 #NAME?
0.00
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
1,643.80
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?

#NAME?
Total Income
Gross Profit #NAME?
1,643.80
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expenses
Expense Account 1 175.99
1,187.50
0.00
0.00
0.00
0.00
0.00
0.00
188.00
0.00
0.00
0.00		 1,551.49
Expense Account 2 116.95
1,290.32
0.00
0.00
0.00
0.00
0.00
0.00
268.64
0.00
0.00
0.00		 1,675.91
Expense Account 3 99.83
513.76
0.00
0.00
0.00
0.00
0.00
0.00
94.17
0.00
0.00
0.00		 707.76
Expense Account 4 565.00
42.00
0.00
0.00
0.00
0.00
0.00
0.00
269.79
0.00
0.00
0.00		 876.79
Expense Account 5 #NAME?
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00		 #NAME?
Expense Account 6 #NAME?
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00		 #NAME?
Expense Account 7 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 8 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 9 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 10 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 11 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 12 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 13 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 14 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 15 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 16 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 17 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 18 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 19 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
Expense Account 20 #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?

#NAME?
Total Expenses
Net Profit/(Loss) #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?
(Gross Profit less Expenses) January
February
March
April
May
June
July
August
September
October
November
December
Month1
Month2
Month3
Month4
Month5
Month6
Month7
Month8
Month9
Month10
Month11
Month12
ADJUSTMENTS ould be on a Balance Sheet, you can exclude them from this P&L Report. Enter them into the schedule below to get your true profit or ask your Professionl Bookkeeper or Accountant to prepare a Balance Sheet and adjust yo
January
February
March
April
May
June
July
August
September
October
November
December		 ur income statement

Total YTD
0.00
0.00
0.00
0.00
0.00
0.00
If your income or expenses include items that sh
Personal Expenses 0.00
Personal MoneyDeposited 0.00
Loans Received 0.00
Loan Repayments 0.00
Asset Purchases 0.00
Tax Payments(Income, Payroll, Sales Tax) 0.00
True Net Profit/(Loss) #NAME?
#NAME?
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00		 #NAME?

Excel Cashbook Easy

RECONCILIATION WORKSHEET

----- Start of picture text -----
Outstanding Withdrawals Outstanding Deposits
Example Check 0001 50.00 Example Deposit 10001 120.00
Total A 50.00 Total B 120.00
Enter any payments you have received
Enter any payments you made that are
that are not showing on the bank
not showing on the bank statement
statement
Closing Cash Book Balance enter the closing balance of the last day of the month from this Cashbook
Add: Outstanding Withdrawals (Total A) 50.00
Sub-total 50.00
Less: Outstanding Deposits (Total B) 120.00
Expected Bank Statement Balance -70.00
Actual Bank Statement Balance enter the closing balance of last day of month from Bank Statement
Difference -70.00 This should be 0.00. If not, double check all your entries
----- End of picture text -----

----- Start of picture text -----
You can delete or type over the examples
----- End of picture text -----

This worksheet is not linked to any other worksheets

Use this worksheet to Reconcile your Cashbook to the Bank Balance each month. When a month is complete, print this out or PDF it before re-entering data for the next month. You only have to use this reconciliation if you issue or receive checks/cheques or cash that take a few days to show up on the bank account.