Discussion

Difference between revisions of "Statement of Account"

 
(9 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><br />
+
<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====
−
[[File:Statement of Account Menu.png|center|thumb|870x870px|Statement of Account Menu]]
+
[[File:Financial Statements - Statement of Account - Record List.png|center|1500x1500px]]
−
'''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>
+
 
 +
 
 +
'''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>
  
−
Statement of Account Terms on Oojeema Prime.
+
=====<span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Statement of Account</span>=====
  
−
#'''Record Filters'''(Customer, Date Range) - refers on filters for quick research of records.
+
*The user should have the following records in order to proceed on using the <span>Statement of Account</span>
−
#*The user must filter the customer first in order to use the Statement of Accounts.
+
*#[[Customer]]
−
#'''Transaction Date''' - Date when the transaction is created.
+
*#[[Sales Invoice]]
−
#'''Due Date''' - Date when the transaction should be paid.
+
*#[[Accounts Receivable]]
−
#'''Invoice No'''. - The reference no of the Transaction.
+
*#[[Credit Voucher]]
−
#'''Type''' - The nature of Invoice Reference of the Transaction. It can be a Payment/Invoice ([[Accounts Receivable]]) ,Over Payment([[Receipt Voucher]]), [[Credit Memo]] or Advance Payment([[Credit Voucher]])
+
*#[[Receipt Voucher]]
−
#'''Reference No'''. - The reference No for the Type of Reference Transaction.
 
−
#'''Description''' - any remarks regarding the said Transaction.
 
−
#'''Previous Balance'''(Forwarded) - any balance on an account that has been carried over from the previous statement to the current statement.
 
−
#'''Amount''' - any amount to be added or deducted to the Balance..
 
−
#'''Balance''' - the remaining Balance for this Statement
 
  
 +
{| class="wikitable"
 +
|+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:
 
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.
  
−
{| 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;"
+
=====<span class="mw-headline" id="Exporting_Statement_of_Account_Records" style="box-sizing: inherit;">Filtering Records and Exporting Statement of Account Records</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Statement of Account|Statement of Accounts]]''' under [[Financial Statement]] Reports.
 +
#Under Statement of Account screen, filter the following fields
 +
#Click Export
 +
 
 +
[[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 42: 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]] [[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]]
 
−
|- 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]]
 
 
|}
 
|}
 +
[[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
Retrieved from "https://docs.oojeema.com/index.php?title=Statement_of_Account&oldid=6760"