Difference between revisions of "General Ledger"

(Changed categories.)
 
(11 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><br />
+
<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.
 +
 +
*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.
 +
 +
*List of Partners can be seen in [[Customer]] and [[Supplier]] Maintenance Module.
 +
|-
 +
|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.
 +
|}
  
General Ledger Menu Terms on Oojeema Prime System:
+
=====<span class="mw-headline" id="Exporting_General_Ledger" style="box-sizing: inherit;">Exporting General Ledger</span>=====
  
*'''Record Filters'''(Date Range, Project, Accounts(Start and End Range)) - refers on filters for quick research of records.
+
#Click [[Reports]] under Main Menu
*[[Account Codes|Account Code]] - reference number code for a specific accounting entry for transaction
+
#Under Reports Pageage, Click '''[[General Ledger]]''' under [[Financial Statement]] Reports.
*Account Name - the account name corresponds to its account code.
+
#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
*Transaction Date - The date where the voucher/transaction is created transact.
 
*Voucher No. - The reference number of the transaction.
 
*[[Project]] - the Project assigned in the voucher.
 
*[[Chart of Account|Account]] - the Accounting entry applied in the voucher.
 
*Description - Additional Notes on the corresponding voucher.
 
*Status - Status of the Voucher if it is '''POSTED''' or '''CANCELLED'''.
 
*Total Debit  - the Total Debit on the specific voucher.
 
*Total Credit - the Total Credit on the specific voucher.
 
  
{| 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 - 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>=====
 +
 
 +
#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
 +
 
 +
[[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>[[Project]]
+
| 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 35: 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>[[Project 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