Scroll

Ledger - Transactions Table and Columns

The Transactions Table is a list of all transactions associated to the selected incident, including charges, payments, claims, adjustments, and so on. It is located in the Transactions node of an Incident in the Ledger.

Above this table are the ChargesPaymentsOtherPrint and View Options menus. Each menu contains several difference functions. It is possible to configure MacPractice to display different types of transactions by using the Ledger Colors reference.

Column Descriptions
The Transaction Table is a series of columns that contain all of the financial information within the incident. Each column is described in the list below.

Columns can be dragged and dropped into any order desired. We'll list each column alphabetically. Not all columns will be used 

  • Accept: States "Yes" or "No" depending on if the Provider Accepts Assignment on a claim item. For other items, this column will be blank.
  • Audit ID: This is the User ID of the MacPractice user who entered the line item. A User's ID is defined in the References Ability > Users.
  • Balance: This represents the balance as of the placement of the line item. This may not match the Acct. Balance.
  • Claim Number: (New in Build 11.6.12+) A system-assigned number to each Claim. These end in E or P, and indicate whether the claim in question is an Electronic claim or a Paper Claim.
  • Code: The procedure code of an item.
  • Collection Transmittal Number: This column displays a Transmittal number that correlates to submitted Collections in the Collections Manager.
  • Credit: This is the amount of money subtracted from the account. Credit items will decrease the balance.
  • Description: The Procedure Description of the item.
  • Debit: This is the amount of money charged to the account. Debit items will inflate the balance.
  • Diagnosis 1: The first Diagnosis code listed in the New Charge Window.
  • Diagnosis 2: The second Diagnosis code listed in the New Charge Window.
  • Diagnosis 3: The third Diagnosis code listed in the New Charge Window.
  • Diagnosis 4: The fourth Diagnosis code listed in the New Charge Window.
  • Discount: If a discount is set in the Account tab, the amount of the discount appears in this column.
  • Emerg.: This states "Yes" or "No" if the Emergency box in the New Charge window has been checked.
  • Fee: This is the amount charged for the Fee alone.
  • Fee Tax: This is the amount charged for the tax associated with the Fee.
  • Form Amount: The total amount of all charges associated with a claim's line item.
  • Ins. Plan: This shows the Insurance Plan associated to the claim.
  • Ins. Holder: This shows the primary person who holds the insurance.
  • Insurance Portion: The amount of the charge associated to an insurance company.
  • Insurance Paid: The amount that an insurance company has paid.
  • In Collection: This will say "yes" or "no" depending on the collections status.
  • Is Lab: If Requires Lab is checked in the New Charge window, this column will say either "Yes" or "No".
  • Lab Fee: This is the amount charged for the Lab. (Canadian only)
  • Lab Tax: This is the amount charged for the tax associated with the Lab. (Canadian only)
  • Lab Cost: This is the Lab Cost as designated in the New Charge window.
  • Lab Place: The Place the lab was performed.
  • Open: The amount of money still owed for the item.
  • Original Fee: This is the base fee of the item before any added discounts or fees.
  • Payment Amount: This is the total amount of a payment regardless of what may or may not have been applied.
  • Patient Portion: The amount of the charge associated to the patient.
  • Patient Paid: The amount that a patient has paid.
  • Posted Date: The date the item was posted in the Ledger. This cannot be edited.
  • Provider: The Provider associated to an item.
  • Procedure Type: This is the Procedure Type set in the New Charge window.
  • Pri. Deductible: The amount pulling from the primary insurance.
  • POS: This pulls from the Place of Service field in the New Charge window.
  • Proc. Date: The date the item was performed. This can be edited in the original item (such as in the charge window for a procedure's date) and you may single click into this field to change the proc. date of an insurance claim. 
  • Quad: This pulls from the Area of Oral Cavity in the New Charge window.
  • Record #: This is the number assigned to the item chronologically in all of MacPractice.
  • Status: The status of a claim.
  • Schedule: The Fee Schedule associated to the item.
  • Surface: This pulls from the Surface field in the New Charge window.
  • Sec. Deductible: The amount pulling from the secondary insurance.
  • Thru Date: In MD, this will show the To Date from the New Charge window.
  • Time: This displays the Schedule Units entered in the New Charge window.
  • TOS: This pulls from the Type of Service field in the New Charge window.
  • Tooth: This pulls from the Tooth field in the New Charge window.
  • Unapplied: This shows how much of a payment is not applied.
  • Units: The number of Units in the New Charge window.
  • Write-Off: Any applicable Write-Off appears here.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments