GST processing
At transaction time, Oracle ERP Cloud uses tax configuration and determines the tax applicability on each transaction line. Once tax applicability on a given transaction line is determined, applicable tax lines are created.
Each tax line displays tax regime, tax name, tax jurisdiction, tax status, tax rate, tax amount, and other information where applicable. For each tax line, the required distribution lines are created.
Case Study
An organization based in Tamil Nadu (TN) sells and dispatches two different products to one of its customers located in Telangana (TS) for INR 4,460. Assume this transaction is hypothetically subject to a GST at the rate of 18%.
The buyer enters a purchase order in Oracle ERP Cloud Purchasing with these transaction lines:
This table displays the Purchase Order (PO) Lines (Payables Invoicing Match to PO Option):
Line | Item | Unit Price | Quantity | Line Amount | Bill to/ship to State | Ship from State |
---|---|---|---|---|---|---|
1 | A (Inventory Item) | INR 1.83 | 1,000 | 1,830.00 | TS | TN |
2 | B (Inventory Item) | INR 2.63 | 1,000 | 2,630.00 | TS | TN |
Total in INR | 4,460.00 |
Tax Determination Process Sequence for GST Calculation
This table displays the sequence of tax determination processes, which Oracle ERP Cloud uses to calculate and apply GST on the transaction:
Order | Process Name | Activities Performed by the Process | Components Used | Result |
---|---|---|---|---|
1. | Determine Applicable Tax Regimes | Identifies the applicable tax regimes. | Based on the location (Country = India) involved in the transaction | Applicable Regime |
2. | Determine Place of Supply and Tax Jurisdiction |
Identifies the relevant tax jurisdiction and place of supply.
Refer to Note 1. |
Navigation: GST definition > tax rule defaults > Place of Supply = Bill to/ship to/ First party tax registration Number |
Place of Supply – State TS Tax Jurisdiction – State TS
|
3. | Determine Tax Applicability |
Evaluates taxes based on any tax applicability rule for each tax.
|
Tax Applicability Rules
Tax conditions:
If the qualifier Ship From state TS Is not equal to Bill To/Ship To/First-Party Tax Registration Number state TN, then apply Interstate tax.
If the qualifier Ship From state TS is equal to Bill To/Ship To/First party tax registration state TN, then apply Intrastate tax.
|
GST Applicable |
4. | Determine Tax Registration |
Determines the party type used to derive the tax registration for each applicable tax.
Refer to Note 2.
|
Navigation: GST definition > tax rule defaults > tax registration = Ship from- party | Ship from party |
5. | Determine Tax Status | Considers tax statuses of the applicable taxes. |
Define the tax status for GST as Standard and set it as default tax status.
Navigation: GST definition > tax rule defaults > Indirect defaults > tax status= Standard |
Standard |
6. | Determine Tax Rate | Consider the tax rate(s) of each applicable tax status associated with the applicable tax. |
Tax Rate Rules
Tax conditions –
Product Inventory Linked (Qualifier Level 1 = HSN Code)
|
Applicable GST rate – 18% |
7. | Determine Taxable Basis |
Determines the taxable basis on which the tax rate for each tax is applied.
|
Standard taxable basis formula = STANDARD_TB | Taxable Basis = Line Amount, i.e. in this case, the two line amounts are 1,830 and 2,630. |
8. | Calculate Taxes | Identifies the tax calculation formula. Calculates taxes using the tax calculation formula. |
Standard tax calculation formula = STANDARD_TC
|
Taxable Basis * Tax Rate 1,830*18% + 2,630*18% = 329.40+ 473.40 = 802.80
|
9. | Determine Tax point Basis |
Identifies the tax point basis for taxes to be recognized and accounted.
Refer Note 3.
|
Invoice | Recoverable taxes and tax liability accounted on Invoice |
10 | . Determine Recovery Rate |
Determines tax recovery rates, tax recoverable amounts, and nonrecoverable tax amount amounts.
Refer to Note 4. |
For a GST input tax credit, define a 100% tax recovery rate of GST STANDARD RECOVERY and select a default tax recovery rate.
Navigation: GST definition > tax rule defaults > Indirect defaults > Tax recovery rates > GST STANDARD RECOVERY |
Tax Recoverable Amount = Tax Amount * 100% = (329.40*100%) + (473.40*100%) = INR 802.80 |
Here are some notes:
- The Determine Place of Supply process identifies the applicable place of supply,
which is the location where the supply of goods or services is deemed to have
taken place for a specific tax. Oracle ERP Cloud identifies the tax jurisdiction
for the location that corresponds to the place of supply.
You can also use First-Party Tax Registration Number as the determining factor assigned to legal reporting unit of supplier facing entity to default place of supply.
- Set up tax registrations for customers and suppliers.
Navigate to the Manage Tax Registrations page to configure any required tax registrations for Third-Parties. A tax registration contains information related to a party's transaction tax obligation with the tax authority where it conducts business. The supplier located in TN has a tax registration record against the GST regime with a current tax registration status as Registered. The supplier must maintain tax registration records for all its Third-Parties. Regular transaction taxes are applied if Third-Party is registered under GST. If not registered, transaction taxes can be computed as selfassessed (Reverse charge). See Management of GST Registration Numbers and Implementation of Self-Assessed Taxes section for more details.
- Tax Point Basis (TPB) is the pointwhere recoverable taxes can be accounted and
reported.
Oracle ERP Cloud facilities Delivery, Invoice, Accounting, and Payment as Tax Point Basis. You can use any one of these TPB as per their GST Transaction process requirements on recognition and reporting of recoverable taxes. Using the Manage Configuration Owner Tax Options task you can enable Allow Delivery Based Tax Calculation on Invoice for Oracle Payables application with TPB as Invoice and Tax Point Date (TPD) as receipt. This ensures that taxes are calculated as per tax rates prevailing on Goods receipt date and Recoverable taxes can be recognized and accounted on Invoice for Inbound transactions. See the Tax Implementation Guide for more details on Tax Point Basis and Configuration Owner Tax Options (COTO).
This table lists sample setups for Allow Delivery Based Tax Calculation on Standard Invoice for Payables application through COTO:Configuration Owner Tax Options (COTO) Values Configuration owner Business Unit Application name Payables Event Class Standard Invoice Allow Delivery Based Tax Calculation YES Report Delivery based taxes on INVOICE Tax Point date Receipt Tax point basis INVOICE - Tax recovery is the full or partial recovery of the tax paid on purchases by a registered LRU to offset the taxes collected from any sales transactions. GST is recoverable by the way of an input tax credit after complying with applicable regulations. In Oracle ERP Cloud, tax recovery functionality is available. The GST recovery rate on a tax may vary based on one or more transaction factors. You must set up the required tax recovery rate rules to determine the appropriate recovery rate applicable on the transaction.
PO Tax Determination
This table displays the transaction lines for a PO Tax Determination process:
Transaction Line No | Serial No | Tax Regime | Tax Name | Tax Status | Tax Jurisdiction | Tax Rate | Tax Amount | Recoverable Tax Amount |
---|---|---|---|---|---|---|---|---|
1 | 1 | GST | GST | Standard | TS | 18% | 329.40 | 329.40 |
2 | 2 | GST | GST | Standard | TS | 18% | 473.40 | 473.40 |
Total GST on payables invoice | 802.80 | 80280 |
After the Tax Determination process is complete, the application inserts tax lines at a summary level. It inserts one line for each applicable tax.
This table shows one tax line for the GST:
Tax Line | Rate Name | Rate | Tax Amount | Tax Regime | Tax Name | Tax Status | Tax Jurisdiction |
---|---|---|---|---|---|---|---|
1 | GST_18 | 18 | 802.80 | GST | GST | Standard | TS |
Once the PO is approved, the buyer sends it to seller with these details:
Seller: Green Corp.
Bill to/ship to Location: TS
Line | Item | Unit Price | Quantity | Line Amount |
---|---|---|---|---|
1 | A (Inventory Item) | INR 1.83 | 1,000 | 1,830.00 |
2 | B (Inventory Item) | INR 2.63 | 1,000 | 2,630.00 |
Total in INR | 4,460.00 | |||
18% GST | 802.80 | |||
Total PO Value in INR | 5262.80 |
The seller located in TN sends an invoice for the total amount of INR 5,262.80 (4,460 item amount plus 802.80 tax).
Buyer configures TPB as Invoice so recoverable taxes are accounted on the Payables invoice. Buyer enters the Payables invoice in ERP Cloud by matching it to PO, selects the First-Party Tax Registration Number and validates the invoice. The Tax determination process is initiated and following taxes are computed:
AP Tax Determination
This table displays the transaction lines for an AP Tax Determination process:
Transaction Line No | Serial No | Tax Regime | Tax Name | Tax Status | Tax Jurisdiction | Tax Rate | Tax Amount | Recoverable Tax Amount |
---|---|---|---|---|---|---|---|---|
1 | 1 | GST | GST | Standard | TS | 18% | 329.40 | 329.40 |
2 | 2 | GST | GST | Standard | TS | 18% | 473.40 | 473.40 |
Total GST on payables invoice | 802.80 | 80280 |
After the Tax Determination process is complete, the application inserts tax lines at a summary level. It inserts one line for each applicable tax.
This table shows one tax line for the GST:
Tax Line | Rate Name | Rate | Tax Amount | Tax Regime | Tax Name | Tax Status | Tax Jurisdiction |
---|---|---|---|---|---|---|---|
1 | GST_18 | 18 | 802.80 | GST | GST | Standard | TS |
After tax lines are generated, the respective distribution lines are generated for both transaction and tax lines.
This table displays the distribution lines generated for both transaction and tax lines:
Line | Distribution Type | Amount |
---|---|---|
1 | Accrual | 1,830.00 |
2 | Accrual | 2,630.00 |
3 | Recoverable Tax | 329.40 |
3 | Non Recoverable Tax | 0.00 |
3 | Recoverable Tax | 473.40 |
3 | Non Recoverable Tax | 0.00 |
Total Balance | Total Balance | 5,262.80 |
After Accounting, these accounting entries are created. This table displays the details of accounting entries:
Account Class | Account Type | Debit | Credit |
---|---|---|---|
Accrual | Accrual | 4,460.00 | |
Tax Recoverable | Asset | 802.80 | |
Tax Non Recoverable | Expense | 0.00 | |
Liability | Liability | 4,460.00 | |
Liability | Liability | 802.80 | |
Total Balance | 5,262.80 | 5,262.80 |