TallyPrime Ledger Management and Bank Reconciliation
This document explains how to create, alter, and display a single ledger, as well as the steps to create multiple ledgers.
Understanding Ledgers in TallyPrime
A Ledger is the actual accounting head or account name (e.g., Cash, Sales, Rent Expense, Customer A/C) that records and summarizes transactions. Ledgers are the most fundamental master in TallyPrime, as all vouchers and financial statements are built upon them.
Creating, Altering, and Displaying a Single Ledger
All ledger operations (Create, Alter, Display) are performed from the Gateway of Tally (GoT) through the Masters menu.
Create a Single Ledger 📝
- Go to the Creation Screen: From the Gateway of Tally, select Create.
- Select Ledger: Choose Ledger under the Accounting Masters.
- Enter Name: Type the name of the ledger (e.g., Rent Paid, XYZ Customer).
- Select Group: Under the “Under” field, select the appropriate Group from the List of Groups (e.g., Indirect Expenses for Rent Paid, Sundry Debtors for a customer). This determines how the ledger appears in financial statements.
- Provide Details: Fill in other relevant details such as opening balance (if any), mailing details, and statutory information (like GST or TDS details).
- Save: Press Ctrl+A or press Enter until the “Accept: Yes or No” prompt appears, then press Y or Enter to save the ledger.
Alter a Single Ledger ✍️
Altering a ledger allows you to change its name, grouping, or any other details.
- Go to the Alteration Screen: From the Gateway of Tally, select Alter.
- Select Ledger: Choose Ledger under the Accounting Masters.
- Select Specific Ledger: Choose the specific ledger you wish to modify from the list.
- Make Changes: The Ledger Alteration screen appears. Make the necessary changes (e.g., change the name, or change the Group from Sundry Debtors to Sundry Creditors).
- Save: Press Ctrl+A to save the altered ledger.
- Note: If a ledger has no transactions, you can also delete it from the Alteration screen by pressing Alt+D.
Display a Single Ledger 👀
Displaying a ledger allows you to view its details but does not permit any changes (read-only mode).
- Go to the Display Screen: From the Gateway of Tally, select Chart of Accounts.
- Select Ledgers: Choose the Ledgers option.
- View List: You will see a list of all ledgers grouped by their primary group.
- View Details: Select the specific ledger you want to view. The screen will open in display mode. Press Esc to return to the previous screen.
Steps to Create Multiple Ledgers ➕
TallyPrime provides a Multi-Ledger Creation mode, which is faster and more efficient for creating many ledgers that fall under the same or different groups simultaneously.
- Go to the Creation Screen: From the Gateway of Tally, select Create.
- Select Show More: Choose Show More and then select Ledger.
- Access Multi-Master: Press Alt + H (Multi-Master), then select Multi Create.
- Select Group: If the ledgers belong to different groups (e.g., Rent, Salaries, and Bank A/C), select All Items in the “Under Group” field.
- Enter Details:
- Start entering the Name of the first ledger.
- If you selected All Items, you must manually select the appropriate Group for each ledger (e.g., Indirect Expenses, Bank Accounts).
- Enter the Opening Balance for each ledger, if applicable.
- Repeat this process for all the ledgers you need to create.
- Save: Once the list is complete, press Ctrl+A to save all the multiple ledgers in one go.
What is Bank Reconciliation? 🏦
Bank Reconciliation is a process that compares and matches the balance of a company’s Cash Book/Bank Ledger (as maintained in the company’s books) with the balance shown in the Bank Passbook/Statement.
The two balances almost never match on a specific date due to timing differences or errors. The purpose of the reconciliation process is to identify these differences and prepare a Bank Reconciliation Statement (BRS) to account for them, thereby arriving at the adjusted, correct cash balance.
Common Causes for Differences
- Timing Differences: Transactions recorded by one party but not yet by the other (e.g., cheques issued but not yet presented to the bank, or cheques deposited but not yet cleared).
- Bank Transactions: Items recorded only by the bank (e.g., bank charges, interest credited, direct deposits by customers, or EFT payments).
- Errors: Mistakes made either by the company (in the Cash Book) or by the bank (in the Passbook).
Methods of Bank Reconciliation
There are three primary methods used to prepare a Bank Reconciliation Statement (BRS), all of which involve adjusting one balance to match the other:
Reconciliation Starting with the Cash Book Balance 📚
In this method, the reconciliation process begins with the Bank Balance as per the Cash Book.
- Adjustment Logic: Transactions that caused the Cash Book balance to be higher than the Bank Statement are subtracted, and transactions that caused the Cash Book balance to be lower are added.
- Final Result: The statement is prepared to arrive at the Bank Balance as per the Passbook/Bank Statement.
| Example Adjustments | Action |
|---|---|
| Cheques issued but not yet cleared (Cash Book balance is higher) | Deduct |
| Bank Interest Credited (Cash Book does not yet include it) | Add |
Reconciliation Starting with the Passbook Balance 🏦
In this method, the reconciliation process begins with the Bank Balance as per the Passbook/Bank Statement.
- Adjustment Logic: Transactions that caused the Passbook balance to be higher than the Cash Book are subtracted, and transactions that caused the Passbook balance to be lower are added.
- Final Result: The statement is prepared to arrive at the Bank Balance as per the Cash Book.
| Example Adjustments | Action |
|---|---|
| Cheques deposited but not yet cleared (Passbook balance is lower) | Add |
| Bank charges debited by bank (Passbook balance is lower) | Add |
Reconciliation Starting with Both Balances ✅
This is often considered the most accurate method as it involves adjusting both the Cash Book balance and the Passbook balance to arrive at a true, common, or adjusted cash balance.
- Step 1: Adjust the Cash Book: The company first updates its Cash Book by incorporating items the bank recorded but the company missed (e.g., bank charges, interest, direct deposits).
- Step 2: Adjust the Bank Statement: A separate BRS is then prepared using the Adjusted Cash Book Balance as the starting point and adding/subtracting timing differences (like uncleared cheques) to arrive at the Adjusted Bank Statement Balance.
- Final Result: If the reconciliation is accurate, the Adjusted Cash Book Balance and the Adjusted Bank Statement Balance must be equal, representing the actual cash balance available.
In TallyPrime, the software facilitates the process by allowing the user to select transactions and mark them as cleared, automatically generating the reconciliation statement based on the chosen date.
MIS in TallyPrime
MIS (Management Information System) in the context of TallyPrime refers to the system’s ability to process financial and operational data and present it in the form of structured, timely, and relevant reports to the management for effective decision-making, planning, and control. TallyPrime acts as an MIS by providing instantaneous and drill-down views of various reports, transforming raw accounting data into actionable information.
Key Functions of Tally as an MIS
- Real-time Reporting: Provides up-to-date data instantly, allowing management to react quickly to business changes.
- Performance Analysis: Helps in comparing actual performance against budgets, identifying profit centers, and analyzing cost variances (e.g., using Cost Centre Reports).
- Drill-down Capability: Enables users to move from summarized reports (like the Balance Sheet) down to the individual transaction level (the voucher entry).
Steps to Display Reports
All reports in TallyPrime are accessed from the Gateway of Tally (GoT).
Cash/Bank Book (कैश/बैंक पुस्तक) 💵
This report shows the summary of all cash and bank transactions (receipts and payments) over a period, detailing the opening and closing balances. It is used to reconcile transactions and monitor liquidity.
- From the Gateway of Tally (GoT), select Display More Reports.
- Select Account Books.
- Select Cash/Bank Book (or Ledger).
- The report will open. You can select a specific Bank Ledger or the Cash Ledger to view its detailed statement.
- Press Alt+F2 to change the reporting period if needed.
Day Book (डे बुक) 📅
The Day Book is a complete chronological record of all vouchers entered (or recorded) in TallyPrime for a specific day or period, regardless of the voucher type (e.g., Sales, Payments, Receipts, Purchases). It is crucial for auditing and reviewing daily transactions.
- From the Gateway of Tally (GoT), select Display More Reports.
- Select Day Book.
- By default, it shows transactions for the current date.
- To view the report for a different period, press Alt+F2 (Change Period) and enter the desired start and end dates.
Sales Register (बिक्री रजिस्टर) 🧾
The Sales Register is a periodical summary of all Sales Transactions recorded in the company. It allows analysis of sales figures grouped by month, and further by ledger or GST type.
- From the Gateway of Tally (GoT), select Display More Reports.
- Select Account Books.
- Select Sales Register.
- The report initially shows a monthly summary of all sales.
- Drill Down: Select a specific month and press Enter to view the list of individual sales vouchers recorded in that month.
- Press F8 (Columnar) to view the Sales Register in a column format for comparative analysis.