Here is a common question about ADempiere or iDempiere and accounting reporting standards.
"Because of our interactions with various government departments, we have reporting requirements to comply with existing and upcoming IFRS standards. We may also need to report against multiple standards. Any known issues in that arena?"
Said another way, can you use ADempiere or iDempiere, open source ERP, to support international accounting complexities? The answer is amazingly ‘yes’.
Great question! In 9 years, I have not encountered an issue that prevented reporting against a single standard regardless of whether it is IFRS, International GAAP, Canadian GAAP, or US GAAP. The challenges occur when reporting against multiple standards. There are two ways to accomplish the multiple standard reporting approach:
- Manage multiple accounting schemas (quick discussion)
- Create end-of-period GL Journals to update the books to reflect the different standards.
I believe option #2 deserves a more in-depth discussion. If you were to create a GL Journal to update your books to reclass values, you should provide the control report that defends some or all the amounts. ADempiere has a feature that allows you to attach any document to any record. This ability means you can support each GL Journal Line with its own control document. Having processes and results that are self-documenting is a love story. Anyone with the right access can go into any standards GL Journal and defend the reporting standard’s results.
Here is an Example
Let’s discuss a $60B computer manufacturer near Austin, TX as an example of using reversing GL Journals to report via multiple standards. As I understand their situation, the following bullets describe the period close and reporting process:
- They have over 100 subsidiaries or entities.
- Each entity maintains its books in US GAAP regardless of where they are located.
- Each entity closes its books (in US GAAP) and submits the results for consolidation with the other subsidiaries.
- After consolidation, corporate creates its financial reports and statutory filings.
- Once consolidation results are submitted, each entity can then create reversing GL journals to report and file within local standards and regulations.
The biggest benefit to this structure is simplicity. Global accounting education is simplified. Consolidation mappings and efforts are simplified. Regional reporting expertise is maintained by regional domain and audit experts.
I hope this helps!
- Using Open Source ERP with Multiple Companies to produce consolidated financials.
- Here is an more indepth review of ADempiere’s ability to support wholesale and web distribution.
- If you are new to open source ERP, here is a quick guide to help you choose the right ERP. As a worst case scenario, evaluating open source ERP helps you save on commercial license fees.
- If you are new to ADempiere, here is a video tutorial to help learn to navigate.
- If you want to dig deep in to how product accounting works in Tier 1 ERP, here is a video tutorial that should make product accounting easier to understand.
- If you want to know how much you can save by using open source ERP, here is an open source ERP ROI discussion.
Please note that iDempiere is a fork from ADempiere. iDempiere has the same abilities mentioned above.
About Chuck Boecking: I am an ERP educator. I believe that open source ERP have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization. I started using the iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the world. My vision of success is to find companies that can best use open source ERP to help them achieve a single, global instance that drives a discontinuous increase in profitability. I believe that organizations win when they own their technology.
If you have questions, comments or concerns, let me know. I definitely want your feedback.
You can contact me by phone using 512.850.6068.
My email is email@example.com.
You can complete the form on this page.
Thank you for taking the time. I look forward to speaking with you.