Difference between revisions of "Collection Register"

(Changed categories.)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="text-align: center;">[[Financial Statement]] | [[Collection Register]] | [[Collection Register Aids]]</div>
+
<div style="text-align: center;">[[Financial Statement]] | [[Collection Register]]</div>
  
 
==Collection Register==
 
==Collection Register==
  
======Collection Register Menu======
+
=====Collection Register Menu=====
 +
[[File:Financial Statements - Collection Register - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 
'''Collection Register''' <span style="color: rgb(51, 51, 51)">refers to the list of Received Payment in a given period of time.</span>
 
'''Collection Register''' <span style="color: rgb(51, 51, 51)">refers to the list of Received Payment in a given period of time.</span>
 +
{| class="wikitable" style="margin: auto;"
 +
|+Collection Register Terms in Oojeema Prime System
 +
!Field
 +
!Description
 +
|-
 +
|1. '''Export'''
 +
|Allows the user to Export the record into spreadsheet
 +
|-
 +
|2. '''Record Filter'''(Date Range, Customer, Payment Option, Search Bar)
 +
|Set of Record Filters for precise searching of Records.
 +
|-
 +
|3. '''Date'''
 +
|Date when the Voucher was created
 +
|-
 +
|4. '''Voucher No.'''
 +
|Reference No for the specific Voucher
 +
|-
 +
|5. '''[[Customer]]'''
 +
|Name of the Customer in the Voucher
 +
|-
 +
|6. '''Payment Details'''
 +
|Type of Payment issued on the Voucher(Cash/Check)
 +
|-
 +
|7. '''Cheque Details'''
 +
|Details of Cheque issued
 +
|-
 +
|8. '''Payment Date'''
 +
|Date when the Voucher was paid and posted
 +
|-
 +
|9. '''Amount'''
 +
|Total amount of payment issued
 +
|-
 +
|10. '''Cash'''
 +
|The status of Cash in the Summary Portion of Collection Register
  
Collection Register Terms in Oojeema Prime System
+
*Total Issued - Total Number of Issued Vouchers using Cash as Payment
 +
*Total Amount - The total amount of all Vouchers using Cash as Payment
 +
|-
 +
|11. '''Dated Check'''
 +
|Written Checks for the Voucher up to this date.
 +
 
 +
*Total Issued - Total Number of Issued Vouchers that used Dated Check
 +
*Total Amount - The total amount of all Vouchers that used Dated Check
 +
|-
 +
|12. '''PDC(Post Date Check)'''
 +
|Check that will be written or issued for the future Date.
 +
 
 +
*Total Issued - Total Number of Issued Voucher that has Post Dated Check
 +
*Total Amount - Total Amount of all Vouchers that has Post Dated Check
 +
|-
 +
|13. '''Total Provisional Receipts Issued'''
 +
|Overall Number and Amount of All Receipts Accumulated from Cash, Dated Check and Post Dated Checks.
 +
|}
  
#'''Record Filter'''(Date Range, Customer, Payment Option, Search Bar) - Set of Record Filters for precise searching of Records.
 
#'''Date -''' Date when the Voucher was created
 
#'''Voucher No.''' - Reference No for the specific Voucher
 
#'''[[Customer]]'''  - Name of the Customer in the Voucher
 
#'''Payment Details''' - Type of Payment issued on the Voucher(Cash/Check)
 
#'''Cheque Details''' - Details of Cheque issued
 
#'''Payment Date''' - Date when the Voucher was paid and posted
 
#'''Amount''' - Total amount of payment issued
 
#'''Cash''' - The status of Cash in the Summary Portion of Collection Register
 
#*Total Issued - Total Number of Issued Vouchers using Cash as Payment
 
#*Total Amount - The total amount of all Vouchers using Cash as Payment
 
#'''Dated Check''' - Written Checks for the Voucher up to this date.
 
#*Total Issued - Total Number of Issued Vouchers that used Dated Check
 
#*Total Amount - The total amount of all Vouchers that used Dated Check
 
#'''PDC(Post Dated Check)''' - Check that will be written or issued for the future Date.
 
#*Total Issued - Total Number of Issued Voucher that has Post Dated Check
 
#*Total Amount - Total Amount of all Vouchers that has Post Dated Check
 
#'''Total Provisional Receipts Issued''' - Overall Number and Amount of All Receipts Accumulated from Cash, Dated Check and Post Dated Checks.
 
  
 
Notes:
 
Notes:
Line 33: Line 69:
 
**Customer Status can be seen in [[Customer]] Maintenance Module.
 
**Customer Status can be seen in [[Customer]] Maintenance Module.
  
*For Further Instructions on how to Export and View Vouchers in the Collection Register Report, the user may visit the Collection Register Job Aid which can be found [[Collection Register Aids|here]]
+
#Under the Main Menu, Click '''[[Reports]]'''
 +
#Under Reports Menu, Click '''[[Collection Register]]''' under [[Financial Statement]] Reports.
 +
#Under [[Collection Register]], click the '''Export Button''' on the right side. Take note that you can filter the date range, the mode of payment and the customer for precise exportation of records.
 +
 
 +
=====<span class="mw-headline" id="Viewing_Vouchers_of_Collection_Register" style="box-sizing: inherit;">Viewing Vouchers of Collection Register</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under [[Reports]] Page, Click '''[[Collection Register]]''' under [[Financial Statement]] Reports
 +
#Under Collection Register, click the Export Button on the right side. Take note that you can filter the Date, Partner and the Payment Details or searching in search bar for precise exportation of records.
 +
 
 +
[[File:Financial Statements - Collection Register - View.png|border|center|2280x2280px]]
 +
 
 +
 
 +
Notes:
 +
 
 +
*The system will redirect the user to the Print Version of the voucher when checking the Voucher details in the Collection Register
  
<br />
+
=====<span class="mw-headline" id="Exporting_Checks_for_Deposit_List" style="box-sizing: inherit;"><span class="mw-headline" id="Exporting_Deposit_List" style="box-sizing: inherit;">Exporting Collection Register Record</span></span>=====
======Collection Register View Voucher======
 
[[File:Collection Register View Voucher.png|center|thumb|796x796px|Collection Register View Voucher]]Notes:
 
  
*The system will redirect the user to the Print Version of the voucher when checking the Voucher details in the Collection Register Menu.
+
#Click [[Reports]] under Main Menu
*For detailed instructions on how to View Vouchers, the user may visit Collection Register Job Aid which can be found [[Collection Register Aids|here]]
+
#Under Reports Page, Click <span>Collection Register</span> under [[Financial Statement]] Reports.
 +
#Under Collection Register, click the Export Button on the right side. Take note that you can filter the Date, Partner and the Payment Details or searching in search bar for precise exportation of records.
  
{| 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-align: start; 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;"
+
[[File:Financial Statements - Collection Register - Export .png|border|center|2479x2479px]]
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
 
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
 
! 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 59: Line 111:
 
| 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]] <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="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|- style="box-sizing: inherit;"
 
| style="" |Financials Aids
 
| style="" |[[Receipt 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]]<nowiki> | </nowiki>[[Income Statement Aids]]<nowiki> | </nowiki>[[General Ledger Aids]]<nowiki> | </nowiki>[[General Journal Aids]]<nowiki> | </nowiki>[[Trial Balance Aids]]<nowiki> | </nowiki>[[Statement of Account Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aging Aids]]<nowiki> | </nowiki>[[AR Detailed Report Aids]]<nowiki> | </nowiki>[[AR Transaction Report Aids]]<nowiki> | </nowiki>[[Accounts Payable Aging Aids]]<nowiki> | </nowiki>[[AP Detailed Report Aids]]<nowiki> | </nowiki>[[AP Transaction Report Aids]]<nowiki> | </nowiki>[[Cash Position Aids]]<nowiki> | </nowiki>[[Check List Aids]]<nowiki> | </nowiki>[[Deposit List Aids]]<nowiki> | </nowiki>[[Collection Register Aids]]
 
 
|}
 
