Convert Tally Trial Balance Dr/Cr Formatting into Actual Values
A Free Excel Add-in for Accountants & Finance
Professionals
If you
export a Trial Balance from Tally to Excel, you may have noticed a
common issue:
128.00 Cr
94.40 Dr
The
values appear correctly on the screen, but when you press F2 or edit the
cell, Dr/Cr disappears and Excel shows only the number.
Why Does This Happen?
In many
Tally-to-Excel exports, Dr/Cr is stored as Excel custom number formatting
rather than as part of the actual cell value.
This can
create problems when you use the Trial Balance for:
- Financial statement
preparation
- Reconciliation
Manually
correcting hundreds of rows is time-consuming and can lead to errors.
🚀 The Solution — One-Click
Conversion
I created
a free Excel Add-in — "Convert Dr/Cr Format Suffix to Value" —
to solve this problem.
With just
one click, the add-in converts the displayed Dr/Cr suffix into an actual
text value.
Before
128.00 Cr → Dr/Cr exists only in
formatting
94.40 Dr → Dr/Cr exists only in
formatting
After
128.00 Cr → Actual text value
94.40 Dr → Actual text value
Your
Trial Balance is now ready for further Excel processing and accounting work.
⭐ Key Benefits
⏱ Save Time
Convert
hundreds of rows in seconds instead of editing cells manually.
📊 Prepare Financials Faster
Use
cleaner Trial Balance data for Balance Sheet, P&L, and schedules.
🤖 One-Click Automation
No
complicated formulas or manual Find & Replace.
✅ Reduce Manual Errors
Avoid
missing rows or accidentally changing accounting values during manual
correction.
💼 Built for Tally + Excel Users
Especially
useful for accountants, auditors, finance professionals, and CA firms working
with Tally exports.
🎁 Download the Free Excel Add-in
Save time by automatically fixing Dr/Cr formatting.
Tally →
Excel → Convert → Ready for Financials
A small utility that can save you a lot of repetitive work.
Download the "Convert Dr/Cr Format Suffix to Value" Excel Add-in and convert your Tally Trial Balance data in just one click.
🛠️ How to Use the Add-in
- Download the free Excel Add-in.
- Open Excel and install/enable the Add-in.
- Open your Tally Trial Balance Excel file.
- Select the worksheet containing the Trial Balance data.
- Click “Convert Dr/Cr Format to Value with Enable Macros” to start the conversion.
- The tool will automatically convert the Dr/Cr formatting into actual text values.
- Your data is now ready for financial statements, and analysis.
That's it — one click and you're ready to work.
📩 Have Questions?
If you
have any questions, feedback, or need assistance with the Excel Add-in, please
feel free to contact us:
Jigar D.
Shah
📧 shahjigar33@gmail.com
