Matching Advance Payment Receipts with AR Invoices for GST

You use the GST Matching Advance Payment With AR Invoice program (P75I840) to match the advance payments for services with the accounts receivable invoice and to offset the amounts. You must perform the matching process only after generating the tax invoice for the service transaction.

Only receipts that are not voided, not matched, and have open GST amounts greater than 0 (zero) are available for matching. Only those invoice lines that are approved, not voided, not mapped, and for which you have generated the tax invoice are eligible for matching. An invoice line can be matched only once.

When you offset the advance payments with the accounts receivable invoice, the system:

  • Stores the matched invoice lines and advance payment receipts in the GST Offset AR Advance Payment table (F75I841)

  • Creates journal entries in the Account Ledger table (F0911)

    The system debits the permanent liability accounts in the GST Account Master Setup program (P75I805). The system credits the trade accounts for the tax authority that are retrieved using the AAI item from the processing option and the G/L offset from the GST GL Offset Setup table (F75I835). If the AAI item processing option and the G/L offset codes are not specified, the system uses the default debit trade account associated with the AAI item PC.

  • Decreases the open receipt amounts in the Advance Payment GST Transaction Services table (F75I831)

  • Updates the TL (Tax Liability) ledger in the GST Ledgers Setup table (F75I804) with the decreased liability amounts

Note: The system offsets invoice line amounts (for CGST, SGST, IGST, and GST Cess) against multiple advance payment receipts. However, open receipt amount for a particular GST type (for example, CGST) can be offset only against the invoice amount for that GST type (CGST).