Spreadsheet: 57097d1257268333-data-file-to-file-my-simple-example-for-my-simple-brain
Sheet: Sheet1

Week No |  | 1
Date Commencing |  | 2008-10-27 00:00:00
 | Daily Gross Takings |  | Receipts |  |  | Paid to Bank
Day/Date | Cash Column 1 | Cheques  Column 2 | Other Rcpts Column 3 | Particulars of others Rcpts |  | Cash              Column 5 | Cheques Column 6 | [NAME] Column 7 | TOTAL Column 8
2008-10-27 00:00:00 | 143.58 |  | 0 |  |  | 0 | 0 | 0 | 0
2008-10-28 00:00:00 | 122.4 | 0 | 0 |  |  | 0 | 0 | 0 | 0
2008-10-29 00:00:00 | 144 | 0 | 0 |  |  | 0 | 0 | 0 | 0
2008-10-30 00:00:00 | 146.15 | 0 | 0 |  |  | 300 | 0 | 0 | 300
2008-10-31 00:00:00 | 104.55 | 0 | 0 |  |  |  |  | 0 | 0
2008-11-01 00:00:00
2008-11-02 00:00:00
Sub Totals | 660.68 | 0 | 0 | Total                           Totals |  | 300 | 0 | 0 | 300
Gross wkly take Cols 1+2 |  | 660.68 | 0 | $ [NAME]
Payments for business stock |  |  |  |  | Payments other than stock
Date or Chq No | To whom paid |  | Amount Paid |  | Nature of Payment |  |  | Amount Paid
 |  |  | Cash Column 9 | Cheque Column 10 |  |  |  | Cash Column 11 | Cheque Column 12
 | Suppliier |  | 41.99 | 0 | Employee costs   (1) Wages |  |  | 146 | 0
 | Suppliier |  |  | 0 |  |  |  |  | 0
 | Suppliier |  | 67.29 | 0 | Premises costs   (1) Rent |  |  | 100
 | Suppliier |  | 107.55 | 0 | (2) Rates              DD |  |  | 100
 | Suppliier |  | 13.2 | 0 | (3) Electricity        DD |  |  | 100
 | Suppliier |  |  | 0 | (4) Cleaning |  |  |  | 35
 | Suppliier |  | 42 | 0 | (5) Repairs |  |  |  | 2
 | Suppliier |  | 41.07 |  | (6) Insurance        DD |  |  |  | 45
 | Suppliier |  |  | 0
 | Suppliier |  |  | 0
 | Suppliier |  |  | 0
 | Suppliier |  |  | 0
 | Suppliier |  | 1.59 | 0
 | Suppliier |  | 1.59 | 0 | [NAME]  (1) Shop Telephone      DD
 | Suppliier |  | 6.4 | 0 | (2) [NAME]           DD
 |  |  | 0 | 0 | (3) Postage
 |  |  | 0 | 0 | (4) Stationary, Printing, Menus, [NAME]
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0 | Motor Expenses    (1) fuel
 |  |  | 0 | 0 | (2) Repairs
 |  |  | 0 | 0 | (3) MOT, Ins, Tax
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0 | Customs & Excise (VAT)
 | Totals |  | 322.6799999999999 | 0 | Drawings of proprietor
 |  |  | è | 322.6799999999999 | Capital items |  |  | 0
Total payments (to Summary) |  |  |  | 322.6799999999999 |  |  | Totals | 446 | 82
Weekly bank report |  |  |  |  | Weekly Cash Report
Add | Opening balance from last YEAR |  |  |  | Add | Cash in hand (as counted) b/fwd last YEAR |  |  | 1232
 | Total paid to bank last week (Col 8) |  |  | 300 |  | Gross weekly takings (Col 1 + Col 2) |  |  | 660.68
 | Start up allowance/other direct charges |  |  | 0 |  | Other receipts [NAME]) |  |  | 0
 | Bacs Reciepts |  |  | 0 |  | Cash drawn from bank for office use |  |  | 0
 |  |  | Total | 300 |  | Bacs Reciepts |  |  | 0
Deduct | Cash for office use |  | 0 |  |  |  |  | Total | 1892.68
 | Stock Chqs only (Col 10) |  | 0 |  | Deduct | Stock payments (Col 9) |  | 322.6799999999999
 | Other payments (Col12) |  | 82 |  |  | Other payments (Col11) |  | 446
 | Standing orders |  | 0 |  |  | Amount Paid to bank (Col 8) |  | 300
 | Direct debits |  | 0 |  |  | Bacs payments |  | 0
 | Bank & interest charges |  | 0 |  |  |  |  | Total Deductions | 1068.68
 | Total |  |  | 82 |  | Cash Balance as per weekly page |  |  | 824
 | Week one |  |  | 218 |  | Cash in hand (as counted) [NAME] fwd |  |  | 824
 | VAT Account |  |  | 0 |  | Difference on books if any + or - |  |  | 0