DSO Table

Thank you parry2k for your reply

please find example in excel format in below link

https://1drv.ms/u/s!AuDSNniB2nu8kRZVUw9SVxrvBfyJ?e=fwsYry

Thank you

Hi,

let me try to make it more clear i am trying to create table that include below lines for each month, ,

1. To have a Total Receivable Balance by creating a formula or table to calculate values of first table based on group TB class, following below formula

•    Total Receivable Balance = 1.AR Rece + 2.AR Prov. + 3.AR Clearing + 4.AR Deposit + 5.AR Unapp + 6.AR On Acc

1. In table 2, each row is calculated based on below formula,

• a-Period Revenue = Sum(8.Rev Ops 1 + 8.Rev Ops 2 + .....+8.Rev Ops 8)
• b-Total Sales Annualised = (Total Period Revenue / Number of periods)*12
• c-Average Receivable Balance = Total Receivable Balance / number of periods)
• d-Receivable Turnover = Total Sales Annualised / Average Receivable Balance
• e-DSO = 365 / Receivable Turnover

Hope you can support me in my query.

Thank you