1
2 Objectives
3 Per-Unit-Retains – what are they
4 Things to Know
5 Business Rules
6 Examples
7 Accumulating Per-Unit-Retains
8 Notes on the Report Created
9 Per-Unit-Retain Allocation Remarks
10 How to Correct if Incorrect
11 Standard Export report for Per-Unit-Retains
12 Steps to Import the Spreadsheet (file)

Objectives

Version 18.1 (January 2018) released a completely re-vamped Patronage per-unit-retains function. This function will give you a better way to update the per-unit-retains for the 1099 reporting and it will also allow imports to stop.

Determining the Amount of the 1099 Per-Unit-Retain to distribute to each patron.
Learn about all the small questions to be answered in regards to how you distribute per-unit-retains.
Learn how to run the report that will auto update per-unit-retains.
Learn how to create spreadsheets, if you still want to import instead of auto update.
Learn how to make Corrections to the dollar amounts for each patron.

Per-Unit-Retains – what are they

The per-unit-retains is the amount that represents the Patron's farm products that were sold to a cooperative, which is the Coop's Grain Purchases & the Farmers grain sales. This amount, reported in Box 3 of the 1099-Patr, is fixed based on the grain settlements, regardless of the income/loss that the cooperative received. This becomes income to the farmer and they must report it as such. If the income on the Form 1099-Patr (per-unit-retains) does not match the income reported on a Schedule F of the individual's income tax return, the farmer would receive a notice from the IRS advising them that their income was understated and more tax is due.
So this process is all about reporting a Patrons Grain Sales to the IRS, if the sales were done via a Coop that the Patron is a member of.

Things to Know

Name id must be marked YES or WITHHOLDING for ACCUMULATE PATRONAGE.
NAM > Name id Maintenance > Select Name > general information > Accumulate Patronage must equal Yes or Withholding.
The new Per-unit-Retain reporting will allow you to update the per-unit-retain with three possible calculations: * Gross = Net Quantity times Contact Price* Net = Settlement Amount* Value of Grain = Gross adjusted by all "value discounts" such as Moisture, FM, Test Weight, Etc. but not by service charges such as Weighing and inspection fees, storage charges, etc.
It is our understanding that gross dollars are to be reported for the activity in a given calendar year less non-value deduction such as storage, drying, trucking, check-off expenses, etc. Please check with your auditor to verify. But note that you will now have 3-options of what value to post so we can handle however your auditor recommends.
The Section 199 Per-Unit-Retains are to be reported in Box 3 of the 1099-PATR form.

