Skip to content
UsecaseBoard
← All use cases
substackMoney

Sync a personal expense log into a monthly balance

At a glance

A Claude skill moves one person's pending Notion entries into a finance template after a review step. This workflow is listed under Money, Life admin.

Agents / tools
Claude, Notion, Coda

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Create a Notion database for each month with concept, amount, free-text category, date and a Synced checkbox; duplicate the author's Superhuman finance template with expense, income and balance tables. Connect Notion and Superhuman through their MCP servers in Claude. 2) Write a finance-sync skill with the source database and destination column IDs, category list, and the rule to mark an entry synced only after its destination write succeeds. Install the skill in Claude Desktop or Claude Code. 3) Run the skill on unchecked entries: it identifies income or expense, maps categories and presents a summary. Compare the first summary against the original notes and approve it; Claude writes the entries and checks the successful ones. The template's date-based formulas then recalculate the monthly balance.

How it went

The author reported a first run of 24 expenses and one income, with two new categories created after approval and the July balance recalculated.

Worth knowing

The checkbox is the only duplicate checkpoint, so an incorrect checkbox can produce an incorrect sync. The author also reported a free-plan MCP quota and an annual template that needs replacing each year.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →