Modelling Leave Provisions

A choice of 2 methods

There are 2 ways to model staff leave provisions like annual leave and long service leave in Castaway:

  1. Using a modified Costs element (our preference)
  2. Using a Provisions element

Although both methods end up with the same numbers in the P&L, Balance Sheet and Cashflow reports, we favour the first method because it gives more flexibility in positioning the provision expense line in the Profit & Loss. 

Because the first method involves a Costs element, you can position the provision expense line under any Direct Costs, Overheads, Other Expenses or Non Operating Expense section heading.  The second method can only show the provision expenses in the Other Expense section of the Profit & Loss.

Method 1: Using a modified Costs element

  1. Add a Costs element under the Overheads heading, or any of the other eligible section headings (Direct Costs, Other Expenses or Non-Operating Expenses)
  2. Under the the Costs, set the Invoicing Method to ‘Enter Accrued Invoices’
  3. Under the Settings, change the GST Rate to 0% and set Accrual Reporting to ‘Separately as Current Provision’
  4. Add say $5,000 per month to the Enter Expense line.  Note that the Cash Payments line shows $0 each month and the Accrual/Provision balance grows (so we’ve successfully created a non-cash expense)
  5. Enter $13,000 in the Enter Invoice line for December (we’re assuming here that we’ll make a large cash payment to staff as they take leave)
  6. Review the Profit & Loss Report, the Balance Sheet and the Cash flow Statement to confirm the numbers appear as you would expect

 Method 2: Using a Provisions element

  1. Add a Provisions element under the Current Liabilities heading
  2. Under the Account Type, set the account type to ‘Staff’
  3. Under the New Provision, set the Provision Movement Option to ’Enter Provision’
  4. Under the Write Off tab, set the Write Off Method to ‘Enter Write Off’
  5. Under the Settings tab, ensure the Balance Sheet Location is set to ‘Current Liability’
  6. Add say $5,000 per month to the Enter Provision line
  7. Enter $13,000 in the Enter Write Off line for December (we’re assuming here that we’ll make a large cash payment to staff as they take leave)
  8. Review the Profit & Loss Report, the Balance Sheet and the Cash flow Statement to confirm the numbers appear as you would expect

 

Download a sample file to compare the 2 methods here: 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.