It is recommended that you create a folder in My Documents or on your desk top. Use this folder to store the reports that you will be creating. The reports are one-time reports so spool them to the spool, then save an electronic copy somewhere else.
Settlement Split Name id: The per-unit-retain calculation is designed to print based on the settlement split name id. This is the person that received the check.
There is now a standard import report for importing source Allocations. AGRIS > Pat > Report manager > Advanced Reports > Per-Unit-Retain Allocation Export (AGEXPIMP.CSV>this will create the import file and allow you to tweak the values before importing them into the system.

Business Rules

The following business rules will be used to determine the per-unit retain allocation:
Each of the topics below refers to each split payment distribution of Purchase Settlements. The settlement split Name ID is used to determine each party's share of the Grain Value toward their Per-Unit Retain allocation.

#	Purchase Settlements	Notes

#	Purchase Settlements	Notes
1	Advance Settlement	The total Advance Amount will be reported for each split payment Name ID based on the date of the settlement, unless an A/P Voucher/Credit Memo is created. The A/P check amount will be reported based on the date of each A/P Disbursement.
2	Discount Settlement	No amount will be reported for discount settlements (settlements for storage charges, or any other type of discounts and/or premiums).
3	Final Settlement	The total Value of the grain, minus all advances will be reported based on the date of the settlement, or the date of the A/P Disbursement. If the settlement was split between multiple parties, the Grain Value is also prorated by the same split percentage.
4	Client Load-Out Settlement	No amount will be reported.
5	Contract Cancellation Settlement	No amount will be reported when a contract is cancelled, and a settlement is created as a cancellation charge. No grain was purchased and there is no Grain Value.
6	Settlement Reversals	All reversals of Advances and Final Settlements will produce the opposite dollar affect, based on the date of the reversal.
7	Reopen and Resettle	The net effect of the resettled Grain Value will be reported (a negative amount of the old value plus a positive amount of the new value)

Examples

The following examples are supplied to explain the different methods of settlement distribution. Each of the examples will report the appropriate value of grain purchases, regardless of how each of the split Name IDs were "paid" (by check, credit memo, A/R invoice, etc).
These examples assume that the DM discount (Damage) is set up as a discount that does affect the value of the grain, but SC (Storage Charges) does not affect the value.

#	Settlement Scenario	Result

#	Settlement Scenario	Result
1	$1000 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1000 advance = $50 GRN Settlement Check	$1000 reported in 2017 $150 reported in 2018 (1200 - 50DM - 1000 advance) Total reported = $1150 value
2	$1000 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1000 advance = $50 A/R Reduction The $50 payment was applied to the patron's outstanding A/R balance.	$1000 reported in 2017 $150 reported in 2018 (1200 - 50DM - 1000 advance) Total reported = $1150 value
3	$1000 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1000 advance = $50 A/R Credit Memo This is very similar to #2. Both examples 2 and 3 will reduce the patron's A/R Balance. Example 2 reduces his balance by paying off some existing invoices. Example 3 reduces his balance by issuing another credit memo invoice.	$1000 reported in 2017 $150 reported in 2018 (1200 - 50DM - 1000 advance) Total reported = $1150 value
4	$1000 advanced in 2017, with another 2017 final settlement of $1200 - $50DM - $100SC - $1000 advance = $50 A/P Voucher In 2018, the disbursement was processed out of the Accounts Payable system = $50 Check. Or, In 2018, the $50 A/P Voucher was transferred to A/R as an A/R Credit Memo, resulting in a decrease to the patron's A/R Balance.	$1000 reported in 2017 $150 reported in 2018 (1200 - 50DM - 1000 advance) Total reported = $1150 value
5	$1050 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1050 advance = $0 (zero-dollar settlement) Even though the final settlement was for zero dollars and the customer did not receive any additional payment, the final settlement results in $100 being reported for per-unit retain allocation. The only time that the actual Grain Value can be calculated is at the time of the final settlement. The final calculation of the Grain Value is reduced by all previous advances that have already been reported.	$1050 reported in 2017 $100 reported in 2018 (1200 - 50DM - 1050 advance) Total reported = $1150 value
6	$1100 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1100 advance = -50 ($50 GRN Settlement Receipt)	$1100 reported in 2017 $50 reported in 2018 (1200 - 50DM - 1100 advance) Total reported = $1150 value
7	$1100 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1100 advance = -50 ($50 A/R Invoice)	$1100 reported in 2017 $50 reported in 2018 (1200 - 50DM - 1100 advance) Total reported = $1150 value

8	$1100 advanced in 2017, with a 2018 final settlement of $1200 - $50DM - $100SC - $1100 advance = -50 ($50 A/P Credit Voucher)	$1100 reported in 2017 $50 reported in 2018 (1200 - 50DM - 1100 advance) Total reported = $1150 value
	Every example above results in a consistently reported Grain Value of $1,150. The Grain Value is calculated by the $1,200 gross amount (net quantity times contract price) minus the $50 DM (Damage) discount. The SC (Storage Charge) deduction does not affect the Grain Value. The method of payment to the patron does not affect the Grain Value.
9	With no previous advances, a 2017 final settlement was done of $1200 - $50DM - $100SC = $1050 GRN Settlement Check	$1150 reported in 2017 (1200 - 50DM)
10	On the same settlement as in #9, some Contract Cancellation delivery sheets were also included to charge the patron $600 for not delivering on his committed grain, and some client load-out delivery sheets were also included for $600 storage charges. The patron owes you more than the $1050 that you are paying him. $1200 - $50DM - $100SC - $600 Contract Cancellation - $600SC = -150 ($150 A/R Invoice)	$1150 reported in 2017 (1200 - 50DM) (Contract cancellations and client load-out are not relevant)
11	In 2017, the patron paid you for the DM and SC discounts with a discount settlement $0 purchase - $50DM - $100SC = -150 ($150 A/R Invoice) In 2018, the final settlement was done of $1200 - no unpaid discounts = $1200 GRN Settlement Check	$0 reported in 2017 $1150 reported in 2018 (1200 - 50DM)
12	In 2017, a final settlement was done of $1200 - $50DM - $100SC = $1050 GRN Settlement Check In 2018, that settlement was reversed and settled again as $1300 - $50DM - $150SC = $1100 GRN Settlement Check	$1150 reported in 2017 (1200 - 50DM) $100 reported in 2018 (-1150 reversal + 1300 - 50DM)
13	In 2017, a final settlement was done of $1200 - $50DM - $100SC = $1050 GRN Settlement Check In 2018, that delivery sheet was reopened, adjusted, and resettled $1300 - $50DM - $150SC - 1050 original settlement = $50 GRN Settlement Check	$1150 reported in 2017 (1200 - 50DM) $100 reported in 2018 (-1150 reopen + 1300 - 50DM resettle)
14	In 2017, a final settlement was done of $1200 - $50DM - $100SC = $1050 and was split 60/40 to two patrons = $630 and $420 GRN Settlement Checks	$690 to the first patron (1200 - 50DM) x 60% $460 to the second patron (1200 - 50DM) x 40% Total reported = $1150 value

Accumulating Per-Unit-Retains

There are two ways to get to the Per-Unit-Retains Calculation.

Pat > Patronage Transactions > Source Allocation > 5) Per-Unit-Retain Allocations
PAT > Report Manager > Advanced Reports > Per-Unit-Retain Allocations Report

