Arjun had just begun a new chapter in his life. After completing his graduation, he was actively searching for a job and soon secured a position as an accountant at a newly established business, “GG Electronics.”
Arjun possessed strong working knowledge of Tally.ERP
9, but TallyPrime was relatively new to him. Rather than feeling hesitant, he
was excited and eager to embrace both his new professional journey and the
latest software advancements.
He was assigned the responsibility of managing the
company’s accounting operations effective from 1st May 2026. However, since the
business had commenced operations on 1st April 2026, all banking transactions
for the previous month were still pending and needed to be recorded in the
company’s Tally data.
Before joining the organization, Arjun had been
exploring the latest updates in TallyPrime and had discovered several advanced
features. Among them, one banking feature particularly caught his attention —
“Automated Voucher Creation.” He learned that by importing a bank statement
into Tally, the software could automatically generate corresponding banking
vouchers.
Recognizing the practical value of this feature, Arjun
saw it as the perfect opportunity to handle the backlog of pending banking
transactions efficiently. He decided to implement this process in the business
and test how effectively it would work in a real-world scenario. With curiosity
and determination, he set out to explore the feature and transform a routine
accounting task into an innovative learning experience.
Automated Voucher Creation is a smart, AI-like feature
available in TallyPrime that helps users streamline banking operations. It
enables businesses to perform automatic bank reconciliation and create
accounting vouchers directly in Tally based on the imported bank statement.
The process is simple: once the bank statement is
imported into Tally, the software analyzes the entries and automatically
generates the relevant vouchers in the system. This reduces manual effort and
significantly improves accuracy in recording banking transactions.
In many businesses, the traditional approach is still
followed — payment and receipt vouchers are recorded manually throughout the
month, and reconciliation is carried out at month-end. During this process,
accountants often discover transactions reflected in the bank statement but
missing in Tally records. These transactions then have to be entered manually,
which consumes additional time and increases the chances of oversight.
By exploring this intelligent feature in TallyPrime,
users can simplify the entire process. Not only does it automatically reconcile
transactions with the bank statement, but it also identifies unmatched entries
and converts them into accounting vouchers within Tally. This means the feature
serves multiple purposes — faster reconciliation, reduced manual intervention,
improved data accuracy, and efficient transaction recording — making it a
highly valuable tool for modern accounting practices.
With a basic understanding of this AI-like feature in
TallyPrime, Arjun decided to implement the process in a practical business
scenario.
For the month of April 2026 — where no banking
transactions had yet been recorded in the Tally data — he followed the process
below:
Step 1: Downloaded the
bank statement in Excel format.
(TallyPrime also supports importing statements in Excel, CSV, and PDF formats.)
Step 2: Reverified the
bank ledger created in Tally to ensure it was correctly configured.
This step was important because accurate bank ledger setup is essential for
successful statement import, automated reconciliation, and voucher creation.
Step 3 – Navigated
to banking activities as “Gateway of Tally >> Banking >> Banking Activities>>
Select Bank Ledger>> Enter
Step 4 – Clicked
on ALT+O=Import >> Selected Bank Statement
Step 5 – Specified
the bank statement location as below
Step 6- Post acceptance
of Import Bank statement page, preview of bank statement generated as below
Note: A preview of the
bank statement is first generated, displaying all debit and credit transactions
reflected in the statement. Once the user clicks on Import, the
transactions are brought into TallyPrime through a structured process.
During this process, the system automatically
reconciles bank transactions with entries already recorded in Tally data by
matching relevant banking details. For example, if the first transaction is a
payment of ₹10,500 and it has already been recorded in Tally with the same
cheque number or bank reference details, Tally will automatically reconcile the
transaction since the instrument details match.
If a transaction exists both in the bank statement and
in Tally, but the instrument details are only partially matched, the software
identifies these as Potential Matches. In such cases, the user can
manually review and reconcile them.
Finally, if a transaction is found in the bank
statement but is not present in Tally at all, it is categorized as Available
Only in Bank Statement — indicating that these entries still need to be
recorded in the books.
In Arjun’s case, he was already aware that none of the
April 2026 banking transactions had been entered into Tally. Therefore, instead
of reconciling existing entries, he chose to use the Auto Create option
so that the missing transactions could be generated directly as vouchers within
the system.
Step 7 – Once clicked
on Import a page was displayed as
Above page refer that all the bank transaction not available in Tally hence treated as new entries.
Step 8 – Further
he pressed on Bank reconciliation summary, Bank reconciliation summary page was
generated as below
Let us understand the meaning of the information
displayed in the bank reconciliation summary:
- Balance
as per Company Books:
This refers to the bank ledger balance as recorded in the company’s TallyPrime data. - Unreconciled
Transactions from the Period Till Date:
This represents all bank statement transactions that have not yet been reconciled with the entries in Tally. - Available
Only in Books:
This includes all payment and receipt transactions that have been recorded in Tally but are not yet reflected in, or matched with, the bank statement for any reason. - Available
Only in Bank:
This includes all payment and receipt transactions that appear in the bank statement but have not been recorded in Tally. - Expected
Bank Balance:
This is the projected bank balance that should appear in Tally after successful reconciliation of all transactions. - Balance
as per Bank Statement:
This is the actual closing balance reflected in the imported bank statement. - Difference:
This shows any variance between the balance in the bank statement and the bank ledger balance in Tally, helping users identify mismatches or missing entries.
Step 9 - Arjun clicked on “Unreconciled transactions
from the period to till date”
Step 10 – Now Arjun
has two options either create all the pending transactions in Tally at once or create
one by one. First he understood one by one option where a single transaction to
be created. He selected the first transaction by pressing spacebar
Now press F7
(Create Vch/Multi Vch) a blank voucher creation page will be displayed as per
nature of transaction
Fill the voucher screen
as per applicable nature
Now the voucher
created successfully.
Step 11- Post
exploring first option he choose multi creation voucher option as below
Press spacebar to
select all the banking transaction
He Pressed F7 to select
option “Create Vch/Multi-Vch” and then multi voucher creation page got
displayed
Here in this page
he was asked to select Tally ledger name for each banking transaction. Tally
ledger name from the list of ledger as below
He filled all the
ledger for each banking transactions
As soon as he filled
the ledger name and accepted the page a page got displayed as below
Above page was
related to creation of vouchers based on bank statement and also reconciling
the transaction automatically. He clicked on “Mark Regular & Reconcile”
Press enter to
select option as Yes
As soon as he accepted
all the transaction reported in Tally and bank reconciliation summrry also
updated as below
Now he verified
the bank ledger report by selecting option as “Balance as per company books”
Arjun was thrilled to see that all the transactions
had been recorded successfully in TallyPrime with minimal manual effort. Not
only were the transactions created accurately, but they were also automatically
reconciled — making the entire process efficient and seamless.
With this success, Arjun completed the recording of
all pending banking transactions for the backlog period and presented the
results to his supervisor. The supervisor was genuinely impressed to see that
such a large volume of transactions had been updated in Tally so effortlessly,
using an intelligent, AI-like feature in significantly less time.
For Arjun, this achievement brought a strong sense of
satisfaction. It reinforced his confidence that by exploring and applying the
advanced capabilities of TallyPrime, he could make meaningful contributions to
the organization in the days ahead.
Overall, the Automated Voucher Creation feature
stands out as a smart, AI-like solution that helps users reduce manual effort,
simplify bank reconciliation, and ensure that all banking transactions are
updated accurately and efficiently in Tally.
Comments
Post a Comment