Creating a Bank Reconciliation Statement

To create a bank reconciliation statement, you need to upload your bank statement, then match the transactions between your bank and the ones recorded in IFS Cloud.

Uploading the Bank Statement

  1. Before connecting to IFS Cloud, download your bank statement in CSV format from your bank.
  2. In IFS Cloud, go to the page External File Assistant.
  3. In Set External File Type page:
    1. Check that Online Process is selected.
    2. In File Options > File Type, select Bank Statement.
    3. In File Template, choose the template corresponding to your company (for example, MPF BankStmt for Marport France office).
      Note:
      CSV files might have different headers depending on the country, so it is important to choose the correct template corresponding to your office.
    4. Add the CSV file as an attachment.


  4. Click Next.
  5. In Set Parameter Values page:
    1. Select the correct Cash Account.
    2. Complete the other details.


  6. Click Finish.

Matching the Transactions

  1. Go to the page Automatic Transaction Matching.
  2. Make sure to select your company, then select the Cash Account.
  3. The Reconciliation Date populates automatically with the date of the latest CSV bank file uploaded. It should match the date from the header of the uploaded CSV file. If not, change it.

  4. Click OK.
    The transaction matching page is displayed.
  5. Select the lines that match between Cash Transactions and Bank Transactions, then click Manual Matching each time you match a set of lines. Once matched, the lines disappear from the list.

    Note:
    Transactions by checks do not appear in this list. They are automatically matched.
  6. If you also want to show in the list the transactions that you have matched, deselect Exclude Matched at the top of the page.