Budget - Releases

Fixed

• MariaDB compatibility: CAST(... AS VARCHAR) is not valid on MariaDB. Changed to CAST(... AS CHAR(n)) which works on all three databases (MySQL/MariaDB, PostgreSQL, SQLite).

Added

• Liability Account Model (#187): Loan, credit card, mortgage, and line of credit accounts now store balances as negative numbers internally. Payments (credits) correctly decrease the balance; charges (debits) increase it. The display layer shows absolute values with "owed" context.
• Mortgage and Line of Credit account types added to the account type dropdown.
• Import from App — App-specific import presets with Toshl Finance as the first supported app. Select "Toshl Finance" from the import format dropdown and the app handles column mapping, date/amount formats, and auto-creation automatically.
• Toshl Import: Category Auto-Creation — Categories from Toshl's Category column are created automatically if they don't exist.
• Toshl Import: Tag Set Integration — Toshl tags map to Budget's tag set system (not subcategories). A "Tags" tag set is created per category.
• Toshl Import: Multi-Account Auto-Creation — Accounts from Toshl's Account column are created automatically with inferred types (e.g., "Cash" → cash, "Investment" → investment) and currencies from the CSV.
• Toshl Import: Full Preview — Preview shows accounts to create, categories to create, tags to create, and transfer rows to skip before executing.

Fixed

• PostgreSQL compatibility (#185, #192): Fixed SUBSTR() on date columns by casting to VARCHAR. Affects all report/trend queries.
• CSV encoding detection (#189): Import now auto-detects ISO-8859-1, Windows-1252, and ISO-8859-15 encodings and converts to UTF-8.
• Horizontal scrolling (#188): Transaction table no longer overflows viewport with long descriptions.
• Scheduled transaction auto-clear: Editing a scheduled transaction's date to today or past automatically changes status to cleared and updates the account balance.
• Liability balance display: Account detail view now shows absolute value for liability accounts instead of raw negative number.
• Net worth formula: Corrected for negative liability balance model.
• Category delete error message: Now explains why deletion failed and what to do.
• Database migration: Existing liability account balances automatically negated on upgrade.
• Backward-compatible import: Legacy data exports with positive liability balances are converted during import.

Fixed

• DI registration mismatches: Fixed missing IL10N in BankSyncService, missing LoggerInterface in BillService and RecurringIncomeService DI registrations causing 500 errors on income and bills pages.
• API credentials exposure: Institutions endpoint changed from GET to POST so GoCardless secrets are no longer in URL query parameters.
• Premature active status: New GoCardless connections and re-authorizations now use pending_auth status until bank authorization is completed, preventing failed background sync attempts.
• False-positive expiration: Transient API errors during reauth checks no longer incorrectly mark connections as expired; only definitive statuses (EX/RJ/SA) trigger expiration.
• Double-click protection: All wizard buttons now have busy guards preventing duplicate submissions.
• Auth check conflict: Fixed onclick/addEventListener collision in the authorization check step.
• Budget account unmapping: Users can now clear a mapped budget account back to unmapped.
• Transaction ID collisions: Fallback hash for transactions without IDs now includes account ID and index to prevent silent deduplication of identical purchases.
• Provider revocation: Disconnecting a GoCardless connection now revokes the requisition at the provider.
• API efficiency: refreshAccounts no longer fetches transaction data unnecessarily, saving GoCardless API quota.
• Background job memory: Credentials are no longer bulk-decrypted; connections processed one at a time.
• Null safety: Fixed potential TypeError when disconnecting with mappings section not rendered.

Changed

• Country names in bank selection now use Intl.DisplayNames for automatic locale-appropriate translation.
• Connection name validated (1-255 chars), country code validated (2-letter ISO), redirect URLs validated against Nextcloud base URL.
• SimpleFIN claim POST now has a 30-second timeout.
• Default currency fallback changed from GBP to EUR for GoCardless.
• Service-layer messages wrapped in IL10N for translation support.
• Background job converted from service locator to constructor injection.

Added

• GoCardless Bank Sync Wizard (#184): Complete multi-step connection flow — enter API credentials, select your country and bank from a searchable grid with logos, then authorize at your bank. Previously the institution selection step was missing, making GoCardless connections non-functional.
• Re-authorization Flow: Expired GoCardless connections (90-day PSD2 limit) now show a "Re-authorize" button instead of requiring disconnect/reconnect.
• Sync All Connections: New button to sync all active bank connections sequentially with progress feedback and aggregated results.
• Refresh Accounts: Button in account mappings to re-fetch the account list from the bank provider.

Fixed

• GoCardless sync always failing (#184): Fixed "Bank authorization has expired" error that occurred on every sync because the connect flow never sent the institution ID, so no bank requisition was created.
• Exception messages leaking to clients: Controllers now return generic error messages instead of exposing internal exception details.
• SQLite compatibility: Replaced MySQL-specific CAST(AS CHAR) with SUBSTR for cross-database compatibility.
• Budget summary double-counting: Children's spending no longer counted twice in parent category totals.

Changed

• Controllers now use request->getParams() instead of reading php://input directly, following Nextcloud framework conventions.
• Replaced debug error_log() calls with proper PSR logger usage.

Fixed

• Duplicate detection false positives (#163): Payment + next occurrence pairs (same created_at, ~30 days apart) were incorrectly flagged as duplicates. Now only flags entries within 14 days of each other.
• Bill date edit not updating nextDueDate (#163): Editing a bill on an older version left a stale nextDueDate. Now verifies consistency on every save and recalculates if needed.

Added

• Description field for bills, income, and transfers (#181): Optional description that is used when transactions are auto-generated.
• Semi-annually frequency support: Bills can now use semi-annual frequency (every 6 months), previously missing from the frequency calculator.

Fixed

• FrequencyCalculator rewrite: Fixed 6 bugs affecting bill date calculations:
• Daily bills double-advancing (skipping 2 days instead of 1) with forceAdvance
• Biweekly bills only advancing 1 week instead of 2
• Quarterly bills getting stuck when dueMonth was >3 months behind
• Days 29-31 truncated to 28 for quarterly/yearly/one-time bills
• One-time bills incorrectly advancing +1 year on create
• forceAdvance using a 2099 date hack that broke custom frequency bills
• Bills list shows only active bills (#163): Inactive paid one-time bills no longer appear as "Upcoming".
• Calendar paid status (#163): Now uses lastPaidDate instead of nextDueDate to determine paid months.
• Bill date editing (#163): Changing dueDay/dueMonth now recalculates nextDueDate from today.
• Running balance pagination (#182): Balance calculations now correct when same-date transactions span multiple pages.
• Timezone issue in bill paid status: isBillPaidThisMonth now parses dates as strings to avoid timezone drift.
• Removed debug error_log calls from BillService.
• Repair tool no longer flags daily/weekly/biweekly bills as stuck.

Fixed

• Reconciliation marks 0 transactions (#175): The finish reconciliation flow was querying for non-existent checkbox elements. Now correctly uses the selected transactions set.
• Reconciled transaction indicator (#175): Reconciled transactions now show a green left border in both transaction views.
• Paid one-time bills showing as "Upcoming" (#163): One-time bills that were paid but remained active are now detected and deactivated by the Data Repair tool. The stuck bills repair also no longer touches one-time bills.

Fixed

• Finish Reconciliation error (#175): "this.loadTransactions is not a function" error when completing reconciliation
• Dashboard totals include excluded categories: Transactions in categories marked "Exclude from reports" were still counted in the dashboard income/expense totals

Fixed

• Reconciliation ignores statement date (#175): The statement date field was collected but never sent to the backend. Reconciliation now calculates the account balance as of the statement date, excluding transactions after it.

Added

• Exclude from reports flag for categories: Categories can be marked as excluded from budget calculations, spending reports, and dashboard totals. Useful for investment adjustments, internal bookkeeping, or reimbursement categories.
• Auto-match transfers after import (#178): After importing bank statements, the app automatically scans for and links matching transfer pairs across accounts.
• Pension DOB from Nextcloud profile (#173): Pension projections now read your date of birth from your Nextcloud profile for accurate retirement age calculations. No separate setting needed.
• Reconciliation completion (#175): Finishing a reconciliation now persists the "Last Reconciled" date and marks checked transactions as reconciled.

Fixed

• Category totals now net credits against debits (#172): Refunds/credits in a category now reduce the total instead of inflating it.
• Transfer credits no longer carry category (#172): The credit side of transfers no longer gets a category, preventing double-counting in category totals. Data Repair tool can clean existing data.
• Debt payments count as expenses (#172): Transfers to liability accounts (credit cards, loans, mortgages) now correctly count as expenses in dashboard totals instead of being excluded as internal transfers.
• Stale bill duplicate detection (#163): Data Repair tool now detects duplicate auto-generated transactions from previous billing cycles with different created_at timestamps.
• Split badge missing in account detail (#176): Split transaction indicator now shows in the account detail transaction list.
• Transaction table header alignment (#177): Table headers now match column alignment with data rows.
• XSS in account detail view: Transaction description, vendor, and category name now properly escaped in account detail rendering.
• XSS in import filename: Uploaded filename now escaped in import file details.

Security

• Added array size limit (500) on reconciliation transaction IDs to prevent oversized queries
• Fixed output encoding in account detail transaction list and import file display

Fixed

• Transactions with future date not marked as scheduled (#170): Manually creating a transaction with a future date now auto-sets status to "scheduled". Previously only bill-generated transactions had this logic.
• Factory reset fails with JSON parse error — BudgetSnapshotMapper.deleteAll() returned void instead of int, causing a TypeError in the factory reset flow
• Data Repair tool: Added detection and repair of existing future-dated transactions incorrectly marked as cleared

Added

• Multi-currency shared expenses (#168): Shared expenses now track the transaction's account currency. Balances display per-currency lines (e.g., "Owes you ¥5,000" and "Owes you $50" separately). Settlements are created per-currency.
• Data Repair tool: New "Scan for Issues" button in Settings → Maintenance detects and fixes duplicate auto-generated transactions, stuck bill due dates, and balance inconsistencies
• Bill payment duplicate detection: When marking a bill as paid, the app checks for existing transactions that may already represent the payment and lets you link them instead of creating duplicates
• In-app documentation: Help panel and sidebar with searchable user documentation for all features

Fixed

• Bills not advancing due date when paid early (#163): Paying a bill before its due date now correctly advances to the next cycle. Previously this caused balance corruption through duplicate auto-generated transactions.
• Bank sync shows 0 imports (#166): Fixed bank sync import count and PHP 8.4 nullable parameter deprecations
• Mobile responsive layout: Improved view header layout on mobile devices
• Help panel navigation: Help panel now updates content when navigating between pages

Fixed

• Upgrade fails from pre-2.14 versions (#165): Migrations 050, 051, and 053 used table/index names that exceeded database limits. Previously, fix migrations (054-056) would correct these, but users upgrading multiple versions at once would hit the broken migration before the fix could run. Now the original migrations create short table names directly, while fix migrations still handle renaming for users who already ran the old versions.

Added

• Accounts tile customisation: Unlock dashboard to access a gear icon on the Accounts tile — reorder accounts with drag-and-drop and toggle visibility per account
• Projected Balance: Account detail now shows both "Current Balance" and "Projected Balance" when scheduled transactions exist, with dimmed/italic styling on projected running balances

Fixed

• Migration fails on MariaDB (#164): Renamed budget_bank_connections table to budget_bc — auto-generated PK name exceeded MariaDB's index name limit
• Bill amount edit causes date jump (#163): Editing a bill's amount no longer recalculates the due date; only actual changes to frequency/dueDay/dueMonth trigger recalculation
• Paid bills disappear from calendar (#163): Past months now remain visible in the bills calendar with strikethrough styling to indicate they've been paid

Fixed

• Installation fails: table name too long (#162): Renamed budget_bank_account_mappings to budget_bam to stay within Nextcloud's name limit
• Recent Imports dashboard tile stuck on Loading (#157): Implemented actual import history query and fixed container ID mismatch

Added

• External Bank Sync (Beta) (#61): Connect external bank accounts for automatic transaction imports
• GoCardless provider for UK/Europe banks
• SimpleFIN provider for US banks
• Admin toggle (disabled by default) with experimental feature warning
• Encrypted credential storage, daily background sync, duplicate detection
• Account mapping between external and local accounts
• Kazakhstani Tenge (KZT) (#154): Added KZT currency with ₸ symbol
• One-time transfers (#160): Transfer form now supports one-time frequency

Fixed

• Dashboard tiles stuck on Loading (#157): 11 Phase 2/3 dashboard tiles had no render methods — now display data correctly
• Asset/liability colors inverted (#153): Colors now match actual values; income budget progress uses correct semantics
• Income amount not saving on update (#159): Fixed php://input consumption issue in RecurringIncomeController

Changed

• Updated German and Portuguese (Brazil) translations from Weblate

Fixed

• Migration fails: "Primary index name too long" (#152): Renamed budget_budget_snapshots table to budget_bgt_snapshots to stay within Nextcloud's 30-character index name limit
• Budget tab does not show income transactions (#149): Spending queries were hardcoded to debit transactions; income categories now correctly query credit transactions
• Mark bill as paid fails (#151): Regular bills and recurring income were still passing null description to transaction creation
• German translation not loading (#150): Compiled translation files were missing from the release; added compiled German and Portuguese translations

Changed

• Updated German translations from Weblate

Added

• Per-month budget adjustments: Budget values can now differ between months. Click "Adjust budgets from this month" to create a new baseline that applies from that month onwards while preserving previous months' values
• Budget snapshot system: New budget_budget_snapshots table stores per-month budget overrides with automatic resolution chain
• Parent category budget aggregation: Parent categories now show the sum of their own budget plus all children's budgets, with a "Total" hint below the input

Fixed

• Parent category spending not showing (#144): Parent categories now aggregate children's spending and budgets correctly
• Spending by Category shows wrong data on first dashboard load (#147)
• Dashboard tile header links not navigating (#146)
• Budget page month selector not filtering spending (#148)
• Bill transaction creation fails with null description (#145)

Changed

• Reports, alerts, and dashboard now use snapshot-resolved budgets for accurate per-month reporting
• Budget aggregate hint updates immediately when editing budget inputs (no reload needed)
• Improved translation documentation in README

Added

• Unrealised P&L for investment/crypto accounts: Display unrealised profit and loss based on current market value vs cost basis (#59)
• Interest accrual for loans and credit cards: Automatic interest calculation and accrual for loan and credit card accounts (#73)
• New translation: German via Weblate

Fixed

• Security and precision fixes for interest accrual: Improved input validation and decimal precision
• Interest tracking checkbox sizing: Checkbox now matches form UI styling

Fixed

• Improved color contrast for amounts and progress bars: Better visibility across all pages
• Restore Unlock Dashboard button text on mobile: Button text was missing on small screens
• Mobile navigation toggle not working and mispositioned (#130)

Fixed

• Translator placeholder protection: Added translator comments to notification strings warning not to translate {placeholder} names, and configured Weblate placeholder check (#140)

Added

• Granular budget sharing between Nextcloud users: Share accounts, categories, budgets, and savings goals with other Nextcloud users with read/write permissions (#23)
• Duplicate transaction option: Quickly duplicate an existing transaction (#138)
• Skip payment option for recurring bills: Skip a bill payment and advance to the next due date (#132)
• New translations: Spanish, French, Russian, Portuguese (Brazil) via Weblate

Fixed

• Category drag-and-drop throws DOM insertBefore error: Fixed drag-and-drop reordering of categories
• Cannot change subcategory to top-level category (#141)
• Recent Transactions dashboard tile shows empty (#139)
• Auto-generated bill/income transactions use null description (#137)
• Undo mark-as-paid now properly deletes created transactions (#136)
• Shared expenses overhaul: Fixed settlements, badges, and UI layout (#134)
• Standardize positive/negative amount colors with CSS custom properties (#133)
• Security audit fixes: Added missing write-access checks and input validation
• Database review fixes: Cascade delete and parameter type corrections
• Frontend review fixes: Error handling, partial saves, and performance improvements

Fixed

• Tag filter checkmark visibility improved: Checkmarks in tag filter dropdowns are now visible, and "include untagged" is unchecked by default (#128)
• bcmath dependency removed from migration: Removed bcmath requirement from migration code and declared it in info.xml (#131)
• Mobile navigation toggle for collapsed sidebar: Sidebar navigation toggle now works correctly on mobile when sidebar is collapsed

Fixed

• Tag/category dropdown selection broken on Safari/WebKit: Moved selection logic from click to mousedown event to fix dropdowns not responding to clicks in Safari, DuckDuckGo, and other WebKit browsers (#128)

Added

• Full internationalization (i18n) support: All user-facing strings are now translatable, enabling multilingual translations via Weblate
• Multi-currency bill display and split templates: Bills now show amounts in their native currency with base-currency equivalents, and split templates support multi-currency accounts (#126, #121)

Fixed

• Stale event listeners breaking tag filter in reports: Prevented duplicate event listeners from accumulating and causing tag filters to malfunction (#128)
• Long tag names cut off in transaction list: Tag names are no longer truncated in the transaction list display

Added

• Global tags support: Tags can now be created globally and shared across all categories (#109)
• Creation date filter for transactions: Filter transactions by when they were created in the app, separate from the transaction date (#127)
• Account filter on bills calendar report: Filter the bills calendar by specific accounts (#105)
• Fiat equivalent display on non-base-currency accounts: Accounts in foreign currencies now show their equivalent value in your base currency (#58)
• Deletion warnings and duplicate transaction detection: Warns before deleting transactions and detects potential duplicates during entry (#115)
• Info notice on Tags page: Explains the difference between global and category-specific tags

Fixed

• Pre-existing test failures: Fixed test failures across 6 test files including AccountServiceTest dependency issues

Added

• LATAM currencies and zero-decimal fiat display: Added support for Latin American currencies (ARS, BRL, CLP, COP, PEN, UYU) and fixed display for zero-decimal fiat currencies (#123)
• Transfer target account name in transaction table: Transaction table now shows the target account name for transfer transactions (#116)

Fixed

• Scheduled transactions incorrectly affect account balance: Scheduled (future) transactions were included in the stored account balance; a migration recalculates all balances to exclude them (#115)
• Tags not saved when creating a new transaction: Tags were silently dropped when creating transactions (#125)
• Account and category filters reset when toggling filter panel: Opening or closing the filter panel cleared the selected account and category filters (#117)
• Bill/income name populates vendor field instead of description: Creating a transaction from a bill or income item put the name in the vendor field rather than the description (#120)
• Entity updates silently fail due to method_exists on magic methods: Updates to entities using magic setter methods were silently ignored (#118)
• Debt payoff recommendation uses hardcoded GBP symbol: Debt payoff planner now uses the user's configured currency symbol instead of £ (#122)
• Balance recalculation fails on PostgreSQL with invalid date: Fixed a PostgreSQL-specific error when recalculating balances with null or invalid dates (#124)
• Bill payment and scheduling bugs causing balance discrepancies: Fixed multiple issues with bill payments and scheduling that led to incorrect account balances (#115)
• Import rules losing criteria and actions during data re-import: Re-importing rules from backup data could overwrite existing criteria and actions (#119)

Fixed

• Parent category dropdown not working when editing subcategories: The parent dropdown failed to show or pre-select the current parent when editing subcategories (#111)
• Map income/expense to credit/debit in rule type actions: Import rules with "set type" action stored income/expense instead of the internal credit/debit values, causing the type to appear empty on affected transactions (#110)

Added

• Asset value history dashboard widget: Track asset values over time with a change indicator showing growth/decline (#92)
• Account filtering on dashboard widgets: Filter dashboard widgets by specific accounts (#71)
• Minimum payment field on account edit form: Track minimum payments for credit card and loan accounts (#102)

Fixed

• Hierarchical nested category dropdowns everywhere: All category dropdowns now show the full parent/child hierarchy consistently (#104)
• Quick Add Transaction widget not populating accounts and categories: Widget now correctly loads account and category options
• Central currency list for asset and pension dropdowns: Asset and pension forms now use the same currency list as the rest of the app (#103)
• Duplicate category creation and renaming: Prevent creating or renaming categories to names that already exist
• Show actual error message when category create/update fails: Error responses now display the server's message instead of a generic error
• Allow clearing category, vendor, notes, and reference on transactions: These fields can now be set back to empty (#98)
• Handle BOM and metadata preamble in DKB CSV imports: DKB bank exports with byte-order marks and header metadata are now parsed correctly (#100)

Added

• Running balance column on transactions table: Bank-statement-style cumulative balance column that shows the account balance at each transaction. Auto-hides when viewing multiple accounts or using non-date sorting/filters (#79)
• Bi-weekly frequency for bills, income, and transfers: New bi-weekly option across all frequency dropdowns (#88)
• One-time income support: Non-recurring income entries that auto-deactivate after being marked as received; also adds semi-annually frequency to income (#91)
• Redesigned Match All with scan/review flow: Split bulk-match into separate scan and link steps with a pre-scan config dialog for date window and auto/review mode. Adds currency check to prevent cross-currency matching and fixes N+1 account queries (#82)

Fixed

• Recurring bill payment not creating transaction for current period: Marking a recurring bill as paid only created a scheduled transaction for the next period — the current payment was never recorded. Now finds and clears any pre-existing scheduled transaction, or creates a new cleared one (#99)
• Pension return rate displayed as decimal in edit form: The edit form showed the raw decimal (e.g. 0.05) instead of the percentage (5%). Now correctly converts between display and storage formats (#101)
• Reconciliation using wrong balance: Reconciliation used the raw stored balance (including future scheduled deductions) instead of the adjusted current balance shown on the account card

Added

• Create transaction when marking recurring income as received: Marking income as received now automatically creates a corresponding transaction in the linked account, so income appears in transaction history and reports (#99)

Fixed

• 2-digit year dates in CSV import: CSV files using 2-digit year date formats (e.g. 25.03.26) are now parsed correctly (#100)

Added

• Tag filter on transaction list: Filter transactions by tag directly from the transaction page (#96)
• Split type filter and account filter matching: Filter transactions by split type (unsplit, split parent, split child); account filter options now match the accounts dropdown (#97)

Fixed

• European-format zeros (e.g. 0,00) in dual-column CSV import no longer treated as valid amounts (#95)
• Bill name field clarified as "Vendor / Payee" to match its actual purpose (#94)
• Removed undefined distinct() call in QueryFilterBuilder that could cause errors on some databases
• Category dropdown clipped by overflow:hidden on table cells
• Search filter inputs now span full width of the filter grid

Added

• Import and Export buttons on account details page: Quick access to import statements and export transactions directly from account view
• Improved account reconciliation: Adjustment transactions created automatically when reconciliation reveals a balance discrepancy; UX improvements to reconciliation flow

Fixed

• Filter panel layout tidied up; removed unused more-actions button
• Empty-state message now spans full table width in account transactions view
• Account header condensed into a single row for cleaner layout
• Dark green text colors brightened for dark mode readability across account pages and pagination
• Account pagination centered properly
• Correct error message shown when attempting to delete an account that still has transactions
• Institution field not persisting on account edit due to duplicate element ID
• Account form group spacing and credit limit field margin

Added

• Redesigned category details panel: Spending breakdown chart with enhanced analytics showing monthly trends, top vendors, and budget progress (#88)
• Redesigned assets page: Styled asset cards with full-page detail view replacing the previous list layout
• Redesigned transaction actions: More-actions dropdown replaced with a horizontal icon toolbar for faster access
• Consistent date formatting: Replace native date inputs with flatpickr across the app so the user's chosen date format is used everywhere — transaction forms, filters, inline editing (#72)
• Tag set editing: Edit existing tag sets and tags with duplicate name validation (#90)
• Inline amount editor: Simplified to text-only input with automatic type detection based on sign (positive = income, negative = expense)

Fixed

• Category dropdown not working: Categories stopped appearing in transaction dropdown after a recent UI update (#87)
• NC33 background job error: Log error when starting Nextcloud 33 with Budget enabled (#86)
• Interest rate limit: Error saving account when interest rate exceeds 9.99%; widened column precision from DECIMAL(5,4) to DECIMAL(7,4) (#74)
• Liability sign/color inversion: Liability account cards showed a forced negative sign on positive balances; Total Assets summary used static green color even when negative (#85)
• Liability totals incorrect: Totals now net credits against debt instead of using absolute values; cards distinguish owed vs credit balance
• One-time bill transactions not created: Marking a one-time bill as paid did not create a transaction or deduct from account balance because the bill was deactivated before the transaction creation check (#89)
• One-time bill payment date: Payment transactions now use today's date and are marked as cleared instead of scheduled
• Dashboard tile reordering errors: "Failed to save widget order" and "Failed to save dashboard lock state" errors caused by race conditions during rapid drag-and-drop; settings saves are now debounced (#77)
• Add Tiles menu closing: Menu no longer closes when selecting tiles
• Asset detail edit button broken: Edit button in asset detail panel did nothing due to a button ID mismatch between template and JavaScript (#76)
• Asset edit modal crash: Annual rate field ID mismatch caused the modal to fail on open
• Split transaction cannot be undone: The "Unsplit Transaction" button existed but was never shown or connected to its handler; now visible when editing a split transaction (#75)
• Split indicator badge missing: Split transactions now show the indicator badge; split modal auto-fills remaining balance
• Inline account change: Support changing a transaction's account via inline edit (#70)
• Transaction action buttons overflowing: Prevent action buttons from being pushed into adjacent columns by long text; editable cell overlay no longer blocks the actions column
• Tag set edit button not wired up: Edit button now works; fixed related categories navigation issue
• "Use Default Categories" failing: JSON parse error when applying default categories
• Sidebar search overlap: Search text no longer overlaps the search icon
• Theme consistency: Category settings button, configure columns button, and reconciliation panel now use Nextcloud theme variables

Fixed

• Multi-currency account totals: Account list totals now correctly convert balances to the user's default currency; asset value editing saves properly (#68)
• Action buttons disappearing: Prevent action buttons from being pushed off-screen by long text in transaction and account views (#69)
• Opening balance not persisting on edit: Editing an account now correctly saves the opening balance and auto-recalculates the stored balance (#64)
• Missing NetWorthSnapshotJob registration: Background job was not registered in info.xml, preventing automatic net worth snapshots (#67)

Improved

• Manual exchange rate modal visual refinements for better readability and spacing

Fixed

• Migration failure on upgrade from 2.6.x to 2.7.0: Undefined constant OCP\IDBConnection::PARAM_INT in opening balance migration — used wrong constant class (#66)
• Log error spam from missing notification icon: Notifier referenced non-existent app-dark.svg, causing RuntimeException on every notification poll (#65)

Added

• Opening balance tracking: New opening_balance column on accounts separates the initial balance from transaction-derived running totals. Existing accounts are back-calculated automatically during migration (#64)
• Recalculate Account Balances: New maintenance tool in Settings recalculates all account balances from opening balance + transaction history (#64)
• Opening balance field on account edit: Edit an account's opening balance directly; contextual labels show "Starting Balance" on create and "Current Balance" on edit
• Comprehensive unit test suite: 1,045 tests covering all services, mappers, controllers, and edge cases

Fixed

• Account balance corruption when editing account details — the display balance (excluding future transactions) was incorrectly written back as the stored balance (#64)
• Import preview showing "Uncategorized" for all transactions despite matching import rules (#64)
• Money market accounts invisible on Accounts page due to missing account type in filter (#64)
• Account balances not refreshing after importing transactions (#64)
• Year-over-Year report and Bills Calendar export functionality (#62)
• Dashboard charts auto-regenerate when switching accounts (#62)

Fixed

• Database migration failure: table name budget_manual_exchange_rates exceeded Nextcloud's 27-character limit (#62)

Added

• Configurable budget cycle start day: Set a custom start day for budget periods instead of always using the 1st of the month (#54)
• Exchange rate support for non-ECB currencies: Currencies not covered by the European Central Bank now fetch rates from fallback providers (#55)
• Transaction status column: Scheduled future transactions can be excluded from reports and balance calculations (#56)

Fixed

• Reports account filtering, year-over-year filtering, and export errors (#62)
• Category text unreadable in light theme (#17)
• Import rule matching now uses v2 schema during file import (#57)
• Bills page title changed from "Recurring Bills" to "Bills"

Added

• Assets section: Track non-cash assets (real estate, vehicles, jewelry, collectibles) with value snapshots, appreciation/depreciation projections, and net worth integration (#52)
• CRUD management with 11 REST endpoints
• Value history charts and projection charts
• Dashboard hero tile for total asset worth
• Net worth and factory reset integration

Fixed

• Parent category dropdown showing wrong type when creating Income categories (#53)

Added

• Cryptocurrency account type: Static cryptocurrency tracking with 25 supported currencies (BTC, ETH, XRP, SOL, DOGE, etc.), correct decimal precision, and encrypted wallet address field (#47)
• Multi-currency dashboard aggregations: Hero tiles, net worth, trend data, and cash flow reports convert all account values to the user's default currency before summing. Exchange rates fetched from ECB (fiat) and CoinGecko (crypto) with daily background updates (#52)
• Recurring bill end dates: Optional end date or remaining payment count on bills; bills auto-deactivate when conditions are met and annual overview respects constraints (#46)
• Unit tests: 133 new tests across AccountService, AuthService, CategoryService, TagSetService, and TransactionService

Fixed

• Bill mark-as-paid now uses the bill's due date instead of today's date, preventing wrong billing period from being marked paid (#51)
• Bill status badge colors use explicit values instead of Nextcloud CSS variables for reliable contrast (#51)
• Blank pagination pages after bulk actions caused by ?int category parameter discarding 'uncategorized' string value; reset page to 1 after bulk operations (#50)
• CSV date parsing for DD/MM/YYYY format (#48)
• Bill date timezone bug and added one-time bill frequency (#39)
• Pension edit modal redesigned with form-section layout; fixed missing field persistence for expectedReturnRate, retirementAge, and transferValue
• Pension summary and projections now convert to base currency before aggregating
• Dashboard pension worth tile uses base currency instead of first account's currency
• getPrimaryCurrency() replaced with user's default_currency setting instead of balance-weighted heuristic
• Income summary API returns correct keys for page tiles (expectedThisMonth, monthlyTotal, receivedThisMonth, activeCount)

Changed

• Added ext-bcmath PHP extension dependency

Fixed

• CSV import crash (array_combine() error) when bank exports include metadata preamble rows before column headers (e.g. Swiss bank CSVs) (#11)
• UTF-8 BOM in CSV files polluting the first column header name

Added

• Pending transaction indicator: Future-dated transactions display with muted opacity, italic text, and an orange "Pending" badge (#39)
• Status filter (All / Cleared / Pending) in main transactions and account detail views
• Expanded currency support: Added 25+ new currencies covering Americas, Europe, Asia-Pacific, Middle East, and Africa (45 total)
• Custom toast notifications: Built-in toast notification system replacing deprecated OC.Notification calls

Fixed

• Account detail filters (category, type, status, date range, amount range, search) not passed to transactions API (#43)
• PostgreSQL compatibility: cast date column to CHAR before SUBSTR for month extraction (#41)
• Reports: exclude transfers from aggregate income/expense totals in all-accounts view to prevent double-counting

Removed

• Non-functional in-app theme toggle (light/dark/system) — the app correctly inherits Nextcloud's global theme via CSS variables (#44)
• Hardcoded dark mode CSS overrides from rules builder components

Fixed

• Cannot update account after creation when IBAN or other banking details are provided (#38)
• Encrypted banking fields (IBAN, account number, routing number, sort code, SWIFT/BIC) exceeded column length limits
• Widened all encrypted columns from 10-100 chars to 512 chars to accommodate AES-CBC encrypted output (~232 chars)

Added

• Tag-linked savings goals: Link savings goals to tags so current amount is automatically calculated from the sum of tagged transactions
• Tag dropdown in goal modal with options grouped by tag set
• Auto-tracked badge and disabled manual amount entry for linked goals
• Goals without a linked tag continue to use manual tracking
• Tag selection in bills: Assign tags from category tag sets when creating or editing bills
• Dynamic tag dropdowns load based on selected category
• Tags stored on bill entity and applied to generated transactions
• Tag selection in recurring transfers: Assign category and tags to recurring transfers
• Category dropdown and dynamic tag selectors in transfer modal
• "Create transactions now" checkbox to immediately generate tagged transactions
• Tags automatically applied to transactions created via auto-pay

Fixed

• Budget period conversion rounding errors and inconsistent summary cards (#35)
• Increased budget_amount column precision from DECIMAL(15,2) to DECIMAL(15,6) for accurate intermediate conversions
• Removed premature 2-decimal rounding in budget proration; round only for display
• Normalized all category budgets to monthly in summary cards for consistent totals
• Goal modal form groups missing top margin spacing

Fixed

• App store screenshot display - corrected repository name in screenshot URL from Nextcloud-Budget to Budget

Fixed

• Critical database migration error preventing fresh installations: "Column is type Bool and also NotNull, so it can not store false"
• Fixed 4 boolean columns incorrectly created with NOT NULL constraint in migrations 001000024, 001000026, and 001000027:
• budget_import_rules.stop_processing
• budget_bills.auto_pay_enabled
• budget_bills.auto_pay_failed
• budget_bills.is_transfer
• Added cleanup migration (Version001000028) to fix existing installations that already ran broken migrations
• All boolean columns now use 'notnull' => false as required by Nextcloud's DBAL for cross-database compatibility
• Updated CLAUDE.md with critical boolean column requirements to prevent future occurrences

Added

• Custom frequency pattern for bills: Select specific months when irregular bills occur (e.g., bills in January, June, and July only)
• New "Custom" frequency option in bill creation/editing modal
• Interactive month selector with modern tile-based UI design
• Selected months show full primary color background with checkmark indicators
• Smooth hover animations and responsive grid layout (4/3/2 columns for desktop/tablet/mobile)
• Automatic next due date calculation based on selected month patterns
• Handles year wrapping and month-end edge cases (e.g., day 31 in February)
• Monthly equivalent calculations for budget summaries
• Pattern stored as JSON: {"months": [1, 6, 7]} for flexibility

Improved

• Enhanced month selector UI with hidden checkboxes and clean tile design
• Better visual feedback for selected months in bill frequency picker

Fixed

• Re-release with corrected build configuration excluding development files from distribution package

Fixed

• Missing deleteByTag() method in TransactionTagMapper causing HTTP 500 errors when deleting categories with tag sets
• Categories with subcategories can now be deleted recursively - cascade delete now removes all child categories and their tag sets automatically