CountServa
JMB Statement Reconciliation
JMB Statement Reconciliation in CountServa compares a Joint Management Body statement for one strata unit against the payments recorded in your ledger. It is used by property owners and accountants who pay maintenance and sinking fund charges.
What It Does
- Reads a pasted statement table: Date, Document No, Title, Description, Debit, Credit and Balance.
- Checks that the statement adds up to its printed closing balance before saving.
- Matches each receipt to a voucher in your ledger.
- Splits charges between what the company bears and what the tenant bears.
- Shows late payment interest, which is avoidable.
- Lists exceptions for you to chase.
Import a Statement
- Go to Reports > All Reports and open JMB Statement Reconciliation.
- Press Import a statement.
- Enter the Management body and the Unit. The unit must appear in your voucher memos.
- Choose the Expense account where this unit's charges are posted.
- Tick This account belongs to this unit alone only if no other property posts there.
- Enter Period from, Period to, Opening balance and Closing balance.
- Pick the Statement layout that matches your JMB.
- Paste the transaction table into Statement table and check the Preview.
- Save the import.
Read the Result
The list shows Unit, Management body, Period, Opening, Closing, Lines, Unexplained and Variances. Press Open on a row.
| Line Status | Meaning |
|---|---|
| Matched | A voucher in your ledger agrees |
| No voucher | The JMB received money you have no record of paying |
| Tenant | Paid by the tenant |
| Nets to nil | Charge and reversal cancel out |
| Charge | A charge raised, not a payment |
Other sections are Charges for the Period, Settlement and Exceptions. Press Re-match against the ledger after you correct a voucher.
Where a line needs no action, mark it Settled by the tenant with a reason. Re-matching leaves these alone.
Frequently Asked Questions
Does importing change my ledger?
No. The import is for comparison only.
Why are my vouchers not matching?
Check that the unit name appears in the voucher memo, or tick the unit-only account option when that account serves one unit.
Is a closing balance in brackets a debt?
No. Brackets mean a credit, so the JMB owes you. It is stored as a negative number.