Skip to main content
Plinkr
September 18, 2020
Question

Detailed Report - Invoices

  • September 18, 2020
  • 1 reply
  • 0 views

In my field of property management, a tenant invoice total could be derived of several items.  When performing month end reports for financial purposes, we need to provide total paid dollars PER ITEM.  I created my OWN Excel spreadsheet per property with all the items that pertain to that properties billing, but it's a lot of time consuming back 'n' forth from QB to excel filling in the item column blanks per tenant paid invoice.  Is there a way to print a "received" or "paid" dollars report that segregates the line items?  If it can't segregate per item and only break down the item information per tenant invoice, I can upload into excel and manipulate the rows/columns - because I also need to TOTAL each column. (ie: Base Rent dollars, vs. Operating Exp dollars, vs, RE Tax Reimbursement dollars, vs. Utility dollars, vs. Prior Year dollars, etc.), these are some of the items.  Any items that apply to said paid invoice should appear on this report for uploading into excel for me to manipulate.  Thanks so much for any help.

1 reply

September 18, 2020

Hi Plinkr,

 

Being able to quickly collect your information is paramount when running a business. QuickBooks Desktop makes it easy to pull reports to get the information you need. I'd be happy to go over this information with you.

 

At this time there is no one report that can pull all the information you are looking for. You can try pulling a sales by customer and sales by item report but you would need to export them to excel and manipulate them there. These reports can be found by going to: Reports>Sales. 

 

I suggest sending feedback to our developers to let them know this is a report you want added and the information you are looking to include. You can send feedback by going to: Help>Send Feedback Online>Product Suggestions.

 

Take care!