The flagship
LedgerLine Multi-Entity
One of the most powerful ways in Australia to run up to 10 businesses from a single spreadsheet. One ABN, one combined BAS, no monthly subscription.
What it is
A complete system for several businesses under one ABN
LedgerLine Multi-Entity is a complete bookkeeping system for people who run more than one business under the same ABN: a farm with a few income streams, a family group with rentals and a trade, a sole trader juggling several ventures. Record income and expenses once, tag each line to a business, and the workbook does the rest.
One income register, one expense register, and it splits everything out by entity automatically. One BAS to lodge. Per-entity and side-by-side profit dashboards, fuel tax credits, the primary production split your partnership return needs, and live charts that update as you type. Every formula is ATO aligned.
Best of all it is a one-off purchase, not another monthly subscription. You own it outright, with no ongoing fees and no per-entity charges, a fraction of what you would pay over a year for MYOB or Xero. Every July we email you a free ATO rate update so your figures stay current.
60 second tour
See the workbook in action
A look inside
Real screens, real numbers
Every figure shown is computed live from the Featherstone Family Farm demo, which runs eight active businesses.
What you get
The 15 connected tabs
Welcome and orientation
Start here, with the free annual update signup.
Setup
Your entities, GST status, financial year and fuel tax credit rates.
Tax Code Register
28 ATO-aligned codes, each with its GST treatment and primary production flag.
Income Tracker
One row per sale, tagged to any entity.
Expense Tracker
One row per expense, tagged to any entity.
Invoice Template
An entity-aware tax invoice; pick which business is issuing.
BAS Summary
Combined quarterly BAS across all entities: G1, 1A, 1B, W1, W2, 7D.
Fuel Tax Credits
Litres times rate, per quarter, flowing to BAS label 7D.
Bank Reconciliation
Match books to bank monthly, with an audit trail.
Home Office and Vehicle
Hours and kilometres, per entity.
Per-Entity P&L Dashboard
Profit for any one business, with the primary production split.
Combined P&L Dashboard
Every active business side by side, with a Total column.
Cash Flow Dashboard
Running balance, outstanding invoices, days of cash on hand.
Annual Tax Prep Summary
Feeds the partnership return, primary and non-primary production separated.
Updates
Changelog and the free annual update signup.
Who it is for
Built for Australian groups and family businesses
- ✓Family farms running cropping, cattle, agistment, farm-gate sales and on-farm tourism under one ABN
- ✓Family or investment groups with rental income alongside a trade or consulting business
- ✓Partnerships with a primary venture and one or two side businesses
- ✓Anyone who has outgrown a single sole-trader template but does not want a Xero subscription for each entity
The difference
Why this workbook beats the others
One ABN, one BAS, done properly
The workbook aggregates every entity into a single combined BAS, the way the ATO expects when you trade under one ABN. No stitching numbers together by hand.
Per-entity and combined views
See any one business on its own, then all of them side by side with a Total. Inactive entity slots are suppressed, so a three-business owner sees three columns, not three plus seven blanks.
Primary production handled correctly
Income and expenses split into primary production and non-primary production, the way the partnership return needs them.
GST treatment done right per code
Taxable, GST-free and input-taxed are each handled correctly. Residential rent and short-stay accommodation are treated as input-taxed.
Fuel tax credits built in
Litres times the quarterly rate, flowing straight to BAS label 7D.
Live formulas, no macros
Everything calculates the moment you open it. No macro warnings, no security prompts, nothing to enable.
How it works
Five simple habits
- 1
Open the Setup tab, name your entities, set your GST status and financial year (about 10 minutes).
- 2
Record income and expenses as they happen, tagging each line to an entity and a tax code.
- 3
Once a month, reconcile the bank and glance at the dashboards.
- 4
Once a quarter, copy the BAS Summary figures into the ATO Business Portal or hand them to your agent.
- 5
Once a year, use the Annual Tax Prep Summary to feed the partnership return.
Technical requirements
- Microsoft Excel 2016 or newer (Windows or Mac), or Excel for the web.
- Works on Mac and PC.
- Not optimised for mobile data entry; use a desktop for accuracy.
What this product is not
- Not tax advice. We provide a record-keeping tool. Verify your obligations with the ATO or a registered tax agent.
- Not a replacement for Xero, MYOB or QuickBooks at high transaction volumes or where you need live bank feeds.
- Built for several businesses under one ABN. If each entity has its own ABN and lodges its own BAS, this combined design is not the right tool.
Questions
Frequently asked
How many businesses can I track?
Up to 10 entities under one ABN. You name them on the Setup tab and flag which are active. Inactive slots are hidden from the dashboards, so the views stay clean if you run fewer than 10.
We lodge one BAS for the whole group. Does this match that?
Yes. This product is built for several businesses trading under a single ABN with one combined BAS. If each business has its own separate ABN and lodges separately, this combined design is not the right fit.
Does it handle Airbnb or residential rent correctly?
Yes. Short-stay accommodation and residential rent are treated as input-taxed: no GST is added to that income, and no GST credit is claimed on the related expenses. The tax codes do this for you.
Does it separate primary production?
Yes. Every income and expense line carries a primary production flag, and the Annual Tax Prep Summary separates primary from non-primary production for the partnership return.
Will this work in Excel and Google Sheets?
It is built and tested for Microsoft Excel 2016 or newer, Windows or Mac, and Excel for the web. It uses INDEX and MATCH rather than newer functions, so older Excel is supported. It will open in Google Sheets, though Excel is the tested and recommended environment.
Are there macros?
No. Everything is live formulas, so it calculates the moment you open it. No macro warnings and nothing to enable.
I only run one business. Should I buy this?
Probably not. The Sole Trader edition is simpler and cheaper and is a separate product. Buy Multi-Entity when you have two or more businesses under one ABN.
One ABN. One BAS. Up to 10 businesses.
A one-off purchase of $99 inc GST. Instant download, with your free ATO rate update every July.