Tally Prime to Excel Dashboard - Bill Outstanding and Calculation of Working Capital Cost #05

Tutorial demonstrating how to import bill wise payment / receipt data from Tally Prime and create reports based on that. Ledger Bill-wise outstanding amount and days is calculated. Reports with breakup of bill-wise credit period given or taken is created. It uses weighted average method to perform complex calculation of credit days for scenario with multiple payments / receipts. Also, blockage of working capital and interest cost accured is calculated to determine cost of credit for Debtors.

Excel functions & features used
XLOOKUP, SUMIFS, MAXIFS, DATE
Dynamic Array, Pivot

Excel file download link:

Tally Prime backup download link:

0:00 Intro
0:27 Import Data - trn_bill
5:59 Linking trn_voucher with XLOOKUP
7:40 Pivot Report of Ledger Billwise Outstanding
11:03 Calculation of Outstanding days using SUMIFS / MAXIFS / Dynamic Array
21:46 Calculation of Weighted Average Credit days & Working Capital Interest Cost
33:44 FAQ
35:44 Conclusion

[doyouknow]

Sir, how to make trn_bill.csv utility

[doyouknow]

Sir, please give Utility trn_bill cvc

[irajatsolanki]

Please can you help to make msme report which has post dated vouchers