[PR #4459] [MERGED] feat: add "last reconciled" timestamp to accounts #5394

Closed
opened 2026-02-28 21:11:44 -06:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/actualbudget/actual/pull/4459
Author: @tostasmistas
Created: 2/26/2025
Status: Merged
Merged: 3/3/2025
Merged by: @youngcw

Base: masterHead: feat/accounts-last-reconciled


📝 Commits (3)

  • 520d0d7 feat: add "last reconciled" timestamp to accounts
  • a42b559 test: generate mock accounts with last_reconciled as null
  • 7b263f7 improvement: display "last reconciled" timestamp in tooltip

📊 Changes

11 files changed (+81 additions, -7 deletions)

View changed files

📝 packages/desktop-client/src/components/accounts/Account.tsx (+14 -0)
📝 packages/desktop-client/src/components/accounts/Balance.tsx (+1 -0)
📝 packages/desktop-client/src/components/accounts/Header.tsx (+24 -5)
📝 packages/desktop-client/src/components/spreadsheet/index.ts (+1 -0)
packages/loot-core/migrations/1740506588539_add_last_reconciled_at.sql (+5 -0)
📝 packages/loot-core/src/mocks/index.ts (+1 -0)
📝 packages/loot-core/src/server/accounts/app.ts (+11 -2)
📝 packages/loot-core/src/server/aql/schema/index.ts (+1 -0)
📝 packages/loot-core/src/shared/util.ts (+16 -0)
📝 packages/loot-core/src/types/models/account.d.ts (+1 -0)
upcoming-release-notes/4459.md (+6 -0)

📄 Description

⚠️ This PR contains a migration ⚠️


This PR resolves #2967.

It adds a last_reconciled column to the accounts table, which stores a UNIX timestamp indicating when each account was last reconciled. Upon initial release, all accounts will display "Not yet reconciled"; however, after completing reconciliation and pressing the "Done reconciling" button, the timestamp will be updated accordingly.


imagem

imagem

imagem

imagem



🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/actualbudget/actual/pull/4459 **Author:** [@tostasmistas](https://github.com/tostasmistas) **Created:** 2/26/2025 **Status:** ✅ Merged **Merged:** 3/3/2025 **Merged by:** [@youngcw](https://github.com/youngcw) **Base:** `master` ← **Head:** `feat/accounts-last-reconciled` --- ### 📝 Commits (3) - [`520d0d7`](https://github.com/actualbudget/actual/commit/520d0d74af6bbdc02b98a5f96551d237bf673dda) feat: add "last reconciled" timestamp to accounts - [`a42b559`](https://github.com/actualbudget/actual/commit/a42b5591ce3b3d9eaf5afd81521697e0afe4033f) test: generate mock accounts with `last_reconciled` as `null` - [`7b263f7`](https://github.com/actualbudget/actual/commit/7b263f7c2cc9fce861665ebf9a32123903100e35) improvement: display "last reconciled" timestamp in tooltip ### 📊 Changes **11 files changed** (+81 additions, -7 deletions) <details> <summary>View changed files</summary> 📝 `packages/desktop-client/src/components/accounts/Account.tsx` (+14 -0) 📝 `packages/desktop-client/src/components/accounts/Balance.tsx` (+1 -0) 📝 `packages/desktop-client/src/components/accounts/Header.tsx` (+24 -5) 📝 `packages/desktop-client/src/components/spreadsheet/index.ts` (+1 -0) ➕ `packages/loot-core/migrations/1740506588539_add_last_reconciled_at.sql` (+5 -0) 📝 `packages/loot-core/src/mocks/index.ts` (+1 -0) 📝 `packages/loot-core/src/server/accounts/app.ts` (+11 -2) 📝 `packages/loot-core/src/server/aql/schema/index.ts` (+1 -0) 📝 `packages/loot-core/src/shared/util.ts` (+16 -0) 📝 `packages/loot-core/src/types/models/account.d.ts` (+1 -0) ➕ `upcoming-release-notes/4459.md` (+6 -0) </details> ### 📄 Description **⚠️ This PR contains a migration ⚠️** --- This PR resolves #2967. It adds a `last_reconciled` column to the `accounts` table, which stores a UNIX timestamp indicating when each account was last reconciled. Upon initial release, all accounts will display "Not yet reconciled"; however, after completing reconciliation and pressing the "Done reconciling" button, the timestamp will be updated accordingly. --- <kbd><img width="793" alt="imagem" src="https://github.com/user-attachments/assets/0ac295fd-8c23-41d0-8d41-6363191475b1" /></kbd> <kbd><img width="855" alt="imagem" src="https://github.com/user-attachments/assets/a0159795-f924-4c1a-a11a-60c67a933cb5" /></kbd> <kbd><img width="852" alt="imagem" src="https://github.com/user-attachments/assets/9b511a17-a2bd-4952-b41c-abb7babb24b5" /></kbd> <kbd><img width="927" alt="imagem" src="https://github.com/user-attachments/assets/6e57265e-49a2-475b-8861-879755c8d508" /></kbd> --- --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-02-28 21:11:44 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#5394