rincewind2019
New Member
- Joined
- Jan 29, 2019
- Messages
- 23
Hi I am trying to put together a simple cash book to run from month to month. Does anyone know what formulas I will need to put into columns J & K to calculate row 3 to 9. I have gotten so far but I am having trouble with rows 8 & 9.
Thank you.
<colgroup><col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 877;">
<col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;">
<col width="152" style="width: 114pt; mso-width-source: userset; mso-width-alt: 5558;">
<col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;">
<col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;">
<col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;">
<col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;">
<col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;">
<col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;">
<col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;">
<col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<tbody>
</tbody>
Thank you.
a | b | c | d | e | f | g | h | i | j | k | |
1 | Income | Expenditure | Bank | ||||||||
2 | Date | Description | Rec No | Income | F1 | Expenditure | CHQ No | Deposits | Withdrawals | Balance | Cash |
3 | 01/01/2019 | B/F | | £100.00 | £10.00 | ||||||
4 | 02/01/2019 | Cash Income | 1 | £20.00 | £100.00 | £30.00 | |||||
5 | 03/01/2019 | Cash Expenditure | 1 | £10.00 | £100.00 | £20.00 | |||||
6 | 04/01/2019 | Cheque Expenditure | 2 | £10.00 | 1 | £10.00 | £90.00 | £20.00 | |||
7 | 05/01/2019 | Cheque Income | 2 | £20.00 | £20.00 | £110.00 | £20.00 | ||||
8 | 06/01/2019 | Cash to Bank | £10.00 | £120.00 | £10.00 | ||||||
9 | 07/01/2019 | Bank to Cash | £20.00 | £100.00 | £30.00 |