Bank reconciliation in Sapera lets you reconcile the bank's statement against the entries registered in the financial journal. The screen works with bank reconciliation journals, and each journal is linked to a financial account. There are two import modes: File mode, where you manually upload a CSV or XLSX file from the bank, and Aiia mode, which connects to your bank via Open Banking and retrieves entries automatically without manual file upload.
If you cannot see the menu item, you most likely do not have permission for it. Contact support.
From Financial select Accounting and then Bank reconciliation. You are now on the overview of bank reconciliation journals.
The overview shows all created journals with the following columns.
Name: The journal's display name.
Description: Optional explanatory text.
Import mode: Indicates whether the journal uses File or Aiia mode.
Financial account: The financial account the journal is linked to.
Is connected to Aiia: Only shown if Aiia is enabled in the system. Indicates whether the journal is currently connected to a bank account via Aiia.
Not processed: Number of imported bank entries in the journal that have not yet been processed. The field is shown in bold when there are unprocessed entries.
You can double-click a row to open the reconciliation screen for that journal.
See How to search in lists for more about searching and filtering.
+ (New journal): Creates a new bank reconciliation journal. Opens the create/edit dialog.
Edit (pencil): Edits the selected journal's setup.
Delete (trash can): Deletes the selected journal after confirmation. Cannot be undone.
Clear journal: Deletes all imported bank entries from the selected journal without removing the journal setup itself. Requires confirmation.
Show entries: Navigates to the reconciliation screen for the selected journal.
Click + to create a new journal, or select an existing journal and click the edit icon. The dialog contains the following fields.
Name: The journal's display name in the overview. Required.
Description: Optional explanatory text about the journal.
Financial account: The financial account in Sapera's chart of accounts that the journal is to reconcile against. Required in Aiia mode.
Import mode: Radio buttons that determine how bank entries are retrieved. Choose File for manual upload of CSV/XLSX, or choose Aiia for automatic synchronization via Open Banking.
The following fields are only shown in File mode:
Financial date header: The column header in the import file that corresponds to the financial date. Can be filled in automatically by Sapera at import.
Amount header: The column header in the import file that corresponds to the amount. Can be filled in automatically.
Description header: The column header in the import file that corresponds to the description. Can be filled in automatically.
Default allowed day offset in days: Specifies how many days' difference is accepted by default in automatic matching. Valid values are 0-5. Example: If a payment is posted in Sapera on 1/10, and the bank file has an entry on 3/10 that otherwise matches on amount and description, Sapera can match these — provided the threshold is set to at least 2 days.
The following field is only shown in Aiia mode:
Ignore entries before: Date. Bank entries older than this date are not included in the synchronization.
The following field is always shown:
Show matched entries by default: Check box. If enabled, already matched entries are shown by default when you open the reconciliation screen for the journal.
Save the setup with Save. If you create a new journal in Aiia mode, and the journal is not already connected, you are taken to Aiia's connection flow.
Aiia is an Open Banking solution that gives Sapera direct access to the bank's transaction data. Before Aiia can be used, an administrator must have set up the integration with the following information under Aiia integration setup:
Client ID: Aiia's assigned client ID for the application.
Client secret: Aiia's assigned secret for the application.
Return URL: The URL Aiia returns the user to after approval.
Should use sandbox: Check box for the test environment. Disabled in production.
Contact support if the Aiia integration needs to be set up or changed.
Click Show entries in the overview (or double-click a journal row) to open the reconciliation screen. The screen is divided into two panels side by side: Bank entries on the left and Registered entries on the right.
At the top of the reconciliation screen is a filter bar with the following settings:
Financial date (From/To): Limits the registered entries shown on the right to a specific period.
Threshold in days: Dropdown that specifies how many days' date difference is accepted in matching. The setting applies to the current view.
Include matching: Check box. When enabled, already matched entries are shown in both panels.
See How to search in lists for more about searching and filtering.
The left panel shows the bank entries loaded into the journal — either via file import or Aiia synchronization.
At the top of the panel is shown:
Selected entries: Number and total amount for the selected rows.
Match difference: Amount difference between the selected bank entries and the selected registered entries. Shown in red text if the difference exceeds the minor-amount threshold.
Minor-amount threshold: Shown in red text when the match difference is too large. Specifies the maximum allowed difference.
In Aiia mode the following is also shown:
Closing balance: The balance retrieved from Aiia, including account name, owner and the time of the latest synchronization.
Not matched: The total amount for bank entries that have not yet been matched. Shown in red when the amount differs from zero.
Check box: Select the row for manual matching or removal of a match.
Financial account: The financial account the entry is linked to.
Org. unit: Organizational unit. The field can be edited directly in the row (inline edit).
Financial date: Date of the bank entry.
Amount: The entry's amount.
Description: Descriptive text from the bank file or Aiia.
Processed: Shows a check icon if the entry has already been processed (transferred to a posting journal). Shows a warning icon (triangle) if there is a high probability that the entry is a duplicate of an already processed entry — hover over the icon for details.
Match: A chain icon is shown if the entry is matched with a registered entry. Hover over the icon to see details about the match.
The right panel shows the entries registered in Sapera's finance for the relevant financial account.
At the top of the panel is shown:
Closing balance: The balance according to Sapera.
Org. unit: Shown if an org. unit filter is set.
Financial account: The financial account whose entries are shown.
Check box: Select the row for manual matching.
Type: Specifies whether the entry is a posted Entry or a Journal entry (not yet finally posted). Journal entries are shown in italics.
Financial account: The financial account the entry belongs to.
Org. unit: Organizational unit for the entry.
Financial date: Date of the entry in Sapera.
Amount: The entry's amount.
Description: Descriptive text.
Match: A chain icon is shown if the entry is matched with a bank entry. Entries matched with the currently selected bank entry are highlighted visually.
Posting journals (back arrow): Navigates back to the overview of bank reconciliation journals.
File: Opens the file import dialog for uploading a CSV or XLSX file from the bank. Only shown in File mode.
Auto-match with allowed X days diff. (dropdown): Runs automatic matching of bank entries against registered entries. The button is a dropdown menu where you can choose the allowed day offset: 0, 1, 2, 3, 4, 5, 10, 15, 20, 25 or 30 days. Matching is done on amount, description and date within the selected threshold.
Clear matching: Removes all existing matches in the journal so you can start the matching process over.
Match entries: Matches the currently selected bank entries (left) with the currently selected registered entries (right). The button is only active when entries are selected in both panels and the match is valid.
Remove match: Removes the match for the selected rows.
Clear selection: Clears the selection of all rows in both panels.
Delete: Deletes the selected bank entry from the journal. Only shown in File mode. Note: Deletion should be avoided, as you must manually recreate the deleted entry. The action is not available in Aiia mode.
Process entries: Transfers the matched bank entries to a posting journal in Sapera. Opens a dialog where you select the target journal. Entries that have already been processed are remembered as matched at the next reconciliation.
Clear journal: Deletes all imported bank entries from the current journal after confirmation.
Reconnect to Aiia: Only shown in Aiia mode, when the connection to Aiia has failed. Starts the reconnection flow.
Force synchronization: Only shown in Aiia mode, when the connection is active. Forces an immediate synchronization of transactions from the bank.
At the top of the screen's toolbar, two status indicators can also be shown in Aiia mode:
A rotating refresh symbol indicates that transactions are currently being retrieved from Aiia in the background.
A yellow warning icon indicates that the Aiia synchronization requires a supervised login — the connection to the bank must be renewed manually by the user.
Click File in the reconciliation screen to open the import dialog. Here a CSV or XLSX file from the bank is uploaded.
File upload: Select a file with the file type .xlsx or .csv from your computer.
Character set/Encoding: Only shown for CSV files. Select the character set (e.g. UTF-8) corresponding to the file's format.
First line is header: Check box. Tick it if the file's first line contains column headers. Uncheck it if the file does not have headers.
Click Process file to analyze the file. When the file is loaded, the columns from the file are shown, and you can map them to Sapera's fields.
Financial date (column mapping): Select which column in the file contains the financial date.
Amount (column mapping): Select which column contains the amount.
Description (column mapping): Select which column contains the description.
Financial account: The financial account the entries are to be imported to. Can be changed here if necessary.
Culture/language: Specifies the number format and date format in the file. Adjust it if the file uses a different country format than the default.
Update setup on import: Check box. If enabled, the selected column mappings, financial account and culture are saved automatically in the journal setup, so they are remembered for the next file import.
Confirm with OK to import the file into the journal.
Once you have matched the bank entries, you click Process entries to transfer the matched entries to a posting journal in Sapera. A dialog opens where you select the target journal.
Journal: Dropdown for selecting the posting journal in which the matched entries are to be created. Choose, e.g., "Daily Bookkeeping".
Confirm with OK. The entries are now created in the selected journal, and Sapera remembers the match relations, so these entries are shown as matched at the next reconciliation. In the journal you can optionally add further information (customer information, description, etc.) before final posting.
Payments of purchase invoices are normally uploaded to the bank via outgoing payments and are not expected to appear as unknown entries in the bank file. See Outgoing bank payments for more information.
If you have any questions, you are welcome to contact support.
Want to know more?
Read more in these related articles:
Bank setup
How to create and edit bank accounts for outgoing payments in Sapera, including bank format, reg. number, account number, folder and journal.
Bank import
Settings and workflow for bank import in Sapera: create import journals, import bank entries via file or Aiia, match them against registered entries and post the result.
Outgoing bank payments
Overview of generated payment files to vendors. From here you export payments to the bank, regenerate payout files, download CSV content, and view linked vouchers and invoices.
