Understanding the Financial reports

Aging

• Aging - An aged balance (0-30, 31-60, 61-90, 91-120, and >120 days).

Applied Date.Date (ISO)

• Date - The date when a payment (or any portion thereof), a credit adjustment (or any portion thereof), or an unapplied credit was applied to a charge. For a procedure or charge adjustment, the Applied Date is the Transaction Date. Uses the international date format (yyyy-mm-dd).

Applied Date.Date (YMD)

• Year - The year when a payment (or any portion thereof), a credit adjustment (or any portion thereof), or an unapplied credit was applied to a charge. For a procedure or charge adjustment, the Applied Date is the Transaction Date. Uses the four-digit identifier (yyyy).

• Month - The month when a payment (or any portion thereof), a credit adjustment (or any portion thereof), or an unapplied credit was applied to a charge. For a procedure or charge adjustment, the Applied Date is the Transaction Date. Uses an abbreviated name (Jan, Feb, Mar, and so forth).

• Day - The day of the month when a payment (or any portion thereof), a credit adjustment (or any portion thereof), or an unapplied credit was applied to a charge. For a procedure or charge adjustment, the Applied Date is the Transaction Date.

Applied Date.Date (local)

• Date - The date when a payment (or any portion thereof), a credit adjustment (or any portion thereof), or an unapplied credit was applied to a charge. For a procedure or charge adjustment, the Applied Date is the Transaction Date. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

Description

• Category - The category (type of transaction) that a ledger entry pertains to.

• Subcategory - The subcategory that a ledger entry pertains to.

• Description - The description of a ledger entry.

• Primary Tag - For a payment with restricted tagging, the mandatory tag that is attached to that payment. For a payment with unrestricted tagging, the first tag that is attached to that payment.

• Secondary Tags - A comma-delimited list of all the optional tags that are attached to a payment with restricted tagging. A payment with unrestricted tagging does not have secondary tags.

First Visit Date.Date (ISO)

• Date - The date of a patient's first visit (based on the first appointment or ledger entry, whichever is oldest). Uses the international date format (yyyy-mm-dd).

First Visit Date.Date (YMD)

• Year - The year of a patient's first visit (based on the first appointment or ledger entry, whichever is oldest). Uses the four-digit identifier (yyyy).

• Month - The month of a patient's first visit (based on the first appointment or ledger entry, whichever is oldest). Uses an abbreviated name (Jan, Feb, Mar, and so forth).

• Day - The day of the month of a patient's first visit (based on the first appointment or ledger entry, whichever is oldest).

First Visit Date.Date (local)

• Date - The date of a patient's first visit (based on the first appointment or ledger entry, whichever is oldest). Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

Insurance Claim

• Claim Sent Date - The date an insurance claim was sent. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Claim Status Date - The date of a status change of an insurance claim. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Claim Status - The status of an insurance claim.

• Claim Carrier - The name of an insurance carrier.

• Claim Payer ID - The payer ID of an insurance carrier.

• Billing Prov TIN - The TIN of a billing provider for an insurance claim.

• Billing Provider - The name of a billing provider (which can be a person or a location) for an insurance claim. Uses a "Last name, First name" or a "Location name" format.

• Billing Prov NPI - The NPI of a billing provider for an insurance claim.

• Claim ID - The unique ID of an insurance claim.

• Claim Status Note - The text of a status note of an insurance claim.

• Claim Status Source - The source of a status change of an insurance claim (such as a payer or a user).

• Coverage Type - The type of coverage for an insurance claim (such as primary or secondary).

• Rendering Prov NPI - The NPI of the rendering provider for an insurance claim.

• Rendering Provider - The name of a rendering provider for an insurance claim. Uses a "Last name, First name" format.

• Claim Plan - The name of an insurance plan.

• Claim Plan Address - The address associated with an insurance plan.

Location

• Time Zone - The time zone of a location in your organization.

