mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-15 22:54:03 -05:00
[GH-ISSUE #1166] [Feature] Automatically split sales tax, proportionally to split categories #114824
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#114824
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 @MattDemers on GitHub (Jun 22, 2023).
Original GitHub issue: https://github.com/actualbudget/actual/issues/1166
Verified feature request does not already exist?
💻
Pitch: what problem are you trying to solve?
When using the split transactions, I would like to be able to proportionally assign remaining post-tax amounts to categories.
For example:
Total amount, with tax: $100
Category 1: $60
Category 2: $30
Pre-Tax total: $90
Money left-over (tax): $10
I'd like to have it so that more of the remaining $10 (the tax) would be assigned to Category 1, then Category 2, because Category 1 is a larger proportion of the transaction. I'm unsure of whether it would be related to the proportion of the subtotal or the total, but my terrible math guesses that $6.5 of the remaining $10 would go to Category 1, and $3.5 would go to Category 2.
I searched GitHub for "proportional sales tax", "sales tax" and "split transactions tax" and found nothing that addressed this. Since Reddit is currently locked, I cannot search there. I've seen topics asking about clarity/bugs when it comes to calculations in-field, but I am unfamiliar about how to calculate these proportions myself.
I am using self-hosted Actual, using Docker.
Describe your ideal solution to this problem
With YNAB4 (Classic), having a remaining unassigned amount of a split transaction, and attempting to click off of the transaction, would give a popup asking what the user would like to do with the remaining amount. One of the options was "Assign proportionally to categories (Sales Tax)" which did the behavior described above.
That behavior, or a literal "Sales Tax Distribution" button, or a button that says "proportional distribute" would be best.
Teaching and learning
No response
@github-actions[bot] commented on GitHub (Jun 22, 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 👍!
@ToniCipriani commented on GitHub (May 1, 2024):
Was trying out the Distribute functionality and found it only does equal splits. Was looking for this. instead.
Basically it is re-implementing YNAB4's split transaction functionality, and like @MattDemers mentioned, it is good for splitting taxes, tips and even currency conversion.
@jkrehm commented on GitHub (Jul 1, 2024):
The lack of this feature is my biggest stumbling block to using Actual. A Walmart trip may include 5 different categories and having to do the math to proportionally distribute the taxes is prohibitively time consuming. I could swag the amounts, but I would much prefer the tool figure out for me at the press of a button.
@ToniCipriani commented on GitHub (Jul 1, 2024):
As a workaround right now, I just copy it as a mathematical formula, e.g. if I have a foreign transaction that is $10, but in my currency it's $13 when processed, I just take
*(13/10)and paste it and hit Enter to all the subcategory lines.Likewise if your tax rate is 5%, you can just paste
*(1+0.05)to all the lines.Mind you this only works on the desktop client, there's no freeform Excel-like entry on mobile.
But in your situation, I do it manually anyways even with YNAB, simply because some items are not taxed (e.g. grocery food items vs household cleaning stuff).
@MattDemers commented on GitHub (Jan 16, 2025):
For people looking for something to achieve this function, I've created a Google Sheet with formulas/instructions to get the same end result: proportional tax distribution for your big receipts (Costco, I'm looking at you...).
Google Sheet (Protected, but make a copy)
[edit]: I also took inspiration from above to make a little webapp that does this: TaxCalc
@mcalligator commented on GitHub (Apr 20, 2025):
A later, more generic form of this feature request is tracked at Automatically enter remaining amount in split #2872.
@Kerrick commented on GitHub (Dec 24, 2025):
I don't think that is the same feature, or a more generic form of the same feature. This is a request to ‘divide the remaining amount among all existing splits proportional to their amounts. This is not currently possible with any workflow; you have to pull out a separate calculator. That is a request to streamline the functionality of an existing button without needing a click.
@github-actions[bot] commented on GitHub (Apr 6, 2026):
🎉 This feature has been implemented in #7257 and will be released in the next version. Thanks for sharing your idea! 🎉
@schnps commented on GitHub (May 20, 2026):
Thank you @victle for doing this! It was my main hang up with adopting Actual.
Do we need to add a separate issue to request this feature be added to the PWA mobile view?