Difference between revisions of "Statement of Account"

(Tag: 2017 source edit)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="text-align: center;">[[Financial Statement]] | [[Statement of Account]] | [[Statement of Account Aids]]</div>
+
<div style="text-align: center;">[[Financial Statement]] | [[Statement of Account]]</div>
 
==Statement of Account==
 
==Statement of Account==
  
 
====Statement of Account Menu====
 
====Statement of Account Menu====
'''Statement of Account'''  r<span style="color: rgb(51, 51, 51)">efers to a detailed report of the contents of an account. Statement of Accounts refers on the created individual statements for the [[Customers]].</span>
+
[[File:Financial Statements - Statement of Account - Record List.png|center|1500x1500px]]
  
===== <span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Statement of Account</span> =====
 
  
* The user should have the following records in order to proceed on using the <span>Statement of Account</span>
+
'''Statement of Account'''  r<span style="color: rgb(51, 51, 51)">efers to a detailed report of the contents of an account. Statement of Accounts refers on the created individual statements for the [[Customer]].</span>
*# [[Customer]]
+
 
*# [[Sales Invoice]]
+
=====<span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Statement of Account</span>=====
*# [[Accounts Receivable]]
+
 
 +
*The user should have the following records in order to proceed on using the <span>Statement of Account</span>
 +
*#[[Customer]]
 +
*#[[Sales Invoice]]
 +
*#[[Accounts Receivable]]
 +
*#[[Credit Voucher]]
 +
*#[[Receipt Voucher]]
  
[[File:Statement of Account Menu.png|center|thumb|870x870px|Statement of Account Menu]]
 
 
{| class="wikitable"
 
{| class="wikitable"
 
|+Statement of Account Terms on Oojeema Prime:
 
|+Statement of Account Terms on Oojeema Prime:
Line 36: Line 40:
 
|-
 
|-
 
|6. '''Type'''
 
|6. '''Type'''
|The nature of Invoice Reference of the Transaction. It can be a Payment/Invoice ([[Accounts Receivable]]) ,Over Payment([[Receipt Voucher]]), [[Credit Voucher|Credit Memo]] or Advance Payment([[Credit Voucher]])
+
|The nature of Invoice Reference of the Transaction. It can be a Payment/Invoice ([[Accounts Receivable]]), Over Payment([[Receipt Voucher]]), or Advance Payment([[Credit Voucher]])
 
|-
 
|-
 
|7. '''Reference No'''.
 
|7. '''Reference No'''.
Line 55: Line 59:
 
Notes:
 
Notes:
  
*For further details on how to export the Statement of Accounts for a specific customer, the user may visit the Statement of Account Job Aids which can be found [[Statement of Account Aids|here.]]
 
 
*Customers must be on '''ACTIVE''' status in order to view its status on Statement of Accounts.
 
*Customers must be on '''ACTIVE''' status in order to view its status on Statement of Accounts.
 
**Customer status can be seen in [[Customer]] Maintenance Module.
 
**Customer status can be seen in [[Customer]] Maintenance Module.
  
===== <span class="mw-headline" id="Exporting_Statement_of_Account_Records" style="box-sizing: inherit;">Filtering Records and Exporting Statement of Account Records</span> =====
+
=====<span class="mw-headline" id="Exporting_Statement_of_Account_Records" style="box-sizing: inherit;">Filtering Records and Exporting Statement of Account Records</span>=====
  
# Under the Main Menu, Click '''[[Reports]]'''
+
#Click [[Reports]] under Main Menu
# Under Reports Menu, Click '''[[Statement of Account|Statement of Accounts]]''' under [[Financial Statement]] Reports.
+
#Under Reports Page, Click '''[[Statement of Account|Statement of Accounts]]''' under [[Financial Statement]] Reports.
# Filter the desired Date and Customer for precise exportation of record.
+
#Under Statement of Account screen, filter the following fields
# After filtering Date and Customer, the system will present the statement of accounts on that date and customer. Click '''Export''' '''button''' at the right side.
+
#Click Export
  
{| 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;"  style="margin: auto;"
+
[[File:Financial Statements - Statement of Account - Export.png|border|center|2301x2301px]]
 +
<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
 
|Financials
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Credit Memo]]<nowiki> | </nowiki>[[Credit Voucher]]
+
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Credit Voucher]]<nowiki> | </nowiki>[[Receipt Voucher]]
 +
|-
 +
|Sales
 +
|[[Sales Invoice]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
| style="" |Maintenance
 
| style="" |Maintenance
Line 81: Line 89:
 
|- 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]]<nowiki> | </nowiki>[[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]]<nowiki> | </nowiki>[[Profit and Loss 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]]<nowiki> | </nowiki>[[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
 
|[[Accounts Receivable Aids]]<nowiki> | </nowiki>[[Credit Memo Aids]]<nowiki> | </nowiki>[[Credit Voucher Aids]]
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance Aids
 
| style="" |[[Customer Aids]]
 
 
|}
 
|}
 +
[[Category:Financial Statements]]

Latest revision as of 10:25, 26 April 2022

Statement of Account

Statement of Account Menu

Financial Statements - Statement of Account - Record List.png


Statement of Account refers to a detailed report of the contents of an account. Statement of Accounts refers on the created individual statements for the Customer.

Requirements before using Statement of Account
Statement of Account Terms on Oojeema Prime:
Field Description
1. Record Filters(Customer, Date Range) refers on filters for quick research of records.
  • The user must filter the customer first in order to use the Statement of Accounts.
2. Export Allows the user to Export the Report into Spreadsheet
3. Transaction Date Date when the transaction is created.
4. Due Date Date when the transaction should be paid.
5. Invoice No The reference no of the Transaction.
6. Type The nature of Invoice Reference of the Transaction. It can be a Payment/Invoice (Accounts Receivable), Over Payment(Receipt Voucher), or Advance Payment(Credit Voucher)
7. Reference No. The reference No for the Type of Reference Transaction.
8. Description any remarks regarding the said Transaction.
9. Previous Balance(Forwarded) any balance on an account that has been carried over from the previous statement to the current statement.
10. Amount any amount to be added or deducted to the Balance..
11. Balance the remaining Balance for this Statement

Notes:

  • Customers must be on ACTIVE status in order to view its status on Statement of Accounts.
    • Customer status can be seen in Customer Maintenance Module.
Filtering Records and Exporting Statement of Account Records
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Statement of Accounts under Financial Statement Reports.
  3. Under Statement of Account screen, filter the following fields
  4. Click Export
Financial Statements - Statement of Account - Export.png


Modules
Financials Accounts Receivable | Credit Voucher | Receipt Voucher
Sales Sales Invoice
Maintenance Maintenance | Customer
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