Report for Names that had Federal Income Tax Withheld from their Refund or Equity Payback

GOAL:

 A report that prints a listing of the names that federal income tax was withheld.

Eventually you’ll be able to transfer the report to your user-defined reports via Custom Transfer Options.  But as of 22.1, the report is not there yet. You must design it on your own.

Utilities > Transfer Reports/Forms > 5) Custom Transfer Options
reports/forms:  select option 1
Package: PAT
Look for TAX WITHHELD report.

Open

Report filters for a Patronage Transaction Reports:

1. PAT > Report Manager > Transaction Reports > User-defined

2. Tax Withheld Report

3. Range Selection Criteria

4.      Transaction Date of this year (2nd row of data)
        Leave Date Processed blank
        distribution Type 8 to 8 for Reserve

5. value selection criteria
         2nd option called PERCENT
         Set the option to 2 and the value to 100
        so we want any RESERVER amount that does NOT equal 100%.
        this is the same criteria the 1099-Pat form uses to gather the tax withheld amount.

6. Print.

Testing 1099 against report

A way to check this report is to run the 1099-PATR form using the substitute form. 
Print to screen.
Go to the LAST page of the report where the totals are.
it will give the grand total in box 4 (Federal income tax withheld)
It should match the transaction report.

Pat > 1099 > print 1099 forms
key in  dates
use substitute form
Print to screen.