|}
 +
[[Category:Financial Statements]]
 +
[[Category:Financials]]
 +
[[Category:Sales]]

Latest revision as of 12:13, 7 April 2022

Collection Register

Collection Register Menu
Financial Statements - Collection Register - Record List.png


Collection Register refers to the list of Received Payment in a given period of time.

Collection Register Terms in Oojeema Prime System
Field Description
1. Export Allows the user to Export the record into spreadsheet
2. Record Filter(Date Range, Customer, Payment Option, Search Bar) Set of Record Filters for precise searching of Records.
3. Date Date when the Voucher was created
4. Voucher No. Reference No for the specific Voucher
5. Customer Name of the Customer in the Voucher
6. Payment Details Type of Payment issued on the Voucher(Cash/Check)
7. Cheque Details Details of Cheque issued
8. Payment Date Date when the Voucher was paid and posted
9. Amount Total amount of payment issued
10. Cash The status of Cash in the Summary Portion of Collection Register
  • Total Issued - Total Number of Issued Vouchers using Cash as Payment
  • Total Amount - The total amount of all Vouchers using Cash as Payment
11. Dated Check Written Checks for the Voucher up to this date.
  • Total Issued - Total Number of Issued Vouchers that used Dated Check
  • Total Amount - The total amount of all Vouchers that used Dated Check
12. PDC(Post Date Check) Check that will be written or issued for the future Date.
  • Total Issued - Total Number of Issued Voucher that has Post Dated Check
  • Total Amount - Total Amount of all Vouchers that has Post Dated Check
13. Total Provisional Receipts Issued Overall Number and Amount of All Receipts Accumulated from Cash, Dated Check and Post Dated Checks.


Notes:

  • The user can chose multiple Filter Options from the record filters(Example: Multiple Customer Filter Records, Multiple Payment Option Filter Records etc.)
  • The Customer status must be ACTIVE in order to use it as a filter to view the Records.
    • Customer Status can be seen in Customer Maintenance Module.
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Collection Register under Financial Statement Reports.
  3. Under Collection Register, click the Export Button on the right side. Take note that you can filter the date range, the mode of payment and the customer for precise exportation of records.
Viewing Vouchers of Collection Register
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Collection Register under Financial Statement Reports
  3. Under Collection Register, click the Export Button on the right side. Take note that you can filter the Date, Partner and the Payment Details or searching in search bar for precise exportation of records.
Financial Statements - Collection Register - View.png


Notes:

  • The system will redirect the user to the Print Version of the voucher when checking the Voucher details in the Collection Register
Exporting Collection Register Record
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Collection Register under Financial Statement Reports.
  3. Under Collection Register, click the Export Button on the right side. Take note that you can filter the Date, Partner and the Payment Details or searching in search bar for precise exportation of records.
Financial Statements - Collection Register - Export .png


Categories:
Modules
Financials Receipt 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