Bank Reconciliation — CDT IT Tools

📋 Step-by-Step Reconciliation Process

Obtain Source Files

Faiva sends the soft copy of both the ANZ Bank Statement and TTM Transactions for the period being reconciled.

Compare Deposits and Credits

Go through the ANZ statement and check these against CDT Toutaimana internal records, marking each transaction. Ensure the exact amount Dr/Cr on the ANZ Tonga statement matches the corresponding entry recorded in the CDT Toutaimana ledger.

Identify Outstanding Items

⏳ Unpresented Cheques — Transactions recorded in the CDT ledger that have not yet been cashed or processed by the bank.

💰 Outstanding Deposits / Credits — Funds recorded locally but which do not yet appear on the current ANZ / TTM statement.

📂 Upload both Excel files to begin

① ANZ Bank Statement

🏦

ANZ Bank Statement

Click or drag & drop .xlsx file

② TTM Ledger

📒

TTM Ledger

Click or drag & drop .xlsx file

✅ 1. Matched Cheque Transactions

Chq/Ref	TTM Date	ANZ Date	Amount (TOP)	Description	Status

⏳ 2. Unpresented Cheques — In TTM, not yet cleared in ANZ

Chq/Ref	TTM Date	ANZ Date	Amount (TOP)	Description	Status

🔴 3. Cheques in ANZ — Not recorded in TTM

Chq/Ref	TTM Date	ANZ Date	Amount (TOP)	Description	Status

💰 4. Matched Deposits / Credits

Amount (TOP)	TTM Date	ANZ Date	TTM Description	ANZ Description	Status

⚠️ 5. Credits in ANZ — Not matched in TTM

Amount (TOP)	TTM Date	ANZ Date	TTM Description	ANZ Description	Status