Automation work samples

Python tools that replace manual work with Excel, PDF, and CSV files. Each page shows the output of an actual run.

The samples are Japanese business data, and the tools handle what comes with it: Shift_JIS files, Japanese era dates, full-width digits, 10% and 8% consumption tax on one invoice, and invoice registration numbers. The pages explain them in English.

• Invoice PDFs into an Excel list

  From a folder of invoice PDFs to an Excel list and a payment schedule. Wrong tax and duplicate billing are stopped, with the reason.

  Sample output, translated10% consumption tax of ¥5,000 does not match ¥48,000 × 10% = ¥4,800 (off by more than the ¥1 rounding allowance)

• Alerts for new government subsidies

  Watches the Japanese government's public subsidy API and sends only the new matches to Slack or email.

  Sample output, translated[jgrants-watch] 18 new subsidies (as of 2026-10-05 19:02)

• Sales CSVs in different formats into one monthly Excel report

  Three stores' CSVs with different encodings and column names, combined into a monthly report. Problem rows are listed with row numbers.

  Sample output, translatedQty × unit price = 2,940, but the amount is 2,490 (difference -450).