I want to start recording receivables in my database. I have one table for Units (undeveloped lots or houses) and one for owners (Name, mailing address, etc). I only have about 300 units and 250 owners. At the moment, I have an "ownerID" field in the UNITS table. Annual HOA dues are about $400/unit and can be paid in two installments. Owners can also receive fines, late fees, and a variety of services performed fees. I do not need a double entry type bookkeeping system.
This is my first "transaction table" but my thoughts for fields are:
- OwnerID
- UnitID (If applicable)
- Transaction Date
- Transaction Description
- Transaction Amount
How would you generate the annual dues charge?
Thanks
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar