Difference between revisions of "Statement of Account"

(Tag: 2017 source edit)
Line 3: Line 3:
  
 
====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>
+
'''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>
 +
 
 +
===== <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]]
 +
 
 
[[File:Statement of Account Menu.png|center|thumb|870x870px|Statement of Account Menu]]
 
[[File:Statement of Account Menu.png|center|thumb|870x870px|Statement of Account Menu]]
 
{| class="wikitable"
 
{| class="wikitable"
Line 51: Line 59:
 
**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> =====
 +
 
 +
# Under the Main Menu, Click '''[[Reports]]'''
 +
# Under Reports Menu, Click '''[[Statement of Account|Statement of Accounts]]''' under [[Financial Statement]] Reports.
 +
# Filter the desired Date and Customer for precise exportation of record.
 +
# 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.
 +
 
 +
{| 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;"
 
! 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 75: Line 90:
 
| style="" |Maintenance Aids
 
| style="" |Maintenance Aids
 
| style="" |[[Customer 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]]
 
 
|}
 
|}

Revision as of 10:42, 2 December 2021

Statement of Account

Statement of Account Menu

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 Customers.

Requirements before using Statement of Account
File:Statement of Account Menu.png
Statement of Account Menu
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), Credit Memo 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:

  • 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 here.
  • 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. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Statement of Accounts under Financial Statement Reports.
  3. Filter the desired Date and Customer for precise exportation of record.
  4. 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.
Modules
Financials Accounts Receivable | Credit Memo | Credit Voucher
Maintenance Maintenance | Customer
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
Job Aid Modules
Financials Aids Accounts Receivable Aids | Credit Memo Aids | Credit Voucher Aids
Maintenance Aids Customer Aids