We use cookies to help provide you with the best possible online experience.
By using this site, you agree that we may store and access cookies on your device. You can find out more and set your own preferences here.

Things To Remember When Reporting To A Date (Not A Month End)


  1. Depreciation is calculated on the last day of any month so will not be included in the month if you run it without the last day included.
  2. Budget figures are included from the first day of the month, so again be careful.

If you run a monthly report from 05.04.15 to 04.07.15 (i.e. what some would deem to be the first quarter) you would get the following

Column ONE - 05.04.15 to 30.04.15 (Actuals for 30 days, inc. depreciation, no budget)

Column TWO - 01.05.15 to 31.05.15 (Everything you would expect)

Column THREE - 01.06.15 to 30.06.15 (Everything you would expect)

Column FOUR - 01.07.15 to 04.07.15 (Budget for all JULY, no depreciation)

Follow this through in a similar vein if you were running a quarterly report.

Suggested routine is that MANAGEMENT REPORTS are run by MONTH and the DAY reporting is for year end and final accounts purposes.