mirror of
https://github.com/actualbudget/actual.git
synced 2026-08-04 06:12:43 -05:00
[PR #7335] [MERGED] [AI] Add BALANCE_OF() function to fetch balance of an arbitrary account #96990
Closed
opened 2026-05-26 13:27:36 -05:00 by GiteaMirror
·
0 comments
No Branch/Tag Specified
master
jfdoming/opfs-sahpool-mobile
jfdoming/opfs-sahpool
dependabot/npm_and_yarn/npm_and_yarn-8f254b6801
fix-8612-schedule-delete-menu
jfdoming/api-tokens-part-8
jfdoming/api-tokens-part-7
jfdoming/api-tokens-part-6
jfdoming/api-tokens-part-5
jfdoming/mobile-safe-area-header
jfdoming/api-tokens-part-4
jfdoming/mobile-splash-lifecycle
jfdoming/api-tokens-part-3
jfdoming/mobile-shared-array-buffer
jfdoming/api-tokens-part-2
jfdoming/api-tokens-part-1
claude/react-compiler-js-ts-ml5vaw
persist-transaction-filters
claude/modernize-transactions-tanstack-orgrze
fix-slow-transaction-context-menu-listener
ai/balance-of-query-mode
ai/add-loan-formula-autocomplete
release
bank-sync-per-file-03-pluggy-loot-core
claude/auto-close-prs-no-profile-pic-mjqpsy
cross-version-sync
cross-version-sync-stage2
claude/react-table-library-research-afx83z
tolerate-newer-migrations
claude/verify-migration-guardrails-i82c8m
tabedzki/feat/replacing-month-picker-with-day-picker
delay-initial-sync-until-loaded
cross-version-sync-compat
jfdoming/mobile-app-updates
claude/budget-version-migration-compat-151jlr
claude/worker-error-serialization-9iqtl7
claude/issue-8401-regression-test-9nw9l3
jfdoming/mobile-app-foundation-part-1
jfdoming/mobile-app-scaffold
ai-fix-cleanup-def-8290
claude/relaxed-shannon-jusywa
claude/fervent-keller-s6f2fq
claude/determined-feynman-st1y9z
claude/wizardly-einstein-vi2wce
claude/sweet-albattani-7nseio
feat/bank-sync-per-budget-file
claude/affectionate-cannon-y0kc82
claude/dependabot-findings-m9pgmb
claude/mac-app-ios-publish-zjs1lz
claude/vigilant-tesla-aiiyos
depot-migrate-secrets-1781296330308
claude/quirky-cerf-v5qck7
claude/animation-removal-alternative-2etfh1
claude/netlify-preview-comments-consolidate-9XPYa
osc/7391-error-boundaries-reports
claude/pensive-dijkstra-7DYui
claude/server-app-version-mismatch-HTCGv
claude/pr-8027-review-feedback-mELuO
claude/zealous-wozniak-e5pO0
claude/intelligent-heisenberg-BSHJq
claude/translation-download-refactor-jFRsO
claude/mobile-performance-ideas-G9PAO
claude/github-issue-7988-5A5ly
blacksmith-migration-ff70d2d
claude/great-mayer-KRvOk
claude/react-native-ios-compilation-fcJh5
claude/serene-goldberg-58xv0
claude/kind-euler-LVG3K
release-automation/edge-nightly
7710-bundle-migrations
claude/fix-docker-build-error-WMfed
claude/llm-compatible-release-notes-t20Nr
7710-tests-tdd
cursor/transaction-table-rewrite-f077
claude/plan-ci-secure-context-OtEe1
claude/fix-issue-7667-DPXi3
cursor/resolve-pr-7449-ee11
claude/fix-typescript-build-error-JPtZ5
copilot/add-repository-configs-to-packages
worktree-compressed-drifting-ritchie
claude/api-consumer-verification-kfz1K
pr-7454
claude/fix-issue-7410-LLLQ4
revert-7281-generate-icons
react-query-useSchedules
copilot/sub-pr-6140
package-upgrades
v26.8.0
v26.7.0
v26.6.0
v26.5.2
v26.5.1
v26.5.0
v26.4.0
v26.3.0
v26.2.1
v26.2.0
v26.1.0
v25.12.0
v25.11.0
v25.10.0
v25.9.0
v25.8.0
v25.7.1
v25.7.0
v25.6.1
v25.6.0
v25.5.0
v25.4.0
v25.3.1
v25.3.0
v25.2.1
v25.2.0
v25.1.0
v24.12.0
v24.11.0
v24.10.1
v24.10.0
v24.9.0
v24.8.0
v24.7.0
v24.6.0
v24.5.0
v24.4.0
v24.3.0
v24.2.0
v24.1.0
v23.12.0
v23.11.0
v23.10.0
v23.9.0
v23.8.1
v23.8.0
v23.7.2
v23.7.1
v23.7.0
v23.6.0
v23.5.0
v23.4.2
v23.4.1
v23.4.0
v23.3.2
v23.3.0
v23.2.9
v23.2.5
v23.1.12
v22.12.9
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
Mirrored from GitHub Pull Request
No labels
pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No projects
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#96990
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/actualbudget/actual/pull/7335
Author: @StephenBrown2
Created: 3/30/2026
Status: ✅ Merged
Merged: 4/14/2026
Merged by: @youngcw
Base:
master← Head:push-mmnmmrvoszkr📝 Commits (10+)
e808724Add BALANCE_OF() function to fetch balance of an arbitrary accountbf6d57aUpdate VRT screenshotse2eb1b6Adjust docs864cc0d[autofix.ci] apply automated fixes3e1e59eUpdate tests to verify sidebar balances9eacc8aAdd comments to schedule-template.ts6b0e867Update index.ts to recompute sidebar balances11eae61[autofix.ci] apply automated fixescd03a6cUpdate VRT screenshots379d701Address CodeRabbit comments📊 Changes
19 files changed (+437 additions, -56 deletions)
View changed files
📝
packages/desktop-client/e2e/page-models/account-page.ts(+13 -0)📝
packages/desktop-client/e2e/transactions.test.ts(+14 -0)📝
packages/desktop-client/src/components/formula/transactionModeFunctions.ts(+12 -0)📝
packages/desktop-client/src/components/sidebar/Account.tsx(+11 -1)📝
packages/desktop-client/src/components/sidebar/Accounts.tsx(+3 -0)📝
packages/desktop-client/src/hooks/useFormulaExecution.ts(+1 -1)📝
packages/desktop-client/src/hooks/useTransactionFormulaExecution.ts(+26 -4)📝
packages/docs/docs/experimental/formulas.md(+16 -0)📝
packages/loot-core/src/server/budget/schedule-template.test.ts(+1 -0)📝
packages/loot-core/src/server/budget/schedule-template.ts(+34 -6)📝
packages/loot-core/src/server/rules/action.ts(+6 -0)➕
packages/loot-core/src/server/rules/balanceOfFormula.test.ts(+47 -0)➕
packages/loot-core/src/server/rules/balanceOfFormula.ts(+56 -0)📝
packages/loot-core/src/server/rules/customFunctions.ts(+26 -7)📝
packages/loot-core/src/server/rules/formula-action.test.ts(+35 -0)📝
packages/loot-core/src/server/rules/rule.ts(+2 -0)📝
packages/loot-core/src/server/sync/index.ts(+22 -1)📝
packages/loot-core/src/server/transactions/transaction-rules.ts(+106 -36)➕
upcoming-release-notes/7335.md(+6 -0)📄 Description
Description
This PR adds
BALANCE_OF("…")for rule formulas (the ƒ formula mode on Set actions and split-amount formulas).balancevariable) at the same transaction cutoff as the current row (date,sort_order,idordering).balancevariable;BALANCE_OFis for other accounts.runRules,applyActions, schedule template) into_balanceOfPrefetchedon the transaction object. Before HyperFormula runs,substituteBalanceOfLiteralsreplaces eachBALANCE_OF("…")with a numeric cent literal so formula execution stays synchronous and we avoid a HyperFormula plugin that needs DB access.getRunningBalanceBeforeTransactionis shared withprepareTransactionForRulesfor the existingbalancefield. Split rule actions receive the same prefetch map as the parent row;finalizeTransactionForRulesstrips internal fields.Related issue(s)
https://discord.com/channels/937901803608096828/1488212143923921088
Testing
Automated
packages/loot-core:balanceOfFormula.test.ts(literal extraction, substitution, id vs name resolution).packages/loot-core:formula-action.test.ts(prefetched map + missing literal → 0).Manual
=BALANCE_OF("Your Account Name")or=BALANCE_OF("<account-id>")and confirm the Set field result matches expectations vs the register for that account.Checklist
Bundle Stats
View detailed bundle stats
desktop-client
Total
Changeset
home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.tssrc/components/formula/transactionModeFunctions.tssrc/components/sidebar/Account.tsxsrc/components/sidebar/Accounts.tsxView detailed bundle breakdown
Added
No assets were added
Removed
No assets were removed
Bigger
Smaller
No assets were smaller
Unchanged
loot-core
Total
Changeset
home/runner/work/actual/actual/packages/loot-core/src/server/rules/balanceOfFormula.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.tshome/runner/work/actual/actual/packages/loot-core/src/server/transactions/transaction-rules.tshome/runner/work/actual/actual/packages/loot-core/src/server/budget/schedule-template.tshome/runner/work/actual/actual/packages/loot-core/src/server/sync/index.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/rule.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/action.tsView detailed bundle breakdown
Added
Removed
Bigger
No assets were bigger
Smaller
No assets were smaller
Unchanged
No assets were unchanged
api
Total
Changeset
home/runner/work/actual/actual/packages/loot-core/src/server/rules/balanceOfFormula.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.tshome/runner/work/actual/actual/packages/loot-core/src/server/transactions/transaction-rules.tshome/runner/work/actual/actual/packages/loot-core/src/server/budget/schedule-template.tshome/runner/work/actual/actual/packages/loot-core/src/server/sync/index.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/rule.tshome/runner/work/actual/actual/packages/loot-core/src/server/rules/action.tsView detailed bundle breakdown
Added
No assets were added
Removed
No assets were removed
Bigger
Smaller
No assets were smaller
Unchanged
No assets were unchanged
cli
Total
View detailed bundle breakdown
Added
No assets were added
Removed
No assets were removed
Bigger
No assets were bigger
Smaller
No assets were smaller
Unchanged
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.