github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-05-06 07:01:45 -05:00
Code Issues 1.5k Packages Projects Releases 54 Wiki Activity

[Bug]: Imported OFX incorrectly moving decimal in amounts by 4 places #1502

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

Originally created by @kevinmickey on GitHub (Oct 12, 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?

When I import an OFX file, I see all amounts in OFX file such as $123.45 that get imported in Actual as $1,234,500.00, so the decimal is being moved 4 extra places.

I am using v24.10.1, and the OFX file includes <?OFX OFXHEADER="200" VERSION="220" ...

The amounts were imported correctly (123.45) in Actual v24.7.0. I have tested importing the same OFX file, and see a difference in Actual's behavior, so I don't believe this is due to a change by the financial institution.

Let me know if I can provide additional information.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Mac OSX

Originally created by @kevinmickey on GitHub (Oct 12, 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? When I import an OFX file, I see all amounts in OFX file such as $123.45 that get imported in Actual as $1,234,500.00, so the decimal is being moved 4 extra places. I am using v24.10.1, and the OFX file includes <?OFX OFXHEADER="200" VERSION="220" ... The amounts were imported correctly (123.45) in Actual v24.7.0. I have tested importing the same OFX file, and see a difference in Actual's behavior, so I don't believe this is due to a change by the financial institution. Let me know if I can provide additional information. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox ### Operating System Mac OSX
GiteaMirror added the transaction importbug labels 2026-02-28 19:45:36 -06:00
GiteaMirror commented 2026-02-28 19:45:37 -06:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Oct 12, 2024):

Can you upload an example ofx file?

@youngcw commented on GitHub (Oct 12, 2024): Can you upload an example ofx file?
GiteaMirror commented 2026-02-28 19:45:37 -06:00
Author
Owner
Copy Link

@kevinmickey commented on GitHub (Oct 13, 2024):

Below is a test ofx file. I deleted some parts and anonymized amounts, but hopefully it should suffice. The amount 123.45 gets imported as 1,234,500, and the amount 12,345.67 gets imported as 123,456,700.

<?xml version="1.0" encoding="UTF-8" standalone="no"?><?OFX OFXHEADER="200" VERSION="220" SECURITY="NONE" OLDFILEUID="NONE" ?><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>SUCCESS</MESSAGE></STATUS><DTSERVER>20240831000000.000[-4:EDT]</DTSERVER><LANGUAGE>ENG</LANGUAGE><FI><ORG>finame.com</ORG><FID>9999</FID></FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>9876</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>SUCCESS</MESSAGE></STATUS><INVSTMTRS><DTASOF>20240831000000.000[-4:EDT]</DTASOF><CURDEF>USD</CURDEF><INVACCTFROM><BROKERID>finame.com</BROKERID><ACCTID>123</ACCTID></INVACCTFROM><INVTRANLIST><DTSTART>20240630000000.000[-4:EDT]</DTSTART><DTEND>20240730000000.000[-4:EDT]</DTEND><INVBANKTRAN> <STMTTRN><TRNTYPE>CASH</TRNTYPE><DTPOSTED>20240716000000.000[-4:EDT]</DTPOSTED><TRNAMT>-000000000012345.6700</TRNAMT><FITID>12345</FITID><NAME>TRANS A</NAME><MEMO>TRANS A</MEMO><CURRENCY><CURRATE>1.00</CURRATE><CURSYM>USD</CURSYM></CURRENCY> </STMTTRN><SUBACCTFUND>CASH</SUBACCTFUND> </INVBANKTRAN><INVBANKTRAN> <STMTTRN><TRNTYPE>CHECK</TRNTYPE><DTPOSTED>20240716000000.000[-4:EDT]</DTPOSTED><TRNAMT>-00000000000123.4500</TRNAMT><FITID>12345</FITID><CHECKNUM>0000000001</CHECKNUM><NAME>Check Paid #0000000001</NAME><MEMO>Check Paid #0000000001</MEMO><CURRENCY><CURRATE>1.00</CURRATE><CURSYM>USD</CURSYM></CURRENCY> </STMTTRN><SUBACCTFUND>CASH</SUBACCTFUND> </INVBANKTRAN></INVTRANLIST><INVPOSLIST></INVPOSLIST><INVBAL></INVBAL></INVSTMTRS></INVSTMTTRNRS></INVSTMTMSGSRSV1></OFX>

@kevinmickey commented on GitHub (Oct 13, 2024): Below is a test ofx file. I deleted some parts and anonymized amounts, but hopefully it should suffice. The amount 123.45 gets imported as 1,234,500, and the amount 12,345.67 gets imported as 123,456,700. `<?xml version="1.0" encoding="UTF-8" standalone="no"?><?OFX OFXHEADER="200" VERSION="220" SECURITY="NONE" OLDFILEUID="NONE" ?><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>SUCCESS</MESSAGE></STATUS><DTSERVER>20240831000000.000[-4:EDT]</DTSERVER><LANGUAGE>ENG</LANGUAGE><FI><ORG>finame.com</ORG><FID>9999</FID></FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>9876</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>SUCCESS</MESSAGE></STATUS><INVSTMTRS><DTASOF>20240831000000.000[-4:EDT]</DTASOF><CURDEF>USD</CURDEF><INVACCTFROM><BROKERID>finame.com</BROKERID><ACCTID>123</ACCTID></INVACCTFROM><INVTRANLIST><DTSTART>20240630000000.000[-4:EDT]</DTSTART><DTEND>20240730000000.000[-4:EDT]</DTEND><INVBANKTRAN> <STMTTRN><TRNTYPE>CASH</TRNTYPE><DTPOSTED>20240716000000.000[-4:EDT]</DTPOSTED><TRNAMT>-000000000012345.6700</TRNAMT><FITID>12345</FITID><NAME>TRANS A</NAME><MEMO>TRANS A</MEMO><CURRENCY><CURRATE>1.00</CURRATE><CURSYM>USD</CURSYM></CURRENCY> </STMTTRN><SUBACCTFUND>CASH</SUBACCTFUND> </INVBANKTRAN><INVBANKTRAN> <STMTTRN><TRNTYPE>CHECK</TRNTYPE><DTPOSTED>20240716000000.000[-4:EDT]</DTPOSTED><TRNAMT>-00000000000123.4500</TRNAMT><FITID>12345</FITID><CHECKNUM>0000000001</CHECKNUM><NAME>Check Paid #0000000001</NAME><MEMO>Check Paid #0000000001</MEMO><CURRENCY><CURRATE>1.00</CURRATE><CURSYM>USD</CURSYM></CURRENCY> </STMTTRN><SUBACCTFUND>CASH</SUBACCTFUND> </INVBANKTRAN></INVTRANLIST><INVPOSLIST></INVPOSLIST><INVBAL></INVBAL></INVSTMTRS></INVSTMTTRNRS></INVSTMTMSGSRSV1></OFX>`
GiteaMirror commented 2026-02-28 19:45:38 -06:00
Author
Owner
Copy Link

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

Can you try the test build in #3676 with one of your files? It worked with the example you gave me.

@youngcw commented on GitHub (Oct 15, 2024): Can you try the test build in #3676 with one of your files? It worked with the example you gave me.
GiteaMirror commented 2026-02-28 19:45:38 -06:00
Author
Owner
Copy Link

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

It looks good when I test thru the Netlify deploy preview link. Thank you so much for your speedy fix!!

@kevinmickey commented on GitHub (Oct 16, 2024): It looks good when I test thru the Netlify deploy preview link. Thank you so much for your speedy fix!!
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 transaction import
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#1502
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?