Working with the AgriStability Worksheet

AgriStability is a business risk management program designed to help farm operations facing large margin declines caused by production loss, increased costs, or market conditions.  Coverage is personalized for each farm by using historical information based on income tax and supplementary information.

AgExpert Accounting can track your inventory information and provide you with your supplemental information for your AgriStability reports.  To access this information, click Inventory on the left navigation menu.

Click Advanced inventory.

Click AgriStability worksheet.

Each section of the worksheet has its own tab.  You can click the different tabs to access the different areas to work on.  You will see different tabs depending on what province your farm is located in.

Livestock

This tab consolidates all your livestock inventory transactions.  Anywhere you see an arrow, you can click to view and edit details.

Both the grade and the inventory transaction type can be edited as needed.  Simply use the drop down to select the correct information and click Save when you are done.

Any transactions that have missing information will be listed below the worksheet information.  Click the inventory account listed to provide the missing information.

Crops

This tab consolidates all your crop inventory transactions.  Anywhere you see an arrow, you can click to view and edit details.

Both the grade and the inventory transaction type can be edited as needed.  Simply use the drop down to select the correct information and click Save when you are done.

Any transactions that have missing information will be listed below the worksheet information.  Click the inventory account listed to provide the missing information.

You can set your acres (both harvested and unharvested) by clicking on Set on the appropriate line.

Purchased Inputs

This tab consolidates all your input inventory transactions.  The only information that gets tracked is what your inventory value was at the beginning of the year and what your inventory value at the end of the year was.

Any transactions that have missing information will be listed below the worksheet information.  Click the inventory account listed to provide the missing information.

Deferred income & receivables

 This tab keeps a running total of any deferred sales at the beginning of the year, and any deferred sales at the end of the year.  Deferred sales are sales that are made in the current fiscal year, but are not paid until the next fiscal year.

Only allowable sales will appear on this tab.  This is set when you are setting up the income account in the chart of accounts.  You must assign the T1163/T1273 line number to an allowable income.

Accounts payable

This tab keeps a running total of any accounts payable at the beginning of the year, and any accounts payable at the end of the year.  Accounts payable are expenses that are incurred in the current year, but are not paid until the next fiscal year.

Only allowable expenses will appear on this tab.  This is set when you are setting up the expense account in the chart of accounts.  You must assign the T1163/T1273 line number to an allowable expense.

Perishable

This tab consolidates all perishable crop information.  It is only available if your province is set to Prince Edward Island, and generally deals with potato inventory.

You will see a list of your potato sales, whether payment has been received or not.

You can set the date you expect to receive payment on the sale if it has not yet been received by clicking Set.

Other Features

You can record inventory adjustments directly from the worksheet if required by clicking Adjust Inventory.

The inventory adjustment slider will open for you to create your transaction.  Once you record it, the worksheet will update automatically.

To print your worksheet, click Print at the top right of the screen.

Last updated on December 8, 2020 by FCC AgExpert