We are a startup with offices in a number of countries.
We want an accounting system that is nevertheless compartmentalised per country, such that only global officers see the accounts across all our markets/operating-countries (i.e. with the option to combine or consolidated accounts for different countries by the global officers), whilst staff in each country only see the accounts of the specific country they have been assigned.
In essence, we want a multi-user, multi-country, account. Is Manager the right option?
Currently Manager does have multi-user (server & cloud editions) and multi-business capabilities.
If your organisation is a single legal entity then Manager has tracking codes function where divisions (countries) can be reported individually or collectively. If your organisation is a multiple of separate legal entities then Manager can cater for them individually, but doesn’t have consolidation of entities currently but it a planned enhancement in the future.
Hi, thanks. The country operating entities are separate legal bodies but with common shareholding. So they all report to group of ‘global officers’. What is needed is the ability of the ‘global group’ to compute income and other results across the country entities thus obtaining a snap shot of the organisation as a whole.
Consolidation will probably come the next year. It’s quite complicated feature and it’s not something that is generally supported in other accounting packages anyway. Most companies do consolidation manually.
Set up in a spreadsheet a Master BS & P&L which caters for all the chart of account variations and then transpose the data from the respective reports into the columns for each business. This would also allow for a column to enter any intercompany elimination entries - that’s if you are going to worry about that level of detail. (This could be a good practise exercise before considering (2)
As with (1) but set up the Master BS & P&L inside a Manager business called Consolidation, “not” the parent business. This business would “only” have the default tabs activated - Summary, Journal, Reports & Settings so there is no complications with Control Accounts. Then via Journal entry transpose the respective reports, possibly utilising the tracking codes feature. The Journals could either be monthly results (via cloning) or cumulative results (via overwriting)
These options would only suit month end reporting - not day to day reporting.
I am trying the Server Edition to setup all my businesses. I have 3 different companies at three different locations, but each of these companies deal with the other 2 - as suppliers and customers. So, I was trying to setup 3 different business, but after creating these companies, the other companies are not visible for me to set them up as supplier and/or customer. Can this be done? Or is there a workaround?
Each company is a separate data file. When you have one of the company’s open you can add the other companies as Customers or Suppliers via the Customers or Suppliers tab as you would add any other external Customer or Supplier for that business.
Currently your best option in Manager is to create a new master business and then Journal the required balances of each individual business into the master business. You could use the tracking codes in the master business so that you can produce a P&L with both aggregate and each business side by side totals
I’m not planning to implement consolidation of multiple business files. It would be impossible to do it correctly.
What I’m planning to do is improve divisional accounting so you can set for each asset and liability account what division it belongs to so you can get divisional balance sheet where loan accounts between divisions are automatically managed and of course consolidated balance sheet where loan accounts between divisions are filtered out.
In other words, if you have 5 related entities which you want to consolidate, you will set them up as single business is Manager and those 5 entities will be created as divisions within single business file.