> ## Documentation Index > Fetch the complete documentation index at: https://waffo.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Which settlement data can I actually get, and where? > Answers the 'can you add this field / is there an API for this' class of reconciliation question: which identifiers and dimensions exist in the transaction export, the settlement reports and the money-movement APIs, which ones do not exist at all, why three exports of the same month disagree, and which document is issued to whom. [Settlement File Specification](/docs/en/support/settlement-file-specification-faq) is the column-by-column contract for the three report files. [Settlement Reports & Exports](/docs/en/support/settlement-reports-export-faq) covers how to pull a report on demand. **This page answers the question one step before those**: for a given piece of data — a card network reference, your customer's country, the settlement amount in your settlement currency — does it exist at all, and if so through which channel. Read it before asking support to add a column: several of the most-requested fields are not "unavailable in the export", they are not held in a merchant-visible form anywhere. ## What are my three ways of getting settlement data? | Channel | What it gives you | Shape | | - | - | - | | **Reconciliation report files** | Transaction Details, Settlement Details, Settlement Summary | CSV, UTF-8, per day or per settlement batch | | **Merchant Portal exports** | Transaction list, billable-transaction list, settlement reports, withdrawal list, balance history | Background export task, CSV inside a zip | | **API** | Order/refund/chargeback inquiry, balance inquiry, account history, withdrawal consult/create/inquiry | JSON, request/response | There is **no API that returns a reconciliation report or a settlement batch**. Settlement-level data reaches you as files (Portal download or SFTP delivery), never as an API response. If your finance system needs settlement data programmatically, the integration point is the file, not an endpoint. ## Is there an API I can use to receive my money-movement records? Yes, for **balance and account movements** — not for settlement reports. Five merchant endpoints exist: | Endpoint | Purpose | | - | - | | `/api/v1/account/balance/inquiry` | Current balances per currency and account | | `/api/v1/account/history/inquiry` | Account movement rows (the API equivalent of Balance History) | | `/api/v1/withdraw/consult` | Pre-check a withdrawal: fee, receivable amount, rate | | `/api/v1/withdraw/create` | Create a withdrawal | | `/api/v1/withdraw/inquiry` | Withdrawal status and outcome | See [Withdrawal & Balance API](/docs/en/support/withdrawal-and-balance-api-faq) for the request and response contracts and the query-window limits. So the practical split is: **account movements → API; settlement composition → file.** ## Can I get the RRN (Retrieval Reference Number, field 37) in my settlement file? No. There is no `RRN` column in any of the three reconciliation reports, and none in the Portal transaction export. For card transactions the merchant-visible references are: | Identifier | Where you get it | What it identifies | | - | - | - | | `Order Id` | Reports, exports, order inquiry | Waffo's identifier for the transaction | | `Merchant Order Id` | Reports, exports, order inquiry | Your own identifier | | `payMethodRefId` | Order inquiry, inside `payMethodResponse` | The reference your customer sees in their own payment-method statement or app | | `schemeTransactionId` | Order inquiry, inside `payMethodResponse` | The card-scheme transaction identifier used to chain a stored-credential series | `payMethodResponse` is a JSON string on the order inquiry response, and the object returned to you carries a **fixed set of keys** — payment-method reference, scheme transaction id, token id, masked card data, card metadata, the amount and currency your customer actually paid, and the rate the payment method used. A network retrieval reference is not one of them, so it cannot be reached by parsing that field either. If you are trying to trace a specific transaction with a bank or an issuer, open a support case with the `Order Id` and the payment date; that is the identifier Waffo can trace end to end. ## Can you add a column to my report — my own refund id, my customer's country, an extra reference? The exported column set is fixed per report type. It is the same for every merchant, and it is not extended per account. What you can control is: | Control | Where | Effect | | - | - | - | | Which report types you receive | Report delivery configuration | Adds or removes whole files | | Which fields a **Customized Export** contains | Portal, when building the export | Selects from the available field list | | Where files land | Report delivery configuration | Portal only / Waffo SFTP / your SFTP / email | See [Report Delivery & Email Subscription](/docs/en/support/report-delivery-and-subscription-faq). Some fields you may be looking for are already present under a different name — check [Settlement File Specification](/docs/en/support/settlement-file-specification-faq) before requesting anything: * your own reference on a payment is `Merchant Order Id`, and on a refund `Merchant Original Order Id` identifies the payment you refunded * the payment a refund or chargeback belongs to is `Original Order Id` * your own user identifier, if you sent one on order create, is `Merchant User Id` ## How do I report by my customer's country? The reports only show currency. There is **no consumer-country column**. The country dimension that exists is the country of the **payment method**, not the location of the person paying: | Column | Present in | Means | | - | - | - | | `Pay Method Country/Region` | Portal transaction export | The country/region the payment method belongs to | | `Order Currency` | All reports and exports | The currency you charged in | | `cardIssueCountryCode` | Order inquiry, for card payments, inside `payMethodResponse` | The card issuer's country (ISO 3166-1 alpha-3) | Two consequences worth being explicit about: * Grouping the transaction export by `Pay Method Country/Region` gives you **revenue by payment-method market**, which is the closest available proxy and is what most merchants end up using. It is not the same as your customer's residence — a customer can be anywhere and use a method registered in one market. * For card volume specifically, `cardIssueCountryCode` on order inquiry is a per-transaction issuer country. It is available through the API only, not as a report column, so building an issuer-country breakdown means enriching your own records at payment time rather than after the fact. Portal analytics also breaks volume down by country for the payment-method dimension — see [Portal Analytics](/docs/en/support/portal-analytics-faq) — so for a quick answer you may not need an export at all. ## My order is in a non-USD currency. Where is the settlement-currency amount? Not in the transaction export — that file has no settlement columns at all, because a transaction is exported the day after it happens and its settlement may not exist yet. | Looking for | Look in | | - | - | | The order amount converted to your settlement currency | `Order Amount (Settlement Currency)` in Settlement Details, and in the settlement report export | | The rate used | `Forex Rate` / `Forex Currency Pair` in Settlement Details | | The net amount per transaction type | Settlement Summary | | An estimate before the settlement exists | Settlement estimation export, which carries `Est Forex Rate` and `Est Order Amount (Settlement Currency)` | The conversion itself, including which pair and which rounding rule applies, is in [Settlement Calculation Explained](/docs/en/support/settlement-calculation-explained). ## Is there an API that gives me the settlement amount in my settlement currency? No. This is the single most-asked variant of the previous question, and the answer is the file: `Order Amount (Settlement Currency)` in Settlement Details, keyed by `Order Id`, is the row you join to your own ledger. If you need this as a feed rather than a download, configure delivery to your own SFTP so the file is pushed to you and your job picks it up — see [Report Delivery & Email Subscription](/docs/en/support/report-delivery-and-subscription-faq). ## Can I see my funds broken down per channel instead of one account balance? No. Your money is presented to you as **accounts**, not as channel positions: | What you see | Where | | - | - | | Pending settlement balance, settlement account balance, reserve balance, withdrawable amount | Portal → Account → Balance, and `/api/v1/account/balance/inquiry` | | Every movement that changed those balances | Portal → Balance History, and `/api/v1/account/history/inquiry` | There is no per-channel funds screen in the Merchant Portal and no per-channel breakdown in the balance API. If you cannot find it, it is not a permission problem — the dimension does not exist on the merchant side. See [Balance & Account History](/docs/en/support/balance-and-account-history-faq) for what each balance means and [Settlement Account Structure](/docs/en/support/settlement-account-structure-faq) for why one currency can show more than one account. ## Three exports of the same month disagree. Which one is authoritative? They disagree because they answer three different questions. None of them is wrong: | Export | Row basis | Date basis | Use it for | | - | - | - | - | | Transaction list export | Every transaction, any status | Payment date | Operational volume, order-level lookups | | Billable-transaction export | Transactions that carried a fee, including **failed** ones | Payment date | Explaining a fee you did not expect | | Settlement report export | Transactions inside a settlement batch | Settlement date | What Waffo actually paid you | For "what did I get paid", the **settlement report** is authoritative — it is the same data the money movement was built from. For "what did I sell", the transaction list is authoritative. The classic mismatch has one cause: a transaction that happened in the last days of a month settles in the next month, so it is in one month's transaction export and the next month's settlement report. See [Should I export by Payment Date or by Settlement Date?](/docs/en/support/settlement-reports-export-faq) and [Settlement Cycle](/docs/en/support/settlement-cycle-faq). ## Why can't I find an order from last month's settlement report in my transaction list for that month? Because you filtered the transaction list on a **payment date** in that month, and the order's payment date is in the previous one. A settlement report covering a settlement date in November routinely contains transactions paid in October. To find it: search the transaction list by `Order Id` with no date filter, rather than narrowing by month. ## Does filtering the transaction list on "payment successful" give me my revenue for the month? No, for three reasons, in order of how often they bite: 1. **It is gross, not net.** Fees, taxes and reserve holds are applied in settlement, not on the transaction. See [Settlement Calculation Explained](/docs/en/support/settlement-calculation-explained). 2. **Refunds and chargebacks are separate rows** with their own dates. A payment succeeded in the month and was refunded in the month both count once each. 3. **Successful is not settled.** Some of those transactions have not entered a settlement batch yet. For a revenue figure, start from the settlement reports. For an accrual figure, the settlement estimation export gives you the not-yet-settled part with `Est` columns marked as estimates. ## What does the Settlement Status column mean, and do UNSETTLED orders count as this month's revenue? `Settlement Status` on a settlement report export tells you whether the transaction has entered a settlement batch: | Value | Meaning | | - | - | | `SETTLED` | The transaction is in a settlement batch; its settlement amounts are final | | `UNSETTLED` | The transaction has not entered a batch; any settlement amount shown for it is an estimate | Whether an `UNSETTLED` transaction belongs in this month's revenue is an **accounting-policy question**, not a Waffo one: on a cash basis it does not, on an accrual basis it does and the estimate columns are what you would accrue against. Waffo does not restate the month once those rows settle — they simply appear as `SETTLED` in a later report. More on the column and the export filter in [Settlement Reports & Exports](/docs/en/support/settlement-reports-export-faq). ## What is the difference between Settlements → Transaction and the Transactions page? They look similar and answer different questions: | Screen | One row is | Money view | | - | - | - | | **Transactions** | A payment, refund or chargeback you or your customer created | What happened | | **Settlements → Transaction** | A transaction as it entered settlement, with its fee, rate and settlement amounts | What it was worth to you | A transaction appears on Transactions immediately and on Settlements → Transaction only once settlement has processed it. A transaction that was billed but carried no order amount — a failed transaction that still incurred a fee — appears on the settlement side and looks odd on the transaction side; that case is covered in [Failed Transaction Billing](/docs/en/support/failed-transaction-billing-faq). ## Where do I download settlement batch details now? Portal → Settlements → Reports. Batch-level detail, Customized Export and the settlement estimation export are all **background tasks**: you request one, it is built, and it appears in the export history on the same screen as a downloadable file — it does not stream to your browser. If the only export type you can produce is a narrow one, the export types available to you depend on your account's report configuration. The full list of types and their date-span ceilings is in [Settlement Reports & Exports](/docs/en/support/settlement-reports-export-faq); task statuses and download link lifetimes are in [Export Center](/docs/en/support/export-center-faq). ## Which identifier ties a report row to the money that arrived in my bank? Depends which end you start from: | You have | Join on | | - | - | | A settlement report row | `Settlement Batch Id` — every row in one batch was paid as one movement | | A credit on your bank statement | The settlement batch for that settlement date and settlement currency; a Settlement Statement PDF exists per batch | | A withdrawal on your bank statement | The withdrawal order id, and `bankRefId` from withdrawal inquiry | | An individual transaction | `Order Id`, which appears in both the transaction and the settlement reports | One settlement date can produce more than one batch — see [Settlement Batch & Calendar](/docs/en/support/settlement-batch-and-calendar-faq). ## Can I issue an invoice to my own customer from the Portal? No. The two documents Waffo produces have fixed directions: | Document | Issued by | Issued to | Covers | | - | - | - | - | | **Invoice** | Waffo | You | Waffo's fees, grouped by fee currency | | **Settlement Statement** | Waffo | You | One settlement batch | | **Receipt** | You, through Waffo | Your customer | One transaction | So the Invoice in your Portal is Waffo's invoice **to you** for fees. It is not a document you can pass to your customer, and there is no feature that issues a merchant invoice to an end customer. The customer-facing document is the transaction **Receipt** — content, configuration and delivery are in [Receipt Configuration & Download](/docs/en/support/receipt-configuration-and-download-faq) and [Portal Receipts](/docs/en/support/portal-receipt-faq). Invoice numbering, why several attachments arrive at once, and what is excluded from the Invoice are in [Settlement File Specification](/docs/en/support/settlement-file-specification-faq). ## Can I get an invoice for a transaction that is refunded, or not yet settled? The Invoice covers **fees on settled transactions**, and its date is derived from the latest actual settlement date in the set it covers. A transaction that has not settled has not contributed a fee to any invoice yet, so it is not on one. It appears on the invoice covering the period in which its settlement lands. *** Still stuck on a specific field? [Contact support](mailto:support@waffo.com) with the report file name and the column you are looking for — naming the file lets support tell you whether the field exists under another name or not at all. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.