6.6.4. Excise Reporting - Excise Summary

button and complete the fields:

• • Document No: automatically completed according to the defined counting sequence;

  • Document Type: select Excise Summary from the list;

  • Account Date: usually the last date of the month, it represents the date at which the summary is posted in the accounting data;

  • Period: select the month from the list

  • Data From - Data To: enter the interval for which you wish to calculate the excises; it usually is a whole month.

To generate the excise summary, press the Generate Excise Summary button and then Start.

All the transactions in the selected interval for which the excise amounts have been computed will be displayed in the Total Excise tab, with the following data:

• Tenant;

• Organization - on the document;

• Document - Type, No;

• Account Date

• Excise Product Key;

• Movement Quantity - in the product's basic UOM;

• Quantity in Excise UOM - it will display the quantity depending on the excisable product key (e.g. for wine and sparkling wine, the quantity will be displayed in hectolitres, for brandy, the quantity will be displayed in hectolitres degree);

• Amount;

• Source Amount.

To calculate the contribution to healthcare funds, press the Calculate Healthcare Contribution button, and, for each excisable product key for which this tax is owed, complete the fields:

• • Excise Product Key - select a key from the list;

  • Charge - select from the list the account corresponding to the contribution;

  • Fix tax - enter the value of the tax, according to the current Law;

  • Fix Tax Currency - usually Euro;

  • UOM for application - the unit of measure to which the tax will be applied.

The Healthcare Contribution tab will display the results of the corresponding process:

• Tenant - from the master;

• Organization - from the master;

• Charge - from the process (necessary for posting and for determining the account 447.xx);

• Excise Product Key;

• Movement Quantity - not homogeneous as unit of measure;

• Quantity in Excise UOM;

• Fix tax - from the process ( 200Euro/HL);

• Source Amount - rounded up to a whole number;

• Amount.

To compute the total Sports Contribution, press the Calculate Sports Contribution button and, for each excisable product key to which this tax is owed, complete the fields :

• • Excise Product Key - select a key from the list;

  • Charge - select from the list the account corresponding to the contribution;

  • Percentage - enter the percentage corresponding to the tax, as according to the current Law.

The Sports Contribution tab will display the results of the corresponding process:

• Tenant - from the master;

• Organization - from the master;

• Charge - from the process (necessary for posting and for determining the account 447.xx);

• Excise Product Key;

• Movement Quantity - not homogeneous as unit of measure;

• Quantity in Excise UOM;

• Percentage - from the process ( 1% of [Total Excise - Healthcare Deduction]);

• Source Amount - rounded up to a whole number;

• Amount.

To compute the total Sports Contribution, press the Calculate Excise Duty Stamp Deduction button and, for each excisable product key to which this tax is owed, complete the fields :

• • Excise Product Key - select a key from the list;

  • Charge - select from the list the account corresponding to the contribution;

  • Price - enter the price of a duty stamp.

The Duty Stamps Deduction tab accepts manual insertion of:

• Tenant - from the master;

• Organization - from the master;

• Charge - from the process (necessary for posting and for determining the account 7412);

• Excise Product Key;

• Quantity = the sum of the moved quantities, grouped by excise codes;

• Price - from the process;

• Amount = Quantity * Price (RON)- rounded up to a whole number.

Posting the Excise Summary

Post the information in the tabs/details as such:

Debit: “Excise” = Credit: “Revenue”

“Excise” - determined from the definition of the excise key - Accounting tab;

“Revenue” - determined from the definition of the Charge field found in each detail.