cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

pay vendors AFTER customer pays - tracking

We pay some of our vendors AFTER we get paid. Is there a way to track which invoices the customer paid go with which vendor bill, outside of keeping a spreadsheet, to be able to easily see what I can pay the vendor at the end of the month based on which invoices customers have paid? Does this make sense? I know there are many contractors that don't pay vendors until they get paid, so there must be a way. HELP me to get rid of this spreadsheet!

Solved
Best answer May 15, 2020

Best Answers
Highlighted
Moderator

pay vendors AFTER customer pays - tracking

Hi there, TNCL.

 

You got me here to help you sort this out. In QuickBooks Online, we can pull up the Transaction Detail by Account report and customize it to show the information you need. Please note to make sure that the customer's bill is marked as billable so the payment will show on the report which is associated with the vendor.

 

Here's how:

 

  1. Click the Reports tab on the left menu.
  2. Type in transaction in the search field and choose Transaction Detail by Account.
  3. Click the Customize button.
  4. Select the Report period.
  5. Click the Rows/Columns and in the Group by the drop-down arrow, choose Vendor.
  6. Click Change columns.
  7. Put a checkmark in Customer, Vendor, and A/R Paid boxes.
  8. Click Filter.
  9. Put a checkmark besides Customer and Vendor box.
  10. Click Run report.

Please see attached screenshots:

report.PNG

report2.PNG

You can learn more details about customizing report in this article: Customize reports in QuickBooks Online.

 

Using the steps above, you'll be able to track which invoices are paid and which bill each invoice matches. 

 

Feel free to leave a comment below if you have any other concerns.

View solution in original post

3 Comments 3
Highlighted
Moderator

pay vendors AFTER customer pays - tracking

Hi there, TNCL.

 

You got me here to help you sort this out. In QuickBooks Online, we can pull up the Transaction Detail by Account report and customize it to show the information you need. Please note to make sure that the customer's bill is marked as billable so the payment will show on the report which is associated with the vendor.

 

Here's how:

 

  1. Click the Reports tab on the left menu.
  2. Type in transaction in the search field and choose Transaction Detail by Account.
  3. Click the Customize button.
  4. Select the Report period.
  5. Click the Rows/Columns and in the Group by the drop-down arrow, choose Vendor.
  6. Click Change columns.
  7. Put a checkmark in Customer, Vendor, and A/R Paid boxes.
  8. Click Filter.
  9. Put a checkmark besides Customer and Vendor box.
  10. Click Run report.

Please see attached screenshots:

report.PNG

report2.PNG

You can learn more details about customizing report in this article: Customize reports in QuickBooks Online.

 

Using the steps above, you'll be able to track which invoices are paid and which bill each invoice matches. 

 

Feel free to leave a comment below if you have any other concerns.

View solution in original post

Highlighted
Level 1

pay vendors AFTER customer pays - tracking

GlinetteC,

 

Highlighted
Moderator

pay vendors AFTER customer pays - tracking

You're on the right track, @TNCL!

 

Click each line will show you the transaction each of the invoices or bill are linked to. You can also select Customers under Group by so you'll see only the billable invoices.

 

In addition, your invoices should look like this upon opening them. Then, click on the following hyperlink indicated with the number to view your bill.

Lastly, here's a few articles you can read for ideas about managing all your customers and vendors transaction: Income and Expenses for QuickBooks Online.

 

If you have any other questions, you can always leave them in the comments. Thanks!

Need to get in touch?

Contact us