Payments by Transaction Report Columns

The following table describes the columns in the Daily by Transaction Payments report:

Column Name	Description	Data Pulled From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Location Name	Charge Posting
Location SubGrp 1	Location Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Locations Master File
Location SubGrp 2	Location Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Locations Master File
Post Date	Post Date	Day transaction was posted
Proc Dt	Process date	Day transaction was posted
Ovr Proc Dt	Override Process Date	Transaction Detail
Bt Dt	Batch date	Batch Header
Bt Nbr	Batch Number	Batch Header
Bt Desc	Batch Description	Batch Header
Track Desc	Tracking Description	Transaction Detail
E/I/A/B	Encounter Account Invoice Number Budget	Transaction Detail
Src Type	Source Type	Transaction Detail
Name	Guarantor/Employer/ Patient Name	Depends on source type
Collection Agency	Collection Agency	Encounter Maintenance
Per Nbr	Person Number	Patient Information
Addr1	Address 1	Patient Information
Addr2	Address 2	Patient Information
City	City	Patient Information
State	State	Patient Information
Zip	Zip code	Patient Information
County	County	Patient Information
Sex	Sex at Birth	Patient Information
Birth Dt	Patient Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Insured Name	Insured Name	Insurance Maintenance
Pat Type	Patient Type	Encounter Maintenance
Billed Amt	Billed Amount	Charge Posting
Aprv Amt	Approved Amount	Transaction Detail
Tran Dt	Transaction Date	Transaction Detail
Tran Cd	Transaction Code	Transaction Detail
Pay Amt	Payment Amount	Transaction Detail
Reason Cd	Transaction Reason Code	Transaction Detail
Rsn Cd Desc	Reason Code Description	Reason Code Library
Payer Name	Payer Name	Payer associated with Payment
Fin Class	Financial Class	Payers Master File
Rendering	Encounter Rendering Provider	Encounter Maintenance
Provider SubGrp 1	Provider Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Provider SubGrp 2	Provider Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Addtl Prov	Additional Provider Note: Field name is from Practice Preferences > Charge Entry.	Charge Posting
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Referring	Encounter Referring Provider	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Fst Bill Dt	First Bill Date	Encounter Maintenance
Lst Bill Dt	Last Bill Date	Encounter Maintenance
FQHC Qual Enc	FQHC Qualifying Encounter Indicator	Encounter Maintenance > Claims
CCBHC Qual Enc	CCBHC Qualifying Encounter Indicator	Encounter Maintenance > Encounter Specifics
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Pat Prov UD 1 - 12	Patient Provider User Defined 1 - 12 Fields Note: Patient Provider names are from Practice Preferences > Providers.	Patient Information > Providers
Crt Dt	Create Date	Modification Information
Created By	Created By	Modification Information
Mod Dt	Last Modified Date	Modification Information
Modified By	Last Modified By	Modification Information
Homeless Status	Homeless Status	Patient Information
Migrant Worker Status	Migrant Worker Status	Patient Information
Language Barrier	Language Barrier	Patient Information
Primary Med Cov	Primary medical Coverage	Patient Information
Race	Race	Patient Information Note: Multiple entries are separated by commas.
Ethnicity	Ethnicity	Patient Information Note: Multiple entries are separated by commas.
Tribal Affiliation	Tribal Affiliation	Patient Information
Blood Quantum	Blood Quantum	Patient Information
Veteran Status	Veteran Status	Patient Information
School Based Hlth Care	School Based Health Care	Patient Information
Public Housing Primary	Public Housing Primary Care	Patient Information
Descendancy	Descendancy	Patient Information
IHS Eligibility Status	IHS Eligibility Status	Patient Information
Classification Beneficiary	Classification Beneficiary	Patient Information
Community Code	Community Code	Patient Information
Consent to Treat Ind	Consent to Treat Indicator	Patient Information
Consent to Treat Date	Consent to Treat Date	Patient Information
Enc Homeless Status	Encounter Homeless Status	Encounter Maintenance
Pat Age in Years	Patient Age in Years	Patient Information
Pat Age in Months	Patient Age in Months	Patient Information
Pat Age in Years (DOS)	Patient Age in Years on the Date of Service	Patient Information
Pat Age in Months (DOS)	Patient Age in Months on the Date of Service	Patient Information
Mrkt Plan Name	Marketing Plan Name	Encounter Maintenance
Mrkt Plan Type	Marketing Plan Type	Encounter Maintenance
Mrkt Desc	Marketing Plan Description	Encounter Maintenance
CC Vendor Processor	Credit Card Vendor Processor	Encounter Maintenance
CC Merchant ID	Credit Card Merchant ID	Encounter Maintenance
Refund to	Refund To	Payment Entry
Ref Addr Line 1	Refund Address Line 1	Payment Entry
Ref Addr Line 2	Refund Address Line 2	Payment Entry
Ref City	Refund City	Payment Entry
Ref State	Refund State	Payment Entry
Ref Zip	Refund Zip Code	Payment Entry
Vendor Matching UD1	Vendor Matching UD1	Payment Entry
Vendor Matching UD2	Vendor Matching UD2	Payment Entry
Vendor Matching UD3	Vendor Matching UD3	Payment Entry
Vendor Matching UD4	Vendor Matching UD4	Payment Entry
Vendor Matching UD5	Vendor Matching UD5	Payment Entry
Vendor Matching UD6	Vendor Matching UD6	Payment Entry
Vendor Matching UD7	Vendor Matching UD7	Payment Entry
Vendor Matching UD8	Vendor Matching UD8	Payment Entry
Vendor Matching UD9	Vendor Matching UD9	Payment Entry
Vendor Matching UD10	Vendor Matching UD10	Payment Entry
Claim/Resub #	Claim/Resubmission number	Encounter Maintenance
Batch Transaction Category	Batch Transaction Category Note: Field name is from Enterprise Preferences > General Tab.	Batch Maintenance
Race Category	Race Category	Race Category Mapping Master File Note: Multiple entries are separated by commas.
Ethnicity Category	Ethnicity Category	Ethnicity Category Mapping Master File Note: Multiple entries are separated by commas.
APC Payment	APC Payment Note: Automatic Payment Collections is available with InstaMed.	Displays Y for credit card payments processed by InstaMed on accounts that are enabled for APC.
Gateway ID	Gateway ID Note: Gateway ID is used with TSYS-Express.	Displays the Gateway ID used for credit card payments processed via TSYS-Express.
Outlet ID	Outlet ID The Outlet ID is the name of the outlet as identified in the Description column in Practice Preferences > Payment Processing on the InstaMed Configuration window.	Displays the name of the Outlet ID selected when processing a payment for InstaMed.
Cost Est ID	Unique ID assigned to an estimate	Estimate Patient Cost window
Cost Est Dt	Date on which the cost estimation was done	Estimate Patient Cost window
Cost Est Ins Resp	Estimated amount the insurer is responsible to pay	Estimate Patient Cost window
Cost Est Pat Resp	Estimated amount the patient is responsible to pay	Estimate Patient Cost window
Cost Est Total	Total estimated cost of a service.	Estimate Patient Cost window
Cost Est Pat Paid Amount	Amount the patient has paid	Estimate Patient Cost window

