How to Import Bank Transactions Using Excel (Bank Reconciliation)

Description: Use the Excel Import feature to upload bank statement data into Profitz for automated matching during bank reconciliation. This method streamlines the reconciliation process by allowing you to import bank lines directly from an Excel file and match them against system transactions.

Step‑by‑step instructions

Before starting, ensure you have access to your bank’s CSV or Excel statement file.

1. Navigate to Bank Reconciliation Setup

Go to General Ledger › Bank Reconciliation › Bank Reconciliation Setup.

2. Create a Bank Reconciliation Run

Click Add to create a new reconciliation run.

1. Bank Account: Select the bank account you are reconciling. This defaults to your primary bank account. Click the magnifying glass to choose another account.
2. Reference: Enter a unique reference for the reconciliation (e.g., May End of Month).
3. Date: Enter the date you are reconciling up to.
   • Important: No transactions after this date will be included.
4. Opening Balance: The closing balance from the previous reconciliation.
5. Closing Balance: The closing balance from your bank statement as at the reconciliation date.

Click Save to create the run.

3. Prepare Your Excel Spreadsheet

Profitz creates a view for your company based on the header names from your bank’s CSV file. You must use these exact headers when preparing your Excel file.

Follow these steps:

• Create or update your Excel file using the header names shown in Profitz.
• Your bank may require six headers, but this varies by bank.
• Important: If the header names do not match exactly, Profitz will not recognise the data.
• Spreadsheet Headers and Data should Appear like this.

4. Import the Excel Spreadsheet

Return to Profitz and select the reconciliation run you created.

1. Click Auto Reconcile

   

   In the new window, click Import from Excel.

2. Click Select and choose your Excel file.
3. Once the lines load, click Show Import Data.

4. Click Validate and Import.

   

Any issues will appear in the Errors column.

• If you need help, contact [e-mail].

Your Excel lines are now imported into the reconciliation run created in step 2.

5. Access Your Bank Reconciliation Run

Navigate to General Ledger › Bank Reconciliation.

1. Enter the Reference you created in Step 2.
2. Click Get Result.

System lines and imported bank lines will now appear side‑by‑side and can be auto‑matched.

FAQ

What if my Excel file won’t import?

Check that your header names match the Profitz view exactly. Even small differences will prevent import.

Can I re‑import if I made a mistake?

Yes. You can delete the run and create a new one or remove the imported lines and re‑upload.

Related articles

• How to Set Up a Reconciliation Run
• GL Bank Reconciliation – Excel Import & Auto‑Matching