Discussion

Difference between revisions of "Statement of Account"

(Created page with "== Statement of Account == ===== Exporting Statement of Account Records ===== # Under the Main Menu, Click '''Reports'''File:Reports.png|center|624x624px|link=https://docs...")
 
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
== Statement of Account ==
+
<div style="text-align: center;">[[Financial Statement]] | [[Statement of Account]]</div>
 +
==Statement of Account==
  
−
===== Exporting Statement of Account Records =====
+
====Statement of Account Menu====
 +
[[File:Financial Statements - Statement of Account - Record List.png|center|1500x1500px]]
  
−
# Under the Main Menu, Click '''Reports'''[[File:Reports.png|center|624x624px|link=https://docs.oojeema.com/File:Reports.png]]
+
 
−
# Under Reports Menu, Click '''Statement of Accounts''' under Financial Statement Reports.[[File:Statement of Account(Export) - Step 2.png|center|623x623px]]<br />
+
'''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>
−
# Filter the desired Date and Customer for precise exportation of record. [[File:Statement of Account(Export) - Step 3.png|center|623x623px]]<br />
+
 
−
# 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.[[File:Statement of Account(Export) - Step 4.png|center|624x624px]]<br />
+
=====<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>
 +
*#[[Customer]]
 +
*#[[Sales Invoice]]
 +
*#[[Accounts Receivable]]
 +
*#[[Credit Voucher]]
 +
*#[[Receipt Voucher]]
 +
 
 +
{| 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:
 +
 
 +
*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.
 +
 
 +
=====<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'''
 +
|-
 +
|Financials
 +
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Credit Voucher]]<nowiki> | </nowiki>[[Receipt Voucher]]
 +
|-
 +
|Sales
 +
|[[Sales Invoice]]
 +
|- style="height:25px;"
 +
| style="" |Maintenance
 +
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Customer]]
 +
|- style="box-sizing: inherit;"
 +
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 +
|- style="box-sizing: inherit;"
 +
| style="" |Reports
 +
| style="" |[[Financial Statement]]
 +
|- style="box-sizing: inherit;"
 +
| style="" |Financial Statements
 +
| 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]]
 +
|}
 +
[[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"