Spreadsheet: 94767d1294529755-hiding-value-tlcsample
Sheet: Purchases

Ctrl+Shift+E |  | 0 | <<<Check Total | Next Job no |  | Total for Month |  | 265.88 | 39.59212765957447 | 226.2878723404255 | For your information only. Enter How Paid e.g. Cash, Cheque etc., | 265.88 | 0 | 2011-01-08 00:00:00 | 194.7744680851064 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15.59 | 0 | 15.92340425531915 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Purchase Ledger No | Month | Purchase Date | [NAME] | 122 |  | Purchase Description | Enter Expense Code Letter | Total Purchase Value incl [NAME] | 17.5 | Purchases           Net of Vat |  | Payments Made to Creditors |  |  | Purchases Cost of Sales |  |  | Directors Wages         Non Paye | Employee Wages        Non Paye | Premises |  | Distribution Transport Costs | Equipment Tools & Plant Hire | Repairs & Maintenance | Consumable Materials | Advertising &  Promotion | Telephone Postage & Stationery | Travel & Hotel Expenses | Motor Vehicle Expenses | Insurance Costs | Leasing Charges | Bank Charges & Interest | Charitable Donations | Goodwill | Fixed Asset Purchases |  | Contractors
 |  |  |  | Job No | Invoiced Verbal |  |  |  | [NAME] |  |  | Actual Amount Paid | Purchases not yet paid | Purchases Days Outstanding | Direct Materials | Sub Contractors | Other Direct Costs |  |  | Rent & Rates | Light & Heating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIS Certificates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | C | O | D | W | R | P | F | Q | M | U | A | G | H | V | N | T | L | Y | Z | FA |  | Tax Paid | Certificate No
10/001 | 2010-09-24 00:00:00 | 2010-09-24 00:00:00 | Ballcock and bits | 115 | Invoiced |  | S | 5.41 | 0.8057446808510638 | 4.604255319148937 |  | 5.41 | 0 |  | 4.604255319148937
10/002 | 2010-09-24 00:00:00 | 2010-09-24 00:00:00 | Ballcock and bits | 115 | Invoiced |  | S | 8.03 | 1.19595744680851 | 6.834042553191489 |  | 8.03 | 0 |  | 6.834042553191489
10/003 | 2010-09-24 00:00:00 | 2010-09-24 00:00:00 | Ballcock and bits | 115 | Invoiced |  | S | 1.35 | 0.2010638297872341 | 1.148936170212766 |  | 1.35 | 0 |  | 1.148936170212766
10/004 | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | Ballcock and bits | 115 | Invoiced |  | S | 46.69 | 6.953829787234042 | 39.73617021276596 |  | 46.69 | 0 |  | 39.73617021276596
10/005 | 2010-09-24 00:00:00 | 2010-09-24 00:00:00 | Ballcock and bits | 115 | Invoiced |  | S | 5.64 | 0.8399999999999999 | 4.8 |  | 5.64 | 0 |  | 4.8
10/006 | 2010-09-26 00:00:00 | 2010-09-26 00:00:00 | Wickes | 115 | Invoiced |  | S | 13.99 | 2.083617021276596 | 11.9063829787234 |  | 13.99 | 0 |  | 11.9063829787234
10/007 | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | JK Bathrooms | 115 | Invoiced |  | S | 4.11 | 0.6121276595744681 | 3.497872340425532 |  | 4.11 | 0 |  | 3.497872340425532
10/008 | 2010-12-08 00:00:00 | 2010-12-08 00:00:00 | Ballcock and bits |  |  |  | U | 11.23 | 1.672553191489362 | 9.557446808510639 |  | 11.23 | 0 |  |  |  |  |  |  |  |  |  |  |  | 9.557446808510639
10/009 | 2010-12-24 00:00:00 | 2010-12-24 00:00:00 | Sainsburys |  |  |  | U | 7.48 | 1.114042553191489 | 6.365957446808511 |  | 7.48 | 0 |  |  |  |  |  |  |  |  |  |  |  | 6.365957446808511
10/010 | 2010-12-22 00:00:00 | 2010-12-22 00:00:00 | Ballcock and bits | 120 |  |  | S | 143.64 | 21.3931914893617 | 122.2468085106383 | DD | 143.64 | 0 |  | 122.2468085106383
10/011 | 2010-12-22 00:00:00 | 2010-12-22 00:00:00 | Ballcock and bits | 120 |  |  | Q | 18.31 | 2.72 | 15.59 | DD | 18.31 | 0 |  |  |  |  |  |  |  |  |  | 15.59
10/012
10/013
10/014
10/015
10/016
10/017
10/018
10/019
10/020
10/021
10/022
10/023
10/024
10/025
10/026
10/027
10/028
10/029
10/030
10/031
10/032
10/033
10/034
10/035
10/036
10/037
10/038
10/039
10/040
10/041
10/042
10/043
10/044
10/045
 |  |  |  |  |  |  | Subtotals | 265.88 | 39.59212765957447 | 226.2878723404255 |  | 265.88 | 0