Difference between revisions of "Accounts Receivable Aging"

(Changed categories.)
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financial Statement]] | [[Accounts Receivable]] | [[Accounts Receivable Aging]] | [[Accounts Receivable Aging Aids]]
+
[[Financial Statement]] | [[Accounts Receivable]] | [[Accounts Receivable Aging]] | [[AR Detailed Report]] | [[AR Transaction Report]]
</div><br />
+
</div>
 
==Accounts Receivable Aging==
 
==Accounts Receivable Aging==
  
 
====Accounts Receivable Aging Menu====
 
====Accounts Receivable Aging Menu====
[[File:Accounts Receivable Aging Menu.png|center|thumb|866x866px|Accounts Receivable Aging Menu]]
+
[[File:Financial Statements - Accounts Receivable Aging - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 
'''Accounts Receivable Aging''' are list of [[Accounts Receivable]] that has not been paid by User. This report categorizes the set of invoice that has been outstanding over a specific period(can be within a month range, 2 months range or over 2 months)
 
'''Accounts Receivable Aging''' are list of [[Accounts Receivable]] that has not been paid by User. This report categorizes the set of invoice that has been outstanding over a specific period(can be within a month range, 2 months range or over 2 months)
  
Accounts Receivable Aging Menu Terms on Oojeema Prime System:
+
=====<span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Accounts Receivable Aging</span>=====
 +
 
 +
*The user should setup and have the following records in order to proceed on using the <span>Accounts Receivable Aging</span>
 +
*#[[Customer]]
 +
*#[[Accounts Receivable]]
 +
 
 +
{| class="wikitable" style="margin: auto;"
 +
|+Accounts Receivable Aging Menu Terms on Oojeema Prime System:
 +
!Field
 +
!Description
 +
|-
 +
|1. '''Record Filter'''(Customer and Date)
 +
|Set of filter record for precise search of records.
 +
 
 +
*Records will be defaulted to set on Filter All for customers and the current date for the Date Range.
 +
|-
 +
|2. '''Export'''
 +
|Allows the user to Export the report into Spreadsheet
 +
|-
 +
|3. '''[[Customer]]'''
 +
|The customer assigned for the specific Receivables.
 +
|-
 +
|4. '''Reference'''
 +
|The reference record for the Accounts Receivable of the Customer.
 +
 
 +
*Clicking the Receivables link will let the user view the status of the Receivable.
 +
|-
 +
|5. '''Transaction Date'''
 +
|The date when the Receivable is issued.
 +
|-
 +
|6. '''Terms'''
 +
|the set default days on the customer for them to pay their outstanding balance on their receivables.
 +
 
 +
*Aging will start when the days on the Terms are exceeded.
 +
*Default Terms can be edited through [[Customer]] Maintenance Module.
 +
|-
 +
|7. '''Due Date'''
 +
|The date on which the receivable should be paid.
  
#'''Record Filter'''(Customer and Date) -Set of filter record for precise search of records.
+
*Due dates will based on the Transaction date plus the Terms applied on the customer.
#*Records will be defaulted to set on Filter All for customers and the current date for the Date Range.
+
*If there are no Terms applied on the customer. The due date will be automatically set into 7 days after the Transaction Date.
#'''[[Customer]]''' - The customer assigned for the specific Receivables.
+
|-
#'''Reference''' - The reference record for the Accounts Receivable of the Customer.
+
|8. '''Current'''
#*Clicking the Receivables link will let the user view the status of the Receivable.
+
|The balance to be paid on the receivables during the span of Transaction date up to Expiration Date.
#'''Transaction Date''' - The date when the Receivable is issued.
+
|-
#'''Terms''' - the set default days on the customer for them to pay their outstanding balance on their receivables.
+
|9. '''Aging Range'''
#*Aging will start when the days on the Terms are exceeded.
+
|A range of days where the receivable exceeds to its due date.
#*Default Terms can be edited through [[Customer]] Maintenance Module.
 
#*This Terms is different from the [[Terms]] Maintenance Module.
 
#'''Due Date''' - The date on which the receivable should be paid.
 
#*Due dates will based on the Transaction date plus the Terms applied on the customer.
 
#*If there are no Terms applied on the customer. The due date will be automatically set into 7 days after the Transaction Date.
 
#'''Current''' - The balance to be paid on the receivables during the span of Transaction date up to Expiration Date.
 
#'''Aging Range''' - a range of days where the receivable exceeds to its due date.
 
#*Range will be categorized within 30 days , within 60 days and more than 60 days.
 
#'''Balance''' - the total amount to be paid on a specific Transaction.
 
  
 +
*Range will be categorized within 30 days , within 60 days and more than 60 days.
 +
|-
 +
|10. '''Balance'''
 +
|The total amount to be paid on a specific Transaction.
 +
|}
 
Notes:
 
Notes:
  
 
*Customer record must be '''ACTIVE''' status in order to check its receivable aging records.
 
*Customer record must be '''ACTIVE''' status in order to check its receivable aging records.
 
**Customer records can be seen in [[Customer]] Maintenance Module.
 
**Customer records can be seen in [[Customer]] Maintenance Module.
*For detailed instructions on how to view Receivables as well as how to Export the Aging Report. The user may visit the Accounts Receivable Aging Job aids which can be found [[Accounts Receivable Aging Aids|here]].
 
  
{| 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;"
+
=====<span class="mw-headline" id="Exporting_Accounts_Receivable_Aging" style="box-sizing: inherit;">Filtering Records and Exporting Accounts Receivable Aging</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Accounts Receivable Aging]]''' under [[Financial Statement]] Reports.
 +
#Under Accounts Receivable Aging, click the Export Button on the right side. Take note that the user can filter the date and the customer for precise exportation of records.
 +
 
 +
[[File:Financial Statement - Accounts Receivable Aging - Export.png|border|center|2020x2020px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_Accounts_Receivable_Aging" style="box-sizing: inherit;">Viewing Vouchers on Accounts Receivable Aging</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Accounts Receivable Aging]]''' under [[Financial Statement]] Reports.
 +
#Under Accounts Receivable Aging, click the reference links under reference column to check the records corresponding to the customer’s transaction on a specific date.
 +
#*The user may Received the payment when viewing a specific [[Accounts Receivable]] record.
 +
#*The user may tag a [[Profit Center]] when viewing a specific Accounts Receivable record
 +
#**The user may only tag a [[Profit Center]] if the status is not yet Posted
 +
 
 +
[[File:Financial Statements - Accounts Receivable Aging - View.png|border|center|2162x2162px]]
 +
<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]]
+
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
| style="" |Maintenance
 
