Example: Withholding Calculations
Suppose you make four payments to Supplier A in August, 2005.
The first payment consists of:
Gross amount of 1210
Tax of 210
Taxable amount of 1000
Because the 1000 taxable amount is less than the 8000 minimum at which the tax is calculated, the system does not calculate the withholding. The system stores these values in the F76A0456 table:
G/L Date - YR (data item DGY) = 05
G/L Date – MO (data item DGM) = 08
Taxable Amount (data item ATXA) = 1000
Aging Amount 1 (data item AG1) = 0
The second payment consists of:
Gross amount of 4420
Tax of 420
Taxable amount of 4000
The system adds the stored taxable amount from the F76A0456 table to the taxable amount of the second payment to determine whether taxes must be paid. Because the total of the taxable amount of the first payment (1000) plus the taxable amount of the second payment (4000) is less than the 8000 minimum, the system does not perform the tax calculations.
The system updates these values in the F76B0456 table:
G/L Date - YR (data item DGY) = 05
G/L Date – MO (data item DGM) = 08
Taxable Amount (data item ATXA) = 5000
Aging Amount 1 (data item AG1) = 0
The third payment consists of:
Gross amount of 10220
Tax of 1220
Taxable amount of 9000
The system adds the stored taxable amount from the F76A0456 table to the taxable amount of the third payment to determine whether taxes must be paid. Because the stored amount (5000) plus the taxable amount for the third payment (9000) exceeds the 8000 minimum, the system calculates the tax:
The system updates these values in the F76A0456 table: (5000 + 9000) × tax rate (6 percent for this example)= 840 tax.
G/L Date - YR (data item DGY) = 05
G/L Date – MO (data item DGM) = 08
Taxable Amount (data item ATXA) = 14000
Aging Amount 1 (data item AG1) = 840
The fourth payment consists of:
Gross amount of 1210
Tax of 210
Taxable amount of 1000
The system adds the stored taxable amount from the F76A0456 table to the taxable amount of the fourth payment to determine whether taxes must be paid. Because the stored amount (14000) plus the taxable amount for the fourth payment (1000) exceeds the 8000 minimum, the system calculates the tax by making the calculation on the new total, then subtracting the amount of tax already withheld: (14000 + 1000) × tax rate (6 percent for this example)= 900. 900 – 840 (accumulated withholding) = 60 withholding for payment four.
The system updates these values in the F76B0456 table:
G/L Date - YR (data item DGY) = 05
G/L Date - MO (data item DGM) = 08
Taxable Amount (data item ATXA) = 15000
Aging Amount 1 (data item AG1) = 900