Hi Everyone,

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:

  1. Manage multiple accounting schemas (quick discussion)
  2. 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!

More Information

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 chuck@chuboe.com.

You can complete the form on this page.

Thank you for taking the time. I look forward to speaking with you.

Chuck Boecking



Leave a Reply

Your email address will not be published. Required fields are marked *