Chart of Accounts
The Chart of Accounts is an essential component of financial management operations in a company. It is a list of all the financial accounts a business uses to keep track of its income, expenses, assets, liabilities, and equity. The Chart of Accounts typically includes asset accounts such as cash, accounts receivable, inventory, and fixed assets; liability accounts such as_ accounts payable_ and loans; and equity accounts like sales and expenses accounts such as cost of goods sold and operating expenses.
See More about Accounting Concepts
A Chart of accounts has a crucial role in accounting as it defines the structure of the accounts used in the financial reports. It is a key tool for tracking the financial health of a business and allows users to quickly assess their overall performances. It also helps to ensure that financial transactions are accurately and correctly reported.
It will support the creation, edit and view of all financial accounts easily and also make it possible to customize and manage your financial statements and reports.The Chart of accounts is an important tool for financial reporting, as it helps to ensure that financial transactions are recorded in the correct accounts.
PerfectWORK’s Chart of accounts is a standard, double-entry bookkeeping system comprising balance sheets, income statements, and other accounts. It is customizable allowing you to create your own accounts and categories, as well as configure the system to meet your specific accounting requirements. The system will always make certain that the records of your financial operations remain excellent and able to use future requirements. The main and first thing that you initiate your accounting and financial management with the PerfectWORK accounting system is the configuration of the Chart of Accounts. It is just because all the future operations are determined based on it. PerfectWORK provides the provision to create a custom chart of accounts based upon the business needs and which will be a great support for having complete governance of the management of the financial operations.
Configuration¶
It is very simple to define the chart of accounts in Odoo. you just need to select the Chart of Account menu in the Accounting section available under the Configuration tab of the PerfectWORK Accounting module as shown in the image below.
The chart of accounts (COA) is the list of all the accounts used to record financial transactions in the general ledger of an organization.
The accounts are usually listed in the order of appearance in the financial reports. Most of the time, they are listed as follows :
-
Balance Sheet accounts:
-
Assets
-
Liabilities
-
Equity
-
-
Profit & Loss:
-
Income
-
Expense
-
When browsing your chart of accounts, you can filter the accounts by number, in the left column, and also group them by Account Type.
Fiscal Localization¶
The country you select at the creation of your database (or additional company on your database) determines which fiscal localization package is installed by default. This package includes a standard chart of accounts already configured according to the country’s regulations. You can use it directly or set it according to your company’s needs.
Warning
It is not possible to modify the fiscal localization of a company once a journal entry has been posted.
To create a new account, go to , click on Create, and fill out the form.
Code and name¶
Each account is identified by its code and name, which also indicates the account’s purpose.
Type¶
Correctly configuring the account type is critical as it serves multiple purposes:
-
Information on the account’s purpose and behavior
-
Generate country-specific legal and financial reports
-
Set the rules to close a fiscal year
-
Generate opening entries
To configure an account type, open the Type field’s drop-down selector and select the right type among the following list:
Report | Category | Account Types |
---|---|---|
Balance Sheet | Assets | Receivables |
Bank and Cash | ||
Current Assets | ||
Non Current Assets | ||
Prepayments | ||
Fixed Assets | ||
Liabilities | Payable | |
Credit Card | ||
Current Liabilities | ||
Non Current Liabilities | ||
Profit & Loss | Income | Income |
Other Income | ||
Expense | Expense | |
Depreciation | ||
Cost of Revenue | ||
Other | Other | Off-Balance Sheet |
Assets, deferred expenses, and deferred revenues automation¶
Some account types display a new field to automate the creation of assets entries, deferred expenses entries, and deferred revenues entries.
You have three choices for the Automation field:
-
No: this is the default value. Nothing happens.
-
Create in draft: whenever a transaction is posted on the account, a draft entry is created, but not validated. You must first fill out the corresponding form.
-
Create and validate: you must also select a model. Whenever a transaction is posted on the account, an entry is created and immediately validated.
Default taxes¶
Select a default tax that will be applied when this account is chosen for a product sale or purchase.
Tags¶
Some accounting reports require tags to be set on the relevant accounts. By default, you can choose among the tags that are used by the Cash Flow Statement.
Account groups¶
Account groups are useful to list multiple accounts as sub-accounts of a bigger account and thus consolidate reports such as the Trial Balance. By default, groups are handled automatically based on the code of the group. For example, a new account 131200
is going to be part of the group 131000
.
Create account groups manually¶
Note
Regular users should not need to create account groups manually. The following section is only intended for rare and advanced use cases.
To create a new account group, developer mode and head to . Here, create a new group and enter the name, code prefix, and company to which that group account should be available. Note that you must enter the same code prefix in both From and to fields.
To display your Trial Balance report with your account groups, go to , then open the Options menu and select Hierarchy and Subtotals.
Allow reconciliation¶
Some accounts, such as accounts made to record the transactions of a payment method, can be used for the reconciliation of journal entries.
For example, an invoice paid with a credit card can be marked as paid if reconciled with its payment. Therefore, the account used to record credit card payments needs to be configured as allowing reconciliation.
To do so, check the Allow Reconciliation box in the account’s settings, and save.
Deprecated¶
It is not possible to delete an account once a transaction has been recorded on it. You can make them unusable by using the Deprecated feature.
To do so, check the Deprecated box in the account’s settings, and save.
Purpose¶
This documentation outlines the processes associated with a Chart of Accounts in the Accounting application of PerfectWORK 15.
A Chart of Accounts is a listing of all accounts used in the general ledger of an organization. The Chart of Accounts should be tailored to reflect the actual operations of a company and an organization has the freedom to add or remove accounts, as needed, to better suit its needs.
Process
To get started, navigate to the Accounting app.
Configuring the Chart of Accounts¶
Good to Know!¶
Why Is My Chart of Accounts is Empty?¶
If you get to the Chart of Accounts page but see nothing listed, you'll need to go into Configuration > Settings and click Install More Packages. From there, install the default accounts for your country.
When you're done, go back to the settings page and, under Fiscal Localization, set the Package to "Configurable Account Chart Template".
Click Save. You should now see accounts listed in your Chart of Accounts.
Down the left-hand side, you have the ability to view numerical ranges using the index marks. For example, clicking 1 will expand indexing to the next character (10, 11, 12, etc.) allowing you to filter directly to the range you need.
To simplify this view, click Group By > Account Type. This helps to narrow down to the specific accounts you're looking for.
Working with Default Accounts¶
To give an idea of where you'll see these accounts used throughout PerfectWORK, click configuration > Management > Product categories and select a category from the list.
At the bottom of this page, you'll see the Account Properties. The accounts listed in these fields are created and configured in the Chart of Accounts, and this category happens to use PerfectWORK's default settings from the configuration.
You can see the accounts under Account Properties, for example, are set to use generalized accounts: Product Sales & Expenses. These accounts have very basic settings that allow you to use PerfectWORK relatively quickly without having to go into every product category and select all of your custom accounts.
Because PerfectWORK has so many pre-configured accounts, it's best practice to determine the existing default account, then edit the account's number and/or name accordingly.
For example, PerfectWORK's default Product Sales account is already mapped to all product categories and expense accounts within PerfectWORK. By deprecating (disabling) this account and creating a new account, you'll then need to update all related categories and accounts affected by the change. To avoid this extra work, you only need to map your existing accounts to PerfectWORK's default accounts.
In our example, we'll map the 400000 Product Sales account from PerfectWORK with our own corresponding account, 400002 Retail Sales.
To get started, we'll click Configuration > Accounting > Chart of Accounts, then click SETUP to the right of Product Sales.
Once there, click EDIT and change the settings to match your business's settings.
When done, click Save.
Now, when we go look at the same product category we opened above, we'll see the changes we've made. We accomplished this by simply editing a default account, and now there's no need to re-configure each category manually. This is a huge time saver!
Deleting an Account¶
Important!¶
Delete vs. Deprecate¶
In a production environment with existing data, you should not delete an account. Instead, Edit the account and, select the Deprecated checkbox, then click Save.
Deprecated accounts will still show up in your list view of accounts unless you filter them out, but they can no longer be selected throughout PerfectWORK.
If you still wish to delete an account after reading the warning above, simply click the checkbox to the left of the account's code, in list view, then click Action > Delete.
You will see this message asking you to confirm your intention to delete. You can click OK to continue.
If an account has recorded journal items, you'll see the following message.
If an account is set as a default in the system, you'll see the following message.
You'll need to deprecate the account instead, which we covered in the Important section, above.
Creating a New Account¶
From the list view of accounts, click Create. This opens a new line for you to add basic information:
-
Code: A unique number that helps in the identification of the account type and may also be coded with further information. This is an alphanumeric fields that can also accommodate hyphens, decimals, and spaces.
-
Account Name: The name of the account.
-
Type: The type of account, which is detailed below in the 'Choosing an Account Type' section.
-
Allow Reconciliation: Check this box if this account allows invoices and payments matching of journal items. When enabled, it will display the RECONCILE button.
When these fields are complete, click Save.
Once saved, click SETUP to the far right of the new entry to open it in form view.
From within the account, click EDIT to add any additional information.
-
Type: This required field is used to define the financial reports on which the account will be included, and where the accounts will appear on those reports. Also, the fields listed in this window will change based on the type selected.
-
Default Taxes: If default taxes should apply to this account, select them here. This will auto-populate based on your app configuration.
-
Tags: Optional keywords that assist in custom reporting.
-
Allowed Journals: Define which journal(s) this account can be used for. Leave it empty for all journals.
-
Account Currency: If your system is set for multiple currencies, select what is appropriate for this account here.
-
Allow Reconciliation: Checking the box here sets the account's entries as available to be reconciled (or matched) to other entries. This is used in reconciling bank statements, matching vendor payments to vendor bills, cash receipts to customer invoices, etc.
-
Deprecated: Use this as an alternative to deletion to indicate the account is no longer in use.
-
Group: If your system has been set up to use Account Groups, then this field will indicate into which account group this account falls as set by its account number. Account Groups assist in the organization and filtering your accounts, and will also create subsections on your financial reports.
-
Company: If you have multiple companies set up, set the company to which this account belongs.
When finished, click SAVE.
Choosing an Account Type¶
Choosing the correct Account Type is extremely important as they affect your overall reporting.¶
Assets | |
Receivable | Record funds owed to you (Example: For products or services delivered) |
Bank and Cash | Record bank and cash transfer transactions |
Current Assets | All assets that can be reasonably expected to be converted into cash within one year |
Non-current Assets | Long-term investments where the full value will not be realized within the accounting year |
Prepayments | An asset account that stores partial payments from customers that still owe money |
Fixed Assets | Record assets and property that cannot be easily converted into cash (These will not be used up, consumed, or sold within the current accounting year) |
Liabilities | |
Payable | Record funds you owe (Example: Bills from suppliers) |
Credit Card | A bank account that is considered to be a liability |
Current Liabilities | Financial obligations that are payable within one year |
Non-current Liabilities | Financial obligations that will not become due within the accounting year |
Equity | |
Equity | Record capital gains and losses (To measure the net worth of your business) |
Current Year Earnings | Record net income or loss for your company within the current year (The difference between all revenues and expenses on an income statement) |
Profit & Loss Income | |
Income | Record income that comes from your company's main business (Example: Sales Revenue) |
Other Income | Record income that does not come from your company's main business (Example: Interest) |
Profit & Loss Expense | |
Expense | Record outflow of funds to pay for goods and services your business uses |
Depreciation | An expense that comes from a Fixed Asset account |
Cost of Revenue | Record total cost incurred to obtain a sale and the cost of the goods or services sold, often referred to as 'Direct Costs' (Example: The cost of materials, equipment, or labor used in production) |
Other | |
Off-Balance Sheet | Useful for annual reporting annexes |
View Journal Items for Each Account¶
Navigate back to CONFIGURATION > Accounting > CHART OF ACCOUNTS and click SETUP next to an entry from the list.
From within the Account record, you have the option to view Unreconciled Entries and Journal Items by clicking the Balance smart button. Note that the current balance of this account is displayed on the smart button as well.
Once there you can use the Filters to narrow down your view. This helps when you want to see common results, such as Posted, UnPosted, Unreconciled items, etc.
Good to Know!¶
Stock Interim Accounts¶
PerfectWORK has two preconfigured accounts that you may not recognize.
-
Stock Interim (Received): This account is to record goods received that are not yet billed.
-
Stock Interim (Delivered): This account is to record goods delivered that are not yet invoiced.
Because PerfectWORK uses double-entry accounting, these act as temporary accounts to track stock in either of these scenarios.