Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 10-09-2009, 02:50 PM
jjnine77 jjnine77 is offline
Registered User
 
Join Date: Oct 2009
Location: MO
Posts: 2
Tie a client's invoice to a vendor's bill...

I'm new to the forum. Wondering if someone can help. We are kind of a middle man in this scenario.

Our sales dept is selling a bundle of goods that includes some goods from us and goods from a vendor of ours. Our vendor only gets paid when we receive the money but we have terms of 60-90 days. We are currently tracking this outside of QB and it is getting tedious. So, my question is, "is there an appropriate QB/accounting method to tie our customer's invoice to our vendor's bill?" I'd like to be able to pull an income report (cash basis) from the 1st of a given month to the 30/31st and pay the vendor based on this report.

I realize we can pull this report now and the check should be accurate but it doesn't allow me to drill down on specific questions about specific clients very easily. I'm thinking if I can find a way to link between the client invoices and vendor bills, that would help??????

Thanks,
jjnine77
Reply With Quote
  #2  
Old 10-10-2009, 06:12 AM
shazinoz shazinoz is offline
Registered User
 
Join Date: Oct 2005
Location: Ballajura, Western Australia
Posts: 931
Lightbulb

On each vendor's bill, select the customer in the "Customer:Job" column for each line. This will link them. If you want to transfer that bill's charges onto the customer's invoice, tick the checkbox in the "Billable?" column at the end.
When you invoice that particular customer, click on the "Add Time/Cost" button & select the appropriate tab(s) (depending on whether you've used the "Items" and/or "Expenses" tab on the vendor's bills). Tick the vendor lines displayed on the tab(s). You can choose to add the lines to the customer's invoice in detail as they appear, or as one summary line & also if you want to on-charge exactly as billed or apply a markup amount/percentage.

(Depending on what version of QB you have), once you "link" your vendor's charges with your customer's invoice, you will be able to generate a variety of "Job" reports, directly comparing your income from that cusomer, against how much the expense was that was charged to you by your supplier. If you have access to these reports, they'll be on the "Reports" dropdown menu under "Jobs, Time & Mileage."
__________________
Shaz Hughes (Dip)Fin ACQ NSW, AAT ABN MICB
Accredited Reckon Professional Partner
Registered BAS Agent
Bookkeeper / Tax Consultant
Accounted 4 Bookkeeping Services

Email: shazinoz@digisurf.com.au / shaz@accounted4bs.com
Web: www.accounted4bs.com
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Tags
invoices vendor bills

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 07:01 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.