Excel, Tally Prime Financial Formulas

₹12500-37500 INR

Posted 1 minute ago

•

Ends in 6 days

₹12500-37500 INR

Paid on delivery

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.

Project ID: 40830116

About the project

3 proposals

Open for bidding

Remote project

Active 12 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

3 freelancers are bidding on average ₹23,083 INR for this job

User Avatar
Flag of MOLDOVA, REPUBLIC OF

Tally exports hide traps: Dr/Cr split columns, indented group rows and blank lines that break lookups the moment next month's file is pasted in. You get a P&L driven from your current export within a day to check the numbers against Tally, then the full workbook with balance sheet, a reconciliation sheet and per-formula notes by day 3, plus a short screen-share. 1. Which Excel version are you on, 365 or 2019/2021? It decides which functions stay safe to use. 2. Do you export one file per month, or one cumulative file covering all periods? Send a sample export in chat and I can start on it today.

User Avatar
Flag of GERMANY

Your Tally Prime trial balance and ledger exports should feed the P&L and balance sheet through formulas, so nobody has to recalculate anything by hand each month. I would load the exports into a raw-data sheet, ideally through Power Query so a new month is a single refresh. A mapping table then assigns each ledger to its statement group. The P&L and balance sheet pull their figures with XLOOKUP, SUMIFS and SUMPRODUCT over dynamic ranges, so they keep working as the files grow. A check row confirms that the balance sheet balances and that the totals match the trial balance. You get the finished workbook plus concise notes on every key formula, and I can suggest where array functions would make your reconciliations and variance checks easier. Based in Frankfurt, Germany, I have worked with data processing and text data in research since 2014 (PhD, 30+ publications). If you send one month's exports, I can build a free sample mapping of the first 20 ledgers before you award the project. Which Excel version do you use, Microsoft 365 or an older one without XLOOKUP and dynamic arrays? Wahed

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab