Unreconciled
17,556
Across 8 clients
Overdue invoices
$2.24M
357 invoices
Overdue bills
$86.7K
44 bills
Missing bank feeds
3
Kityan · Dodd · Hodgeys
28 Jul 2026
Q4 BAS due — 7 clients
Agent ext: 25 Aug
Agent ext: 25 Aug
Critical — act today
Jacob Dodd — no bank feed, 6,803 lines unreconciled
Statement stale since Jan 1. All reconciliation blocked until bank feed connected or CSV imported.
No bank feed6,803 unreconciledCBA Business Account
AA Kityan Cleaning — $2.15M Xero balance vs $0 bank statement
No bank feed (NAB). 24 invoice drafts unsent ($9,418). Likely years of unmatched entries requiring full audit.
$2.15M discrepancy24 drafts unsentNo bank feed
Onyx Building — all invoices and bills overdue, negative balance
$87,239 receivable (34 invoices) and $71,297 payable (27 bills) all overdue. Bank balance -$7,479.
Cash flow risk$87K receivables-$7,479 balance
Client health scores
DC
David Coffey
10,248 unrec · $1.99M OD
8
JD
Jacob Dodd
6,803 unrec · no bank feed
15
HH
Hodgeys Hot Rodz
332 unrec · $291K discrepancy
18
AK
AA Kityan Cleaning
$2.15M discrepancy · no feed
32
OB
Onyx Building
$87K inv · $71K bills OD
35
XB
XBook (practice)
49 unrec · $54K invoices OD
40
CH
CH8 Billiards
19 unrec · $5K invoices OD
45
1B
126 Beverin St Pty Ltd
1 unrec · bank feed connected
72
Today's checklist
Send bank feed request — Jacob Dodd
Blocks all reconciliation until connected
Jacob Dodd
Investigate AA Kityan $2.15M discrepancy
Data integrity — urgent review
AA Kityan
Call Onyx Building — cash flow crisis
All invoices and bills overdue
Onyx Building
Review INV-0165 bad debt — $55,000 (2021)
Write off or refer to collector?
David Coffey
Send 6 pending invoice drafts ($4,582)
Sitting unsent — delaying cash collection
CH8 Billiards
Reconcile 1 outstanding item ($35 diff)
Quick win — nearly clean
126 Beverin St
Send bank feed request — Hodgeys
$291K discrepancy needs feed connected
Hodgeys
Begin Q4 BAS prep — David Coffey
Most complex file, due 28 Jul (ext. 25 Aug)
David Coffey
Critical — 4 alerts
Jacob Dodd — no bank feed, 6,803 lines unreconciled
Statement balance stale since January 1. Reconciliation blocked. CBA Business Account 063-502-11033646 needs direct feed or CSV import.
No bank feed6,803 unreconciledCBA
AA Kityan Cleaning — $2,156,600 Xero balance vs $0 bank statement
No bank feed (NAB 083-543-769820083). 24 invoice drafts unsent ($9,418). Likely years of unmatched entries or ghost transactions. Full audit required.
$2.15M discrepancy24 drafts unsentNo bank feed
Onyx Building — all 34 invoices and 27 bills overdue, negative balance
$87,239 owed to Onyx (34 invoices overdue), $71,297 owed by Onyx (27 bills overdue). CBA balance -$7,479. Macquarie savings not on bank feed.
Cash flow crisis$87K receivables OD$71K payables ODNeg. balance
David Coffey — INV-0165 overdue 1,743 days ($55,000)
Invoice to Christine & Maggie outstanding since 27 August 2021. All 284 invoices ($1.99M) are overdue. Requires urgent receivables review and bad debt decision.
1,743 days overdueBad debt candidate$55,000
Needs attention this week
Q4 BAS due 28 July 2026 — 7 clients need preparation (agent ext. 25 Aug)
53 days to standard deadline. Start with David Coffey (10,248 unrec) and Jacob Dodd (6,803 unrec) immediately. Q4 covers April–June 2026.
53 days standard81 days agent ext.7 clients
CH8 Billiards — 6 invoice drafts unsent ($4,582)
Draft invoices delaying cash collection. All 3 active invoices ($5,055) and 5 bills ($1,072) also overdue. $2,282 bank discrepancy unreconciled.
6 drafts unsent$4,582 pendingAll invoices OD
Hodgeys Hot Rodz — $291,816 balance discrepancy, 332 unreconciled, no bank feed
A J Hodges account: Xero -$254,257 vs statement $37,560. LaTrobe Financial no bank feed (stale Jan 1). 5 overdue bills ($5,589).
$291K discrepancyNo bank feed332 unreconciled
June 2026 — all clients
Outstanding activity statements — loaded from ATO portal
Report date: 5 June 2026
⚠️ DAVID COFFEY — MAJOR TAX COMPLIANCE REMEDIATION REQUIRED
ABN: 26 281 331 269 · TFN: 360 127 210 · Individual/Sole trader · Monthly + Quarterly BAS + PAYGI
$163,108.62
owing to ATO
~83
Outstanding BAS
11.5
Years unfiled
Oct 2014
Earliest outstanding
22 Jun
Next due (May 2026)
What this means: David Coffey has had outstanding BAS lodgements since Q4 FY2014-15 and has never been fully compliant. The $163,108 ATO debt is the accumulated result. This is not a bookkeeping issue — this is a serious tax compliance matter that requires a structured remediation plan, potentially including a payment arrangement with the ATO and a catch-up lodgement strategy working from oldest to most recent.
Note: There is also a Fuel response notification on his ATO file that needs to be checked — this may relate to fuel tax credit entitlements given his expense profile (Fuel: $26,038 in FY26).
📧 No email address on ATO file. Contact via Xero or direct phone.
Note: There is also a Fuel response notification on his ATO file that needs to be checked — this may relate to fuel tax credit entitlements given his expense profile (Fuel: $26,038 in FY26).
📧 No email address on ATO file. Contact via Xero or direct phone.
Recent outstanding periods (most urgent first)
| Period | Type | Due date | Status |
|---|---|---|---|
| May 2026 | Monthly BAS (Form G) | 22 Jun 2026 — 17 days | Due soon |
| Apr 2026 | Monthly BAS | 21 May 2026 | Overdue |
| Jan–Mar 2026 | Quarterly BAS (Q3) | 21 Apr 2026 | Overdue |
| Feb 2026 | Monthly BAS | 23 Mar 2026 | Overdue |
| Jan 2026 | Monthly BAS | 23 Feb 2026 | Overdue |
| Oct–Dec 2025 through Oct–Dec 2014 | Mixed monthly/quarterly | All overdue | ~78 more overdue |
Recommended action plan:
1. Contact David Coffey immediately to discuss the extent of non-compliance
2. Assess whether a payment arrangement with the ATO is appropriate given the $163K debt
3. Consider applying for failure to lodge penalty remission — the ATO may remit penalties where there is a genuine reason for non-lodgement
4. Lodge oldest outstanding first — ATO generally requires chronological lodgement for catch-up situations
5. Check the Fuel response notification — may indicate fuel tax credit entitlement given significant fuel expenses
1. Contact David Coffey immediately to discuss the extent of non-compliance
2. Assess whether a payment arrangement with the ATO is appropriate given the $163K debt
3. Consider applying for failure to lodge penalty remission — the ATO may remit penalties where there is a genuine reason for non-lodgement
4. Lodge oldest outstanding first — ATO generally requires chronological lodgement for catch-up situations
5. Check the Fuel response notification — may indicate fuel tax credit entitlement given significant fuel expenses
JD
Jacob Dodd
ABN: 13 507 663 625 · Individual/Sole trader · Quarterly BAS · 📧 JACODTD0@GMAIL.COM
$18,153.78 owing
11 outstanding BAS
Outstanding BAS from Q3 FY2022-23 through Q3 FY2025-26 — 11 consecutive quarters all showing NEW. GST active on all. No PAYGW despite Xero having a Tax & GST account. Payment reference: 4135076636258960.
Q3 FY25-26 — due 26 May 2026
Q2 FY25-26 — due 3 Mar 2026
Q1 FY25-26 — due 25 Nov 2025
Q4 FY24-25 — due 25 Aug 2025
+ 7 more quarters
HH
Andrew Hodges (Hodgeys Hot Rodz)
ABN: 11 012 551 477 · Individual/Sole trader · Quarterly BAS + PAYGW · No email on file
$1,081.61 owing
13 outstanding BAS
Outstanding BAS from Q3 FY2022-23 through Q3 FY2025-26 — all showing NEW with both GST and PAYGW active. 13 consecutive quarters. No email address on ATO file.
AK
AA Kityan Cleaning Pty Ltd
ABN: 20 663 222 580 · Australian Private Company · Quarterly BAS + PAYGW · 📧 QUIDDETTE69@OUTLOOK.COM
$0.00 balance
13 outstanding BAS
Outstanding BAS from Q3 FY2022-23 through Q3 FY2025-26 — all NEW, GST + PAYGW active. Account balance is $0 which is unusual given 13 outstanding quarters — may indicate payments made but forms not lodged.
Current period only — recently connected clients
126 Beverin St Pty Ltd
ABN: 24 683 809 207 · Monthly
Apr 2026 outstandingMay 2026 outstanding
Balance: $0.00 ✓
Onyx Building Pty Ltd
ABN: 13 651 419 671 · Monthly
May 2026 outstanding
Balance: -$1,100 (credit) ✓
📧 INFO@ONYXBUILDING.COM.AU
Alan Marchingo (XBook)
ABN: 79 149 024 066 · Monthly
May 2026 outstanding
Balance: -$1,277 (credit) ✓
📧 INFO@XBOOK.COM.AU
ATO report importer
Drop ATO report CSVs here
Drag and drop one or more CSV files downloaded from Online Services for Agents, or click to browse. Accepts individual CSVs or a ZIP of multiple reports.
ATO account balances — loaded from portal reports
Run date: 31 May 2026
PAYG instalments — David Coffey (ATO data)
ATO interest history — clients with late payment charges
Active jobs
Awaiting docs
0
In progress
0
Awaiting sign-off
0
Ready to lodge
0
Completed
0
Current & upcoming
28Jul
Q4 BAS — April to June 2026
David Coffey · AA Kityan · CH8 Billiards · Onyx Building · Hodgeys · Jacob Dodd · 126 Beverin St · Agent ext: 25 Aug 2026
28Jul
Super guarantee — Q4 contributions (Apr–Jun 2026)
All clients with employees · Must be received by fund by 28 July — no extensions apply
14Jul
STP finalisation — Single Touch Payroll FY2025–26
All clients with payroll · Finalise employee payment summaries in Xero before 14 July
14Aug
TPAR — Taxable Payments Annual Report FY2025–26
Clients in building, cleaning, courier, IT, security · Due 14 August 2026
31Oct
Individual income tax returns — FY2025–26
All individual clients · Sole traders include business income · Agent lodgement program may extend
Full BAS calendar — FY2025–26 & FY2026–27
| Quarter | Period (Australian FY) | Standard due | Agent extension | Status |
|---|---|---|---|---|
| Q1 FY25–26 | Jul – Sep 2025 | 28 Oct 2025 | 25 Nov 2025 | Lodged |
| Q2 FY25–26 | Oct – Dec 2025 | 28 Feb 2026 | No extension | Lodged |
| Q3 FY25–26 | Jan – Mar 2026 | 28 Apr 2026 | 26 May 2026 | Lodged |
| Q4 ◀ NOW FY25–26 | Apr – Jun 2026 | 28 Jul 2026 | 25 Aug 2026 | Due soon |
| Q1 FY26–27 | Jul – Sep 2026 | 28 Oct 2026 | 25 Nov 2026 | Upcoming |
| Q2 FY26–27 | Oct – Dec 2026 | 28 Feb 2027 | No extension | Upcoming |
| Q3 FY26–27 | Jan – Mar 2027 | 28 Apr 2027 | 26 May 2027 | Upcoming |
| Q4 FY26–27 | Apr – Jun 2027 | 28 Jul 2027 | 25 Aug 2027 | Upcoming |
Monthly IAS due dates
Drafted emails
To: Jacob Dodd
Bank feed requestAction required — Please connect your bank feed to Xero
Hi Jacob,
I'm writing to let you know that your CBA Business Account (063-502-11033646) has not been connected to Xero via a bank feed. Without this, I'm unable to reconcile your transactions...
I'm writing to let you know that your CBA Business Account (063-502-11033646) has not been connected to Xero via a bank feed. Without this, I'm unable to reconcile your transactions...
To: Onyx Building
Urgent — cash flowUrgent — Outstanding invoices and cash flow discussion
Hi,
I've been reviewing your Xero file and need to flag some urgent matters. You have 34 overdue invoices totalling $87,239 and 27 overdue bills totalling $71,297. Your bank balance is -$7,479...
I've been reviewing your Xero file and need to flag some urgent matters. You have 34 overdue invoices totalling $87,239 and 27 overdue bills totalling $71,297. Your bank balance is -$7,479...
To: Hodgeys Hot Rodz
Bank feed requestBank statement needed — A J Hodges account
Hi AJ,
To reconcile your A J Hodges account in Xero, I need either a bank feed connection or a CSV statement export from Bankwest. There's currently a $291,816 difference...
To reconcile your A J Hodges account in Xero, I need either a bank feed connection or a CSV statement export from Bankwest. There's currently a $291,816 difference...
Client profiles & obligations