[GH-ISSUE #525] [Feature] Support importing transactions over multiple accounts at once #41857

Closed
opened 2026-04-26 01:18:47 -05:00 by GiteaMirror · 7 comments
Owner

Originally created by @rich-howell on GitHub (Jan 22, 2023).
Original GitHub issue: https://github.com/actualbudget/actual/issues/525

Discussed in https://github.com/actualbudget/actual/discussions/158

Originally posted by winklevos August 6, 2022
In import UI select specific account or use a column of the data to define the related account

Originally created by @rich-howell on GitHub (Jan 22, 2023). Original GitHub issue: https://github.com/actualbudget/actual/issues/525 ### Discussed in https://github.com/actualbudget/actual/discussions/158 <div type='discussions-op-text'> <sup>Originally posted by **winklevos** August 6, 2022</sup> In import UI select specific account or use a column of the data to define the related account</div>
GiteaMirror added the needs votesfeature labels 2026-04-26 01:18:47 -05:00
Author
Owner

@MatissJanis commented on GitHub (Feb 10, 2023):

@winklevos could you please elaborate on your idea?

Thanks

<!-- gh-comment-id:1426222128 --> @MatissJanis commented on GitHub (Feb 10, 2023): @winklevos could you please elaborate on your idea? Thanks
Author
Owner

@lanmaster53 commented on GitHub (Feb 19, 2023):

I'll provide some context. When I export an OFX file from my bank, it includes transactions for 4 different accounts. When I import that OFX into YNAB or other budgeting software, they allow me to select which local account is associated with each account listed in the OFX file, then imports the transactions accordingly. When I try to import the same OFX in Actual, whichever account I am in when I import receives all of the transactions.

I think the OP was referring to a way to do this with CSV files by having all transactions in a single CSV file, with a column that indicates which account each transaction should be imported into. Same thing I'm after, but a different file type.

Does that help?

<!-- gh-comment-id:1436107672 --> @lanmaster53 commented on GitHub (Feb 19, 2023): I'll provide some context. When I export an OFX file from my bank, it includes transactions for 4 different accounts. When I import that OFX into YNAB or other budgeting software, they allow me to select which local account is associated with each account listed in the OFX file, then imports the transactions accordingly. When I try to import the same OFX in Actual, whichever account I am in when I import receives all of the transactions. I think the OP was referring to a way to do this with CSV files by having all transactions in a single CSV file, with a column that indicates which account each transaction should be imported into. Same thing I'm after, but a different file type. Does that help?
Author
Owner

@j-f1 commented on GitHub (Feb 19, 2023):

Can you share an example of one of these files (with any identifying details you’re not sharing redacted)? It will be a fairly significant undertaking to add an account field to the import dialog since the current import logic is fairly tightly designed around importing to a single transaction, but the underlying parser does seem to support pulling out the account name. Opened https://github.com/actualbudget/actual/pull/670 but I don’t plan on working on this too much more in the near future.

<!-- gh-comment-id:1436114793 --> @j-f1 commented on GitHub (Feb 19, 2023): Can you share an example of one of these files (with any identifying details you’re not sharing redacted)? It will be a fairly significant undertaking to add an account field to the import dialog since the current import logic is fairly tightly designed around importing to a single transaction, but the underlying parser does seem to support pulling out the account name. Opened https://github.com/actualbudget/actual/pull/670 but I don’t plan on working on this too much more in the near future.
Author
Owner

@lanmaster53 commented on GitHub (Feb 20, 2023):

Just a standard OFX file. You can find them on the internet, but see a simple one attached. I had to change the extension to txt for Github, but should be ofx.

sample.txt

<!-- gh-comment-id:1437287341 --> @lanmaster53 commented on GitHub (Feb 20, 2023): Just a standard OFX file. You can find them on the internet, but see a simple one attached. I had to change the extension to txt for Github, but should be ofx. [sample.txt](https://github.com/actualbudget/actual/files/10786197/sample.txt)
Author
Owner

@lanmaster53 commented on GitHub (Feb 20, 2023):

Also, this isn't nearly as urgent as the other issue I posted about transaction merging. I can make do with individual account importing, but I can't use Actual without manual transaction merging. Thanks for what you're doing. As a fellow open source developer, I know the thankless work you put in.

<!-- gh-comment-id:1437290262 --> @lanmaster53 commented on GitHub (Feb 20, 2023): Also, this isn't nearly as urgent as the other issue I posted about transaction merging. I can make do with individual account importing, but I can't use Actual without manual transaction merging. Thanks for what you're doing. As a fellow open source developer, I know the thankless work you put in.
Author
Owner

@github-actions[bot] commented on GitHub (May 1, 2023):

Thanks for sharing your idea!

This repository is now using lodash style issue management for enhancements. This means enhancement issues will now be closed instead of leaving them open. This doesn’t mean we don’t accept feature requests, though! We will consider implementing ones that receive many upvotes, and we welcome contributions for any feature requests marked as needing votes (just post a comment first so we can help you make a successful contribution).

The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+

Don’t forget to upvote the top comment with 👍!

<!-- gh-comment-id:1530130252 --> @github-actions[bot] commented on GitHub (May 1, 2023): :sparkles: Thanks for sharing your idea! :sparkles: This repository is now using lodash style issue management for enhancements. This means enhancement issues will now be closed instead of leaving them open. This doesn’t mean we don’t accept feature requests, though! We will consider implementing ones that receive many upvotes, and we welcome contributions for any feature requests marked as needing votes (just post a comment first so we can help you make a successful contribution). The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+ Don’t forget to upvote the top comment with 👍!
Author
Owner

@djcurley89 commented on GitHub (Feb 22, 2026):

Multiple Account Transaction Example - Piere.csv

Here's an example of a CSV with transactions from multiple accounts that I get from Piere. Would really love if this could be integrated into AB as a way of importing regularly.

<!-- gh-comment-id:3941647873 --> @djcurley89 commented on GitHub (Feb 22, 2026): [Multiple Account Transaction Example - Piere.csv](https://github.com/user-attachments/files/25472118/Multiple.Account.Transaction.Example.-.Piere.csv) Here's an example of a CSV with transactions from multiple accounts that I get from Piere. Would really love if this could be integrated into AB as a way of importing regularly.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#41857