Jump to content
Kitty Hawk Kitty Hawk (New Member) New Member

OT:Balancing the checkbook

Lounge   (1,468 Views 38 Comments)
9,869 Visitors; 9 Posts
If you find this topic helpful leave a comment.

You are reading page 2 of OT:Balancing the checkbook. If you want to start from the beginning Go to First Page.

I admit, the PDA program is my lifesaver. It does the math so much better than I do.
The formula to use in a spreadsheet is pretty simple.

Say you have three column:

  • Debit = Column A
  • Credit = Column B
  • Balance = Column C

Now, the math is simple ::: Take value from previous row for Colum C, Add current row for column B and then subtract Column A from the total --- to give you current balance.

So for example: (rats, HTML coding is off)

___A _____B _____ C

1________$10____ $10

2 _$5 ___ $8_____ $13

3 _$10___ $25

(try to imagine the thing without the dashes LOL)

To find the balance for C3, the forumula would be (C2+B3)-A3

You can maintain your own spreadsheet using Excel at home :) if anyone wants, I'll send the Excel file template and you cans et it up for your own use..

Share this post


Link to post
Share on other sites

Thanks Roy! I didn't know Excel could do that!

I think half the attraction with the PDA Splash program is the cute lil icons that I can assign to transactions.

Share this post


Link to post
Share on other sites

Wow I was just trying to "balance" my checkbook!?

I don't own a computer; and even if I did - I wouldn't trust to have stuff online. I round each check up; check off each thing with my monthly statement; and run a false bottom (so I have little extra "funds" for college, IRA, Cottage, trip, and extra)....but right now I'm a bit over-extended because of college. It'll all balance out once I get my return when I pass the 3 courses I'm enrolled it tho. I try to not use out of the fund I have cause once I'm done I'm having a wonderful vacation somewhere! I always have 2 extra morgage payments saved over too; and once I save enough for a 3rd I pay an extra payment - plan for 2 to 3 extra payments a year!

Anyway it's maybe a strange system; but it works for me.

Share this post


Link to post
Share on other sites
Now, I have auto pay set up for all my bills. I use my credit card to buy everything so I can collect frequent flyer miles.

Oh I do that too! I'll have enough FFM's to go anywhere in the world this year! :) I alway pay the cards off every month too...No matter what!

And I put money in the IRA automatically and save off the top of the paycheck every month too.

Share this post


Link to post
Share on other sites
Wow I was just trying to "balance" my checkbook!?

I don't own a computer; and even if I did - I wouldn't trust to have stuff online. I round each check up; check off each thing with my monthly statement; and run a false bottom (so I have little extra "funds" for college, IRA, Cottage, trip, and extra)....but right now I'm a bit over-extended because of college. It'll all balance out once I get my return when I pass the 3 courses I'm enrolled it tho. I try to not use out of the fund I have cause once I'm done I'm having a wonderful vacation somewhere! I always have 2 extra morgage payments saved over too; and once I save enough for a 3rd I pay an extra payment - plan for 2 to 3 extra payments a year!

Anyway it's maybe a strange system; but it works for me.

I trust the online more than I trust myself. :)

I can't imagine anyone taking college courses these days without a computer. How do you do it???

Share this post


Link to post
Share on other sites
I have not balanced my checkbook for at least 10 years. I don't keep a register at all. I keep up with my balance daily on the internet. I use my Debit card religiously, and pay all of my bills online. I write maybe 6 checks per year. This makes my life sooo much easier!! Plus I don't have to purchase any stamps!

That's the approach I take. Although I'm not sure it's been 10 years since my credit union went online.

I always choose debit when out buying stuff because that shows up instantly. I can use my debit card at the gas station and immediately come home and check the balance and it's on there.

I've gone paperless with my phone bill and electric bills, don't even get a bill in the mail, just an email notice what the amount is and when it's going to be taken out of my account. My car insurance is taken out once a month on the same day automatically. When I had a car payment it came out automatically on the same day each month as well. (Paid for that in April!!!) My utilitity bill still comes by paper in snail mail, but I go to their website to pay it online. I do the same with my two credit cards.

I write 2 checks a month: to the guy who cuts my grass (weeds), and to the spouse to help pay the mortgage which comes out of his account on the same day monthly. I don't use the check register to write anything down manually at all. Haven't in years and never had a problem.

Share this post


Link to post
Share on other sites

My problem with using the debit card as a REAL debit card is that some places want to charge a fee. That's so not worth it.

I've also always hated carrying cash, so just carrying around a card is handy for me. It's nice now that more fast food places accept plastic :)

Share this post


Link to post
Share on other sites
.

I also have Splash Money on my PDA, which keeps a balance identical to my checkbook, so it double checks my math.

I admit, the PDA program is my lifesaver. It does the math so much better than I do.

I love my Splash Money. So much I use it instead of the paper trail. I like the auto feature where you can program your automatic payments to come out on a certain day. No hassels!!!

Share this post


Link to post
Share on other sites

I still use a register and compare it to my account online. I have a system that works well for me and have been doing it for years. I'd feel strange completely giving up the paper.

Share this post


Link to post
Share on other sites
I trust the online more than I trust myself. :)

I can't imagine anyone taking college courses these days without a computer. How do you do it???

Well...it has been a challenge...we do have some nice computer labs here at work. With the tests online I cannot access on free computers up at work; so that is my option for now. Of course I got an OK from my nurse manager to use a free computer before I ever started.

I'm thinking tho with these final courses I will have to get something...I just might go nuts otherwise. We can get Dels with the discount at work...which is substancial; and I was all set to do this a couple of months ago but kinda spent the money on something else.

Now I'm hearing there is software in which you just type in your paper and it all comes up in the correct apa format? HUMMMMMMMMMMM....boy I've been waisting loads of time the last few years.

Share this post


Link to post
Share on other sites

Now I'm hearing there is software in which you just type in your paper and it all comes up in the correct apa format? HUMMMMMMMMMMM....boy I've been waisting loads of time the last few years.

Yes - its wonderful!!

Share this post


Link to post
Share on other sites
Well...it has been a challenge...we do have some nice computer labs here at work. With the tests online I cannot access on free computers up at work; so that is my option for now. Of course I got an OK from my nurse manager to use a free computer before I ever started.

I'm thinking tho with these final courses I will have to get something...I just might go nuts otherwise. We can get Dels with the discount at work...which is substancial; and I was all set to do this a couple of months ago but kinda spent the money on something else.

Now I'm hearing there is software in which you just type in your paper and it all comes up in the correct apa format? HUMMMMMMMMMMM....boy I've been waisting loads of time the last few years.

If you're strapped for a lot of cash or you just want to try a computer (you might be better off with a laptop) for a little while and see how you like it, you might try a rental. You can buy (but they cost more unless you find a place that does a net-90 and pay the whole thing off before the 90 days are up and the interest kicks in). Or you can just rent it for a few months.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
×