Difference between revisions of "Chart of Account"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Maintenance]] | [[Account Class]] | [[Account Codes]] | [[Chart of Accounts Aids]]
+
[[Maintenance]] | [[Account Class]] | [[Account Codes]]
 
</div>
 
</div>
 
==Chart of Account==
 
==Chart of Account==
Line 6: Line 6:
  
 
=====Chart of Account Record List=====
 
=====Chart of Account Record List=====
[[File:Prime - Chart of Account - Record List.png|center|1000x1000px]]
 
<br />
 
 
=====Adding Chart of Account=====
 
=====Adding Chart of Account=====
[[File:Prime - Chart of Account - Add.png|center|1000x1000px]]
+
1. Click Chart of Account under Maintenance Module
<br />
+
 
{| class="wikitable"
+
2. Under Chart of Account Menu Screen, Click Add Chart of Account
 +
 
 +
3. Fill out the necessary fields then click Save.
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 24: Line 25:
 
|<span style="color: rgb(34, 34, 34)">•Alphanumeric</span>
 
|<span style="color: rgb(34, 34, 34)">•Alphanumeric</span>
 
|-
 
|-
|3.Account Class
+
|3.[[Account Class]]
 
|<span style="color: rgb(34, 34, 34)">•Class of the Account</span>
 
|<span style="color: rgb(34, 34, 34)">•Class of the Account</span>
 
|<span style="color: rgb(34, 34, 34)">•Account Class List provided in Account Class Maintenance Module</span>
 
|<span style="color: rgb(34, 34, 34)">•Account Class List provided in Account Class Maintenance Module</span>
Line 50: Line 51:
  
 
=====Editing Chart of Account=====
 
=====Editing Chart of Account=====
[[File:Prime - Chart of Account - Edit.png|center|1000x1000px]]
+
1. Click Chart of Account under Maintenance Module
<br />
+
 
{| class="wikitable"
+
2. Select a Chart of Account that needs to update its details. Click the drop-down arrow then click Edit.
 +
 
 +
3. Update the necessary fields then click Save.
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 65: Line 69:
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Alphanumeric</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Alphanumeric</span>
 
|-
 
|-
|3.Account Class
+
|3.[[Account Class]]
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Class of the Account</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Class of the Account</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Account Class List provided in Account Class Maintenance Module</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Account Class List provided in Account Class Maintenance Module</span>
Line 84: Line 88:
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Nature of Account if it is Debit or Credit</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Nature of Account if it is Debit or Credit</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Debit/Credit</span>
 
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Debit/Credit</span>
|}
+
|}<br />
Notes:
+
=====Importing and Exporting Chart of Accounts=====
 
+
1. Under Chart of Account Screen, Click Options
*Detailed instructions on how to edit a Chart of Account, you can visit the Chart of Account Job Aids which can be found [[Chart of Accounts Aids|here]]
 
  
=====Chart of Account Options=====
+
2. Under Options, The user may Export or Import The Record
[[File:Prime - Chart of Account - Option List.png|center|724x724px]]
 
  
 +
* When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
 +
* When Importing the records, the user should follow the following steps provided in the Importing Chart of Account Screen such as
 +
** Downloading the template link provided under Step 1.
 +
** Filling up the information needed for each columns of the template
 +
** Uploading the updated Template
  
