UniformSoftware main content

Medical Billing Format

Template#: c5074

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
453 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Medical Billing Format

Detail

This form is suitable for general hospitals, pharmacies, clinics, and home health agencies. It shows the amount of expenses for medical services or treatment.

On the top of the spreadsheet, you'll first notice there is a logo image showing "UniformSoftware", which is a placeholder for your own logo image. Near the logo image is your business information.

Related templates:

This form is intended to be as general as possible. In the "Patient" section, you'll find fields for Hospital No., Name, Address, Phone, Email, Patient Age, Consultant, Payment Mode, Bed No., Admission Date, and Discharge Date.

The detail section includes 5 columns: #, PARTICULARS, QTY, RATE, and AMOUNT.

At the bottom of the form, there is one tax. Another custom field, Med Claim, is also added. The "Total" is calculated with a formula like this:

subtotal + tax - Med Claim

Format and Specification

Template#c5074
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns5
Lines20
Line Height (Points)15.75
Print Area$D$2:$K$54
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree