Hi Sandip,
I second Teagan's post above, but I'll add that the closest match to GP's Excel utility is Velixo. Full disclosure, I recently joined them to help make life easier for fellow Finance team members like yourself.
I too experienced frustrations with limitations from BC and when I stumbled upon Velixo I wanted to spread the word.
If you want something closer to what GP gave you (a refreshable Excel workbook comparing GL to sub ledger balances), the Velixo add-in for Business Central is worth a look. It pulls live GL and sub-ledger data (AP, AR, bank, dimensions, etc.) straight into Excel formulas, so you can build a reconciliation template once, with GL balance next to sub-ledger balance and a variance column, and just refresh it each period rather than regenerating anything. You could pair the variance column with conditional formatting to flag mismatches at a glance.
You can even use Claude alongside Velixo to build this out. Claude can write the Velixo formula structure and the workbook layout for you, based on what accounts and sub-ledgers you describe, so you're not starting from a blank sheet. It's a decent shortcut for getting the reconciliation template built without knowing every Velixo function off the top of your head.
Hope this helps!
Natasha Sabelli, CPA
