...
| Report # | Report Name | Description / Usage / Benefits |
|---|
| CC-01 | Transaction Aging Analysis | 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. |
...
Image Removed
Image Removed
...
...
| 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.
|
Image Removed
Image Removed
...
Again, the amount outstanding are divided into different periods for easy viewing. Eg :
- 0 - 30 days
- 30 - 60 days
- 60 - 90 days
|
| CC-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. |
...
Image Removed
Image Removed
...
|
| CC-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 :
|
Image Removed
Image Removed
- nature of business (for distributors)
- demographic group - by age / gender / race
- social preferences
|
| CC-05 | Transaction Aging Summary |
...
...
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 :
Image Removed
Image Removed
| 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. |
| CC-06 | Monitor Outstanding Document / Monitor Outstanding |
...
Image Removed
Image Removed
...
PDC Document | This report is hyperlink to Monitor Outstanding Document which consolidates all customer outstanding invoices from a branch or all branch into one report. |
| CC-07 | Historical |
...
Transaction Aging Analysis | This report is |
...
| useful for getting a breakdown of your customer aging report as of |
...
| a specific date. Normal operating standards would require you to issue invoice, receipt for deposit and customer credit memo. This check helps you detect fraud and errors in customer balance account for audit purposes and also identifying the aging of the invoices. |
| CC-08 | Customer Historical Overdue Aging Report | This report is similar to CC-07 with additional information on final invoice term days ( Invoice Term days minus term given to the customer) |
| CC-09 | Transaction Aging Summary By Customer Currency | Similar with CC-04 Transaction Aging Summary by Customer with additional selection on Currency |
| Expand |
|---|
| title | CC-01 Transaction Aging Details |
|---|
|
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.
 Image Removed
 Image Added - Key in Specific Customer or Customer Code Range → leave it blank to generate for ALL Customer
- Select Branch
- Select Date
- Select Branch
- Select Specific Customer or leave it blank to generate for ALL Customer
- Salesman
- Select Customer Type → if any configuration from drop down list
- Select Date
- Tick the the Options
- Show Accounts That Busted Credit Limit or Terms Only
- Outstanding Document Only→ by default, it will tick "show outstanding document only"
- Show Contact Persons
- 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
Select Sort by - Click "Generate Repot Now"
 Image Removed
Notes: - Please refer to Aging Summary Total
- Click on 'Printable Page - Summary' for total historical aging per customer
 Image Removed
- For Account checking and Audit Purpose, the Aging Summary Total Amount need to be tally with Total Historical AR
- Audit Trail Report tracked the user which user generate the report, which branch and what date range → refer to Audit Trail Report
|
| Expand |
|---|
| title | CC-08 Customer Historical Overdue Aging Report |
|---|
|
 Image Removed
 Image Removed
|
...
 Image Added
- Click Printable Page → to print current columns or tables
 Image Added
- Click Printable Page -Summary → to print outstanding summary by customer
 Image Added
- Click Export Excel or CSV → to export current columns or tables
NOTES: - Credit Terms and Credit Limit in RED fonts shows that the Invoices have exceeded the Credit Terms without being paid yet
|
...
...
...
 Image Added
- Click the Transaction Number for Pop Up Document function
|
| Expand |
|---|
| title | CC-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. Image Added - 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.
|
...
...
...
- Document Only: To exclude Receipts already paid for Invoices.
|
...
...
- to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
|
...
...
...
Image Added Notes: Again, the amount outstanding are divided into different periods for easy viewing. Eg : - 0 - 30 days
- 30 - 60 days
- 60 - 90 days
|
...
| Expand |
|---|
| title | CC-03 Transaction Aging Summary |
|---|
|
...
|
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. Image Added - Select Branch or All Branches
|
...
...
...
- to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
|
...
...
...
...
...
- Document Only: To exclude Receipts already paid for Invoices.
|
...
...
Image Added |
...
| Expand |
|---|
| title | CC-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 : - nature of business (for distributors)
- demographic group - by age / gender / race
- social preferences
Image Added - Select Branch or All Branches
|
...
...
...
- to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
|
...
...
...
...
...
- Document Only: To exclude Receipts already paid for Invoices.
|
...
...
...
Image Added |
...
| Expand |
|---|
| title | CC-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 : - nature of business (for distributors)
- demographic group - by age / gender / race
- social preferences
|
...
Image Added - 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.
|
...
...
...
- Document Only: To exclude Receipts already paid for Invoices.
|
...
...
- to choose a customer name. Once done, 'Filter by Account' will immediately be ticked as well.
|
...
...
...
Image Added Notes: 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. |
...
...
| Expand |
|---|
| title | CC-06 Monitor Outstanding Document/ Monitor Outstanding PDC Document |
|---|
|
Image Added - 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
Image Added |
| Expand |
|---|
| title | CC-07 Historical Transaction Aging Analysis |
|---|
|
This report is useful for getting a breakdown of your customer aging report as of a specific date. Normal operating standards would require you to issue invoice, receipt for deposit and customer credit memo. This check helps you detect fraud and errors in customer balance account for audit purposes and also identifying the aging of the invoices. Image Added - Key in Specific Customer or Customer Code Range → leave it blank to generate for ALL Customer
- Select Branch
- Select Customer Type → if any configuration from drop down list
- Select Date
- 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
- Select Sort by
- Click "Generate Repot Now"
Image Added Notes: - Please refer to Aging Summary Total
- Click on 'Printable Page - Summary' for total historical aging per customer
Image Added - For Account checking and Audit Purpose, the Aging Summary Total Amount need to be tally with Total Historical AR
- Audit Trail Report tracked the user which user generate the report, which branch and what date range → refer to Audit Trail Report
|
| Expand |
|---|
| title | CC-08 Customer Historical Overdue Aging Report |
|---|
|
Image Added - 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
Image Added |
| Expand |
|---|
| title | Transaction Aging Summary By Customer Currency |
|---|
|
Similar with CC-04 Transaction Aging Summary by Customer with additional selection on Currency  Image Added
- Key in Specific Customer or Customer Code Range → leave it blank to generate for ALL Customer
- Select Branch
- Select Date Range
- Select Salesman → default is all
- Select Customer Type → refer to 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
- Select Currency
- Click Generate Repot Now
 Image Added
- Click Printable Page → to print current columns
- Click Export Excel xls FIle → to export current columns to excel file
- Click Export CSV→ to export current columns to CSV file
|