Skip to main content
T
TNCL
May 16, 2020
Solved

pay vendors AFTER customer pays - tracking

  • May 16, 2020
  • 1 reply
  • 0 views

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!

Best answer by GlinetteC

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:

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.

1 reply

G
GlinetteCAnswer
May 16, 2020

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:

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.

T
TNCLAuthor
May 18, 2020

GlinetteC,

 

J
JonpriL
May 18, 2020

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!

Terms & ConditionsAccessibility statement