• Location - The name of a location in your organization. Only the locations that you have access to are available.

• Website - The website address of a location in your organization.

• Service Location - The name of a location in your organization where a procedure is performed. Only the locations that you have access to are available.

• Transaction Location - The name of a location in your organization where a transaction is entered. Only the locations that you have access to are available.

Measures

• Active w/ Recare - The number of distinct patients on the report who are active and have recare attached to their records.

• Amount - The amount of a ledger entry.

• Applied Credit Adjustments - The amount of a credit adjustment that is applied to a procedure.

• Applied Payments - The amount of a payment that is applied to a procedure.

• Average Charge - The average amount of the Charges.

• Billed to Insurance - The amount that is billed to insurance for a ledger entry that is attached to a claim with any status other than Unsent.

• Charge Adjustments - The amount of a charge adjustment.

• Charges - The amount of a positive (+) ledger entry (a procedure or a charge adjustment).

• Collection - The amount of a ledger entry that is designated as a collection transaction according to its Category and Subcategory.

• Contracted Fee - The contracted fee between a provider and a patient's primary insurance carrier. The service location of the procedure determines the plan's fee schedule for the contracted fee. The contracted fee does not depend on whether or not a claim has been created, but the report does verify that the patient is insured and the billing provider is contracted with the carrier.

• Count - The number of items for the corresponding row and column on the report.

• Credits - The amount of a negative (-) ledger entry (a payment or a credit adjustment).

• Patient Count - The number of distinct patients on the report.

• Perio Patients - The number of distinct patients on the report who have a perio exam.

• Procedure Charges - The amount of a ledger entry for a procedure.

• Procedure Count - The number of distinct procedures on the report.

• Production - The amount of a ledger entry that is designated as a production transaction according to its Category and Subcategory.

• Unapplied Credit Adjustments - The amount of a credit adjustment that is not applied to a procedure.

• Unapplied Payments - The amount of a payment that is not applied to a procedure (such as an overpayment, a pre-payment, or a payment that has been entered before the corresponding completed procedure has been posted).

Miscellaneous

• On First Visit - If a patient has a first visit date on a given date.

Modified Date (ISO)

• Modified Date - The date when a transaction was created initially or modified. Uses the international date format (yyyy-mm-dd).

Modified Date (YMD)

• Modified Year - The year when a transaction was created initially or modified. Uses the four-digit identifier (yyyy).

• Modified Month - The month when a transaction was created initially or modified. Uses an abbreviated name (Jan, Feb, Mar, and so forth).

• Modified Day - The day of the month when a transaction was created initially or modified.

Modified Date (local)

• Modified Date - The date when a transaction was created initially or modified. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

Organization

• Organization Type - Indicates whether the organization is real or for testing purposes only.

• Customer ID - Your organization's customer ID (which can be used to log in).

• Organization Name - The name of your organization (or the organization log-in ID).

Organization Recare

• Recare Type - The recare type.

Patient

• Chart Number - The chart number of a patient.

• Birth Date - The birth date of a patient.

• Discount Plan - The discount plan assigned to a patient.

• Gender - The gender of a patient.

• State - The state of a patient.

• City - The city of a patient.

• Postal Code - The ZIP Code/postal code of a patient.

• External ID - The external ID of a patient.

• Patient Status - The status of a patient (such as active or inactive).

• Preferred Location - The preferred location for a patient.

• Primary Prov - The short name of a patient's primary provider (the ID that appears throughout Ascend Academic to identify him or her).

• Primary Provider - The name of a patient's primary provider. Uses a "Last name, First name" format.

• Patient - The name of a patient. Uses a "Last name, First name" format.

Patient Primary Ins

• Pat. Prim. Plan - The name of an insurance plan.

• Pat. Prim. Carrier - The name of an insurance carrier.

• Prim. Subscriber ID - The ID of the subscriber of an insurance plan.

• Pat. Prim. Fee Schedule - The fee schedule associated with an insurance plan.

Patient Secondary Ins Plan

• Pat. Sec. Plan - The name of an insurance plan.

• Pat. Sec. Carrier - The name of an insurance carrier.

• Sec. Subscriber ID - The ID of the subscriber of an insurance plan.

• Pat. Sec. Fee Schedule - The fee schedule associated with an insurance plan.

Payment Info

• Bank - The bank account number associated with a transaction.

• Check # - The check number associated with a transaction.

• Payment Reference Info - The bank account and check number associated with a transaction. The two numbers are separated by a slash (/).

• Reference # - The reference number associated with a transaction.

Payment Source

• Source of Payment - The source of a payment (such as self-pay or medicaid).

Primary Guarantor

• Primary Guarantor - The name of a patient's primary guarantor. Uses a "Last name, First name" format.

Procedure

• Proc Alias - The alias procedure code of a procedure.

• Proc Category - The Procedure Code Category of a procedure.

• Proc Code - The procedure code of a procedure.

• Proc Desc - The abbreviated description of a procedure.

• Proc Description - The description of a procedure.

Procedure Treatment Area

• Proc Treatment Area - The treatment area (such as tooth or arch) of a procedure.

Production or Collection

• Production or Collection - Indicates whether a ledger entry is designated as a production transaction or as a collection transaction, according to its Category and Subcategory.

Provider

• Specialty - The specialty of a provider.

• Prov - The short name of a provider (the ID that appears throughout Ascend Academic to identify him or her).

• Provider - The name of a provider. Uses a "Last name, First name" format.

Referred By

• Referred By - The name of a patient or non-patient source that referred a given patient.

Referred By Geo

• Referrer State - The state of a referral source.

• Referrer City - The city of a referral source.

• Referrer Postal Code - The ZIP Code/postal code of a referral source.

Referred By.Specialty

• Referrer Specialty - The specialty of a referral source, if applicable (such as endodontist or general practice).

Referred By.Type

• Referral Type - The type of referral (such as marketing or professional).

Revision History

• Revision History - One of the following:

  • Current ? Either the latest version of a modified transaction or the original transaction (if the transaction has never been modified). A deleted transaction does not have a current version. Only the current transaction is shown on the ledger if you are using the normal, simplified view.

  • Obsolete ? A revised transaction that was either deleted or modified and is no longer the current version. A transaction cancellation is always an obsolete transaction. An obsolete transaction can be shown on the ledger only if you are viewing transaction revisions.

Revision Order

• Revision Order - The order in which original, cancellation, and revised transactions were posted as part of a transaction's revision history. An unchanged transaction is always the original and the current version. The numbering starts at 1 with the original version. Then, if the transaction was modified or deleted, the number increases until either the current version is reached (for a modified transaction) or the cancellation transaction is reached (for a deleted transaction).

Revision Type

• Revision Type - One of the following:

  • Original ? The original, unchanged transaction.

  • Revision ? A revised transaction. A revision pertains to either the current version or an obsolete version of a transaction (if the transaction was modified multiple times). A modified transaction may have multiple revisions. A deleted transaction has revisions only if the transaction was modified and then deleted.

  • Cancellation ? A reversing transaction. A cancellation is posted automatically when a transaction is modified or deleted.

Service Date.Date (ISO)

• Date - The date of service of a procedure or charge adjustment (see Transaction Date). A credit adjustment or payment (or any portion thereof) uses the date of service of the charge that the credit or payment amount was applied to. Uses the international date format (yyyy-mm-dd).

Service Date.Date (YMD)

• Year - The year of the date of service of a procedure or charge adjustment (see Transaction Date). A credit adjustment or payment (or any portion thereof) uses the date of service of the charge that the credit or payment amount was applied to. Uses the four-digit identifier (yyyy).

• Month - The month of the date of service of a procedure or charge adjustment (see Transaction Date). A credit adjustment or payment (or any portion thereof) uses the date of service of the charge that the credit or payment amount was applied to. Uses an abbreviated name (Jan, Feb, Mar, and so forth).

