IPPB-APT Reconciliation Tool

IPPB-APT RECONCILIATION TOOL SUMMARY

• Generate difference reports between IPPB transactions & APT data
• Compatible with Excel 2013 or above

🏢 Set Up Office Data

• Enter HO pin code in Cell M2 → Click "Get Office Data" → Verify/update office details in Office Master sheet

📥 Obtain IPPB Report

• Get monthly IPPB report for all offices from IPPB branch in Excel format

💰 Generate APT Receipts Report

• Download IPPB receipts from APT-treasury (GL Account: 8455000200) for same period

💳 Generate APT Payments Report

• Download IPPB payments from APT-treasury (GL Account: 8455000300) for same period

🧹 Clear Previous Data

• Use "Clear All" button in IPPB Reconciliation sheet before importing new files

📤 Import Data Files

• Import IPPB report, APT receipts, and APT payments using respective buttons

📈 View Consolidated Data

• Click "View All Figures" for monthly consolidated transaction overview

🔍 Identify Differences

• Click "View Difference Figures" to see offices with IPPB-APT data mismatches

📅 Analyze Date-wise Differences

• Use "View Date Wise Difference Figures" for detailed daily analysis

📞 Support Contact

Email: mjprbr@gmail.com | Phone: 9790605858

Download IPPB-APT Reconciliation Tool