Spreadsheet: 57133d1257285828-data-file-to-file-indirect-budget-formulas
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 |  |  | Stationary, Printing, Menus, [NAME]
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 |  |  | 5
 | Suppliier |  | 6.4 | 0 | (2) [NAME]           DD |  |  | 6
 |  |  | 0 | 0 | (3) Postage |  |  | 7
 |  |  | 0 | 0 | (4) Stationary, Printing, Menus, [NAME] |  |  |  | 8
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0 | Motor Expenses    (1) fuel |  |  | 1
 |  |  | 0 | 0 | (2) Repairs |  |  | 2
 |  |  | 0 | 0 | (3) MOT, Ins, Tax |  |  |  | 3
 |  |  | 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 | 467 | 93
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) |  | 93 |  |  | Other payments (Col11) |  | 467
 | Standing orders |  | 0 |  |  | Amount Paid to bank (Col 8) |  | 300
 | Direct debits |  | 0 |  |  | Bacs payments |  | 0
 | Bank & interest charges |  | 0 |  |  |  |  | Total Deductions | 1089.68
 | Total |  |  | 93 |  | Cash Balance as per weekly page |  |  | 803
 | Week one |  |  | 207 |  | Cash in hand (as counted) [NAME] fwd |  |  | 803
 | VAT Account |  |  | 0 |  | Difference on books if any + or - |  |  | 0