Difference between revisions of "General Ledger"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financial Statement]] | [[Income Statement]] | [[Trial Balance]] | [[Income Statement Aids]]
+
[[Financial Statement]] | [[Income Statement]] | [[Trial Balance]]  
 
</div>
 
</div>
 
==General Ledger==
 
==General Ledger==
  
 
======General Ledger Menu======
 
======General Ledger Menu======
[[File:General Ledger Menu.png|center|thumb|1221x1221px|General Ledger Menu]]
 
  
  
 
'''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"
+
{| class="wikitable" style="margin: auto;"
 
|+General Ledger Menu Terms on Oojeema Prime System:
 
|+General Ledger Menu Terms on Oojeema Prime System:
 
!Field
 
!Field
Line 17: Line 16:
 
|refers on filters for quick research of records.
 
|refers on filters for quick research of records.
  
* Date Range will be set on Current date and year by default
+
*Date Range will be set on Current date and year by default
* Project will be filtered automatically to None by default
+
*Project will be filtered automatically to None by default
* Start and End accounts will be automatically filtered to None by default
+
*Start and End accounts will be automatically filtered to None by default
 
|-
 
|-
 
|2. Export
 
|2. Export
Line 62: Line 61:
 
|the Total Credit on the specific voucher.
 
|the Total Credit on the specific voucher.
 
|}
 
|}
Notes:
 
  
*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]].
+
===== <span class="mw-headline" id="Exporting_General_Ledger" style="box-sizing: inherit;">Exporting General Ledger</span> =====
  
{| 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;"
+
# Under the Main Menu, Click '''[[Reports]]'''
 +
# Under Reports Menu, Click '''[[General Ledger]]''' under [[Financial Statement]] Reports.
 +
# Under General Ledger, click the Export Button on the right side. Take note that you can filter the Date Range, Project and Start and end Range of Chart of Accounts for precise exportation of records.
 +
 
 +
===== <span class="mw-headline" id="Viewing_Vouchers_on_General_Ledger" style="box-sizing: inherit;">Viewing Vouchers on General Ledger</span> =====
 +
 
 +
# Under the Main Menu, Click '''[[Reports]]'''
 +
# Under Reports Menu, Click '''[[General Ledger]]''' under Financial Statement Reports.
 +
# Under [[General Ledger]], Check the Voucher Number Column, you will see the voucher list with links for a specific date. Click on the voucher number to redirect you to the View mode of the selected Voucher.
 +
 
 +
{| 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'''
 
|- 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 79: Line 87:
 
| 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]] [[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></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]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Ledger Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Payable Aging Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register Aids]]
 
 
|}
 
|}

Revision as of 12:30, 22 December 2021

General Ledger

General Ledger Menu

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. Project the Project assigned in the voucher.
8. Account the Accounting entry applied in the voucher.
9. Check No. the reference check number on the assigned voucher.
10. Partner the partner assigned on the specific voucher.
11. Description Additional Notes on the corresponding voucher.
12. Status Status of the Voucher if it is POSTED or CANCELLED.
13. Total Debit the Total Debit on the specific voucher.
14. Total Credit the Total Credit on the specific voucher.
Exporting 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 Export Button on the right side. Take note that you can filter the Date Range, Project and Start and end Range of Chart of Accounts for precise exportation of records.
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, Check the Voucher Number Column, you will see the voucher list with links for a specific date. Click on the voucher number to redirect you to the View mode of the selected Voucher.
Modules
Maintenance Maintenance | Account Code | Chart of Account | Customer | Supplier
Reports Module (Reports)
Reports Financial Statement
Financial Statements Balance Sheet | Income 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