• Day - The day of the month of the date of service of a procedure or charge adjustment (see Transaction Date). A credit adjustment or payment (or any portion thereof) uses the date of service of the charge that the credit or payment amount was applied to.

Service Date.Date (local)

• Date - The date of service of a procedure or charge adjustment (see Transaction Date). A credit adjustment or payment (or any portion thereof) uses the date of service of the charge that the credit or payment amount was applied to. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

Transaction Date.Date (ISO)

• Date - The date entered when posting or modifying a transaction. Uses the international date format (yyyy-mm-dd).

Transaction Date.Date (YMD)

• Year - The year of the date entered when posting or modifying a transaction. Uses the four-digit identifier (yyyy).

• Month - The month of the date entered when posting or modifying a transaction. Uses an abbreviated name (Jan, Feb, Mar, and so forth).

• Day - The day of the month of the date entered when posting or modifying a transaction.

Transaction Date.Date (local)

• Date - The date entered when posting or modifying a transaction. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

IsApplied

• Is Applied - If the amount has been applied to a charge.

Fee Schedule

• FeeScheduleName - The name of a fee schedule.

• StartDate - The effective date of a fee schedule.

• EndDate - The expiration date of a fee schedule.

Procedure

• Fee - A procedure's default fee.

• Procedure Category - The procedure code category of a procedure.

• Description - A procedure's description.

• Abbreviated Description - A procedure's abbreviated description.

• Code - A procedure's code.

• Proc Alias - The alias for a procedure code.

• Active - A procedure's code status (active or inactive).

• Bill To Insurance - Whether a procedure code is billable to insurance.

Organization

• CustomerID - Your organization's customer ID (which can be used to log in).

• Organization - The name of your organization (or the organization log-in ID).

Ledger

• Amount - The amount of a ledger entry.

• Billed to Insurance - The amount that is billed to insurance for a ledger entry that is attached to a claim with any status other than Unsent.

• Category - The category (type of transaction) that a ledger entry pertains to.

• Subcategory - The subcategory that a ledger entry pertains to.

• Description - The description of a ledger entry.

• Note - The note of a ledger entry.

• Transaction Date - The date entered when posting or modifying a transaction. Uses the the following format: the abbreviated day of the week (such as Mon), the abbreviated name of the month (such as Jun), the day of the month (two digits), the time (hh:mm:ss) and time zone (such as CDT), and then the year (four digits).

• Applied Date - The date when a payment, credit adjustment (or any portion thereof), or unapplied credit was applied to a charge. For a procedure or charge adjustment, this date is the Transaction Date. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Modified Date - The date when a transaction was created initially or modified. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Procedure - The description of a procedure.

• Proc - The abbreviated description of a procedure.

• Code - The procedure code of a procedure.

• Proc Alias - The alias for a procedure code.

• Provider - The name of a provider. Uses a "Last name, First name" format.

• Prov - The short name of a provider (the ID that appears throughout Ascend Academic to identify him or her).

• Contracted Fee - The contracted fee between a provider and a patient's primary insurance carrier. The service location of the procedure determines the plan's fee schedule for the contracted fee. The contracted fee does not depend on whether or not a claim has been created, but the report does verify that the patient is insured and the billing provider is contracted with the carrier.

• Primary Tag - For a payment with restricted tagging, the mandatory tag that is attached to that payment. For a payment with unrestricted tagging, the first tag that is attached to that payment.

• Secondary Tags - A comma-delimited list of all the optional tags that are attached to a payment with restricted tagging. A payment with unrestricted tagging does not have secondary tags.

• Revision Order

  • Revision Order - The order in which original, cancellation, and revised transactions were posted as part of a transaction's revision history. An unchanged transaction is always the original and the current version. The numbering starts at 1 with the original version. Then, if the transaction was modified or deleted, the number increases until either the current version is reached (for a modified transaction) or the cancellation transaction is reached (for a deleted transaction).

