Difference between revisions of "Trial Balance"

Line 5: Line 5:
  
 
====Trial Balance Menu====
 
====Trial Balance Menu====
 +
[[File:Financial Statements - Trial Balance - Menu.png|center|1702x1702px]]
 +
 +
 
'''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)
 
'''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" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 52: Line 55:
 
|Overall balanced on the specific period.
 
|Overall balanced on the specific period.
 
|}<br />
 
|}<br />
 +
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Income_Statement_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"><span class="mw-headline ve-pasteProtect" id="Exporting_Balance_Sheet_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Trial Balance Records</span></span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click [[Trial Balance]] under Financial Statements section
 +
#Under Trial Balance, click the Export Button on the right side. Take note that the user can filter the date for precise exportation of records.
 +
 +
[[File:Financial Statements - Trial Balance - Export.png|border|center|4137x4137px]]
 +
 +
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Income_Statement_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"><span class="mw-headline ve-pasteProtect" id="Exporting_Balance_Sheet_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Viewing Debit in Trial Balance Records</span></span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click [[Trial Balance]] under Financial Statements section
 +
#<span style="color: rgb(51, 51, 51)">Under Trial Balance, click the amount links under Total Debit column to check the records corresponding to the specific records on a given date.</span>
 +
#Under Detailed Debit View, the user may click on the reference link  under Reference Column to view a specific record.
 +
 +
[[File:Financial Statements - Trial Balance - View Debit.png|border|center|3826x3826px]]
 +
<br />
 +
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Income_Statement_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"><span class="mw-headline ve-pasteProtect" id="Exporting_Balance_Sheet_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Debit Details in Trial Balance Records</span></span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click [[Trial Balance]] under Financial Statements section
 +
#<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Under Trial Balance, click the amount links under Total Debit column to check the records corresponding to the specific records on a given date.</span>
 +
#Under Detailed Debit Details, Click Export
 +
 +
[[File:Financial Statements - Trial Balance - Export Debit.png|border|center|3609x3609px]]
 +
 +
 +
 +
<br />
 +
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Income_Statement_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"><span class="mw-headline ve-pasteProtect" id="Exporting_Balance_Sheet_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Viewing Credit in Trial Balance Records</span></span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click [[Trial Balance]] under Financial Statements section
 +
#<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Under Trial Balance, click the amount links under Total Credit column to check the records corresponding to the specific records on a given date.</span>
 +
#Under Detailed Credit View, the user may click on the reference link  under Reference Column to view a specific record.
 +
 +
[[File:Financial Statements - Trial Balance - View Credits.png|border|center|3817x3817px]]
 +
 +
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Income_Statement_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"><span class="mw-headline ve-pasteProtect" id="Exporting_Balance_Sheet_Records" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Credit in Trial Balance Records</span></span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click [[Trial Balance]] under Financial Statements section
 +
#<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Under Trial Balance, click the amount links under Total Credit column to check the records corresponding to the specific records on a given date.</span>
 +
#Under Detailed Credit View, Click Export
 +
 +
<br />
 +
[[File:Financial Statements - Trial Balance - Export Credit.png|center|3445x3445px]]
 +
 +
 +
 +
<br />
 
====Closing Period Menu====
 
====Closing Period Menu====
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 71: Line 125:
 
|}
 
|}
  
===== Closing Period Breakdown =====
+
=====Closing Period Breakdown=====
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
 
|+Closing of Period Breakdown Terms under Closing Period Menu
 
|+Closing of Period Breakdown Terms under Closing Period Menu
Line 110: Line 164:
 
|}
 
|}
  
===== <span class="mw-headline" id="Closing_a_Period.28Monthly.29" style="box-sizing: inherit;">Closing a Period(Monthly)</span> =====
+
=====<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]]'''
+
#Click [[Reports]] under Main Menu
# Under Reports Menu, Click '''[[Trial Balance]]''' under [[Financial Statement]] Reports
+
#Under Reports Page, Click '''[[Trial Balance]]''' under [[Financial Statement]] Reports
# Click '''Close Period''' on the upper right corner of the screen.
+
#Under Trial Balance, Click '''Close Period''' on the upper right corner of the screen.
# Add notes for additional information then click '''Save'''
+
#Add notes for additional information then click '''Save'''
# Double Check the Statements then click '''confirm''' to complete the process
+
#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]].
+
#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> =====
+
=====<span class="mw-headline" id="Closing_a_Period.28Yearly.29" style="box-sizing: inherit;">Closing a Period(Yearly)</span>=====
 
Notes:
 
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
+
*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
+
#Add notes if needed
# Click '''Save'''
+
#Click '''Save'''
# Double Check the Statements then click '''confirm''' to complete the process
+
#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.]]
+
#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:
 
Notes:
  
* 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
  
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 138: Line 192:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Journal Voucher]]
+
|[[Journal Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]<nowiki> | </nowiki>[[Receipt Voucher]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
| style="" |Maintenance
 
| style="" |Maintenance

Revision as of 12:05, 31 March 2022

Trial Balance

Trial Balance Menu

Financial Statements - Trial Balance - Menu.png


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.


Exporting Trial Balance Records
  1. Click Reports under Main Menu
  2. Under Reports page, click Trial Balance under Financial Statements section
  3. Under Trial Balance, click the Export Button on the right side. Take note that the user can filter the date for precise exportation of records.
Financial Statements - Trial Balance - Export.png
Viewing Debit in Trial Balance Records
  1. Click Reports under Main Menu
  2. Under Reports page, click Trial Balance under Financial Statements section
  3. Under Trial Balance, click the amount links under Total Debit column to check the records corresponding to the specific records on a given date.
  4. Under Detailed Debit View, the user may click on the reference link under Reference Column to view a specific record.
Financial Statements - Trial Balance - View Debit.png


Exporting Debit Details in Trial Balance Records
  1. Click Reports under Main Menu
  2. Under Reports page, click Trial Balance under Financial Statements section
  3. Under Trial Balance, click the amount links under Total Debit column to check the records corresponding to the specific records on a given date.
  4. Under Detailed Debit Details, Click Export
Financial Statements - Trial Balance - Export Debit.png



Viewing Credit in Trial Balance Records
  1. Click Reports under Main Menu
  2. Under Reports page, click Trial Balance under Financial Statements section
  3. Under Trial Balance, click the amount links under Total Credit column to check the records corresponding to the specific records on a given date.
  4. Under Detailed Credit View, the user may click on the reference link under Reference Column to view a specific record.
Financial Statements - Trial Balance - View Credits.png
Exporting Credit in Trial Balance Records
  1. Click Reports under Main Menu
  2. Under Reports page, click Trial Balance under Financial Statements section
  3. Under Trial Balance, click the amount links under Total Credit column to check the records corresponding to the specific records on a given date.
  4. Under Detailed Credit View, Click Export


Financial Statements - Trial Balance - Export Credit.png



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. Click Reports under Main Menu
  2. Under Reports Page, Click Trial Balance under Financial Statement Reports
  3. Under Trial Balance, 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 | Payment Voucher | Receipt 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