mcpField
B
bank-sync

bank-sync

github.com/openaccountantOther103648 installsUpdated 29w ago
Repository

About bank-sync

A Wilson skill that uses Plaid to import bank transactions automatically and regularly. It supports account selection, duplicate checks, categorization, and daily sync, and requires a Wilson Pro license.

Key features

  1. 01Connects accounts through Plaid Link
  2. 02Imports recent transactions on initial sync
  3. 03Checks for duplicate transactions
  4. 04Categorizes newly synced transactions
  5. 05Schedules daily sync on Wilson session start

Use cases

  1. 01Importing transactions without CSV exports
  2. 02Syncing checking, savings, or card accounts
  3. 03Categorizing newly imported bank activity

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/openaccountant/skills --skill bank-sync

After installing, type/bank-syncin Claude Code to confirm it loaded.

Details

From the project README

Bank Sync

Overview

Connect your bank accounts for automatic, recurring transaction imports using the Plaid API. Once connected, Wilson pulls new transactions daily without manual CSV exports. Supports checking, savings, and credit card accounts from thousands of financial institutions.

Note: Plaid integration requires a Wilson Pro license.

Wilson Tools Used

  • transaction_search — verify imported transactions and check for duplicates
  • categorize — auto-categorize newly synced transactions

Workflow

  1. Verify the user has a valid Wilson Pro license.
  2. Launch the Plaid Link flow to connect a bank account:
    • User selects their financial institution
    • User authenticates with their bank credentials
    • User selects which accounts to sync
  3. Store the Plaid access token securely in the local database.
  4. Perform an initial sync to pull the last 30 days of transactions.
  5. Deduplicate against any previously imported transactions.
  6. Run categorize on newly synced transactions.
  7. Report sync results: new transactions, duplicates skipped, accounts connected.
  8. Set up daily automatic sync (runs on next Wilson session start).

Without Wilson

If you don't have Wilson Pro or prefer manual imports, here are alternatives for each major bank:

Manual Export Schedule (Recommended Monthly)

Chase:

  • chase.com > Account > Download account activity > CSV
  • Or set up Chase email alerts for transactions over a threshold

Bank of America:

  • bankofamerica.com > Account > Information & Services > Download transactions > CSV
  • BofA also supports auto-export to Quicken/QuickBooks

Wells Fargo:

  • wellsfargo.com > Account > Download Account Activity > Comma Delimited

Citi:

  • citibank.com > Account > View Activity > Download (CSV, OFX, QIF)

Capital One:

  • capitalone.com > Account > Download Transactions > CSV

American Express:

  • americanexpress.com > Statements & Activity > Download your Transactions > CSV
Free Plaid Alternatives
  • Monarch Money ($9.99/mo): Automatic bank sync with budgeting
  • Lunch Money ($10/mo): Developer-friendly, CSV import + Plaid sync
  • Actual Budget (free, self-hosted): Manual import with OFX support
  • GnuCash (free): OFX direct download from some banks
Automation Without Plaid
  • Set calendar reminders to export CSV monthly from each bank
  • Use the import-transactions skill to import each file
  • Some banks support OFX Direct Connect — GnuCash and KMyMoney can pull transactions automatically without Plaid

Important Notes

  • Plaid credentials are stored locally in your Wilson database — they never leave your machine.
  • Bank sync uses Plaid's transaction sync API, which handles deduplication server-side.
  • Some institutions require re-authentication every 90 days (Plaid will prompt you).
  • Plaid supports 12,000+ financial institutions in the US, Canada, and UK.
  • If a bank connection breaks, Wilson will notify you and offer to re-authenticate or fall back to manual CSV import.

Comments

Markdown supported