With the increase in the quantum of Exports in India the documentation relating to export is also increasing, and one of the important documents relating to export is Shipping Bill.

A Shipping Bill has various details like FOB value, IGST amount, Drawback Claim, Rodtep amount, etc. These details are required for various custom fillings/ claim or incentive amount reporting etc. which are extracted manually.

Problem Statement:

The details are being extracted from the Shipping bill manually by copying pasting the data in excel. This is a time-consuming task and has a high risk of accuracy. Even if a person takes 30 seconds to extract the data from 1 shipping bill, getting the data from 1000 shipping bills will take almost 8 hours, and with this high quantum it becomes practically difficult for a person to be able to maintain the same level of accuracy for every detail to be extracted from such large numbers of shipping bill.

Solution Created:

Identifying the above problem statement, a shipping bill reader has been created with the help of ChatGPT in form of a python script i.e. AI-enabled automation tool. This will allow the user to get the details from N-number of shipping bills into excel in just one click. This helps to mitigate the risk of accuracy, faster processing of documents and reduced manual efforts resulting in streamlined document processing.

Key Features:

1. Allows the user to browse the folder location where the shipping bills are placed
2. List the details from Shipping bill in a formatted excel table along with the file name of the shipping bill
3. The script doesn’t need any additional OCR tools to be installed to read the PDF.
4. Being a python script installed into the system, there will be no risk of data leakage.

Impact:

1. Time Saving: 1000 bills can get processed in less than 15 minutes in place of 8 hours
2. Accuracy Increase: Automated extraction ensures consistent accuracy of >99%
3. Cost Reduction: Lower manpower reliability
4. Improved Compliance: Accurate data submission leads to timely custom and audit compliance
5. Reduced Penalties: Reduced errors in data helps to avoid penalties, rework or delayed incentive claims.

Python Script Screenshot:

Formatted Excel Output Screenshot

Below is the screenshot for the excel output that gets generated.