Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.orkesta.com.tr/llms.txt

Use this file to discover all available pages before exploring further.

Orkesta’s reconciliation engine automatically matches processed payments against bank statement entries and imported ERP records, flagging any discrepancies for manual review. This reduces the time spent on end-of-period close and gives your finance team a clear audit trail for every transaction.

How reconciliation works

Reconciliation runs in three phases: 1. Import Bank statement files are ingested into Orkesta automatically via the bank connector integration, or uploaded manually in MT940 or CSV format. ERP records can be imported via the ERP connector or uploaded as a CSV export from your accounting system. 2. Match Orkesta compares each statement entry against processed payments using amount, value date, and the reference field. Each potential match receives a confidence score:
ScoreMeaning
ExactAmount, date, and reference all match precisely. Approved automatically.
FuzzyTwo of three criteria match (e.g., amount and date match but reference differs). Requires manual approval.
UnmatchedNo suitable payment found for this statement entry. Appears in the reconciliation queue for investigation.
3. Review Unmatched and fuzzy-matched items appear in the Reconciliation queue. Your team reviews each item, approves correct fuzzy matches, and assigns manual mappings for unmatched entries. Once all items in a period are resolved, you finalize the reconciliation run.

Starting a reconciliation run

1

Go to Payments → Reconciliation

In the left sidebar, select Payments, then click Reconciliation.
2

Select the account and statement period

Choose the account you want to reconcile and set the statement start and end dates.
3

Click Run reconciliation

Orkesta imports the latest statement data (if using a bank connector) and starts the matching process. Large periods may take a few seconds to process.
4

Review matched and unmatched items

The results table shows three sections: Exact matches (auto-approved), Fuzzy matches (needs review), and Unmatched (needs investigation). Filter by section to focus your review.
5

Approve matches or assign manual mappings

For each fuzzy-matched item, confirm or reject the suggested match. For unmatched items, search for the correct payment and assign it manually, or mark the item as an exception with a note.
6

Click Finalize to mark the period as reconciled

Once all items are resolved, click Finalize. The period is locked and marked as reconciled. No further changes can be made without reopening the period (Admin only).

Exporting reconciliation results

Export the full reconciliation results from the results page using the Export button. Orkesta supports two formats:
FormatContents
CSVAll matched, fuzzy, and unmatched items with amounts, dates, references, and match scores. Suitable for import into accounting systems.
PDFFormatted reconciliation report with summary totals and exception list. Suitable for audit files and sign-off.
Schedule a recurring CSV export at period end and route it automatically to your ERP or accounting integration. This removes the manual download step and keeps your general ledger current without extra effort.

Via API

Retrieve reconciliation results programmatically using the GET /reconciliation endpoint.
curl -X GET "https://api.orkesta.com.tr/v1/reconciliation?account_id=acc_01HXYZ&period_start=2024-10-01&period_end=2024-10-31" \
  -H "Authorization: Bearer YOUR_API_KEY"
The response contains a summary and an array of reconciliation items:
{
  "account_id": "acc_01HXYZ",
  "period_start": "2024-10-01",
  "period_end": "2024-10-31",
  "status": "in_progress",
  "summary": {
    "total_items": 142,
    "exact_matches": 128,
    "fuzzy_matches": 9,
    "unmatched": 5
  },
  "items": [
    {
      "id": "rec_01HABC",
      "type": "exact",
      "payment_id": "pay_01HXYZ123",
      "statement_reference": "INV-2024-001",
      "amount": 5000,
      "currency": "TRY",
      "value_date": "2024-10-15",
      "confidence": "exact"
    }
  ]
}
Automatic reconciliation accuracy improves when you populate the reference field consistently in every payment. Exact matches require a reference that aligns with the statement entry — without a reference, Orkesta falls back to amount and date matching, which increases fuzzy and unmatched rates.