Does anyone know if there is a way to enter a formula in Quicken in a split transaction? I am tracking my sales tax expenses this year and I breakout every purchase into components - one of which is sales tax. The sales tax is fixed at 5% here (generally) and I want to automate the calucation of the sales tax component in the split window.
Ideally, the formula could reference the total amount of a transaction (such as a downloaded credit card transaction) and compute the actual item price by =TotalPrice/1.05 and enter this in Line 1 of the split window and compute the sales tax using =Total Price-TotalPrice/1.05 and enter this in Line 2 of the split window.
Does anyone know if this is possible - such things are so easy in spreadsheets it would be a very nice feature to add to Quicken.