Franking account register
Keep every company’s franking account in one register
Track the franking account for every private company your practice looks after, in one register that sits with the client. Bring the history in from Excel once, then add each entry as it happens, so the balance is ready before the next dividend is declared.
Included in the base subscription
Australia only
| Client | ACN | Last Entry | Balance | Last Edited | Documents |
|---|---|---|---|---|---|
| Bull Antics Pty LtdImputation account for the trading company | 600437708 | 19/06/2026 | $ 57,675.00 | 02/10/2026 at 9:42 AM | 2 |
| Bull Buckets Pty LtdFranking account for the bucket company | 600512946 | 28/07/2026 | $ 186,412.50 | 29/09/2026 at 3:18 PM | |
| Bull Nominees Pty LtdFranking account for the new games company | 601374905 | 28/07/2026 | $ 4,150.00 | 29/09/2026 at 3:26 PM | |
| Bull Property Investments Pty LtdProperty company franking account | 600788123 | 15/05/2023 | $ 9,318.40 | 04/08/2023 at 11:05 AM | |
| Bullish Pty LtdGame development company franking account | 601118342 | 28/07/2026 | $ 38,960.25 | 30/09/2026 at 10:12 AM | |
| Schurr Pty LtdTrading entity franking account | 600935810 | 28/07/2026 | $ 52,904.00 | 01/10/2026 at 2:47 PM | 2 |
Illustrative view. Sample client groups and sample figures.
What goes wrong today
The history is spread across tax returns
When the franking account lives in each year’s return, seeing the full history means going back through every return and pulling the figures out.
Each company has its own workbook
The spreadsheet sits in a folder somewhere, so the balance is only worked out at year end and nobody can see across the practice.
Last year’s figures quietly change
In a spreadsheet, anyone can edit a finished year, and the balance no longer matches the one in the return.
One register, start to finish
From the Excel history to a locked year
This is Bull Antics Pty Ltd, the trading company in a sample client group, working through its 2025/26 year. The figures are made up, but each step works the way the tool does.
Bring the history in from Excel in one go
Download the template, fill it in without changing the headings and upload it. Every earlier year lands in the register with its entries, and an entry dated in a prior year goes into that year.
Add each entry as it happens
Record tax paid, PAYG instalments, refunds, franked dividends received and dividends paid as they happen, each with a date, a type and a short description. The running balance updates with every line.
Lock the year when it’s done
Locking a year locks every entry before it, so the balance you put in the tax return can’t change underneath you. Link the dividend paperwork or the old spreadsheet, so the source sits with the register.
Keep the register with the work papers
Export the whole register as a PDF or Excel work paper, with every year’s entries and totals, straight to your computer or the client’s folder in your DMS.
- Bring the history in from Excel in one go
- Add each entry as it happens
- Lock the year when it’s done
- Keep the register with the work papers
Bring the history in from Excel in one go
Download the template, fill it in without changing the headings and upload it. Every earlier year lands in the register with its entries, and an entry dated in a prior year goes into that year.
Description
Imputation account for the trading company
Register Detail
| Entry Date | Description | Type | Debit | Credit | Balance | Lock |
|---|---|---|---|---|---|---|
| 01/07/2019 - 30/06/20202019/20 | $20,550.00 | |||||
| 01/07/2020 - 30/06/20212020/21 | $28,570.00 | |||||
| 01/07/2021 - 30/06/20222021/22 | $37,530.00 | |||||
| 01/07/2022 - 30/06/20232022/23 | $44,975.00 | |||||
| 01/07/2023 - 30/06/20242023/24 | $47,255.00 | |||||
| 01/07/2024 - 30/06/20252024/25 | $53,335.00 | |||||
| 01/07/2025 - 30/06/20262025/26 | $53,335.00 | |||||
| 30/06/2026 | Enter a short description (optional) | Select transaction type | $0.00 | $0.00 | $53,335.00 | |
To import multiple Franking Account entries, work your way through the following steps…
Step 1.Download our Franking Account import template fileIt has the column headings the import needs. Use the example entries as a guide, then delete them before importing. Download the template
Step 2.Enter your Franking Account details into the templateDon’t change the column headings, or the import will fail.
Step 3.Upload the completed Franking Account import templateBrowse and select the file to import
Franking account 2019–2025.xlsx
Illustrative AccountKit Franking Account Register. Sample client group and sample figures, not tax advice.
Add each entry as it happens
Record tax paid, PAYG instalments, refunds, franked dividends received and dividends paid as they happen, each with a date, a type and a short description. The running balance updates with every line.
Description
Imputation account for the trading company
Register Detail
| Entry Date | Description | Type | Debit | Credit | Balance | Lock |
|---|---|---|---|---|---|---|
| 01/07/2019 - 30/06/20202019/20 | $20,550.00 | |||||
| 01/07/2020 - 30/06/20212020/21 | $28,570.00 | |||||
| 01/07/2021 - 30/06/20222021/22 | $37,530.00 | |||||
| 01/07/2022 - 30/06/20232022/23 | $44,975.00 | |||||
| 01/07/2023 - 30/06/20242023/24 | $47,255.00 | |||||
| 01/07/2024 - 30/06/20252024/25 | $53,335.00 | |||||
| 01/07/2025 - 30/06/20262025/26 | $57,675.00 | |||||
| 28/07/2025 | June 2025 quarter instalment | PAYG Instalment Paid | $7,500.00 | $60,835.00 | ||
| 28/10/2025 | September 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $68,735.00 | ||
| 01/12/2025 | 2024/25 income tax paid | Income Tax Paid | $3,640.00 | $72,375.00 | ||
| 15/12/2025 | Dividend on listed shares ($3,500 fully franked) | Franked Distribution Received | $1,500.00 | $73,875.00 | ||
| 02/03/2026 | December 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $81,775.00 | ||
| 28/04/2026 | March 2026 quarter instalment | PAYG Instalment Paid | $7,900.00 | $89,675.00 | ||
| 19/06/2026 | 2025/26 dividend ($96,000 fully franked) | Dividend Paid | $32,000.00 | $57,675.00 | ||
| 30/06/2026 | Enter a short description (optional) | Select transaction type | $0.00 | $0.00 | $57,675.00 | |
Illustrative AccountKit Franking Account Register. Sample client group and sample figures, not tax advice.
Lock the year when it’s done
Locking a year locks every entry before it, so the balance you put in the tax return can’t change underneath you. Link the dividend paperwork or the old spreadsheet, so the source sits with the register.
Description
Imputation account for the trading company
Register Detail
| Entry Date | Description | Type | Debit | Credit | Balance | Lock |
|---|---|---|---|---|---|---|
| 01/07/2019 - 30/06/20202019/20 | $20,550.00 | |||||
| 01/07/2020 - 30/06/20212020/21 | $28,570.00 | |||||
| 01/07/2021 - 30/06/20222021/22 | $37,530.00 | |||||
| 01/07/2022 - 30/06/20232022/23 | $44,975.00 | |||||
| 01/07/2023 - 30/06/20242023/24 | $47,255.00 | |||||
| 01/07/2024 - 30/06/20252024/25 | $53,335.00 | |||||
| 01/07/2025 - 30/06/20262025/26 | $57,675.00 | |||||
| 28/07/2025 | June 2025 quarter instalment | PAYG Instalment Paid | $7,500.00 | $60,835.00 | ||
| 28/10/2025 | September 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $68,735.00 | ||
| 01/12/2025 | 2024/25 income tax paid | Income Tax Paid | $3,640.00 | $72,375.00 | ||
| 15/12/2025 | Dividend on listed shares ($3,500 fully franked) | Franked Distribution Received | $1,500.00 | $73,875.00 | ||
| 02/03/2026 | December 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $81,775.00 | ||
| 28/04/2026 | March 2026 quarter instalment | PAYG Instalment Paid | $7,900.00 | $89,675.00 | ||
| 19/06/2026 | 2025/26 dividend ($96,000 fully franked) | Dividend Paid | $32,000.00 | $57,675.00 | ||
| 01/07/2026 - 30/06/20272026/27 | $57,675.00 | |||||
| 30/06/2027 | Enter a short description (optional) | Select transaction type | $0.00 | $0.00 | $57,675.00 | |
Illustrative AccountKit Franking Account Register. Sample client group and sample figures, not tax advice.
Keep the register with the work papers
Export the whole register as a PDF or Excel work paper, with every year’s entries and totals, straight to your computer or the client’s folder in your DMS.
Register Detail
| Entry Date | Description | Type | Debit | Credit | Balance |
|---|---|---|---|---|---|
| 01/07/2019 - 30/06/2020 | $20,550.00 | ||||
| 14/11/2019 | 2018/19 income tax paid | Income Tax Paid | $24,650.00 | $24,650.00 | |
| 28/02/2020 | December 2019 quarter instalment | PAYG Instalment Paid | $6,200.00 | $30,850.00 | |
| 28/04/2020 | March 2020 quarter instalment | PAYG Instalment Paid | $6,200.00 | $37,050.00 | |
| 26/06/2020 | 2019/20 dividend ($43,500 fully franked) | Dividend Paid | $16,500.00 | $20,550.00 | |
| $16,500.00 | $37,050.00 | $20,550.00 | |||
| 01/07/2020 - 30/06/2021 | $28,570.00 | ||||
| 28/07/2020 | June 2020 quarter instalment | PAYG Instalment Paid | $6,200.00 | $26,750.00 | |
| 28/10/2020 | September 2020 quarter instalment | PAYG Instalment Paid | $5,400.00 | $32,150.00 | |
| 30/11/2020 | 2019/20 income tax refund | Income Tax Refund | $1,380.00 | $30,770.00 | |
| 01/03/2021 | December 2020 quarter instalment | PAYG Instalment Paid | $5,400.00 | $36,170.00 | |
| 28/04/2021 | March 2021 quarter instalment | PAYG Instalment Paid | $5,400.00 | $41,570.00 | |
| 25/06/2021 | 2020/21 dividend ($37,000 fully franked) | Dividend Paid | $13,000.00 | $28,570.00 | |
| $14,380.00 | $22,400.00 | $28,570.00 | |||
| 01/07/2021 - 30/06/2022 | $37,530.00 | ||||
| 28/07/2021 | June 2021 quarter instalment | PAYG Instalment Paid | $5,400.00 | $33,970.00 | |
| 28/10/2021 | September 2021 quarter instalment | PAYG Instalment Paid | $6,100.00 | $40,070.00 | |
| 01/12/2021 | 2020/21 income tax paid | Income Tax Paid | $3,260.00 | $43,330.00 | |
| 28/02/2022 | December 2021 quarter instalment | PAYG Instalment Paid | $6,100.00 | $49,430.00 | |
| 28/04/2022 | March 2022 quarter instalment | PAYG Instalment Paid | $6,100.00 | $55,530.00 | |
| 24/06/2022 | 2021/22 dividend ($54,000 fully franked) | Dividend Paid | $18,000.00 | $37,530.00 | |
| $18,000.00 | $26,960.00 | $37,530.00 | |||
| 01/07/2022 - 30/06/2023 | $44,975.00 | ||||
| 28/07/2022 | June 2022 quarter instalment | PAYG Instalment Paid | $6,100.00 | $43,630.00 | |
| 28/10/2022 | September 2022 quarter instalment | PAYG Instalment Paid | $6,800.00 | $50,430.00 | |
| 01/12/2022 | 2021/22 income tax paid | Income Tax Paid | $2,945.00 | $53,375.00 | |
| 28/02/2023 | December 2022 quarter instalment | PAYG Instalment Paid | $6,800.00 | $60,175.00 | |
| 28/04/2023 | March 2023 quarter instalment | PAYG Instalment Paid | $6,800.00 | $66,975.00 | |
| 23/06/2023 | 2022/23 dividend ($66,000 fully franked) | Dividend Paid | $22,000.00 | $44,975.00 | |
| $22,000.00 | $29,445.00 | $44,975.00 | |||
| 01/07/2023 - 30/06/2024 | $47,255.00 | ||||
| 28/07/2023 | June 2023 quarter instalment | PAYG Instalment Paid | $6,800.00 | $51,775.00 | |
| 30/10/2023 | September 2023 quarter instalment | PAYG Instalment Paid | $7,200.00 | $58,975.00 | |
| 01/12/2023 | 2022/23 income tax refund | Income Tax Refund | $1,120.00 | $57,855.00 | |
| 28/02/2024 | December 2023 quarter instalment | PAYG Instalment Paid | $7,200.00 | $65,055.00 | |
| 29/04/2024 | March 2024 quarter instalment | PAYG Instalment Paid | $7,200.00 | $72,255.00 | |
| 21/06/2024 | 2023/24 dividend ($75,000 fully franked) | Dividend Paid | $25,000.00 | $47,255.00 | |
| $26,120.00 | $28,400.00 | $47,255.00 | |||
| 01/07/2024 - 30/06/2025 | $53,335.00 | ||||
| 29/07/2024 | June 2024 quarter instalment | PAYG Instalment Paid | $7,200.00 | $54,455.00 | |
| 28/10/2024 | September 2024 quarter instalment | PAYG Instalment Paid | $7,500.00 | $61,955.00 | |
| 02/12/2024 | 2023/24 income tax paid | Income Tax Paid | $4,380.00 | $66,335.00 | |
| 28/02/2025 | December 2024 quarter instalment | PAYG Instalment Paid | $7,500.00 | $73,835.00 | |
| 28/04/2025 | March 2025 quarter instalment | PAYG Instalment Paid | $7,500.00 | $81,335.00 | |
| 20/06/2025 | 2024/25 dividend ($84,000 fully franked) | Dividend Paid | $28,000.00 | $53,335.00 | |
| $28,000.00 | $34,080.00 | $53,335.00 | |||
| 01/07/2025 - 30/06/2026 | $57,675.00 | ||||
| 28/07/2025 | June 2025 quarter instalment | PAYG Instalment Paid | $7,500.00 | $60,835.00 | |
| 28/10/2025 | September 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $68,735.00 | |
| 01/12/2025 | 2024/25 income tax paid | Income Tax Paid | $3,640.00 | $72,375.00 | |
| 15/12/2025 | Dividend on listed shares ($3,500 fully franked) | Franked Distribution Received | $1,500.00 | $73,875.00 | |
| 02/03/2026 | December 2025 quarter instalment | PAYG Instalment Paid | $7,900.00 | $81,775.00 | |
| 28/04/2026 | March 2026 quarter instalment | PAYG Instalment Paid | $7,900.00 | $89,675.00 | |
| 19/06/2026 | 2025/26 dividend ($96,000 fully franked) | Dividend Paid | $32,000.00 | $57,675.00 | |
| $32,000.00 | $36,340.00 | $57,675.00 | |||
Illustrative AccountKit Franking Account Register. Sample client group and sample figures, not tax advice.
Who it’s for
Built for practices with private company clients
Practices looking after private companies that pay tax and pay franked dividends. The list shows every register in the practice, one per company, with its ACN, latest entry and balance, so anyone in the team can check a balance.
How often it comes round
Whenever the company pays tax or a PAYG instalment, gets a refund, receives a franked distribution or pays a dividend.
- Each BAS quarter
- Record the PAYG instalment against the right quarter.
- Before a dividend
- Check the balance can support the franking.
- At year end
- Lock the year, use the closing balance in the return and export the register for the work papers.
Xero App Store reviews
What practices say about it
★★★★★
…Franking accounts are easily updated balanced and referenced to look up.…
AccountKit is rated 5.0 out of 5 from 83 reviews on the Xero App Store.
Questions
What practices ask about franking account register
Can a company have more than one franking register?
No. Each company has one franking account register. If you try to create a second, AccountKit opens the existing one.
Can we import our existing franking account history?
Yes. Put the history into AccountKit’s Excel import template without changing the headings, then import it. An entry dated in an earlier year goes into that year.
What does locking a year do?
It locks every entry up to the end of that year. Later years stay open, so you can keep adding entries.
Does the register pull entries from Xero or QuickBooks?
No. You record entries in the register yourself, or import them from Excel.
Can we change the types of franking entry?
Yes. The list of entry types is set in practice settings, so it can match the categories your firm already uses.
How do I get the register out for the file?
Export it to Excel or PDF, to your computer or the client’s folder in your document management.
Related tools
Tools that sit beside this one
- Compliance
Division 7A tool
Interest and minimum yearly repayments calculated across every loan, with a forecast for dividend planning.Follow a year end - Consulting
Client mapping tool
Diagrams of client structures, software and processes, with client details kept in sync.Explore a client group
Also in the toolkit
- Fuel tax credit calculatorEach client’s fuel tax credit claim calculated per period, then rolled over for the next one.
- Account reconcilerReconcile any balance sheet account through the year, from clearing accounts and suspense to loans, linked back to source verifications.
The heart of your firm
Check a company’s franking balance before the next dividend
Start a free 14-day trial and import one company’s franking history, or book a demo to see the register with the team.