• Revision History

  • Revision History - One of the following:

    • Current ? Either the latest version of a modified transaction or the original transaction (if the transaction has never been modified). A deleted transaction does not have a current version. Only the current transaction is shown on the ledger if you are using the normal, simplified view.

    • Obsolete ? A revised transaction that was either deleted or modified and is no longer the current version. A transaction cancellation is always an obsolete transaction. An obsolete transaction can be shown on the ledger only if you are viewing transaction revisions.

• Revision Type

  • Revision Type - One of the following:

    • Original ? The original, unchanged transaction.

    • Revision ? A revised transaction. A revision pertains to either the current version or an obsolete version of a transaction (if the transaction was modified multiple times). A modified transaction may have multiple revisions. A deleted transaction has revisions only if the transaction was modified and then deleted.

    • Cancellation ? A reversing transaction. A cancellation is posted automatically when a transaction is modified or deleted.

Organization

• Customer ID - Your organization's customer ID (which can be used to log in).

• Organization Name - The name of your organization (or the organization log-in ID).

Location

• Location - The name of a location in your organization. Only the locations that you have access to are available.

Patient

• Patient - The name of a patient. Uses a "Last name, First name" format.

• Status - The status of a patient (such as active or inactive).

• Email - The email address of a patient's primary contact person.

• Phone - The first phone number listed for the primary contact person for a patient.

• Address - The address of the primary contact person for a patient.

• Time Zone -The time zone where the primary contact person for a patient lives.

• First Visit - The date of a patient's first visit. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Last Visit - The date of a patient's most recent visit. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Next Appointment Date - The date of a patient's next appointment. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• First Name - The first name of a patient.

• Last Name - The last name of a patient.

• Middle Name - The middle name of a patient.

• Preferred Name - The preferred name or nickname of a patient.

• Gender - The gender of a patient.

• Date of Birth - The date of birth of a patient. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Address Line 1 - The street address of a patient's primary contact person.

• Address Line 2 - The second line of the street address of a patient's primary contact person.

• City - The city of a patient's primary contact person.

• State - The state of a patient's primary contact person.

• ZIP Code - The ZIP Code/postal code of a patient's primary contact person.

• Patient Count - The number of patients.

• Chart Number - The chart number of a patient.

• Remaining Benefits Primary - The benefits that remain on a patient's primary insurance plan.

• Remaining Benefits Primary Ortho - The ortho benefits that remain on a patient's primary insurance plan.

• Remaining Benefits Secondary - The benefits that remain on a patient's secondary insurance plan.

• Remaining Benefits Secondary Ortho - The ortho benefits that remain on a patient's secondary insurance plan.

• Renewal Month Primary - The renewal month for a patient's primary insurance plan.

• Renewal Month Secondary - The renewal month for a patient's secondary insurance plan.

• Discount Plan - The discount plan assigned to a patient.

• Primary Prov - The short name of a patient's primary provider (the ID that appears throughout Ascend Academic to identify him or her).

• Primary Provider - The name of a patient's primary provider. Uses a "Last name, First name" format.

• Preferred Location - The preferred location for a patient.

Primary Guarantor

• Primary Guarantor - The name of a patient's primary guarantor. Uses a "Last name, First name" format.

• Email - The email address of a patient's primary guarantor.

• Phone - The primary phone number of a patient's primary guarantor.

• Address - The address of a patient's primary guarantor.

• First Name - The first name of a patient's primary guarantor.

• Last Name - The last name of a patient's primary guarantor.

• Middle Name - The middle name of a patient's primary guarantor.

• Preferred Name - The preferred name or nickname of a patient's primary guarantor.

• Gender - The gender of a patient's primary guarantor.

• Date Of Birth - The birth date of a patient's primary guarantor.

• Address Line 1 - The street address of a patient's primary guarantor.

