Master the Process: Create Vouchers from Bank Statements in Tally Prime 6.0

Published on: 26-03-2025

Master the Process: Create Vouchers from Bank Statements in Tally Prime 6.0

Tally Prime 6.0 offers a seamless process to create vouchers from bank statements, allowing businesses to efficiently manage their transactions. By importing your bank statement into Tally, you can automatically generate the corresponding vouchers, streamlining your accounting process. Below is a comprehensive guide to help you create vouchers from a bank statement in Tally Prime.

Step-by-Step Guide to Creating a Voucher from Bank Statement in Tally Prime 6.0

Step 1: Import the Bank Statement into Tally

1. Open Tally Prime and select the company where you want to create the voucher.
2. From the Gateway of Tally, navigate to the Banking menu.
3. Select Bank Reconciliation from the list.
4. In the Bank Reconciliation screen, press Alt+I or go to Import to import the bank statement file.
5. Choose the appropriate file format for your bank statement. Tally supports various formats such as CSV, MT940, and others.
6. Once you select the file, Tally will automatically detect the bank statement's details.

Step 2: Reconcile Bank Entries

1. After importing the statement, Tally will display the transactions from the bank statement.
2. Match each entry from the bank statement with the corresponding ledger entry in Tally (e.g., Payments, Receipts, or Bank Charges).
3. For each bank transaction, you can:
   • Create a new voucher by selecting F7: Payment for payments, F6: Receipt for receipts, or Ctrl+F8: Journal for any other adjustments.
   • Verify and modify the voucher if needed, ensuring that the amounts and ledger accounts match the bank transactions.

Step 3: Create Vouchers Automatically (Optional)

1. Tally Prime can automatically create vouchers from the bank statement if the reconciliation is enabled.
2. For automatic creation, enable the option "Auto Create Vouchers" in the Bank Reconciliation screen.
3. Tally will automatically generate vouchers based on the imported statement, and you can review and approve them before posting.

Step 4: Post and Save the Vouchers

1. Once the reconciliation is done, press Enter to save the vouchers.
2. Tally will update your books with the newly created vouchers, keeping the ledger and the bank balance aligned.

Step 5: Review and Finalize Bank Reconciliation

1. After all the entries are reconciled, you can verify the bank balance in Tally against the actual bank statement.
2. If everything matches, complete the reconciliation and finalize the process.
3. The created vouchers are now recorded in your books and can be viewed under the Accounting Vouchers section.

Additional Tips for Efficient Voucher Creation in Tally Prime

• Use Bank Formats: When importing bank statements, ensure your bank provides the statement in a Tally-compatible format (like MT940 or CSV) for smooth integration.
• Voucher Customization: If required, you can create custom vouchers to meet specific accounting needs by defining voucher types.
• Bank Reconciliation Report: After creating vouchers, always generate a Bank Reconciliation Report to ensure all transactions are properly matched and accounted for.

Conclusion

Creating vouchers from your bank statement in Tally Prime 6.0 has never been easier. With the ability to import statements, automate voucher creation, and perform reconciliations, Tally Prime helps businesses save time and ensure accuracy in their accounting. By following these simple steps, you can easily manage your bank transactions and keep your books up to date.