Filter 1

Use parameters to filter data on the report:

Post Date: Include payments posted within a date range.
Process Date: Include payments processed within a date range.
Transaction Date: Include payments with a transaction date within a date range.
Transaction Type: Include/exclude payments by type. Select Encounter, Invoice, Account and/or Budgets.
Unposted Transactions: Include/exclude unposted payment transactions. Select either Only or Exclude (default).
In Progress: Include/exclude payments on In Progress encounters. Select either Only, Exclude (default), or Include All.

Filter 2

Use columns to filter data on the report. Column filter options include the following:

Between
Equals
Not Equals
Greater Than
Less Than
Like

Additional Filters

Use additional filters to filter data on the report. Additional filters include the following:

Creator
Financial Classes
Location Subgrouping 1
Location Subgrouping 2
Locations
Marketing Plan Type
Patient Types
Payment Transaction Codes
Provider Subgrouping 1
Provider Subgrouping 2
Reason Code Subgrouping 1
Reason Code Subgrouping 2
Reason Codes
Referring Providers
Rendering Providers

Sorting

Use columns to sort and group data on the report. Column sorting options include the following:

Ascending
Descending
Group By
Page Break

Note: Columns that are not available for Group By or Page Break are indicated by 'n/a'.

Totals

Use columns to sub-total and total data on the report. Column total options include the following:

Sum
Average
Count
Totals

Note: Columns that are not available for totals are indicated by 'n/a'.

Payments by Transaction Report Columns

The following table describes the columns in the Daily by Transaction Payments report:

