Iteration Layer
Menu
Features
Use Cases
Docs
Resources
Pricing

Extract Keihi Seisansho Data

Extract employee, department, expense lines, tax, totals, and approval fields from Japanese expense settlement forms.

Who this is for

Finance teams use this recipe to extract keihi seisansho fields into structured reimbursement records for approvals and accounting systems.

Request
curl -X POST https://api.iterationlayer.com/document-extraction/v1/extract \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "files": [
    {
      "type": "url",
      "name": "keihi-seisansho.pdf",
      "url": "https://example.com/documents/keihi-seisansho-sample.pdf"
    }
  ],
  "schema": {
    "fields": [
      {
        "name": "employee_name",
        "type": "TEXT",
        "description": "Employee name"
      },
      {
        "name": "employee_number",
        "type": "TEXT",
        "description": "Employee number"
      },
      {
        "name": "department",
        "type": "TEXT",
        "description": "Department"
      },
      {
        "name": "submission_date",
        "type": "DATE",
        "description": "Submission date"
      },
      {
        "name": "expense_lines",
        "type": "ARRAY",
        "description": "Expense settlement lines",
        "fields": [
          {
            "name": "expense_date",
            "type": "DATE",
            "description": "Expense date"
          },
          {
            "name": "category",
            "type": "TEXT",
            "description": "Expense category"
          },
          {
            "name": "merchant",
            "type": "TEXT",
            "description": "Merchant or payee"
          },
          {
            "name": "purpose",
            "type": "TEXT",
            "description": "Business purpose"
          },
          {
            "name": "amount",
            "type": "CURRENCY_AMOUNT",
            "description": "Expense amount"
          },
          {
            "name": "consumption_tax",
            "type": "CURRENCY_AMOUNT",
            "description": "Consumption tax amount if shown"
          }
        ]
      },
      {
        "name": "total_amount",
        "type": "CURRENCY_AMOUNT",
        "description": "Total settlement amount"
      },
      {
        "name": "approval_status",
        "type": "TEXT",
        "description": "Approval status if shown"
      },
      {
        "name": "currency",
        "type": "CURRENCY_CODE",
        "description": "Currency code"
      }
    ]
  }
}'
Response
{
  "success": true,
  "data": {
    "employee_name": {
      "value": "Maria Keller",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NAME"
      ]
    },
    "employee_number": {
      "value": "Employee Number",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NUMBER"
      ]
    },
    "department": {
      "value": "Department",
      "confidence": 0.97,
      "citations": [
        "DEPARTMENT"
      ]
    },
    "submission_date": {
      "value": "2026-04-15",
      "confidence": 0.97,
      "citations": [
        "15 Apr 2026"
      ]
    },
    "expense_lines": {
      "value": [
        {
          "expense_date": {
            "value": "2026-04-15",
            "confidence": 0.96,
            "citations": [
              "15 Apr 2026"
            ]
          },
          "category": {
            "value": "Category",
            "confidence": 0.96,
            "citations": [
              "CATEGORY"
            ]
          },
          "merchant": {
            "value": "Merchant",
            "confidence": 0.96,
            "citations": [
              "MERCHANT"
            ]
          },
          "purpose": {
            "value": "Purpose",
            "confidence": 0.96,
            "citations": [
              "PURPOSE"
            ]
          },
          "amount": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          },
          "consumption_tax": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          }
        }
      ],
      "confidence": 0.97,
      "citations": [
        "EXPENSE LINES"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "1234.56",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "1,234.56"
      ]
    },
    "approval_status": {
      "value": "Approval Status",
      "confidence": 0.97,
      "citations": [
        "APPROVAL STATUS"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.97,
      "citations": [
        "CURRENCY"
      ]
    }
  }
}
Request
import { IterationLayer } from "iterationlayer";

const client = new IterationLayer({ apiKey: "YOUR_API_KEY" });

