There are a raft of changes being implemented at the moment to streamline end of period closing for accounting and deal with the current limitations of fee projection and statement design. Several areas will be touched:

  • Parent Statements
  • Parent Transaction Listing
  • Fee Projection
  • direct debit batches
  • recording fees and payments
  • Accounting Extracts
  • Financial Reports
    • Aged Debt
    • Balance Owing
    • Income Reports
    • Payment Reports

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.

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:

  • Aged Debt report now has an ‘As At’ date so you can pick any prior date and run the report
  • Fee Projection is its own discrete step and doesn’t need to be done separately for direct debit and statements
  • Projected Fees are now pushed onto the parent transactions so they appear in transaction listings, balance owing and aged debt reports
  • Session Code changes now have a ‘Date of Effect’ so fee changes can be entered in advance and the change will take effect on the date chosen without further interaction, allowing (among other things) for accurate fee projection when fee changes take effect

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.