Type search words and press enter
Seamless e-invoicing is now at your fingertips. Check out our self-help videos.

Account Reconciliation (India)

The Account Reconciliation feature in Tally.ERP 9 can be used for transaction-by-transaction reconciliation of the Company's Books  with Sister Concerns, Branch offices, etc., apart from third parties.

On this page

View and use the Account Reconciliation report

Loading Ledger

Loading Transactions

Button options in Account Reconciliation report

Configure Account Reconciliation report

View and use the Account Reconciliation report

Go to Gateway of Tally > Audit & Compliance > Audit & Analysis > Other Analysis > Account Reconciliation .

The Account Reconciliation report is displayed as shown below:

Select the required Ledger , and press Enter to reconcile.

Click here to know the F12: Configure options in this report

The Account Reconciliation sub-screen is displayed as shown below:

Account Reconciliation in Tally.ERP 9 can be done by:

Loading Ledger

Loading Transactions

Loading Ledger

This option is used if the data received can be loaded on Tally.ERP 9 in the form of a company.

In the Account Reconciliation sub-screen,

Choose Loading Ledger from the Compare By list.

Press Enter to move to the Name of Company field. Tally.ERP 9 displays the List of Companies that are open.

Press Enter to move to the With field. A List of Ledgers available in the compared company will be displayed as shown below:

Choose the required Ledger and press Enter .

The Account Reconciliation report appears.

Loading Transactions

This option can be used if the party concerned also uses Tally.ERP 9. The data can be exported as an XML file and sent across to the auditor, who will be able to import the same into his Tally.ERP 9 and use it for auditing purposes. Click here for the process to export XML file.

In the Account Reconciliation sub-screen,

Choose the option Loading Transactions from the Compare By list.

Press Enter .

The field Import file path with file name will appear. Specify the location of the XML file here, and press Enter again.

The Account Reconciliation report appears as shown below:

The transactions as per the user's books and the compared books will be displayed.

Account Reconciliation can be performed in two ways:

Accept Reconciliation

Manual Reconciliation

Button options in Account Reconciliation report

F1 : Condensed : Tally.ERP 9 will by default display a detailed Account Reconciliation report. Press Alt+F1 to view the condensed report.

F2: Period : Press F2 to change the selected period.

F7: Voucher : Select the required transaction in the Compared Book and press F7 to create Voucher entries from the Account Reconciliation screen. Tally.ERP 9 will automatically display the Voucher with the opposite nature of transaction, that is, if the transaction is a Purchase entry, the Voucher displayed will be a Sales Voucher .

F8: Show Ledger : Press F8 to view the default Ledger Vouchers report for the selected Party along with the details of the Opening Balance , Current Total and Closing Balance .

F9 : Remark : To add observations for the reconciled Vouchers, if any, press Alt+F9 . The Remark sub-screen will be displayed. Comments entered here will be displayed in the Account Reconciliation report.

Ctrl+F9 : Restore Remark : P ress Ctrl+F9 to undo remarks made for a transaction.

Ctrl+F10: Restore Default : Press Ctrl+F10 to change the Reconciled transactions back to their Unreconciled state.

Note: The F9 : Remark , Ctrl+F9 : Restore Remark , and Ctrl+F10 : Restore Default buttons will be highlighted when one or more Vouchers are selected using the Spacebar key.

F9: Inv Reports : Press F9 to navigate to the default Inventory Reports like Godown Summary , Movement Analysis , Stock Summary and so on.

F10: Acc Reports : Press F10 to navigate to the default Accounting Reports like Balance Sheet , Cash Flow , Trial Balance and so on.

F10: Audit Reports : Press Alt+F10 to navigate to the other Audit Reports within Statutory Audit .

Configure Account Reconciliation report

Click F12 : Configure or press F12 and use the following options to change the default view of the Account Reconciliation report:

Show Opposite Transactions to : Select the Type of Entries for which transactions of the opposite nature, from the Compared Books , has to be displayed. Users can view the Account Reconciliation report with opposite transactions from compared books for All Vouchers , Credit Entries only , or Debit Entries only .

Show Transactions Reconcile status of : This filter allows the user to view the report based on the Status of transactions, the report can be configured to display both unreconciled and reconciled transactions, only Reconciled transactions, or only Unreconciled transactions.

Show Unreconciled : Set this option to Yes to view Unreconciled transactions of both Company Books and Compared Books .