Versions Compared

Old Version 5

changes.mady.by.user Rick Eggleston (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Jeff Duke

Saved on

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 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 definitions the definition of terms found in the table below.


Asset
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(+)DecreaseCR
CHARGE_ADMIN
ORDERARTRANSACTIONS
Income Statement
Expense
Contra 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(+)IncreaseCRADJUSTMENT

CHARGE_ADMIN
System-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(+)IncreaseCR
CHARGE_ADMIN
ADJUSTMENTInterest:
CHARGE_ADMIN::TYPE = ADJUSTMENT
CHARGE_ADMIN +----> ADJUSTMENT +---
---> ADJ_TYPE::ADJUSTMENT_TYPE = INTEREST
Income StatementContra RevenueInterest Charges ReversalADJUSTMENT::INTEREST(-)DecreaseDR
CHARGE_ADMIN
ADJUSTMENTInterest Reversal (unpaid):
CHARGE_ADMIN::TYPE = ADJUSTMENT
Income Statement
Balance Sheet
Revenue
LiabilityInterest Charges ReversalCREDIT_MEMO(-)DecreaseDR
CHARGE
CREDIT_
ADMIN
MEMOInterest 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(-)DecreaseDR
CHARGE_ADMIN
ADJUSTMENTLate Fee Reversal:
CHARGE_ADMIN::TYPE = ADJUSTMENT
Income Statement
Expense
Contra Revenue

Client Discount


Volume Discount


Product Debit Reversal

ADJUSTMENT::PRODUCT(-)IncreaseDR
CHARGE_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(+)IncreaseCR
CHARGE_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(+)IncreaseCR
CHARGE_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 SheetLiability
Application of a client credit or credit memo

Client Credit Applied


Credit Memo Applied

CREDIT_MEMO_APPLIED(-)DecreaseDR
CHARGE

CREDIT_

ADMIN

MEMO

CREDIT

DEBIT_MEMO

Balance Sheet

ORDERARTRANSACTIONS

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

DEBIT_MEMO

Debit Memos are posted via the Accounting screen - Credit/Debit Memo tab.
Income StatementRevenueLate Fees AssessedDEBIT_MEMO::LATE_FEE(+)IncreaseCR
CHARGE_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(-)DecreaseDR
CHARGE

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 SheetLiability
Prepaid SalesPREPAID
Unearned 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 Liability
Prepayments applied to charges and A/R(-
Prepayment 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 Sheet
AssetCash, A/RPREPAID
LiabilityTaxes DueTAX(+)Increase
DRPAYMENT
DEBIT_MEMO
ORDERAR_TRANS
CR

Balance SheetContra Liability
Taxes Due
Tax AdjustmentsTAX_ADJUSTMENT(
+
-)
Increase
Decrease
CR
DR
TAX_
ADJUSTMENTWhen a closed-order adjustment affects the taxable revenue of a charge, the tax amount is adjusted.
Balance SheetContra LiabilityTax Exemption CreditTAX_EXEMPTION(-)DecreaseDR
CHARGE

ADJUSTMENT

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(+)IncreaseCR
CHARGE_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