LwnmwnMan2 Posted February 9, 2012 Share Posted February 9, 2012 Anyone know of a place I can get an app or program that'll allow me to set up virtual "envelopes" for budget reasons?Right now I have all of the monthly payments on an excel sheet that I print off and cross off the list as the payments are made, but I'd like to have one that will show the total still outstanding for the month as the payments are crossed off.Yes, I know I could re-arrange the payments in the excel by their date, and then create another field to show what the total still due is as each one would be paid, but I cannot take that with me on the go.Anyone come across something like this?Or, can someone help me with the Excel sheet, making a new column that'll subtract the total paid without having to manually enter each row's total? Quote Link to comment Share on other sites More sharing options...
upnorth Posted February 9, 2012 Share Posted February 9, 2012 I am not totally clear what you want to do, but does this sound about right.Column A <amount due> Column B <amount paid> Column C <=column A - Column B> or =A1-B1That would be row 1 from that point forward you could have have Column A = Column COnce you get a few forumulas in you could just do an auto fill. Is that something like you are looking for? Quote Link to comment Share on other sites More sharing options...
LwnmwnMan2 Posted February 9, 2012 Author Share Posted February 9, 2012 Not exactly.I have everything listed row format.What I would like to do is have column J be a running total, so as the month goes along, as payments are being made, I can have a total of the outstanding bills.My payments are all listed in column H. Total for the month due is around $xxx.xx. I will put that total in J2, and then have running total in Column J that as I pay a bill, there will be a running total of the remaining payments due, from J5 down to J39. Quote Link to comment Share on other sites More sharing options...
upnorth Posted February 10, 2012 Share Posted February 10, 2012 I am still not quite clear how you have this setup, but if all your payments are in H and you want that total in J2 this formula in J2 would give you the total of payments made =SUM(H1:H9) or whatever cells you use in column H. I am not clear if H is payments owed or payments made.Anyway you could put up sample of what you have with dummy data? Quote Link to comment Share on other sites More sharing options...
LwnmwnMan2 Posted February 10, 2012 Author Share Posted February 10, 2012 I ended up doing it manually.For example I put my monthly total due on day 1 at $9,500 for example, J4.Then J5 said =J4-H3, J6 said =J5-H37 or whichever block in column H would be the one to be paid in daily order.I know it's confusing, but it worked for me.I don't really need a record of when they were paid, I just wanted a running total of the amount that the total bills were still due as I went through the month. I could then compare that with the bank account(s) and receivables and make sure I was still quite solvent. Quote Link to comment Share on other sites More sharing options...
upnorth Posted February 10, 2012 Share Posted February 10, 2012 Not everyone does things the same way. Just be sure to save a blank of your sheet so you don't have to recreate the wheel every time you start new. Quote Link to comment Share on other sites More sharing options...
delcecchi Posted February 11, 2012 Share Posted February 11, 2012 cant you use intuit or ms money or maybe quickbooks? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now ↓↓↓ or ask your question and then register. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.