13 Working with VAT on a Cash Basis in the United Kingdom

This chapter contains the following topics:

13.1 Generating Journal Entries for VAT on a Cash Basis

This section provides an overview of journal entries for VAT on a cash basis and discusses how to:

  • Run the VAT Payments Update program.

  • Set processing options for VAT Payments Update (R74U0445).

13.1.1 Understanding Journal Entries for VAT on a Cash Basis

Run the VAT Payments Update program (R74U0445) to:

  • Update the Taxes table (F0018) based on both the VAT amounts form the voucher and the cash payment made against that voucher.

    Partial payments are pro-rated.

  • Create a journal entry record to move the VAT amount from a suspense account to an actual VAT account.

13.1.2 Running the VAT Payments Update Program

Select VAT Inputs on a Cash Basis (G74U0525), VAT Payments Update.

13.1.3 Setting Processing Options for VAT Payments Update (R74U0445)

Processing options enable you to specify default processing values.

13.1.3.1 Select

1. Date From

Specify the beginning of the date range that the system uses to select records to process.

2. Date To

Specify the end of the date range that the system uses to select records to process.

13.1.3.2 Defaults

1. Journal Entry Document Type

Enter a value that exists in the Document Type (00/DT) UDC table to specify the document type to assign to the journal entries for VAT. If you leave this processing option blank, the system uses JE.

2. G/L Date (general ledger date)

Specify the date that the system uses as the general ledger (G/L) date for the journal entries it writes for VAT. If you leave this processing option blank, the system uses the receipt date of the transaction.

3. Tax Date

Specify the date that the system uses as the tax date for the journal entries it writes for VAT. If you leave this processing option blank, the system uses the receipt date of the transaction.

4. Journal Explanation

Enter the text that the system writes to the Remark field in the F0911 table. If you leave this processing option blank, the system writes the text Vat cash receipt journal.

5. Ledger Type

Enter a value that exists in the Ledger Types (09/LT) UDC table to specify that ledger to which the system writes the journal entries for VAT. If you leave this processing option blank, the system use ledger type AA.

13.1.3.3 Accounts

1. AAI for VAT Debit (automatic accounting instruction for value-added tax debit)

Enter the AAI that you use to write the journal entry for the VAT debit account. If you leave this processing option blank, the system uses PT.

2. OR Enter Account:

Enter the business unit, object account, and subsidiary that make up the VAT debit account. You enter the values in this processing option if you leave the AAI for VAT Debit processing option blank.

3. AAI for VAT Credit (automatic accounting instruction for value-added tax credit)

Enter the AAI that you use to write the journal entry for the VAT credit account. If you leave this processing option blank, the system uses VT.

Generally, you use the AAI that is pointing to the VAT suspense account. The system wrote the amounts for VAT to that account when you posted the voucher.

4. OR Enter Account:

Enter the business unit, object account, and subsidiary that make up the VAT credit account. You enter the values in this processing option if you leave the AAI for VAT Credit processing option blank.

13.1.3.4 Process

1. Final or Proof Mode.

Specify how the system processes records and writes data to the Taxes (F0018) table. Values are:

1: Proof mode. The system selects unflagged records and produces a report only. The system does not update the F0018 table. If you leave this processing option blank, the system uses this value.

2: Final mode: The system selects unflagged records, flags them, and creates VAT records in the F0018 table.

3: Proof mode: The system selects flagged records and produces a report only. The system does not update the F0018 table.

4: Delete mode: The system selects flagged records, removes the flag, and removes the VAT records from the F0018 table.

2. Enter when to update Tax File (F0018).

Specify the conditions under which the system updates records in the F0018 table. The system uses the value in this processing option only when the value in the Final or Proof Mode processing option is set to 2 (final mode). Values are:

Blank: Do not update the F0018 table. This is the default value.

1: Update only VAT and use taxes.

2: Update the selected records in the F0018 table for all tax amounts.

3: Update the selected records for all tax explanation codes.

3. Suppress Creation of Zero lines in F0911

Enter 1 to suppress the creation of lines in the F0911 table for records with 0 (zero) for the tax amount. If you leave this processing option blank, the system writes lines for zero amounts.

13.1.3.5 Print

1. Print Selection Report

Enter 1 to print the report.