Understanding Accounts Payable VAT Calculations and Accounting Entries

This section discusses:

  • VAT calculations in PeopleSoft Payables.

  • VAT accounting entries in PeopleSoft Payables.

This section discusses VAT calculations in PeopleSoft Payables.

Exclusive VAT Calculation for Vouchers

In the case of exclusive VAT vouchers, when you save the voucher, a VAT confirmation process takes place. The system calculates the VAT amount for each line based on entered VAT values and stores that amount on the distribution line. The system compares the calculated amount to the amount of VAT that you entered on the voucher header. If there is a discrepancy, the system compares the amount of difference against the VAT tolerance rules, as defined in your PeopleSoft Payables control hierarchy. If the difference is within tolerance, the voucher is accepted and the difference is allocated to the distribution line with the highest VAT basis amount upon running the Voucher Posting Application Engine process (AP_PSTVCHR). If the difference is out of tolerance, and you have set up VAT tolerance checking to issue a warning, the system alerts you with a warning message to check for input errors (you also have the option of having the system issue an error or not check for tolerances at all.) The system stores the calculated VAT amount on the voucher header, but the payment is always based on the VAT amount shown on the supplier's invoice.

Inclusive VAT Calculation for Vouchers

Another common processing scenario generally occurs with low monetary value invoices. In this case, known as VAT inclusive, the amount of VAT is not explicitly detailed on the voucher, but is included in the merchandise amount for each voucher line. The system calculates the amount of VAT for the voucher and stores the amount for reporting purposes. The system calculates the VAT at the line level and stores the sum of all VAT amounts, on all lines, on the voucher header.

Vouchers with a VAT Exemption

When your organization is VAT exempt, the VAT Exception Type is Exoneration. In this case, the transactions are treated as taxable at a zero-rate. This means that the transaction line would have a taxable type VAT Applicability (X) and a VAT code with a zero rate should be specified on the line. There is nothing that prevents you from entering a VAT amount on the header in this caseā€”even if all of the lines are zero-rated. However, the VAT tolerance check occurs (unless you have opted not to use it), since the calculated VAT amount would be zero.

When the good or service is VAT exempt, the voucher line is flagged with a VAT Applicability of Exempt, and there is no VAT code on the line. In this case, you are not allowed to enter a VAT amount on the header if all lines are flagged as exempt. However, it is possible for a voucher to contain a mixture of taxable and exempt lines, in which case you can enter a VAT amount on the header.

Another type of VAT exemption occurs when you have been granted a temporary suspension from paying VAT. In this case the transaction line has a taxable-type VAT Applicability (S), and a VAT code with a zero-rate should be specified on the line.

Finally, when a transaction line is outside the scope of VAT, VAT calculation simply ignores the transaction (except in some exceptional circumstances). Like exempt goods or services, these lines have a VAT applicability of O, no VAT code on the line, and you would be unable to enter a VAT amount on the header if all lines are thus flagged.

Postponed or Self-Assessed VAT

In some cases, you are required to record both input and output VAT on a voucher. In this case, VAT is due on your purchase but has not been charged by the supplier. Instead of including the VAT in your payment to the supplier, you pay it to your country's VAT authorities. Examples of this include EC acquisitions, reverse charge transactions in Europe, and self-assessed GST in Canada. This may also be referred to as postponed VAT or self-imposed VAT. When VAT is self-assessed, the record output VAT flag is set to Y. If all of the voucher lines are self-assessed, then you enter no VAT amount; the system calculates the VAT amount for each line and stores the total on the voucher header.

If you have both self-assessed and non self-assessed voucher lines, any VAT amount entered on the voucher header applies only to the non self-assessed lines.

VAT accounting entries are created by voucher posting and payment posting, when applicable, for each combination of general ledger business unit, VAT code, and VAT transaction type that exists in the voucher distribution. Several factors affect how VAT can be accounted for, as follows:

  • If you are recording input VAT only, where VAT is included on the invoice and the VAT amount is payable to the supplier, the VAT amount is included in the accounts payable entry during voucher posting.

  • If you are recording both input and output VAT, where VAT is not included on the invoice and you may be liable for VAT, but it is not payable to the supplier, the system creates a separate VAT liability entry during voucher posting.

  • The VAT declaration point determines the date on which VAT is recognized.

    If VAT is declared at time of payment, intermediate VAT accounting entries are created by voucher posting. Payment posting reverses the intermediate entries and creates the VAT accounting entries against the final VAT accounts. If VAT is declarable at invoice, delivery, or accounting date, the VAT accounting entries for the final VAT accounts are created by voucher posting; no intermediate accounts are used.

  • If VAT is initially calculated at gross and then recalculated at the time of payment, and a cash discount is being taken, adjusting VAT accounting entries are created by payment posting to reduce the amount of VAT that is recorded, based on the amount of the discount.

  • Voucher posting and payment posting create separate entries for recoverable VAT and non-recoverable VAT.

    If you are prorating non-recoverable VAT, the non-recoverable VAT is applied to the expense accounts specified for each VAT-applicable line. If you are not prorating non-recoverable VAT, the non-recoverable VAT is applied to the non-recoverable VAT account specified for each VAT code and VAT transaction type. If the Allocate Non-Recoverable option is selected on the transaction, then the system looks to the ChartField inheritance options for each ChartField to determine whether the value is inherited from the associated expense distribution line, from the defaults defined for the business unit, or from the VAT accounting template. If the Allocate Non-Recoverable option is deselected, then the rest of the ChartFields default from the VAT accounting template.

  • VAT can be recorded in the general ledger using the general ledger business unit associated with the accounts payable business unit on the voucher header or the general ledger business unit on the voucher distribution line, depending on the VAT interunit settings.