ホーム / Skills / オフィス・文書 / Invoice Organizer 請求書の整理
オフィス・文書

Invoice Organizer 請求書の整理

ComposioHQ community contributorsApache-2.0Skill の言語: 英語
ライセンス確認済みスクリプトなし
デモ実行記録 · claude-sonnet-5-5 · 2026年10月
Organize the invoices in ./receipts-to-sort for taxes. Copy them rather than moving, sort by year and then vendor, and create the CSV summary for my accountant. You have my approval for that plan, so go ahead without asking again. Flag anything you can't read properly.
Skill: invoice-organizer
Bash: ls -la ./receipts-to-sort
Bash: cd receipts-to-sort && for f in *; do echo "=== $f"; cat "$f"; echo; done; md5 *
Bash: cd <workdir> && S=receipts-to-sort && O=Invoices…

I copied the five readable receipts into ./Invoices/, sorted by year and then vendor. The originals in receipts-to-sort are untouched, still six files. I also wrote the CSV summary for your accountant.

Invoices/
├── invoice-summary.csv
├── 2026/
│   ├── Adobe/    2026-03-15 Adobe - Invoice - Creative Cloud.txt
│   ├── Amazon/   2026-03-10 Amazon - Receipt - Keyboard and USB-C Hub.txt
│   ├── Netlify/  2026-02-28 Netlify - Invoice - Pro Plan.txt
│   ├── Staples/  2026-02-10 Staples - Receipt - Printer Paper and Toner.txt
│   └── Uber/     2026-03-02 Uber - Receipt - Airport Trip.txt
└── Needs-Review/
    └── document.txt

The CSV has date, vendor, invoice number, description, amount, currency, category, file path and notes. The category column is my own guess (Office, Software or Travel), so your accountant may want to adjust it.

Flagged for your review

  • document.txt: This is a note about a call, not an invoice or receipt. It has no vendor, date or amount, so I put a copy in Needs-Review/ and left it out of the CSV.
  • Adobe: The amount is EUR 59.99. I didn't convert it to USD, so your accountant will need to.
  • Netlify: The invoice has a billing period (2026-02-01 to 2026-02-28) but no invoice date. I used the period end, 2026-02-28, as the date.
  • Uber: The receipt has no receipt or invoice number, so that CSV field is blank.
  • Staples: The receipt has a store number but no invoice number. The date was written as 02/10/2026, and I read it as 10 February 2026, since the other receipts are all dated February or March 2026. If it was meant as 2 October, the date and folder placement need fixing.

The files are plain text rather than PDFs, so I kept the .txt extension.

invoice-summary.csv recorded in the trial sandbox:

Date,Vendor,Invoice Number,Description,Amount,Currency,Category,File Path,Notes
2026-02-10,Staples,Store #4412,Printer paper (5 reams); toner cartridge,103.89,USD,Office,"Invoices/2026/Staples/2026-02-10 Staples - Receipt - Printer Paper and Toner.txt",
2026-02-28,Netlify,NL-882134,Pro Plan (1 seat),19.00,USD,Software,"Invoices/2026/Netlify/2026-02-28 Netlify - Invoice - Pro Plan.txt","Date is end of billing period 2026-02-01 to 2026-02-28; no invoice date given"
2026-03-02,Uber,,Airport to downtown trip (fare 34.50 + tip 5.00),39.50,USD,Travel,"Invoices/2026/Uber/2026-03-02 Uber - Receipt - Airport Trip.txt","No receipt number"
2026-03-10,Amazon,112-3948571-2218265,Ergonomic keyboard; USB-C hub,127.45,USD,Office,"Invoices/2026/Amazon/2026-03-10 Amazon - Receipt - Keyboard and USB-C Hub.txt",
2026-03-15,Adobe,IEE2026-0048213,Creative Cloud All Apps (monthly),59.99,EUR,Software,"Invoices/2026/Adobe/2026-03-15 Adobe - Invoice - Creative Cloud.txt","Amount in EUR (not converted); paid by Visa ending 4242"

Real run recorded with claude-code / claude-sonnet-5-5. Run on a sample folder with 6 invoices in text format. We approved the plan in the prompt so it would go ahead directly. The trial used .txt files; PDFs and scanned images were not tested. The last block is the CSV it generated, recorded verbatim. Tool-call lines show only the first line of each command. The model output is unmodified.

できること

山積みの請求書やレシートを整った保管庫に整理します。1 件ずつ読み取って要点を取り出し、統一した名前で保管します。

仕組み

  1. 請求書ファイルを探し、それぞれから取引先、番号、日付、金額、内容を読み取ります。
  2. どう整理したいか(取引先別、カテゴリー別、日付別、税区分別)を尋ね、指定がなければ年、カテゴリー、取引先の順にします。
  3. まず計画を示し、その後ファイルを新しい構成にコピー(希望すれば移動)します。名前は YYYY-MM-DD 取引先 - Invoice - 内容 のようになります。
  4. すべての明細を載せた CSV を作り、読み取れなかったものは手動確認用に一覧にします。

向いている場面

確定申告の準備、経費精算、会計士への資料の引き渡し。

知っておきたいこと

私たちの試用では、5 枚のレシートをコピーし、請求書ではないファイルを要確認フォルダーに入れ、あいまいな日付、外貨の金額、欠けている請求書番号を推測せずに指摘しました。

補足とリスク

指示だけのファイルで、スクリプトはありません。 請求書やレシートの内容を読み取り、ファイルをコピーまたは移動し、フォルダー内にディレクトリと、取引先、金額、支払い情報を含む CSV を作成します。経費カテゴリーはモデルの推測です。税務や会計のアドバイスではないので、申告前に専門家に確認してもらい、元のファイルは残してください。テストはテキストファイルのみで、PDF やスキャン画像では試していません。 元の skill フォルダには単独のライセンスファイルがなく、ライセンスの根拠は、リポジトリ全体を Apache-2.0 とする元リポジトリの README の記載です(個別の skill は異なる場合があるとも書かれています)。 パッケージには LICENSE(Apache-2.0 全文)と SOURCE.txt(出典とライセンス根拠のメモ。AIBars が追加)も含まれます。