← Back to Skills Marketplace
oasiseng

QuickBooks Mileage CSV

by Oasis Engineering · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
33
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install 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.
README (SKILL.md)

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

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.
  • 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
Usage Guidance
Before installing, narrow the Outlook OAuth scope unless you explicitly need Microsoft Graph email sending, protect all config and token files, run a dry run first, and avoid enabling email, cloud storage, GitHub Actions, or recurring schedules until you are comfortable with those data flows.
Capability Analysis
Type: OpenClaw Skill Name: qbo-mileage Version: 1.0.0 The qbo-mileage skill is a legitimate utility designed to generate QuickBooks Online mileage CSVs from various data sources including Airtable, Google Calendar, and Outlook. The Python implementation (qbo_mileage/) uses standard libraries to fetch event data via official APIs (Airtable, Microsoft Graph, Google Calendar), calculates distances using the Google Routes API with local caching (cache.py), and provides optional email delivery of reports. The SKILL.md instructions correctly guide the AI agent to use the deterministic CLI rather than hallucinating data. The code and documentation (README.md, docs/) emphasize local data handling and security best practices, such as using environment variables for secrets and advising against committing credentials. No evidence of malicious intent, data exfiltration to unauthorized endpoints, or prompt injection was found.
Capability Tags
requires-oauth-tokenrequires-sensitive-credentials
Capability Assessment
Purpose & Capability
Generating QuickBooks mileage CSVs from Airtable/calendar data is coherent with the code, but the Outlook calendar adapter defaults to a send-mail OAuth scope that is broader than needed for calendar reads.
Instruction Scope
The SKILL.md workflow is user-directed and asks the agent to run the CLI and review the report; generate mode can write files and use configured external/email providers.
Install Mechanism
There is no installer or remote download path in the artifacts, but the source/homepage provenance is limited and users should review the included Python code before running it.
Credentials
User-owned API keys, OAuth refresh tokens, and optional SMTP/email credentials are expected, but registry metadata under-declares them and the Outlook default scope is overbroad.
Persistence & Privilege
The skill uses a local distance cache and documents optional scheduling/GitHub Actions; these are disclosed and user-configured, not hidden automatic persistence.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install qbo-mileage
  3. After installation, invoke the skill by name or use /qbo-mileage
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of qbo-mileage skill. - Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar data using the local CLI and user credentials. - Provides commands for dry runs and file generation, with outputs organized by month. - Includes a review checklist to ensure accuracy of data before confirming CSV readiness. - Guides users through first-time setup with example config files and setup documentation.
Metadata
Slug qbo-mileage
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is QuickBooks Mileage CSV?

Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar records using the local qbo-mileage CLI and user-owned credentials. It is an AI Agent Skill for Claude Code / OpenClaw, with 33 downloads so far.

How do I install QuickBooks Mileage CSV?

Run "/install qbo-mileage" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is QuickBooks Mileage CSV free?

Yes, QuickBooks Mileage CSV is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does QuickBooks Mileage CSV support?

QuickBooks Mileage CSV is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created QuickBooks Mileage CSV?

It is built and maintained by Oasis Engineering (@oasiseng); the current version is v1.0.0.

💬 Comments