Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mburhansafi
Level 2

Customized Report Guidance

Hello,

im Stuck at customizing a custom report for my QuickBooks desktop enterprise version.

I run profit and loss report but i want to add a balance sheet item that is owner draw after the net profit is calculated so that i can get to know how much the owner has drawn for the month. therefore kindly guide on how to generate such customized report 

1 Comment 1
LeizylM
QuickBooks Team

Customized Report Guidance

Hello,  mburhansafi. Thank you for reaching out to the Community.

 

I'm here to assist you with queries about customizing profit and loss reports in QuickBooks Desktop (QBDT).

 

The option to add balance sheet items to a Profit and Loss (P&L) report is unavailable in QBDT. Since they serve different purposes. The P&L report focuses on income and expenses over a period, while the Balance Sheet shows the financial position at a specific date.

 

 As a workaround, we can run both reports and consolidate the data by exporting to Excel and combining them into a single file. 

 

Here's how you can run the report :

 

  1. Go to Reports > Company & Financial > Profit & Loss Standard/ Balance Sheet. 
  2. Click on Customize Report.
  3. In the Date tab, select the desired date range or enter a custom date range.
  4. Click OK to apply the changes and generate the report with the customized date range.

 

Once done, you can refer to this article for more details about exporting reports: Export reports as Excel workbooks in QuickBooks Desktop.

 

For future reference, here’s an article that will guide you on how to personalize and memorize the information on your report:

 

 

Keep your posts coming if you have questions about running reports in QBDT.  I'll be one post away if you need assistance. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us