# 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](Finance-QB-Integration-Overview.md).

### 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](Finance-QB-Integration-Overview.md) |