360 Secure SkillHub
360 安全技能中心

QuickBooks Mileage CSV

通过本地 qbo-mileage 命令行,把 Airtable、Outlook 或 Google 日历中的行程记录整理为 QuickBooks Online 里程 CSV,并输出运行报告;支持按月生成、预演模式与定时脚本,行程配对和距离缓存由代码完成。

oasiseng
oasiseng
热度 47.60
最近更新 2026-06-11 04:45:07
分类:数据依赖:代码执行 / 读写文件 / 第三方 API应用场景:财务 / 数据处理 / 自动化脚本 / 报告撰写 ...

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add qbo-mileage
Metadata
name
qbo-mileage
description
Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar records using the local qbo-mileage CLI and user-owned credentials.
metadata
{"openclaw":{"requires":{"bins":["python"]}}}

QuickBooks Mileage CSV

Use this skill when the user wants to generate, review, or schedule a QuickBooks Online mileage CSV from calendar or inspection data.

Do not infer or hand-edit mileage rows in the prompt. Run the deterministic CLI from the plugin root so trip pairing, distance caching, CSV formatting, and run reports are produced by code.

Common commands

Dry run:

python -m qbo_mileage generate --config config.json --month YYYY-MM --dry-run

Generate files:

python -m qbo_mileage generate --config config.json --month YYYY-MM

If python is not on PATH (common on macOS/Linux), use python3. If the qbo_mileage package is not installed, run the bundled entry point instead, which adds the plugin's src/ folder to the path automatically:

python3 skills/qbo-mileage/scripts/run.py generate --config config.json --month YYYY-MM

Outputs are written under the configured output directory, normally quickbooks_mileage/YYYY-MM/.

Review checklist

  • Confirm the requested month is correct.
  • Confirm the configured home base and vehicle.
  • Read run_report.md before telling the user the CSV is ready.
  • Surface skipped events, missing addresses, and distance API failures.
  • Confirm PERSONAL legs show a 0.00 deduction in the report.
  • Remind the user that GitHub Actions or cloud/email output is not local-only.

Setup guidance

For first-time setup, point the user to:

  • config.example.json
  • docs/setup-airtable.md
  • docs/setup-maps.md
  • docs/setup-scheduling.md