Notes:
+
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Chart of Account Import Details
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Field'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Description'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Allowed Inputs'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Input Restrictions'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Required Field?'''
 +
|- style="box-sizing: inherit;"
 +
| style="" |1.Account Code
 +
| style="" |Reference Code for the Account
 +
| style="vertical-align:middle;text-align:left;" |*Alphanumeric
 +
<nowiki>*</nowiki>Dash ""-""
  
*Detailed instructions on how to Export and Import a Chart of Account, you can visit the Chart of Account Job Aids which can be found [[Chart of Accounts Aids|here]]
+
<nowiki>*</nowiki>Underscore ""_""
 +
| style="" |*Up to 15 characters
 +
<nowiki>*</nowiki>Other Special Characters
  
=====Chart of Account Importing Option=====
+
<nowiki>*</nowiki>Space"
[[File:Prime - Chart of Account - Importing Option.png|center|869x869px]]
+
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |2.Account Name
 +
| style="" |Name of the Account
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" |*Up to 200 characters
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |3.Account Class
 +
| style="" |Class of the Account
 +
| style="" |*Account Class List provided in Account Class Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |4.FS Presentation
 +
| style="" |Presentation of Financial Statements
 +
| style="" |*Balance Sheet
 +
<nowiki>*</nowiki>Income Statement
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |5.Account Type
 +
| style="" |Type of Account
 +
| style="" |*Child
 +
<nowiki>*</nowiki>Parent
  
 +
<nowiki>*</nowiki>Both
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |6.Parent Account
 +
| style="" |Parent Account related on the Account
 +
| style="" |*Existing Chart of Account Record whose Account Type is ""Parent"" or ""Both""
 +
<nowiki>*</nowiki>Account Code of the Parent Class provided in the Chart of Account Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |7.Account Nature
 +
| style="" |Nature of Account if it is Debit or Credit
 +
| style="" |*Debit
 +
<nowiki>*</nowiki>Credit
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|}
  
 +
=====Chart of Account Record Option=====
 +
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Actions Available base from Chart of Account Record Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Edit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Deactivate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Activate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Delete
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''ACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''INACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|}
 
Notes:
 
Notes:
 
*Detailed instructions on how to import a Chart of Account, you can visit the Chart of Account Job Aids which can be found [[Chart of Accounts Aids|here]]
 
 
=====Chart of Account Record Option=====
 
[[File:Chart of Account Record Option.png|center|Chart of Account Record Option|178x178px]]Notes:
 
  
 
*Charts of accounts are important when creating or editing the following Module since it needs accounting details to proceed with the transaction
 
*Charts of accounts are important when creating or editing the following Module since it needs accounting details to proceed with the transaction
 
**[[Accounts Payable]]
 
**[[Accounts Payable]]
 
**[[Accounts Receivable]]
 
**[[Accounts Receivable]]
**[[Debit Memo]]
 
**[[Credit Memo]]
 
 
**[[Disbursement Voucher]]
 
**[[Disbursement Voucher]]
 
**[[Journal Voucher]]
 
**[[Journal Voucher]]
Line 120: Line 200:
  
 
*The list of accounts can be used as long as its status is '''ACTIVE'''
 
*The list of accounts can be used as long as its status is '''ACTIVE'''
 +
*The user has an option to Edit the details when viewing the record.
 
*'''INACTIVE''' accounts cannot be used in the transaction but the '''INACTIVE''' accounts on the past transactions can still use it.
 
*'''INACTIVE''' accounts cannot be used in the transaction but the '''INACTIVE''' accounts on the past transactions can still use it.
  
*Detailed instructions on how to View, Edit, Deactivate/Activate and delete a Chart of Account, you can visit the Chart of Account Job Aids which can be found [[Chart of Accounts Aids|here]]
+
{| class="wikitable" style="margin: auto;"
 
 
=====Chart of Account View Record=====
 
[[File:Prime - Chart of Account - View.png|center|1000x1000px]]
 
 
 
 
 
Notes:
 
 
 
*The user has an option to Edit the details when viewing the record.
 
 
 
*Detailed instructions on how to view a Chart of Account, you can visit the Chart of Account Job Aids which can be found [[Chart of Accounts Aids|here]]
 
 
 
{| class="wikitable"
 
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 142: Line 211:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Accounts Payable]]<nowiki> | </nowiki>[[Accounts Receivable]]<nowiki> | </nowiki>[[Credit Memo]]<nowiki> | </nowiki>[[Debit Memo]]<nowiki> | </nowiki>[[Disbursement Voucher]]<nowiki> | </nowiki>[[Journal Voucher]]<nowiki> | </nowiki>[[Petty Cash]]<nowiki> | </nowiki>[[Payment Voucher]]<nowiki> | </nowiki>[[Receipt Voucher]]
+
|[[Accounts Payable]]<nowiki> | </nowiki>[[Accounts Receivable]]<nowiki> | </nowiki>[[Disbursement Voucher]]<nowiki> | </nowiki>[[Journal Voucher]]<nowiki> | </nowiki>[[Petty Cash]]<nowiki> | </nowiki>[[Payment Voucher]]<nowiki> | </nowiki>[[Receipt Voucher]]
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports'''
Line 148: Line 217:
 
|Financial Statements
 
|Financial Statements
 
|[[Balance Sheet]]<nowiki> | </nowiki>[[Income Statement]]
 
