Upload carcass sale data via CSV import

By uploading your carcass sale data via a CSV import, you can:

• Log all carcass grading information against individual animals.

• View this data in the Carcass History report.

• Automatically generate an off-movement, ready for approval and submission to BCMS/ScotEID in your Regulatory Dashboard (by including ‘Departure Date’ and ‘Move Off Farm To’ columns in your carcass CSV file).

• Record an off-movement either before, during, or after uploading carcass sale information.

• If carcass sale data is uploaded with a ‘Kill Date’ but without a ‘Departure Date’, the animals will remain in your ‘My Cattle’ tab and will not be automatically moved to the Archive.
  
  
  

What information do you need in the CSV file to upload a carcass sale to Breedr?

• Animal ID (passport number or EID number)
• Kill Date
• Buyer
• Kill Number
• Grading (split into two further columns below)
• Fat Class
• Conformation
• Carcass Cold Weight 

To automatically generate an off-movement via a CSV file, you need to add the additional information:

• Move Off Farm To (must be a contact in your Address Book in Settings)
• Departure Date (must be before or matching the Kill Date)

You can download the Carcass Sale Template provided to record all required carcass information and, optionally, automatically generate an off-movement.

The formulas to split the 'Grading' into 'Fat Class' and 'Conformation' are already described in this template. This teaches you how best to split your grading if you don't want to use the template above and/or require some more understanding of the formula:

1. 1. For the grade O+4L in H2, the formula for Fat Class (I2) in this example is: =RIGHT(H2,2) [it is taking the right 2 digits ('4L') from H2]. For the grade O+3 (H3) the Fat Class cell I3 has the formula =RIGHT(H2,1) [it is taking the right 1 digit ('3') from H2].
   2. For the grade O+4L in H2, the formula for Conformation column G is: =LEFT(H2,2) [it is taking the left 2 digits ('O+') from H2]. 
   3. Click into cell I2 and use the bottom left green box to click and hold down to pull down column I. This copies the formula down the length of your grading data. Do the same with column G.

Upload your carcass sale CSV file to the web app:

1. From the 'Upload' tab, select 'Custom Import' > 'Financial'.
2. 'Carcass Sale'.
3. Upload your CSV file by clicking 'Upload file' and selecting the file you wish to upload.
4. Click 'Next', or, if you have uploaded the incorrect file, select 'Change file'.
5. Match the headings as necessary. To assign or change a column header, use the dropdown arrows to find the appropriate heading. 
   
   1. Green indicates an exact match with our system's column headings.
   2. Yellow means that the system has made an assumed match, or you've manually selected a heading.
   3. 'IGNORE' columns will be excluded from the upload, so if these columns are required, ensure a heading has been selected.

   Important: Please double-check that all column headers are correctly matched before clicking 'Finish upload'. 

6. A green banner will display if you have successfully uploaded the carcass sale information against the animals. Click 'View all animals' to see the updated information.

Relevant articles:

Record financial activities in Breedr

Deleting activities on the mobile and web app

Overview of logging activities against animals

Move animals off your holding in Breedr

Need some help? Use the chat window to your right on the web or the help button on your mobile app, call our Customer Support team on +44 (0) 3300 436327 or email support@breedr.co.