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

[Bug]: New OFX Importer: Dates offset by 1 day #410

New Issue
Closed
opened 2026-02-28 19:03:01 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-02-28 19:03:01 -06:00
Owner
Copy Link

Originally created by @bverkron on GitHub (May 21, 2023).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

Got a warning after importing that that might be a problem importing the file. I think all the transaction amounts, memos, etc are fine but the dates are offset by 1 day. They are all a day behind what they're supposed to be.

What error did you receive?

Didn't screenshot it but it was a yellow error in the bottom right that linked me to this bug report and said there might be an import problem. Can try to recreate the error and capture more details later.

statement (6).qfx.zip

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Mac OSX

Originally created by @bverkron on GitHub (May 21, 2023). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? Got a warning after importing that that might be a problem importing the file. I think all the transaction amounts, memos, etc are fine but the dates are offset by 1 day. They are all a day behind what they're supposed to be. ### What error did you receive? Didn't screenshot it but it was a yellow error in the bottom right that linked me to this bug report and said there might be an import problem. Can try to recreate the error and capture more details later. [statement (6).qfx.zip](https://github.com/actualbudget/actual/files/11525221/statement.6.qfx.zip) ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Chrome ### Operating System Mac OSX
GiteaMirror added the bugtransaction import labels 2026-02-28 19:03:01 -06:00
GiteaMirror commented 2026-02-28 19:03:02 -06:00
Author
Owner
Copy Link

@j-f1 commented on GitHub (May 21, 2023):

fyi @sinistersnare

@j-f1 commented on GitHub (May 21, 2023): fyi @sinistersnare
GiteaMirror commented 2026-02-28 19:03:02 -06:00
Author
Owner
Copy Link

@bverkron commented on GitHub (Aug 25, 2023):

@sinistersnare @j-f1

This did not seem to solve my issue. Date imported from my bank account still shows as 1 day behind the actual date. Have tried qfx and also ofx and both have the same result. Here is a trimmed down and partially obfuscated sample of the ofx file I tried.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:TYPE1
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
 <SIGNONMSGSRSV1>
  <SONRS>
   <STATUS>
    <CODE>0
    <SEVERITY>INFO
    <MESSAGE>OK
   </STATUS>
   <DTSERVER>20230825104908[-7:PST]
   <LANGUAGE>ENG
  </SONRS>
 </SIGNONMSGSRSV1>
 <BANKMSGSRSV1>
  <STMTTRNRS>
   <TRNUID>169*****48887
   <STATUS>
    <CODE>0
    <SEVERITY>INFO
    <MESSAGE>OK
   </STATUS>
   <STMTRS>
    <CURDEF>CAD
    <BANKACCTFROM>
     <BANKID>13****00
     <BRANCHID>116
     <ACCTID>VF1c2*****11601
     <ACCTTYPE>CHECKING
    </BANKACCTFROM>
    <BANKTRANLIST>
     <DTSTART>20230725000000[-7:PST]
     <DTEND>20230825235959[-7:PST]
     <STMTTRN>
      <TRNTYPE>DEBIT
      <DTPOSTED>20230821000000[-7:PST]
      <TRNAMT>-120.00
      <FITID>692****062
      <NAME>Interac eTransfer Outgoing
      <MEMO>To: IKEA Alex drawers 
     </STMTTRN
    </BANKTRANLIST>
    <LEDGERBAL>
     <BALAMT>5358.26
     <DTASOF>20230825104909[-7:PST]
    </LEDGERBAL>
    <AVAILBAL>
     <BALAMT>****8.26
     <DTASOF>20230825104909[-7:PST]
    </AVAILBAL>
   </STMTRS>
  </STMTTRNRS>
 </BANKMSGSRSV1>
</OFX>
@bverkron commented on GitHub (Aug 25, 2023): @sinistersnare @j-f1 This did not seem to solve my issue. Date imported from my bank account still shows as 1 day behind the actual date. Have tried qfx and also ofx and both have the same result. Here is a trimmed down and partially obfuscated sample of the ofx file I tried. ``` OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:TYPE1 ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:NONE <OFX> <SIGNONMSGSRSV1> <SONRS> <STATUS> <CODE>0 <SEVERITY>INFO <MESSAGE>OK </STATUS> <DTSERVER>20230825104908[-7:PST] <LANGUAGE>ENG </SONRS> </SIGNONMSGSRSV1> <BANKMSGSRSV1> <STMTTRNRS> <TRNUID>169*****48887 <STATUS> <CODE>0 <SEVERITY>INFO <MESSAGE>OK </STATUS> <STMTRS> <CURDEF>CAD <BANKACCTFROM> <BANKID>13****00 <BRANCHID>116 <ACCTID>VF1c2*****11601 <ACCTTYPE>CHECKING </BANKACCTFROM> <BANKTRANLIST> <DTSTART>20230725000000[-7:PST] <DTEND>20230825235959[-7:PST] <STMTTRN> <TRNTYPE>DEBIT <DTPOSTED>20230821000000[-7:PST] <TRNAMT>-120.00 <FITID>692****062 <NAME>Interac eTransfer Outgoing <MEMO>To: IKEA Alex drawers </STMTTRN </BANKTRANLIST> <LEDGERBAL> <BALAMT>5358.26 <DTASOF>20230825104909[-7:PST] </LEDGERBAL> <AVAILBAL> <BALAMT>****8.26 <DTASOF>20230825104909[-7:PST] </AVAILBAL> </STMTRS> </STMTTRNRS> </BANKMSGSRSV1> </OFX> ```
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#410
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?