How to Prepare a Dues Ledger (Schedule)?

What Is a Dues Ledger?

A dues ledger (or schedule) is a tracking table showing the dues accrued for each unit, the amount paid, and the remaining debt. A good ledger enables management to instantly answer the question "who paid how much" and is the foundation of transparency.

What Information Is Included in the Ledger?

A complete dues ledger includes the following columns:

• Unit number and owner/tenant name
• Period (month/year) and accrued amount
• Amount paid and payment date
• Remaining debt
• Late-payment interest, if any
• Status (paid / partial / unpaid)

When this information is seen together, both the manager and the resident clearly understand the situation.

Manual or Digital?

In small buildings, the ledger may be kept manually or with a simple table, but as the number of units increases, the risk of error grows. Recalculating late-payment interest each month and correctly deducting partial payments become difficult manually. In a digital management system, the ledger is updated automatically; when a collection is entered, the remaining debt and late-payment interest are instantly recalculated. This saves time and prevents errors.

Partial Payment and the FIFO Logic

When an owner with multiple monthly debts makes a partial payment, it is important which debt this payment is credited to. The common method is to close the oldest debt first (FIFO). We covered this logic and collection methods in detail in our collection methods article.

Sharing the Ledger with Residents

Transparent management enables each resident to see their own debt and payment status. Under KVKK (the Turkish Personal Data Protection Law), one resident seeing another's debt information may cause problems; for this reason, care must be taken when sharing the ledger. We covered this topic in our dues list and KVKK article. The correct method is to provide each resident with a panel showing only their own data.

Common Mistakes

• Not entering late-payment interest in the ledger: An incomplete ledger does not show the actual debt.
• Openly sharing everyone's debt: Creates risk under KVKK.
• Incorrectly deducting partial payments: If the FIFO logic is not applied, the accounts become confused.

This content is for informational purposes. The ledger arrangement should be adapted to your building's needs.