Use Reconciliation

Introduction

Reconciliation ensures your platform records match with custodian records. This is key for accurate reporting and investment analysis.

Accessing Reconciliation

You can access reconciliation data in two ways:

Go to the Reconciliation page from the dashboard

👉 New to some terms? Check out our full Platform Glossary for more.

Reconciliation Table Overview

Use the table reference below when you're performing it.

Reconciliation Check Fields Explained:

Field Name	Description
Bank Account	A bank account is held by a bank or custodian to manage a client’s funds and securities for investment.
Bank Ccy	The currency in which the bank’s transactions or positions are recorded.
Bank Instrument Name	The name or symbol of the instrument as recorded by the bank.
Bank Pos Qty	Indicates the number of units or quantity of the instrument held, as reported by the bank. Special Cases: Asset Types: Bond and Option Calculation Rules: For bonds: If the bank provides quantity without a nominal value, calculate the quantity by multiplying it with the Nominal Bond Amount. For options: If the bank includes OPT_CONT_SIZE, calculate the adjusted quantity by dividing the reported quantity by OPT_CONT_SIZE.
Bank Price	The price per unit of the instrument as recorded by the bank.
Bank Tr Qty	The number of units transacted (bought/sold) according to the bank.
Bank Value	The total value of the instrument in the bank’s records, it depends on asset type.
Instrument	The name or identifier of the instrument according to the platform.
New Instrument	The updated or new identifier for the instrument that may have been changed internally.
New Pos Qty	New position quantity after updates
platform Ccy	The currency in which the platform records its transactions or positions.
platform Instrument Name	The name or symbol of the instrument as recorded in the platform.
platform Pos Prev Day Qty	The quantity of the instrument held in the platform at the close of the previous day quantity.
platform Price	The price per unit of the instrument according to the platform.
platform Value	The total value of the instrument in the platform, calculated as platformPosPrevDayQty * platformPrice.
Status	A status indicator that shows whether the reconciliation for that particular instrument or transaction is accurate.
Diff	Difference in position quantity/value between bank and platform
platform New Positions	Adjusted positions post reconciliation
Diff Prev Day	Difference between positions from previous day and current day
Current Status	Indicates the current day’s reconciliation status
Bank Name	Name of the Custodian
platform Name	platform-recognized name

The platform compares bank-reported values with platform data and marks them as:

Green: Bank and platform Data Match
Red: Mismatches found

Error Message shows that the platform Ccy doesn't match with Bank Ссу.

Progress bar of the reconciliation will help you to estimate the time required for conducting a bank account reconciliation.

Transactions Tab – Reconciliation

The Transactions tab provides a breakdown of all transactions imported into the platform for reconciliation. This view helps users monitor data integrity, identify discrepancies and investigate mismatches or errors across systems.

Transactions Screen Overview

The top section gives a summary for a specific date, in this case: 2025.01.01.

Section	Description
Error Transactions	Total number of transactions that failed validation (e.g., currency mismatch, unknown subtype, missing data). In this example, 14 errors were detected.
Unmatched Transactions	Transactions that could not be reconciled with any corresponding record on the platform. Here, 6 unmatched entries require review.
Missing Instruments	Transactions involving instruments (e.g., securities) not found in the system. This is 0, meaning no instruments are missing for this date.

You can click "See More Details" under each card to drill down into specific records.

Troubleshooting Steps

Learn more here:

Step 1: Inspect File via Connectors

Go to Transactions > Connectors
Click on Failed files
Open file, verify File Time, check for format issues

Step 2: Classify Failure

Issue Type	Description
Format Error	Column headers missing
Missing Data	Price or instrument empty
Corrupted Upload	File unreadable
Mapping Issues	Instrument not linked in platform

Step 3: Take Action

Issue	Recommended Action
Missing fields	Ask custodian for updated file
Mapping error	Update via instrument directory
File OK, but failed	Try Reprocess in Connectors

Send these details to your platform Admin or Reluna support team for advanced troubleshooting.

Frequently Asked Questions

Clear Your Doubts Here:

Who is this for?
For financial analysts to review and resolve data mismatches.
What if Reconciliation % is low?
Check red-highlighted rows in the Reconciliation Check screen, mismatches exist.
Can I export the table?
Yes, use the Export button option.
Why does platform and bank data differ?
Could be due to format or mapping mismatches.

Want to Monitor File Processing?

Use the Connectors tab to check file upload status, identify failed files and reprocess them if needed.

See Guide: Using the Connectors feature for more.