| style="" |Maintenance
| style="" |[[Maintenance]]<nowiki> | </nowiki><span>[[Customer]]</span>
+
| style="" |[[Maintenance]]<nowiki> | </nowiki><span>[[Customer]]<nowiki> | </nowiki>[[Profit Center]]</span>
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
Line 49: Line 102:
 
|- 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
 
|[[Accounts Receivable 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]]
 
 
|}
 
|}
 
<br />
 
<br />
 +
 +
[[Category:Financials]]
 +
[[Category:Financial Statements]]
 +
[[Category:Sales]]
 +
[[Category:Sales Reports]]
 +
[[Category:Billing]]

Latest revision as of 10:04, 8 April 2022

Accounts Receivable Aging

Accounts Receivable Aging Menu

Financial Statements - Accounts Receivable Aging - Record List.png


Accounts Receivable Aging are list of Accounts Receivable that has not been paid by User. This report categorizes the set of invoice that has been outstanding over a specific period(can be within a month range, 2 months range or over 2 months)

Requirements before using Accounts Receivable Aging
  • The user should setup and have the following records in order to proceed on using the Accounts Receivable Aging
    1. Customer
    2. Accounts Receivable
Accounts Receivable Aging Menu Terms on Oojeema Prime System:
Field Description
1. Record Filter(Customer and Date) Set of filter record for precise search of records.
  • Records will be defaulted to set on Filter All for customers and the current date for the Date Range.
2. Export Allows the user to Export the report into Spreadsheet
3. Customer The customer assigned for the specific Receivables.
4. Reference The reference record for the Accounts Receivable of the Customer.
  • Clicking the Receivables link will let the user view the status of the Receivable.
5. Transaction Date The date when the Receivable is issued.
6. Terms the set default days on the customer for them to pay their outstanding balance on their receivables.
  • Aging will start when the days on the Terms are exceeded.
  • Default Terms can be edited through Customer Maintenance Module.
7. Due Date The date on which the receivable should be paid.
  • Due dates will based on the Transaction date plus the Terms applied on the customer.
  • If there are no Terms applied on the customer. The due date will be automatically set into 7 days after the Transaction Date.
8. Current The balance to be paid on the receivables during the span of Transaction date up to Expiration Date.
9. Aging Range A range of days where the receivable exceeds to its due date.
  • Range will be categorized within 30 days , within 60 days and more than 60 days.
10. Balance The total amount to be paid on a specific Transaction.

Notes:

  • Customer record must be ACTIVE status in order to check its receivable aging records.
    • Customer records can be seen in Customer Maintenance Module.
Filtering Records and Exporting Accounts Receivable Aging
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Accounts Receivable Aging under Financial Statement Reports.
  3. Under Accounts Receivable Aging, click the Export Button on the right side. Take note that the user can filter the date and the customer for precise exportation of records.
Financial Statement - Accounts Receivable Aging - Export.png


Viewing Vouchers on Accounts Receivable Aging
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Accounts Receivable Aging under Financial Statement Reports.
  3. Under Accounts Receivable Aging, click the reference links under reference column to check the records corresponding to the customer’s transaction on a specific date.
    • The user may Received the payment when viewing a specific Accounts Receivable record.
    • The user may tag a Profit Center when viewing a specific Accounts Receivable record
      • The user may only tag a Profit Center if the status is not yet Posted
Financial Statements - Accounts Receivable Aging - View.png


Modules
Financials Accounts Receivable | Receipt Voucher
Maintenance Maintenance | Customer | Profit Center
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