Difference between revisions of "General Ledger"

(Changed categories.)
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="text-align: center;">[[Financial Statement]] | [[Income Statement]] | [[Trial Balance]] | [[Income Statement Aids]]</div>
+
<div style="text-align: center;">
 +
[[Financial Statement]] | [[Income Statement]] | [[Trial Balance]]  
 +
</div>
 
==General Ledger==
 
==General Ledger==
  
 
======General Ledger Menu======
 
======General Ledger Menu======
[[File:General Ledger Menu.png|center|thumb|1000x1000px|General Ledger Menu]]
+
[[File:Financial Statements - General Ledger - Record List.png|border|center|1500x1500px]]
  
  
 
'''General Ledger''' refers to an overview of all the transactions for all accounts for a given period. It also represents the record of company's financial data with debit and credit accounts which has been validated by the [[Trial Balance]].
 
'''General Ledger''' refers to an overview of all the transactions for all accounts for a given period. It also represents the record of company's financial data with debit and credit accounts which has been validated by the [[Trial Balance]].
 +
{| class="wikitable" style="margin: auto;"
 +
|+General Ledger Menu Terms on Oojeema Prime System:
 +
!Field
 +
!Description
 +
|-
 +
|1. '''Record Filters'''(Date Range, Project, Accounts(Start and End Range))
 +
|refers on filters for quick research of records.
  
General Ledger Menu Terms on Oojeema Prime System:
+
*Date Range will be set on Current date and year by default
 +
*Project will be filtered automatically to None by default
 +
*Start and End accounts will be automatically filtered to None by default
 +
|-
 +
|2. Export
 +
|Allows the user to Export the report into spreadsheet
 +
|-
 +
|3. '''[[Account Code]]'''
 +
|Reference number code for a specific accounting entry for transaction
 +
|-
 +
|4. '''Account Name'''
 +
|The account name corresponds to its account code.
 +
|-
 +
|5. '''Transaction Date'''
 +
|The date where the voucher/transaction is created.
 +
|-
 +
|6. '''Voucher No'''
 +
|The reference number of the transaction.
 +
|-
 +
|7. [[Chart of Account|'''Account''']]
 +
|the Accounting entry applied in the voucher.
 +
|-
 +
|8. '''Check No.'''
 +
|the reference check number on the assigned voucher.
 +
|-
 +
|9. '''Partner'''
 +
|the partner assigned on the specific voucher.
  
#'''Record Filters'''(Date Range, Project, Accounts(Start and End Range)) - refers on filters for quick research of records.
+
*List of Partners can be seen in [[Customer]] and [[Supplier]] Maintenance Module.
#[[Account Codes|'''Account Code''']] - reference number code for a specific accounting entry for transaction
+
|-
#'''Account Name''' - the account name corresponds to its account code.
+
|10. '''Description'''
#'''Transaction Date''' - The date where the voucher/transaction is created transact.
+
|Additional Notes on the corresponding voucher.
#'''Voucher No'''. - The reference number of the transaction.
+
|-
#'''[[Project]]''' - the Project assigned in the voucher.
+
|11. '''Status'''
#[[Chart of Account|'''Account''']] - the Accounting entry applied in the voucher.
+
|Status of the Voucher if it is '''POSTED''' or '''CANCELLED'''.
#'''Check No.''' - the reference check number on the assigned voucher.
+
|-
#'''Partner''' - the partner assigned on the specific voucher.
+
|12. '''Total Debit'''
#*List of Partners can be seen in [[Customer]] and [[Supplier]] Maintenance Module.
+
|the Total Debit on the specific voucher.
#'''Description''' - Additional Notes on the corresponding voucher.
+
|-
#'''Status''' - Status of the Voucher if it is '''POSTED''' or '''CANCELLED'''.
+
|13. '''Total Credit'''
#'''Total Debit''' - the Total Debit on the specific voucher.
+
|the Total Credit on the specific voucher.
#'''Total Credit''' - the Total Credit on the specific voucher.
+
|}
 +
 
 +
=====<span class="mw-headline" id="Exporting_General_Ledger" style="box-sizing: inherit;">Exporting General Ledger</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Pageage, Click '''[[General Ledger]]''' under [[Financial Statement]] Reports.
 +
#Under General Ledger, click the Export Button on the right side. Take note that the user can filter the date and the accounts from start and of range for precise exportation of records
  
Notes:
+
[[File:Financial Statements - General Ledger - Export.png|border|center|3247x3247px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_General_Ledger" style="box-sizing: inherit;">Viewing Vouchers on General Ledger</span>=====
  
*For detailed instructions on how to Export and how to view the Reference Voucher. The user can visit the General Ledger Job Aids which can be found [[General Ledger Aids|here]].
+
#Under the Main Menu, Click '''[[Reports]]'''
 +
#Under Reports Menu, Click '''[[General Ledger]]''' under Financial Statement Reports.
 +
#Under General Ledger, click the reference links under Voucher No. column to check the records corresponding to the specific accounts on a given date.
 +
#*The user may edit the [[Receipt Voucher]] as long as it is not POSTED.
 +
#*The user may edit the [[Payment Voucher]] as long as its not POSTED
  
{| 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: 1em 0px; 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-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; text-align: start;"
+
[[File:Financial Statements - General Ledger - View.png|border|center|3263x3263px]]
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
 
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
 +
|-
 +
|Financials
 +
|[[Accounts Payable]]<nowiki> | </nowiki>[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
| style="" |Maintenance
 
| style="" |Maintenance
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Account Code]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Customer]]<nowiki> | </nowiki>[[Project]]<nowiki> | </nowiki>[[Supplier]]
+
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Account Code]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Customer]]<nowiki> | </nowiki>[[Supplier]]
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
Line 41: Line 93:
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |Financial Statements
 
