Incorrect values in cost tracker

I am using the cost tracker to track clothing expenses.  The amounts 
reflected in tracker seem to capture only expenses, but not returns.  Hence 
the amounts are always off (we return a lot of stuff!).  In reports, I can 
select to include payments or expenses or both, but I don't see any options 
for the expense tracker.

Any ideas how to fix this?

0
Curtis (31)
4/24/2006 2:12:01 PM
money 28651 articles. 7 followers. Follow

0 Replies
331 Views

Similar Articles

[PageSpeed] 0

Reply:

Similar Artilces:

This forum does have value!
As year end approaches and I am considering upgrading to Money 2005, I found the message traffic extremely valuable. After this summers fiasco with the update to MSN Money locking us out of our local data file, I thought, or was hoping M$ would make an extra effort to make sure that Money 2005 was a significant improvement and without the assorted problems that I have found posted here. Some still unresolved. I have made my decision and I do not care how much work it is going to take me, bt I am going back to Quicken after giving Money a two year trial. This program is just not ready f...

Create a line graph of quanitity of values
Hi, I am terrible with excel so I really appreciate the suggestions, in advance!! I am using excel to create a graph showing the ages of my employees. I'd like to show the demographic.... maybe a bar graph? Probably putting the quantity of employees on the Y axis and the age ranges on the X axis. How do I go about this? Can I make this from a selection of just ages, or do I need to create a new table showing the information I want to graph? Thanks! You need to use an intermediate table. Charts only show values, they don't calculate values. But you have this great worksheet fu...

Use values instead of labels on X-axis in Area/Stacked Area Charts
When building a stacked area chart, independent of how the linked cells are formatted, the chart uses the x-axis values as simple text labels. Since my values are not equally spaced, this distorts the plot, and I have not found any method through the help menus to change this formatting. Any help would be greatly appreciated. This technique might give you some ideas: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Ryan" <Ryan@discussions.micr...

Sumproduct
Hi I am using the sumproduct formula below to pull information from one work sheet to another. However some of the values in the range ranking order E5:E38 are blank. The rest are 0% to 100%. I need to get my formula to return blank instead of Zero unless the value in col E actually is Zero. I have tried IF on it's own as well however I am not getting result I am looking for. Any help appreciated! Formula - =IF(ISBLANK(SUMPRODUCT(--('RANKING ORDER'!A$8:A$35=A8)*(--'RANKING ORDER'!E$8:E$35))),"",(SUMPRODUCT(--('RANKING ORDER'!A$8:A$35=A8)*(-...

Cards>>Fixed Assets should include Cost and Salvage Value
Cost, salvage value, depreciation method, and useful life are all basic information that should be on the main card for Fixed Assets. It's fine to have the flexibility to have alternatives for tax purposes in other Books. But there should be a complete redesign of Fixed Assets that allows for the basics to be easily "got to" on the main card with little trouble. As it is, it's a menu nightmare. It's trying to be all things to all people and succeeding at being a mess. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the sugge...

Net Gains/Losses on Investments Incorrect in Money PLus
I have the new Money Plus deluxe edition, and have noticed that in my investments, the Market Value - cost basis is not equalling the "net gain" column in my investment snapshot column, which I do not understand. It is not off by a little; in some cases it is by a lot. I do not own many stocks and funds but have no idea why this is off; t should be simple math. There were some dividends but that should just affect the cost basis of my stock, and in turn, that number would effect my gain or loss. Is anyone else noticing this problem? Am I looking at something wrong here or...

Loop through a Control to see its value
Hi! I have tried many many ways but I just can't get it to work so any ideas are welcomed. I have a Tests database that has a Form with a subform in it. I am trying to search for "Fail" value in a control named "PASS_FAIL" in the subform named "AMC_ResultsB" . If it finds the control value to be "Fail" then it should set the value of another control "OverAllPassFail" to "Fail" (this control is in the main form). This way I ensure that if any test results failed I can Flag the whole test header as Failed. Here is the code Ove...

