A raft of changes were implemented on 1st December 2019 to streamline end of period closing for accounting and deal with the current limitations of fee projection and also feedback we have had on statement design. Several areas will be touched:
A perennial problem with CCS is that nothing is ever really locked down and numbers can change from weeks or even months ago, in extreme cases even from the prior financial year.
This makes reconciling of information in SmartCentral with an external accounting system (eg MYOB or TECH1) quite difficult since changes to prior periods happen routinely but accounting systems (and accountants) really don’t like that.
To address this we are shifting to a strict ‘posting date’ based reporting. Any transaction or change is now taken into the reports on the date it happened rather than the date it applies to. So if an attendance is submitted 3 weeks late it will go into the statement from that later period.
Similarly if an attendance submitted 3 weeks ago is now varied, the previous submission will be reversed on the transaction record and the new one added on the date it is submitted.
The net result of this however is that if you come back six months later and run that same statement for that same period you will always get the same result. It will show what ever it did for that period in time originally and changes will show up in later periods when they are made.
To make sure that the posting date approach works the way changes are made in the system will be more strictly controlled. If a payment or fee is manually recorded in the system it will only be able to be edited or deleted on the day its created. After that point it is part of the permanent transaction record and can only be adjusted by explicitly reversing it and entering a new transaction.
All reports on financial information are switched to using ‘Posting Date’ as the basis for including a transaction into the report.
As a result there should no longer be any differences in reported numbers as a result of timing issues.
This does simplify a number of calculations and we have taken advantage of this to introduce a number of related and frequently requested changes:
Probably the most visible change will be to parent statements. The front page of the statement will now show a simplified listing of charges and payments to line up with the online transaction listing, with a running balance. Session detail information will be separated and relegated to subsequent pages.
Changes to fees can now be enterred in advance with a date of effect. For example as soon as you know what next year’s fees will be you can enter them in the system by going to the session code and clicking ‘Update Fee’.
Based on lots of feedback from centres we have taken the opportunity to rationalise the statement layout as part of this update.
Basically we have split the statement layout further so that the new page 1 is simply a list of charges and payments. This layout follows the pattern of the transaction screen and provides a running balance.
It should be very simple for new parents to understand as it follows the same approach as they would be familiar with from internet banking.
Please Note: the ‘To Date’ that you pick when generating statements corresponds to the ‘Posting Date’ in the parent’s transaction list. The closing balance on the statment will correspond to the final balance on the transaction list for the same date. Transactions posted after that date will not be on that statement.
This includes Fee Projections - the ‘To Date’ for statements has to include or be after the posting date, the Fee Projection was created.
The transaction listing consists of the following columns
The second page now shows the attendance detail for each finalised attendance in the transaction listing. The layout is identical with the same information in the previous design, slightly expanded for readability.
In the screenshot below highlighting shows the flow of changes to an individual attendance when it is varied.
Fee projections are now accessed as a separate menu item in the ‘Extracts’ menu.
The main screen provides a list of any projections created using this process and provides the following functions :
Clicking ‘New’ brings up the batch creation screen.
Date from : Always pick the Monday of the first week in your projection. If you want to bill the current week before it’s submitted that will be the Monday of the current week.
Weeks : The number of week you want included in this batch. They will be sequential from the first week.
Refund date relative to period end date : The number of days before or after the Sunday of that week that the projection rolls back. 0 (the default) means the projection will ‘roll back’ on the Sunday , this will generally be appropriate but if you submit on Fridays and run statements and bill all on the same day you will want the projection to roll off 3 days before the week ending date ie on Thursday. So set it to -3.
Limit to these rooms : You can specify if you only want certain rooms included in the projection. For example you want to create a projection for VAC care but not ASC/BSC . Just make sure the appropriate rooms are ticked. You can use the text filter for example to find all your VAC rooms, particulalry useful for multi-service organisations.
You must tick the ** Service** to create a Fee projection, which automatically ticks all rooms.