Versions Compared

Version Old Version 16 New Version 17
Changes made by

Simas Sen

Simas Sen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



 Report Name
 Step By Step Guide
 Description / Usage / Benefits
 Transaction Aging Analysis1. Check the selected Branches.
2. Customer Account (Optional) - Click 'Select' to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well. 
3. From the drop-down list, select 'Show Accounts That Busted Credit Limit / Terms', if you want to see only the exceeds.
4. Date range - From and To.
5. Tick 'Outstanding Documents Only' to exclude Receipts already paid for Invoices.
6. Sort By.
7. Click 'Generate Report Now'.		This report is similar to Monitor Outstanding Invoice Report, where all outstanding documents are displayed. Instead of showing the exact number of days where a document is outstanding, this report display them into various columns, based on the configurations in the accounting module for various aging periods. Please seeAging Period Setup.

Also, included Credit Terms and Credit Limit. RED fonts shows that the Invoices have exceeded the Credit Terms without being paid yet.

Users can also choose to settle the outstanding invoices here. Just click eg. Settle 1001 to settle the invoices using Settle Documents.
 Transaction Aging By Salesman1. Select Branch or All Branches.
2. Choose a Salesman name from the drop-down list.
3. Enter Date Range - From and To.
4. Credit Limit Usage - How much percentage of invoice issued but still not paid within the credit limit.
5. Tick 'Outstanding Documents Only' to exclude Receipts already paid for Invoices.
6. Click 'Select' to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well
7. Click 'Generate Report Now'.		In this report, the filters selected can make big difference in the report generated. The special feature in this report is the Credit Limit Usage. This filter helps salesman be aware of customers who are almost reaching the credit limit. From this, they will be able to manage their customer accounts better. 

Again, the amount outstanding are divided into different periods for easy viewing. Eg :
  • 0 - 30 days
  • 30 - 60 days
  • 60 - 90 days
 Transaction Aging Summary By Branch1. Select Branch or All Branches.
2. Click 'Select' to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
3. Enter Date Range - From and To.
4. Tick 'Outstanding Documents Only' to exclude Receipts already paid for Invoices.
5. Click 'Generate Report Now'.		To effectively manage a chain store, certain customers may buy from multiple branches. Hence, performance of the branch managers in chasing for collections should be monitored accordingly. This report helps senior management monitor the people who control the credit risk of the company.
 Transaction Aging Analysis By Customer1. Select Branch or All Branches.
2. Click 'Select' to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
3. Enter Date Range - From and To.
4. Tick 'Outstanding Documents Only' to exclude Receipts already paid for Invoices.
5. Click 'Generate Report Now'.		Very similar to Transaction By Salesman / Branch except that it filters by customer. This report lists down the 'Customer Type' as well. Customer type is set in Configure Drop Down List for Create Customer Account, as it can be anything or anyhow you want to categorize your customer base. Examples :
  • nature of business (for distributors)
  • demographic group - by age / gender / race
  • social preferences
 Transaction Aging Summary By Salesman1. Select Branch or All Branches.
2. Choose a Salesman name from the drop-down list.
3. Enter Date Range - From and To.
4. Credit Limit Usage - How much percentage of invoice issued but still not paid within the credit limit.
5. Tick 'Outstanding Documents Only' to exclude Receipts already paid for Invoices.
6. Click 'Select' to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well
7. Click 'Generate Report Now'.		Exactly the same as Transaction Aging By Salesman, but instead of showing all Receipts and CMs, this is a summarized version where only the total of all outstanding amount is shown here. 
 Collection with Invoice Aging1. Select Branch or All Branches.
2. Enter Date Range - From and To.
3. Choose a Salesman name from the drop-down list. Remember to tick the check box.
4. Click 'Generate report Now'.		Certain companies reward their salesmen according to how fast they manage to collect from their customers. If the salesman collect faster, they get rewarded better. This report shows all the collections within a period of time, and analyze each of the collection, to compute the corresponding age of the collection based on the invoice dates.

