Grouping Withholding for Payment Posting
In PeopleSoft Payables, accounting entries are written for withholding during voucher posting (if withholding at voucher posting option is selected) and payment posting, and withholding entries are grouped by WTHD_ENTITY, WTHD_TYPE, WTHD_JUR_CD, WTHD_CLASS, and WTHD_RULE.
The linking of a withholding PYMNT_VCHR_XREF (PYMNT_TYPE = W) to its PYMNT_VCHR_WTHD entries is 1 to 1 and is linked in the following way for backup withholding:
PYMNT_VCHR_XREF.BUSINESS_UNIT |
= |
PYMNT_VCHR_WTHD.BUSINESS_UNIT |
---|---|---|
PYMNT_VCHR_XREF.VOUCHER_ID |
= |
PYMNT_VCHR_WTHD.VOUCHER_ID |
PYMNT_VCHR_XREF.ORIG_PYMNT_CNT |
= |
PYMNT_VCHR_WTHD.PYMNT_CNT |
PYMNT_VCHR_XREF.WTHD_PYMNT_CNT |
= |
PYMNT_VCHR_WTHD.WTHD_PYMNT_CNT |
Example #1: Two-Line Voucher with Single Payment
Assumptions include:
Total 1000 USD: Line 1: 500 USD, Line 2: 500 USD.
Line 1 withholding is 31%.
Line 2 withholding is 20%.
PYMNT_VCHR_XREF:
Payment Count |
Paid Type |
Payment Gross Amount |
Original Payment Count |
Withhold Payment Count |
---|---|---|---|---|
1 |
R |
745.00 |
0 |
0 |
2 |
W |
155.00 |
1 |
1 |
3 |
W |
100.00 |
1 |
2 |
PYMNT_VCHR_WTHD:
Payment Count |
Withhold Payment Count |
Entity |
Type |
Juris |
Class |
Rule |
Withhold Basis Amount |
Withhold Amount |
---|---|---|---|---|---|---|---|---|
1 |
1 |
CA |
1099 |
North |
04 |
RULE4 |
500.00 |
155.00 |
1 |
2 |
IRS |
1099 |
South |
02 |
RULE2 |
500.00 |
100.00 |
VCHR_ACCTG_LINE (assuming summary control posting method):
Posting Process |
Payment Count |
Type |
Account |
Foreign Amt |
---|---|---|---|---|
PYMN |
1 |
APA |
200000 |
1000.00 (dr) |
PYMN |
1 |
CAS |
100001 |
745.00 (cr) |
PYMN |
1 |
WTH |
100011 |
155.00 (cr) |
PYMN |
1 |
WTH |
100012 |
100.00 (cr) |
Example #2: Two-Line Voucher with Split Payments
Assumptions include:
Total 1000 USD: Line 1: 700 USD, Line 2: 300 USD.
Payment split is 600 USD / 400 USD.
PYMNT_VCHR_XREF:
Payment Count |
Paid Type |
Payment Gross Amount |
Original Payment Count |
Withhold Payment Count |
---|---|---|---|---|
1 |
R |
433.80 |
0 |
0 |
2 |
R |
289.20 |
0 |
0 |
3 |
W |
130.20 |
1 |
1 |
4 |
W |
36.00 |
1 |
2 |
5 |
W |
86.80 |
2 |
1 |
6 |
W |
24.00 |
2 |
2 |
PYMNT_VCHR_WTHD:
Payment Count |
Withhold Payment Count |
Entity |
Type |
Juris |
Class |
Rule |
Withhold Basis Amount |
Withhold Amount |
---|---|---|---|---|---|---|---|---|
1 |
1 |
CA |
1099 |
NORTH |
04 |
RULE4 |
420.00 |
130.20 |
1 |
2 |
IRS |
1099 |
SOUTH |
02 |
RULE2 |
180.00 |
36.00 |
2 |
1 |
CA |
1099 |
NORTH |
04 |
RULE4 |
280.00 |
86.80 |
2 |
2 |
IRS |
1099 |
SOUTH |
02 |
RULE2 |
120.00 |
20.00 |
VCHR_ACCTG_LINE (assuming summary control posting method):
Posting Process |
Payment Count |
Type |
Account |
Foreign Amount |
---|---|---|---|---|
PYMN |
1 |
APA |
200000 |
600.00 (dr) |
PYMN |
1 |
CAS |
100001 |
433.88 (cr) |
WTHA |
1 |
WTH |
100011 |
130.20 (cr) |
WTHA |
1 |
WTH |
100012 |
36.00 (cr) |
PYMN |
2 |
APA |
200000 |
400.00 (dr) |
PYMN |
2 |
CAS |
100001 |
289.20 (cr) |
WTHA |
2 |
WTH |
100011 |
86.80 (cr) |
WTHA |
2 |
WTH |
100012 |
24.00 (cr) |