{"id":17405,"date":"2026-01-29T13:20:51","date_gmt":"2026-01-29T13:20:51","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17405"},"modified":"2026-01-29T13:20:53","modified_gmt":"2026-01-29T13:20:53","slug":"how-accounting-schema-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-accounting-schema-works-in-idempiere\/","title":{"rendered":"How Accounting Schema Works in iDempiere"},"content":{"rendered":"\n
An Accounting Schema is the foundational configuration that tells iDempiere how financial transactions should be recognized, recorded, and posted to the General Ledger (GL). It defines the rules, structure, elements, and default accounts that control accounting entries across your business.<\/p>\n\n\n\n
An Accounting Schema allows you to define:<\/p>\n\n\n\n
\n
The accounting principles you follow (e.g., accrual vs cash)<\/li>\n\n\n\n
The default GL accounts used when transactions are posted<\/li>\n\n\n\n
How product costs are calculated and accounted<\/li>\n\n\n\n
Whether commitments and cost reservations are tracked<\/li>\n\n\n\n
The currency and period control for accounting postings<\/li>\n\n\n\n
Which accounting dimensions (segments) are in the account structure<\/li>\n\n\n\n
Default accounts for receivables, payables, inventory, revenue, expenses and more.<\/li>\n<\/ul>\n\n\n\n
Accounting Schema Setup<\/strong><\/h2>\n\n\n\n
In the Accounting Schema main tab, you configure:<\/p>\n\n\n\n
\n
Name & Description<\/strong>: A unique label to identify the schema<\/li>\n\n\n\n
GAAP<\/strong>: The accounting principles used<\/li>\n\n\n\n
Accrual or Cash Basis<\/strong>: Revenue recognition method<\/li>\n\n\n\n
Costing Method<\/strong> (Standard \/ Average \/ FIFO \/ LIFO)<\/li>\n\n\n\n
Cost Type<\/strong> (e.g., Current \/ Planned \/ Future)<\/li>\n\n\n\n
Currency<\/strong> for accounting<\/li>\n\n\n\n
Automatic Period Control<\/strong> and posting limits<\/li>\n<\/ul>\n\n\n\n
These settings guide how financial records behave across the system.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Account Schema Elements<\/strong><\/h2>\n\n\n\n
This tab defines the dimensions used in account combinations<\/strong>, such as:<\/p>\n\n\n\n
\n
Business Partner<\/li>\n\n\n\n
Product<\/li>\n\n\n\n
Project<\/li>\n\n\n\n
Activity<\/li>\n\n\n\n
Location<\/li>\n\n\n\n
Campaign<\/li>\n<\/ul>\n\n\n\n
Each dimension adds context to accounting entries so you can analyze financial results by department, product line, project, region, etc.<\/p>\n\n\n\n
General Ledger Settings<\/strong><\/h2>\n\n\n\n
Here you define how the schema handles:<\/p>\n\n\n\n
\n
Currency balancing<\/li>\n\n\n\n
Suspense accounts<\/li>\n\n\n\n
Intercompany accounts<\/li>\n\n\n\n
Purchase Price Variance<\/li>\n\n\n\n
Commitment offsets<\/li>\n<\/ul>\n\n\n\n
These settings ensure postings are balanced and compliant<\/em> under all scenarios.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Defaults for Posting<\/strong><\/h2>\n\n\n\n
The Defaults tab<\/strong> stores default GL accounts<\/em> that iDempiere applies automatically when you create or complete transactions. Examples include:<\/p>\n\n\n\n
\n
Customer Receivables<\/li>\n\n\n\n
Vendor Liabilities<\/li>\n\n\n\n
Inventory Asset<\/li>\n\n\n\n
Cost of Goods Sold<\/li>\n\n\n\n
Revenue<\/li>\n\n\n\n
Unearned Revenue<\/li>\n\n\n\n
Work In Progress (WIP)<\/li>\n\n\n\n
Project Asset<\/li>\n<\/ul>\n\n\n\n
This ensures every business event is posted to the correct ledger account.<\/p>\n\n\n\n<\/figure>\n\n\n\n
How Accounting Schema Is Used Every Day<\/strong><\/h2>\n\n\n\n
Every time after the creation of:<\/p>\n\n\n\n
\n
Customer invoices<\/li>\n\n\n\n
Vendor bills<\/li>\n\n\n\n
Payments<\/li>\n\n\n\n
Material receipts<\/li>\n\n\n\n
Project costing<\/li>\n\n\n\n
Inventory movements<\/li>\n\n\n\n
Period closes<\/li>\n<\/ul>\n\n\n\n
\u2026iDempiere uses the Accounting Schema rules and default accounts<\/strong> you defined to automatically generate the correct journal entries.<\/p>\n\n\n\n
In iDempiere, the Accounting Schema <\/strong>is the central configuration that defines how accounting works<\/em>.It determines posting logic, cost methods, GL accounts, accounting dimensions, and period controls. Proper setup here ensures financial data is accurate, traceable, compliant, and easily reportable<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"
An Accounting Schema is the foundational configuration that tells iDempiere how financial transactions should be recognized, recorded, and posted to […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[38],"tags":[],"class_list":["post-17405","post","type-post","status-publish","format-standard","hentry","category-master"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17405"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17405\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"TenthPlanet-iDempiere-Master-AccountingSchema-1\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-AccountingSchema-1-1.png\")
<\/figure>\n\n\n\n![\"TenthPlanet-iDempiere-Master-AccountingSchema-2\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-AccountingSchema-2-1.png\")
<\/figure>\n\n\n\n![\"TenthPlanet-iDempiere-Master-AccountingSchema-3\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-AccountingSchema-3-1.png\")
<\/figure>\n\n\n\n