Spreadsheet: 288645d1389266646-formula-correction-sales-2013-2014-kym-edit
Sheet: June 2013

 | Invoice Date | Clients Name | Code | Invoice No | Net | VAT | Gross | Date Paid | Total Paid | MOP |  | Total Net |  |  | Company Totals (Net)
 | 2013-06-07 00:00:00 | Client 1 | DTZC/093 | 001513 | 1061.64 | 212.33 |  | 2013-08-22 00:00:00 | 1273.97 | Bacs |  | Total VAT |  |  | DTZ
 | 2013-06-07 00:00:00 | Client 2 | WPA/008 | 001514 | 352.6 | 70.52 |  | 2013-08-22 00:00:00 | 423.12 | Bacs |  | Total Gross |  |  | Wonderland WPA
 | 2013-06-07 00:00:00 | Client 3 | SST/010 | 001515 | 2187.66 | 437.53 |  | 2013-09-12 00:00:00 | 2625.19 | Bacs |  | Total Paid |  |  | Skillset
 | 2013-06-07 00:00:00 | Client 4 | ECP/013 | 001516 | 117.7 | 23.54 |  | 2013-07-05 00:00:00 | 141.24 | Bacs |  | Total Bad Debt |  |  | Euro Commercial Properties Ltd
 | 2013-06-07 00:00:00 | Client 5 | ARR/001 | 001517 | 1601.24 | 320.25 |  | 2013-07-18 00:00:00 | 1921.49 | Bacs |  |  |  |  | Arriva PLC
 | 2013-06-07 00:00:00 | Client 6 | ILA/976 | 001518 | 134.2 | 26.84 |  | 2013-07-05 00:00:00 | 161.4 | Bacs |  |  |  |  | ILA
 | 2013-06-07 00:00:00 | Client 7 | NAD/012 | 001519 | 925.6 | 185.12 |  | 2013-07-09 00:00:00 | 1110.72 | Bacs |  |  |  |  | Nadfas
 | 2013-06-07 00:00:00 | Client 8 | ATO/022 | 001520 | 2113.2 | 422.64 |  | 2013-07-03 00:00:00 | 2535.84 | Bacs |  |  |  |  | Atomico
 | 2013-06-07 00:00:00 | Client 9 | DPO/011 | 001521 | 120 | 24 |  | 2013-07-18 00:00:00 | 144 | Bacs |  |  |  |  | Dragon Properties
 | 2013-06-07 00:00:00 | Client 10 | DPO/011 | 001522 | 212 | 42.2 |  | 2013-07-18 00:00:00 | 254.2 | Bacs |  |  |  |  | St Davids Property Management
 | 2013-06-07 00:00:00 | Client 11 | CBP/007 | 001523 | 350 | 70 |  | 2013-09-06 00:00:00 | 420 | Bacs |  |  |  |  | CPB
 | 2013-06-21 00:00:00 | Client 12 | CE/1144 | 001524 | 5446.02 | 1089.2 |  | 2013-09-03 00:00:00 | 6535.22 | Bacs |  |  |  |  | Cheil Europe
 | 2013-06-21 00:00:00 | Client 12 | EMU/024 | 001525 | 528.6 | 105.72 |  | 2013-07-25 00:00:00 | 634.32 | Bacs |  |  |  |  | Emu Australia
 | 2013-06-21 00:00:00 | Client 13 | COL/006 | 001526 | 105 | 21 |  | 2013-07-03 00:00:00 | 126 | Bacs |  |  |  |  | Codean Ltd
 | 2013-06-21 00:00:00 | Client 14 | TCG/0211 | 001527 | 650 | 130 |  | 2013-08-01 00:00:00 | 780 | Bacs |  |  |  |  | Thales Corporate Services
 | 2013-06-21 00:00:00 | Client 15 | WAF/044 | 001528 | 1279.3 | 255.86 |  | 2013-09-05 00:00:00 | 1535.16 | Bacs |  |  |  |  | We Are Friday
 | 2013-06-21 00:00:00 | Client 16 | TPC/502 | 001529 | 48 | 9.6 |  | 2013-07-23 00:00:00 | 57.6 | CQ011414 |  |  |  |  | Robshaw TPC Group Ltd
 | 2013-06-30 00:00:00 | Client 17 | FFCH/614 | 001530 | 1504.6 | 300.92 |  | 2013-07-23 00:00:00 | 1805.52 | Bacs |  |  |  |  | Farfetch
 | 2013-06-30 00:00:00 | Client 18 | Mov/224 | 001531 | 450 | 90 |  | 2013-07-30 00:00:00 | 540 | Bacs |  |  |  |  | Movement
 | 2013-06-30 00:00:00 | Client 19 | BAM/021 | 001532 | 310 | 62 |  | 2013-09-16 00:00:00 | 372 | CQ531790 |  |  |  |  | BAM
 | 2013-06-30 00:00:00 | Client 20 | Levy/015 | 001533 | 153 | 30.6 |  | 2013-08-01 00:00:00 | 183.6 | Bacs |  |  |  |  | D E & J Levy
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001534 | 162 | 32.4 |  | 2013-08-01 00:00:00 | 194.4 | Bacs |  |  |  |  | Art Review
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001535 | 98 | 19.6 |  | 2013-08-01 00:00:00 | 117.6 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001536 | 208 | 41.6 |  | 2013-08-01 00:00:00 | 249.6 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001537 | 248 | 49.6 |  | 2013-08-01 00:00:00 | 297.6 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001538 | 54 | 10.8 |  | 2013-08-01 00:00:00 | 64.8 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001539 | 74 | 14.8
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001540 | 60 | 12 |  | 2013-08-01 00:00:00 | 72 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001541 | 166 | 33.2 |  | 2013-08-01 00:00:00 | 199.2 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001542 | 70 | 14 |  | 2013-08-01 00:00:00 | 84 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001543 | 46 | 9.2 |  | 2013-08-01 00:00:00 | 55.2 | Bacs
 | 2013-06-30 00:00:00 | Client 21 | Levy/015 | 001544 | 203 | 40.6 |  | 2013-08-23 00:00:00 | 243.6 | Bacs
 | 2013-06-28 00:00:00 | Client 22 | [NAME] | 001545 | 45 | 9 |  | 2013-09-05 00:00:00 | 54 | Bacs