Account Pull Fields

Owned by Dylan Nigh
Apr 27, 2023
4 min read

All non-financially related pull fields listed below (name, contact info, demographics, employer info) will pull from wherever the statements are directed to go, as specified in the Patients Ability > Account tab > Where To Send Statements. All pull fields that represent a monetary amount do not include a dollar symbol ($) - this will need to be manually added to the left side of the pull field.

The following pull fields will pull from either the Primary or Secondary tab, depending on which is selected to receive statements in the Account tab. For this document the term Guarantor is used to refer to the person selected to receive statements. If a specific field is not noted, the name of the pull field is the same as the name of the field in the Primary or Secondary tab.

  • Name: Guarantor's full name (first name, middle initial with a period, and last name)

  • Prefix: Guarantor's prefix

  • Suffix: Guarantor's suffix

  • Last Name: Guarantor's last name

  • First Name: Guarantor's first name

  • Middle Name: Guarantor's middle name

  • Street Address: Guarantor's street address

  • Suite: Guarantor's suite

  • City: Guarantor's city

  • State: Guarantor's state

  • Zip Code: Guarantor's zip code

  • Home Phone: Guarantor's phone number associated with the Home phone pop-up button as entered in one of the phone fields

  • Work Phone: Guarantor's phone number associated with the Work phone pop-up button as entered in one of the phone fields

  • Other Phone: Guarantor's phone number associated with the Other phone pop-up button as entered in one of the phone fields

  • Mobile Phone: Guarantor's phone number associated with the Mobile phone pop-up button as entered in one of the phone fields

  • Date of Birth: Guarantor's DOB as entered in the Birth Date field. It will be formatted based on the MacPractice Preference > Notes >Format Date As.

  • SSN: Guarantor's social security number

The Employer pull fields pull from the Employer table on the Guarantor's record. 

  • Employer Name: Employer's name

  • Employer Address: Employer's street address

  • Employer Suite: Employer's suite

  • Employer City: Employer's city

  • Employer State: Employer's state

  • Employer Zip Code: Employer's zip code

The Account Balance pull fields will pull the balance for all patients on the account, not only the patient associated with the note. For example, a family account with two children, one of whom has a balance of $20.00 and the other $60.00, will pull an Account Balance Total of $60.00, regardless of the patient the note was created for.

  • Account Balance Current: Account balance that has been outstanding between 0-30 days

  • Account Balance 30 Days: Account balance that has been outstanding between 31-60 days

  • Account Balance 60 Days: Account balance that has been outstanding between 61-90 days

  • Account Balance 90 Days: Account balance that has been outstanding between 91-120 days

  • Account Balance 120 Days: Account balance that has been outstanding between 121-150 days

  • Account Balance 120 Plus Days: Account balance that has been outstanding more than 120 days (121 days or longer)

  • Account Balance 150 Plus Days: Account balance that has been outstanding more than 150 days (151 days or longer)

  • Account Balance Total: Account balance, regardless of aging

  • Account Balance Total with Credit: Total account balance regardless of aging, minus the total unapplied amount posted to the account.
    For example, if the total account balance is $100.00 and total unapplied balance is $25.00, the amount displayed in the note will be $75.00.

  • Account Balance Patient Portion: Total patient portion balance on the account, regardless of aging

  • Account Balance Insurance Portion: Total insurance portion balance on the account, regardless of aging

  • Account Balance Days Overdue: Age of the oldest balance on the account

  • Last Insurance Payment Amount: Amount of the last insurance payment that was posted to the account (even if the payment remains unapplied)

  • Last Insurance Payment Date: Posted date of the last insurance payment made to the account

The Last Account Payment pull fields will pull information for either the most recent patient payment or negative adjustment. Insurance payments are not account-level transactions, as they are posted to a specific patient's claim and are excluded from this pull field's data.

  • Last Account Payment Amount (w/ Adj): Amount of the last credit that was posted to the account. This could either be a negative adjustment or a patient payment.

  • Last Account Payment Date (w/ Adj): Date that the last credit pulled in from the above pull field was posted to the account.

  • Last Account Payment Amount (No Adj): Amount of the last patient payment that was posted the the account.

  • Last Account Payment Date (No Adj): Date that the last patient payment pulled in from the above pull field was posted to the account.

  • Accounting Alert 1-8: These will pull up to eight alerts in the order they were added in the Patients Ability > Account tab > Accounting Alert.

  • Financial Status: Account's Financial Status (as listed in the Account tab)

  • Percent Discount: Percentage discount as it is entered in the Percent Discount (%) field on the Statement Information tab

  • Installment Amount: Installment amount entered in the Installment Amount field

  • Installment or Balance Amount: This will pull the account balance or the installment amount, whichever is less. If the installment amount is less than the account balance, the installment amount will be displayed. The balance will also account for any unapplied amount on the account - if the total account balance is $175, the installment amount is $150, but the unapplied balance is $90, $85 will be pulled in to the note representing the balance, not the $150 installment amount.

  • Previous Account Number: Account's previous ID number, as entered in the Previous Account field.

The balance fields will pull the balance for the selected patient only; other patients' balances on the account will not be included.

  • Balance Current: Total balance that has been outstanding 0-30 days

  • Balance 30 Days: Total balance that has been outstanding 31-60 days

  • Balance 60 Days: Total balance that has been outstanding 61-90 days

  • Balance 90 Days: Total balance that has been outstanding 91-120 days

  • Balance 120 Days: Total balance that has been outstanding 121-150 days

  • Balance 120 Plus Days: Total balance that has been outstanding longer than 120 days (121 days or longer)

  • Balance 150 Plus days: Total balance that has been outstanding longer than 150 days (151 days or longer)

  • Balance Total: Total balance, regardless of aging