skills.rest
AojdevStudio
AojdevStudioCOMMUNITY
Explore all skills by this author →
Website𝕏@AOJDevStudioGitHub

TransactionSyncing

Import Fidelity transaction CSV into Google Sheets and auto-categorize expenses.

317|108|Updated Oct 18, 2025
Search Tags:#automation#transactions#sync#categorization#google-sheets#fidelity#expense-tracker
One-click install
npx skills add https://github.com/AojdevStudio/Finance-Guru --skill transactionsyncing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: TransactionSyncing
Source: https://github.com/AojdevStudio/Finance-Guru/tree/main/.claude/skills/TransactionSyncing
Command: npx skills add https://github.com/AojdevStudio/Finance-Guru --skill transactionsyncing

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Compiles Fidelity transaction history into a single, auditable Google Sheets ledger and automatically routes debit-card purchases to the Expense Tracker with auto-categorization, reducing manual reconciliation and errors.

Core Features & Use Cases

  • Import Fidelity transaction history CSV from notebooks/transactions and populate a central Transactions tab with full data.
  • Route DEBIT CARD PURCHASE entries to the Expense Tracker with auto-categorization based on merchant patterns.
  • Maintain a master audit trail and support deduplication by date, action, and amount while generating a concise sync summary.

Quick Start

Place the Fidelity History CSV in notebooks/transactions and run the SyncTransactions workflow to import transactions, deduplicate, and route debits to the Expense Tracker.

Frequently Asked Questions about TransactionSyncing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync Fidelity transactions to Google Sheets?▼

To sync Fidelity transactions, place the history CSV in notebooks/transactions and run the workflow to import, deduplicate, and populate a master Transactions tab in Google Sheets.

How does auto-categorization work for Fidelity debit card purchases?▼

Auto-categorization routes DEBIT CARD PURCHASE entries from imported Fidelity data to the Expense Tracker, assigning expense categories based on recognized merchant patterns.

Can I import Fidelity CSV history without creating duplicate transactions?▼

Yes, the Fidelity CSV import process maintains a deduplicated master audit trail by checking existing entries against date, action, and amount before populating the central Transactions tab.

What is the best way to consolidate Fidelity transaction history for expense tracking?▼

Consolidating Fidelity transaction history involves importing the CSV into a central Google Sheets ledger, routing debit purchases to the Expense Tracker, and generating a concise sync summary.

Do I need a specific file format to import Fidelity transactions into Google Sheets?▼

Yes, you need a Fidelity transaction history CSV file placed in the notebooks/transactions directory to successfully import and auto-categorize data into the Google Sheets ledger.

Related Skills

Explore More Finance & Accounting Skills→
LezinrewLezinrew

imports-integrations

Import transactions from CSV files into the backend database with validation and deduplication.

Community
Advanced
skills-ilskills-il
10

gws-israeli-business-sheets

Automate income and expense tracking with VAT calculations in Google Sheets.

Official
Intermediate
think41think41
162

gsheetx

Automate Google Sheets data access, modification, and sharing from Python using gspread.

Official
Intermediate
LutherwavesLutherwaves
1

log

Parse Bulgarian or English input to log financial transactions and update ledgers.

Community
Advanced