Batch Allocations Report
The Batch Allocations Report lists patients, item numbers, payments, allocations, and adjustments for each finalised batch. Use it to analyse how funds were applied across batches in a given period.
- Navigate to Accounts > Batch Allocations Report.
- The Batch Allocations Report selector opens. Configure the filters using the sections below, then click Go.
- Filter the report to batches created within a specific date range. Set the From and To dates manually, or use the quick selectors.
Use the arrow buttons beside each preset to step backwards or forwards. To control the unit applied by the arrows, select Day, Week, Month, Year, or User Defined.
- Select the billing location a batch was created for. Leave set to All to include batches from every location.
- The Grouping section controls how the report is structured. Select a primary grouping in the top drop-down and a secondary grouping in the second drop-down.
- Batches then Payments - lists results per batch, with each batch broken down by the payments received against it.
- Payments then batches - lists results per payment, with each payment broken down by the batches it was allocated to.
Group by Batches then Payments when reconciling a single batch end-to-end. Group by Payments then Batches when tracing how a single fund payment was distributed across multiple batches.
- Limit the report to a single batch or payment.
- Tick Limit to Batch ID and enter the batch ID to return only that batch.
- Tick Limit to Payment ID and enter the payment ID to return only that payment.
The Limit to Batch ID and Limit to Payment ID fields are unavailable until the matching checkbox is ticked.
Run the report
- Set the Batch Creation Date Range.
- Select a Batch Location, or leave set to All.
- Choose the primary and secondary Grouping.
- Optionally, tick Limit to Batch ID or Limit to Payment ID and enter the relevant ID.
- Click Go.
The report opens in a preview window. Each batch (or payment, depending on grouping) shows the invoice number, patient, item number, service date, item amount, item balance, and allocated amount, with subtotals at the batch and payment level.