Dumb Question

I've found something I have no idea how to do in QB Prem. (2005 Acct. Ed).

Occasionally I leave customer/job empty on a bill I'm entering for any number of valid reasons. Normally its a very short-term issue as this company assigns all of its non-overhead expenses to jobs for accurate Job Cost reports.

I cannot find a way to get a report or listing that shows me all expenses not assigned to a customer/job. None of the reports have a column to add that lists the job. I could add it in as a filter as long as I select jobs but that still wouldn't show me the expenses paid that weren't assigned.

Has anyone found a way to locate unassigned-to-customer expenses?

Reply to
Tee
Loading thread data ...

I can think of a kludge way to do this: Run and export to Excel the two reports, "Open Purchase Orders" and "Open Purchase Orders by job." Sort each one by PO Number or Vendor, then look for the "missing" ones in the Job listing.

-- Tom Healy, CPA Boulder, CO Web:

formatting link

Reply to
Thomas Healy

We don't use POs but that was a great idea. Unless I'm missing something the ability to see all costs by job (including no job the way you see No Item show up on Job Cost Reports) and/or isolate costs not assigned to a job is a big one and shouldn't be lacking.

Reply to
Tee

Tara-What about using a "Misc" job to lump all those together? I don't use the Job Cost area of QB, so not real familiar what will work & what won't. HTH

Nancy

Reply to
N Owen

That is an excellent suggestion and one I'll immediately employ. Unfortunately I still can't figure out how to find costs (and 99% of them would have been recorded on the Items tab of a "bill") that were unassigned a customer/job.

Reply to
Tee

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.