| style="" |Financial Statements
| style="" |[[Balance Sheet]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Ledger]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Payable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register]]
+
| style="" |[[Balance Sheet]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement]] <span style="color: rgb(34, 34, 34)"><nowiki>| </nowiki>[[Profit and Loss Statement]]<nowiki> |</nowiki></span> [[General Ledger]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]] [[Accounts Payable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register]]
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance Aids
 
| style="" |[[Account Codes Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Customer Aids]]<nowiki> | </nowiki>[[Project Aids]]<nowiki> | </nowiki>[[Supplier Aids]]
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Aid'''
 
|- style="box-sizing: inherit;"
 
| style="" |Financial Statements
 
| style="" |[[Balance Sheet Aids]]<nowiki> | </nowiki>[[Income Statement Aids]]<nowiki> | </nowiki>[[General Ledger Aids]]<nowiki> | </nowiki>[[General Journal Aids]]<nowiki> | </nowiki>[[Trial Balance Aids]]<nowiki> | </nowiki>[[Statement of Account Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aging Aids]]<nowiki> | </nowiki>[[AR Detailed Report Aids]]<nowiki> | </nowiki>[[AR Transaction Report Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aging Aids]]<nowiki> | </nowiki>[[AP Detailed Report Aids]]<nowiki> | </nowiki>[[AR Transaction Report Aids]]<nowiki> | </nowiki>[[Accounts Payable Aging Aids]]<nowiki> | </nowiki>[[AP Detailed Report Aids]]<nowiki> | </nowiki>[[AP Transaction Report Aids]]<nowiki> | </nowiki>[[Cash Position Aids&action=view&action=view|Cash Position Aids]]<nowiki> | </nowiki>[[Check List Aids]]<nowiki> | </nowiki>[[Deposit List Aids]]<nowiki> | </nowiki>[[Collection Register Aids]]
 
 
|}
 
|}
 +
[[Category:Sales]]
 +
[[Category:Purchase]]
 +
[[Category:Financials]]
 +
[[Category:Financial Statements]]

Latest revision as of 12:04, 7 April 2022

General Ledger

General Ledger Menu
Financial Statements - General Ledger - Record List.png


General Ledger refers to an overview of all the transactions for all accounts for a given period. It also represents the record of company's financial data with debit and credit accounts which has been validated by the Trial Balance.

General Ledger Menu Terms on Oojeema Prime System:
Field Description
1. Record Filters(Date Range, Project, Accounts(Start and End Range)) refers on filters for quick research of records.
  • Date Range will be set on Current date and year by default
  • Project will be filtered automatically to None by default
  • Start and End accounts will be automatically filtered to None by default
2. Export Allows the user to Export the report into spreadsheet
3. Account Code Reference number code for a specific accounting entry for transaction
4. Account Name The account name corresponds to its account code.
5. Transaction Date The date where the voucher/transaction is created.
6. Voucher No The reference number of the transaction.
7. Account the Accounting entry applied in the voucher.
8. Check No. the reference check number on the assigned voucher.
9. Partner the partner assigned on the specific voucher.
10. Description Additional Notes on the corresponding voucher.
11. Status Status of the Voucher if it is POSTED or CANCELLED.
12. Total Debit the Total Debit on the specific voucher.
13. Total Credit the Total Credit on the specific voucher.
Exporting General Ledger
  1. Click Reports under Main Menu
  2. Under Reports Pageage, Click General Ledger under Financial Statement Reports.
  3. Under General Ledger, click the Export Button on the right side. Take note that the user can filter the date and the accounts from start and of range for precise exportation of records
Financial Statements - General Ledger - Export.png


Viewing Vouchers on General Ledger
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click General Ledger under Financial Statement Reports.
  3. Under General Ledger, click the reference links under Voucher No. column to check the records corresponding to the specific accounts on a given date.
Financial Statements - General Ledger - View.png


Modules
Financials Accounts Payable | Accounts Receivable | Receipt Voucher | Payment Voucher
Maintenance Maintenance | Account Code | Chart of Account | Customer | Supplier
Reports Module (Reports)
Reports Financial Statement
Financial Statements Balance Sheet | Income Statement | Profit and Loss Statement | General Ledger | General Journal | Trial Balance | Statement of Account | Accounts Receivable Aging | AR Detailed Report | AR Transaction Report Accounts Payable Aging | AP Detailed Report | AP Transaction Report | Cash Position | Check List | Deposit List | Collection Register