Follow

Pool Income Worksheet

The Pool Income Worksheet is used to break out the yield detail based on gross sales and any freight and storage costs. The summary information from the Crop Production worksheet is sent into the Pool Income Worksheet. The Pool Income Worksheet gives you the option for forecasting the 4 months that the grain pool advances are paid. 

Crop Pool Income Columns 

1.    Crop Type

 

Agrimaster will copy the Crop Type (crop names) from the Production Worksheet

2.    Tonnes

 

Agrimaster will copy the calculated Total Yield (in tonnes) from the Production Worksheet

3.    Gross per Tonne

 

Type the dollar amount your pool is paying per tonne for this crop

4.    Est Costs/tonne

 

Type the dollar amount for the total costs for freight, handling and storage as part of the sale of the crop to your grain pool

5.    Net Return $

 

Agrimaster calculates the net dollar value of the sale (Tonnes multiplied by Gross per Tonne) and subtracts the Est Costs/tonne

  

Optional: Use the Calculator 

Press the F3 anywhere you want a calculator to figure out a number. 

For example, click into Est Costs/tonne and press F3 


After calculating your total, click EX to transfer the number in

 

Optional Budgeting for Pool Advances 

1.    First Adv. $/T
Second Adv. $/T
Third Adv. $/T
Fourth Adv. $/T

 

Type the net dollar amount of the first advance in dollars per tonne. To get the net dollar amount, subtract the handling and selling charges per tonne from the sales price

2.    Total First Adv.
Total Second Adv.
Total Third Adv.
Total Fourth Adv.

 

Agrimaster will calculate the total of your first advance from the pool by multiplying the Tonnes by the Adv. $/T for this
Crop Type (crop in this row)

3.    Month F5
(up to 4 occurances)

 

Press the F5 key to select the Cash Book Code and Bank Account to which the Pool Advance will be booked agaisnt

 

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 the selcetions

 

Review the Advance Calculations 

If you are receiving grain pool advances, Agrimaster will calculate the closing payment from the grain pool. 

  

4.    Later Adv.

 

Agrimaster calculates the remaining dollars per tonne for the final advance (payment) from the grain pool 

If you are tracking grain pool advances, Agrimaster adds up the Total Adv. and subtracts the advances from the 
Net Return $.

If you are not using advances the totals will match the calculated Net Return $.

5.    Total Later $

 

Agrimaster displays the amount of the final grain pool payment for that Crop Type 

Agrimaster subtracts any money listed in any of the Total Adv. from the Net Return $

 

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