Spreadsheet: 63048d1264011374-sumproduct-test
Sheet: Sheet1

 | Paying
Jan
Feb | 0
Mar | 0
Apr | 0
May | 0
June | 0
July | 0
Aug | 0
Sept | 0
Oct | 0
Nov | 0
Dec | 0
 | Date Issued | Transaction Type | Payable to or [NAME] From | Chq # | CC Date | Amount Paid | Amount Recd | Recon'd
 | 1st January | Cheque Deposit | Allianz - Cornhill | 11 | 22nd September | 1111 | 5890.42 | Yes
 | 22nd September | Commission from Insurer(Name Pls) | Property Risk Mangement | 12
 |  |  |  | 13
 |  |  |  | 26
 |  |  |  | 23
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 22
 |  |  |  | 19
 | 1st January | Cheque Deposit | Allianz - Cornhill |  | 1st January |  |  | Yes
 | 2nd January | Cheque Payable to Insurer |  |  | 2nd January
 | 3rd January | Commission from Insurer(Name Pls) | [NAME] |  | 3rd January
 | 4th January | Credit Interest |  |  | 4th January
 | 5th January | DD HSBC CC Charges | Allianz |  | 5th January
 | 6th January | DD To Broker Direct PLC |  |  | 6th January
 | 7th January | [NAME]: Premium Credit | [NAME] |  | 7th January
 | 8th January | [NAME]:Duality-E (enter date) |  |  | 8th January
 | 9th January | [NAME]:Maestr-E (enter date) | Anglo APC |  | 9th January
 | 10th January | Service Fee |  |  | 10th January
 | 11th January | Transfer From Client( Name Pls) | AUL - Towergate |  | 11th January
 | 12th January | Transfer to Account 54132587 |  |  | 12th January
 | 13th January | Transfer to Account 54132642 | Aviva - Norwich Union |  | 13th January
 | 14th January | [NAME] |  |  | 14th January
 | 15th January |  | AXA |  | 15th January
 | 16th January |  |  |  | 16th January
 | 17th January |  | Brit Insurance |  | 17th January
 | 18th January |  |  |  | 18th January
 | 19th January |  | Broker Direct |  | 19th January
 | 20th January |  |  |  | 20th January
 | 21st January |  | C E Heath |  | 21st January
 | 22nd January |  |  |  | 22nd January
 | 23rd January |  | Capita |  | 23rd January
 | 24th January |  |  |  | 24th January
 | 25th January |  | Chaucer |  | 25th January
 | 26th January |  |  |  | 26th January
 | 27th January |  | City Bond Travel |  | 27th January
 | 28th January |  |  |  | 28th January
 | 29th January |  | Composite Assistance |  | 29th January
 | 30th January |  |  |  | 30th January
 | 31st January |  | Cong & General |  | 31st January
 | 1st February |  |  |  | 1st February
 | 2nd February |  | Courier Plan |  | 2nd February
 | 3rd February |  |  |  | 3rd February
 | 4th February |  | Eccesiastical Insurance |  | 4th February
 | 5th February |  |  |  | 5th February
 | 6th February |  | Electrical Contractors |  | 6th February
 | 7th February |  |  |  | 7th February
 | 8th February |  | Entertainment & Leisure |  | 8th February
 | 9th February |  |  |  | 9th February
 | 10th February |  | Equity Red Star |  | 10th February
 | 11th February |  |  |  | 11th February
 | 12th February |  | Europa |  | 12th February
 | 13th February |  |  |  | 13th February
 | 14th February |  | Event Insurance |  | 14th February
 | 15th February |  |  |  | 15th February
 | 16th February |  | Facilitas |  | 16th February
 | 17th February |  |  |  | 17th February
 | 18th February |  | Fortis Insurance |  | 18th February
 | 19th February |  |  |  | 19th February
 | 20th February |  | [NAME] |  | 20th February
 | 21st February |  |  |  | 21st February
 | 22nd February |  | Hastings Direct |  | 22nd February
 | 23rd February |  |  |  | 23rd February
 | 24th February |  | Highway |  | 24th February
 | 25th February |  |  |  | 25th February
 | 26th February |  | Home & Legacy |  | 26th February
 | 27th February |  |  |  | 27th February
 | 28th February |  | HSB |  | 28th February
 | 1st March |  |  |  | 1st March
 | 2nd March |  | HSBC - Corinthian |  | 2nd March
 | 3rd March |  |  |  | 3rd March
 | 4th March |  | HSBC - Milestone |  | 4th March
 | 5th March |  |  |  | 5th March
 | 6th March |  | HSBC - PI |  | 6th March
 | 7th March |  |  |  | 7th March
 | 8th March |  | HSBC - Regency |  | 8th March
 | 9th March |  |  |  | 9th March
 | 10th March |  | HSBC Brokers |  | 10th March
 | 11th March |  |  |  | 11th March
 | 12th March |  | IPrism |  | 12th March
 | 13th March |  |  |  | 13th March
 | 14th March |  | KGM Insurance |  | 14th March
 | 15th March |  |  |  | 15th March
 | 16th March |  | Lancaster Insurance |  | 16th March
 | 17th March |  |  |  | 17th March
 | 18th March |  | Liverpool Victoria |  | 18th March
 | 19th March |  |  |  | 19th March
 | 20th March |  | [NAME] |  | 20th March
 | 21st March |  |  |  | 21st March
 | 22nd March |  | Minibus Plus |  | 22nd March
 | 23rd March |  |  |  | 23rd March
 | 24th March |  | Miscellaneous |  | 24th March
 | 25th March |  |  |  | 25th March
 | 26th March |  | MMA Insurance |  | 26th March
 | 27th March |  |  |  | 27th March
 | 28th March |  | Moorhouse |  | 28th March
 | 29th March |  |  |  | 29th March
 | 30th March |  | NIG |  | 30th March
 | 31st March |  |  |  | 31st March
 | 1st April |  | Noble Marine |  | 1st April
 | 2nd April |  |  |  | 2nd April
 | 3rd April |  | Paragon |  | 3rd April
 | 4th April |  |  |  | 4th April
 | 5th April |  | Prestige |  | 5th April
 | 6th April |  |  |  | 6th April
 | 7th April |  | Property Risk Mangement |  | 7th April
 | 8th April |  |  |  | 8th April
 | 9th April |  | Provident |  | 9th April
 | 10th April |  |  |  | 10th April
 | 11th April |  | Quinn |  | 11th April
 | 12th April |  |  |  | 12th April
 | 13th April |  | Royal SunAlliance |  | 13th April
 | 14th April |  |  |  | 14th April
 | 15th April |  | Sabre |  | 15th April
 | 16th April |  |  |  | 16th April
 | 17th April |  | Spectrum |  | 17th April
 | 18th April |  |  |  | 18th April
 | 19th April |  | Towergate |  | 19th April
 | 20th April |  |  |  | 20th April
 | 21st April |  | Tradex |  | 21st April
 | 22nd April |  |  |  | 22nd April
 | 23rd April |  | Travellers |  | 23rd April
 | 24th April |  |  |  | 24th April
 | 25th April |  | X Broker |  | 25th April
 | 26th April |  |  |  | 26th April
 | 27th April |  | [NAME] |  | 27th April
 | 28th April |  |  |  | 28th April
 | 29th April |  | Zenith |  | 29th April
 | 30th April |  |  |  | 30th April
 | 1st May |  | Zurich |  | 1st May
 | 2nd May |  |  |  | 2nd May
 | 3rd May |  |  |  | 3rd May
 | 4th May |  |  |  | 4th May
 | 5th May |  |  |  | 5th May
 | 6th May |  |  |  | 6th May
 | 7th May |  |  |  | 7th May
 | 8th May |  |  |  | 8th May
 | 9th May |  |  |  | 9th May
 | 10th May |  |  |  | 10th May
 | 11th May |  |  |  | 11th May
 | 12th May |  |  |  | 12th May
 | 13th May |  |  |  | 13th May
 | 14th May |  |  |  | 14th May
 | 15th May |  |  |  | 15th May
 | 16th May |  |  |  | 16th May
 | 17th May |  |  |  | 17th May
 | 18th May |  |  |  | 18th May
 | 19th May |  |  |  | 19th May
 | 20th May |  |  |  | 20th May
 | 21st May |  |  |  | 21st May
 | 22nd May |  |  |  | 22nd May
 | 23rd May |  |  |  | 23rd May
 | 24th May |  |  |  | 24th May
 | 25th May |  |  |  | 25th May
 | [NAME] |  |  |  | [NAME]
 | 27th May |  |  |  | 27th May
 | 28th May |  |  |  | 28th May
 | 29th May |  |  |  | 29th May
 | 30th May |  |  |  | 30th May
 | 31st May |  |  |  | 31st May
 | 1st June |  |  |  | 1st June
 | 2nd June |  |  |  | 2nd June
 | 3rd June |  |  |  | 3rd June
 | 4th June |  |  |  | 4th June
 | 5th June |  |  |  | 5th June
 | 6th June |  |  |  | 6th June
 | 7th June |  |  |  | 7th June
 | 8th June |  |  |  | 8th June
 | 9th June |  |  |  | 9th June
 | 10th June |  |  |  | 10th June
 | 11th June |  |  |  | 11th June
 | 12th June |  |  |  | 12th June
 | 13th June |  |  |  | 13th June
 | 14th June |  |  |  | 14th June
 | 15th June |  |  |  | 15th June
 | 16th June |  |  |  | 16th June
 | 17th June |  |  |  | 17th June
 | 18th June |  |  |  | 18th June
 | 19th June |  |  |  | 19th June
 | 20th June |  |  |  | 20th June
 | 21st June |  |  |  | 21st June
 | 22nd June |  |  |  | 22nd June
 | 23rd June |  |  |  | 23rd June
 | 24th June |  |  |  | 24th June
 | 25th June |  |  |  | 25th June
 | 26th June |  |  |  | 26th June
 | 27th June |  |  |  | 27th June
 | 28th June |  |  |  | 28th June
 | 29th June |  |  |  | 29th June
 | 30th June |  |  |  | 30th June
 | 1st July |  |  |  | 1st July
 | 2nd July |  |  |  | 2nd July
 | 3rd July |  |  |  | 3rd July
 | 4th July |  |  |  | 4th July
 | 5th July |  |  |  | 5th July
 | 6th July |  |  |  | 6th July
 | 7th July |  |  |  | 7th July
 | 8th July |  |  |  | 8th July
 | 9th July |  |  |  | 9th July
 | 10th July |  |  |  | 10th July
 | 11th July |  |  |  | 11th July
 | 12th July |  |  |  | 12th July
 | 13th July |  |  |  | 13th July
 | 14th July |  |  |  | 14th July
 | 15th July |  |  |  | 15th July
 | 16th July |  |  |  | 16th July
 | 17th July |  |  |  | 17th July
 | 18th July |  |  |  | 18th July
 | 19th July |  |  |  | 19th July
 | 20th July |  |  |  | 20th July
 | 21st July |  |  |  | 21st July
 | 22nd July |  |  |  | 22nd July
 | 23rd July |  |  |  | 23rd July
 | 24th July |  |  |  | 24th July
 | 25th July |  |  |  | 25th July
 | 26th July |  |  |  | 26th July
 | 27th July |  |  |  | 27th July
 | 28th July |  |  |  | 28th July
 | 29th July |  |  |  | 29th July
 | 30th July |  |  |  | 30th July
 | 31st July |  |  |  | 31st July
 | 1st August |  |  |  | 1st August
 | 2nd August |  |  |  | 2nd August
 | 3rd August |  |  |  | 3rd August
 | 4th August |  |  |  | 4th August
 | 5th August |  |  |  | 5th August
 | 6th August |  |  |  | 6th August
 | 7th August |  |  |  | 7th August
 | 8th August |  |  |  | 8th August
 | 9th August |  |  |  | 9th August
 | 10th August |  |  |  | 10th August
 | 11th August |  |  |  | 11th August
 | 12th August |  |  |  | 12th August
 | 13th August |  |  |  | 13th August
 | 14th August |  |  |  | 14th August
 | 15th August |  |  |  | 15th August
 | 16th August |  |  |  | 16th August
 | 17th August |  |  |  | 17th August
 | 18th August |  |  |  | 18th August
 | 19th August |  |  |  | 19th August
 | 20th August |  |  |  | 20th August
 | 21st August |  |  |  | 21st August
 | 22nd August |  |  |  | 22nd August
 | 23rd August |  |  |  | 23rd August
 | 24th August |  |  |  | 24th August
 | 25th August |  |  |  | 25th August
 | 26th August |  |  |  | 26th August
 | 27th August |  |  |  | 27th August
 | 28th August |  |  |  | 28th August
 | 29th August |  |  |  | 29th August
 | 30th August |  |  |  | 30th August
 | 31st August |  |  |  | 31st August
 | 1st September |  |  |  | 1st September
 | 2nd September |  |  |  | 2nd September
 | 3rd September |  |  |  | 3rd September
 | 4th September |  |  |  | 4th September
 | 5th September |  |  |  | 5th September
 | 6th September |  |  |  | 6th September
 | 7th September |  |  |  | 7th September
 | 8th September |  |  |  | 8th September
 | 9th September |  |  |  | 9th September
 | 10th September |  |  |  | 10th September
 | 11th September |  |  |  | 11th September
 | 12th September |  |  |  | 12th September
 | 13th September |  |  |  | 13th September
 | 14th September |  |  |  | 14th September
 | 15th September |  |  |  | 15th September
 | 16th September |  |  |  | 16th September
 | 17th September |  |  |  | 17th September
 | 18th September |  |  |  | 18th September
 | 19th September |  |  |  | 19th September
 | 20th September |  |  |  | 20th September
 | 21st September |  |  |  | 21st September
 | 22nd September |  |  |  | 22nd September
 | 23rd September |  |  |  | 23rd September
 | 24th September |  |  |  | 24th September
 | 25th September |  |  |  | 25th September
 | 26th September |  |  |  | 26th September
 | 27th September |  |  |  | 27th September
 | 28th September |  |  |  | 28th September
 | 29th September |  |  |  | 29th September
 | 30th September |  |  |  | 30th September
 | 1st October |  |  |  | 1st October
 | 2nd October |  |  |  | 2nd October
 | 3rd October |  |  |  | 3rd October
 | 4th October |  |  |  | 4th October
 | 5th October |  |  |  | 5th October
 | 6th October |  |  |  | 6th October
 | 7th October |  |  |  | 7th October
 | 8th October |  |  |  | 8th October
 | 9th October |  |  |  | 9th October
 | 10th October |  |  |  | 10th October
 | 11th October |  |  |  | 11th October
 | 12th October |  |  |  | 12th October
 | 13th October |  |  |  | 13th October
 | 14th October |  |  |  | 14th October
 | 15th October |  |  |  | 15th October
 | 16th October |  |  |  | 16th October
 | 17th October |  |  |  | 17th October
 | 18th October |  |  |  | 18th October
 | 19th October |  |  |  | 19th October
 | 20th October |  |  |  | 20th October
 | 21st October |  |  |  | 21st October
 | 22nd October |  |  |  | 22nd October
 | 23rd October |  |  |  | 23rd October
 | 24th October |  |  |  | 24th October
 | 25th October |  |  |  | 25th October
 | 26th October |  |  |  | 26th October
 | 27th October |  |  |  | 27th October
 | 28th October |  |  |  | 28th October
 | 29th October |  |  |  | 29th October
 | 30th October |  |  |  | 30th October
 | 31st October |  |  |  | 31st October
 | 1st November |  |  |  | 1st November
 | 2nd November |  |  |  | 2nd November
 | 3rd November |  |  |  | 3rd November
 | 4th November |  |  |  | 4th November
 | 5th November |  |  |  | 5th November
 | 6th November |  |  |  | 6th November
 | 7th November |  |  |  | 7th November
 | 8th November |  |  |  | 8th November
 | 9th November |  |  |  | 9th November
 | 10th November |  |  |  | 10th November
 | 11th November |  |  |  | 11th November
 | 12th November |  |  |  | 12th November
 | 13th November |  |  |  | 13th November
 | 14th November |  |  |  | 14th November
 | 15th November |  |  |  | 15th November
 | 16th November |  |  |  | 16th November
 | 17th November |  |  |  | 17th November
 | 18th November |  |  |  | 18th November
 | 19th November |  |  |  | 19th November
 | 20th November |  |  |  | 20th November
 | 21st November |  |  |  | 21st November
 | 22nd November |  |  |  | 22nd November
 | 23rd November |  |  |  | 23rd November
 | 24th November |  |  |  | 24th November
 | 25th November |  |  |  | 25th November
 | 26th November |  |  |  | 26th November
 | 27th November |  |  |  | 27th November
 | 28th November |  |  |  | 28th November
 | 29th November |  |  |  | 29th November
 | 30th November |  |  |  | 30th November
 | 1st December |  |  |  | 1st December
 | 2nd December |  |  |  | 2nd December
 | 3rd December |  |  |  | 3rd December
 | 4th December |  |  |  | 4th December
 | 5th December |  |  |  | 5th December
 | 6th December |  |  |  | 6th December
 | 7th December |  |  |  | 7th December
 | 8th December |  |  |  | 8th December
 | 9th December |  |  |  | 9th December
 | 10th December |  |  |  | 10th December
 | 11th December |  |  |  | 11th December
 | 12th December |  |  |  | 12th December
 | 13th December |  |  |  | 13th December
 | 14th December |  |  |  | 14th December
 | 15th December |  |  |  | 15th December
 | 16th December |  |  |  | 16th December
 | 17th December |  |  |  | 17th December
 | 18th December |  |  |  | 18th December
 | 19th December |  |  |  | 19th December
 | 20th December |  |  |  | 20th December
 | 21st December |  |  |  | 21st December
 | 22nd December |  |  |  | 22nd December
 | 23rd December |  |  |  | 23rd December
 | 24th December |  |  |  | 24th December
 | 25th December |  |  |  | 25th December
 | 26th December |  |  |  | 26th December
 | 27th December |  |  |  | 27th December
 | 28th December |  |  |  | 28th December
 | 29th December |  |  |  | 29th December
 | 30th December |  |  |  | 30th December
 | 31st December |  |  |  | 31st December