Page Comparison

Benefit:

• Minimize Reduce time and effort to analyze patronage transactionsto calculate the Qualified Payments amount in Box 7 of the 1099-PATR based on your situation.
• Maximize flexibility to calculate the Qualified Payments amount in Box 7 of the 1099-PATR based on your situation.

Navigation - Usage: 

PAT > Report Manager >

Advanced Reports > 1) Print

Advanced Reports > 8) Qualified Payments Export/Import (Report ID 90005) 

1. Select Standard Report 2, Transaction Audit Detail SpreadsheetImage Removed8, Qualified Payments Export/Import
   1. Image Added
2. The following columns of data appear in the spreadsheet:
   1. PATRON NAME IDImage Added PATRON
   2. NAME
   3. SOCIAL SECURITY #
   4. CELL PHONE
   5. User Defined #3
   6. TRANSACT DATE
   7. PROCESS DATE
   8. LOCATION
   9. TRANSACT NUMBER
   10. TRANSACTION TYPE
   11. TRANSACTION DESCRIPTION
   12. DISTRIBUTION TYPE
   13. DISTRIBUTION DESCRIPTION
   14. STOCK/EQUITY TYPE
   15. STOCK/EQUITY DESCRIPTION
   16. ACTIVE CERT./EQUITY
   17. CERT./EQUITY NUMBER
   18. ORIG. CERT./EQUITY
   19. INVC/ VOUCH
   20. SHARES
   21. PERCENT
   22. ALLOCATED FUNDS
   23. DIST. AMOUNT
   24. STOCK CREDITS
   25. CREDITS BALANCE
   26. STOCK ISSUED
   27. STOCK BALANCE
   28. AMOUNT PAYABLE
   29. PATRON EQUITY
   30. EQUITY BALANCE
   31. GENERAL RESERVE
   32. EQUITY REMAINING
   33. ALTERNATIVE MINIMUM TAX
   34. TRANSACTION AMOUNT
   35. LOCATION DESCRIPTION
   36. LOCATION REM #1
   37. LOCATION REM #2
   38. NAME ID TYPE
   39. MEMBER
   40. PRODUCER
   41. NEWSLETTER
   42. DIRECTOR
   43. Customer Type
   44. CREDIT RATING
   45. NAME ID TYPE DESCR.
   46. MEMBER DESCR.
   47. PRODUCER DESCR.
   48. NEWSLETTER DESCR.
   49. DIRECTOR DESCR.
   50. Customer Type DESCR.
   51. CREDIT RATING DESCR.
   52. BIRTH DATE
   53. EQUITY SOURCE CODE
   54. EQUITY DESCRIPTION
   55. STN ID
   56. USR ID
   57. AUDIT DATE
   58. AUDIT TIME
   59. AUDIT TYPEType
   60. Qualified Payments (with standard formula)
   61. Patron Name
   62. Refund Cash
   63. Refund Qualified Stock
   64. Refund Non-Qualified Stock
   65. Refund Qualified Equity
   66. Refund Non-Qualified Equity
   67. Refund General Reserve
   68. Source Allocation Qualified Equity
   69. Source Allocation Non-Qualified Equity
   70. Source Allocation General Reserve
   71. Payback Qualified Stock
   72. Payback Non-Qualified Stock
   73. Payback Qualified Equity
   74. Payback Non-Qualified Equity
   75. Payback General Reserve
   76. Per Unit Retain Allocation

Related Content: