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 worksheet allows you to track private sales for up to 3 different months for the same crop type. The first 2-columns of this worksheet have had their data transferred from the appropriate section of the production worksheet. 

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 fulfill 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