Expense Data Import

Required Fields

Company Code: The Company Code for the record.  This can be found on the Facility Management view.

Division Code: The Division Code for the record.  This can be found on the Facility Management view.

Farm Code: The Farm Code for the record.  This can be found on the Facility Management view.

Group Code: The Flock Code for the record.

House Code: The House Code for the record you want to enter.  This can be found on the Facility Management view.

Open

Transaction Type: The transaction type of this expense (Add or Subtract).

Expense Code: The expense code for this record. Use a leading apostrophe in the event of a code with leading 0s.  See: Expense Codes

Amount: The total cost of the expense.

Expense Date: The date this expense was incurred (MM/DD/YYYY).

Optional Fields

Sex: The sex code for this record. (Female, Male. Unspecified).

Ticket Number: A ticket number associated with this expense.

Invoice Number: An invoice number associated with this expense.

Component Code: A Component Code associated with this expense.  See: Components

Component Units: The total count of units associated with this expense.

Component UOM: The unit of measure description for this component.

Comment: Any comments or remarks for this record.

Make sure to leave the Header and Control Lines (Rows 1 and 2), You can enter your data starting row 3.

Make sure that the tab is named Sheet1 as the import will look for this tab name to pull data.

Open