Column Name	Description	Data Pulled From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Location Name	Charge Posting
Location SubGrp 1	Location Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Locations Master File
Location SubGrp 2	Location Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Locations Master File
Post Date	Post Date	Day transaction was posted
Proc Dt	Process date	Day transaction was posted
Ovr Proc Dt	Override Process Date	Transaction Detail
Bt Dt	Batch date	Batch Header
Bt Nbr	Batch Number	Batch Header
Bt Desc	Batch Description	Batch Header
Track Desc	Tracking Description	Transaction Detail
E/I/A/B	Encounter Account Invoice Number Budget	Transaction Detail
Src Type	Source Type	Transaction Detail
Name	Guarantor/Employer/ Patient Name	Depends on source type
Collection Agency	Collection Agency	Encounter Maintenance
Per Nbr	Person Number	Patient Information
Addr1	Address 1	Patient Information
Addr2	Address 2	Patient Information
City	City	Patient Information
State	State	Patient Information
Zip	Zip code	Patient Information
County	County	Patient Information
Sex	Sex at Birth	Patient Information
Birth Dt	Patient Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Insured Name	Insured Name	Insurance Maintenance
Pat Type	Patient Type	Encounter Maintenance
Billed Amt	Billed Amount	Charge Posting
Aprv Amt	Approved Amount	Transaction Detail
Tran Dt	Transaction Date	Transaction Detail
Tran Cd	Transaction Code	Transaction Detail
Pay Amt	Payment Amount	Transaction Detail
Reason Cd	Transaction Reason Code	Transaction Detail
Rsn Cd Desc	Reason Code Description	Reason Code Library
Payer Name	Payer Name	Payer associated with Payment
Fin Class	Financial Class	Payers Master File
Rendering	Encounter Rendering Provider	Encounter Maintenance
Provider SubGrp 1	Provider Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Provider SubGrp 2	Provider Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Addtl Prov	Additional Provider Note: Field name is from Practice Preferences > Charge Entry.	Charge Posting
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Referring	Encounter Referring Provider	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Fst Bill Dt	First Bill Date	Encounter Maintenance
Lst Bill Dt	Last Bill Date	Encounter Maintenance
FQHC Qual Enc	FQHC Qualifying Encounter Indicator	Encounter Maintenance > Claims
CCBHC Qual Enc	CCBHC Qualifying Encounter Indicator	Encounter Maintenance > Encounter Specifics
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Pat Prov UD 1 - 12	Patient Provider User Defined 1 - 12 Fields Note: Patient Provider names are from Practice Preferences > Providers.	Patient Information > Providers
Crt Dt	Create Date	Modification Information
Created By	Created By	Modification Information
Mod Dt	Last Modified Date	Modification Information
Modified By	Last Modified By	Modification Information
Homeless Status	Homeless Status	Patient Information
Migrant Worker Status	Migrant Worker Status	Patient Information
Language Barrier	Language Barrier	Patient Information
Primary Med Cov	Primary medical Coverage	Patient Information
Race	Race	Patient Information Note: Multiple entries are separated by commas.
Ethnicity	Ethnicity	Patient Information Note: Multiple entries are separated by commas.
Tribal Affiliation	Tribal Affiliation	Patient Information
Blood Quantum	Blood Quantum	Patient Information
Veteran Status	Veteran Status	Patient Information
School Based Hlth Care	School Based Health Care	Patient Information
Public Housing Primary	Public Housing Primary Care	Patient Information
Descendancy	Descendancy	Patient Information
IHS Eligibility Status	IHS Eligibility Status	Patient Information
Classification Beneficiary	Classification Beneficiary	Patient Information
Community Code	Community Code	Patient Information
Consent to Treat Ind	Consent to Treat Indicator	Patient Information
Consent to Treat Date	Consent to Treat Date	Patient Information
Enc Homeless Status	Encounter Homeless Status	Encounter Maintenance
Pat Age in Years	Patient Age in Years	Patient Information
Pat Age in Months	Patient Age in Months	Patient Information
Pat Age in Years (DOS)	Patient Age in Years on the Date of Service	Patient Information
Pat Age in Months (DOS)	Patient Age in Months on the Date of Service	Patient Information
Mrkt Plan Name	Marketing Plan Name	Encounter Maintenance
Mrkt Plan Type	Marketing Plan Type	Encounter Maintenance
Mrkt Desc	Marketing Plan Description	Encounter Maintenance
CC Vendor Processor	Credit Card Vendor Processor	Encounter Maintenance
CC Merchant ID	Credit Card Merchant ID	Encounter Maintenance
Refund to	Refund To	Payment Entry
Ref Addr Line 1	Refund Address Line 1	Payment Entry
Ref Addr Line 2	Refund Address Line 2	Payment Entry
Ref City	Refund City	Payment Entry
Ref State	Refund State	Payment Entry
Ref Zip	Refund Zip Code	Payment Entry
Vendor Matching UD1	Vendor Matching UD1	Payment Entry
Vendor Matching UD2	Vendor Matching UD2	Payment Entry
Vendor Matching UD3	Vendor Matching UD3	Payment Entry
Vendor Matching UD4	Vendor Matching UD4	Payment Entry
Vendor Matching UD5	Vendor Matching UD5	Payment Entry
Vendor Matching UD6	Vendor Matching UD6	Payment Entry
Vendor Matching UD7	Vendor Matching UD7	Payment Entry
Vendor Matching UD8	Vendor Matching UD8	Payment Entry
Vendor Matching UD9	Vendor Matching UD9	Payment Entry
Vendor Matching UD10	Vendor Matching UD10	Payment Entry
Claim/Resub #	Claim/Resubmission number	Encounter Maintenance
Batch Transaction Category	Batch Transaction Category Note: Field name is from Enterprise Preferences > General Tab.	Batch Maintenance
Race Category	Race Category	Race Category Mapping Master File Note: Multiple entries are separated by commas.
Ethnicity Category	Ethnicity Category	Ethnicity Category Mapping Master File Note: Multiple entries are separated by commas.
APC Payment	APC Payment Note: Automatic Payment Collections is available with InstaMed.	Displays Y for credit card payments processed by InstaMed on accounts that are enabled for APC.
Gateway ID	Gateway ID Note: Gateway ID is used with TSYS-Express.	Displays the Gateway ID used for credit card payments processed via TSYS-Express.
Outlet ID	Outlet ID The Outlet ID is the name of the outlet as identified in the Description column in Practice Preferences > Payment Processing on the InstaMed Configuration window.	Displays the name of the Outlet ID selected when processing a payment for InstaMed.
Cost Est ID	Unique ID assigned to an estimate	Estimate Patient Cost window
Cost Est Dt	Date on which the cost estimation was done	Estimate Patient Cost window
Cost Est Ins Resp	Estimated amount the insurer is responsible to pay	Estimate Patient Cost window
Cost Est Pat Resp	Estimated amount the patient is responsible to pay	Estimate Patient Cost window
Cost Est Total	Total estimated cost of a service.	Estimate Patient Cost window
Cost Est Pat Paid Amount	Amount the patient has paid	Estimate Patient Cost window

