 |
 | 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 / New Users / November 2006Keeping my cash expenses from subtracting the cash balance
I have Ecell 2003 and I have just started a Family budget. I have inputed everything and it is working fine,Till I input what I pay for in cash and it also subtracts from my cash balance. I do not want that, I want a clear picture of where I am spending my money, Not to alter something to make it add up to my checkbook. I woould apperciate any help. Thank you I'm certainly confused. When *I* spend cash, it makes *my* cash balance lower. Have you found a way to spend money that doesn't? If so, please elaborate.  SignatureJoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 >I have Ecell 2003 and I have just started a Family budget. I have inputed > everything and it is working fine,Till I input what I pay for in cash and [quoted text clipped - 6 lines] > apperciate > any help. Thank you When I go into Excell and input all my spending, I put in what I pay with a check or debit, Then I input what i spend in cash. I am trying to track all of my spending but I do not want the $20.00 I took out of the atm to subract again and again for what I pay in cash. Hope this makes sensse. SignatureMichael T. > I'm certainly confused. When *I* spend cash, it makes *my* cash balance > lower. Have you found a way to spend money that doesn't? If so, please [quoted text clipped - 10 lines] > > apperciate > > any help. Thank you Hi Michael. why not keep cash expenditure in a separate column, or even a separate worksheet so that items are not included in any formulae that are keeping track of your bank balance. Gerry > When I go into Excell and input all my spending, I put in what I pay with a > check or debit, Then I input what i spend in cash. I am trying to track all [quoted text clipped - 15 lines] >> > apperciate >> > any help. Thank you I will give it a try, Thank you. SignatureMichael T. > Hi Michael. why not keep cash expenditure in a separate column, or even a > separate worksheet so that items are not included in any formulae that are [quoted text clipped - 20 lines] > >> > apperciate > >> > any help. Thank you Michael, Not knowing how your personal budget sheet is laid out it is impossible to give a definitive answer Just experimenting with it I created a spreadsheet like: Column A - Date Column B - Reason for Transaction Column C - Cash Spent Column D - Cash Balance Column E - Cash Out (from Bank) Column F - Bank Out (Cheques Etc.) Column G - Bank In Column H - Bank Balance The Bank Balance column, Column H is altered by entries in Columns E, F & G but entries in Column C only causes the present Bank Balance to be copied down. Additionally entries in Column E, Cash Out, also cause Column D, the Cash Balance, to be updated and entries in Columns F & G cause the balance in Column D, Cash Balance, to be copied down. It does what I think you are asking for but personally I found it confusing although it was slightly less so when I colour coded the columns in groups. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > When I go into Excell and input all my spending, I put in what I pay with > a [quoted text clipped - 20 lines] >> > apperciate >> > any help. Thank you
|
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.