Setting up a data file for AgriStability reporting

To set up AgExpert Analyst to track the information needed for AgriStability, complete the following:.

Specify your AgriStability province

Note: This ensures that the correct supplementary report is generated.

1. Select Preferences from the Setup menu. The Preferences dialogue box appears.
2. Click the General tab.
3. Select your AgriStability province from the list.
4. Click Save. 

Record your opening inventory balances

The opening inventory value displays on the inventory column of the AgriStability supplementary report.

If you entered opening quantities and balances for your inventory accounts during the original opening balance setup, skip to the Edit inventory accounts for AgriStability section.

If you haven’t entered opening inventory balances or have set up a new inventory account:

1. Select Inventory Adjustment from the Inventory menu. The Select Postable Account - Inventory dialogue box appears.
2. Select an inventory account from the list and click Select. The Inventory Adjustment dialogue box appears. Note: If the account isn’t listed, click Add to create it. Select the Adjust Balance tab.
3. Enter the Date or click the arrow and select it from the calendar.
4. Enter a Number to identify the transaction throughout AgExpert Analyst. For example, use a cheque, invoice or receipt number.
5. Enter a Description or click the arrow to choose an existing description.
6. Enter a positive number for the opening Inventory count.
7. Enter an estimated Value per inventory unit. Refer to the unit label for proper valuation (dozen, head, tonne, etc.). The total value of the inventory calculates automatically.
8. Press the [Tab] key. The Total value field updates automatically.
9. Click Record to record the transaction.
10. Repeat these steps for each inventory account that needs an opening balance. 

Edit inventory accounts for AgriStability

For proper AgriStability reporting, you must set up each inventory account with detailed inventory tracking and the appropriate AgriStability commodity code for your province and region.

To edit your inventory accounts for AgriStability:

1. Select Setup Inventory Accounts from the Inventory menu. 
2. Select an account to set up to track detailed inventory.
3. Select the Commodity type from the list: Crop, Inputs, Livestock or Perishable.
4. Select a Unit label from the list or enter one.
5. Click Edit Inventory Details if there is a warning on inventory account. Enter the missing information and click Save.
6. Repeat the above steps for each account that requires detailed inventory.
7. Select the Income and Expense Accounts tab to change AgriStability reports and manage inventory in income and expense accounts.
8. Click Close.

You can now generate an AgriStability supplementary report to see your business’s initial inventory with the proper AgriStablity commodity codes and its opening inventory amounts allocated to the proper grades and weight ranges. 

Set up income and expense accounts

Ensure that the income and expense accounts are mapped to an appropriate AgriStability/T1163/T1273 report line number, or they won’t be included on the AgriStability/T1163/T1273 Statement A report.

To set up the AgriStability/T1163/T1273 report line number for income and expense accounts: 

1. Select Chart of Accounts from the Setup menu. The Chart of Accounts dialogue box appears.
2. Select either the Income or Expense tab.
3. Double-click the account you want to edit, or select it and click Edit.
4. Enter the AgriStability/T1163/T1273 report line or click … to select one from a list.
5. Click Save. Repeat the above steps until all income and expense accounts that track inventory have a valid AS/T1163/T1273 report line number.
6. Click Close. 

Last updated on January 29, 2016 by FCC AgExpert