Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Benefit:

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


Navigation - Usage: 

PAT > Report Manager >

Transaction Audit

Advanced Reports > 1) Print

Standard Reports > Transaction Audit Detail Spreadsheet

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. AGS-10817-QualifiedPayments2020-02-19_07h07_12.pngImage Added
  2. The following columns of data appear in the spreadsheet:
    1. PATRON NAME IDAGS-8017-QualifiedPayments-Example2020-02-19_07h08_20.pngImage 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:

Page Tree
rootPAT - Patronage (1920.31.0)