Sample_Sheet.xlsx

I appreciate the help, but didn't know you can attached files direct.

Your mistaken about the data validations lists and formulas.

Type - Data Validation list
PAYMENT RECLAIM - Data Validation list
Cost Head - Data Validation list
Company - Data Validation list
Supplier - Data Validation list
Subtotal - Formular
Subtotal + 20% - Formular
VAT - Formular
JOB STATUS - Data Validation list
PAYEMT PROCESSED BY - Data Validation list

Thanks