{"id":18364,"date":"2019-02-14T10:07:44","date_gmt":"2019-02-14T04:37:44","guid":{"rendered":"http:\/\/tenthplanet.in\/compiere\/?p=18364"},"modified":"2023-08-22T16:07:59","modified_gmt":"2023-08-22T10:37:59","slug":"financial-management","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/compiere\/financial-management\/","title":{"rendered":"Compiere Financial Management"},"content":{"rendered":"

Compiere Financial Management includes Web, Accounting Rules, Financial Reporting, GL Journel Batch and GL Journel<\/p>\n

Calendar Period<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Calender<\/p>\n

The Calendar Year and Periods define the calendars that will be used for period control and reporting. You can also define non-standard calendars (e.g. business year from April to March)<\/p>\n

To Click on Create a new Calendar Period we need to define with a Name for the Organisation & Tenant<\/p>\n

For ex: For Garden world we can define as “Garden World – Financial Year 2019 – 20” for Name & Description<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Calendar<\/p>\n

The Organisation selected needs to * & Year defined as 2019 – 20 & we need to click on Create Period Buttons<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Calendar<\/p>\n

For each period the Start & End Date needs to be defined (From 1st to Last date of each month)<\/p>\n

Then for each month, all the respective document types (for ex: AP Invoice, AR Invoice, G\/L Journal, etc can be opened both individually as well as combined) by clicking “Open\/Close all Buttons”<\/p>\n

“The Update balance check box” helps in carrying for the previous month closing balances as current month Opening Balances<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Open<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Document<\/p>\n

Note: As and when the Accounting entries for the respective month gets completed, the Admin needs to close the accounting period in order to maintain the sanctity of numbers and also to make sure Accountants<\/p>\n

do not go and post any back dated accounting entries<\/p>\n

Note: The same process needs to be followed for every month for the calendar year<\/p>\n

Account Element<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Account<\/p>\n

The Account Element Window is used to define and maintain the Accounting Element also popularly called as Chart of Accounts of Any Organisation<\/p>\n

For any Organisation the 5 Key headings under the Chart of Accounts are (Owner’s Equity, Liabilities, Assets, Revenue & Expenses)<\/p>\n

For ex:<\/p>\n

Owner’s Equity: Garden World the amount of money bought in to form the company by the promoters are as Capital\/Equity Share Capital etc. Other parts of Share Capital includes Stock Options, Preference Share Capital<\/p>\n

Earnings: Carry forward of the previous year profit + or – the current year’s Profit is called as Earnings<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Equity<\/p>\n

Liabilities: Garden world liabilities can be classified as Long Term Liabilities (Long Term Debt, Long Term Mortgage from Wells Fargo Bank), Short Term Liabilities (Current Short term portion of long-time Debt Wells Fargo Bank), Tax Payables (GST, Any other deducted Tax)<\/p>\n

Vendor Payables (for Goods purchased like seeds, flower pots & services availed like Tax Consultants)<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_STL<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_LTL-min\"<\/p>\n

For ex: Garden world: Assets can be classified ask Fixed Assets (Plant & Machinery used for processing seeds, Furniture in offices including Chairs, Tables, Computers & Laptops used in offices, Office Buildings, office vehicles including cars, Current Assets (Stocks or inventory which can be classified as Raw Materials, Work in Progress or semi-processed goods, & finished products, Accounts Receivables (payments we need to receive from our customers), (Softwares used in Office premises for Accounting, Inventory, Payroll), Prepaid Expenses (expenses like Internet bills which the company would have paid for a full calendar period), Cash & Bank Balances of Garden World<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Current<\/p>\n

Note: The Element needs to be created at the * Organisation<\/p>\n

Search Key: The Accounting Codes are called as Search Key: In any Organisation there will 4 levels of classification Header, Breakdown, Account, Sub Account<\/p>\n

For Garden World: Headers are called as Owner’s Equity, Liabilities, Assets, Revenue & Expenses)<\/strong><\/p>\n

Breakdowns are 1 level below the Headers: For ex: Under Owner’s Equity: Share Capital & Retained Earnings<\/strong><\/p>\n

Liabilities: Long Term Liabilities & Short Term Liabilities<\/p>\n

Revenue: Revenue from Operation & Other Income<\/p>\n

Expenses: Cost of Goods Sold, Sales & Admin Expenses, Employee Expenses etc<\/p>\n

Accounts: Under Breakdowns, the Accounts are the next level drill down<\/strong><\/p>\n

Owner’s Equity: Equity Share Capital & Reserves & Surplus are called as Accounts<\/p>\n

Liabilities: Long Term Debt, Long Term Mortgages are Account Heads under Long Term Liabilities, Current Period of Long Term Debt, Cash Credit, Bank Overdraft are called as Accounts under Short Term Liabilities<\/p>\n

Revenue: Revenue from Goods Sold, Revenue from Services are account heads under Revenue from Operation\\<\/p>\n

Expenses: Product COGS, Inventory COGS are account heads under Expenses<\/p>\n

SUB ACCOUNT:<\/p>\n

Owner’s Equity: Paid Up Capital is a Sub Account<\/p>\n

Liabilities: Long Term Debt: Individual Debt from Banks (Wells Fargo) are Sub Accounts<\/p>\n

Revenue: Revenue from Sale of flower pots are Sub Accounts<\/p>\n

Expenses: Cost of Purchases of seeds, fertilizers, Salary, Rent, Electricity, Telephone Bills are all sub-accounts<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_AccountTree-min\"<\/p>\n

Element Value Creation<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Element<\/p>\n

Search Key: The Header\/Breakdown\/Account\/Sub Account Code defined for each element value created<\/p>\n

For Ex: for Garden World<\/p>\n

Header: Owner’s Equity Search Key: 1<\/p>\n

Breakdown: Share Capital Search Key: 100<\/p>\n

Account: Equity Share Capital: 1001<\/p>\n

Sub Account: Paid Up Capital 100101<\/p>\n

Summary Level: For Header, Breakdown, Accounts alone, the Summary Level check box needs to be clicked in order to total the values under Each<\/p>\n

For Sub Accounts: The Account Type either has to be Asset, Liability, Expense, Revenue or Owner’s Equity<\/p>\n

Account Sig: Has to be natural only<\/p>\n

Post Actual: Check box needs to be selected for Sub Accounts, Budgets can also be defined<\/p>\n

Document Controlled mechanism helps in maintaining number sequence<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Account<\/p>\n

Accounting Dimensions<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Account<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Dimensions<\/p>\n

Accounting Dimensions refers to the number of Companies which can be created under Organisational Structure<\/p>\n

The Search Key, Name of the Organization and whether to define it at Summary Level can be defined in this window<\/p>\n

**Note: There can be only 1 Account Tree in Compiere.<\/strong><\/p>\n

Accounting Schema<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Accounting<\/p>\n

Accounting Schema will help in defining the Accounting Practice (US GAAP, IND AS), the costing methodology (Standard, FIFO, LIFO, Average), the Currency of the transaction at Organisational level, (USD) & tax corrections<\/p>\n

(in case of any write-off, discounts or any other standard methodology needs to be practiced across Organisation)<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Accounting<\/p>\n

The following are the Account Tree structure places to be effected. Organization, Account, Product, Business Partner and any other which can be added<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_AS<\/p>\n

Accounting Schema General Ledger<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_AS<\/p>\n

use Currency Balancing, Use Suspense Error & Use Suspense Balancing check boxes need to be clicked<\/p>\n

Currency Balancing: The Currency Balancing Account indicates the account to use when a currency is out of balance (generally due to rounding)<\/p>\n

Defaults Sub Tab<\/strong><\/p>\n

The default accounting configurations for Business Partner, Product, Warehouse, Bank, Tax, Cash Book, Work Order can be defined here<\/p>\n

Based on this the same, once configured, the accounting codes can be replicated to all the above across Compiere<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_GL<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_GL<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_GL<\/p>\n

**Note: The definition of the account codes have been individually captured in the modules above Business Partner, Product, Warehouse, Bank, Tax, Cash Book, Work Order<\/p>\n

Account Combination<\/h4>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_Account<\/p>\n

The Account Combination Window defines and displays valid account combinations.<\/p>\n

\"TenthPlanet_Compiere_Gardern_world_Finanical_Management_AC<\/p>\n

Through this window, the process can be used to pre-define and configure for Each Organisation the accounting<\/p>\n

GL Category<\/h4>\n

\"TenthPlanet_Garden_World_Financial_Management_GL<\/p>\n

The GL Category Window allows you to define categories to be used in journals. These categories provide a method of optional grouping and reporting on journals<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_GL<\/p>\n

Some of the examples of GL Category for include AP Invoices, AR Invoices, Material Management, AP Payment, AR Receipt for the purpose of defining the Document Type<\/p>\n

Rate Type<\/h4>\n

\"TenthPlanet_Garden_World_Financial_Management_Rate<\/p>\n

The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and\/or Sell\/Buy rates.<\/p>\n

For ex: This can be used for Buying\/Selling Garden World commodities into the Stock\/Commodities market through Spot\/Future\/Average Rates<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Rate<\/p>\n

This will help at the time of defining the exchange rates for the individual currencies with which Garden World does transactional activities<\/p>\n

Currency<\/h4>\n

\"TenthPlanet_Garden_World_Financial_Management_Currency\"<\/p>\n

The Currency Window defines any currency which will be used in documents or reporting<\/p>\n

For Garden world , the currencies used for Purchase\/Sale of Garden products can happen in any currency including USD, GBP,Euro, SGD (Singapore Dollars), Australian Dollars, Canadian Dollars etc<\/p>\n

Hence the default system provides the Currency, their short form & the full name terminology<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Curency<\/p>\n

Defining the exchange rate<\/p>\n

Creation of New Currency<\/p>\n

Tenant: Garden World, Organisation: *, ISO Code : Currency Code (Ex: USD for American Dollar), Symbol (of USD $) & Description: US Dollar<\/p>\n

Standard Precision: The number of places of decimal for rounding off for accounting purpose<\/p>\n

Costing Precision: The number of places of decimal for rounding off for costing purpose<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Currency<\/p>\n

Conversion Rates<\/h4>\n

The Conversion Rate Tab defines the rates to use when converting a source currency to an accounting or reporting currency. Note that only the multiply rate is used; the divide rate is for visualization only<\/p>\n

The exchange rate can be defined on a daily basis, weekly basis, monthly basis, quarterly basis based on Garden World’s Financial Advisors approval<\/p>\n

For ex: Garden world can get into a contract with a Purchase Vendor in Euro Currency for a quarter (January 2019 – March 2019) and agree that the exchange rate between the parties will remain the same irrespective of<\/p>\n

International Spot Markets fluctuation<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Currency<\/p>\n

Tenant: Garden World; Organisation: *; From Currency (always USD as Organisational Currency is USD); To Currency (Any other Currency); valid From & To Date: Need to be defined, Multiply Rate: As per Exchange Rate<\/p>\n

The divide by automatically gets calculated<\/p>\n

Currency Rate<\/h4>\n

\"TenthPlanet_Garden_World_Financial_Management_Currency<\/p>\n

The exchange rates defined against individual currencies will be displayed in this window<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Currency<\/p>\n

Document Type<\/h4>\n

The Document Type Window defines any document to be used in the system. Each document type provides the basis for processing of each document and controls the printed name and document sequence used<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

For Garden World Document Type will include Vendor Invoice, Vendor Payment, AR Receipt, Return to Consigned (Customer )etc<\/p>\n

\"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

    \n
  • Tenant: Garden World; Organisation: *; Name: AR Receipt\/AP Payment etc; GL Category needs to be defined as AR Receipt (from GL Category window, the Document Base Type is a dropdown from where Multiple Documents can share the same base Document Type (For Garden world ex: All Foreign Receipts, local receipts, Inter-Country State receipts of from customers can all have base document type as AR Receipt<\/li>\n
  • Sales Transaction: Checkbox to be selected if related to Sales alone<\/li>\n
  • The document is Number Controlled: Will have a Document Sequence number automated if checkbox selected<\/li>\n
  • Document Sequence: Based on the above checkbox selected, the Document Sequence for AR Receipt can be defined<\/li>\n
  • Any Default or System configured AR Receipt format can be linked through Print Format<\/li>\n<\/ul>\n

    Document Sequence<\/h4>\n

    \"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

    The Sequence Window defines how document numbers will be sequenced. For Each Document Type, Prefix & Suffix can be added for various tables<\/p>\n

    For Ex: For Garden World for AR Receipt can be with Prefix – GW 2019 – 20 & Suffix can – 001 Hence the Document will have auto-numbering with GW2019 – 20 – 001<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

    Document base Type<\/h4>\n

    \"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

    The accounting document base type determines how the transaction records are accounted for. This allows users to create custom documents and accounting rules<\/p>\n

    Different Document Types can have same Document Base Types<\/p>\n

    For ex:<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Doc<\/p>\n

    Tenant: System;Organisation*; Name: AR Receipt, Description: ***System Maintained*** (always), Document Base Type: ARR, Entity Type: Dictionary, Accounting Classname:<\/p>\n

    This will be configured by the technical consultant<\/p>\n

    GL Distribution<\/h4>\n

    \"TenthPlanet_Garden_World_Financial_Management_GL<\/p>\n

    This process helps in the allocation or transfer of costs from 1 Organisation to Another Organisation for want of finding the Actual Profit & Loss of individual Organisations<\/p>\n

    For ex: For Garden world, there are 3 Organisations (HQ, Stores, & Garden Stores)<\/p>\n

    Certain costs like Rent, Electricity, etc and their vouchers are all handled by HQ and booking happens in HQ only. But the actual costs need to be apportioned to Stores & Garden stores<\/p>\n

    Hence this process can be used for the same<\/p>\n

    Tenant: Garden World; Organisation:*; Name: Distribute Salaries; Accounting Schema: Garden World (General Ledger); Posting Type: Actual\/Budget can be defined; The necessary document types<\/p>\n

    like AP Invoice, AR Invoice; The Account Code: 60130 – Salaries, 61100 – Rent, etc can be defined here; The Business Partner, Product, Project, and any other parameters can be selected for apportionment<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_GL<\/p>\n

    The Lines are created in order to define the % of apportionment of expenses<\/p>\n

    Tenant: Garden World, Organisation: HQ (in order to select from & to Organisation); GL Distribution selected in the header will get carried forward; the Percentage needs to be defined<\/p>\n

    (limited maximum of 100% anything in excess will be not allowed); Organisation will have to be From & TO with Over right Organisation checkbox to be selected in order to over right the Initial Organisation which was<\/p>\n

    selected for Transactions<\/p>\n

    Tax Category<\/h4>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

    The Tax Category Window is used to enter and maintain Tax Categories. Each product is associated with a tax category which facilitates reacting changing tax rates<\/p>\n

    For ex: for Garden world, seeds can be taxed at GST of 5% whereas the Cars Purchased can be taxed at GST 10%<\/p>\n

    Hence GST with multiple Rates can be defined in this window<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

    Tax Rate<\/h4>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

    The Tax Rate Window defines the different taxes used for each tax category. For example, Seeds will have different taxes, clusters will have different tax rates in each state<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

    Tenant : Garden World; Organisation: *; Name & Description: CGST @ 9%, Tax Category: GST @ 5%; Valid From Date: Date field; Parent Tax (in case there are cascading taxes); Rate in %,<\/p>\n

    whether applicable for both Sales & Purchases need to be defined<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

    Configuration of Taxes with G\/L Codes<\/p>\n

    \"TenthPlanet_Garden_World_Financial_Management_Tax<\/p>\n

      \n
    • Tax Due & Tax Liability: Taxes which are part of Vendor Payables need to be configured under these G\/L Codes<\/li>\n
    • Tax Credit & Tax Receivables: Taxes which are part of Customer Receivables need to be configured under these G\/L Codes<\/li>\n
    • Tax Expense: Those Taxes for which Tax Credit cannot be taken and need to write off to Profit & Loss Accounts are classified under these G\/L Codes<\/li>\n<\/ul>\n

      For ex: For Garden, if the seeds clusters which are procured from Ohio contain taxes, which cannot be claimed by Nevada state, these taxes need to be written off as expenses<\/p>\n","protected":false},"excerpt":{"rendered":"

      Compiere Financial Management includes Web, Accounting Rules, Financial Reporting, GL Journel Batch and GL Journel<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[32,60],"tags":[],"class_list":["post-18364","post","type-post","status-publish","format-standard","hentry","category-product","category-compiere-garden-world"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/18364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/comments?post=18364"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/18364\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/media?parent=18364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/categories?post=18364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/tags?post=18364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}