Basically, this report does NOT show invoices which are not settled but onlyinvoices which have been fully / partially settled. You should see Transaction Aging Analysis (as above) for outstanding invoices.

Please be aware that, the columns in this report, segregating eg. 0-30 days, 31-60 days are not how long the invoices have been outstanding. Instead they show how long the payment took to settle the invoice.
  • Salesman Total - The Total Amount collected from each Salesman.
  • Dealer Type Subtotal - Total Amount for customers with the same DealerCode.
  • Invoice Amount - How much is billed to customer.
  • Rct (Invoice Amount column) - How much is paid for the corresponding invoice.
  • Invoice Balance = Invoice Amount - Rct (Invoice Amount column)
  • Account Subtotal - Total amount Outstanding for that customer.
  • All payment modes, eg. cash, credit card, cheque are included here.

...

Expand
titleCC-02 Transaction Aging by Salesman

In this report, the filters selected can make big difference in the report generated. The special feature in this report is the Credit Limit Usage. This filter helps salesman be aware of customers who are almost reaching the credit limit. From this, they will be able to manage their customer accounts better. 

  • Select Branch or All Branches
  • Select Saleman Name from the dropdown list
  • Enter Date Range
  • Enter Credit Limit Usage: How much percentage of invoice issued but still not paid within the credit limit.
  • Tick Outstanding Document Only: To exclude Receipts already paid for Invoices.
  • Click Select to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
  • Click Generate Report Now


Expand
titleCC-03 Transaction Aging Summary by Branch

To effectively manage a chain store, certain customers may buy from multiple branches. Hence, performance of the branch managers in chasing for collections should be monitored accordingly. This report helps senior management monitor the people who control the credit risk of the company.

  • Select Branch or All Branches
  • Click Select to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
  • Enter Date Range
  • Tick Outstanding Document Only: To exclude Receipts already paid for Invoices.
  • Click Generate Report Now


Expand
titleCC-04 Transaction Aging Summary by Customer

Very similar to Transaction By Salesman / Branch except that it filters by customer. This report lists down the 'Customer Type' as well. Customer type is set in Configure Drop Down List for Create Customer Account, as it can be anything or anyhow you want to categorize your customer base. Examples :

  • Select Branch or All Branches
  • Click Select to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
  • Enter Date Range
  • Tick Outstanding Document Only: To exclude Receipts already paid for Invoices.
  • Click Generate Report Now


Expand
titleCC-05 Transaction Aging Summary by Salesman

Very similar to Transaction By Salesman / Branch except that it filters by customer. This report lists down the 'Customer Type' as well. Customer type is set in Configure Drop Down List for Create Customer Account, as it can be anything or anyhow you want to categorize your customer base. Examples :

  • Select Branch or All Branches
  • Select Saleman Name from the dropdown list
  • Enter Date Range
  • Enter Credit Limit Usage: How much percentage of invoice issued but still not paid within the credit limit.
  • Tick Outstanding Document Only: To exclude Receipts already paid for Invoices.
  • Click Select to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
  • Click Generate Report Now


Expand
titleCC-06 Monitor Outstanding Document/ Monitor Outstanding PDC Document


  • Key in Specific Customer or Customer Code Range → leave it blank to generate for ALL Customer
  • Select Branch or All Branches
  • Select Saleman Name from the dropdown list
  • Select Customer Type → if any configuration from drop down list
  • Tick the Options 
    • Show Accounts That Busted Credit Limit or Terms Only
    • Outstanding Document Only→ by default, it will tick "show outstanding document only"
    • Show CM create from Bad Debt Relief → refer to Customer Bad Debt Relief
    • Show CM create from Bad Debt Recovered → refer to Customer Bad Debt Recovered
  • Key in Reference Date
  • Select Document Type
  • Select Sortby 
  • ClickGenerate Repot Now

...

Expand
titleCC-08 Customer Historical Overdue Aging Report

  • Click Select to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well
  • Select Branch or All Branches
  • Select Date Range
  • Select Saleman Name from the dropdown list
  • Key Reference Date
  • Choose Aging calculated based on 
  • Click Generate Report Now

...