Solution of the Week : Consolidated Balance Sheet for Multiple Organizations with different base currencies
In the previous solution, we discussed in detail about creating a Multiple Organizations Setup with the same base currency.
In this solution, we will be addressing the process of creating consolidated financial reports, such as a Balance sheet, for multiple Zoho Finance Organizations that operate with different base currencies.
In this post, we will describe the solution step-by-step, by using the Single Organization Setup in Zoho Analytics, with a few additional steps.
First, we need to create tables to consolidate the data from all organizations and convert their different base currencies into a single base currency.
Follow the steps below to create consolidated financial reports:
- Import the data from one of the organizations using the single organization setup.
- Add the other Zoho Finance organizations with different base currencies into the same workspace using the Add Datasource option.
- Create a currency table with conversion rates.
- Create two query tables to unify the Accounts and Accrual Transaction tables of all the organizations. Check the sample queries to create these query tables.
- With these query tables, you can now create consolidated financial reports.
The following presentation shows in detail how to create Consolidated Reports for multiple orgs with the different base currency.
In the next post, we will see how to handle multiple currencies using the Multiple Organizations Setup option.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Rakesh Ramkumar B
jacob
Kumar K R
Traci Harper
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー