Difference between revisions of "Accounts Receivable Aging"

Line 9: Line 9:
  
 
'''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)
 +
{| class="wikitable"
 +
|+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.
  
Accounts Receivable Aging Menu Terms on Oojeema Prime System:
+
*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.
  
#'''Record Filter'''(Customer and Date) -Set of filter record for precise search of records.
+
*Clicking the Receivables link will let the user view the status of the Receivable.
#*Records will be defaulted to set on Filter All for customers and the current date for the Date Range.
+
|-
#'''[[Customer]]''' - The customer assigned for the specific Receivables.
+
|5. '''Transaction Date'''  
#'''Reference''' - The reference record for the Accounts Receivable of the Customer.
+
|The date when the Receivable is issued.
#*Clicking the Receivables link will let the user view the status of the Receivable.
+
|-
#'''Transaction Date''' - The date when the Receivable is issued.
+
|6. '''Terms'''
#'''Terms''' - the set default days on the customer for them to pay their outstanding balance on their receivables.
+
|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.
 
#*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.
 
  
 +
*Aging will start when the days on the Terms are exceeded.
 +
*Default Terms can be edited through [[Customer]] Maintenance Module.
 +
*This Terms is different from the [[Terms]] 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:
 
Notes:
  

Revision as of 10:35, 24 March 2021


Accounts Receivable Aging

Accounts Receivable Aging Menu

File:Accounts Receivable Aging Menu.png
Accounts Receivable Aging Menu


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:
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.
  • This Terms is different from the Terms 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.
  • 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 here.
Modules
Financials Accounts Receivable
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 Accounts Receivable Aids
Maintenance Aids Customer Aids
Reports Aid
Financial Statements Balance Sheet Aids | Income Statement Aids | General Ledger Aids | General Journal Aids | Trial Balance Aids | Statement of Account Aids | Accounts Receivable Aging Aids | AR Detailed Report Aids | AR Transaction Report Aids | Accounts Payable Aging Aids | AP Detailed Report Aids | AP Transaction Report Aids | Cash Position Aids | Check List Aids | Deposit List Aids | Collection Register Aids