Skip Headers

Oracle Financials for Asia/Pacific User Guide
Release 12.1
Part Number E13419-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Singapore

Setting Up for Singapore Reporting

Before you can run the Singaporean GST F5 Report and Singaporean Input Taxes Gain/Loss Report, you must complete the related setup. This setup includes:

Set Up Legal Entities and Establishments

Use the Legal Entity Configurator to set up and maintain the first party legal entities and establishments for each company site that is responsible for reporting taxes to the tax authority. You can modify the Release 11i migrated location and organization information, and you can enter new definitions according to your requirements.

See: Defining Legal Entities Using the Legal Entity Configurator, Oracle Financials Implementation Guide for more information.

Set Up Tax Regimes and Taxes

Use E-Business Tax to set up the tax regimes and taxes that you need for Payables and Receivables transactions. The Singaporean GST F5 Report and Singaporean Input Taxes Gain/Loss Report extract tax data from the E-Business Tax tax reporting repository.

See: Setting Up Taxes, Oracle E-Business Tax User Guide for more information.

Enter the Supplier Exchange Rate

Enter the supplier exchange rate to calculate the supplier tax amount and supplier invoice taxable amount for foreign currency invoices. You can either enter the rate when you enter an invoice, or you can have Payables enter an exchange rate from the GL Daily Rates table.

The gain/loss in the tax amount for foreign currency invoices is the difference between the inhouse tax amount using the inhouse exchange rate and the supplier tax amount using the supplier exchange rate that you enter. Similarly, the gain/loss in the taxable amount is the difference between the inhouse taxable amount using the inhouse exchange rate and the supplier taxable amount using the supplier exchange rate. A manual journal entry is posted to the General Ledger to incorporate the gain/loss.

Use the Singaporean Input Taxes Gain/Loss report to view the difference in tax amounts and taxable amounts on all foreign currency invoices.

See: Entering Foreign Currency Invoices, Oracle Payables User Guide for more information.

Singaporean GST F5 Report

Use the Singaporean GST F5 report to list the invoice amounts that exclude GST and tax amounts for a company by tax type. You can run this report for a specific ledger, legal entity, or operating unit.

The report lists total taxable and tax amounts for each tax type. The report shows totals by tax type only if there is more than one tax with this transaction type. The Singaporean GST F5 report also calculates the total tax amount value for each tax and the corresponding net GST amount. The amounts listed in the report are cumulative for the period for each tax type and tax.

The Singaporean GST F5 report lists transactions for Receivables, Payables, and General Ledger entries. The report reflects all invoices that are accounted and posted to General Ledger within the reporting period regardless of invoice status. Canceled invoices are shown with zero amounts. To reflect changes to invoices that affect accounting, you must create accounting lines and post to GL again before the correct amounts appear in the report.

Use the Standard Request Submission windows to submit the Singaporean GST F5 report.

Report Parameters

Reporting Level

Enter the reporting level for this report. You can run this report at the ledger, legal entity, or operating unit level.

Reporting Context

Enter the ledger, legal entity, or operating unit name that you want to run this report for.

Start GL Period

Enter the General Ledger starting period for the report.

End GL Period

Enter the General Ledger ending period for the report.

Report Headings

This table shows the report headings.

In this heading… General Ledger prints…
Ledger Name The ledger name
Currency Code The ledger currency
Company Name The name of the reporting entity that you entered in the Reporting Level and Reporting Context parameters
Note: The report does not print this heading if you are reporting at the ledger level
Company Address The address of the reporting entity that you entered in the Reporting Level and Reporting Context parameters
Note: The report does not print this heading if you are reporting at the ledger level
Date The current date and time when you submit the report
Report Title Singaporean GST F5 Report
Reporting Level The reporting level that you selected
Reporting Context The reporting context that you selected
GL Period The General Ledger period that you selected
GST Registration Number The GST registration number for the company
Note: The report shows the GST registration number only if you are reporting at the legal entity level
Designation The designation of the tax person
Tax Person The GST taxable person (name and title)
Bank The GST bank code and branch code
Bank Account Num The GST bank account number

Column Headings

This table shows the column headings.

In this column… General Ledger prints…
Tax Type The tax class and tax type
Tax The tax associated with the tax type
Tax Amount The tax amount of the transactions that are associated with the tax
Amount Excluding GST The total amount excluding GST

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Singaporean Input Taxes Gain/Loss Report

Use the Singaporean Input Taxes Gain/Loss report to view the difference in both tax amounts and taxable amounts on foreign invoices for different exchange rates. The report shows the inhouse rate and the supplier exchange rate for all foreign currency invoices. The report only displays invoices that are approved and posted to General Ledger. The report will not show any data if the Supplier Exchange Rate GDF is empty.

The Singapore Tax Authority requires GST reporting to be in Singapore Dollars (SGD). Therefore, all amounts shown on this report are in SGD (ledger currency).

Use the Standard Request Submission windows to submit the Singaporean Input Taxes Gain/Loss report.

Report Parameters

Ledger Currency

Enter the currency to use for the report. The default value is the default currency of the ledger. If the ledger and reporting currency both use the same default currency, choose either ledger or reporting currency from the list of values. You can also choose any other currency defined for the reporting currency.

Start Accounting Period

Enter the starting date of the accounting period range that you want to run this report for.

End Accounting Period

Enter the ending date of the accounting period range that you want to run this report for.

Tax

Enter the tax that Oracle Payables lists invoice and tax information for.

Supplier Name

Enter a supplier name to generate a report for a specific supplier.

Report Headings

This table shows the report headings.

In this heading… Oracle Payables prints…
Period Range The accounting period
Tax The tax
Tax Account The accounting flexfield for this tax
Invoice Currency The invoice currency
Ledger Currency The ledger currency for this ledger

Column Headings

This table shows the column headings.

In this column… Oracle Payables prints…
Supplier Name The invoice supplier name
Invoice Number The invoice number for the tax
Invoice Date The invoice date
Exchange Rate The invoice exchange rate
Supplier Exchange Rate The invoice supplier exchange rate
Invoice Amount The invoice amount
Tax Amount The sum of the tax distribution lines for a particular tax using the inhouse exchange rate
Supplier Tax Amount The sum of the tax distribution lines for a particular tax using the supplier exchange rate
Tax Gain/Loss The invoice gain/loss on the tax amount

Related Topics

Running Reports and Programs, Oracle Applications User Guide