Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel


Panel
borderColorblue
bgColor#B3D4FF
borderWidth1
borderStylesolid

GL Account Mapping to HOSPITAL_CHARGE_ADMIN


Excerpt

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.



Info

Refer to the 'Inventory and Accounting Definitions' page for the definition of terms found in the table below.


Panel


Panel
borderColorblue
bgColor#B3D4FF
borderWidth1
borderStylesolid

Mapping


FINANCIAL
REPORT
ACCOUNT
GROUP
ACCOUNT TYPETYPE

CHARGE_ADMIN::ADJUSTMENT
CHARGE
ADMIN
SIGN
EFFECT
ON ACCT
DR / CRANCILLARY TABLESEXAMPLES
Balance SheetAssetA/RA_R_PAYMENT(+)DecreaseCRCHARGE_ADMIN
ORDERARTRANSACTIONS

Income StatementExpenseContra RevenueSales Discounts, Returns, and AllowancesADJUSTMENT::OPEN_ORDER(-)IncreaseDRADJUSTMENT
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 StatementRevenuePrice IncreaseADJUSTMENT::INVOICE_PRICE_INCREASE(+)IncreaseCRADJUSTMENTCHARGE_ADMINSystem-generated adjustment that results from the 'Subtotal' of a charge on an order being manually increased by the User.
Income StatementContra RevenuePrice DecreaseADJUSTMENT::INVOICE_PRICE_DECREASE(-)DecreaseDRADJUSTMENT
CHARGE_ADMIN
System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually decreased by the User.
Income StatementRevenueInterest Charges AssessedADJUSTMENT::INTEREST(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENT
Interest:
CHARGE_ADMIN::TYPE = ADJUSTMENT
CHARGE_ADMIN +----> ADJUSTMENT +---
---> ADJ_TYPE::ADJUSTMENT_TYPE = INTEREST
Income StatementContra RevenueInterest Charges ReversalADJUSTMENT::INTEREST(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENT
Interest Reversal (unpaid):
CHARGE_ADMIN::TYPE = ADJUSTMENT
Income StatementBalance SheetRevenueLiabilityInterest Charges ReversalCREDIT_MEMO(-)DecreaseDRCHARGECREDIT_ADMINMEMOInterest Reversal (paid):
CHARGE_ADMIN::TYPE = CREDIT_MEMO
(if interest that has been paid is reversed, resulting in a credit memo).
Income StatementContra RevenueLate Fee ReversalADJUSTMENT::LATE_FEE(-)DecreaseDRCHARGE_ADMINADJUSTMENTLate Fee Reversal:
CHARGE_ADMIN::TYPE = ADJUSTMENT
Income StatementExpenseContra Revenue

Client Discount


Volume Discount


Product Debit Reversal

ADJUSTMENT::PRODUCT(-)IncreaseDRCHARGE_ADMIN

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 StatementRevenue

Client Markup


Minimum Price


Product Markup


Product Credit Reversal

ADJUSTMENT::PRODUCT(+)IncreaseCRCHARGE_ADMIN

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 StatementRevenueSales of products and servicesCHARGE(+)IncreaseCR

ORDER_ITEM


CHARGE_ADMIN

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 SheetLiability

Client Credit


Credit Memo

CREDIT_MEMO(+)IncreaseCRCHARGE_ADMIN

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 SheetLiabilityApplication of a client credit or credit memo

Client Credit Applied


Credit Memo Applied

CREDIT_MEMO_APPLIED(-)DecreaseDRCHARGE

CREDIT_

ADMIN

MEMO

CREDIT

DEBIT_MEMO

Balance SheetAsset

ORDERARTRANSACTIONS

Client Credits, and Credit Memos, can be applied to order balances, and debit memos, via the Cashier screen.
Income StatementRevenueDebit MemoDEBIT_MEMO(+)IncreaseDRCHARGE_ADMIN

DEBIT_MEMO

Debit Memos are posted via the Accounting screen - Credit/Debit Memo tab.
Income StatementRevenueLate Fees AssessedDEBIT_MEMO::LATE_FEE(+)IncreaseCRCHARGE_ADMIN

DEBIT_MEMO

ADJUSTMENT

Late Fees:
CHARGE_ADMIN::TYPE = DEBIT_MEMO
CHARGE_ADMIN +---> DEBIT_MEMO +---> ADJUSTMENT +--
---> ADJ_TYPE::ADJUSTMENT_TYPE = LATE_FEE
Balance SheetLiabilityClient DepositN/AN/AIncreaseCR

CLIENT_DEPOSIT

PAYMENT

Client Deposits are posted via the Cashier screen.
Balance SheetLiabilityDeposits AppliedDEPOSIT_APPLIED(-)DecreaseDRCHARGE

CLIENT_

ADMIN

DEPOSIT 

CLIENT_DEPOSIT

DEBIT_MEMO

ORDERARTRANSACTIONS

Client Deposits can be applied to order balances, or debit memos, via the Cashier screen.
Income StatementRevenueService FeeMODIFIER(+)IncreaseCR

ORDER_ITEM_MODIFIER

Products and services can be configured to include another product as an add-on service fee.
Balance SheetLiabilityPrepaid SalesUnearned IncomePACKAGE_CHARGE(+)IncreaseCR

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 SheetContra LiabilityPrepayments applied to charges and A/RPREPAIDPrepayment AppliedPREPAYMENT_APPLIED(-)DecreaseDR

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 SheetAssetCash, A/RPREPAID(-LiabilityTaxes DueTAX(+)IncreaseDRPAYMENT
DEBIT_MEMO
ORDERAR_TRANSCR


Balance SheetContra LiabilityTaxes DueTax AdjustmentsTAX_ADJUSTMENT(+-)IncreaseDecreaseCRDRTAX_ADJUSTMENTWhen a closed-order adjustment affects the taxable revenue of a charge, the tax amount is adjusted.
Balance SheetContra LiabilityTax Exemption CreditTAX_EXEMPTION(-)DecreaseDR

ADJUSTMENT

CHARGE

CREDIT_

ADMIN
ADJUSTMENT

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 SheetLiabilityTax Exemption Reversal (Debit)TAX_EXEMPTION(+)IncreaseCRCHARGE_ADMIN

ADJUSTMENT

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








Insert excerpt
UG:Setup & Admin Guides
UG:Setup & Admin Guides
nopaneltrue

To see commonly used terms in VetView Hospital, please visit our Hospital Glossary of Terms
Info
titleDefinitions

Refer to the 'Inventory and Accounting Definitions' wiki page for the definition of inventory and accounting terms, and for details about fields and controls.


Panel
titleContents

Table of Contents