Payment Reconciliation Report

All the tax payment vouchers recorded for paying VAT and CST dues and other liabilities are displayed in Tax Payment Reconciliation report. For each payment, the bank and challan details have to be provided from this report.

To view the Tax Payment Reconciliation report

      Go to Gateway of Tally > Display > Statutory Reports > VAT > Payment Reconciliation

To set the payment details for each transaction

1.     Click S: Set Details. The Stat Payment Details screen appears with From and To dates.

2.     Retain or change the From and To dates.

3.     Enter the Deposit Date. It can be the cheque deposit date or the payment date.

4.     Enter the bank details in Name of the Bank, Name of Branch, Branch code(remittance) fields.

5.     Select the Type of Return from the list of payment types.

6.     Enter the Instrument No. through which the payment is made.

7.     Accept the Stat Payment Details screen.

Once these details are entered, the transaction disappears from this report. To display this transaction, enable the option Show transactions having challan details in Configuration screen.

Column Names

Description

Date

Displays the Payment voucher date.

Particulars

Displays the bank or cash ledger selected in payment voucher.

Vch Type

Displays the name of the voucher type like Payment.

Vch No.

Displays the payment voucher number.

Type of Tax Payment

Displays VAT or CST based on the Tax Type selected in Stat Payment Details screen of payment voucher.

Payment Period

Displays From and To dates entered in Stat Payment Details screen of Payment Reconciliation report.

Deposit Date

Displays From and To dates entered in Stat Payment Details screen of Payment Reconciliation report.

Amount

Displays the amount entered in payment voucher.

Configuration

Click F12: Configure and set the options as given below.

      Show Payments For: Based on the Payment Type selected here, the transactions are displayed. On selecting Payment Type as

o      VAT, only those payments recorded by selecting the Tax Type as VAT in payment voucher are displayed

o      CST, only those payments recorded by selecting the Tax Type as CST in payment voucher are displayed

      Show Transactions having Challan Details: By default, only those transactions recorded without providing challan details are displayed. On enabling this option, all tax payment vouchers for which challan details are provided will also be displayed.

      Show narration: On enabling this option, the narration entered in the payment voucher is displayed.