Step 1: Importing a Bank Statement

TallyPrime allows you to fetch bank statements through Connected Banking Services. However, if this service is unavailable for your bank, you can manually import the statement using the following steps:

1. Press Alt+O and select Bank Statement.

2. In the Import Bank Statement screen, choose the Bank Ledger.

3. Specify the file path and select the supported file type.

4. Select the file to import

5. Set Show Preview to Yes.

6. Press Ctrl+A to accept the screen.

7. In the Bank Statement Preview screen, press I to import the bank statement.

Upon successful import, the summary will display the total number of entries imported.

Step 2: Reconciling Bank Transactions

Once the bank statement is imported, you can reconcile the transactions:

1. Press S to go directly to Bank Reconciliation Summary, or

2. Press Escape to return to the Banking Activities Report.

3. Press Alt+G, type or select Banking Activities, and press Enter.

4. In the Banking Activities screen, select the Bank Ledger and press Enter.

5. In the Banking Activities screen, select the Bank Ledger and press Enter.

6. In the Bank Reconciliation Summary, check for unreconciled transactions.

Step 3: Creating Multiple Vouchers

For entries available only in the bank statement, you can create multiple vouchers:

1. Select the entries for which vouchers need to be created

2. Press F7 to open the Ledger Name column.

3. Select the relevant ledger or create a new one.

4. Press Ctrl+A to save the vouchers.

5. These vouchers will now appear as Optional Vouchers linked to the bank data.

6. Press R to regularize and reconcile them with the corresponding bank entries.

Alternatively, you can navigate to the Optional Vouchers Bank Data Report and regularize the vouchers there.

Step 4: Using a Common Ledger for Multiple Entries

If multiple transactions belong to the same ledger, you can:

1. Select the entries.

2. Press F7 and choose Common Ledger.

3. Create a new ledger if needed.

4. Press Ctrl+A to save the optional vouchers.

3. You can then update bill-wise and other details as required.

Step 5: Creating a Single Voucher

For a single bank entry, follow these steps:

1. In the Bank Reconciliation Report, select the required bank entry.

2. Press F7 to open the Voucher Creation screen.

3. Select the ledger and enter bill-wise details if required.

Step 6: Creating a Consolidated Voucher

For entries belonging to the same ledger, you can create a consolidated voucher:

1. Select the entries.

2. Press Alt+F7.

3. Specify the ledger in the Particulars field.

4. The total amount of all selected bank entries will be prefilled.

5. Press Ctrl+A to create and reconcile the voucher.

Step 7: Creating Vouchers from Imported Bank Data Report

You can also create vouchers directly from the imported bank data:

1. Press Alt+G, type or select Imported Bank Data, and press Enter.

2. Select the Bank Ledger and press Enter.

3. Drill down to view imported bank transactions for a specific date.

4. Identify transactions available only in the bank and create vouchers accordingly.

Conclusion

TallyPrime streamlines the process of voucher creation by allowing you to generate single, multiple, or consolidated vouchers from an imported bank statement. This ensures your books of accounts remain reconciled and saves valuable time in managing financial transactions efficiently.

By following these simple steps, you can keep your financial records accurate and up to date. Start leveraging this powerful feature in TallyPrime today!