# RoDTEP and Duty Drawback Export Incentive Tracker (Excel Worksheet) > Source: https://netray.co/tools/rodtep-duty-drawback-export-incentive-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track each shipping bill against its RoDTEP and drawback rate, expected incentive and credit status in one editable sheet. ## Category regional ## Region India ## Industry Discrete Manufacturing ## Audience - Export manager - Finance controller - Exim executive ## Tool **Kind:** worksheet **Mode:** editable **Currency:** Rs **Columns:** #### Shipping bill no **Key:** sb_no **Type:** text #### SB date **Key:** sb_date **Type:** date #### Buyer **Key:** buyer **Type:** text #### FOB value **Key:** fob **Type:** number **Format:** currency #### RoDTEP rate **Key:** rodtep_rate **Type:** number **Unit:** % **Help:** Rate for the tariff line, taken from the current notification #### RoDTEP expected **Key:** rodtep **Type:** number **Expr:** fob * rodtep_rate / 100 **Format:** currency #### Drawback rate **Key:** dbk_rate **Type:** number **Unit:** % **Help:** All industry rate for the tariff item, subject to caps #### Drawback expected **Key:** dbk **Type:** number **Expr:** fob * dbk_rate / 100 **Format:** currency #### Status **Key:** status **Type:** select **Options:** - Filed - LEO given - Scroll generated - Credited - Query or rejected **Rows:** **Sb no:** SB-7012451 **Sb date:** 2026-09-04 **Buyer:** Hartmann GmbH **Fob:** 1850000 **Rodtep rate:** 1.2 **Dbk rate:** 1.5 **Status:** Credited **Sb no:** SB-7013988 **Sb date:** 2026-09-18 **Buyer:** Delta Fluid Systems **Fob:** 960000 **Rodtep rate:** 0.9 **Dbk rate:** 1.8 **Status:** Scroll generated **Sb no:** SB-7015620 **Sb date:** 2026-10-02 **Buyer:** Hartmann GmbH **Fob:** 2310000 **Rodtep rate:** 1.2 **Dbk rate:** 1.5 **Status:** LEO given **Sb no:** SB-7016834 **Sb date:** 2026-10-11 **Buyer:** Nordic Pumps AB **Fob:** 740000 **Rodtep rate:** 0 **Dbk rate:** 2.1 **Status:** Query or rejected **Totals:** #### Total FOB **Key:** fob **Agg:** sum **Format:** currency #### Total RoDTEP **Key:** rodtep **Agg:** sum **Format:** currency #### Total drawback **Key:** dbk **Agg:** sum **Format:** currency **Summary:** #### Total expected incentive **Key:** total_incentive **Expr:** sum_rodtep + sum_dbk **Format:** currency **Primary:** true #### Incentive as share of FOB **Key:** incentive_pct **Expr:** if(gt(sum_fob,0), (sum_rodtep + sum_dbk) / sum_fob * 100, 0) **Format:** percent **Notes:** Rates here are illustrative. Take the RoDTEP and drawback rates for each tariff line from the latest DGFT and CBIC notifications, and apply any value caps. A single shipment may be eligible for only one scheme on a given item. ## Content **Intro:** Export incentives are real money that often sits unreconciled for months. This worksheet lists every shipping bill with its FOB value and applicable rates, computes the expected RoDTEP and drawback, and shows which claims have actually been credited. **Sections:** #### How to use the tracker **Body:** Add one row per shipping bill after the let export order. Enter the FOB value from the shipping bill, then the RoDTEP rate and drawback rate for the tariff line. The sheet multiplies value by rate to give the expected incentive. Update the status as the scroll is generated and credit arrives, and compare the credited amount with your expected figure in your bank or ledger. Rows left in a status other than Credited for long periods are the ones to chase. **Bullets:** - Use the FOB value stated on the shipping bill - Enter rate as a percentage number, such as 1.2 - Set a rate to zero when the scheme does not apply to that line - Review non-credited rows every month #### How the two schemes differ **Body:** RoDTEP refunds embedded central, state and local duties and taxes that are not otherwise rebated, and is credited as a transferable electronic scrip on the customs system. Duty drawback refunds customs and certain central duties paid on inputs, either at an all industry rate or a brand rate. Rates differ by tariff item and some items have per unit or value caps. Check the current notification for the tariff line of each product, and do not assume both are claimable on the same item. #### Common mistakes **Body:** Exporters often book the incentive in the ledger at the time of shipment without checking that the shipping bill data was correct. A wrong tariff item, missing invoice detail or a mismatch with the GST return can hold up the scroll. Another error is applying last year's rate after a notification change. Keep the rate column current and keep the notification reference in your own notes. **Cta:** If your ERP holds shipping and invoice data, we can help reconcile expected and credited incentives automatically. This sheet does the job manually without that. **Faq:** #### Are the rates in the example real? **Answer:** No. They are illustrative placeholders. Real RoDTEP and drawback rates depend on the tariff line and change by notification, so take them from the latest DGFT and CBIC publications for your products. #### Can I claim both RoDTEP and drawback? **Answer:** Generally the same item cannot receive overlapping benefits for the same duties. Confirm eligibility for each tariff line with your customs consultant before you record both in the sheet. #### Why does the incentive share of FOB matter? **Answer:** It shows the effective benefit across your shipments. If it falls sharply, check for rejected claims, wrong tariff items or a rate change that you have not updated. #### Can I export it to Excel? **Answer:** Yes, the worksheet exports to Excel, PDF, Word and CSV so you can attach it to monthly management reporting. ## Search terms rodtep tracker excel, duty drawback claim tracker, export incentive tracker india, rodtep scroll reconciliation, shipping bill incentive register, drawback receivable worksheet, exporter incentive receivable format --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json