Understanding Batch Payments

Introduction

The Batch Payment Allocation System is designed for managing insurance and patient payment allocations in healthcare billing. It ensures accurate distribution of payments across invoices, handling adjustments, balances, and validation checks to maintain consistency.

System Overview

The system automatically processes payments, adjusting the amounts due from both patients and insurance providers. It supports scenarios where invoices contain multiple payment lines, ensuring correct allocations while minimizing manual intervention.

Key Features

  • Automated Payment Allocation: Payments are distributed across invoice items according to predefined rules.
  • Balance Management: Real-time calculations of outstanding balances for both patients and insurance providers.
  • Zero-Sum Validation: Ensures all allocation distributions sum to zero.
  • Field Dependencies: Automatic updates between related fields (e.g., adjustments affecting patient responsibility).

Core Components

1. Allocation Distribution

  • Ensures financial adjustments across payment lines equal zero.
  • Includes allowances, overages, and copays.

2. Transfer to Patient

  • Calculates the final amount the patient is responsible for after all allocations.

3. Balance Management

  • Displays the updated patient and insurance balances after payment processing.

Invoice & Allocation Workflow

Step 1: Invoice Generation

  • Each invoice contains detailed line items including products, procedures, allowances, and copays.
  • Prices, taxes, and due amounts are clearly displayed.

Step 2: Batch Payment Allocation

  • Payments are received and distributed across invoice items.
  • Adjustments and transfers are automatically calculated, ensuring accurate balance updates.

Field Definitions

Field Name Type Description
Claim Amount Float Original invoice amount for the procedure.
Insurance Payment Float Amount paid by the insurance provider.
Adjustment Amount Float Manual claim adjustment (e.g., discounts).
Write-Off Amount Float Difference between the invoice discount and the adjustment.
Allocation Distribution Float The sum of all allocations must be zero across payment lines.
Transfer to Patient Float The final patient responsibility after allocations.
Patient Balance Float Current outstanding patient balance.
Insurance Balance Float Current outstanding insurance balance.
New Patient Balance Float Updated patient balance post-allocation.
New Insurance Balance Float Updated insurance balance post-allocation.

Calculation Rules

1. Transfer to Patient Calculation

Transfer to Patient = Allocation - Insurance Payment - Adjustment - Write-Off

2. New Balance Calculations

  • New Patient Balance = Current Patient Balance + Transfer
  • New Insurance Balance = Allocation - Adjustment - Write-Off - Transfer

3. Write-Off Calculation

Write-Off = Invoice Discount - Adjustment Amount

Validation Rules

  • Zero-Sum Allocation: The sum of all Allocation Distribution entries must be zero.
  • Balance Consistency: Total balance should match the sum of the patient and insurance balances.

Example Scenarios

1. Invoice Details Before Allocation

An example invoice includes products and associated financial details before any payment allocations.

Product Price Patient Due Insurance Due Copay Discount
Frame - 4U U200 $510.11 $586.63 $0.00 $0.00 0.00%
Lens - Essilor Accolade $279.00 $320.85 $0.00 $0.00 0.00%
Allowance & Copay -$200.00 -$200.00 $120.00 $0.00 0.00%

2. Batch Payment Allocation Processing

Once payments are received, the system processes allocations.

Invoice Claim Allocation Insurance Payment Adjustment Write-Off Transfer to Patient New Patient Balance New Insurance Balance
INV/2025/00091 V2020 -25.00 $-25.00 $0.00 $0.00 $0.00 0.00 0.00
INV/2025/00091 V2781 317.82 $120.00 $197.82 $0.00 $0.00 0.00 0.00
INV/2025/00091 (none) -200.00 $0.00 $0.00 $0.00 $0.00 0.00 0.00
INV/2025/00091 (none) -117.82 $0.00 $0.00 $0.00 $0.00 0.00 0.00

3. Updated Invoice After Allocation

After adjustments, the invoice reflects new balances and allocations.

Product Price Patient Due Insurance Due Copay Discount
Frame - 4U U200 $510.11 $586.63 $0.00 $-25.00 0.00%
Lens - Essilor Accolade $279.00 $320.85 $0.00 $120.00 0.00%
Allowance & Copay -$200.00 -$200.00 $120.00 $0.00 0.00%

Still need help? Contact Us Contact Us