Open Receipts Ageing - Region
This dashboard provides a comprehensive view of the aging profile of open receipts that are on account of collections not yet tagged to specific bills. The aging is calculated based on the date the amount was received in the bank. The following sections detail the elements and insights provided by the dashboard:
Number Card:
Open Receipts : This card displays the sum of ON Account in Bank Transaction, excluding cancelled receipts.
Bar Chart: Ageing - Open Receipts
This bar chart provides insights into the age distribution of open receipts, grouped based on the number of days from the receipt date to the current date. The groups are segmented as follows: 0-90 days, 91-180 days, 181-270 days, continuing in increments of 90 days up to 1080 days, and a final group for receipts aged above 1080 days. This visualization helps to understand the aging profile of these untagged receipts, enabling better management of accounts receivable and prioritization of efforts to allocate these receipts to the appropriate bills. Identifying areas where efforts may need to be focused for reconciliation.
Bar Chart: Ageing - Open Receipts (Percentage)
This bar chart provides insights into the age distribution of open receipts, expressed as a percentage of the total open receipts. The receipts are grouped based on the number of days from the receipt date to the current date, segmented as follows: 0-90 days, 91-180 days, 181-270 days, continuing in increments of 90 days up to 1080 days, and a final group for receipts aged above 1080 days. This chart allows for an understanding of the proportion of open receipts within each age group, highlighting the relative age profile of untagged receipts and aiding in the prioritization of reconciliation efforts.
Table: Open Receipts Ageing - Region
This table provides a detailed breakdown of open receipts categorized by their age and region. Each cell in the table represents the sum of open receipts for that specific region and age group. The final column, 'Total', provides the total amount of open receipts for each region. The final row, 'Total', aggregates the open receipts amounts across all regions for each age group. Aging Profile Analysis: This table allows for a comprehensive analysis of the aging profile of open receipts across different regions. Reconciliation Prioritization: By identifying regions with higher amounts in older age groups, efforts can be focused on reconciling these receipts to the appropriate bills. Regional Insights: This segmentation offers insights into the performance of different regions in terms of receipt allocations and untagged amounts. Strategic Decision-Making: Businesses can make informed decisions regarding reconciliation efforts and customer follow-ups based on the aging and regional distribution of open receipts.