Managing Actuals Data quarterly

Castaway is designed to accept Actuals data on a monthly basis. However we often hear from users who prefer to bring Actuals data in less frequently, often quarterly. It's easy to work with quarterly Actuals, provided a few principles are followed. These principles apply whether we are entering or importing Actuals data.

Here's the quick version. To bring in quarterly Actuals for the September quarter*, we:

  • July: use zero for all Profit & Loss items, and repeat the June numbers for the Balance Sheet
  • August: use zero for all Profit & Loss items and repeat the June numbers for the Balance Sheet
  • September: use the quarterly totals for all Profit & Loss items and the September Balance Sheet data

* Note we're assuming the forecast already contains either an Opening Balance sheet or Actuals data for June.

For both July and August, 0 movement in the Profit & Loss together with 0 movement in the Balance Sheet means 0 cashflow. The cashflow for the whole quarter will appear in September.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.