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
Feb 19, 2022 2:50 PM UTC
Question

Project Expenses Not Accurately Reflecting the Total

My project costs are not adding up. When I export the transactions directly from my project, the total is different than what Quickbooks is reflecting. I am taking into account the income associated with each project and it's still not working. What am I missing?

 

Quickbooks Project 1 Profit: - $37,000

Excel Export Project 1 Profit: - $44,000

 

So naturally I cross referenced this with Project 2...and same thing.

 

Quickbooks Project 2 Profit: - $18,000

Excel Export Project 1 Profit: - $23,000

 

Is there a bug in the system? I'm pulling my hair trying to figure this out

 

14 replies

Level 8
Feb 19, 2022 6:55 PM UTC

Hi @34587064. We can run some troubleshooting to correct the costs.

 

Let's start by checking the project name if it is selected on each bill and expense created. It's one of the possible reasons why the transactions aren't showing on your project. Here's how:

 

  1. Find and open each bill and expense.
  2. On the Bill/Expense page, verify if the project is selected under the Customer/Project column. If nothing is selected, choose the appropriate one.
  3. Click Save and close.

 

However, if the issue persists, the browser may have a data issue. To verify, let's log in to your QuickBooks Online (QBO) account using a private browser. To do so, press this shortcut key on your keyboard:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P

 

Once logged in, go back and check if the bills and expenses are showing in the Cost section from the Project page. If this works, it means that you need to clear the browser's cache so the system can start fresh. If you get the same result while using a private browser, I recommend switching to other supported browsers to run QuickBooks Online (QBO).

 

You might also want to learn more about the Project feature in QBO. This article will provide some information on handling project transactions: Projects FAQ.

 

Please know that I'm just a reply away if you need any further assistance managing projects in QBO. Have a great weekend.

Feb 19, 2022 11:34 PM UTC

Thanks for your response!

 

The expenses that I'm exporting into excel are directly from the Project Expenses tab in the project itself. So they wouldn't be there if it wasn't tagged under that project. See the picture below, Costs = $37,155.81 but when I export it to excel....the true costs = $44,080

Level 9
Feb 20, 2022 3:07 AM UTC

Glad to have you back, Realneighbor.

 

Let me share additional information about this.
 

The cost shown on the Project page isn't the profit from the Excel. It is the percentage profit that is shown on the header.

 

You may also check if you've added the subcategory from the main category of the expense resulting in the amount being inaccurate. I've added a screenshot to see if this is the case.

 

I'm adding an article you can use that gives you a clearer picture of your profits from every project: Set up and create projects in QuickBooks Online.

 

Fill me in if you have further questions. I'm always around if you need any help.

Aug 9, 2022 2:15 AM UTC

I am not sure if this is the issue but as I am researching how to enter an expense that needs to be broken out into multiple projects people are reporting that the main Costs summary is wrong yet the Profit % is correct. The cost amount shows the entire invoice amount, not the amount allocated to the project. That would make each project's Costs show higher. 

 

Is it possible you allocated an expense across projects? 

 

This is the support item total I am seeing that on: 

"How can I split an existing bill to multiple projects? When I try, the entire bill shows as cost against each project i.e. 10k bill w/2k cost on 5 projects."

Feb 24, 2023 3:46 AM UTC

Today I have solved a problem that sounds very similar to this and the solution is not provided in this thread.

 

My problem:

- Overview - Project income reported as $3,000; Costs reported as $0.

- In transactions - Sales receipts and deposits total to $3,000; Bills total $1,600.  !!!!!!

 

What is happening:

- The items purchased in the bills were assets, not expenses.  Therefore, the Overview doesn't consider them to be costs!

 

Analysis:

- It is a little annoying that project tracking considers itself a profit and loss activity.  I am happy with this behaviour when it comes to classes, but not with projects.  However, for us at least, a project is something that has a budget and you want to be able to check where you are up to in that budget.  Costs to the budget should not be constrained to expenses.  It you buy equipment that will last past the end of the project you want it in the balance sheet but you don't want it to look like you haven't spent the money!!

 

Solution:

- This is tedious and reflects poorly.  For each purchase of an asset related to a project, you need three lines in the Bill:

 

Asset, can have project name: $x

Expense, with project name: $x

Same Expense, no project name: -$x

 

The first line is the transaction you actually set out to do.  It doesn't matter whether of not the project is mentioned.  Leaving it out means that it will only appear once in the transaction list, but the asset wont be associated with the project in the list of asset.

The second line is only there to have the desired affect on the Project calculations

The third is there to reverse the P&L impact of the second line.  The project is left off so that it doesn't reverse the impact of the second line in the Project Overview.

 

Garry

 

Mar 14, 2023 11:11 PM UTC

This is a big fault that the QB Projects report has. Your total is different because if a bill is split amongst two projects, QB is automatically just calculating the amount specified for that project, and adjusting it in the total costs which is great. HOWEVER, when you pull the transactions, it shows the BILL total; not just the PROJECT total. If you split a lot of bills you'll have to go back through manually and find which bills were split and then manually adjust your project report total (every time!). You may want to do two+ different invoice entries for bills that are split between multiple projects. I wish QB would fix this!