const result = await client.extractDocument({
  "files": [
    {
      "type": "url",
      "name": "keihi-seisansho.pdf",
      "url": "https://example.com/documents/keihi-seisansho-sample.pdf"
    }
  ],
  "schema": {
    "fields": [
      {
        "name": "employee_name",
        "type": "TEXT",
        "description": "Employee name"
      },
      {
        "name": "employee_number",
        "type": "TEXT",
        "description": "Employee number"
      },
      {
        "name": "department",
        "type": "TEXT",
        "description": "Department"
      },
      {
        "name": "submission_date",
        "type": "DATE",
        "description": "Submission date"
      },
      {
        "name": "expense_lines",
        "type": "ARRAY",
        "description": "Expense settlement lines",
        "fields": [
          {
            "name": "expense_date",
            "type": "DATE",
            "description": "Expense date"
          },
          {
            "name": "category",
            "type": "TEXT",
            "description": "Expense category"
          },
          {
            "name": "merchant",
            "type": "TEXT",
            "description": "Merchant or payee"
          },
          {
            "name": "purpose",
            "type": "TEXT",
            "description": "Business purpose"
          },
          {
            "name": "amount",
            "type": "CURRENCY_AMOUNT",
            "description": "Expense amount"
          },
          {
            "name": "consumption_tax",
            "type": "CURRENCY_AMOUNT",
            "description": "Consumption tax amount if shown"
          }
        ]
      },
      {
        "name": "total_amount",
        "type": "CURRENCY_AMOUNT",
        "description": "Total settlement amount"
      },
      {
        "name": "approval_status",
        "type": "TEXT",
        "description": "Approval status if shown"
      },
      {
        "name": "currency",
        "type": "CURRENCY_CODE",
        "description": "Currency code"
      }
    ]
  }
});
Response
{
  "success": true,
  "data": {
    "employee_name": {
      "value": "Maria Keller",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NAME"
      ]
    },
    "employee_number": {
      "value": "Employee Number",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NUMBER"
      ]
    },
    "department": {
      "value": "Department",
      "confidence": 0.97,
      "citations": [
        "DEPARTMENT"
      ]
    },
    "submission_date": {
      "value": "2026-04-15",
      "confidence": 0.97,
      "citations": [
        "15 Apr 2026"
      ]
    },
    "expense_lines": {
      "value": [
        {
          "expense_date": {
            "value": "2026-04-15",
            "confidence": 0.96,
            "citations": [
              "15 Apr 2026"
            ]
          },
          "category": {
            "value": "Category",
            "confidence": 0.96,
            "citations": [
              "CATEGORY"
            ]
          },
          "merchant": {
            "value": "Merchant",
            "confidence": 0.96,
            "citations": [
              "MERCHANT"
            ]
          },
          "purpose": {
            "value": "Purpose",
            "confidence": 0.96,
            "citations": [
              "PURPOSE"
            ]
          },
          "amount": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          },
          "consumption_tax": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          }
        }
      ],
      "confidence": 0.97,
      "citations": [
        "EXPENSE LINES"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "1234.56",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "1,234.56"
      ]
    },
    "approval_status": {
      "value": "Approval Status",
      "confidence": 0.97,
      "citations": [
        "APPROVAL STATUS"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.97,
      "citations": [
        "CURRENCY"
      ]
    }
  }
}
Request
from iterationlayer import IterationLayer

client = IterationLayer(api_key="YOUR_API_KEY")

