E-Lab2.0
6.6 Business reports

Find who still owes money with the Balance Report

Get a call list of only the bills with money still due, and the total outstanding in one box.

Balance Report
More in Business reports
Where to find it
MenuReports › Balance Report

The Balance Report lists bills that still have a balance. A bill that is fully paid never shows here. Payments are counted whatever their date, so a balance paid yesterday for a bill from last month removes that bill from the list.

The date range filters on the bill date. With From on today, you see only today's dues. Move From back to see older bills.

Total outstanding at a glance
The Total Balance box is the sum of all dues in the list.

Clears itself
When a patient pays the balance in Test Report, the bill leaves the list. No manual striking off.

In a real labEvery Monday morning the receptionist sets From to the 1st of the month and prints the Balance Report. She calls each number before 11 am. Patients who pay on collecting the report drop off the list by themselves, so the next Monday's list is shorter and nobody gets a second call for a bill they have cleared.

On this screen

  1. From move back to include older bills
  2. OK reloads the list for the dates
  3. Receipt all payments on the bill, any date
  4. Balance what the bill still owes
  5. Total Received already paid on the listed bills
  6. Total Balance the total amount outstanding

Make the call list

  1. Open the report
    Go to Reports > Balance Report. Today's unpaid bills load at once.
  2. Widen the dates
    Set From back, for example to the start of the financial year, and click OK.
  3. Read the totals
    Total Balance is the money still due on the listed bills. Total Received is what those same bills have already paid.
  4. Call the patients
    Work down the list. Double-click a row to open the bill and see its tests and payments before you call.
  5. Take the payment
    When the patient pays, add a receipt in Test Report. The bill drops off the list next time you click OK.

How each row is worked out

ColumnMeaning
CostTotal of the tests on the bill.
Extra chargesHome collection or other charges on the bill.
discountThe bill's discount in rupees.
ReceiptAll cash and card payments on the bill, on any date.
BalanceCost + Extra charges − discount − Receipt. Only bills with more than ₹0.00 are listed.

Example: Anil Verma's bill has tests of ₹1,800, home collection ₹100 and a discount of ₹100. He paid ₹1,000 at billing. His Balance is 1,800 + 100 − 100 − 1,000 = ₹800. The other columns are dt, No., Patient Name, Age, Gender, Doctor, category and remarks.

CautionOnly bills dated inside From and To are shown. A dues list made with From on today hides every older bill. For a full list, set From to the first day of the financial year.
Patient privacyThe list holds names and amounts owed. Do not leave it on the counter where other patients can read it.

Questions people ask

Last month's dues are missing.

Set From to a date in last month and click OK.

Which box is the amount outstanding?

Total Balance.

A patient paid last week but is still listed.

That should not happen, because all payments are counted. Open the bill and check that the payment was saved in the Test Report receipts.

Are hospitals that owe us in this list?

Only their patients' bills, one by one. For a hospital's statement use the Hospital Report.

See E-Lab on your own tests and reports.

Tell us your tests, your analyser and how you send reports today. We show you the same work in E-Lab and Lifora, on a call or at your lab.