How to Complete a GL Bank Reconciliation Using Excel Import and Auto Matching

Description: Use the Excel Import and Auto‑Matching method to quickly reconcile your bank statement transactions with Profitz system transactions. This process imports bank lines from Excel, pairs them with system transactions, and finalizes the reconciliation once all differences are resolved.

Step‑by‑step instructions

Before starting, ensure you have:

• Created a Reconciliation Run
• Imported your bank statement using Excel Import Bank Reconciliation

1. Select the Reconciliation Run

Locate the reconciliation run you created earlier.

• Enter the Reference for the run.
• Click Get Result to open the reconciliation.

2. View System Transactions and Imported Bank Transactions

After clicking Get Result, all Profitz system transactions appear on the screen.

Important: To use Auto Matching, your bank statement must be imported using the Excel Import process. Imported bank lines will appear alongside system lines and can be paired automatically.

See Excel Import Bank Reconciliation for instructions.

3. Understand the Bank Reconciliation Header

Date: The reconciliation run date. Transactions after this date are excluded.

• Opening Balance: Closing balance from the previous reconciliation run.
• Closing Balance: Bank statement closing balance for this run.
• Unreconciled Amount: Must reach 0 before reconciliation can be completed.
• Gltr Credit / Gltr Debit: Profitz system transaction totals.
• Glab Credit / Glab Debit: Bank transaction totals (from Excel import).
• Tick All / Untick All: Select or deselect all transactions.
• Auto Matching: Automatically pairs system and bank transactions.
• Reconciled: Finalizes the reconciliation when the Unreconciled Amount is 0.

4. Reconcile Transactions Using Auto‑Matching

All system and bank transactions appear in the grid.

You can identify transaction types by:

• Status column:
  • Bank = imported bank transaction
  • System = Profitz GL transaction
• Amount colour:
  • Black = bank transaction
  • Blue = system transaction

Pair transactions automatically

Click Auto Matching to pair bank and system transactions.

• Paired transactions:
  • Status shows Paired
  • Tick box is filled with a blue tick
• Unpaired transactions:
  • Status shows Bank or System
  • Tick box is empty

If transactions do not pair

Use:

• AR Cash Posting
• Post Missing Bank Entry

These tools allow you to create missing GL transactions directly from the reconciliation screen.

Note: If a transaction is not an AR/Debtor cash posting or a journal, you must create the matching transaction manually in the system.

5. Complete the Reconciliation

Once:

• All required transactions are paired
• The Unreconciled Amount is 0

…the Reconciled button becomes available.

Click Reconciled to continue.

6. Confirm the Reconciliation

A confirmation message appears.

If the details are correct:

• Click Yes to finalize the reconciliation
  • Important: This action cannot be reversed.

7. Reconciliation Complete

A message confirms that the reconciliation is complete.

 

8. What Happens After Reconciliation

• Paired and ticked transactions → Will not appear in future reconciliation runs.
• Unpaired system transactions → Will appear in the next reconciliation run.
• Unpaired bank transactions from Excel import → Will not appear in the next run → Must be re‑imported in a new run → See How to Import Bank Transactions Using Excel (Bank Reconciliation)

FAQ

Why didn’t Auto Matching pair all transactions?

Some transactions require manual matching or must be created using AR Cash Posting or Post Missing Bank Entry.

Why did my imported bank lines disappear?

Unpaired Excel transactions do not carry forward. Re‑import them in a new run.