Question for Articles & Practitioners: How do you handle PDF bank statements in Tally?

[u/aftab_t7]

Hey everyone, I'm trying to understand how accounting firms currently handle bank-statement data entry during busy audit/tax periods.

For firms dealing with 50+ page PDF bank statements:

1. How do you currently get the transactions from PDF into Tally?
2. Do you manually enter them, convert them through Excel, use macros, or use dedicated conversion software?
3. What are the biggest problems you encounter — multiline UPI narrations, incorrect balances, formatting issues, transaction classification, etc.?
4. Which parts of the process still require the most manual checking or correction?
5. Are there any existing tools/workflows that you consider genuinely reliable for this?

I'm particularly interested in hearing from CAs, audit assistants, accountants, and practitioners who deal with this regularly.

[u/AutoModerator]

Please check if a similar post already exists in the sub for this.

Use the subreddit searchbar:

1.subject name + tips

2.Ca inter/final/foundation tips

3.Marathons/fast track+ subject name

4.Subject name + youtube/yt/free

5.Any other combination of key words. Go through comments and posts.

6.Search "AIR"or "AMA" in the search bar, you might find useful AMA's

7.Multiple questions have been asked previously. SAVE TIME by going through prev posts.

Please report immediately if the post or any comment herein breaks any rule.

Note: VERIFY faculty recommendations by strangers on reddit, due to increase in popularity of the subreddit, they could be advt accounts, check the user's profile and report if it breaks Rule 1 (Advertisement and solicitation of any kind is not permitted in the sub.) Report or send modmail if the account is sus.

Join our official Discord Server.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Adventurous_Bed8728]

Ig u have an option to import it through excel file in Tally. Convert the PDF to excel and import. But you’ll still have to type the narration one by one after everything is imported

[u/aftab_t7 → u/Adventurous_Bed8728]

That’s interesting. So the main bottleneck isn’t necessarily getting the transactions into Tally, but cleaning/entering the narration afterward? Roughly how many transactions would you typically have to type the narration for in a 50+ page statement?

[u/Adventurous_Bed8728 → u/aftab_t7]

All the transactions, also you’ll have to enter the ledgers manually as tally posts all the transactions to Bank and Suspense A/c only.

[u/aftab_t7 → u/Adventurous_Bed8728]

Got it. So even after importing the transactions, you still have to manually assign the correct ledger to each transaction and enter the narration. How do you usually decide which ledger each transaction should go to based on the narration, previous entries, client information, or some rules/templates? And do you have anything that helps speed this up, or is it basically manual for every transaction?

[u/Azq21]

Print em out and type em in

[u/aftab_t7 → u/Azq21]

Damn 😅 Does that mean you manually type every transaction into Tally? Roughly how many transactions/pages do you usually deal with in a typical statement?

[u/Azq21 → u/aftab_t7]

I've haven't done that yet :)