Enter your idea

Hi. We are an International company with various subsidiaries in the UK and overseas. We are using a bespoke accounting system which is not even cloud based. In fact all on the spreadsheets. Designed to serve the purpose. However, It took me a while to persuade our managers to move onto something more advanced, user friendly, that would create all accounts on the platform, not on manual spreadsheets. 
There are a few downsides I am facing on Xero. This software doesn't have any built in accruals and prepayments invoice system, that could do the accruals and prepayments for you usins the dates you select. However, it is still manageable using either a third party excel that we do anyway or just post manual journals on the monthly basis. I saw someone has already highlighted this idea previosly.
There is another problem that I am facing at the moment is how could I move all our subsidiaries with their own budgets and Bank accounts under one parent company, but projects? Ideally have lets say 3 diffrent companies with different sets of accounts all seperate (Bank, AP), but when it comes to a month end is to be able to consolidate all into one group consolidation management account? So it can create P&L, BL for all? We started using zero for one of our business, but seems like we can not migrate all in order to consolidate it. Seems like Zero is for small business only? All I do is to feed it into our spreadsheets again. I am trying to run away from manual sets of management accounts on the excel. Finally our sales platfom is so sophisticated, I am still looking for alternatives, but it is a different subject. The consolidation is more important.