Monthlybalance


Description

Monthly balance tracking maintaining monthly financial balance summaries by site for accounts receivable management. This table captures monthly snapshots of billing amounts, payments, adjustments, and aging balances, supporting financial reporting, cash flow analysis, and accounts receivable management across different service delivery sites.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MonthID int identity 4 null

Primary key - Unique identifier for each monthly balance record

AsOfDate smalldatetime 16 null

As of date - Date for which this monthly balance snapshot was calculated

SiteID int 4 null

Site reference - Links to the service delivery site for this balance

SiteName varchar 50 null

Site name - Name of the service delivery site

NewBillingAmount money 21,4 null

New billing amount - Total amount of new billing for the month

NewPayment money 21,4 null

New payment amount - Total amount of new payments received for the month

HoldBilledCharged money 21,4 null

Hold billed charged amount - Amount of charges that are on hold from previous billing

HoldNewCharged money 21,4 null

Hold new charged amount - Amount of new charges that are placed on hold

VoidAmount money 21,4 null

Void amount - Total amount of voided transactions for the month

DeleteAdjust money 21,4 null

Delete adjustment amount - Adjustment amount for deleted transactions

PartialPaidAdjust money 21,4 null

Partial paid adjustment - Adjustment amount for partially paid claims

AmountchargeAdjust money 21,4 null

Amount charge adjustment - Adjustment to charge amounts

VoidPaidAdjust money 21,4 null

Void paid adjustment - Adjustment amount for voided payments

DeletePaidAdjust money 21,4 null

Delete paid adjustment - Adjustment amount for deleted payments

VoidPaidByFHAdjust money 21,4 null

Void paid by FH adjustment - Adjustment for voided payments by foster home

PaidByFHAdjust money 21,4 null

Paid by FH adjustment - Adjustment for payments made by foster home

ImportAdjust money 21,4 null

Import adjustment - Adjustment amount from imported transactions

CurrentBalance money 21,4 null

Current balance - Current outstanding balance as of the snapshot date

PreviousEndingBalance money 21,4 null

Previous ending balance - Ending balance from the previous month

NetChange money 21,4 null

Net change - Net change in balance from previous month to current month

Before601 money 21,4 null

Before 601 days - Balance amount for claims older than 601 days

After701 money 21,4 null

After 701 days - Balance amount for claims older than 701 days

OtherAmt money 21,4 null

Other amount - Other miscellaneous amounts not categorized elsewhere

Unbilled money 21,4 null

Unbilled amount - Amount of services provided but not yet billed

Writeoffamount money 21,4 null

Write-off amount - Amount written off as uncollectible for the month

Relationships