TallyPrime reconciles each bank ledger only from its Reconciliation Beginning Date, which is the first day of the financial year unless you change it. So to reconcile a back date, meaning a month or year that has already passed, you do one of two things. Either move that date back so the older period comes into the Bank Reconciliation report, or carry the items still uncleared from before it into Opening BRS.
Which one is right depends on what you are actually trying to fix. Find your situation in the table first. Each row points to the section that deals with it.
Which back-date problem do you have?
| What you are trying to do, or what you see | What to change |
|---|---|
| Reconcile a month or a year that falls before the Reconciliation Beginning Date | Move the beginning date back |
| Start reconciling from this year, while last year’s closing BRS still has uncleared cheques | Enter those cheques in Opening BRS |
| Older unreconciled entries are missing from the Bank Reconciliation Summary | F12, Default Period for Unreconciled transactions |
| A difference appeared after upgrading to TallyPrime 6.0 or later | Opening BRS. Release 6.0 ignores unreconciled items older than six months |
| You need to redo a month you already reconciled | View Reconciled, then unlink or reset the status |
| The bank date you need to enter is earlier than the cheque or voucher date | See the section on bank dates below |
| The old month’s transactions were never entered in Tally at all | Enter the vouchers first, then reconcile |
What the Reconciliation Beginning Date does
The Reconciliation Beginning Date is the day from which TallyPrime starts reconciling a bank ledger. Book entries dated before it are left out of the expected bank balance. Tally’s help describes the unreconciled transactions from before it as Opening BRS transactions. They stay out of reconciliation until you enter them in the Opening BRS report.
Every bank ledger has its own beginning date. A firm with an HDFC current account and an SBI cash credit account can reconcile one from April and the other from an earlier date. Check each ledger separately.
How to move the Reconciliation Beginning Date back
There are two routes, and they change the same setting.
From the bank ledger:
- Open the bank ledger in alteration (Alt+G > Alter Master > Ledger).
- Set Set/Alter Bank configuration to Yes.
- In the Bank Configuration screen, enter the earlier date in Reconciliation Beginning date.
- Save with Ctrl+A.
From Banking Activities:
- Press Alt+G and open Banking Activities.
- Press Alt+H (Opening BRS) and select the bank ledger.
- Press Alt+R (Set Recon Beginning Date) and enter the date.
Expect the Difference in the Bank Reconciliation Summary to change as soon as you do this. Book entries that were sitting before the old date are now inside the reconciliation period, so every one of them that is still unreconciled counts again. That is the backlog showing itself, not a new mistake.
Move the date back only as far as you are willing to reconcile. Pushing it to the start of the books brings in every unreconciled entry since then. If the earlier years were reconciled outside Tally, on paper or in a spreadsheet, Opening BRS is usually the better choice.
How to carry old uncleared items into Opening BRS
Opening BRS is for the case where you do not want to reconcile the old period line by line, but a few items from it are still outstanding. The usual source is the previous year’s closing bank reconciliation statement: cheques issued but not yet presented, and deposits not yet credited.
- Open the bank ledger in alteration. Set Set/Alter Bank configuration to Yes.
- Set Set/Alter Opening BRS to Yes. This option appears only while altering a ledger, not while creating one.
- Press Alt+L (Update Opening BRS).
- For each outstanding item, enter the date (it must be before the Reconciliation Beginning Date), the particulars, whether it is a deposit or a withdrawal, the transaction type, the amount, and the instrument number and date if there is one.
- Save with Ctrl+A.
An example. Your books start reconciliation on 1 April 2026. The closing BRS for 31 March 2026 shows one cheque payment of ₹48,500, entered on 28 March and not yet presented. The bank debits it on 4 April. Without an Opening BRS line for that cheque, April’s reconciliation shows a difference of ₹48,500, because the bank debit has no book entry inside the period to match. With the Opening BRS line, the 4 April debit matches it and April reconciles to nil.
Enter the instrument number exactly as printed on the statement. That is what you will be matching against when the item finally clears.
Why older unreconciled entries are missing from the summary
The Bank Reconciliation Summary does not show every unreconciled entry by default. According to Tally’s guide to the reconciliation reports, its Default Period for Unreconciled transactions is set to Previous Financial Period, so entries from earlier years stay out of view even though they are still unreconciled.
To bring them back:
- Open the Bank Reconciliation Summary (Alt+G > Banking Activities, then Enter on the bank’s reconciliation count).
- Press F12 (Configure).
- Set Default Period for Unreconciled transactions to As per Reconciliation Beginning Date.
The same F12 screen has Show Unreconciled Transactions from Previous Period. Keep it on while you are clearing an old backlog.
Post-dated vouchers are a separate switch. If a cheque you entered with a future date is missing, press Ctrl+B (Basis of Values) and set Include Post-dated Vouchers to Yes.
A difference after upgrading to TallyPrime 6.0
This one is easy to miss. Tally’s own setup help says that Release 6.0 ignores unreconciled transactions older than six months. A company that reconciled cleanly before the upgrade can open the summary afterwards and find a difference it never had.
Tally lists these causes, and the fix for each:
| Cause | Fix |
|---|---|
| Unreconciled items older than six months were dropped in the upgrade | Add them to Opening BRS |
| Unreconciled book entries are older than the previous financial period | F12 in the summary, set the default period to As per Reconciliation Beginning Date, or reconcile them |
| Unreconciled book entries are dated before the Reconciliation Beginning Date | Reconcile them, add them to Opening BRS, or move the beginning date back so none fall before it |
| An entry was reconciled by hand, then the statement was imported with auto reconciliation on | TallyPrime treats the imported row as new. Enter its bank date by hand, or unreconcile the book voucher and link it to the imported row |
| A voucher imported from Excel does not appear in the summary at all | Open the voucher, fill in its Bank Allocation, save |
Work them in that order. The first two are settings rather than wrong entries, so check them before you start searching vouchers.
Redoing a month you already reconciled
Sometimes the back-date job is not a new period but an old one that was reconciled wrongly: a deposit matched to the wrong receipt, or a bank date typed against the wrong cheque.
- Open the Bank Reconciliation Summary and press F5 (View Reconciled). In the Bank Reconciliation report, Ctrl+H (Change View) > View Reconciled does the same.
- Select the transaction that was matched wrongly.
- Press Alt+F8 to unlink it from the bank row, or press F9 (Set Status) and choose System Inferred to mark it unreconciled.
- Reconcile it again against the correct line.
Do this before you move to the next month. A wrong match in March carries its difference into every month after it.
When the bank date is earlier than the voucher date
In manual reconciliation (press Alt+R in the Bank Reconciliation report), you enter a bank date against each transaction. Tally’s help says the bank date can be the instrument date, the voucher date, or a new date you type.
The awkward case is a bank date that falls before the cheque or voucher date. It happens when a customer pays by NEFT before you raise the receipt, and the receipt is then dated the day you entered it. In Tally.ERP 9, entering a bank date earlier than the instrument date was blocked unless Allow Back dated Reconciliation was set to Yes in the Bank Reconciliation screen’s F12 options, as Tally’s ERP 9 help describes.
Tally’s current TallyPrime help pages, updated 14 August 2026, do not list that option. Press F12 in your release’s Bank Reconciliation report and look for it before you plan around it.
Either way, the bank date is telling you something about the voucher. If the money reached the bank on the 3rd, a receipt dated the 5th is recording it on the wrong day. Correcting the voucher date is often the cleaner fix.
When the old period was never entered in Tally
Often the real reason a back period cannot be reconciled is that its transactions are not in the books at all. A client hands over eight months of statements at once, or a bank account was simply never posted. Reconciliation has nothing to match until those vouchers exist.
For a back period the statement is usually a PDF, and TallyPrime cannot import a PDF. As what TallyPrime’s bank statement import accepts explains, Tally’s own documentation also refuses a CSV or Excel file converted from a PDF. Typing months of transactions in by hand is slow, and every figure keyed wrongly becomes a reconciliation difference you then have to hunt for.
SmartXtract reads the bank statement PDF for Tally, checks every row against the statement’s running balance so a misread figure is caught before it reaches Tally, and suggests a ledger for each transaction. After you approve them, Tally Connector posts them to Tally as receipt, payment and contra vouchers. Then you reconcile the period as normal. You can try it free on 20 pages, with no card, using one of the months you are behind on.
Frequently asked questions
Can I do bank reconciliation for a previous year in TallyPrime?
Yes. Move the bank ledger’s Reconciliation Beginning Date back to the start of the year you want, then reconcile it in the Bank Reconciliation report as usual. If you only need last year’s uncleared cheques and deposits to carry forward, enter them in Opening BRS instead.
What is the Reconciliation Beginning Date in TallyPrime?
It is the date from which TallyPrime reconciles a bank ledger. It defaults to the first day of the financial year. Unreconciled entries dated before it are left out of reconciliation until they are added to Opening BRS.
How do I change the Reconciliation Beginning Date in TallyPrime?
Alter the bank ledger, set Set/Alter Bank configuration to Yes and enter the new date in Reconciliation Beginning date. Or go to Banking Activities, press Alt+H (Opening BRS), select the bank and press Alt+R (Set Recon Beginning Date).
What is Opening BRS in TallyPrime?
Opening BRS is the list of transactions dated before the Reconciliation Beginning Date that are still unreconciled, such as cheques issued last year and not yet presented. You enter them by altering the bank ledger, setting Set/Alter Opening BRS to Yes and pressing Alt+L.
Why are old unreconciled transactions not showing in the Bank Reconciliation Summary?
The summary’s Default Period for Unreconciled transactions is Previous Financial Period, so anything older is hidden. Press F12 in the summary and set it to As per Reconciliation Beginning Date. Entries dated before the beginning date stay hidden until they are added to Opening BRS.
Why is there a bank reconciliation difference after upgrading to TallyPrime 6.0?
Tally’s help says Release 6.0 ignores unreconciled transactions older than six months, so items that used to be counted no longer are. Add them to Opening BRS, or change the summary’s default period, and the difference should clear.
How do I undo a bank reconciliation in TallyPrime?
Open the Bank Reconciliation Summary and press F5 (View Reconciled). Select the transaction and press Alt+F8 to unlink it, or press F9 (Set Status) and choose System Inferred. It goes back to unreconciled and you can match it again.
Where to start
Settle the Reconciliation Beginning Date for each bank ledger first, then load Opening BRS from last year’s closing statement, and only then reconcile month by month. If a difference turns up anyway, checking the bank statement against Tally walks through what the size of the difference usually tells you. If imported statement rows are missing altogether, see why a bank statement import does not show in TallyPrime.