Unpaid Client Expenses Report (QB desktop)?

You can pull up the Unbilled Costs by Job report, BOM. This will show you the expenses that aren't billed/paid by the clients.

I'll guide you how:

1. Click Reports.
2. Go to Jobs, Time & Mileage.
3. Select Unbilled Costs by Job. 

You can also customize the report depending on the information you want to see. 

If there's anything else that you need to know, feel free to get back to this thread. 

Go to reports, then Job, Time & Mileage.  Select the report "unbilled costs by job".  This will show all the costs marked as billable the have not been pulled into an invoice. 

You can double click on the expense account then total by customer.  Customize the report to add the paid status field and select paid status and toggle to open.  The problem with this report is that if an invoice is only partially paid, the payment is applied proportionately to all line items on the invoice.   If you are using billing costs, a balance in your expense account would indicate that the cost was never billed.

You should consider using items for your reimbursable costs.  For instance, set up an item for postage. Costs that are related to customers and are reimbursable should not show up on your P&L statement.  There are an asset account that is usually called Work In Progress or Reimbursable Customer Costs. 

When you enter an expense or bill, you use the item tab and not the expense tab.  The customer name is included on the item line and marked billable.  When you invoice, you pull these costs into the invoice and this reduces the asset balance. 

You can then run a report on the items and customize the report by totaling by customer and paid status to find out what costs are still due.

BOM, I feel your frustration.... this should be an EASY report for Quickbooks but i found the exact solution for you.  I myself have the same issue, and for whatever reason people I explain this to, just like you did in your various posts, I guess dont understand the purpose of this report.  We need a report to show BILLS or INVOICES we have paid but have NOT BEEN REIMBURSED yet by a customer in the form of a bill they have been given or even not billed for yet - in the reports below you WILL NEED to bill the customers in order for this to work.  We simply want to know what we have spent on behalf of a customer and have not been paid back yet.  So, it would be nice to see a report from QB with all this built into 1 report already formatted.

To many of us this really should be called an "out of pocket report"

here are the reports you need.  I had to run 2 reports and combine an ACCRUAL report and a CASH BASIS report.  The cash basis report will show ONLY PAYMENTS YOU MADE against that customer.  The ACCRUAL report will shown all expenses billed.  By comparing the 2 and subtracting the cash payment amount from the accrual amount will give you the total, or the "out of pocket expenses" to this point until the customer pays you.  The 2 reports will list every invoice item so you can go down the list and compare.  It is easier to export to excel into 2 separate spreadsheets so you can sort by date.  *** please note my QB kept crashing right after each export so i had to keep reloading and starting the report process over again.  But at least the reports had been exported to excel by then.  I just had to remember which report i was using.  **** 2nd note.... in my case, as a contractor, i had an issue with a client trying to pay bills behind my back directly to vendors and subs.  I invoiced the customer, the customer wanted to pay direct and in 1 case was able to. So in my reports there was 1 invoice i had invoiced to the customer that had already been paid to that vendor/sub.  That amount was still in my reports below in the accrual report so i had to remove that amount or line from that report to get an accurate amount of payments i made to what was actually invoiced.

I am using QB Desktop Premier Contractor 2020.

Go to "Reports" tab and in the various report lines there should be an option in one of those sections for "Job Cost Detail", at least there is in the contractor edition.  Your industry version is probably similar.  You can also find this report by doing the following: in the ribbon at the top of QB, select "Reports" then select "Report Center". In the "Report Center" select the "Memorized" tab inside Report Center.  In the Memorized tab section I had the option for "Contractor" which you might have a different category for your version of QB, then in the Contractor list select "Job Cost Detail"

