Unsupported loans and credit cards on the balance sheet in QBO
When your client’s debt doesn’t match any real-world statement
You open a new QuickBooks Online file, run a 12/31 balance sheet, and there it is:
- Truck Loan · $25,000
- Credit Card ABC · $5,000
You ask for supporting statements and the client says, "I’m not sure where those are, but that’s what my last bookkeeper had." You dig into QBO: no attachments on the accounts, no year-end statements on 12/31 transactions, nothing in their DMS. Or worse, you find a 12/31 statement for Credit Card ABC showing a $0 balance while QBO insists it’s $5,000.
This is how bogus, duplicated, or just plain unsupported debt ends up living on the balance sheet for years. It looks tidy enough on the report, but there’s no paper trail and no reconciliation back to any actual lender or card issuer.
For cleanup and year-end work, this is one of those issues that separates a quick-and-dirty file from a file you’d actually sign your name under.
Where this problem hides inside QuickBooks Online
In QBO, this shows up most clearly when you look at year-end balances for liability and credit card accounts and then go hunting for the documents that should support them.
A simple example:
- As of 12/31/24, the balance sheet shows:
- Truck Loan · $25,000 (Other Long Term Liabilities)
- Credit Card ABC · $5,000 (Credit Card)
- There are no attachments on the Truck Loan account record.
- There are no 12/31/24 transactions with attachments in either account.
- Or, the only attached statement for Credit Card ABC shows a 12/31/24 balance of $0.
In a clean file, you’d expect to see at least one of:
- A 12/31 loan statement with a balance that reasonably matches QBO.
- A 12/31 credit card statement with a balance that reasonably matches QBO.
- A loan origination document that, combined with amortization, explains the year-end balance.
Instead, you get silence.
Red flags to watch for:
- Liability or credit card accounts with non-zero 12/31 balances and no related attachments anywhere.
- Statements attached that clearly don’t match the account (wrong lender, wrong card, wrong entity).
- Statements attached with a 12/31 balance that’s way off from QBO (e.g., QBO shows $25,000, statement shows $10,000).
- Multiple "loan" accounts that appear to be the same debt split across names, but only one has a statement.
- Old loans that appear fully paid off per lender statements but still carry a small or even large balance in QBO.
If you only have a few liability accounts, run a 12/31 Balance Sheet, then right-click each loan/credit card account and open the register in a new tab. Quickly scan the last month of activity for attachments or notes pointing to external statements.
What happens if you just live with it
When unsupported debt sits on the balance sheet, the numbers may still tie to last year’s tax return, but they’re not anchored to reality. That comes back to bite you in multiple ways.
The damage inside your numbers
If a loan or credit card balance doesn’t tie to a statement, you don’t really know:
- Whether the principal balance is correct.
- Whether interest has been expensed properly.
- Whether payments have been split correctly between principal and interest.
Common downstream problems:
- Overstated or understated total liabilities.
- Misstated interest expense (especially if payments were dumped entirely to principal or to a generic expense).
- Negative or nonsense equity because bogus debt was used to "plug" prior-year differences.
- Duplicate loans where a refi or consolidation was booked as a new loan without closing out the old one.
If you’re preparing tax returns, this can mean:
- Wrong interest deductions.
- Wrong basis calculations for owners.
- Balance sheet schedules that don’t match lender statements, which is a problem if the IRS or a bank ever asks for support.
The damage in client conversations
From the client’s perspective, this is where trust erodes.
You sit down to review year-end and have to say things like:
- "We show $30,000 in loans, but I can’t tie $10,000 of that to any lender."
- "Your credit card balance in QuickBooks doesn’t match any statement we’ve seen."
If they’re going through a bank renewal, investor due diligence, or a potential sale, unsupported debt is a red flag. It makes the financials look sloppy, even if everything else is clean.
And for your firm, it creates liability: if you sign off on financials where material debt balances don’t tie to any statement, you’re taking on risk you don’t need.
How solid firms tackle this during cleanup
The firms that handle this well treat every non-trivial loan and credit card balance as something that must be supported by an external document at year-end. Not "nice to have"—required.
A practical workflow:
- Identify all non-zero year-end debt accounts.
- Run a Balance Sheet as of 12/31 for the target year.
- Focus on account types: Long Term Liabilities, Other Current Liabilities, Notes Payable, Other Liabilities, and Credit Card.
- Filter down to accounts with non-zero balances (allowing for tiny rounding differences).
- Check for attached statements or loan docs.
- From the Chart of Accounts, open each account.
- Look for attachments at the account level.
- Then run a Transaction Detail by Account report filtered to 12/31 only and scan for attachments on those entries.
- If you use a DMS, search by account name/number and year-end date.
- Tie the QBO balance to the statement.
- For each account with a statement, compare the 12/31 statement balance to the 12/31 QBO balance.
- Normalize signs (credit vs debit) and compare absolute values.
- Use a reasonable tolerance (e.g., $50–$100 for credit cards, maybe higher for long-term loans if there’s timing on interest accruals).
- Investigate material mismatches.
- If the difference exceeds your tolerance, dig into:
- Missing or misdated payments.
- Principal/interest split errors.
- Duplicate or reversed entries.
- Fix the history as far back as is practical, or document a one-time adjustment if you’re not reopening closed years.
- If the difference exceeds your tolerance, dig into:
- Handle accounts with no support at all.
- Ask the client for lender/card statements or loan docs.
- If they can’t produce anything, decide whether to:
- Reclassify the balance (e.g., to equity) if it’s clearly owner-related.
- Write it off if it’s immaterial and clearly bogus.
- Leave it with a clear workpaper note if it’s tied to prior filed returns and you’re not changing history.
- Document and mark verified accounts.
- For each account, note in your workpapers:
- Statement date and balance.
- QBO balance and difference.
- Your conclusion (OK, adjust, reclassify, or investigate later).
- In your internal system, mark accounts that you’ve manually verified so you don’t keep re-chasing them every year.
- For each account, note in your workpapers:
Set different tolerance levels by account type. For example, keep credit cards tight (e.g., $25–$50) because statements cut off monthly, but allow a bit more for long-term loans where interest accrual timing can create small differences.
Tools like CleanupOwl can help by automatically scanning liability and credit card accounts at year-end, checking for non-zero balances, and flagging where there’s no supporting statement or where the statement balance doesn’t reasonably match QBO. Instead of spending an hour building that list manually, you start your review with the exceptions already identified.
Making this a standard part of every file review
This shouldn’t be a heroic one-time cleanup effort; it should be a checklist item every year (and ideally every cleanup engagement).
How to operationalize it:
- Add a line to your year-end workpapers: "All non-zero loans and credit cards supported by statements and reconciled within tolerance."
- Decide firm-wide tolerances by account type and document them in your SOPs.
- Use a diagnostic tool like CleanupOwl early in your intake or diagnostic review to surface unsupported or mismatched debt before you quote or start detailed work.
- For recurring clients, maintain a list of "verified" debt accounts so you only chase new or changed items each year.
If you do this consistently, you’ll find that loan and credit card issues stop being last-minute surprises and become routine, quick checks.
The patterns you’ll keep seeing in client files
| Situation | What you see in QBO | Risk if you shrug it off |
|---|---|---|
| Old truck loan with no docs | $25,000 balance at 12/31, no attachments, client can’t produce a statement | Overstated liabilities, wrong interest expense, potential equity misclassification |
| Credit card with big mismatch | QBO shows $5,000 at 12/31, attached statement shows $0 or $1,200 | Misstated expenses and liabilities, possible duplicate or missing payments |
| Multiple loans to same lender | Three "Bank XYZ Loan" accounts, only one has a statement, balances don’t align | Duplicate or fragmented debt, confusion in lender and tax schedules |
| Loan fully paid per lender, not in QBO | Statement shows $0 at 12/31, QBO still shows $3,500 | Phantom debt on balance sheet, understated equity |
| Owner card booked as business debt | "Credit Card ABC" in QBO, but statement is clearly a personal card | Personal expenses in business, wrong debt classification, messy for tax and due diligence |
In some cases, the fix is minor—clean up a few misposted payments, adjust interest, and you’re done. In others, you’re looking at a deeper historical cleanup or a conversation about reclassifying balances to equity or distributions.
Your firm doesn’t need to treat every small difference like a federal case. For tiny balances or immaterial differences within your tolerance, document that you’ve reviewed and move on. For larger or unexplained gaps, slow down and resolve them properly; those are the ones that blow up in bank renewals, audits, or sales processes.
Be careful with prior-year balances that tie to filed tax returns. If fixing an unsupported loan would change beginning balances, coordinate with whoever prepared the returns and document your approach. Sometimes the right answer is a prospective fix plus a clear note, not a retroactive rewrite.
Making this part of your cleanup playbook
Loan and credit card balances look simple on the balance sheet, but they’re one of the easiest places for bad data to hide. Unsupported debt, duplicate loans, and mismatched card balances can sit there for years because nobody took the time to tie them back to real-world statements.
If your firm treats "every non-zero loan and credit card must be supported by a statement and reconciled within tolerance" as a hard rule, your cleanups get more defensible and your year-end work gets faster over time. You’re not re-discovering the same problems every year; you’re maintaining a set of verified balances.
Tools like CleanupOwl can run this kind of check before you even touch the file, so your team starts with a list of which debt accounts lack support or don’t match their statements. That’s a much better use of senior time than manually hunting through registers and attachments.
If you’re a business owner, this is the kind of question you can ask your accountant: "Do our loan and credit card balances in QuickBooks actually tie to lender and card statements, and do you check that each year—manually or with a diagnostic tool like CleanupOwl?"
Build this into your standard diagnostic review, and you’ll avoid a lot of awkward conversations with banks, buyers, and tax authorities later.
Ready to run deeper QuickBooks diagnostics?
Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.
Start Free Trial