arrow_back Back to freelances
F

Excel, Tally Prime Financial Formulas

Freelancer

Share:
placeIN home_workRemote assignmentContract publicAggregated job · IN

eventPublished on Nov 22, 2026 · verifiedWe confirmed on Nov 22, 2026 that it's still live

Is this your business?

₹ 12.500 – ₹ 37.500 per project

About the job

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.

Keep reading for free

Create a free account to see the full job and apply.

  • badgePortfolio visible to companies
  • notificationsNew job alert by email
  • favoriteFree subscription, cancel at any time