cancel
Showing results for 
Search instead for 
Did you mean: 
Frequent Explorer **

Invoice created from billable Vendor Bill/Check

I have invoices created for customer jobs via Vendor Billable Checks/Bills and selecting the "billable" option. 

 

Later when I go to the jobs, how do I know which Vendor Check/Bill the invoice was created from?

 

Thank you!

Solved
Best answer 09-16-2019

Accepted Solutions
Highlighted
QuickBooks Team

Re: Invoice created from billable Vendor Bill/Check

Thanks for actively responding, @Isaiah58Financial. I understand how you feel today.

 

I appreciate your ideas of wanting this functionality wherein a link is available in the invoice that lets you associate it to the billable vendor bill/check.

 

I'm personally taking note of your request and will pass it along to our product engineers. In the meantime, you're on the right track in following the steps provided by my colleague @Mark_R

 

You can also visit our QuickBooks blogs to keep you in the loop as to what’s new and what’s coming in QuickBooks Desktop.

 

You're always welcome to message us again here in the Community. Know that you can always count on us at any time of the day. Take care. 

View solution in original post

6 Comments
Moderator

Re: Invoice created from billable Vendor Bill/Check

Hi Isaiah58Financial,

 

You can click on the Transaction Journal Report to see which bill the invoice is linked to. Here's how:

  1. Open the Invoice.
  2. Click on the Reports tab. 
  3. Click on Transaction Journal

This is how it looks like: 

Please note that you can only see the bill in this report if the Billable box is checked in the actual bill.

 

You can also customize this report to show other information. 

 

We are here to help if you have other report questions or anything else. 

Frequent Explorer **

Re: Invoice created from billable Vendor Bill/Check

hat doesn't seem to pull the Vendor name for me when I follow the steps provided.  

I've tried that already and both line items of the transaction journal point to the Client/Job.  I tried to print screen all the key parts for you to see - I redacted the name of my Client for privacy but left enough for you to see what I'm seeing.  The invoice is in the back left, the transaction journal is on top left, the initiating bill is on the right 

Any other suggestions?

BillInvoicePrintScreen.png

 

 

Frequent Explorer **

Re: Invoice created from billable Vendor Bill/Check

Hello again,

I was just relooking at your response and I can see that your 2 lines of the transaction report are the same as mine listing just the customer.  The one with "Vendor" under the name is a line item for sales tax with 0 amount.  We don't do sales tax in NH so we would never have that transaction.  Still looking for a way to tie back an invoice to the billable Vendor Bill/check  Thank you

QuickBooks Team

Re: Invoice created from billable Vendor Bill/Check

I appreciate you getting back to us, @Isaiah58Financial.

 

You can utilize the Memo field to tie an invoice to the billable vendor bill. Then, run the Custom Transactions Detail report to see which bill the invoice should be linked to. Let me guide you through the process.

 

The reason why the vendor's name doesn't show on the invoice Transaction Journal is that the report is specific for customer's transactions.

 

To proceed, when making a billable check or bill, you can add a memo that describes the two transactions. Here's how:

 

  1. In your Bill transaction, enter the necessary information.
  2. In the Memo field, enter a keyword that describes the transaction. (Example: Sample "123" - "123" will be your identifier.)
  3. Click Save & Close.

Once done, you can now create an invoice to the billable bill. Then, enter the same identifier to tie both transactions.

 

After which, you'll have to run and filter the Custom Transaction Detail report. Let me guide you how.

 

  1. Go to the Reports menu.
  2. Select Custom Reports.
  3. Choose Transaction Detail.
  4. On the report page, click Customize Report.
  5. Go to the Filters tab.
  6. In the Search field, enter Memo.
  7. In the Memo field, enter your identifier.
  8. Click OK.

Once done, you'll be able to see a billable check or bill transactions that tie to an invoice.

 

Also, with regards to the sales tax, it'll always show since the account you use has their sales tax. It will just show as 0 amount if the transactions aren't taxable.

 

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBDT Self-help
 
Feel free to visit us again if you have any other questions with QuickBooks. We're always here to help.

Frequent Explorer **

Re: Invoice created from billable Vendor Bill/Check

Thank you - I was doing that already BUT I had hoped that there was a real QB link that would be able to be used and not something I have to create on my own.  It is disappointing that there is obviously something in the QB system that knows that the invoice has been created or not but yet it can't figure out a way to find the link when you are in the invoice.

 

Thank you for weighing in.

Highlighted
QuickBooks Team

Re: Invoice created from billable Vendor Bill/Check

Thanks for actively responding, @Isaiah58Financial. I understand how you feel today.

 

I appreciate your ideas of wanting this functionality wherein a link is available in the invoice that lets you associate it to the billable vendor bill/check.

 

I'm personally taking note of your request and will pass it along to our product engineers. In the meantime, you're on the right track in following the steps provided by my colleague @Mark_R

 

You can also visit our QuickBooks blogs to keep you in the loop as to what’s new and what’s coming in QuickBooks Desktop.

 

You're always welcome to message us again here in the Community. Know that you can always count on us at any time of the day. Take care. 

View solution in original post

Need to get in touch?

Contact us