Jump to content
  • GUESTS

    If you want access to members only forums on HSO, you will gain access only when you Sign-in or Sign-Up .

    This box will disappear once you are signed in as a member. ?

Free "envelope" app? Or program?


Recommended Posts

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?

Link to comment
Share on other sites

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-B1

That would be row 1 from that point forward you could have have Column A = Column C

Once you get a few forumulas in you could just do an auto fill.

Is that something like you are looking for?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.