payment collection
My company provides a service to Blocks of flats with a charge that is paid collectively by the leaseholders in the block. The payment is sometimes paid in full as one payment. But often, it is paid in numerous payments over a short period.
Ideally we would want a system where payments could be made that either updates an amount in a database that keeps the outstanding amount or a system that had a reference number assigned to an amount due per Block of flats.
Any advise on whether a system similar to the above options are possible would be much appreciated, subsequently any ideas you may have on how I could develop a system that supports our payment system requirements.