result = client.extract_document(**{
  "files": [
    {
      "type": "url",
      "name": "keihi-seisansho.pdf",
      "url": "https://example.com/documents/keihi-seisansho-sample.pdf"
    }
  ],
  "schema": {
    "fields": [
      {
        "name": "employee_name",
        "type": "TEXT",
        "description": "Employee name"
      },
      {
        "name": "employee_number",
        "type": "TEXT",
        "description": "Employee number"
      },
      {
        "name": "department",
        "type": "TEXT",
        "description": "Department"
      },
      {
        "name": "submission_date",
        "type": "DATE",
        "description": "Submission date"
      },
      {
        "name": "expense_lines",
        "type": "ARRAY",
        "description": "Expense settlement lines",
        "fields": [
          {
            "name": "expense_date",
            "type": "DATE",
            "description": "Expense date"
          },
          {
            "name": "category",
            "type": "TEXT",
            "description": "Expense category"
          },
          {
            "name": "merchant",
            "type": "TEXT",
            "description": "Merchant or payee"
          },
          {
            "name": "purpose",
            "type": "TEXT",
            "description": "Business purpose"
          },
          {
            "name": "amount",
            "type": "CURRENCY_AMOUNT",
            "description": "Expense amount"
          },
          {
            "name": "consumption_tax",
            "type": "CURRENCY_AMOUNT",
            "description": "Consumption tax amount if shown"
          }
        ]
      },
      {
        "name": "total_amount",
        "type": "CURRENCY_AMOUNT",
        "description": "Total settlement amount"
      },
      {
        "name": "approval_status",
        "type": "TEXT",
        "description": "Approval status if shown"
      },
      {
        "name": "currency",
        "type": "CURRENCY_CODE",
        "description": "Currency code"
      }
    ]
  }
})
Response
{
  "success": true,
  "data": {
    "employee_name": {
      "value": "Maria Keller",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NAME"
      ]
    },
    "employee_number": {
      "value": "Employee Number",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NUMBER"
      ]
    },
    "department": {
      "value": "Department",
      "confidence": 0.97,
      "citations": [
        "DEPARTMENT"
      ]
    },
    "submission_date": {
      "value": "2026-04-15",
      "confidence": 0.97,
      "citations": [
        "15 Apr 2026"
      ]
    },
    "expense_lines": {
      "value": [
        {
          "expense_date": {
            "value": "2026-04-15",
            "confidence": 0.96,
            "citations": [
              "15 Apr 2026"
            ]
          },
          "category": {
            "value": "Category",
            "confidence": 0.96,
            "citations": [
              "CATEGORY"
            ]
          },
          "merchant": {
            "value": "Merchant",
            "confidence": 0.96,
            "citations": [
              "MERCHANT"
            ]
          },
          "purpose": {
            "value": "Purpose",
            "confidence": 0.96,
            "citations": [
              "PURPOSE"
            ]
          },
          "amount": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          },
          "consumption_tax": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          }
        }
      ],
      "confidence": 0.97,
      "citations": [
        "EXPENSE LINES"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "1234.56",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "1,234.56"
      ]
    },
    "approval_status": {
      "value": "Approval Status",
      "confidence": 0.97,
      "citations": [
        "APPROVAL STATUS"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.97,
      "citations": [
        "CURRENCY"
      ]
    }
  }
}
Request
package main

import il "github.com/iterationlayer/sdk-go"

func main() {
    client := il.NewClient("YOUR_API_KEY")

    result, err := client.ExtractDocument(il.ExtractDocumentRequest{
        Files: []il.FileInput{
            il.FileInput{
                Type: "url",
                Name: "keihi-seisansho.pdf",
                Url: "https://example.com/documents/keihi-seisansho-sample.pdf",
            },
        },
        Schema: il.ExtractionSchema{
            Fields: []any{
                il.TextFieldConfig{
                    Name: "employee_name",
                    Type: "TEXT",
                    Description: "Employee name",
                },
                il.TextFieldConfig{
                    Name: "employee_number",
                    Type: "TEXT",
                    Description: "Employee number",
                },
                il.TextFieldConfig{
                    Name: "department",
                    Type: "TEXT",
                    Description: "Department",
                },
                il.DateFieldConfig{
                    Name: "submission_date",
                    Type: "DATE",
                    Description: "Submission date",
                },
                il.ArrayFieldConfig{
                    Name: "expense_lines",
                    Type: "ARRAY",
                    Description: "Expense settlement lines",
                    Fields: []any{
                        il.DateFieldConfig{
                            Name: "expense_date",
                            Type: "DATE",
                            Description: "Expense date",
                        },
                        il.TextFieldConfig{
                            Name: "category",
                            Type: "TEXT",
                            Description: "Expense category",
                        },
                        il.TextFieldConfig{
                            Name: "merchant",
                            Type: "TEXT",
                            Description: "Merchant or payee",
                        },
                        il.TextFieldConfig{
                            Name: "purpose",
                            Type: "TEXT",
                            Description: "Business purpose",
                        },
                        il.CurrencyAmountFieldConfig{
                            Name: "amount",
                            Type: "CURRENCY_AMOUNT",
                            Description: "Expense amount",
                        },
                        il.CurrencyAmountFieldConfig{
                            Name: "consumption_tax",
                            Type: "CURRENCY_AMOUNT",
                            Description: "Consumption tax amount if shown",
                        },
                    },
                },
                il.CurrencyAmountFieldConfig{
                    Name: "total_amount",
                    Type: "CURRENCY_AMOUNT",
                    Description: "Total settlement amount",
                },
                il.TextFieldConfig{
                    Name: "approval_status",
                    Type: "TEXT",
                    Description: "Approval status if shown",
                },
                il.CurrencyCodeFieldConfig{
                    Name: "currency",
                    Type: "CURRENCY_CODE",
                    Description: "Currency code",
                },
            },
        },
    })
    if err != nil {
        panic(err)
    }

    _ = result
}
Response
{
  "success": true,
  "data": {
    "employee_name": {
      "value": "Maria Keller",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NAME"
      ]
    },
    "employee_number": {
      "value": "Employee Number",
      "confidence": 0.97,
      "citations": [
        "EMPLOYEE NUMBER"
      ]
    },
    "department": {
      "value": "Department",
      "confidence": 0.97,
      "citations": [
        "DEPARTMENT"
      ]
    },
    "submission_date": {
      "value": "2026-04-15",
      "confidence": 0.97,
      "citations": [
        "15 Apr 2026"
      ]
    },
    "expense_lines": {
      "value": [
        {
          "expense_date": {
            "value": "2026-04-15",
            "confidence": 0.96,
            "citations": [
              "15 Apr 2026"
            ]
          },
          "category": {
            "value": "Category",
            "confidence": 0.96,
            "citations": [
              "CATEGORY"
            ]
          },
          "merchant": {
            "value": "Merchant",
            "confidence": 0.96,
            "citations": [
              "MERCHANT"
            ]
          },
          "purpose": {
            "value": "Purpose",
            "confidence": 0.96,
            "citations": [
              "PURPOSE"
            ]
          },
          "amount": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          },
          "consumption_tax": {
            "value": {
              "amount": "1234.56",
              "currency": "EUR"
            },
            "confidence": 0.96,
            "citations": [
              "1,234.56"
            ]
          }
        }
      ],
      "confidence": 0.97,
      "citations": [
        "EXPENSE LINES"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "1234.56",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "1,234.56"
      ]
    },
    "approval_status": {
      "value": "Approval Status",
      "confidence": 0.97,
      "citations": [
        "APPROVAL STATUS"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.97,
      "citations": [
        "CURRENCY"
      ]
    }
  }
}
Template
{
  "name": "Extract Keihi Seisansho Data",
  "nodes": [
    {
      "parameters": {
        "content": "## Extract Keihi Seisansho Data\n\nFinance teams use this recipe to extract keihi seisansho fields into structured reimbursement records for approvals and accounting systems.\n\n**Note:** This workflow uses the Iteration Layer community node (`n8n-nodes-iterationlayer`). Install it via Settings > Community Nodes on self-hosted n8n, or add it directly on n8n Cloud with Verified Community Nodes enabled.",
        "height": 280,
        "width": 500,
        "color": 2
      },
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        200,
        40
      ],
      "id": "extract-keihi-seisansho-data-overview",
      "name": "Overview"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        250,
        300
      ],
      "id": "extract-keihi-seisansho-data-trigger",
      "name": "Manual Trigger"
    },
    {
      "parameters": {
        "resource": "documentExtraction",
        "schemaInputMode": "rawJson",
        "schemaJson": "{\n  \"fields\": [\n    {\n      \"name\": \"employee_name\",\n      \"type\": \"TEXT\",\n      \"description\": \"Employee name\"\n    },\n    {\n      \"name\": \"employee_number\",\n      \"type\": \"TEXT\",\n      \"description\": \"Employee number\"\n    },\n    {\n      \"name\": \"department\",\n      \"type\": \"TEXT\",\n      \"description\": \"Department\"\n    },\n    {\n      \"name\": \"submission_date\",\n      \"type\": \"DATE\",\n      \"description\": \"Submission date\"\n    },\n    {\n      \"name\": \"expense_lines\",\n      \"type\": \"ARRAY\",\n      \"description\": \"Expense settlement lines\",\n      \"fields\": [\n        {\n          \"name\": \"expense_date\",\n          \"type\": \"DATE\",\n          \"description\": \"Expense date\"\n        },\n        {\n          \"name\": \"category\",\n          \"type\": \"TEXT\",\n          \"description\": \"Expense category\"\n        },\n        {\n          \"name\": \"merchant\",\n          \"type\": \"TEXT\",\n          \"description\": \"Merchant or payee\"\n        },\n        {\n          \"name\": \"purpose\",\n          \"type\": \"TEXT\",\n          \"description\": \"Business purpose\"\n        },\n        {\n          \"name\": \"amount\",\n          \"type\": \"CURRENCY_AMOUNT\",\n          \"description\": \"Expense amount\"\n        },\n        {\n          \"name\": \"consumption_tax\",\n          \"type\": \"CURRENCY_AMOUNT\",\n          \"description\": \"Consumption tax amount if shown\"\n        }\n      ]\n    },\n    {\n      \"name\": \"total_amount\",\n      \"type\": \"CURRENCY_AMOUNT\",\n      \"description\": \"Total settlement amount\"\n    },\n    {\n      \"name\": \"approval_status\",\n      \"type\": \"TEXT\",\n      \"description\": \"Approval status if shown\"\n    },\n    {\n      \"name\": \"currency\",\n      \"type\": \"CURRENCY_CODE\",\n      \"description\": \"Currency code\"\n    }\n  ]\n}",
        "files": {
          "fileValues": [
            {
              "fileInputMode": "url",
              "fileName": "keihi-seisansho.pdf",
              "fileUrl": "https://example.com/documents/keihi-seisansho-sample.pdf"
            }
          ]
        }
      },
      "type": "n8n-nodes-iterationlayer.iterationLayer",
      "typeVersion": 1,
      "position": [
        500,
        300
      ],
      "id": "extract-keihi-seisansho-data-extract",
      "name": "Extract Data",
      "credentials": {
        "iterationLayerApi": {
          "id": "1",
          "name": "Iteration Layer API"
        }
      }
    }
  ],
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Extract Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}
Prompt
Extract keihi seisansho data from the file at [file URL]. Use the extract_document tool with these fields:

- employee_name (TEXT): Employee name
- employee_number (TEXT): Employee number
- department (TEXT): Department
- submission_date (DATE): Submission date
- expense_lines (ARRAY): Each with expense_date (DATE), category (TEXT), merchant (TEXT), purpose (TEXT), amount (CURRENCY_AMOUNT), consumption_tax (CURRENCY_AMOUNT)
- total_amount (CURRENCY_AMOUNT): Total settlement amount
- approval_status (TEXT): Approval status if shown
- currency (CURRENCY_CODE): Currency code

Related Recipes

Try with your own data

Start the 7-day trial and run this recipe in minutes.