[Bug]: Imported CSV spending appears in other months #1505

New Issue

GiteaMirror · 2026-02-28T19:45:50-06:00

GiteaMirror commented

2026-02-28 19:45:50 -06:00

Originally created by @krumjahn on GitHub (Oct 14, 2024).

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 have imported a bunch of expenses using CSV from various sources. It works fine initially then all of a sudden the expenses start appearing in random months that are not related. I've only started and only imported all my expenses for september but expenses started appearing in march and April. Then when I click on it, it shows no record.

For example. I somehow have -$868.56 for transportation in March. I click on it and it shows no records.

This makes the software essentially unusable as the records are all over the place. I'm on the latest version of a self hosted actual budget.

Example of the CSV file I imported:
date,payee,notes,category,amount,currency 2024-09-28,NETFLIX.COM,,Subscription,-89.72,HKD 2024-09-27,AMAZON,,Purchase,-63.42,HKD 2024-09-22,Audible,,Purchase,-118.81,HKD

Where are you hosting Actual?

NAS

What browsers are you seeing the problem on?

Chrome

Operating System

Mac OSX

Originally created by @krumjahn on GitHub (Oct 14, 2024). ### 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 have imported a bunch of expenses using CSV from various sources. It works fine initially then all of a sudden the expenses start appearing in random months that are not related. I've only started and only imported all my expenses for september but expenses started appearing in march and April. Then when I click on it, it shows no record. For example. I somehow have -$868.56 for transportation in March. I click on it and it shows no records. <img width="1001" alt="Screenshot 2024-10-14 at 9 53 23 AM" src="https://github.com/user-attachments/assets/f8bf9c9a-1337-48dc-b2b8-78a5568452f2"> <img width="805" alt="Screenshot 2024-10-14 at 9 53 16 AM" src="https://github.com/user-attachments/assets/19eb05b1-1c64-4e6e-9a07-b8badc8e91b2"> This makes the software essentially unusable as the records are all over the place. I'm on the latest version of a self hosted actual budget. Example of the CSV file I imported: ` date,payee,notes,category,amount,currency 2024-09-28,NETFLIX.COM,,Subscription,-89.72,HKD 2024-09-27,AMAZON,,Purchase,-63.42,HKD 2024-09-22,Audible,,Purchase,-118.81,HKD ` ### Where are you hosting Actual? NAS ### What browsers are you seeing the problem on? Chrome ### Operating System Mac OSX

GiteaMirror added the needs info bug labels 2026-02-28 19:45:50 -06:00

GiteaMirror closed this issue

2026-02-28 19:45:51 -06:00

GiteaMirror commented

2026-02-28 19:45:51 -06:00

@MatissJanis commented on GitHub (Oct 15, 2024):

👋 Would you mind uploading a demo budget file showcasing the issue? Thanks

@MatissJanis commented on GitHub (Oct 15, 2024): 👋 Would you mind uploading a demo budget file showcasing the issue? Thanks

GiteaMirror commented

2026-02-28 19:45:52 -06:00

@krumjahn commented on GitHub (Oct 16, 2024):

I fixed it by clearing the cache!

@krumjahn commented on GitHub (Oct 16, 2024): I fixed it by clearing the cache!