|[[Balance Sheet]]<nowiki> | </nowiki>[[Income Statement]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Maintenance Aids
 
|[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Account Codes Aids]]<nowiki> | </nowiki>[[Proforma Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
|-
 
|Financials Aids
 
|[[Accounts Payable Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aids]]<nowiki> | </nowiki>[[Credit Memo Aids]]<nowiki> | </nowiki>[[Debit Memo Aids]]<nowiki> | </nowiki>[[Disbursement Voucher Aids]]<nowiki> | </nowiki>[[Journal Voucher Aids]]<nowiki> | </nowiki>[[Petty Cash Aids]]<nowiki> | </nowiki>[[Payment Voucher Aids]]<nowiki> | </nowiki>[[Receipt Voucher Aids]]
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Job Aid'''
 
|-
 
|Financial Statements Aids
 
|[[Balance Sheet Aids]]<nowiki> | </nowiki>[[Income Statement Aids]]
 
 
|}
 
|}

Revision as of 14:03, 15 December 2021

Chart of Account

A chart of accounts is a list of the categories used by an organization to classify and distinguish financial assets, liabilities, and transactions

Chart of Account Record List
Adding Chart of Account

1. Click Chart of Account under Maintenance Module

2. Under Chart of Account Menu Screen, Click Add Chart of Account

3. Fill out the necessary fields then click Save.

Field Description Expected Values
1.Account Code •Reference Code for the Account •Alphanumeric
2.Account Name •Name of the Account •Alphanumeric
3.Account Class •Class of the Account •Account Class List provided in Account Class Maintenance Module
4.FS Presentation •Presentation of Financial Statements •Balance Sheet/Income Statement
5.Account Type •Type of Account •Child/Parent/Both
6.Parent Account Title •Parent Account related on the Account •Parent Account Title List
7.Account Nature •Nature of Account if it is Debit or Credit •Debit/Credit

Notes:

  • When creating a Chart of Accounts, account class field is required, make sure to check the Account Class module first when creating a Chart of Accounts
  • Detailed instructions on how to create a Chart of Account, you can visit the Chart of Account Job Aids which can be found here
Editing Chart of Account

1. Click Chart of Account under Maintenance Module

2. Select a Chart of Account that needs to update its details. Click the drop-down arrow then click Edit.

3. Update the necessary fields then click Save.

Field Description Expected Values
1.Account Code •Reference Code for the Account •Alphanumeric
2.Account Name •Name of the Account •Alphanumeric
3.Account Class •Class of the Account •Account Class List provided in Account Class Maintenance Module
4.FS Presentation •Presentation of Financial Statements •Balance Sheet/Income Statement
5.Account Type •Type of Account •Child/Parent/Both
6.Parent Account Title •Parent Account related on the Account •Parent Account Title List
7.Account Nature •Nature of Account if it is Debit or Credit •Debit/Credit


Importing and Exporting Chart of Accounts

1. Under Chart of Account Screen, Click Options

2. Under Options, The user may Export or Import The Record

  • When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
  • When Importing the records, the user should follow the following steps provided in the Importing Chart of Account Screen such as
    • Downloading the template link provided under Step 1.
    • Filling up the information needed for each columns of the template
    • Uploading the updated Template
Chart of Account Import Details
Field Description Allowed Inputs Input Restrictions Required Field?
1.Account Code Reference Code for the Account *Alphanumeric

*Dash ""-""

*Underscore ""_""

*Up to 15 characters

*Other Special Characters

*Space"

Yes
2.Account Name Name of the Account *Alphanumeric

*Special Characters

*Up to 200 characters Yes
3.Account Class Class of the Account *Account Class List provided in Account Class Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
4.FS Presentation Presentation of Financial Statements *Balance Sheet

*Income Statement

*Any inputs not mentioned in the allowed inputs Yes
5.Account Type Type of Account *Child

*Parent

*Both

*Any inputs not mentioned in the allowed inputs Yes
6.Parent Account Parent Account related on the Account *Existing Chart of Account Record whose Account Type is ""Parent"" or ""Both""

*Account Code of the Parent Class provided in the Chart of Account Maintenance Module

*Any inputs not mentioned in the allowed inputs No
7.Account Nature Nature of Account if it is Debit or Credit *Debit

*Credit

*Any inputs not mentioned in the allowed inputs Yes
Chart of Account Record Option
Actions Available base from Chart of Account Record Status
Status View Edit Deactivate Activate Delete
ACTIVE
INACTIVE

Notes:

  • The list of accounts can be used as long as its status is ACTIVE
  • The user has an option to Edit the details when viewing the record.
  • INACTIVE accounts cannot be used in the transaction but the INACTIVE accounts on the past transactions can still use it.
Categories:
Modules
Maintenance Maintenance | Chart of Account | Account Class | Account Codes | Proforma | Tax
Financials Accounts Payable | Accounts Receivable | Disbursement Voucher | Journal Voucher | Petty Cash | Payment Voucher | Receipt Voucher
Reports
Financial Statements Balance Sheet | Income Statement