🏆 Paycheck Deduction Transaction Generator

I’m not quite sure what’s going on, @jacob80. I just tried the install in one of my spreadsheets and it worked fine. My installed did show the yellow “Warning: Some formulas are trying to send and receive data from external parties.” message but ran through to the end, showing the success message.

It definitely looks like yours isn’t making it to the end (one of the install steps is to remove the “Copy of” prefix in the sheet name… and you’re also seeing that unspecific error message). I’m pretty sure the spreadsheet with id starting with 1A02VOC... is your spreadsheet (not the template master) so I’m not sure why it is failing to write.

I searched the logs for your spreadsheet id but the search turned up empty.

I’m sorry I don’t have a solution to offer you… but, again, the install worked on my test spreadsheet.

I have been using this for years. I am not sure what happened, but I am having issues. When I go to do the data override, then paste, it is not moving over the whole information. I copy and pasted into my transactions and then just manually added dates since it was not functioning appropriately. However, my monthly budget is not syncing now to show the paychecks that I pasted in. Here is what it looks like on the paycheck generator tab. I blacked out the values, but you can see it is only bringing over the 2 columns.

Hard to say what’s going on. I’m gonna guess it’s something to do with the formatting of the data in the first section (your paycheck information). Try choosing an older paycheck in the date override cell (AO5) and see if the correct data shows up for it. Not sure if it’s just a formatting thing, but my date override has a down arrow in it showing it’s a list, if that’s not working right, it could point to another issue going on. My date override is in AP5, so maybe a column got deleted and messed things up? Perhaps copying out all of your data, delete the sheet and then reinstall it clean to try again.

1 Like