--- title: Aged Care Fee Calculator --- [Skip to content](https://robertmair.com/aged-care-fee-calculator#main-content) [![robertmairemailsiglogov3](https://robertmair.com/hs-fs/hubfs/robertmairemailsiglogov3.png?width=321&height=40&name=robertmairemailsiglogov3.png)](https://robertmair.com/?hsLang=en) - [Home](https://robertmair.com) - [About](https://robertmair.com/about) - [Skills and Experience](https://robertmair.com/skills-and-experience) - Projects Show submenu for Projects - [Projects Summary](https://robertmair.com/projects) - [Aged Care Fee Calculator](https://robertmair.com/aged-care-fee-calculator) - [Falls Prevention App](https://robertmair.com/falls-prevention-app) - [Data Visualisation Using R](https://robertmair.com/data-visualisation-using-r) - [Contact](https://robertmair.com/contact) Open main navigation Close main navigation - [Home](https://robertmair.com) - [About](https://robertmair.com/about) - [Skills and Experience](https://robertmair.com/skills-and-experience) - Projects Show submenu for Projects - [Projects Summary](https://robertmair.com/projects) - [Aged Care Fee Calculator](https://robertmair.com/aged-care-fee-calculator) - [Falls Prevention App](https://robertmair.com/falls-prevention-app) - [Data Visualisation Using R](https://robertmair.com/data-visualisation-using-r) - [Contact](https://robertmair.com/contact)   **projects:** # AGED CARE FEE CALCULATOR Automating and improving the ability for an aged care facility to calculate and invoice monthly care fees. ![aged care fee calculator - color](https://45299212.fs1.hubspotusercontent-na1.net/hub/45299212/hubfs/aged%20care%20fee%20calculator%20-%20color.jpg?width=1200&length=1200&name=aged%20care%20fee%20calculator%20-%20color.jpg) TAB: Calculation of daily aged care fees. ![aged care fee calculator - 2](https://45299212.fs1.hubspotusercontent-na1.net/hub/45299212/hubfs/aged%20care%20fee%20calculator%20-%202.jpg?width=1200&length=1200&name=aged%20care%20fee%20calculator%20-%202.jpg) TAB: SA funding reconciliation (also produces JNL for Xero). ![aged care fee calculator - 3](https://45299212.fs1.hubspotusercontent-na1.net/hub/45299212/hubfs/aged%20care%20fee%20calculator%20-%203.jpg?width=1200&length=1200&name=aged%20care%20fee%20calculator%20-%203.jpg) TAB: Automated production of invoice data for import into Xero. ![rm initials logo](https://robertmair.com/hs-fs/hubfs/rm%20initials%20logo.png?width=56&height=18&name=rm%20initials%20logo.png "rm initials logo") **project timeline: may to oct 2024**   ## Purpose There are limited options in the aged care industry to automate the calculation of care fees, which is complicated as the fees are derived from a hybrid of government subsidy and consumer pays. For instance, the government may pay all clinical care fees for a resident, however some residents also pay means tested care fees (MTCF), which reduces government funding dollar for dollar. There are daily care fees (DCF) for catering, cleaning and laundry (commonly known as 'hotel services'). All residents pay this fee. For accommodation costs, some residents are supported via government accommodation supplements but may still pay a Daily Accommodation Contribution (DAC), which can be partially or fully reduced via a Refundable Accommodation Contribution (RAC). Others are self funded and pay a Daily Accommodation Payment (DAP), or reduced DAP (or no DAP) depending on the level of Refundable  Accommodation Deposit (RAD) provided. To complicate things further, there are also differences between how respite and permanent fees work, how social and hospital leave may impact funding, additional services fees, further government supplements to apply for, and DVA, VET and NDIS funded individuals. ![business tax and compliance - business tax returns](https://robertmair.com/hs-fs/hubfs/business%20tax%20and%20compliance%20-%20business%20tax%20returns.png?width=103&height=100&name=business%20tax%20and%20compliance%20-%20business%20tax%20returns.png "business tax and compliance - business tax returns") ### Brief Urgent development and implementation of a monthly aged care fee calculator for a 100 bed facility for: - Accurate and timely funding claims and resident invoicing. - Production of invoice data to be imported into Xero. - Occupancy, revenue and care specification forecasting. ### Result The Excel model is being used monthly to calculate resident fees, process fee adjustments as notified by Services Australia, cross reference data between Clinical Manager and the Aged Care Provider Portal, and generate Xero invoice data and GoCardless direct debit batches. ### Toolchain - Excel using Kutools and Robs Toolkit (yes, I developed this) Add-ins - eTools eRAD refundable accommodation deposit solution - Xero for resident invoices and GoCardless for direct debit processing - Telstra Clinical Manager for monthly occupancy data - Services Australia Aged Care Provider Portal for funding claims ### Drowning in data? ![Help](https://robertmair.com/hs-fs/hubfs/Help.png?width=104&height=100&name=Help.png "Help") Disparate systems? Data quality issues? Inaccurate reporting?  You need help. I can fix your data, systems and processes to reduce risk, improve efficiencies and enhance outcomes. [Contact](https://robertmair.com/contact?hsLang=en) Start a conversation. Interested in working together? I would love to hear from you! [Contact Me Here >](https://robertmair.com/contact?hsLang=en) **Melbourne** PO Box 602 South Melbourne Vic 3205 ![CPA B&W Logo](https://robertmair.com/hs-fs/hubfs/CPA%20B%26W%20Logo.png?width=250&height=111&name=CPA%20B%26W%20Logo.png "CPA B&W Logo") Robert is a Fellow of CPA Australia Robert is currently completing the [Bachelor of Design (Interaction Design](https://www.canberra.edu.au/course/ARB202/3/2025) at University of Canberra [mailto:info@robertmair.com](mailto:info@robertmair.com) [Home](https://robertmair.com?hsLang=en) [Privacy](https://robertmair.com/privacy-policy?hsLang=en) [Conduct](https://robertmair.com/code-of-conduct?hsLang=en) [Reference](https://robertmair.com/references?hsLang=en) Copyright © 2026, Robert Mair