mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-10 23:54:00 -05:00
[Feature] Conditional flip amount in CSV import #752
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#752
Reference in New Issue
Block a user
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?
Originally created by @kymckay on GitHub (Nov 22, 2023).
Verified feature request does not already exist?
💻
Pitch: what problem are you trying to solve?
See this sample from a set of downloaded credit card transactions:
The amount should only be flipped for rows where
debitCreditCodeis valuedDebit. It's no big problem in this simple case, but on a much larger file the user either needs to pre-process the CSV or post-process the amounts in Actual after import.Describe your ideal solution to this problem
Needs a bit of design thought, but perhaps a secondary checkbox is shown if "flip amount" is ticked. Checking the secondary box enables selection of a column + selection of a value from that column to flip the amount on a simple
ifcondition.Would probably want to consider whether there are possible more complex cases and whether those should be supported too. Overall this isn't an urgent need because the user can open the CSV in spreadsheet software and tweak it before import.
Teaching and learning
@github-actions[bot] commented on GitHub (Nov 22, 2023):
✨ Thanks for sharing your idea! ✨
This repository uses lodash style issue management for enhancements. That means enhancement issues are automatically closed. 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 👍!
@shall0pass commented on GitHub (Nov 22, 2023):
I don't know about your specific file, but the checkbox to "split amount into separate input/outflow columns" has corrected this for me in the past.
@kymckay commented on GitHub (Nov 22, 2023):
Sadly not suitable here. It seems some organisations (this is the second I've come across) only provide CSV statements with all values in a single positive column and a separate debit / credit flag column.
@youngcw commented on GitHub (Feb 8, 2024):
@kymckay I think this is doable now. Can you confirm?
@kymckay commented on GitHub (Feb 10, 2024):
@youngcw confirmed!