GL Account Mapping to HOSPITAL_CHARGE_ADMIN
Rick Eggleston (Unlicensed)
Jeff Duke
GL Account Mapping to HOSPITAL_CHARGE_ADMIN
HOSPITAL_CHARGE_ADMIN is the database table that contains all financial transactions, for all hospital accounts. The following table contains the mapping of financial accounts, and account types, to the transaction TYPEs in the HOSPITAL_CHARGE_ADMIN table. It also contains information on how the transactions affect account balances by increasing or decreasing the balance, and whether the transaction is considered to be a credit or debit. HOSPITAL_CHARGE_ADMIN contains foreign key references to many ancillary tables that are also listed.
Refer to the 'Inventory and Accounting Definitions' page for the definition of terms found in the table below.
Mapping
| FINANCIAL REPORT | ACCOUNT GROUP | ACCOUNT TYPE | TYPE CHARGE_ADMIN::ADJUSTMENT | CHARGE ADMIN SIGN | EFFECT ON ACCT | DR / CR | ANCILLARY TABLES | EXAMPLES |
|---|---|---|---|---|---|---|---|---|
| Balance Sheet | Asset | A/R | A_R_PAYMENT | (+) | Decrease | CR | ORDERARTRANSACTIONS | |
| Income Statement | Contra Revenue | Sales Discounts, Returns, and Allowances | ADJUSTMENT::OPEN_ORDER | (-) | Increase | DR | ADJUSTMENT ORDER_ITEM_MODIFIER ADJUSTMENT_ITEMS | Discounts such as: LDA/RDA, Behavior, Promotional, Instructional, Packages, Clinical Research, Wellness Packages, Employee/Student, Credit Adjustments such as: Administrative, Returned Items, Charged-In-Error. |
| Income Statement | Revenue | Price Increase | ADJUSTMENT::INVOICE_PRICE_INCREASE | (+) | Increase | CR | ADJUSTMENT | System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually increased by the User. |
| Income Statement | Contra Revenue | Price Decrease | ADJUSTMENT::INVOICE_PRICE_DECREASE | (-) | Decrease | DR | ADJUSTMENT | System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually decreased by the User. |
| Income Statement | Revenue | Interest Charges Assessed | ADJUSTMENT::INTEREST | (+) | Increase | CR | ADJUSTMENT | Interest: CHARGE_ADMIN::TYPE = ADJUSTMENT CHARGE_ADMIN +----> ADJUSTMENT +--- ---> ADJ_TYPE::ADJUSTMENT_TYPE = INTEREST |
| Income Statement | Contra Revenue | Interest Charges Reversal | ADJUSTMENT::INTEREST | (-) | Decrease | DR | ADJUSTMENT | Interest Reversal (unpaid): CHARGE_ADMIN::TYPE = ADJUSTMENT |
| Balance Sheet | Liability | Interest Charges Reversal | CREDIT_MEMO | (-) | Decrease | DR | CREDIT_MEMO | Interest Reversal (paid): CHARGE_ADMIN::TYPE = CREDIT_MEMO (if interest that has been paid is reversed, resulting in a credit memo). |
| Income Statement | Contra Revenue | Late Fee Reversal | ADJUSTMENT::LATE_FEE | (-) | Decrease | DR | ADJUSTMENT | Late Fee Reversal: CHARGE_ADMIN::TYPE = ADJUSTMENT |
| Income Statement | Contra Revenue | Client Discount
Product Debit Reversal | ADJUSTMENT::PRODUCT | (-) | Increase | DR | ADJUSTMENT ORDER_ITEM_MODIFIER | System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup. Client Discount Adjustment - resulting from a price set multiplier less than 1.00. Volume Discount Adjustment - resulting from a sufficient dollar volume and associations with a volume discount. Product Debit Adjustment Reversal - resulting from the reversal of a PRODUCT debit adjustment. |
| Income Statement | Revenue | Client Markup Minimum Price
Product Credit Reversal | ADJUSTMENT::PRODUCT | (+) | Increase | CR | ADJUSTMENT ORDER_ITEM_MODIFIER | System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup. Client Markup Adjustment - resulting from a price set multiplier greater than 1.00. Minimum Price Adjustment - resulting from a 'Minimum Price' that is greater than the product pricing basis, plus markup, minus discounts. Product Markup Adjustment - resulting from a 'Markup' multiplier greater than 1.00 Product Credit Adjustment Reversal - resulting from the reversal of a PRODUCT credit adjustment. |
| Income Statement | Revenue | Sales of products and services | CHARGE | (+) | Increase | CR | ORDER_ITEM | Results from a product (or service) being added to an order. The transaction is added to CHARGE_ADMIN, from ORDER_ITEMS when the order is closed. Amount = product's pricing basis x markup x quantity. |
| Balance Sheet | Liability | Client Credit
| CREDIT_MEMO | (+) | Increase | CR | ADJUSTMENT CREDIT_MEMO | Client Credits result from an adjustment made to charge, or debit memo, that has been paid. Credit Memos are posted via the Accounting screen → Credit/Debit Memo tab. |
| Balance Sheet | Liability | Client Credit Applied
| CREDIT_MEMO_APPLIED | (-) | Decrease | DR | CREDIT_MEMO DEBIT_MEMO ORDERARTRANSACTIONS | Client Credits, and Credit Memos, can be applied to order balances, and debit memos, via the Cashier screen. |
| Income Statement | Revenue | Debit Memo | DEBIT_MEMO | (+) | Increase | DR | DEBIT_MEMO | Debit Memos are posted via the Accounting screen - Credit/Debit Memo tab. |
| Income Statement | Revenue | Late Fees Assessed | DEBIT_MEMO::LATE_FEE | (+) | Increase | CR | DEBIT_MEMO ADJUSTMENT | Late Fees: CHARGE_ADMIN::TYPE = DEBIT_MEMO CHARGE_ADMIN +---> DEBIT_MEMO +---> ADJUSTMENT +-- ---> ADJ_TYPE::ADJUSTMENT_TYPE = LATE_FEE |
| Balance Sheet | Liability | Client Deposit | N/A | N/A | Increase | CR | CLIENT_DEPOSIT PAYMENT | Client Deposits are posted via the Cashier screen. |
| Balance Sheet | Liability | Deposits Applied | DEPOSIT_APPLIED | (-) | Decrease | DR | CLIENT_DEPOSIT DEBIT_MEMO ORDERARTRANSACTIONS | Client Deposits can be applied to order balances, or debit memos, via the Cashier screen. |
| Income Statement | Revenue | Service Fee | MODIFIER | (+) | Increase | CR | ORDER_ITEM_MODIFIER | Products and services can be configured to include another product as an add-on service fee. |
| Balance Sheet | Liability | Unearned Income | PACKAGE_CHARGE | (+) | Increase | CR | CLIENT_PATIENT_PKG CLIENT_PKG_ITEM | The price of a billing package is captured as 'Unearned Income' liability when the order closes. As package items are used/sold, the liability is converted to revenue. |
| Balance Sheet | Contra Liability | Prepayment Applied | PREPAYMENT_APPLIED | (-) | Decrease | DR | CLIENT_PATIENT_PKG CLIENT_PKG_ITEM | As billing package items are used/sold, the unearned income is reduced by amount of prepayment allocated to the item. The package discount amount reduces sales revenue. |
| Balance Sheet | Liability | Taxes Due | TAX | (+) | Increase | CR | ||
| Balance Sheet | Contra Liability | Tax Adjustments | TAX_ADJUSTMENT | (-) | Decrease | DR | ADJUSTMENT | When a closed-order adjustment affects the taxable revenue of a charge, the tax amount is adjusted. |
| Balance Sheet | Contra Liability | Tax Exemption Credit | TAX_EXEMPTION | (-) | Decrease | DR | ADJUSTMENT CREDIT_MEMO | Tax exemptions reduce the amount to be collected from the client. If tax has been paid, an exemption may result in a client credit. |
| Balance Sheet | Liability | Tax Exemption Reversal (Debit) | TAX_EXEMPTION | (+) | Increase | CR | ADJUSTMENT ORDERARTRANSACTION | |
| ADJUSTMENT::PAYMENT | Corrections to payments that have been posted; such as: Wrong payment type, Returned Check, Incorrect Payment Amount. | |||||||
| ADJUSTMENT::REFUND | ||||||||
| ADJUSTMENT::REFUND_REVERSAL | ||||||||
| ADJUSTMENT::CLIENT_CREDIT | ||||||||
| ADJUSTMENT::DEPOSIT | ||||||||
| ADJUSTMENT::CREDIT_MEMO | ||||||||
| ADJUSTMENT::DEBIT_MEMO | ||||||||
| ADJUSTMENT::WRITE_OFF | ||||||||
| ADJUSTMENT::WRITE_OFF_REVERSAL | ||||||||
| ADJUSTMENT::ASAQ | ||||||||
| ADJUSTMENT::ASAQ_UNREPORTED | ||||||||
| ADJUSTMENT::TAX_EXEMPTION_CR | ||||||||
| ADJUSTMENT::TAX_EXEMPTION_DR | ||||||||
| ADJUSTMENT::PACKAGE |
VetView Wiki Most recent releases of VetView: Version 4.2.5 Hotfix (Released 10/31/2024)
Definitions
Refer to the 'Inventory and Accounting Definitions' wiki page for the definition of inventory and accounting terms, and for details about fields and controls.