Filter 1

Use parameters to filter data on the report:

Post Date: Include payments posted within a date range.
Process Date: Include payments processed within a date range.
Transaction Date: Include payments with a transaction date within a date range.
Transaction Type: Include/exclude payments by type. Select Encounter, Invoice, Account and/or Budgets.
Unposted Transactions: Include/exclude unposted payment transactions. Select either Only or Exclude (default).
In Progress: Include/exclude payments on In Progress encounters. Select either Only, Exclude (default), or Include All.

Filter 2

Use columns to filter data on the report. Column filter options include the following:

Between
Equals
Not Equals
Greater Than
Less Than
Like

Additional Filters

Use additional filters to filter data on the report. Additional filters include the following:

Creator
Financial Classes
Location Subgrouping 1
Location Subgrouping 2
Locations
Marketing Plan Type
Patient Types
Payment Transaction Codes
Provider Subgrouping 1
Provider Subgrouping 2
Reason Code Subgrouping 1
Reason Code Subgrouping 2
Reason Codes
Referring Providers
Rendering Providers

Sorting

Use columns to sort and group data on the report. Column sorting options include the following:

Ascending
Descending
Group By
Page Break

Note: Columns that are not available for Group By or Page Break are indicated by 'n/a'.

Totals

Use columns to sub-total and total data on the report. Column total options include the following:

Sum
Average
Count
Totals

Note: Columns that are not available for totals are indicated by 'n/a'.

Payments by Transaction Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Payments by Transaction Report Columns

Adjustments by Transaction Report Columns

Adjustments by Transaction Report Columns

Payments by Line Item Report Columns

Payments by Line Item Report Columns

Adjustments by Line Item Report Columns

Payments by Transaction Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Payments by Transaction Report Columns

Adjustments by Transaction Report Columns

Adjustments by Transaction Report Columns

Payments by Line Item Report Columns

Payments by Line Item Report Columns

Adjustments by Line Item Report Columns