I use the Split Transactions tool in Tiller Labs, but I keep seeing this Tiller Splitter Add-on pop up in the screenshot.
If I open it it’s just a blank pop up that says “Split Transaction” at the top.
Hey!
The “Split Transactions” tool in Tiller Money Labs is the currently supported implementation of this feature. Tiller Splitter was an add-on that delivered similar functionality, but we’ve decided to EOL the add-on in favor of rolling it in to Tiller Money Labs.
We intend to update the Tiller Splitter to explain that it’s been deprecated. Unfortunately, a recent minor snafu in deployment (my fault!) caused the behavior you’re seeing now and we just haven’t addressed it yet. 
I have tried to follow some of the Q&As on Splitter & Money Labs, particularly on permissions, but I am not a technical person so it has been rough going. (On the plus side, I learned a new acronym, EOL
Can I make sure I understand: if I want to be able to split my transactions (which I do, b/c otherwise Tiller Sheets is not very useful to me), I have to give permission that covers all of my spreadsheets, including “Organize and delete any of your spreadsheets” and “See and change the people you share spreadsheets with”?
This list of permissions alarms me. All I want is a quick tool to do one thing–split transactions. Is there any way to do that now without granting permission that covers all sheets? I don’t want the other functionality. I am the opposite of a power user of spreadsheets. I just want to do this simple but essential task. Am I stuck? Would it make sense to wait a little for future changes to how this works?
Thanks!
Hey @nvorsanger -
Sorry, I’m a software engineer so sometimes I get all jargon-y and acronym-y.
So yes, with the (here comes the jargon!) EOL-ing of the Splitter add-on, you would have to grant those very broad permissions to the Tiller Money Labs add-on to be able to access similar functionality. For a variety of reasons, the current product strategy is to integrate as much functionality into a small number of deliverables (add-ons). That has trade-offs to put it mildly involving performance, security, etc.
So yeah, the list of permissions alarms me, too, and I work here. 
The most concrete advice I can give for yourself and other users with your concerns is to be vocal about it in the community here.
-Brasten
OK, thanks @brasten, & I completely understand on the jargons & acronyms
I guess I am stuck with it then. It’s frustrating b/c I use only the tiniest fraction of Tiller’s capabilities (I really have no idea how to use spreadsheets) but splitting transactions is one of the few.
Nancy
1 Like
Hi. I have no idea where the best place to post is, but I am following Brasten’s advice to be vocal about the permissions issue. I continue to be uncomfortable granting the superbroad permissions that seem to be necessary if I want to split my transactions now that Splitter is gone. Do I have any recourse, other than deleting the original unsplit amounts & then manually re-entering each item separately? Is there any chance this will change in the not-too-distant future?
As I mentioned, I basically understand nothing about how to use spreadsheets and I have trouble following what appear to be workarounds or previous discussions about this. In any event, I did use Splitter and without it, Tiller is a lot less useful to me. I just cannot bring myself to grant all those permissions. Thanks.
1 Like
I’ve only used Tiller for a few weeks but before then I wrote some scripts to help me with my prior budget. One was a transaction splitter. You can write scripts for your own sheet (that only you access) by clicking on “Tools” and then “Script Editor”.
Below is the script you can use:
//Duplicates purchase to more easily adjust for multiple categories
function BreakUpPurchase() {
var spreadsheet = SpreadsheetApp.getActive();
var sheet = spreadsheet.getActiveSheet();
sheet.getRange(spreadsheet.getCurrentCell().getRow() + 1, 1, 1, sheet.getMaxColumns()).activate();
sheet = spreadsheet.getActiveSheet();
sheet.getRange(spreadsheet.getCurrentCell().getRow() - 1, 1, 101, sheet.getMaxColumns()).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
}
It will split a transaction by copying the line selected (and anything 101 lines below it) and pasting that selection to the row below. If in the Tiller sidebar you choose the option to override auto sort (so new transactions stay at the bottom) this could work for you. Feel free to change the “101” to whatever row size you need to ensure you’re capturing all transactions after the one you’re splitting.
You can add this function to your Sheet toolbar with the following script:
//Add custom menu for script functions
function onOpen() {
var user_interface = SpreadsheetApp.getUi();
user_interface.createMenu('Budget Tools')
.addItem('Break-Up Purchase', 'BreakUpPurchase')
.addToUi();
}
I called it “Break-Up Purchase”, but you can change the title to “Split Transaction”, etc.
When you run a script attached to your sheet for the first time Google will ask you to sign in to authorize the third party access (or something like that). Don’t be alarmed - you’re simply letting your script access your sheet - no one else will see your data but you.
1 Like