Hi Saitong,
There are still issues with the DSO numbers, the rest I am ok with. For DSO the issue remaining is as follows;
Avg Monthly AR 2,624,842,167
Avg Aged & Current 26,242,840,323
This implies you have 10x aged vs. your AR, this cannot be right, these numbers should tie out and reconcile? With regard the terms changes, you still have Cash on Delivery, Cheque on Delivery, Pre Payment Wire all showing various forms of aged AR? If the data is correct, this would imply that even though we collect cash, cheque there is a delay in processes to conduct cash allocation & banking process, some > 181d…….see below small extract just for cash on delivery for reference.
The items in red are shown as loan stocks against internal associates, with COD terms, with the AR ageing out, you need to deep dive into the loan stocks process
Please just send the monthly AR files Jan through Sept for all customer (9 files in total) and myself and BCG will have to go through the data manually to reconcile and consolidate. Please send these files asap, it should be part of your monthly finance pack.
Hi Saitong,There are still issues with the DSO numbers, the rest I am ok with. For DSO the issue remaining is as follows;Avg Monthly AR 2,624,842,167Avg Aged & Current 26,242,840,323This implies you have 10x aged vs. your AR, this cannot be right, these numbers should tie out and reconcile? With regard the terms changes, you still have Cash on Delivery, Cheque on Delivery, Pre Payment Wire all showing various forms of aged AR? If the data is correct, this would imply that even though we collect cash, cheque there is a delay in processes to conduct cash allocation & banking process, some > 181d…….see below small extract just for cash on delivery for reference.The items in red are shown as loan stocks against internal associates, with COD terms, with the AR ageing out, you need to deep dive into the loan stocks processPlease just send the monthly AR files Jan through Sept for all customer (9 files in total) and myself and BCG will have to go through the data manually to reconcile and consolidate. Please send these files asap, it should be part of your monthly finance pack.
การแปล กรุณารอสักครู่..
