Syntax
=DRAGON_FINANCE(account, [ASIN/SKU], [marketplace], [period], [event], [kind], [type], [columns], [header], [transpose])
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
This page is also available inside Sheets – type
=DRAGON_FINANCE("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_FINANCE("Nordvik", "", "US", "last 12 months")| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | period | event | kind | type | amount | currency | line_count |
| 2 | US | 2026-10-12 | SHIPMENTEVENTLIST | CHARGE | PRINCIPAL | 28.95 | USD | 85 |
| 3 | US | 2026-10-11 | SHIPMENTEVENTLIST | FEE | COMMISSION | 29.95 | USD | 19 |
| 4 | US | 2026-10-10 | SHIPMENTEVENTLIST | CHARGE | FBAPERUNITFULFILLMENTFEE | 30.95 | USD | 50 |
| 5 | US | 2026-10-09 | SHIPMENTEVENTLIST | FEE | TAX | 56.95 | USD | 81 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or a list separated by ;. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| period | Optional | Optional period such as last 12 months, 2026-04, or 2026. Default: last 12 months. |
| event | Optional | Optional finance event type filter. |
| kind | Optional | Optional finance line kind filter such as FEE, CHARGE, or TAX_WITHHELD. |
| type | Optional | Optional finance line type or subtype filter. |
| columns | Optional | Optional output columns separated by ;. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use yes, true, or 1 to transpose the output. |
The period accepts values like last_30_days, this_month, 2026Q1, or ranges like 2026-01-01..today – see the full period reference.
Columns
Columns are evaluated left to right: a field or group name adds columns, a leading - removes them. default and all select the default or full column set.
| Column | Default | Description |
|---|---|---|
| marketplace | Yes | Marketplace. |
| period | Yes | Period. |
| event | Yes | Event. |
| kind | Yes | Line kind. |
| type | Yes | Line type. |
| amount | Yes | Amount. |
| currency | Yes | Currency. |
| line_count | Yes | Line count. |
| asin | No | Asin. |
| sku | No | Sku. |
| subtype | No | Line subtype. |
| marketplace_id | No | Marketplace id. |
| marketplace_name | No | Marketplace name. |
| seller_order_id | No | Seller order id. |
| order_item_id | No | Order item id. |
| tax_collection_model | No | Tax collection model. |
| line_idx | No | Line idx. |
| seller_id | No | Seller id. |
Examples
=DRAGON_FINANCE("Mystore", "", "US", "last 12 months")