 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2005Where can I find some good Excel spreadsheet for managing my bank account
and tracking my daily expenses? I thought about downloading some applications for this purpose, but none of them satisfy me and they are not free, ;) Thank you you can design your own in spreadsheet something like this DATE my ch# DETAILS BANK CH NO. WITHDRAWAL DEPOSIT BALANCE 1-Jan-04 balance 120,876.17 1-Jan-04 SBI RELF BOND ECS 800.00 =H2+G3-F3 5-Jan-04 IDBI FLEXI BOND 9 ecs 11,050.00 =H3+G4-F4 05-Jan-04 ch uti mepus 35335 utibk 065820/19,12,.03 1,213.50 =H4+G5-F5 07-Jan-04 ch k gilt div citibk 014003/1 jan 04 97.05 =H5+G6-F6 07-Jan-04 643335 sbi card 1,176.00 =H6+G7-F7 07-Jan-04 643336 kmmf-k gilt 1,000.00 = H7+G8-F8 The last column is formula > and tracking my daily expenses? I thought about downloading some > applications for this > purpose, but none of them satisfy me and they are not free, ;) > > Thank you Sigh!@ I am sure there are excellent spreadsheets some people makes in order to keep their own bank account. I don't want to redo what has already been done. What I need is fairly simple, something that allows me to enter some daily expenses, salary, bills, my networth, balance, mortgage schedule, etc. Thanks. > you can design your own in spreadsheet something like this > [quoted text clipped - 21 lines] > > > > Thank you Have you looked at http://office.microsoft.com/en-us/templates/default.aspx  SignatureHTH RP (remove nothere from the email address if mailing direct) > Sigh!@ > [quoted text clipped - 33 lines] > > > > > > Thank you Personally I wouldn't even consider it for that. A copy of Quicken or Microsoft Money will do this perfectly for you. I don't think they are expensive to start with, but you can often find an older version in a PC World or on ebay etc. Just did a search on Quicken on ebay and found a 2005 copy for just $19.99. You can usually download statements from your bank and import them straight into it. Sooooooooo much better for this. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Sigh!@ > [quoted text clipped - 33 lines] > > > > > > Thank you Most new PCs nowadays are bundeld with MS Money and/or Quicken. Of course, my accountant wants me to use QuickBooks.... I think the OP left out a couple of the Excel newsgroups. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > Personally I wouldn't even consider it for that. A copy of Quicken or > Microsoft Money will do this perfectly for you. I don't think they are [quoted text clipped - 4 lines] > You can usually download statements from your bank and import them straight > into it. Sooooooooo much better for this. > I think the OP left out a couple of the Excel newsgroups. Are you sure??? I didn't realise there were so many.......... :-) SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Most new PCs nowadays are bundeld with MS Money and/or Quicken. Of > course, my accountant wants me to use QuickBooks.... [quoted text clipped - 17 lines] > > You can usually download statements from your bank and import them straight > > into it. Sooooooooo much better for this. Sure you could use Quicken or Money but they are a pain in the but to set up. To much work. I use an excel spreadsheet to balance my checkbook and it works fine. Simple and easy. Since it is one I did myself for my own use it does not contain a lot of bells a wistles like a commercial package would, but it works. I could email you the template if you want. You will need to modify it for your on use. Dennis > Most new PCs nowadays are bundeld with MS Money and/or Quicken. Of course, > my accountant wants me to use QuickBooks.... [quoted text clipped - 19 lines] >> straight >> into it. Sooooooooo much better for this. Sounds like more than a simple bank acct file. I'm sure one of us could be hired to make up something for you or you can get Quicken or Money for little or nothing with tax act or turbotax. SignatureDon Guillett SalesAid Software donaldb@281.com > Sigh!@ > [quoted text clipped - 33 lines] > > > > > > Thank you Hi I have one that I created to manage my checking account. Email me and I will send you a copy. HTH Ken |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.