Difference between revisions of "Trial Balance"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financial Statement]] | [[Trial Balance]] | [[Income Statement]] | [[Trial Balance Aids]]
+
[[Financial Statement]] | [[Trial Balance]] | [[Income Statement]]
</div><br />
+
</div>
 
==Trial Balance==
 
==Trial Balance==
  
 
====Trial Balance Menu====
 
====Trial Balance Menu====
[[File:Trial Balance Menu.png|center|thumb|1150x1150px|Trial Balance Menu]]'''Trial Balance''' refers to an overview of balances of the chart of accounts(Debit and Credit) in a given period(Monthly and Yearly).
+
'''Trial Balance''' refers to an overview of balances of the [[Chart of Account|Chart of accounts]](Debit and Credit) in a given period(Monthly and Yearly)
{| class="wikitable"
+
{| class="wikitable" style="margin: auto;"
 
|+Trial Balance Menu Terms on Oojeema Prime System:
 
|+Trial Balance Menu Terms on Oojeema Prime System:
 
!Field
 
!Field
Line 17: Line 17:
 
|Refers to a process to verify and adjust the balances of account to produce reports regarding company's financial position on that given period.
 
|Refers to a process to verify and adjust the balances of account to produce reports regarding company's financial position on that given period.
  
*Closing of Period will be done monthly. The [https://docs.oojeema.com/Journal_Voucher Journal Vouchers] created for the monthly period can still be adjusted.
+
*Closing of Period will be done monthly. The [[Journal Voucher]] created for the monthly period can still be adjusted.
 
*Upon Year-end Closing, All monthly periods on that year will be posted.
 
*Upon Year-end Closing, All monthly periods on that year will be posted.
 
*Upon Year-end Closing, You cannot cancel any monthly periods on that year.
 
*Upon Year-end Closing, You cannot cancel any monthly periods on that year.
Line 33: Line 33:
 
|Current Balance to be carry forward to the next Period.
 
|Current Balance to be carry forward to the next Period.
 
|-
 
|-
|7. '''Total Debit'''  
+
|7. '''Total Debit'''
 
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">the Total Debit on the specific Account Code.</span>
 
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">the Total Debit on the specific Account Code.</span>
  
*Clicking on the Amount link will redirect you to the set of reference on that specific [https://docs.oojeema.com/Account_Code Account Code].
+
*Clicking on the Amount link will redirect you to the set of reference on that specific [[Account Code]].
 
|-
 
|-
 
|8. '''Total Credit'''
 
|8. '''Total Credit'''
 
|the Total Credit on the specific Account Code.
 
|the Total Credit on the specific Account Code.
  
*Clicking on the Amount link will redirect you to the set of reference on that specific [https://docs.oojeema.com/Account_Code Account Code].
+
*Clicking on the Amount link will redirect you to the set of reference on that specific [[Account Code]].
 
|-
 
|-
 
|9. '''Balance for the Period'''
 
|9. '''Balance for the Period'''
Line 51: Line 51:
 
|11. '''Accumulated Balance'''
 
|11. '''Accumulated Balance'''
 
|Overall balanced on the specific period.
 
|Overall balanced on the specific period.
|}
+
|}<br />
Notes:
 
 
 
*For detailed Instructions on how to closed a period, Export Records and how to view the reference codes. The user can visit the Trial Balance Aids which can be found [[Trial Balance Aids|here]].
 
 
 
 
====Closing Period Menu====
 
====Closing Period Menu====
[[File:Closing of Period Menu.png|center|thumb|646x646px|Closing of Period Menu]]
+
{| class="wikitable" style="margin: auto;"
<br />
 
{| class="wikitable"
 
 
|+Closing of Period Terms under Trial Balance Menu
 
|+Closing of Period Terms under Trial Balance Menu
 
! style="width:15%;" |Field
 
! style="width:15%;" |Field
Line 71: Line 65:
 
|-
 
|-
 
| style="width:15%;" |2. '''Notes'''
 
| style="width:15%;" |2. '''Notes'''
|remarks before closing a Period.
+
|Any Remarks before closing a Period.
 
|-
 
|-
 
| style="width:15%;" |3. '''Closing Account'''
 
| style="width:15%;" |3. '''Closing Account'''
|the account to be close in the period.
+
|The account to be close in the period.
 
|}
 
|}
<br />[[File:Closing of Period Breakdown.png|center|thumb|528x528px|Closing of Period Breakdown]]
+
 
<br />
+
===== Closing Period Breakdown =====
{| class="wikitable"
+
{| class="wikitable" style="margin: auto;"
 
|+Closing of Period Breakdown Terms under Closing Period Menu
 
|+Closing of Period Breakdown Terms under Closing Period Menu
 
!Field
 
!Field
Line 86: Line 80:
 
|the reference number to be assigned once the Period has been closed.
 
|the reference number to be assigned once the Period has been closed.
  
* The [[Journal Voucher]] will be auto generated once period has been closed.
+
*The [[Journal Voucher]] will be auto generated once period has been closed.
 
|-
 
|-
 
|2. '''Transaction Date'''
 
|2. '''Transaction Date'''
Line 115: Line 109:
 
|Set of Amounts under Credit Accounts.
 
|Set of Amounts under Credit Accounts.
 
|}
 
|}
{| 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-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;"
+
 
 +
===== <span class="mw-headline" id="Closing_a_Period.28Monthly.29" style="box-sizing: inherit;">Closing a Period(Monthly)</span> =====
 +
 
 +
# Under the Main Menu, Click '''[[Reports]]'''
 +
# Under Reports Menu, Click '''[[Trial Balance]]''' under [[Financial Statement]] Reports
 +
# Click '''Close Period''' on the upper right corner of the screen.
 +
# Add notes for additional information then click '''Save'''
 +
# Double Check the Statements then click '''confirm''' to complete the process
 +
# There will be a confirmation prompt that the process is already saved. If click '''yes,''' it would automatically redirect you to Journal Voucher Menu to view the auto generated [[Journal Voucher]].
 +
 
 +
===== <span class="mw-headline" id="Closing_a_Period.28Yearly.29" style="box-sizing: inherit;">Closing a Period(Yearly)</span> =====
 +
Notes:
 +
 
 +
* If the user reaches the end of a Period (December on the case of Calendar), a modal will pop up right after the user clicks the Confirm button for the Month of December.  The Modal will display the Closing Period of January to December with a Closing Account of Retained Earnings
 +
 
 +
# Add notes if needed
 +
# Click '''Save'''
 +
# Double Check the Statements then click '''confirm''' to complete the process
 +
# There will be a confirmation prompt that the process is already saved. If click '''yes''', it would automatically redirect you to Journal Voucher Menu to view the auto generated [[Journal Voucher|Journal Voucher.]]
 +
 
 +
Notes:
 +
 
 +
* Upon Year-end Closing, All monthly periods on that year will be posted.
 +
* Upon Year-end Closing, You cannot cancel any monthly periods on that year
 +
 
 +
{| 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'''
 
|-
 
|-
Line 131: Line 150:
 
| 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'''
 
|-
 
|Financials Aids
 
|[[Journal Voucher Aids]]
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance Aids
 
| style="" |[[Account Codes Aids]]<nowiki> | </nowiki>[[Chart of Accounts 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 09:26, 23 December 2021

Trial Balance

Trial Balance Menu

Trial Balance refers to an overview of balances of the Chart of accounts(Debit and Credit) in a given period(Monthly and Yearly)

Trial Balance Menu Terms on Oojeema Prime System:
Field Description
1. Date Range gives the user a set of date range on how they will view their Balance Sheet.
2. Close Period Refers to a process to verify and adjust the balances of account to produce reports regarding company's financial position on that given period.
  • Closing of Period will be done monthly. The Journal Voucher created for the monthly period can still be adjusted.
  • Upon Year-end Closing, All monthly periods on that year will be posted.
  • Upon Year-end Closing, You cannot cancel any monthly periods on that year.
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. Previous Carryforward Previous Balance to be carryforward for the current Period.
6. Balance Carryforward Current Balance to be carry forward to the next Period.
7. Total Debit the Total Debit on the specific Account Code.
  • Clicking on the Amount link will redirect you to the set of reference on that specific Account Code.
8. Total Credit the Total Credit on the specific Account Code.
  • Clicking on the Amount link will redirect you to the set of reference on that specific Account Code.
9. Balance for the Period Current Balance for this current Period(Base from the Total Credit, Total Debit, and Carry forwards on the Trial Balance Sheet)
10. Closing list of Balance before closing
11. Accumulated Balance Overall balanced on the specific period.


Closing Period Menu

Closing of Period Terms under Trial Balance Menu
Field Description
1. Closing Period The set of period to be closed.
  • If the user reaches the end of a Period (December on the case of Calendar), a modal will pop up right after the user clicks the Confirm button for the Month of December.  The Modal will display the Closing Period of January to December with a Closing Account of Retained Earnings.
  • For year-end closing, the closing period will be indicated from January to December.
2. Notes Any Remarks before closing a Period.
3. Closing Account The account to be close in the period.
Closing Period Breakdown
Closing of Period Breakdown Terms under Closing Period Menu
Field Description
1. Voucher No the reference number to be assigned once the Period has been closed.
2. Transaction Date The assigned month to be closed.
  • For year-end closing, the Transaction date will be the last Day of the year.
3. Reference the reference of the date of book closing for the month.
  • For year-end closing, the reference will be Year end closing for the designated year
4. Notes any remarks for the closing Period.
5. Account Set of Accounts under Income Statement Entries.
6. Description Description for the specific Accounts.
7. Debit Set of amounts under Debit Accounts.
8. Credit Set of Amounts under Credit Accounts.
Closing a Period(Monthly)
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Trial Balance under Financial Statement Reports
  3. Click Close Period on the upper right corner of the screen.
  4. Add notes for additional information then click Save
  5. Double Check the Statements then click confirm to complete the process
  6. There will be a confirmation prompt that the process is already saved. If click yes, it would automatically redirect you to Journal Voucher Menu to view the auto generated Journal Voucher.
Closing a Period(Yearly)

Notes:

  • If the user reaches the end of a Period (December on the case of Calendar), a modal will pop up right after the user clicks the Confirm button for the Month of December.  The Modal will display the Closing Period of January to December with a Closing Account of Retained Earnings
  1. Add notes if needed
  2. Click Save
  3. Double Check the Statements then click confirm to complete the process
  4. There will be a confirmation prompt that the process is already saved. If click yes, it would automatically redirect you to Journal Voucher Menu to view the auto generated Journal Voucher.

Notes:

  • Upon Year-end Closing, All monthly periods on that year will be posted.
  • Upon Year-end Closing, You cannot cancel any monthly periods on that year
Modules
Financials Journal Voucher
Maintenance Maintenance | Account Code | Chart of Account
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