• File exported from word document or excel file from the client. For this part, we checked the correct contract carrier, contract ID and amendment ID, the commodity code, we also check the right unloc code, origin code.

• For this file, we checked the destination unloc code, the correct destination trade, arbitruary construct, service and most importantly, the analyst notes column, that is the surcharges.

• Lastly, is the rates. We do not enter the rates manually, we used another method and then after we do copy paste. But for the last part of the excel, we manually entered the rates for surcharges. depending on what is written in analyst notes (that is shown in the above file).
• 

• This is where we record all our amendments. This is what we called TIMESHEET.
  

Note: All information are confidential, please do not disclose. Thank you!