Calculating GST for Accounts Receivable Transactions

You run the Calculate GST for A/R Invoices program (R75I813) to calculate GST for services that you supply to customers. When you run this program, the system selects the accounts receivable invoices from the F03B11 table for the date range and company specified in the processing option.

Only those invoices that are not posted and not paid are eligible for GST calculation. The system prints specific error messages in the report if these conditions are not met.

The system prints an error for the export transactions that are associated with a bond or LOU. You must cancel the export transactions that are associated with a bond or LOU from the Work With GST Bond/LOU program (P75I853) to calculate GST for these transactions.

You can set processing options to include both processed and unprocessed invoices in the report. Processed invoices are those invoices that have already been included in an earlier report run and have GST amounts already calculated. If you edit the invoice base amount for a processed invoice, and you rerun the R75I813 program, the system recalculates the GST for the invoice based on the updated base amount.

However, processed invoices for which you have paid or partially paid the GST amounts are not eligible to be processed again. The system prints an error in the report for these invoices.

When you run the program, the system:

  • Calculates the GST (CGST, SGST, IGST, and Cess) amounts for all selected invoices and prints a report with all the processed invoices at the document level detail

    For those invoices that have discounts, the system calculates the GST by deducting the discount amounts from the gross amounts.

  • Creates GST lines (CGST, SGST, IGST, and Cess as applicable) for the invoice in the GST Tax File table (F75I807)

    If reverse charge is applicable, the tax liability is updated with the provider amount in the GST Tax File (F75I807) table. The provider amount is calculated based on the provider percentage set for the GST rule.

    Note: If the provider percentage is set to zero for the GST rule, the tax liability is not updated and the GL entry is not created.
  • Creates pay item lines for each GST type in the F03B11 table for domestic transactions

    The system does not update the F03B11 table for export transactions.

You post the invoice after GST is calculated. When you post the invoice, the system creates general ledger journal entries, crediting the intermediate tax liability account for the GST type in the GST Account Master Setup program (P75I805) and debiting the GST trade account. The system retrieves the trade account by concatenating the AAI item RC with the G/L offset for the GST type that you have specified in the processing option for the R75I813 program. If the processing option for R75I813 program is not specified, the system uses the G/L offset from the GST GL Offset Setup table (F75I835).

For transactions where reverse charge is applicable, the system creates journal entries with the GST amounts that the receiver must pay to the service provider. This is the amount that the system calculates using the provider's percentage set up in the GST Rules Setup program (P75I802).

At the time of supplying the service to the receiver, you issue the legal tax invoice to the recipient to comply with regulatory requirements. You run the Legal Document Print Process program (R7430030) to print the tax invoice template.

See Printing AR Tax and Export Invoices for GST.