Skip to main content

False Zero Balance Report

Written by Meridythe Lanoue

About This Report

The Zero Balance Report highlights accounts showing a $0 balance on open or closed invoices. In these cases, charges and credits offset each other, resulting in a net zero balance. However, the transactions may not be properly allocated to the correct invoices.

Recommended Action

We recommend reviewing each account listed in this report to verify the accuracy of all associated transactions. If discrepancies are found, adjust or reconcile the entries to correct any false zero balances and ensure proper allocation.

Need Assistance?

If you encounter a large number of false $0 balance accounts, our Customer Support Team can help. Contact us at [email protected] for assistance.


Note: To access this report in Analytics, users must have the analytics_false_zero_balance_report permission assigned to their role.

The False Zero Balance Summary Report includes the following tabs:

Report Info Tab

The Report Info tab serves as the cover page of the report. It displays:

  • Hospital name and location

  • The report’s date and time range

  • The date the report was created

Glossary Tab

The Glossary tab provides definitions for column headings used throughout the report for clarity.

For this report, the glossary includes a note explaining the purpose of the report.

False $0 Balance Accounts

The False $0 Balance Accounts tab includes the following information:

  • Account ID

  • Account Label

  • Account Type

  • Account Alerts

  • Tax Exempt

  • Client Name

  • Client First Name

  • Client Last Name

  • Client Address

  • Unapplied Payments

  • Account Balance

  • Current Balance

  • Over 30 Days Balance

  • Over 60 Days Balance

  • Over 90 Days Balance

  • Over 120 Days Balance

  • Client Phone Number

  • Client Email

  • Patient(s): List of the client’s pets with balances or credits

  • Account Notes

  • Date of Last Payment

  • Invoice IDs

Recommended Action on False Zero Balances

When an account on the Financials tab shows a $0 balance, an alert will appear. This helps identify situations where a payment may have been applied to the wrong invoice or where account deposits have not yet been associated with an invoice.

Hover over the tooltip to see one of three scenarios that indicate how the funds should be allocated.

An overpaid invoice and an underpaid invoice.

An unapplied account credit.

Multiple unpaid invoices with available account credits.

To move funds to the correct invoice and remove the account from the Financial Ledger, follow these steps:

Overpaid Invoice and an Underpaid Invoice Scenario

  • Using the Payments panel, identify the patient with the invoice balance and review each invoice to locate the overpayment. One invoice should show a negative balance, and another should have a balance equal to the overpaid amount.

For example: Invoice 13090 is overpaid by $440.91, while Invoice 13089 remains unpaid by $440.91.

  • Once the invoices are identified, click the three-dot menu next to the overpaid invoice in the Financial Ledger and select Unapply Payment(s).

  • A pop-up box will appear, allowing you to enter the overpayment amount to transfer into the Account Credit.

  • The funds will move into the account’s Account Credit.

  • Then, apply a payment to the invoice using Payment Type: Payment and Payment Method: Account Credit for the same amount to pay off the invoice, as long as the balances match.

  • The account should now show a $0.00 balance and will no longer appear on the Financial Ledger as a False Zero Balance.

Recommended Action on Account Credit Scenario

If the tooltip indicates that there are funds in the Account Credit and one or more invoices remain unpaid, simply allocate the credits to the outstanding invoice(s).

  • One Invoice: Select the unpaid invoice and apply a payment using Payment Type: Payment and Payment Method: Account Credit for the same amount to pay off the invoice.

  • Multiple Invoices/Pets: In the Account tab of the Payments panel, select Balance Payoff and use Payment Method: Account Credit to pay off all outstanding visits.

  • The account should now show a $0.00 balance and will no longer appear on the Financial Ledger as a False Zero Balance.

Did this answer your question?