Both of these paths will get you to the same screen that allows you to accumulate the per-unit-retain source allocation transaction that will be saved in the patronage transactions.

GREEN options - Limit the report or creation of per-unit-retains to a range of names, locations & commodities.
GRAY options - Use the name id fields to limit the range of name id's that will be used to create the per-unit-retain transactions. Ideally, this will match how you payout your patronage accumulation but it could change under certain circumstances
RED options - There are 6 Y/N questions for the different settlement distribution types. If you want to eliminate a type, you can exclude it by answering NO. Note that AP vouchers are considered the same as a grain settlement to a check, so they are always included
YELLOW options - Delivery Sheet Detail Lines? – Yes will post all the detail that makes up the calculation.

No will post a single line for each grain settlement

New Page for Each Customer? -

Yes will create a new page for each customer so that's easier to provide a copy of this report to your patron's. I would make the report print out like a statement, so that you could just mail the per-unit-retain detail to the customer as proof behind the allocation.

Notes on the Report Created

RED Warning - If an allocation already exists for that customer and date range, you are warned on the report. It will still create an allocation transaction, so you can double or triple this amount up if you run and post the report over and over. But you do get a warning on the report. This warning occurs whether you are updating totals or not.

RETAIN

Detail – All the settlements (with or without delivery sheet detail) are included on the report so that you may verify what is being allocated. Note that this detail is coming from the Grain package. This is not from accumulated patronage activity.
Grand Totals – on the last page, grand totals of each calculation figure will be totaled for easy validation.
If you answer NO to any of the grain settlement types, the grand totals amounts will state NA (not applicable) so you know what you flagged.

Per-Unit-Retain Allocation Remarks

Every allocation created for the customer will have a series of Remarks that give that provides the detail for what makes up the totals.
It's the grand total for each settlement type for that allocation.
This is provided for research purchases.
NOTE: if you answered NO to a certain settlement type, such as A/R Reductions, then the notes would say NA as in you didn't use this field to calculate.

Also note that this remarks can be edited via Account Balance Inquiry.

How to Correct if Incorrect

If you find that the per-unit-retain is wrong for an individual you can take the following steps to correct.

In Patronage, through Account Balance Inquiry select the Patron with the problem and display Transaction History.
Locate the transaction for the Source Allocation and make note of the transaction Number.

Reverse the transaction by going to Patronage Transactions and then selecting Reverse Transactions.
Go to AGRIS > PAT > Report Manager > Advanced Reports > Standard3. Per-Unit Retain Allocation, One Name id

Enter the name id and verify fiscal year date range.
At bottom, key in dollar amount.
Then select if it should POST (green highlight.)

Note: The report will create Remarks that identify that this is a manually keyed amount.

Standard Export report for Per-Unit-Retains

Before 18.1 (January 2018), you could create a grain settlement report that you could then massage into an import file to bring in the Per-Unit-Retain.
Now there is a standard export report that will create an import file using the logic that we have already covered above.
AGRIS > PAT > Report Manager > Advanced Reports > Standard > Per-Unit-Retain Allocation Export (AGEXPIMP.CSV)

Columns A-N These are the columns that will be used for the import file.The ability to edit the column N will allow you to create a different amount than what was calculated.
Columns O - End of import Fields. All information after this is to help you calculate column N manually
Columns P-AZ Grain Settlement Detail & Name ID Detail

Steps to Import the Spreadsheet (file)

At the Main Menu of AGRIS go to Reports.

Then select Import Procedures
At the next screen select Comma Separated Import File. If you do not have this import procedure, one can be defined. If you need help, call Support at 800-366-2474.

At the next screen, enter the name of the file that you are wanting to import or you can search for it. Change the Output file name to RetainsReject leaving the EXT as CSV. Click Ok. The file will now import. If there are issues, call Support at the number above.

~ Document Written by Alisa Mueller

AGRIS Customer Documentation

How to Create Per-Unit-Retains for PAT 1099