Spreadsheet: 204388d1357491534-strange-problem-that-i-cannot-get-my-head-round-error1
Sheet: 2013

MONTH | CLIENT | NOTES | ADVERT TYPE | NET ADVERT COST | DESIGN FEE | INSURANCE COST | QUANTITY OF ADVERTS | NET COST OF ALL ADVERTS | VAT RATE | VAT AMOUNT | GROSS PRICE OF ALL ADVERTS | COMMISSION RATE TO PAY | TOTAL COMMISSION PAYABLE | TOTAL DUE TO COMPANY EXC COMMISSION | COMMISSION PAID IN ADVANCE YES/NO | NUMBER OF PAYMENTS | DATE OF FIRST PAYMENT | FIRST PAYMENT to malta now | FIRST COMM PAYMENT to sales person | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF SECOND PAYMENT | SECOND PAYMENT | SECOND COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF THIRD PAYMENT | THIRD PAYMENT | THIRD COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF FORTH PAYMENT | FORTH PAYMENT | FORTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF FIFTH PAYMENT | FIFTH PAYMENT | FIFTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF SIXTH PAYMENT | SIXTH PAYMENT | SIXTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF SEVENTH PAYMENT | SEVENTH PAYMENT | SEVENTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF EIGHTH PAYMENT | EIGHTH PAYMENT | EIGHTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF NINTH PAYMENT | NINTH PAYMENT | NINTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF TENTH PAYMENT | TENTH PAYMENT | TENTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF ELEVENTH PAYMENT | ELEVENTH PAYMENT | ELEVENTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT | DATE OF TWELTH PAYMENT | TWELTH PAYMENT | TWELTH COMM PAYMENT | COMPANY PAID YES/NO | COMMISSION PAID YES/NO | AMOUNT DUE BY CLIENT
NOVEMBER |  |  |  | 1000 |  |  | 1 |  | 0.18 |  |  | 0.3 |  |  | YES | 2
NOVEMBER |  |  |  | 1000 |  |  | 1 |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
NOVEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
TOTAL
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
DECEMBER |  |  |  |  |  |  |  |  | 0.18 |  |  | 0.3
TOTAL
TOTAL FOR THE YEAR