Thank you both for your prompt responses.
In Business Central, I have created a company with the Indian fiscal year (April–March). However, at regular intervals, one of our investors based in the US requests to view the Trial Balance using the US fiscal year (January–December).
While I understand that financial reporting with date filters can help generate reports for the desired periods, I’m unsure how to handle opening balances for January, especially when those balances were originally posted in April as per the Indian fiscal year.
Could you please advise on how to filter or display accurate opening balances for January under this scenario?
Thanks again.
Valentin Castravet Work: Zander ERP Services Blog: Dynamics 365 Business Central Insights LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Hi Revan,
Business Central doesn't support multiple fiscal year structures within the same company—only one accounting period setup is allowed at a time.
That said, one possible workaround is to use dimensions (e.g., "Calendar Year" or "Alt Fiscal Period") to tag transactions. This isn't the most elegant solution, but it can help you track and report against an alternate period like Jan–Dec.
It's not perfect, but it can work depending on how strict your reporting requirements are.
Hope that helps!
Regards,
Zain
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sumit Singh 3,227
Nimsara Jayathilaka. 2,866
Sohail Ahmed 2,682 Super User 2025 Season 2