Changing costing methods
Our auditors want us to change our cost method from average to FIFO perpetual. Other than using the utility to change each item, what other considerations are there? Is there documentation on this? Thank you...... There is no real documentation but here is what you need to do. MAKE A BACKUP FIRST!!!!!!!!!!!!!!!!!!! 1. Make sure your stock status by account number balances to GL. 2. Post all sales orders that can be posted and delete the rest. 3. Receive all the POs you can and invoice them. Delete the rest. 4. Use the utility (it will not change items on Sales Orders or POs 5. ...

Formula to extract number values only
Hi, I can't seem to remember how to use a formula to extract numbers only. For example, I would like to take a create a formula to pull only "3.5" for a cell that containts "Sum: 3.5"... In your example, you could use: =--(RIGHT(A2,3)) If your cells follow a pattern of: Text(space)number You can use: =--(RIGHT(A2,LEN(A2)-FIND(" ",A2))) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "April" wrote: > Hi, > I can't seem to remember how to use a formula to extract numbers onl...

Is an event triggered when a cell value changes?
I would like to run a sub when the value is several cells changes, independently. Is there an event triggered when this happens that I can use to initiate my procedure? Thank you much, Shar Hi Worksheet's Change event is triggered, whenever a change is made on sheet. -- (When sending e-mail, use address arvil@tarkon.ee) Arvi Laanemets "Sharon" <shar@newnetworld.net> wrote in message news:QuCzb.417382$Tr4.1196022@attbi_s03... > I would like to run a sub when the value is several cells changes, > independently. Is there an event triggered when this happens th...

using NZ() function to return ''0'' value when query is null
Hi folks, I have a form called tbldocinput that contains a subform countrack. The form countrack is behind a query also called countrack that will provide me with the MAX() of the value of a tracking number that I am trying to create and autogenerate. I want the user to input the data on the tbldocinput form which is essentially a data entry form. When the user clicks save, the countrack is requery as well as a unbound field on the form tbldocinput that is default to 0. If there is a value in the countrack form field dtrack, then I want to use that value to input in my tracking nu...

Multiple series with different x-values on one scatter plot
I'm trying to add a new series to a scatter plot in Excel, but the new series uses a different set of x-values. I want to plot it along the same axis as the other series, but Excel plots the first point at (1, #) and the second point at (2, #), etc., instead of actually reading in the x-value and putting it at that place on the plot. How can I change this so that it plots the point at the correct/actual x,y values? Hi, Let's say you have a chart with the first data series displayed. Now select the data (the x-values and y-values ) for the new data series and click the Copy to...

IE load incorrect dll in ActiveX package
Dear all, I have a problem with IE behavior when loading dll in ActiveX control. The scenario is 1. Open IE load a ActiveX control including a.ocx and a.dll 2. Change IE URL to load another ActiveX control including b.ocx and "a.dll" I find that when IE load 2nd ActiveX control, it will load b.ocx and OLD a.dll. If I open a new IE and load 2nd ActiveX, it will load correct a.dll. Is this correct IE behavior? Can I aviod it? Thanks, Justin Dont know the reason but it could be because it probably looks at what is currently loaded and doesnt bother to find it if the name/checksum ...

Turn On A UserForm If Any Values Changes Within A Named Range
Greetings, I have an entry sheet that calls up several UserForms to help enter in data. In redesigning this sheet, I realized that I don't know how to use an entry into a cell within a named range to trigger a UserForm to become visible. Right now, I have three Command Buttons (Button 1, Button 2 and Button 3). Button's 1 & 2 will make themselves not visible and make the CommandButton called "SAVE" visible - these work fine. It is Button 3 that needs the adjustment. At present, by pushing it, I go directly to the next step in the entry process. This is a mistake. ...

POP-SOP Link: PO invoice cost different than PO receipt
If we use the POP-SOP link, the PO is received and then the sales order is transferred to an invoice and posted. Later the PO invoice is entered at a higher unit cost. Shouldn't the COGS account be debited instead of the Inventory account for the cost difference? What valuation method are you using Elaine? Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www.gp2themax.blogspot.com FIFO but I'd like to know how it also works with Average Perpetual "Frank Hamelly, MCP-GP, MCT, MVP" wrote: > What valuation method are you using El...

fill cells with a value from two previous cells
Hi, I try to copy the letter value from column A and B to column C in the example below with a formula: A B C 1A A 2 I I 3... Thanks, FormulaChallenged Maybe this in Cell C1 and copy down........ =A1&B1 Vaya con Dios, Chuck, CABGx3 "FormulaChallenged" wrote: > Hi, > > I try to copy the letter value from column A and B to column C in the > example below with a formula: > > A B C > 1A A > 2 I I > 3... > > Thanks, > FormulaChallenged > > Assuming that there is a value in only column A or column B, ...

Inifinity value? URGENT!
I am trying to exclude a value which is being use for some of my formulas, using the solver. Is there anyway to add constraints such as putting the value to Infinity so it would be as good as excluding it? The value sets the maximum my amount can reach. Thanks!! -- aeiou ------------------------------------------------------------------------ aeiou's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25595 View this thread: http://www.excelforum.com/showthread.php?threadid=394967 aeiou <aeiou.1tluyx_1123772889.0061@excelforum-nospam.com> wrote in news:aei...

Counting with two criteria where one is between values
Hi I have a spreadsheet with details of client contacts. Column H - users enter "X" when client has had first appointment Column I - users enter time (in weeks) client has waited for the appointment I need to return how many clients waited 0-8 weeks, 9-13weeks and 13-18 weeks I can count how many waited <8 weeks using =SUM((H1:H5="X")*(I1:I5<=8)) How can I count with the first criteria being an X in column h and the second criteria being between the values of 9 and 13? Thanks very much to anyone who is able to help me, it is very much appreciate...

calcluating a value if the original value meets a condition
Hello, I'm very new to Access, and I'm having a headache trying to set up and run queries for the first time. I'm used to doing things in Excel and SPSS, and maybe having a hard time adjusting to how the things are done in Access. What I'm trying to do is this: I'm trying to set up an accounting database, where you enter the amount of money (from vouchers, etc.) that you spend. I have the "amount" field, and some of the values in the field may already have taxes added, some do not have it added yet (so need to have it added), and some are not taxed (so no ...

Conditional cell values
Does anyone know if it is possible to make the input conditions of cell dependent on the value/formula of/in another cell WITHOUT usin excel? something like the example: if (cell_a = pre_defined_value_a OR some_condition/formula_is_true/false) then (cell_b pre_defined_value_b OR some_condition/formula) otherwise (user_can_enter_a_value OR user_can_choose_from_drop_down_list) Thanks -- Message posted from http://www.ExcelForum.com ...

"Scaling of Decimal Value Resulted in data Truncation"
Our AS400 was recently upgraded to V5R2..and now some tables that poreviously imported with no problems are generating this error message. Does anyone know of this error message? Any help would be most appreciated. ...

copy sheets values
Hello everyone, i have a question; Is it possible to copy values (A2:Z500) from a sheet name "Data" in a worksheet name "BdData.xls" to an other worksheets but not in the same folder as the first, and in this worksheet name "BbData.xls" values would be in the sheets "Data". Thanks a lot for all your advices. Michael Yes. Open both files and use Edit|Copy (xl2003 menus) to copy the range. Go to the other worksheet in the other workbook and select the top left cell of the destination range. Then Edit|Paste (or Edit|Paste special|values). If ...

Lookup value, but between dates
I am needing some help on this situation. I have the data structured in this way: A B C Res ID Cost Activity Date 1 1234 $20 1/1/2010 2 1234 $25 1/20/2010 3 7432 $15 2/2/2010 4 2574 $45 10/1/2009 5 7432 $65 1/2/2010 It shows by resource (Col A), Hourly Cost (Col B), and Activity date (Col C). Then I have a second sheet, with this format: A B C Res ID Cost Effective Date 1 1234 $15 12/30/2009 2 1234 $18 1/18/2010 3 7432 $12 1/31/2010 4 2574 $43 9/29/2009 5 7432 $67 12/31/2009 Same format, but it shows the standard cost. Effective Date represe...

reference cell value from fixed column with variable row
template wizard wont let me select a form control (combo box) value to associate a field with but provides a reference cell value which gives me the row number in the other workbook of the value. how do i make a valid cell reference from this reference? i.e. col of referenced value is "A", row is variable depending on what value i pick in combo box. how do i make a reference out of "A" plus the value to equal "A5" ? (so that i can associate a field with it using the template wizard) -- bob z ...

need help creating formula based on cell value
Hello, Is it possible to create a formula using a cell value to create a formula. basically I have multiple sheets with the name as a month. I have one sheet that does my reporting. So Instead of having a to create a seperate formula in each cell to reference each month (ie. ='jan report'!$A$14, ='feb report'!$A$14, etc) I want to be able to do something like create a formula to reference a cell that would contain the month name. For example. A1 b1 Jan Feb a2 ="'" & A1 & " Report'!" & $A$14 b2 ="'...