Purpose
- The purpose of this webpage is to assist licensees of Manufacturing Warehouses (VM’s) in the Oil Industry with guidance when completing the monthly petroleum products account (DA 160 and supporting schedules).
Scope
- This webpage applies to all role players of the Oil Industry including category 2 manufacturers of biodiesel.
DA 160 Monthly Excise Account
Completion of account and supporting schedules
- The form required for bringing excise duty, fuel levy and Road Accident Fund (RAF) levy to account is the DA 160 for VM’s. The relevant form is the summary of all relevant petroleum products transactions, giving an overall picture of all of the petroleum products during an accounting period.
- The DA160 Excel workbook is provided as an attachment to this webpage.
- The licensee must select the applicable supporting schedules on the Instructions worksheet. Additional supporting schedules default to “Hide / Not applicable” and must be changed to “Show” where applicable
for completion. - The DA 160 is an Excel spreadsheet linked to supporting spreadsheets by formulae and calculations. This package is a linked excel worksheet comprising of lead and supporting schedules.
- The DA 160 and supporting schedules allows for completing transactions for current rates, previous years rates (Current – 1) and the year before that (Current – 2).
- The copy of a signed DA 160 and supporting schedules must be submitted to the local Controller /Branch Manager in who’s area of control the warehouse is situated on the date the respective EXD 160 returns are submitted via efiling.
DA 160 – Account for Manufacturing Warehouse.
- This entire form is automatically produced from its underlying supporting schedules by means of linked excel formulae.
- Manual input of the header information, the payment schedule dates and the declaration details, is however required.
- Product:
- The relevant product name will be prepopulated based on the tariff selected. (separate Excise accounts are to be prepared in respect of each Excisable product):
- Petrol;
- Diesel (Distillate Fuel);
- Unmarked illuminating kerosene;
- Biodiesel; or
- Unmarked specified aliphatic hydrocarbon solvents (in the event of these being dutiable as a result of not complying with the existing Customs and Excise registration procedures), as the case may be.
- The relevant product name will be prepopulated based on the tariff selected. (separate Excise accounts are to be prepared in respect of each Excisable product):
- Tariff code: Select applicable tariff subheading.
- Client Number: This field is for the licensees’ Excise number.
- License Warehouse Name: The name under which the VM warehouse is licensed must be inserted in this box.
- Warehouse number: This box is for the VM number.
- Physical Address: Warehouse address must be filled in the relevant boxes.
- Accounting period – accounting period will be prepopulated based on the Date from and Date To inserted the same applies to Year and Quarter.
- From date / to date: these period boxes are provided in order that the first and last day of the accounting month may be indicated. If, for example, the closing date for excise account purposes is the 25th of each month and the excise account in respect of January is rendered, the period would be 26 December to 25 January. The date must again use the format CCYYMMDD with no spaces or connecting links such as oblique’s, full stops, colons or dashes.
DA 160A: Table of Rates of Duty and Levies
- Manually input of the rates of excise duty, general fuel levy, carbon fuel levy and RAF levy for the Current Year (CURRENT), the Previous Year (CURRENT – 1) and the year before that (CURRENT – 2) is required. This is expressed in Rands to five (5) decimal places. Every rate table appearing on all supporting schedules that follow will be automatically populated by means of the Excel programme linking those schedules to the tables on the DA 160A. It is critical that the tables appearing on the DA 160A are updated when rate changes occur, which is normally when the month of April is being reported on the May account.
DA 160B: – Analysis of Litres and Collections by Duty Year (Excise Duty)
- The objective of this form is to split the Excise duty collections by year and to calculate the related volumes.
- Most of this form is automatically produced from its underlying supporting schedules by means of linked Excel formulae. The headers for this schedule and its underlying supporting schedules are automatically populated from the DA 160. However, manual input is required for the LITRES and RANDS for the 50% related to the previous month’s declaration.
DA 160C: – General Fuel Levy Analysis
- The objective of this form is to split the general fuel levy collection by year and to calculate the related volumes.
- This entire form is automatically produced from its underlying supporting schedules by means of linked Excel formulae. The headers for this schedule and its underlying supporting schedules are automatically populated from the DA 160. However, manual input is required for the LITRES and RANDS for the 50% related to the previous month’s declaration.
DA 160D: – Carbon Fuel Levy Analysis
- The objective of this form is to split the carbon fuel levy collection by year and to calculate the related volumes.
- This entire form is automatically produced from its underlying supporting schedules by means of linked Excel formulae. The headers for this schedule and its underlying supporting schedules are automatically populated from the DA 160. However, manual input is required for the LITRES and RANDS for the 50% related to the previous month’s declaration.
DA 160E: Analysis of Litres and Collections by Duty Year (Road Accident Fund Levy)
- The objective of this form is to split the RAF levy collection by year and to calculate the related volumes.
- Most of this form is automatically produced from its underlying supporting schedules by means of linked Excel formulae. The headers for this schedule and its underlying supporting schedules are automatically populated from the DA 160. However, manual input is required for the LITRES and RANDS for the 50% related to the previous month’s declaration.
DA 160.05: Local Removals
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details of all petroleum products destined for local consumption removed from the VM and attracting duty / levies at current rates and rates immediately preceding the currently ruling rates.
- Volumes for rates immediately preceding the currently ruling rates should only be completed where there were two (2) rates applicable within the single accounting period.
DA 160.10: Removals Outwards to BELN Countries
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products analysed by the transport mode and destination country within the SACU, in litres, of all products removed from the VM to BELN countries and attracting duty / levies at current rates and rates immediately preceding the currently ruling rates.
- Volumes for rates immediately preceding the currently ruling rates should only be completed where there were two (2) rates applicable within the single accounting period.
DA 160.15: Exports / Ships’ Stores (Foreign)
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products analysed by the transport mode and destination country outside SACU, in litres, of all products exported from the VM to destination outside BELN countries and attracting duty / levies at current rates and rates immediately preceding the currently ruling rates.
- Volumes for rates immediately preceding the currently ruling rates should only be completed where there were two (2) rates applicable within the single accounting period.
DA 160.20: Removals to Special Storage Warehouses (SOS)
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products in litres, of all products removed to an SOS and attracting duty / levies at current rates and rates immediately preceding the currently ruling rates.
- Volumes for rates immediately preceding the currently ruling rates should only be completed where there were two (2) rates applicable within the single accounting period.
DA 160.25: Removals to Other Manufacturing Warehouses
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products in litres, of all products removed to a VM and attracting duty / levies at current rates and rates immediately preceding the currently ruling rates.
- Volumes for rates immediately preceding the currently ruling rates should only be completed where there were two (2) rates applicable within the single accounting period.
DA 160.50: Acquitted Removals Outwards to BELN Countries
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products analysed by the transport mode and destination country within the SACU, in litres, of all acquitted removals from the VM to BELN countries and attracting duty / levies at current rates, rates immediately preceding the currently ruling rates and rates before that (Current – 2).
DA 160.60: Acquitted Removals to Special Storage Warehouses
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products in litres, of all acquitted removals to an SOS and attracting duty / levies at current rates, rates immediately preceding the currently ruling rates and rates before that (Current – 2).
DA 160.65: Acquitted Removals from Other Manufacturing Warehouses
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products in litres, of all acquitted removals to a VM and attracting duty / levies at current rates, rates immediately preceding the currently ruling rates and rates before that (Current – 2).
DA 160.70: Returned Product – Sub-Standard or Contaminated
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of all petroleum products in litres, of all products which have been returned to the VM as a result of being found to be sub -standard or contaminated and attracting duty / levies at current rates, rates immediately preceding the currently ruling rates and rates before that (Current – 2).
- There is an automatically calculated adjustment for Rule 19A.10 allowances previously granted, based on the tariff subheading selected on sheet DA160.
DA 160.75: Losses
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures full narrative details, and volume in litres, of any product which has been lost as a result of vis major (“an act of God”) and attracting duty / levies relief at current rates, rates immediately preceding the current ruling rates and rates before that (Current – 2). Before submitting a claim for a vis major loss written authority must be obtained from the Commissioner grating the claim (manually insert inputs).
- There is an automatically calculated losses for Section 75(18)(d) or Section 75(18)(e) based on the tariff subheading selected on sheet DA160 and total litres removed during the accounting period.
DA 160.90: Other Adjustments (Movements and Adjustments after Leaving Manufacturing Warehouse Duty Paid)
- The schedule will only be available for completion when to be shown is selected under the instruction sheet.
- This form captures details, of any unusual or exceptional circumstance, requiring an adjustment not catered for on other forms in this package, and requiring duty / levies relief or additionally duty / levies liability at current rates, rates immediately preceding the currently ruling rates and rates before that (Current – 2).
- Where duty / levies relief is claimed the column in litres should be entered as a negative figure (-) and where additional duty liability is being brought to account the volume in litres should be entered as a positive figure (+).
Definitions, acronyms and abbreviations
The definitions, acronyms and abbreviations can be accessed here – Glossary webpage
Legal disclaimer: In the event of conflict or inconsistency between this webpage and the PDF version of the guide, the latter shall prevail.