github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-09 11:42:54 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

[Bug]: QIF File import doesn't parse date correctly, ends up in notes column #743

New Issue
Closed
opened 2026-02-28 19:17:12 -06:00 by GiteaMirror · 4 comments
GiteaMirror commented 2026-02-28 19:17:12 -06:00
Owner
Copy Link

Originally created by @KyleK1782 on GitHub (Nov 19, 2023).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

When importing, the date ends up in notes instead of date column!
Sample from the import file (snipped to remove private transactions)

!Type:Bank
M11/15/2023
T-7.49
N
PSQ *EQUATOR COFFEE BARRHAOttawa 
^
Screenshot 2023-11-19 at 1 46 09 AM

What error did you receive?

No error.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Mac OSX

Originally created by @KyleK1782 on GitHub (Nov 19, 2023). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? When importing, the date ends up in notes instead of date column! Sample from the import file (snipped to remove private transactions) ``` !Type:Bank M11/15/2023 T-7.49 N PSQ *EQUATOR COFFEE BARRHAOttawa ^ ``` <img width="804" alt="Screenshot 2023-11-19 at 1 46 09 AM" src="https://github.com/actualbudget/actual/assets/81052018/1eb4c672-bd46-4c82-96a5-ede7e8af6af7"> ### What error did you receive? No error. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Chrome ### Operating System Mac OSX
GiteaMirror added the bug label 2026-02-28 19:17:12 -06:00
GiteaMirror commented 2026-02-28 19:17:13 -06:00
Author
Owner
Copy Link

@joel-jeremy commented on GitHub (Nov 19, 2023):

Looks like your bank's export is generating a QIF which stores the date in the memo tag (as seen in this line M11/15/2023). That is unusual since the date must labeled with a D tag e.g. D11/15/2023. That is why Actual is (rightfully) setting it in the memo field.

@joel-jeremy commented on GitHub (Nov 19, 2023): Looks like your bank's export is generating a QIF which stores the date in the memo tag (as seen in this line `M11/15/2023`). That is unusual since the date must labeled with a `D` tag e.g. `D11/15/2023`. That is why Actual is (rightfully) setting it in the memo field.
GiteaMirror commented 2026-02-28 19:17:13 -06:00
Author
Owner
Copy Link

@KyleK1782 commented on GitHub (Nov 19, 2023):

Interesting okay, I’m not surprised. My bank supports many formats but isn’t great about labeling or including more information.

Would it be possible to include a way to switch the memo and date columns in the interface?

@KyleK1782 commented on GitHub (Nov 19, 2023): Interesting okay, I’m not surprised. My bank supports many formats but isn’t great about labeling or including more information. Would it be possible to include a way to switch the memo and date columns in the interface?
GiteaMirror commented 2026-02-28 19:17:13 -06:00
Author
Owner
Copy Link

@rolinge commented on GitHub (Nov 19, 2023):

I see you are using a Mac, you could send your data file through sed (stream editor) before importing, changing the first character from M to D on the appropriate lines...
Something like
(Open a terminal, navigate to the directory of your bank file)

cat yourfile.QIF | sed 's/^M/D/' > newfile.QIF .

Or, get your bank to export with the proper field identifiers. sed is easier.

@rolinge commented on GitHub (Nov 19, 2023): I see you are using a Mac, you could send your data file through sed (stream editor) before importing, changing the first character from M to D on the appropriate lines... Something like (Open a terminal, navigate to the directory of your bank file) cat yourfile.QIF | sed 's/^M/D/' > newfile.QIF . Or, get your bank to export with the proper field identifiers. sed is easier.
GiteaMirror commented 2026-02-28 19:17:14 -06:00
Author
Owner
Copy Link

@KyleK1782 commented on GitHub (Nov 20, 2023):

Thanks @rolinge the sed command seems to be the issue. I'll let my bank know they're not following the standard.

@KyleK1782 commented on GitHub (Nov 20, 2023): Thanks @rolinge the sed command seems to be the issue. I'll let my bank know they're not following the standard.
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
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#743
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?