Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 2, 2019
Solved

I have several purchase orders with the same client, which i need to reference on an invoice. Is there a field so I can track how much has been billed against each?

  • July 2, 2019
  • 1 reply
  • 4 views
These are professional services items which are fulfilled over a number of months (some over years). It would be useful to use Quickbooks to keep track of them, rather than a falable spreadsheet.
Best answer by

Thanks for your time today, @alex41,

 

I can share some information on how to track how much you bill your customers in QuickBooks Online.

 

When you bill a customer, you can assign a memo on the Message on invoice section of the invoice. This way, when you run a customer report, you can track which transactions are billable. Check out this snapshot:

 

 

Once you assign the memo, you can customise a Sales by Customer Detail report to view billable sales transactions. Here's how:

 

  1. Go to the Reports menu.
  2. Select Sales by Customer Detail.
  3. Click the Customise button.
  4. In the Rows/Columns section, click the Change columns link.
  5. Mark the Client/Supplier Message box.
  6. Hit Run report.

Here's how the report looks like:

 

 

That should do it. Please let me know if you have other questions. I'll be around to help whenever you need a hand. Have a nice day!

 

 

 

1 reply

Answer
July 3, 2019

Thanks for your time today, @alex41,

 

I can share some information on how to track how much you bill your customers in QuickBooks Online.

 

When you bill a customer, you can assign a memo on the Message on invoice section of the invoice. This way, when you run a customer report, you can track which transactions are billable. Check out this snapshot:

 

 

Once you assign the memo, you can customise a Sales by Customer Detail report to view billable sales transactions. Here's how:

 

  1. Go to the Reports menu.
  2. Select Sales by Customer Detail.
  3. Click the Customise button.
  4. In the Rows/Columns section, click the Change columns link.
  5. Mark the Client/Supplier Message box.
  6. Hit Run report.

Here's how the report looks like:

 

 

That should do it. Please let me know if you have other questions. I'll be around to help whenever you need a hand. Have a nice day!

 

 

 

alex41Author
July 4, 2019

Thank you that's very useful.

I think I am going to try setting up a custom field specifically for purchase order numbers and then I should be able to run a report on that field, the problem with using the notes section Is that I already use it for descriptions as well as the PO numbers. I tried to search the PO numbers that are already within this field, however Quickbooks does not seem to be able to recognise them as part of that field....

I'll see what work around I can come up with.

 

Thanks again.

alex41Author
July 4, 2019

Huzzah that worked a treat. I now have a discrete field that is labelled as Purchase order reference that I can search against.