Run the report.  It will give more detail then you need.  1st step is to choose your time period in the drop down box.  I chose "all".  Then below that you will see Accrual or Cash.  Dont do this yet.  Right now you probably have other projects in the list.  You want to filter out only that 1 project.  My version to the right side of Accrual or Cash has a "hide filters" area. To the right of that shows the filters pre-populated by QB.  In the "Name" section click the blue link that says "all customers/jobs".  When you click on that it will bring up another box with the "name" category selected in the options box and to it's right will be another drop down box where you can then choose only that specific customer or project. Choose the specific customer you want then select OK.  The report will then run just that customer.  Now, and only now do you want to run BOTH ACCRUAL AND CASH BASIS reports.  after running each report, export each report to excel so you have copies to compare against.  The cash basis report will be what you are specifically asking for in your posts, all your expenses paid to this point and the accrual report will be everything you billed so far.  subtract the 2 and you will get how much you are "out of pocket" for that customer until they pay you.

BOM, I feel your frustration.... this should be an EASY report for Quickbooks but i found the exact solution for you.  I myself have the same issue, and for whatever reason people I explain this to, just like you did in your various posts, I guess dont understand the purpose of this report.  We need a report to show BILLS or INVOICES we have paid but have NOT BEEN REIMBURSED yet by a customer in the form of a bill they have been given or even not billed for yet - in the reports below you WILL NEED to bill the customers in order for this to work.  We simply want to know what we have spent on behalf of a customer and have not been paid back yet.  So, it would be nice to see a report from QB with all this built into 1 report already formatted.

To many of us this really should be called an "out of pocket report"

here are the reports you need.  I had to run 2 reports and combine an ACCRUAL report and a CASH BASIS report.  The cash basis report will show ONLY PAYMENTS YOU MADE against that customer.  The ACCRUAL report will shown all expenses billed.  By comparing the 2 and subtracting the cash payment amount from the accrual amount will give you the total, or the "out of pocket expenses" to this point until the customer pays you.  The 2 reports will list every invoice item so you can go down the list and compare.  It is easier to export to excel into 2 separate spreadsheets so you can sort by date.  *** please note my QB kept crashing right after each export so i had to keep reloading and starting the report process over again.  But at least the reports had been exported to excel by then.  I just had to remember which report i was using.  **** 2nd note.... in my case, as a contractor, i had an issue with a client trying to pay bills behind my back directly to vendors and subs.  I invoiced the customer, the customer wanted to pay direct and in 1 case was able to. So in my reports there was 1 invoice i had invoiced to the customer that had already been paid to that vendor/sub.  That amount was still in my reports below in the accrual report so i had to remove that amount or line from that report to get an accurate amount of payments i made to what was actually invoiced.

I am using QB Desktop Premier Contractor 2020.

Go to "Reports" tab and in the various report lines there should be an option in one of those sections for "Job Cost Detail", at least there is in the contractor edition.  Your industry version is probably similar.  You can also find this report by doing the following: in the ribbon at the top of QB, select "Reports" then select "Report Center". In the "Report Center" select the "Memorized" tab inside Report Center.  In the Memorized tab section I had the option for "Contractor" which you might have a different category for your version of QB, then in the Contractor list select "Job Cost Detail"

Run the report.  It will give more detail then you need.  1st step is to choose your time period in the drop down box.  I chose "all".  Then below that you will see Accrual or Cash.  Dont do this yet.  Right now you probably have other projects in the list.  You want to filter out only that 1 project.  My version to the right side of Accrual or Cash has a "hide filters" area. To the right of that shows the filters pre-populated by QB.  In the "Name" section click the blue link that says "all customers/jobs".  When you click on that it will bring up another box with the "name" category selected in the options box and to it's right will be another drop down box where you can then choose only that specific customer or project. Choose the specific customer you want then select OK.  The report will then run just that customer.  Now, and only now do you want to run BOTH ACCRUAL AND CASH BASIS reports.  after running each report, export each report to excel so you have copies to compare against.  The cash basis report will be what you are specifically asking for in your posts, all your expenses paid to this point and the accrual report will be everything you billed so far.  subtract the 2 and you will get how much you are "out of pocket" for that customer until they pay you.

Hello 

Is there a report that lists unbilled client expenses that were paid for and now I want to see if they have been billed to the client?