Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
August 25, 2026
Question

P&L REPORT

  • August 25, 2026
  • 1 reply
  • 5 views

REGARDING P&L REPORT….WANT TO CREATE EXCEL REPORT WITH EXPENSE CATEGORIES DOWN LEFT SIDE WITH CLINICS(7) ACROSS TOP

 

EXAMPLE:

                                CLINIC #1              CLINIC #2           CLINIC #3              CLINIC #4          CLINIC #5      CLINIC #6         CLINIC #7

ADVERTISING

PAYROLL

CABLE

1 reply

QuickBooks Team
August 25, 2026

Use the Profit and Loss by Location report which displays expense categories as rows and each clinic as a column and export it to Excel. Note that each of the 7 clinics must first be set up as a Location in QuickBooks Online (available on QBO Plus or Advanced).

 

Here's how to get it done:

 

You need to turn on location tracking if it’s not yet enabled. Once done, set up your 7 clinics as Locations.

  1. Go to Settings :gear: , choose All Lists.
  2. Select Locations.
  3. Click New and add each clinic (Clinic #1 through Clinic #7).
  4. Assign Locations to Transactions (When entering expenses, invoices, or other transactions, select the appropriate clinic from the Location field.).
  5. Run the Profit and Loss by Location Report.
  6. Then Export to Excel.

 

If you have any additional questions, please don’t hesitate to reach out. We're always here to assist you.