github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-05-07 20:38:54 -05:00
Code Issues 1.6k Packages Projects Releases 55 Wiki Activity

[GH-ISSUE #6264] [Bug]: Bank of America transactions that have Zelle payments not able to parse csv #51785

New Issue
Closed
opened 2026-04-30 19:22:12 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2026-04-30 19:22:12 -05:00
Owner
Copy Link

Originally created by @enkur on GitHub (Nov 27, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/6264

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

Hi,
When trying to import the BofA transactions using csv the app is not able to parse the file and gives error on the Zelle notes section
"Error: Failed parsing: Invalid Closing Quote: got "$" at line 19 instead of delimiter, record delimiter, trimable character (if activated) or comment"

This is the line it is having issues with
11/05/2025,"Zelle payment to XXXX for "$200 from XXXX...give to Dad"; Conf# i57no9gd2","-200.00","2,943.44"

Abid

How can we reproduce the issue?

Export BofA transactions with Zelle transactions that have a note. Then try to import the CSV into Actual.

Where are you hosting Actual?

None

What browsers are you seeing the problem on?

No response

Operating System

Windows 11

Originally created by @enkur on GitHub (Nov 27, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/6264 ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? Hi, When trying to import the BofA transactions using csv the app is not able to parse the file and gives error on the Zelle notes section "Error: Failed parsing: Invalid Closing Quote: got "$" at line 19 instead of delimiter, record delimiter, trimable character (if activated) or comment" This is the line it is having issues with 11/05/2025,"Zelle payment to XXXX for "$200 from XXXX...give to Dad"; Conf# i57no9gd2","-200.00","2,943.44" Abid ### How can we reproduce the issue? Export BofA transactions with Zelle transactions that have a note. Then try to import the CSV into Actual. ### Where are you hosting Actual? None ### What browsers are you seeing the problem on? _No response_ ### Operating System Windows 11
GiteaMirror added the bug label 2026-04-30 19:22:12 -05:00
GiteaMirror commented 2026-04-30 19:22:16 -05:00
Author
Owner
Copy Link

@db-src commented on GitHub (Nov 28, 2025):

The bug is in their CSV, since a quoted field itself contains unescaped quotes, which is poorly formed and probably not able to be worked around (e.g. by only separating on quotes AND comma) by most parsers.

<!-- gh-comment-id:3588501986 --> @db-src commented on GitHub (Nov 28, 2025): The bug is in their CSV, since a quoted field itself contains unescaped quotes, which is poorly formed and probably not able to be worked around (e.g. by only separating on quotes AND comma) by most parsers.
GiteaMirror commented 2026-04-30 19:22:18 -05:00
Author
Owner
Copy Link

@matt-fidd commented on GitHub (Nov 29, 2025):

Hi, I'm closing this off for the reasons stated by @db-src above.

<!-- gh-comment-id:3590735801 --> @matt-fidd commented on GitHub (Nov 29, 2025): Hi, I'm closing this off for the reasons stated by @db-src above.
GiteaMirror commented 2026-04-30 19:22:20 -05:00
Author
Owner
Copy Link

@Gtt1229 commented on GitHub (Jan 3, 2026):

Hi, I'm closing this off for the reasons stated by @db-src above.

What DB said is incorrect though, the quotes are not unescaped:

"Zelle payment to XXXX for "$200 from XXXX...give to Dad"; Conf# i57no9gd2"

<!-- gh-comment-id:3707210013 --> @Gtt1229 commented on GitHub (Jan 3, 2026): > Hi, I'm closing this off for the reasons stated by [@db-src](https://github.com/db-src) above. What DB said is incorrect though, the quotes are not unescaped: "_Zelle payment to XXXX for **"$200 from XXXX...give to Dad"**; Conf# i57no9gd2_"
GiteaMirror commented 2026-04-30 19:22:22 -05:00
Author
Owner
Copy Link

@db-src commented on GitHub (Jan 3, 2026):

If they were escaped, they would look like \" instead of being solitary. What exactly, inside backticks, is in the raw data?

<!-- gh-comment-id:3707212133 --> @db-src commented on GitHub (Jan 3, 2026): If they were escaped, they would look like `\"` instead of being solitary. What exactly, inside backticks, is in the raw data?
GiteaMirror commented 2026-04-30 19:22:22 -05:00
Author
Owner
Copy Link

@Gtt1229 commented on GitHub (Jan 3, 2026):

If they were escaped, they would look like \" instead of being solitary. What exactly, inside backticks, is in the raw data?

Oh I see what you mean, I confused with open ended.

<!-- gh-comment-id:3707212791 --> @Gtt1229 commented on GitHub (Jan 3, 2026): > If they were escaped, they would look like `\"` instead of being solitary. What exactly, inside backticks, is in the raw data? Oh I see what you mean, I confused with open ended.
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#51785
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?