TownSq

Accounts

Core information for billing accounts for units or properties. Accounts are where charges are applied, payments are received, and balances are tracked. THIS DATA IS REQUIRED for migration.

Migration Requirements

Required for Import

Yes - Required

Retention History

Include all active accounts regardless of balance. For inactive accounts, only include those with non-zero balances (positive or negative). Inactive accounts with zero balance are excluded.

Usage Notes

THIS DATA IS REQUIRED - Critical for migration success
Initial data required 85 days before Go Dark period
Updated file with current balances required 5 days prior to Go Dark
An account is the billing entity for a unit or property
Retention logic: ALL active accounts + inactive accounts with non-zero balances
Active accounts are always included regardless of balance
Inactive accounts with zero balance are excluded from migration
For unit identification, provide at least one of: Unit ID, Unit Number, or Unit Address
People associated with the account should be provided in the Community Members entity
Additional mailing addresses can be provided in the Account Addresses entity
Transaction history should be provided in the Account Transactions entity
Most accounts have one primary unit, but some may have multiple (use Additional Unit IDs)

Fields (11)

Expand a field to see example values and, where necessary, additional business context

FieldTypeDescriptionAttributes
Account Main
Account IDTextUnique identifier for the source system Account
Required

Account ID

Unique identifier for the source system Account

Examples

ACCT-001
12345
ACCOUNT_001

Business Context

This field identifies unique account records from your source system, enabling updates after initial import. Provide any unique identifier from your system—numeric IDs, text codes, or concatenated values all work.

Association IDTextYour system's unique identifier for the HOA/association
Required
Primary Unit IDTextYour system's unique identifier for the primary unit
Required
Primary Unit NumberTextThe primary unit number/identifier (e.g., '101', 'A-5', 'Building 3 Unit 12')
Optional
Primary Unit AddressTextThe street address of the primary unit
Optional
Additional Unit IDsArrayIDs of any additional units associated with this account
Optional
Account Status
Is ActiveTrue/FalseWhether this account is currently active
Optional
Current BalanceNumberThe current balance on the account (positive = amount owed, negative = credit)
Optional
Is DelinquentTrue/FalseWhether the account currently has overdue payments
Optional
Delinquency DescriptionTextAdditional details about the delinquency
Optional
Additional Data
Additional DataJSON ObjectAny extra information from your source system
Optional

Relations

associationAssociationsmany-to-one

The HOA/community this account belongs to

unitUnitsmany-to-one

The primary unit associated with this account

membersCommunity Membersone-to-many

People associated with this account (owners, tenants, occupants)

addressesAccount Addressesone-to-many

Mailing addresses for this account

transactionsAccount Transactionsone-to-many

Charges, payments, and adjustments for this account

Accounts