# Settlement Reports

## What it is

After each payout from Shopify, IDC automatically imports a settlement report that summarizes the payout amount, fees, and individual transactions. This report is saved in IDC's Settlements section, where your finance team can review the details and reconcile them against your bank deposits. IDC also imports the transaction lines (individual orders, refunds, chargebacks, and fees) that make up the payout, so you have a complete audit trail.

## What it generates

IDC imports two types of records for each Shopify payout:

1. **Settlement Summary** — A high-level record showing the payout date, gross amount, fees, net amount, and status.
2. **Settlement Transactions** — Detailed line items showing which orders, refunds, chargebacks, and fees contributed to the payout.

Together, these records let you verify that all orders have been accounted for in payouts and reconcile Shopify payouts with your bank records.

## How it works

Shopify pays out to your bank on a regular schedule (daily, weekly, or monthly depending on your account settings). Each payout generates settlement data in Shopify. IDC pulls this data on a schedule (typically hourly), creates a settlement record in the IDC Settlements page, and imports all transaction lines. Your finance team then opens the settlement record to review the breakdown, match it against their bank deposit, and mark it as processed.

## Flows involved

| Flow                          | What it does                                                                                                  |
| ----------------------------- | ------------------------------------------------------------------------------------------------------------- |
| **Payout Import**             | Fetches settlement summaries (payouts) from Shopify and creates a settlement record in IDC for each one.      |
| **Payout Transaction Import** | Fetches transaction lines (orders, refunds, fees) for each payout and attaches them to the settlement record. |

## Settings

This flow has no additional settings. Once enabled and scheduled, it runs automatically.

## Step by step — processing a payout

1. In the IDC dashboard, click **Settlements** in the left menu.
2. You'll see a list of settlement reports from Shopify, sorted by payout date.
3. Click on a settlement to open it and review the summary: gross amount, fees, and net payout.
4. Scroll down to see the transaction lines — each order, refund, chargeback, or fee that made up the payout.
5. Verify that the total matches your bank deposit.
6. Once verified, click **Mark as Processed** (or contact your finance team for approval first).
7. The settlement is now marked as reconciled in IDC.

See [Review and Process Settlement Reports](/idc/idc-core/settlements.md) for the full walkthrough with screenshots.

## Common issues

| Symptom                                      | What to try                                                                                                                                                                                                                                                                                  |
| -------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Payout not appearing in IDC                  | Check that both Payout Import and Payout Transaction Import flows are enabled and scheduled. Verify your Shopify connection is active. Check the activity log to see if the flows ran. Shopify typically generates payouts daily or weekly, so it may take time for the first one to appear. |
| Settlement amount doesn't match bank deposit | Verify the settlement date and time zone match your bank's records. Check that all transactions are included in the settlement (scroll through all transaction lines). Contact Shopify support if there's a discrepancy in Shopify's payout records.                                         |
| Transaction lines are missing                | Ensure the Payout Transaction Import flow is enabled and has run at least once after the payout was created in Shopify. Transaction lines are fetched separately from the summary.                                                                                                           |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.in8sync.com/idc/shopify/settlement-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.