Follow

Non Pool Income Worksheet

The Non Pool Income Worksheet forecasts the private sales of grain. For example, you may plan to sell a portion of you yield to a private mill or to a neighbour. 

The Non Pool Income Worksheet allows you to track private sales for up to 3 different months for the same crop type. 

If you are obligated to contract sales or cash sales, do not use this worksheet. Use the Grain Calculator tool in combination with the Pool Income Worksheet. 

 

1.    Crop Type

 

Agrimaster copies the Crop Type (crop names) from the Production Worksheet

2.    Total Non Pool Tonnes

 

Agrimaster copies the Non Pool tonnes from the Production Worksheet

3.    Sale #1 Tonne
Sale #2 Tonne
Sale #3 Tonne

 

Type in the number of tonnes to be sold through a private sale

4.    Return Per Tonne
(up to 3 occurances)

 

Type the number of the expected price per tonne to be paid by the private buyer

5.    Return $
(up to 3 occurances)

 

Agrimaster will calculate the total sale

6.    Month F5
(up to 3 occurances)

 

Press the F5 key to select the Cash Book Code and Bank Account where the buyer sends the payment

 

In Distribute, choose the frequency (Any 1, 2, 3 or 4 months recommended) 

In First Month, choose the month the advance will be sent to your business 

In Select Code, choose your Agrimaster Cash Book Code and the Bank Account where the advance will be deposited 

 Click on the green tick to OK

 

Unsold Carry Over Grain

The Carry Over columns ensure you are not overselling your expected yield or help you decide what the value of unsold surplus grain. 

 

7.    Carry Over

 

Agrimaster calculates the amount of grain left over after the private sales to Non Pool buyers 

A positive number means that the grain is an unsold surplus 

A negative number may mean the number of tonnes for the private sales were not accounted for on the main Production Worksheet, or not enough grain will be yielded to fulfil the sales

8.    Value/Tonne Carry Over

 

Type the dollar value per tonne of the unsold surplus grain if the Carry Over is a positive number

9.    Total $ Carry Over

 

Agrimaster calculates the total dollar amount of the unsold grain. Agrimaster multiplies the Carry Over by the Value/Tonne Carry Over

 

Click the green tick to save the Worksheets

 

Fixing a Negative Carry Over 

If you know you have the private sale of grain to a Non Pool buyer but didn’t enter the tonnes in the main Crop Production Worksheet, you will see a negative number in the Carry Over. 


1.    Click on the Production Worksheet 



2.    If there is enough grain to cover the Non Pool sales 

·         In Non Pool, type the positive number that matches the negative Carry Over amount

·         Reduce one of the other Crop income numbers by the amount you are placing in the Non Pool column 

In this example, the Pools Non-Loan was reduced from 300 tonnes to 280 tonnes to allow for the 20 tonnes of Non Pool sales. After the negative Carry Over is corrected, the Non Pool Income Carry Over columns will be blank. 

Click on the green tick to save the Worksheets

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments