| Report Name | Step By Step Guide | Description / Usage / Benefits |
| Transaction Aging Analysis | 1. 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 see Aging 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 Salesman | 1. 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 Branch | 1. 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 Customer
| 1. 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 Salesman | 1. 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. |
Monitor Outstanding Document / Monitor Outstanding PDC (Post Dated Cheque) Document
| Also check Monitor Outstanding Document. | Monitoring customer credit is extremely important. This report
consolidates outstanding invoices grouped by customer from various
branches on a real time basis. All customer accounts that have exceeded
credit limits or credit terms will be highlighted. Managers could
suspend or black list these accounts to prevent further credit sales to
these accounts for better control of credit risk. |
