How to manage stock events that cross the revision line in the Working Plan

Why this matters

When there is an invoice in Needs Action for a stock sale or purchase, and the event date is before the revision line but the payment date is after revision line, the stock movement will show in the livestock grid in the Working Plan. However, the cash will not be in the plan unless it is entered as a budgeted event (because it falls after the revision line).

This happens because the invoice records the livestock movement as an actual, but the payment is still considered a planned event, so it will be missing unless you enter it.

If the cash is not included in the plan, your cashflow forecast will be incomplete, and your cashflow and reports will not show an accurate picture.

Benefits

By recording both the invoice and the planned cash event, you:

• Ensure livestock numbers on hand are correct.

• Maintain an accurate cashflow forecast.

Steps to complete

1. Code the invoice as you normally would for the livestock sale or purchase.

2. Create a planned event in the Working Plan for the cash transaction:

   • Go to the relevant stock class and event type (either Sales or Purchases).

   • Enter the details exactly as per the invoice.

   • Enter the invoice date as the event date (prior to the revision line).

   • Enter the due date as the expected payment date (after the revision line).

3. Add a description, e.g. “Stock sold before revision date and paid after”

TIP:

Include a clear description in the planned event to clearly communicate what what it is for and avoid confusion later.

Scenario

Example: You sell 400 mixed age ewes on 20 August (before the revision line), but the payment is made on 17 September (after the revision line).

• The actual invoice will record the livestock movement on 20 August.
• A planned cash event ensures the payment is reflected correctly on 17 September.
• The reports will be accurate, including the one stock event and one payment.

More Information

• Learn more about the Livestock tab in the Working Plan