Adds date-parameterized SQL queries for Income Statement, Expense
Detail, Vendor Payment Summary, and General Ledger. These filter
TransactionLines by date range instead of using cumulative balances,
enabling tax year and other period-specific financial reports.
New capability for importing bank transactions (Schwab JSON), matching
against existing ledger entries, creating missing transactions, and
reconciling balances. Includes two new Grist tables (Reconciliations,
BankRules), two bank-import templates, and reference documentation.
Introduces templates/ directory with pre-built record structures that only
include writable fields, preventing 400 errors from formula column writes.
Templates:
- bill-paid-credit-card.json: Invoice paid by business credit card
- bill-paid-owner.json: Invoice paid by owner (reimbursement)
- bill-paid-checking.json: Invoice paid from checking account
- bill-unpaid.json: Invoice recorded but not yet paid
- pay-existing-bill.json: Payment for existing open bill
- direct-expense.json: Bank fees and minor expenses
Also adds references/templates.md usage guide and updates SKILL.md with
template references and formula column warnings.
- Add note to consult schema.md for writable fields before add_records
- Add sample JSON payloads for common transactions:
- Owner equity contribution
- Owner draw
- Direct expense (no bill)
- Revenue receipt
- Include quick reference table for key account IDs
- Add audit subagent that runs automatically after bill entries
- Create download-attachment.sh for retrieving invoice/receipt PDFs
- Create verify-pdf.py for PDF extraction with OCR fallback
- Restructure SKILL.md from 856 to 177 lines using reference files
- Move detailed content to references/:
- schema.md: table schemas
- workflows.md: code examples
- queries.md: SQL queries and financial reports
- audit.md: audit queries and remediation steps
Adds a quick-reference section near the top of the skill that clarifies:
- Invoice/bill PDFs should always create Bill records
- Receipts attach to existing Bills via BillPayment
- Bank entries and journal adjustments are Transaction-only
Includes step-by-step checklist for common "vendor invoice paid by owner" workflow.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Add separate Invoice and Receipt columns to Bills table for clearer
document organization
- Update upload-attachment.sh to accept column parameter (defaults to
Invoice, use Receipt for payment confirmations)
- Update all documentation examples and workflows
- Add receipt upload step to payment workflows
- Update validation checklist to verify both fields
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Add Step 5 to bill entry: upload invoice attachment if available
- Add batch attachment upload guidance to Batch Operations
- Add validation checklist item for missing attachments
- Add common mistake entry for missing invoice attachments
Includes queries that properly handle parent-child account hierarchy to avoid double-counting balances.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Move embedded bash script to scripts/upload-attachment.sh
- Update SKILL.md to reference external script with usage examples
- Follows skill best practice: separate reusable tools from documentation
