Bank Statement Reconciliation made Easy | EZTax.in GST Help Center

🏦

Understanding Bank Reconciliation

Compare your accounting records against bank statement transactions to ensure financial accuracy.

Bank reconciliation is the process of matching your EZTax.in records against bank statement transactions. It helps identify discrepancies, detect unauthorized transactions, and ensure your books match your bank records perfectly.

✅

Verify Accuracy

Ensures your accounting records match actual bank transactions.

🔍

Detect Errors

Identifies recording errors and unauthorized transactions quickly.

📊

GST Compliance

Ensures all transactions are correctly recorded for GST filing.

📈

Cash Flow Clarity

Reveals timing differences between recorded and cleared transactions.

📥

Step 1: Upload Bank Statement

EZTax.in provides a simple Excel template for uploading your monthly bank statements.

1
Download the Reconciliation Template
Go to Bank Transactions Reconciliation from the menu and download the provided Excel template.
2
Prepare Your Bank Statement
Export your monthly bank statement in Excel format from your bank's online portal.
3
Copy Transaction Data
Paste your bank transactions (without headers) into the downloaded template — include dates, amounts, descriptions, and transaction types.
4
Upload to EZTax.in
Upload the completed Excel file through the Bank Reconciliation interface in EZTax.in.

⚙️

Step 2: Map and Configure Columns

Ensure EZTax.in correctly identifies the columns in your bank statement.

1
Select Transaction Date Column
Identify which column contains the transaction date — crucial for matching with your invoices.
2
Select Debit Column
Specify the column containing debit amounts (money going out of your account).
3
Select Credit Column
Specify the column containing credit amounts (money coming into your account).
4
Map Description / Reference
Identify the column with transaction descriptions or references to help match with your records.

💡 Column Mapping Tip: If your bank statement uses different column names, EZTax.in lets you manually select which column corresponds to each field.

✓

Step 3: Run Reconciliation

After uploading, EZTax.in analyzes and categorizes all your transactions into three groups.

✅

Fully Matched

Transactions already in your EZTax.in records that align perfectly. No action needed.

⚠️

Partially Matched

Minor differences found. Review and adjust or mark as reconciled.

❓

Unmatched

Create new entries in EZTax.in or mark invoices as directly paid for unmatched items.

🏦

Bank Fees & Interest

These appear on bank statements but must also be recorded in EZTax.in manually.

⏰ Timing Differences: Payments may clear on different dates — this is normal. Consolidated deposits may match multiple invoices. Review carefully before marking unmatched.

Keep Your Books Accurate

Our GST experts can help you set up bank reconciliation for complete financial accuracy.

📞 Call Us 💬 WhatsApp 🗨️ Live Chat 🚀 Start Free Trial

Online Software

Expert Services

Pricing

Help Center

Bank Statement Reconciliation in EZTax.in GST Accounting

Keep Your Books Accurate