Can LiveFlow import a P&L by Customer from QuickBooks?
Yes! LiveFlow can easily pull in a P&L by Customer.
There are two ways you can do it!
1 - P&L by Customer with a column for each customer
This is how the report looks like
![Can LiveFlow import a P&L](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/62ffc9985a6d509916a3c5ea_Screenshot%202022-08-19%20at%2018.32.58.png)
How to create a P&L by Customer with a column for each customer?
- Open LiveFlow
- Go to Create Report
- Select a Profit & Loss report
- Choose a date-range
- Set Display columns by to be by Customer
![Can LiveFlow import a P&L by](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/62ffcaf17a292e2dddbddf7b_Screenshot%202022-08-19%20at%2018.37.56.png)
2 - P&L by Customer filtered by each customer
![Can LiveFlow import a P&L](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/62ffcc3e8c1eaf3676fab009_Screenshot%202022-08-19%20at%2018.45.00.png)
How to import a P&L by Customer filtered by each customer?
- Open LiveFlow
- Go to Create Report
- Select a Profit & Loss report
- Choose a date-range
- Set Display columns by to be by Month, Year, Quarter, or any other method you prefer
- Click on Show Filters
- Click on Filter by Customer/Project and select the Customer/Project to filter by
![Can LiveFlow import a P&L by](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/62ffcbaa53bbb8f2704e52b4_Screenshot%202022-08-19%20at%2018.37.29.png)
Turn your report into a live Project/Customer Profitability Dashboard with our free template
Check out the live Project/Customer Profitability Template
![Can LiveFlow import](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/62ffced4702025e464c9292f_Screenshot%202022-08-19%20at%2018.56.28.png)