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:
Legal entities and establishments
Tax regimes and taxes
Suppliers
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.
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 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.
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.
Enter the reporting level for this report. You can run this report at the ledger, legal entity, or operating unit level.
Enter the ledger, legal entity, or operating unit name that you want to run this report for.
Enter the General Ledger starting period for the report.
Enter the General Ledger ending period for the report.
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 |
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
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.
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.
Enter the starting date of the accounting period range that you want to run this report for.
Enter the ending date of the accounting period range that you want to run this report for.
Enter the tax that Oracle Payables lists invoice and tax information for.
Enter a supplier name to generate a report for a specific supplier.
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 |
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