Project Overview

Case Study – Table Tennis Victoria

Management and control over budgeting process
Developed a tool, that reviewed prior year phasing month by month, when revenue and spend were likely to occur, and over-laid the annual budget

Worked with Table Tennis Victoria, in reviewing the annual budget, and monthly phasing, to finalise a full year budget month by month

Uploaded a full budget, and departmental budgets in Xero, to aid monthly analysis on actual results vs budgeted results

Accounting systems
Transitioned Table Tennis Victoria from MYOB to Xero accounting package (cloud based system – allowing remote access)

Altered account structure from a tiered general ledger to a flat general ledger, utilising department & jobs tracking codes – eliminating the number of accounts required

Transitioned client, supplier, employee details from MYOB to Xero

Designed altered reporting formats to allow for high level reporting, and detailed reporting to department & jobs. Cleaned the monthly reporting to board up from total accounts to a summarised report allowing easier analysis

Transitioned payroll to Xero, and identified errors in prior payroll files, thus correcting issues, and allowing more accurate monthly provisioning

Processing Efficiency
Enabled bank feeds direct from bank to accounting system. Eliminating printing daily bank statements, and double entry to accounting system

Hyperlinked paypal details to invoices, allowing customers to make payment direct from electronic invoice

Set-up Paypal account with bank feeds, direct into the general ledger, allowing business to manage this like another bank account

Introduced on-line expense claims, allowing management to log expense claims on the road thru a mobile phone application. Photo evidence stored of receipts, avoiding a paper base clutter at end of month

Project Details

Date : July 13, 2013