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 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
