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 in 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.

 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.

Bank Name

Displays the name of the bank where the payment was made.

Branch Name

Displays the bank's branch where the payment was made.

Branch Code

Displays the bank's branch code where the payment was made.

Return Type

Displays whether the return is revised.

Instrument No.

Displays the number of the instrument used to make the payment.

Amount

Displays the amount entered in payment voucher.

Configuration

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

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

o      VAT - Displays payments recorded by selecting the Tax Type as VAT in payment voucher are displayed.

o      CST - Displays payments recorded by selecting the Tax Type as CST in payment voucher.

      Show transactions having challan details?: By default, transactions recorded without providing challan details are displayed. Enable this option to view all tax payment vouchers for which challan details are provided.

      Show narration?:Enable this option to view the narration entered in the payment voucher.