Rasa-LilaM
QuickBooks Team
QuickBooks Team
‎November 18, 2023 07:11 AM

Manage your account

Hello there, LCShepaprd.

 

Gaining an in-depth overview of your finances is more challenging when your projects don't sync in the Profit and Loss report. I'm here to help and share some alternate methods to get the information to show up in the statement. 

 

It appears that you're using the US version. Please keep in mind that Spreadsheet Sync is only available from the specified region. 

 

In regard to your concern, let's open the Project Profitability Summary to show the income, costs, and profit margins for each project. You can also run the Profit and Loss report and add the projects. 

 

To open the financial statement: 

 

  1. In QuickBooks Online (QBO), head to the Reports menu on the left panel and type Profit and Loss in the Search field.
  2. On the statement's page, click the Report period drop-down and choose the correct date range.
  3. Tap the Customize button to open the Customize report window.
  4. In the Rows/Columns section, choose Customers from the Columns drop-down.
  5. Press the Filter link and tick the Customer box to select the projects you wish to appear in the report. 
  6. Click the Run report button to apply the changes.
    I've included a screenshot on how the statement will look like:project.png

 

To build the Project Profitability Summary:

 

  1. In QuickBooks Online (QBO), head to the Reports menu on the left panel and Project Profitability Summary in the Search bar. 
  2. On the statement's page, click the Report period drop-down and set the date range.
  3. Click the Run report button to apply the changes.

 

Moreover, you can make use of the Customize feature to prioritize the specific aspects that are most relevant to your company. I understand that many users will find it beneficial to have an integrated report that presents the mentioned data. Ideas like this one will definitely enhance your working environment. I suggest sharing your feedback on this feature with our developers so they can incorporate it into upcoming releases.

 

Here's how:

 

  1. In your company, head to the Gear icon in the upper right and choose Feedback under Profile.
  2. Enter a brief description of your product suggestion in the field box.
  3. Click Next to submit.

 

 Stay up-to-date with the latest product developments and expert advice to help your business thrive by visiting the QuickBooks Blog. Need a one-stop solution to fine-tune your financial statements and establish budgets? These articles offer a comprehensive guide with step-by-step directions on how to manage labor costs for your project:

 

 

@LCShepaprd, if you have any other concerns or questions about projects or building reports, drop a comment below and tag my name. I'll make sure this is taken care of for you..Have a great rest of your day. 

Reply