Skip to main content

How to Reconcile Deposits

How to reconcile deposits in the Admin App

Written by Cyran Castelino

Caruso's Deposits tool allows you to efficiently match incoming bank transactions with investment applications. This ensures that investor payments are recorded accurately and applications are processed smoothly.


Step 1: Convert Your Bank Statement (If Needed)

If your bank exports data in a format different from Caruso’s standard, you’ll need to convert it first.

To convert your file:

  • In the navigation pane, select File Converter

  • Select Bank Statement and upload your bank's transaction file

  • Review the file mapping and update if necessary.

  • Download the converted deposit reconciliation file.


Step 2: Import Your Bank Statement

  • In the navigation pane, select Deposits

  • Upload the converted file

  • Click Save & Continue

Note: Caruso will automatically exclude negative transactions. The Reconcile feature currently supports deposits only.


Step 3: Match Transactions with Allocation Requests

Imported bank transactions are shown on the left side of the screen. The best matching investment application, if available, is displayed on the right.

Caruso's matching algorithm assigns a confidence score based on how closely transaction details align with existing allocation data.

Learn more about how matching works

High confidence matches are based on:

Transaction field

Caruso field

Reference / Code / Particulars

Matches the payment reference on an allocation request (this reference is automatically included in payment instructions and consists of the Fund Name, Offer ID, and Order ID), or matches the payment reference field of an investing entity with a valid application

Bank Account Number

Matches the bank account number of an investing entity with a valid application (includes fuzzy matching to allow for differences in the suffix)

Lower confidence matches may be suggested based on:

Transaction field

Caruso field

Reference / Code / Particulars

Matches the investing entity's customer reference (optional field)

Bank Account Name

Matches the investing entity's bank account name (includes fuzzy/partial matching)

Tip: Click the information icon beside a suggestion to view more details about the potential match.

Caruso only suggests orders in a Requested or Approved status. Completed and cancelled orders are never suggested — use Find & Match (Step 4) if you need to reconcile a deposit against one.


Step 4: Find Alternative Matches (If Needed)

If no suitable match is suggested, or the match appears incorrect:

  • Click Find & Match

  • Search using transaction details (bank account number, name, or reference)

  • Or search by Caruso records, including:

    • Investing entity name

    • Investing entity ID

    • Customer reference

    • Payment reference

    • Bank account number

    • Order ID

  • Find & Match shows orders in a Requested or Approved status by default. Turn on Include completed and cancelled orders to search across orders in any status.

  • Click Next once found, or move to Step 5 if you are unable to find the allocation


Step 5: Create an Application (If Needed)

If a deposit cannot be matched to an existing application, you can create a new one directly from the Deposits screen:

  • Click Create Application

  • Select the relevant investing entity and capital raise

  • Enter the investment amount, or the number of units where the capital raise is priced in units

  • Leave Mark new application as approved on (the default) to create the application in an Approved status — this automatically makes the deposit eligible for the next issuance batch

  • Turn on Mark as completed to mark the application as completed at the same time — completed applications are excluded from future deposit reconciliation suggestions and issuance batches

  • Click Next once ready

  • The deposit will be matched to the new application

Note: The Mark new application as approved toggle is only available if you have permission to review applications. Without it, applications are created as Requested.

Note: Applications created through the Deposits flow can bypass the capital raise's minimum and maximum investment limits.


Step 6: Confirm and Apply Payments

Once you have reviewed the match:

  • Select Reconcile deposit to record the payment

  • Click Confirm

  • (Optional) Send an email notification to the investor

Note: Reconciling a deposit records the payment only. Units are issued separately through the batch issuance workflow. Completed and cancelled orders are excluded from reconciliation suggestions by default — turn on Include completed and cancelled orders in Find & Match if you need to reconcile against one.


Tips and Best Practice

  • You can apply payments for amounts different from the allocation request. This is useful for partial payments or when an investor overpays

  • To learn more about issuing units, see How to Issue Units in Bulk (Batch Workflow)

  • To review all reconciled payments, download and view the All Deposits report from the Reports section


Related Articles


If you have any questions or need help at any stage, please contact our Caruso Support team either by email or live chat.

Did this answer your question?