Summary:
Through the new Expense Transfer Reconciliation form, AeLive has the ability to reconcile outstanding expenses left from discrepancies in head counts during the process of transferring animals from one group to another.
Once all expenses, feed deliveries, ending feed inventory and/or feed returns are entered into the system and all transfer-outs are finalized, select the Reconcile button for the selected flock and perform the steps shown in this document.
At the end of the group the starting number of head minus mortalities and transfer outs may not equal zero. Because of this, remaining dollars that belong to those birds (that really do not exist because of count discrepancies) remain in the flock. Through the reconciliation form, AeLive will give the user the option of applying those remaining dollars to the last transfer or allocate among the transfers based on the percentage of the dollars originally transferred.
This article describes how to use this form with the example of a pullet flock transferring into two different commercial egg laying houses.
Step 1: Finalize Transfers
After entering all transfer outs from a pullet flock to a layer flock, select the “Finalize” button on the bottom left of the form. The finalize button will move the flock from active status to settlement status. When the flock is in a status of “Settlement,” users are allowed to enter any additional expenses, feed deliveries, ending feed inventory and/or feed returns against that flock.
The Finalize button creates a clear stop date for feed consumption, allowing for accurate feed consumption calculations for transfer-outs in AeLive. Clicking this button tells AeLive that the animals are done moving and it is time to reconcile the numbers. AeLive will reconcile against all transfers marked to “Transfer Expenses”, as displayed below.
Step 2: How to Reconcile Leftover Amounts
In the example above, the “On-Hand” count indicates that there are 310 birds remaining at the end of the flock. This is a discrepancy with the bird count at some point (bad mortality record, incorrect starting count, etc.). At this point, the best number is the count of birds transferred.
The 310 birds may or may not have existed, however at the end of the flock what really matters is that all of the dollars get transferred. All of the birds are gone but because of a small discrepancy in count something needs to be done with the dollars that belong to those 310 birds.
The “Reconciliation” form, found in the main ribbon bar and context menu, allows users to choose one of two options. The first is to update the dollars of those remaining birds to the “Last” transfer and the other will update the dollars to “All” transfers.
Select the flock and click the Reconcile form button:
The following form displays:
The Reconciliation form has two sections, a top half and a bottom half:
- The top half, “Transfers Out with Expense Transfers Configurations” displays the transfers currently entered for the flock.
- The bottom half, “Remaining” displays what is remaining in the flock.
If no changes are to be made to the head counts of the existing transfers, what should be done with the remaining $923.05 (Cost per Head multiplied by the Head Count or the Cost Transferable minus the Cost Transferred).
Update Last
“Update Last” will take the remaining dollars and apply those dollars to the last transfer. Upon save, the total cost of the transfer that occurred on 5/7/2011 would increase from $507,680.86 to $508,603.91. The Cost Transferable and the Cost Transferred now match.
Update All
“Update All” will take the remaining dollars and apply them to all transfers allocating dollars based on the total cost of the original dollars transferred. In this case the first transfer would receive close to 49% of the remaining cost and the second transfer would receive roughly 51%.
The allocation is based off of dollars and not birds because of the effect of feed consumed in expense transfers. In the above transfers, the second transfer had dollars transferred based on a per bird cost of $2.98/bird because those birds consumed more feed than the first set of birds since they remained in the pullet barn for an additional five days.
The 310 birds still remain but all dollars have been accounted for.
Rules to Remember
Some procedures to highlight that should occur when dealing with multiple transferred and feed consumed are the following:
- There must be an ending feed inventory or a feed return at the end of the flock.
- Multiple transfers will receive the same amount of feed consumed unless an ending feed inventory is entered on each day that a transfer exists.
- The feed consumed will not calculate correctly for the existing portion of the flock unless an actual starting amount of feed for the remaining birds is present.