add_transaction
Add a transaction with date, amount, category, and source, then receive the transaction and the category's running total for that month.
Instructions
Insert a transaction and return it plus the category's running total for its month.
date: ISO 8601 'YYYY-MM-DD'. amount: dollars, signed (negative = expense, positive = income), precise to the cent. category: must already exist in the budgets table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | ||
| note | No | ||
| amount | Yes | ||
| source | Yes | ||
| category | Yes |