github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-07-15 22:54:03 -05:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[GH-ISSUE #3928] [Bug]: Transaction order is incorrect after importing data with the same date #27432

New Issue
Closed
opened 2026-04-18 03:54:15 -05:00 by GiteaMirror · 3 comments
GiteaMirror commented 2026-04-18 03:54:15 -05:00
Owner
Copy Link

Originally created by @youaintnobody on GitHub (Dec 4, 2024).
Original GitHub issue: https://github.com/actualbudget/actual/issues/3928

Verified issue does not already exist?

  • I have searched and found no existing issue
  • I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

I'm running the following:
Client version: v24.11.0
Server version: v24.11.0

I'm new to Actual Budget. This happens on both local and server. Is there a fix for this or an option to easily re-order the transaction?
This happens when you import transactions for bank or from and account export/import from CSV. You end up with the incorrect running balance.

Would it be possible to fix this during the import process or an addition to be able to reorder the transaction. The only workaround is change the date to a different date and change the date back in the correct order of transaction.

Manually entered data with the correct order.
392200553-edd585ba-fc3f-4d43-be96-5dc580fce686

Another account with the exported data after it has been imported.
392201059-6bc75965-866c-48bb-9247-7347b9eabc3e

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

No response

Operating System

Windows 10

Originally created by @youaintnobody on GitHub (Dec 4, 2024). Original GitHub issue: https://github.com/actualbudget/actual/issues/3928 ### Verified issue does not already exist? - [X] I have searched and found no existing issue - [X] I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file) ### What happened? I'm running the following: Client version: v24.11.0 Server version: v24.11.0 I'm new to Actual Budget. This happens on both local and server. Is there a fix for this or an option to easily re-order the transaction? This happens when you import transactions for bank or from and account export/import from CSV. You end up with the incorrect running balance. Would it be possible to fix this during the import process or an addition to be able to reorder the transaction. The only workaround is change the date to a different date and change the date back in the correct order of transaction. Manually entered data with the correct order. ![392200553-edd585ba-fc3f-4d43-be96-5dc580fce686](https://github.com/user-attachments/assets/af003837-0f53-42e9-b198-ff0e8aebdf6d) Another account with the exported data after it has been imported. ![392201059-6bc75965-866c-48bb-9247-7347b9eabc3e](https://github.com/user-attachments/assets/26b59239-c365-4719-8cec-5696997cdb51) ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? _No response_ ### Operating System Windows 10
GiteaMirror added the bug label 2026-04-18 03:54:15 -05:00
GiteaMirror commented 2026-04-18 03:54:16 -05:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Dec 4, 2024):

You found the only work around. It think there are feature requests open for reordering already if you want to go vote for them.

<!-- gh-comment-id:2518414100 --> @youngcw commented on GitHub (Dec 4, 2024): You found the only work around. It think there are feature requests open for reordering already if you want to go vote for them.
GiteaMirror commented 2026-04-18 03:54:17 -05:00
Author
Owner
Copy Link

@tekumara commented on GitHub (Dec 23, 2024):

Also hit this. The sort_order is correct in the database but when the UI sorts by date it's not using sort_order.

It think there are feature requests open for reordering already if you want to go vote for them.

@youngcw I think this is a different issue from #1165 and feels more like a bug?

<!-- gh-comment-id:2558870508 --> @tekumara commented on GitHub (Dec 23, 2024): Also hit this. The `sort_order` is correct in the database but when the UI sorts by date it's not using `sort_order`. > It think there are feature requests open for reordering already if you want to go vote for them. @youngcw I think this is a different issue from #1165 and feels more like a bug?
GiteaMirror commented 2026-04-18 03:54:17 -05:00
Author
Owner
Copy Link

@travisw3 commented on GitHub (Dec 27, 2024):

I just ran into this also when I realized that the imported transactions only take a date and ignore the times in the transaction csv from my bank. Example CSV below (for some reason the bank ordered them this way - I have a bug report with them also)

"2024-10-01 04:18:03+00:00","REDACTED",400.00
"2024-09-25 13:22:11+00:00","REDACTED",-107.93
"2024-09-30 14:01:07+00:00","REDACTED",-6.00
"2024-09-30 17:41:45+00:00","REDACTED",-14.46
"2024-10-01 22:12:54+00:00","REDACTED",-25.38
"2024-10-01 13:52:23+00:00","REDACTED",-6.00
"2024-10-01 16:39:35+00:00","REDACTED",-17.09
"2024-10-02 18:13:45+00:00","REDACTED",-25.00
<!-- gh-comment-id:2563220295 --> @travisw3 commented on GitHub (Dec 27, 2024): I just ran into this also when I realized that the imported transactions only take a date and ignore the times in the transaction csv from my bank. Example CSV below (for some reason the bank ordered them this way - I have a bug report with them also) ``` "2024-10-01 04:18:03+00:00","REDACTED",400.00 "2024-09-25 13:22:11+00:00","REDACTED",-107.93 "2024-09-30 14:01:07+00:00","REDACTED",-6.00 "2024-09-30 17:41:45+00:00","REDACTED",-14.46 "2024-10-01 22:12:54+00:00","REDACTED",-25.38 "2024-10-01 13:52:23+00:00","REDACTED",-6.00 "2024-10-01 16:39:35+00:00","REDACTED",-17.09 "2024-10-02 18:13:45+00:00","REDACTED",-25.00 ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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
Mirrored from GitHub 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
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#27432
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?