Every Diagnostic Report we generate includes a Health Score — a single number from 0 to 100 that summarizes how clean and trustworthy your QuickBooks file is.

This guide explains exactly how that score is calculated, what each component means, and how to read it like an accountant.


1. The Big Picture

Your file starts at a perfect 100.

We then check it against five areas of accounting hygiene. For every issue we find — an unreconciled bank account, a negative vendor balance, an uncategorized transaction, and so on — we deduct a small number of points from the area it affects.

The five areas are combined into one final, weighted score.

The lower the score, the more cleanup the file needs.

A score of 85+ means the file is in good shape.

A score below 30 means the financials cannot be trusted without significant work.


2. The Five Health Areas

Not every area carries equal weight.

Areas that undermine the trustworthiness of the financials are weighted more heavily.

Area

Weight

What It Checks

Reconciliation & Cash Accuracy

25%

Bank and credit card accounts are reconciled and current

Customer & Vendor Balances (AR/AP)

20%

Invoices, bills, and payments are tracking cleanly

Transaction Coding

20%

Class, location, and account assignments are correct

Completeness

20%

Transactions are categorized and payees are filled in

General Ledger Integrity

15%

Account balances are clean, with no duplicates or unexplained negatives

Why these weights?

  • Reconciliation gets the highest weight (25%) because if bank and credit card accounts are not reconciled, every other number on the financials becomes questionable.

  • AR/AP, Coding, and Completeness each get 20% because they directly impact reporting accuracy and statement reliability.

  • GL Integrity gets 15% because issues there are usually localized to specific accounts.


3. Score Bands

Score

Band

Meaning

85 – 100

🟢 Healthy

Books are clean with minimal cleanup needed

70 – 84

🟢 Good

A few issues exist, but financials are generally reliable

50 – 69

🟡 Moderate

Financials need work before relying on them

30 – 49

🟠 Poor

Significant cleanup is needed

0 – 29

🔴 Critical

Books cannot be trusted in their current state


4. How Points Are Deducted

Each area starts at 100 points.

Every issue found subtracts a fixed number of points.

More severe accounting problems result in larger penalties.

Important: Each area is capped at a minimum score of 0.

Even if one area is severely damaged, it cannot reduce the total score beyond its assigned weight.


Area 1 — Reconciliation & Cash Accuracy (25%)

Issue

Penalty

Impact

Bank/credit card account never reconciled

-25

Cash figures cannot be trusted

Reconciliation discrepancy

-15

Reconciliation does not tie out properly

Stale reconciliation (not reconciled within 30 days)

-10

Account has fallen behind

Transaction stuck in Undeposited Funds

-2

Cash sits in a clearing account instead of the bank

Uncleared bank/CC transaction

-0.05

Minor individually but impactful in large volume

Area 2 — Customer & Vendor Balances (AR/AP) (20%)

Issue

Penalty

Impact

Negative customer balance

-5

Indicates overpayments or misapplied credits

Negative vendor balance

-5

Distorts AP reporting and 1099 prep

Unapplied payment (AR)

-3

Payment not linked to an invoice

Unapplied payment (AP)

-3

Bill payment not properly applied

Past-due invoice 90+ days

-1.5

Revenue collection risk

Past-due bill 90+ days

-1.5

Vendor payment risk

Area 3 — Transaction Coding (20%)

Issue

Penalty

Impact

GL misclassification

-2

Distorts financial statements

Posted to parent account instead of child

-0.3

Impacts sub-account reporting

Missing class

-0.03

Weakens departmental reporting

Missing location

-0.03

Impacts location-based reporting

Area 4 — Completeness (20%)

Issue

Penalty

Impact

Uncategorized transaction

-2

No accounting decision has been made

Missing payee

-0.5

Weakens vendor and 1099 reporting

Pending bank-feed item

-0.05

Unprocessed transaction waiting for review

Area 5 — General Ledger Integrity (15%)

Issue

Penalty

Impact

Account with negative balance

-3

Usually indicates a coding issue

Possible duplicate contact

-3

Splits transaction history and reporting

Small fixed asset purchase capitalized

-2

Creates unnecessary balance sheet bloat

Negligible-balance vendor

-1

Cleanup issue

Negligible-balance customer

-1

Cleanup issue

---|---|---|
| Bank/credit card account never reconciled | −25 | Cash figures cannot be trusted |
| Reconciliation discrepancy | −15 | Reconciliation does not tie out properly |
| Stale reconciliation (not reconciled within 30 days) | −10 | Account has fallen behind |
| Transaction stuck in Undeposited Funds | −2 | Cash sits in a clearing account instead of the bank |
| Uncleared bank/CC transaction | −0.05 | Minor individually but impactful in large volume |


Area 2 — Customer & Vendor Balances (AR/AP) (20%)

Issue

Penalty Each

Why

Negative customer balance

−5

Indicates overpayments or misapplied credits

Negative vendor balance

−5

Distorts AP reporting and 1099 prep

Unapplied payment (AR)

