We need to complete an xls spreadsheet with April purchases.
Each purchase is scanned in a pdf you may find enclosed to this doc.
We have 69 sheets=69 line
For each line you need to fill the spreadsheet with these information:
B, C, D, E: YY (year), MM (month) , DD (day); SS (serial)
F: protocol = concatenation of B, C, D, E
You may find this protocol at the bottom of each page
NOTE each day may have several sheets each one has its own serial (SS+1)
G, H: leave it blank they are controls
I: Type of document (EX=expenses, PI=purchasing invoice, MT=monetary transaction, TR=troll)
You may find this info at the bottom of each page
J: Company (Zf or HH) You may find this info at the bottom of each page only for Purchasing Invoices as Expenses have no company
K, L: leave them blank
M: TOT put the total amount
N: NET put the NET amount (only for PI)
O: VAT put the VAT amount (only for PI)
1. Please note in several sheet you may find the purchase invoice and payment doc (credit card transaction) you need to report the amount once (not the transaction but only the expense amount)
2. In some sheet you may find several docs like tickets or recipts. You need to sum them and put in Total.
Btg for this is 25 if all fields will be correct after our control we can put 5 on the top of that as a bonus
Please note we have MAY and JUNE to be processed with the same amount
Need someone ready to start the job immediately, possibly working on the weekend
MAX completion time 1 day (it is about 2 hrs work)