Excel, Tally Prime Financial Formulas

via Freelancer ·

Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted2 hours ago
I have a set of financial reports exported from Tally Prime that now need to be brought to life inside Excel. My main focus is on building robust, reusable formulas that can summarise and interpret the data rather than relying on manual calculations each month. Think multi-sheet references, dynamic ranges, nested logical tests, and lookup combinations that stay reliable even when the source files grow.

The first milestone is to translate my trial balance and ledger exports into a clean, formula-driven P&L and balance-sheet view. Once that framework is solid, I’d like your guidance on where advanced techniques such as array functions, XLOOKUP, SUMPRODUCT, or Power Query could simplify recurring reconciliations and variance checks. If better data organisation will make these formulas more resilient, I’m open to your suggestions.

Deliverables
• An Excel workbook containing the completed financial statements with all complex formulas in place
• A quick walkthrough (screen-share or concise notes) explaining how each key formula works so I can maintain it going forward

If you’re comfortable marrying Tally Prime exports with deep-level Excel logic, I’d love to work together.
excel tally definition language
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.