Skip to main content
S
suzannek1
November 7, 2024
Question

Is there a way to pull a PNL that shows expenses but not money received applied to those expenses?

  • November 7, 2024
  • 2 replies
  • 0 views
We are trying to get an average monthly spend on expenses that our clients have reimbursed us for for all clients.  PNL's apply payments and zero out the expenses.  So that doesn't work.  

2 replies

Rainflurry
Rainflurry
November 7, 2024

@suzannek1 

 

Correct me if I'm not understanding this.  You incur expenses that you bill your clients for and then you assign the items on the customer invoice to the same expense account, thereby zeroing out the expense on your P&L?  Now, you want to see a list of all of those expenses?    

 

I assume you're using the billable expense option on the vendor bills?  If so, I think the best you can do is run a Transaction List with Splits report and add a column for Billable.  You would still need to total the billable expenses manually/in Excel.  Maybe someone else has a better idea and can chime in.   

    S
    suzannek1Author
    November 8, 2024

    Hello.  You are correct about what I am looking for.  However, I cannot use the billing expense option.  Too many expenses.  I need to group them and it doesn't work with the option.  Really annoying.  

     

    Currently I am working with Transaction by account. 

    Z
    ZarahHillarey_T
    November 7, 2024

    Thank you for sharing the details of your concern, @suzannek1. I'm here to share more information about the Profit and Loss in QuickBooks Online (QBO).

     

    Before we start, I'd like to clarify if you've applied or activated the billable when creating expenses? May I also ask for a screenshot wherein it shows zero on your expenses. Any additional information would be greatly appreciated.

    To give you a heads up, the expense account will show as zero if you linked the same expense account to your invoice items. To know how to get this posted to your expense account accurately, I recommend seeking help from your accountant.

     

    I'm sharing you this article to help you find the missing transactions in Profit and Loss report: Find the missing income and expense transactions in your Profit and Loss report.

     

    In addition, you can also customize reports in QBO to filter and easily show the specific accounts. 

    Please let me know if you have more question about pulling up a profit and loss that shows expenses. I'm always here to help.

    Rainflurry
    Rainflurry
    November 7, 2024

    @ZarahHillarey_T 

     

    "To give you a heads up, all expenses created that enables the billable option and paid by your clients will not be zero out on the record, instead the amount added will show the same on the Profit and Loss section."

     

    Yes, they will, if the invoice items are linked to the same expense accounts.  It would be great if you had a basic understanding of how QB works to be able to help your customers with...QB.  Not trying to be rude but if you have nothing to add or, worse, you give your customer bad information, you're just confusing your customer.    

    Terms & ConditionsAccessibility statement