Skip to main content
S
SEM61
May 4, 2024
Question

reporting that ties the sales order to the invoice

  • May 4, 2024
  • 2 replies
  • 0 views

I want to run a single report that ties the sales order to the invoice. Then payment is applied against the invoice. I am trying to tie them all together, basically following the journey from the originating sales order to the invoice then to the payment. I currently run a transaction report by date range and select all three, sales orders, invoices and payments, but the links are never clear becuase the invoice is always higher than the sales order  becuase we include freight or lower if items are back ordered, and payments will not match the invoice is some cases because of storages or discounts, etc.. 

 

Help, is there a simple report that marries the three?

2 replies

J
JoanaC
May 4, 2024

I'll be glad to help you with your report, @SEM61.

 

I can share a report with you. We can use the transactions list by customer to show the three transactions you need. This report will show the sales order, invoices, and payment. However, this transaction list report includes transactions not associated with any specific invoice or payment.

 

Here's how to run the report: 

  1. Go to Reports.
  2. Select Customers and Receivable, and then Transaction list by customer.
  3. Click Customize, then go to Filters.
  4. Select Transaction type. 
  5. Select Dropdown, and select Multiple transactions types.
  6. Choose the transactions you want to show. 

 

To quickly find the payment or invoice associated with the transaction, double-click on the transaction. You can also export the report and combine it on the Excel file. 

 

If this report is not what you want, I recommend sending feedback to our Project Engineers. 

 

Follow these steps: 

  1. Go to Help.
  2. Click Send Feedback Online.

 

Moreover, let me share this article that helps you manage your reports: Customize customer, job, and sales reports in QuickBooks Desktop.

 

I'll be here if you still have questions about your transaction list report. Have a lovely day, and take care.

S
SEM61Author
May 4, 2024

This is the exact report we currently use but i am trying to tie the three together. Since we generate a invoice from the sales order they are tied somewhere within QB's, in fact our invoice includes the sales order. In addition, when we apply a payment, it goes against an invoice. So how do I link the three. Sales order # 123 was used to create invoice ABC and payment *&^ was applied against invoice ABC.

S
SheandL
May 4, 2024

We can link and combine your sales order, invoices, and payment. Let's export this report to Excel and customize it there, @SEM61. I can show you how.

 

If you want to link the three entries shown in the Transaction List by Customer report, you can do so even if they're connected or not. To accomplish this, we can transfer the report to Excel and personalize it according to your preferences. Let me guide you through the process step by step.

 

  1. Open your QuickBooks Desktop company file.
  2. Go to the Reports menu, then Customers & Receivables.
  3. Select Transaction List by Customer. 
  4. Click the Excel dropdown, and choose Create New Worksheet or Update Existing Worksheet.
  5. If a message appears and says your reports show too many columns, go to Advanced, then untick the Space between columns checkbox. Click OK.
  6. When you’re ready, select OK.

 

Afterward, you can now personalize and edit your report from there.

 

Read this article for reference: Export reports as Excel workbooks in QuickBooks Desktop.

 

Additionally, you can also modify your reports to your liking. Please check out this article for guidance: Customize reports in QuickBooks Desktop. 

 

I'll be here if you need help linking the transactions in one report. Be sure to reply to this one or post here in this forum if you have one. 

Terms & ConditionsAccessibility statement