Finance Inpatient Invoice Journal

Inpatient Invoice Journal

Introduction

The inpatient invoice journal is an accounting-focused report that lists all inward billing transactions in a structured format suitable for journal entry posting to an external accounting system (such as QuickBooks). Each row shows the bill reference, patient, charge category, amount, and corresponding accounting codes, enabling systematic transfer of inpatient revenue data to the general ledger.

Navigation

Main Menu → Inward → Reports → Invoice Journal OR Main Menu → Financial Reports → Inward Invoice Journal

Generating the Invoice Journal

1. Navigate to inward/inward_report_invoice_journal.xhtml.
2. Set the date range (From Date, To Date).
3. Select filters as needed:
   • Ward or unit
   • Charge category (All, or specific InwardChargeType)
   • Bill status (Active, Cancelled, or both)
4. Click Generate.
5. The report renders in the browser.
6. Use Export to Excel to download for accounting software import.

Report Columns

Column	Description
Bill Date	Date the bill was created
BHT No	Bed Head Ticket / admission reference
Patient Name	Admitted patient
Ward	Ward where the patient was admitted
Charge Category	InwardChargeType (Room, Nursing, Investigation, etc.)
Gross Amount	Total charge before discounts
Discount	Any price adjustments applied
Net Amount	Gross − Discount
Payment Method	Cash, Credit, Insurance, etc.
Accounting Code	GL code for journal entry (if configured)
Remarks	Notes or reference

Use Cases

Internal Accounting Reconciliation

The invoice journal allows the accounts department to verify that all inpatient charges have been captured and to reconcile the billing system totals against the general ledger.

QuickBooks IIF Export

When configured for QuickBooks integration, the invoice journal can generate an IIF-format file that is imported directly into QuickBooks as journal entries. See QuickBooks Integration Overview.

Insurance / Credit Company Verification

Filter by payment method = Credit to view all insurance-billed charges for a period, then match against insurer claim reports.

Filtering Tips

• Use a narrow date range (single day) for daily journal posting.
• Filter by ward to produce department-level revenue summaries.
• Export to Excel before importing to QuickBooks or other accounting tools.

Technical Reference

Item	Detail
Page	inward/inward_report_invoice_journal.xhtml
Controller	InwardInvoiceJournalController
Export format	Excel (Apache POI)
QB integration	See Finance-QB-Integration-Overview