Three DB for data capture, three further DBs that automatically flow from first - is this possbile/sensible in Zoho?

Hi,

I'm a newbie to Zoho and I have 12 days left of my 14 day free trial.

I'm trying to achieve the following, but really don't know if Zoho is a sensible platform for achieving it or if it's possible. Be great to get some advice from the community.

What I am trying to do?

I want create four DBs with the ability to create rich and dynamic reports. So far so easy.

The hard bit is, I only want to input data in to one Master DB and for the other three DB to all update automatically, based on a set of automated rules.

I've played around in the workflow and rules parts of Zoho, but it's really not obvious to be how I can do this.

Bit more context.

I have multiple properties in the uk that I own. I have also legitimately set up a property management company that manages all these properties and sub-contracts all the contracts and agents that mange the different properties. For this service, the property management company adds on margin to most of the transactions.

So the property management company retains some profits and the reduced income that flows to me as an individual has to be declared for tax returns.

The four DBs

DB1 is where I want to import all the raw transaction data form the various sources. This data can then be used to report on the financial performance of each property. This is straight forward enough.

DB2 needs to then be automatically updated, using all the data from DB1, but filtering out any non-relevant lines. This DB2 represents all the costs of the property management company.

DB3 then needs to take each line from DB2 and add margin on the relevant lines depending on the category (rent, commission, expense etc). this represent the revenue for the property management company and DB3 minus DB2 is the companies profit.

Finally, DB4 needs to take all the lines from DB3 (effectively all my costs) plus additional costs/lines from DB1 that do not flow through the property management company (personal expenses, insurance etc). This DB has the rent in it and it represents my personal profit.

What I need to know

Is this even a sensible use of the Zoho platform? Is it possible and simple enough to create a bug free, easy to use application?

If yes, any simple pointers on how I can achieve the automation I describe above.

I'd like to do it myself, but if it's beyond me, I'm equally happy to get a developer to do it assuming it's not too expensive (I've also reached out to the developer community).

Any ideas would be much appreciated.

Thanks!