AI Bookkeeping Norwest
Where one client means six ledgers
Norwest Business Park is not a strip of shopfronts, it is a master planned commercial precinct of roughly 377 hectares wrapped around the lake at Bella Vista, with more than 1,000 businesses and something in the order of 30,000 people working in it. Woolworths Group runs its support office from Norwest, Norwest Private Hospital sits inside the park, and the low rise buildings along Solent Circuit, Brookhollow Avenue, Century Circuit and Lexington Drive are full of the kind of tenant that rarely makes the news: head offices, support offices, distribution and services businesses that are bigger than they look from the car park. Since the Sydney Metro Northwest opened in 2019, with stations at Norwest and Bella Vista, the precinct has been a fifteen minute train ride from Chatswood, which changed who works here and made it viable to run a national operation from the Hills.
The Hills Shire around it is a little over 190,000 people and one of the fastest growing local government areas in New South Wales, with the newer suburbs at Rouse Hill, Box Hill and North Kellyville still filling in. It is also, unusually, an area where a very large share of households own the business they work in. That combination produces a specific kind of client for a bookkeeping practice, and it is not the single trading company most practices are set up to handle.
What walks through the door at Norwest is a group. A franchisee who started with one store at Castle Hill and now has six across the north west, each one in its own company so that a bad site cannot take down the good ones. A service entity that employs the area managers and charges the stores a management fee. A family discretionary trust that owns the shares. A property trust holding the two industrial units the group operates out of and leases them back. And a bucket company, sitting quietly at the end of the structure, holding entitlements from three years of distributions that may or may not have ever been paid across. That is one client on the fee list and six live ledgers in the practice.
Everything hard about that client sits between the files rather than inside them. Any competent bookkeeper can reconcile a bank feed. What nobody has time for is checking that the loan account in the service company still mirrors the loan account in the trust, that the franchisor's weekly settlement has been split back to the right store entity, that the group has not quietly gone past a single shared payroll tax threshold because six employers feel like six small employers, and that the Division 7A minimum yearly repayment was actually banked rather than journalled in June. Those checks are mechanical, they are unglamorous, and they are precisely what a dedicated AI working across the whole group can hold every single night. Because it runs single-tenant in the AWS Sydney region, a family's entire balance sheet stays in Australia.
Pick the Norwest group whose loan accounts have never agreed
Bring two entities from the same family group, whichever pair you have been avoiding. In 30 minutes we will run a dedicated AI across the real Xero or MYOB files and show you both sides of the loan account, matched, with the variances listed. Connected and working within 1 hour.
Book a 30-min demoA Solent Circuit practice, ten days out from 30 June
Picture a five person bookkeeping practice in one of the low rise buildings on Solent Circuit, looking out over the lake: the owner is a registered BAS agent, there are two bookkeepers, a payroll specialist and an office manager who also does the debtor chasing. The fee list says 38 clients. The software says 140 ledgers, because most of those clients are groups.
The biggest of them is a quick service food franchisee with six stores, at Rouse Hill, Castle Hill, Kellyville, Baulkham Hills, Norwest Marketown and Marsden Park. Each store trades through its own company. Above them sits a service company that employs the two area managers and charges each store a management fee, a family discretionary trust that holds the shares, a property trust that owns two units off Brookhollow Avenue and leases them back to the group, and a bucket company that has been receiving distributions since 2023. Five stores are on Xero. The sixth, bought from an outgoing franchisee in March, is still on MYOB Business with the previous owner's chart of accounts. The property trust runs on the practice's own ledger. The point of sale system feeds daily sales into four of the six.
It is the third week of June, which in this practice means three deadlines are converging and only one of them is on anybody's calendar. The trust resolutions have to be made by 30 June or the default beneficiary clause decides where the income goes. The Division 7A loans from the bucket company need their minimum yearly repayments genuinely made, not journalled. And the payroll tax annual reconciliation is due in July for a group that has never been certain whether it is grouped, which it is.
In the usual version of this, none of it is ready. The inter-entity loan accounts are out by five figures in four different directions, because a walk-in freezer for the Kellyville store was paid from the Castle Hill company's account in October and never charged across, and because the owner's car payment comes out of whichever entity is in credit that fortnight. Nobody can say what the group actually earned, because producing a consolidated position means somebody exporting six trial balances into a spreadsheet that only one person in the practice understands, and that has not happened since February. The franchisor's weekly settlement has been coded as a single expense line for months, so the royalty, the marketing levy, the stock and a supplier rebate are all sitting together and no store has a real margin. The MYOB store has not been touched since the handover. And the resolutions will be signed on 29 June against numbers nobody is confident in.
With a dedicated AI running across the group, that fortnight is a different job entirely. Since July it has been coding and reconciling all nine ledgers nightly, and mirroring every inter-entity movement as it happens: the freezer was picked up the week it was paid, posted as a loan from Castle Hill to Kellyville with the invoice attached, and the owner's personal payments have been landing in a drawings queue instead of quietly becoming expenses. The loan account schedule agrees on both sides for every pair in the group, with a variance list of four genuine exceptions rather than forty unexplained ones. The bucket company schedule shows exactly what the minimum yearly repayment is for each complying loan and how much has actually been banked, and it has said so since April, when there was still time to move money rather than invent a solution.
The consolidated pack was ready on the eighth of the month, as it has been every month: a group profit and loss and balance sheet with the loans, the management fees and the internal rent on the property trust eliminated, and a per store column underneath it. That column is the one the owner reads first, because the franchisor's settlement has been split back into royalty, levy, stock and rebates per store, so Marsden Park's margin is finally comparable with Rouse Hill's rather than buried in a single direct debit. The combined wages figure across the three employing entities has been tracked against the one grouped threshold all year, so the July reconciliation is a review of a maintained number. And the MYOB store sits in the consolidation on the same mapped chart as the other five, with the migration to Xero now a scheduled job in September instead of an excuse.
The BAS agent spends the last ten days of June doing the work that requires a registered agent: sitting with the family, looking at a set of numbers she trusts, and getting the resolutions right. The practice did not hire anyone. It took on two more Hills District groups it would have turned away the year before, because the marginal cost of the seventh ledger in a group stopped being a person's afternoon.
Six things that break between the files
None of these are visible inside a single ledger. All of them are found at year end, when it is too late to do anything but explain them.
| Where it breaks | What it costs the group | What the dedicated AI holds nightly |
|---|---|---|
| Inter-entity loan accounts | Both sides of the same loan carry different numbers, so the group cannot be consolidated and the year end becomes an argument about history | Every movement matched pair by pair, the mirror entry posted, and a short variance list of what exists on only one side |
| Division 7A and the bucket company | A minimum yearly repayment missed or journalled instead of banked, and an unpaid present entitlement nobody has tracked since the distribution was resolved | A live schedule per loan: balance, term, benchmark interest, repayment required and repayment genuinely banked, flagged in April not November |
| The consolidated position | Nobody can say what the group earned without a spreadsheet only one person can run, so it is produced twice a year at best | One mapped group chart, inter-entity balances and recharges eliminated, consolidated and per entity views ready by the eighth |
| The franchisor settlement | Royalty, marketing levy, stock and rebates coded as one expense line, so no store has a margin anyone can act on | Each component split to the right store entity, reported sales reconciled to point of sale and banked takings, anomalies raised |
| Grouped payroll tax | Six employers that feel small share one threshold between them, and the shortfall is discovered by an audit rather than a practice | Combined Australian wages tracked against the single grouped threshold month by month, with the annual reconciliation evidence assembled |
| Owner drawings and private costs | Personal spending paid from whichever entity had cash, coded as an expense, and reclassified nine months later under time pressure | Private and unclear items diverted to a drawings queue against the right entity, with the question asked while the owner still remembers |
What your dedicated AI carries for the group
One AI across every entity your Norwest client owns, working nightly and leaving everything review ready for a registered BAS agent.
Inter-entity loan accounts, mirrored
Matches every movement between entities pair by pair as it posts, writes the mirror entry where you have authorised it, and lists the items that exist on only one side instead of leaving them to June.
Division 7A and bucket company schedules
Keeps a schedule per complying loan covering balance, term, benchmark interest and the minimum yearly repayment, tracks unpaid present entitlements owed to the corporate beneficiary, and warns while there is still time to act.
Consolidated reporting across the group
Maps every entity's chart into one group chart, eliminates the loans, management fees and internal rent, and produces a consolidated profit and loss and balance sheet with the per entity columns still readable underneath.
Franchisor settlements, split per store
Breaks the weekly or monthly statement into royalty, marketing levy, stock, equipment finance and rebates, posts each to the right store entity, and reconciles reported sales against the point of sale and the banked takings.
Payroll across several employing entities
Runs the pay cycles per entity, checks award rates, superannuation and leave in each, and tracks combined Australian wages against the one grouped New South Wales payroll tax threshold month by month.
Management fees and internal recharges
Raises the recurring service company charges and property trust rent on the basis you set once, posts both sides in the same run, and keeps the calculation and its support attached to every one.
Working papers before 30 June, not after
Has each trust's year to date position, its loan accounts and what the bucket company is owed assembled in the first half of June, so the resolutions are made against numbers rather than an estimate and a hope.
The everyday ledger, in every file
Bank feed coding, supplier invoice matching, daily reconciliation and BAS and GST working papers, done in each entity in the group whether it sits in Xero, in MYOB or on your own practice ledger.
Bring one franchisor statement and we will rebuild the store margins
Thirty minutes on a real Hills District franchise group. We will split a weekly settlement into royalty, levy, stock and rebates across the store entities in Xero or MYOB, and show you the consolidated pack that falls out the other side. Live on your files within 1 hour.
See it on your Xero fileFrom one entity to the whole structure
You do not hand it six ledgers on day one. You hand it the pair that never agrees.
Draw the structure
We connect the Xero and MYOB files and tell the AI how the entities relate: who lends to whom, who charges what, which trust distributes to the bucket company.
Set the group rules
Your BAS agent fixes the recharge basis, the group chart mapping and what the AI may post on its own. Anything touching a loan account or a distribution comes to a human first.
Start on the worst pair
Usually the service company and the trust that have disagreed for two years. It reconciles that pair back to a number before it is trusted with the rest of the structure.
Take the whole group
Then the remaining entities, then the consolidated pack, then the next client group. Adding a seventh ledger stops being a staffing decision.
What a Norwest practice is really choosing between
When the client is a group, the question is never one file. It is who carries the ninth.
| Dedicated AI | Offshore VA | Another bookkeeper in the Hills | |
|---|---|---|---|
| Time to start | Within 1 hour, across every entity | 2-4 weeks, one file at a time | Months, at Norwest salary rates |
| Relative cost | ~70% less than a VA | Baseline, and priced per file | $5,000+/mo plus on-costs |
| Cost of the seventh ledger | Marginal | Another set of hours | Another hire, eventually |
| Loan accounts agreeing on both sides | Checked nightly, variances listed | Only where instructed, per file | Reconstructed at year end |
| Consolidated group position | Monthly, eliminations included | Spreadsheet, if anyone has time | Twice a year at best |
| Where the family's data sits | Onshore, AWS Sydney, single tenant | Overseas | Local |
| Works inside Xero and MYOB | Natively, both, in the same group | Manual | Manual |
Built for Australian compliance
Structure decisions stay with your agent
The dedicated AI reconciles, schedules and drafts the working papers. A registered BAS or tax agent decides the Division 7A treatment, the distributions and the lodgements, so your Tax Practitioners Board registration and supervision arrangements are untouched.
A family balance sheet that stays onshore
Single tenant on AWS in the Sydney region. Loan accounts, drawings, distributions, tax file numbers and staff records across every entity stay in Australia, in your practice's own isolated environment, never pooled and never used to train models.
Evidence that survives a review
A loan, a recharge and a repayment are only worth the record behind them. Every entry carries its source document, its calculation and a timestamp, so a group's position can be demonstrated rather than reasoned backwards from a bank statement.
Norwest group structures, answered
One client, six Xero files. Does a dedicated AI work on the group or on one ledger at a time?+
On the group, and that is the difference that matters in Norwest. A single dedicated AI is connected to every file the owner has: a company per store, the service entity that employs the area managers, the family trust, the property trust and the bucket company sitting behind all of it. It codes and reconciles each one nightly, but it also holds the relationships between them, so it knows that a transfer out of the Castle Hill store is a loan to the service company rather than a cost, that a payment made from whichever entity happened to have cash belongs somewhere else, and that a recharge posted in one file has a matching entry waiting in another. Practices that treat six files as six separate jobs pay for the same transaction three times and still end up with a group that does not agree with itself.
Our inter-entity loan accounts have never agreed. Can it actually get both sides to the same number?+
Yes, and it does it as the transactions post rather than in a reconstruction each June. The rule is simple and almost never observed in practice: what the lending entity carries as a loan receivable has to be exactly what the borrowing entity carries as a loan payable, on the same date, for the same reason. Groups break that rule constantly, because a supplier gets paid out of the trust that had the funds, a director's card is attached to the wrong entity, a bank transfer is coded as drawings on one side and a loan on the other, and a store's fit-out is paid by the service company and never charged on. The dedicated AI matches every inter-entity movement pair by pair, posts the mirror entry where you have authorised it to, and raises a variance list of everything that only exists on one side. Your BAS agent works from a short list of genuine exceptions instead of two ledgers that are $40,000 apart with no explanation.
Can it keep a Division 7A loan on complying terms and track what the bucket company is owed?+
It keeps the record that decides the answer, which is where these fall over. For each complying loan the dedicated AI maintains a schedule showing the opening balance, the term remaining, interest calculated at the benchmark rate the ATO publishes for the year, the minimum yearly repayment required and the repayments genuinely banked rather than journalled, and it tells you in April whether the group is short with time left to fix it, not in November when the return is being prepared. It does the same on the other side of the structure, tracking what each trust has resolved to distribute to the corporate beneficiary and how much of that entitlement is still unpaid, so an unpaid present entitlement that needs to be put on complying terms is visible rather than discovered. Your registered tax agent decides the treatment, sets the terms and signs. The AI makes sure the numbers behind the decision were kept all year.
Xero does not consolidate. How do we get one set of numbers across three trading trusts and a holding company?+
By mapping first and eliminating second, which is mechanical work and therefore exactly what a dedicated AI should be doing. It holds one group chart of accounts and the mapping from each entity's own chart into it, including the store that came across on MYOB with a chart nobody has ever tidied. Each month it pulls the trial balance from every file, eliminates the inter-entity loans, the management fees, the internal rent on the property entity and the stock moved between stores, and produces a consolidated profit and loss and balance sheet with the per entity columns still sitting underneath so the owner can see which store is carrying the group. If the practice already uses a reporting tool such as Fathom or Spotlight, it feeds clean, agreeing data into it instead of replacing it. The point is that the consolidation stops being a spreadsheet one person in the practice knows how to run.
Our franchisee clients get one remittance covering royalty, marketing levy and stock. Can it split that back to the store?+
That is one of the first jobs it earns its keep on. A franchisor statement is not a bill, it is a settlement: gross sales reported by the point of sale system, less royalty at the percentage in the agreement, less the marketing or advertising levy, less stock supplied from the franchisor's own warehouse, less equipment finance, plus whatever supplier rebate has been passed back, and the whole thing lands in one direct debit against one bank account for stores that are separate legal entities. The dedicated AI reads the statement, posts each component to the right account in the right store's ledger, reconciles reported sales against the point of sale data and the banked takings, and flags the things operators never catch: a royalty charged on a sales figure that includes a delivery aggregator's commission, a levy still being charged on a store that closed for a refit, a rebate that stopped arriving three months ago. What comes out the other side is a per store margin that is real, which is the number an owner with six sites actually needs.
Three entities in the group employ staff. Does that change how we have to watch payroll tax?+
It changes it completely, and it is the trap most commonly sprung on Hills District family groups. Related entities are grouped for New South Wales payroll tax, so the group gets one threshold between it, currently $1.2 million of Australian wages, and not one per company. Six stores each paying $250,000 in wages feel like six small employers and are in fact one employer well over the line, at a rate of 5.45% on the excess. The dedicated AI runs the pay cycles across each employing entity, keeps a running total of combined Australian wages against the grouped threshold month by month, separates the wages that belong to interstate work, and keeps the superannuation, leave and award positions checked per entity. It also keeps the annual reconciliation evidence assembled as the year goes, so July is a review rather than a rebuild. Where a group has never been registered and should have been, having the numbers assembled is what lets your registered agent make the voluntary disclosure on the front foot.
One entity came to us on MYOB and the rest are on Xero. Do we have to migrate before this is useful?+
No, and we would rather you did not migrate mid-year just to make the tooling happy. Mixed software is the normal state of a group that has grown by acquisition, because every site or business bought from a previous owner arrives with whatever ledger that owner ran. The dedicated AI connects natively to both Xero and MYOB, so it codes bank feeds, matches supplier invoices, reconciles and prepares BAS working papers in each, and does the group level work, the loan account mirroring, the eliminations and the consolidated reporting, across the mix. When the practice does decide to bring that entity onto Xero, the AI is useful during the migration too, because it holds the mapping between the two charts of accounts and can check that the opening balances and the comparatives still agree afterwards. QuickBooks Online, Dext and Hubdoc are supported as well.
A family's whole financial position sits in these files. Where does that data live and what happens to our BAS agent obligations?+
It lives in Australia, in an environment that belongs to your practice alone. Each dedicated AI runs single-tenant on AWS infrastructure in the Sydney region, so the loan accounts, the drawings, the distributions, the tax file numbers and the staff records across every entity in the group stay onshore, are never pooled with another practice's data and are never used to train models. That answer carries weight with a Norwest client group, because these six ledgers together are effectively the family's entire balance sheet, and the owner is usually two suburbs away rather than on the other side of the country. On the compliance side nothing about your registration moves. The dedicated AI prepares: it reconciles, it schedules, it drafts the working papers and it logs what it did, from what source, at what time. A registered BAS or tax agent reviews and lodges every activity statement and return, so your Tax Practitioners Board obligations, the Code of Professional Conduct and your supervisory arrangements sit exactly where they did before.
Related reading
The bookkeeping pillar, nationally
How practices anywhere in Australia are running this, not just around the lake.
If you also prepare the returns
The companion pillar for accounting firms carrying the tax side of a group.
What a dedicated AI actually is
Single tenant, trained on your practice, still working at two in the morning.
Inside a firm that runs one
Where it sits in the workflow, and what the team stops doing.
Twenty minutes down Windsor Road
The same idea from the accountant's chair in Sydney's Central City.
Across the wider Sydney basin
What a metro bookkeeping practice's month looks like with a dedicated AI on the ledgers.
Give your Norwest practice a dedicated AI
See it run across a real client group in your own Xero and MYOB files. Thirty minutes is enough to show you both sides of a loan account agreeing, a franchisor settlement split back to the store and a consolidated pack that did not come out of a spreadsheet. Live within 1 hour, with the whole family's data kept onshore in the AWS Sydney region.
[email protected] · Serving bookkeepers and BAS agents across Norwest, Bella Vista, Baulkham Hills, Castle Hill, Kellyville and Rouse Hill