Overview of Billing Batch Processing Log

1
Overview of Billing Batch Processing Log

• Layout and definition
• Frequently asked questions

2
Billing Batch Processing Log
Section 1
Section 2
Section 3

• We will be looking at 3 major areas of the log,
  beginning with the left side of the log.

3
Billing Log - Section 1
The month and day here are the Transaction Dates,
or the date that the batch was processed. Files
for a transaction date will contain charges for
the previous business day, as well as any charges
from previous days that are ready to bill.
This TSO email confirms that the batch file was
successfully transmitted to Radar.
This email is sent at 305 to confirm initial
processing of the billing file.
Billing file named hradbill.mv. with the date
and time as the extension. Here, the Jan 01 file
sent at 1334 has the extension 01011334
Here, there are two times because the batch was
not processed on the first attempt. It was sent a
second time, and a second email receipt was
receved.
4
Billing Log - Section 2
This is the number of lines contaioned in the
batch file sent to Radar. This is not a count of
the number of charges sent.
Did we receive a paper UCX Report from Charge
Control confirming final batch processing?
If the batch file was resent, did we receive a
paper UCX report copy confirming final processing?
If the Paper UCX copy was not received, did we
need to resend the batch file?
5
Billing Log Section 3
Total charges processed (from UCX report)
Total charges processed (from UCX report).
Includes credits and debits.
Total charges processed on this transaction date
(from UCX report). May include previous
resubmitted batch files.
Total credits processed (from UCX report)
Include comments for any unusual occurrences, or
to list which files were processed if there were
multiple batches on one transaction day.
Contains hyperlink that will take you to the
charge detail for that day.
This total may not match the Total for This
Transaction Day if more than one batch file is
processed.
6
Frequently Asked Questions

• Q. Why do the charge count and dollar amounts
  on the TSO emails not match the totals found on
  the UCX reports (actual charges processed)?
• The TSO emails use the batch file footer totals,
  and these totals do not accurately reflect the
  charges actually transmitted.
• The batch footer is a simple sum of the charge
  amount field.
• It does not account for credits or charges with a
  quantity greater than 1.

Line item count
Sum of dollar amount field in batch file
Line item count
Sum of dollar amount field in batch file
7
Frequently Asked Questions

• Is it possible to include a column in the billing
  log with the actual billed charge count and
  charge amount sent in the batch file out of
  IDXRad?
• Yes, but this is a manual process, since there is
  no available report in IDXRad to do this.
• To get these totals, the user must
• Dump the batch file into Excel
• Separate the data lines into distinct data fields
• Multiply the charge amount by the quantity field
• Subtract the credits
• Sum the quantity and charge amount columns.
• It may be possible to write a query to produce
  these same results, but that has not yet been
  researched.