I want to make a home budget spreadsheet on excel and be able to download my transaction history from my bank. So far, I've been entering transactions by hand and that's gotten too tiresome. My bank offers transaction historys in the downloadable formats - *qif, *csv, quicken, and microsoft money. I want to be able to just download the transaction history and input them into excel budget spreadsheet with minimal hassle. Anybody know how? Thanks.
2007-03-10 02:33:59 · 4 answers · asked by unitedsways 1 in Business & Finance ➔ Personal Finance
Well, I created a budget worksheet in Excel. It's not quite as detailed as you're doing, though. It has amounts by month and year.
If you'd like a copy to use/try, just email me. I'm more than happy to send it to you!
2007-03-12 04:19:41 · answer #1 · answered by boo's mom 6 · 0⤊ 0⤋
There is no simple formula. IRS taxes, state & local taxes depend on you w-4 dependency claims.. See what is all to be deducted and look up each rate for ones particular circumstances. Most numbers are a percent of gross, which when deducted will yield the net pay.
2016-03-28 22:40:12 · answer #2 · answered by Anonymous · 0⤊ 0⤋
This web site has a home budget planning program for excel :
http://www.simpleplanning.net/Financial%20Calculators/BudgetPlanner.html
2007-03-10 02:49:28 · answer #3 · answered by The Count 7 · 1⤊ 0⤋
download as csv
excel will be able to open it
csv is comma separated values
when you try and open it with excel it will ask about the commas
it will work
2007-03-10 02:37:04 · answer #4 · answered by Molly R 3 · 0⤊ 0⤋