• Address Line 2 - The second line of the street address of a patient's primary guarantor.

• City - The city of a patient's primary guarantor.

• State - The state of a patient's primary guarantor.

• ZIP Code - The ZIP Code/postal code of a patient's primary guarantor.

Primary Contact

• Primary Contact - The name of a patient's primary contact. Uses a "Last name, First name" format.

• Email - The email address of a patient's primary contact.

• Phone - The primary phone number of a patient's primary contact.

• Address - The address of a patient's primary contact.

• First Name - The first name of a patient's primary contact.

• Last Name - The last name of a patient's primary contact.

• Middle Name - The middle name of a patient's primary contact.

• Preferred Name - The preferred name or nickname of a patient's primary contact.

• Gender - The gender of a patient's primary contact.

• Date Of Birth - The birth date of a patient's primary contact.

• Address Line 1 - The street address of a patient's primary contact.

• Address Line 2 - The second line of the street address of a patient's primary contact.

• City - The city of a patient's primary contact.

• State - The state of a patient's primary contact.

• ZIP Code - The ZIP Code/postal code of a patient's primary contact.

Insurance Claim

• Claim Carrier - The name of an insurance carrier.

• Claim Plan - The name of an insurance plan.

• Claim Payer ID - The payer ID of an insurance carrier.

• Claim Status - The status of an insurance claim.

• Claim Carrier Fax - The fax number of an insurance carrier.

• Claim Carrier Phone - The phone number of the contact person for an insurance carrier.

• Claim Carrier Ext - The phone extension of the contact person for an insurance carrier.

• Claim Carrier URL - The website address of an insurance carrier.

• Claim Sent Date - The date an insurance claim was sent. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Claim ID - The unique ID of an insurance claim.

• Coverage Type - The type of coverage for an insurance claim (such as primary or secondary).

• Last Status Note - The text of the most recent claim status note of an insurance claim.

• Last Status Date - The date of the most recent status change of an insurance claim. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

• Claim Status Source - The source of the most recent claim status change of an insurance claim (such as a payer or a user).

• Billing Provider - The name of a billing provider (which can be a person or a location) for an insurance claim. Uses a "Last name, First name" or a "Location name" format.

• Billing Prov TIN - The TIN of a billing provider for an insurance claim.

• Billing Prov NPI - The NPI of a billing provider for an insurance claim.

• Rendering Provider - The name of a rendering provider for an insurance claim. Uses a "Last name, First name" format.

• Rendering Prov NPI - The NPI of the rendering provider for an insurance claim.

Organization Recare

• Recare Type - The recare type.

• Recare Description - The description of a recare type.

• Recare Interval - The interval of a recare type.

Referred By

• Referred By - The name of a patient or non-patient source that referred a given patient.

• Referral Type - The type of referral (such as marketing or professional).

• Specialty - The specialty of a referral source, if applicable (such as endodontist or general practice).

• Address - The address of a referral source.

• Phone - The first phone number listed for a referral source.

• Email - The email address of a referral source.

• Address Line 1 - The street address of a referral source.

• Address Line 2 - The second line of the street address of a referral source.

• City - The city of a referral source.

• State - The state of a referral source.

• ZIP Code - The ZIP Code/postal code of a referral source.

Patient Primary Ins Plan

• Pat. Prim. Fee Schedule - The fee schedule associated with an insurance plan.

• Pat. Prim. Plan - The name of an insurance plan.

• Pat. Prim. Carrier - The name of an insurance carrier.

• Prim. Subscriber ID - The ID of the subscriber of an insurance plan.

Patient Secondary Ins Plan

• Pat. Sec. Plan - The name of an insurance plan.

• Pat. Sec. Carrier - The name of an insurance carrier.

• Sec. Subscriber ID - The ID of the subscriber of an insurance plan.

• Pat. Sec. Fee Schedule - The fee schedule associated with an insurance plan.