3rd Try and No Response?

This is my 3rd post regarding this issue in the last 2 weeks without a response! Can someone please post a possible solution to my problem? The problem is as follows:

In order to track the job costs, I place a job name in the memo field. When I want to know what the costs of that job are, I perform a search on the memo field for the job name and click on the report button. Works great. All costs for that job are displayed and totaled at the bottom.

The problem begins when I try to use splits. If I write a check to a sub for more than one job (as I often do...), I use splits to assign the correct amounts to the correct job. However, when I try to track job costs via the method described above, the splits are *deducted* from the total rather than added.

So, what I need, is either a way to 'force' the splits to be added to the total rather than subtracted or a different method of tracking the "split" amounts. It has been suggested that perhaps using classes as a job name might work. Any opinions on that?

Any help is greatly appreciated. Writing a check to the same sub for each and every job would be quite tedious and use up a lot of checks as well.

Thanks, mxh

Reply to
mxh
Loading thread data ...

Forgot to mention: QB Basic 2005 & Windows XP Pro SP2.

Reply to
mxh

What version of QB are you using? I don't understand why you're putting the job name in the memo field and searching on it.

If you enter your bills correctly, particularly using Items vs Expenses, and assign the correct job to each line then you'll have no problems. Go to Reports>Jobs> and select any number of reports. I like Job Estimates vs. Actuals Detail (which requires that you create an estimate for the job with at least one line item and an amount, even if its $1) and Job Profitability Summary.

Reply to
scfundogs

Hello, Tara. Thanks for the response. I'm using 2005 Basic. I have a separate data base from which I keep customer data and receivables. That being the case, I use QB 2005 solely for bank accounts, credit cards and vendors. Also, I don't believe that job reports are available in Basic, which is why I'm unable to assign jobs to expenses other than by the memo field. Can you suggest some solution to cause the splits to be added to the total report or a simple alternative to tracking job costs?

Thanks again, mxh

Reply to
mxh

Unfortunately I'm unfamiliar with QB Basic and have no idea what kind of reporting it has so I'm unable to offer you alternative suggestions.

It sounds like job costing is important to you and if that's the case I'd have to ask if you've weighed the time vs cost of trying to get something out of QB Basic that doesn't seem to be there.

I'd think that your time in trying to find this solution and in attempting work-arounds is worth the cost to upgrade to QB Pro which does have job costing & reporting abilities that are very simple to use.

Reply to
scfundogs

Actually, it's not about the upgrade costs or usability, it's about the time and effort involved in transfering the data from the data base to QB. At some point in the future, I may decide to either transfer the data (doubtful, given the enormity of the task) or just start entering customers in QB as the need arises and build it up from there, but all I really need at this point is as way to add rather than subtract splits to the total on the find reports.

Thanks, mxh

Reply to
mxh

Could be your problem is so unique that you are the only one with the problem?

I'm not familiar with Basic, but in Pro and above you don't have a problem tracking job costing.

Reply to
Golden California Girls

Shit! He oughtta axe for his money back.

Reply to
GWB

If I'm correct in my thinking, the reason I can't assign jobs in QB Basic is because I don't use QB as a customer data base, and 'jobs' are tied to customer records. At any rate, I found the workaround I was looking for by assigning the job name as a class and performing my searches by 'Class' rather than by text typed in 'Memo'.

Thanks to you and Tara for your responses.

mxh

Reply to
mxh

Well if you are going to abuse the software and not use it's built in functions, why are you suprised when you are the only person who has your specific problem?

Reply to
Golden California Girls

Abuse? Because I have a solution that works better for me? Because I prefer to use the customer data base that I designed expressly for my business? On the contrary, I merely use what works best for my business. And, with this new workaround, I am able to increase the efficiency with which I do and have done business for the last 20 years. Your condescension is unwarranted, unhelpful and poorly reasoned.

I neither expressed nor implied surprise. I merely used a subject line that would grab attention this time around.

Thanks, mxh

Reply to
mxh

You should understand that the CA Girls are members of the SPCQB club. . . . . . . . . . . . . . . . . . . . . . . . . .

. . ..

THE SOCIETY TO PREVENT CRUELTY TO QUICKBOOKS.

Reply to
Allan Martin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.