−3

Payment not linked to an invoice

Unapplied payment (AP)

−3

Bill payment not properly applied

Past-due invoice 90+ days

−1.5

Revenue collection risk

Past-due bill 90+ days

−1.5

Vendor payment risk


Area 3 — Transaction Coding (20%)

Issue

Penalty Each

Why

GL misclassification

−2

Distorts financial statements

Posted to parent account instead of child

−0.3

Impacts sub-account reporting

Missing class

−0.03

Weakens departmental reporting

Missing location

−0.03

Impacts location-based reporting


Area 4 — Completeness (20%)

Issue

Penalty Each

Why

Uncategorized transaction

−2

No accounting decision has been made

Missing payee

−0.5

Weakens vendor and 1099 reporting

Pending bank-feed item

−0.05

Unprocessed transaction waiting for review


Area 5 — General Ledger Integrity (15%)

Issue

Penalty Each

Why

Account with negative balance

−3

Usually indicates a coding issue

Possible duplicate contact

−3

Splits transaction history and reporting

Small fixed asset purchase capitalized

−2

Creates unnecessary balance sheet bloat

Negligible-balance vendor

−1

Cleanup issue

Negligible-balance customer

−1

Cleanup issue


5. Severity Pattern

Penalty Tier

Meaning

Examples

15 – 25 pts

Financial foundation issue

Unreconciled bank account

3 – 5 pts

Real accounting error

Negative balances, duplicate contacts

2 pts

Financial statement distortion

Misclassification, uncategorized transaction

1 – 1.5 pts

Workflow or cleanup issue

Past-due AR/AP

0.3 – 0.5 pts

Minor data quality issue

Missing payee

0.03 – 0.05 pts

Small-volume hygiene issue

Missing class/location

A single severe issue can outweigh hundreds of minor data-quality issues.

Key Design Principles

  1. Issues that affect financial statement accuracy are penalized most heavily.

  2. Small issues matter when they accumulate in large volume.


6. Worked Examples

Example 1 — Two Unreconciled Bank Accounts

Setup

  • 5 bank accounts total

  • 3 reconciled through Dec 2025

  • 2 never reconciled

Reconciliation Impact

Account Status

Penalty

Reconciled

0

Never reconciled

−25 each

Total penalty: −50

Reconciliation score: 50 / 100

Overall Score Impact

Area

Score

Weighted Contribution

Reconciliation

50

12.5

AR/AP

100

20

Coding

100

20

Completeness

100

20

GL Integrity

100

15

Final score: 88 → Healthy

What This Means

Two unreconciled accounts reduce the reconciliation area significantly.

Because reconciliation has the highest weight, it pulls the total score down by approximately 12–13 points.


Example 2 — Adding Negative Vendor Balances

Same example as above, but now there are also:

  • 2 vendors with negative balances

AR/AP penalty:

  • 2 × 5 = −10

AR/AP score:

  • 90 / 100

Updated Overall Score

Area

Score

Weighted Contribution

Reconciliation

50

12.5

AR/AP

90

18

Coding

100

20

Completeness

100

20

GL Integrity

100

15

Final score: 86 → Healthy


Example 3 — Reconciliation Variations

Scenario

Reconciliation Score

Overall Score

Band

All accounts reconciled

100

100

🟢 Healthy

2 never reconciled

50

88

🟢 Healthy

2 stale reconciliations

80

95

🟢 Healthy

All 5 never reconciled

0

75

🟢 Good

These examples assume all other areas are perfect.

In real files, additional issues will reduce the score further.


7. Frequently Asked Questions

Why is reconciliation weighted so heavily?

Because every financial report ultimately depends on accurate reconciled transactions.

If bank balances do not tie to statements, downstream reports become unreliable.

Why does a negative vendor cost 5 points but a missing payee only 0.5?

A negative vendor balance usually represents a real accounting error.

A missing payee is primarily a data-quality issue and does not affect totals.

Why are some penalties so small?

Some issues are insignificant individually but become important at scale.

For example:

  • 1 missing class = minor issue

  • 1,000 missing classes = major reporting problem

Can one bad area destroy the overall score?

No.

Each area is capped at zero, so one category cannot reduce the total score beyond its assigned weight.

Does the final score round?

Yes.

The final score is rounded to the nearest whole number.

Fastest Ways to Improve the Score

  1. Reconcile any never-reconciled bank or credit card accounts

  2. Resolve reconciliation discrepancies

  3. Bring stale reconciliations current

  4. Fix negative customer/vendor balances

  5. Categorize uncategorized transactions

  6. Match unapplied payments properly


8. TL;DR

  • Health Score ranges from 0–100

  • Five weighted areas determine the score

  • Severe accounting issues reduce the score most heavily

  • Small hygiene issues matter when they accumulate

  • 85+ = Healthy

  • Below 30 = Critical

  • Reconciling bank accounts is usually the fastest way to improve the score


Have questions about how your score was calculated?

Reach out to support and we will walk through it with you.

Was this helpful?