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.
6023mann
Level 1

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

I just got done categorizing last year's transactions, and I'm showing a $37500 difference in the "Business Spending" listed at the top of the Transactions page and the Total Business Expenses in my yearly Expenses report. I didn't have anywhere near that amount in assets bought, so any ideas why the discrepancy?
5 Comments 5
Adrian_A
Moderator

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

Hi 6023mann,

 

Let's ensure that the transactions are categorized correctly to fix the discrepancy issue. 

 

Here's how:

 

  1. Click the Transactions tab.
  2. Locate the transactions.
  3. Select either Business or Personal.
  4. Click Save.

 

You may use your bank statement as a reference in categorizing transactions.

 

Moreover, you can check this article as your guide in reporting self-employed income and expenses: Schedule C and expense categories.

 

Keep me posted whenever you have concerns about categorizing bank transactions.

6023mann
Level 1

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

Thanks for the response, but that doesn't really address my situation. As described, I've categorized my transactions (as business and personal), but the end of year Expenses report doesn't include a number of Spending categories, like:

Apps/Software/web services
Apps/Software/web services (>$200)
Business Insurance
Business Licenses
Business Loan
Business Loan Interest
Car and truck
Commissions
Communication
Computers
Computers (>$200)
Contract labor
Copiers
Copiers (>$200)
Credit Card Interest
Credit Card Payment
Entertainment
Equipment rent and lease 
Federal Estimated Taxes
Federal Tax
Furniture
Furniture (>$200)
Gas and Fuel
Health Insurance Premium
HSA Contribution
Homeowner / Renter Insurance
 
 
Legal and professional services 
Listing Fees
 
Materials & Supplies
Meals
Meals with Clients
Memberships/Subscriptions
Mortgage & Mortgage (Home Office) & Interest
Office expenses
Other business expenses
Other Home Office expenses
Other Interest
Other Property Insurance
Other Taxes
Other Tools and Equipment
Other Tools and Equipment (>$200)
Other Vehicle Expenses
Parking And Tolls
Personal Deposit / Withdrawal
Phone
Phone (>$200)
Photo/Video Equipment
Photo/Video Equipment (>$200)
Printing
Property Tax & PT Home Office
Referral/Broker/Seller Fees
Rent and lease (business bldg/land) 
Rent and Lease (Home Office)
Repairs and maintenance
Repairs and maintenance (Home Office)
Sales Tax
Shipping Fees
State Estimated Taxes
State Tax
 
Transaction / Processing fees
Travel expenses
Uncategorized 
Uniforms
Utilities
Utilities (Home Office)
Vehicle Insurance
Vehicle Lease
Vehicle Loan
Vehicle Loan Interest
Vehicle Registration
Vehicle Repairs
Wash and Road services

 

 

So I'm trying to understand why this is the case?

JamaicaA
QuickBooks Team

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

I understand you've categorized transactions properly, @6023mann. Let's go over some information and steps to handle this matter.

 

Let's start by addressing the differences between the Business Spending at the top of the Transactions page and the Total Business Expenses in the report. The expenses on the Transactions page are based on your bank transactions, downloaded or manually entered. On the other hand, the Expenses section of the report sums up the total expenditures of your business alone. You'll want to review the period to get the correct comparison amounts.

 

The report should show the different categories you shared above. We can perform some troubleshooting steps to verify if this is the browser's issue. Use these keyboard shortcuts:

 

  • For Firefox, press Ctrl + Shift + P
  • For Chrome, press Ctrl + Shift + N
  • For Safari, hold down Command + Shift + N

 

If this works, clear the browser's cache to start with a clean slate. You can also use other supported browsers as alternatives.

 

Furthermore, please know that the ones you generated also affect the categories shown. Here's an article to learn how Schedule C categories appear on Expense Category, Profit & Loss, Tax Summary, and Tax Details report.

 

To stay on top of your taxes, check out this reference: QuickBooks Self-Employed Annual Tax Guide.

 

Feel free to leave a comment below and tag my name if you have additional questions about your reports. I'll be here to help you. Stay safe!

6023mann
Level 1

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

Thanks for the response Jamaica, but I'm afraid your suggestions didn't help. My Business Expenses (from the Business and personal expenses report) has the following categories:

 

Advertising
Car and truck
Commissions
Contract labor
Entertainment
Equipment rent and lease Insurance
Interest paid
Legal and professional services Loan principal
Materials & Supplies
Meals
Office expenses
Other business expenses
Rent and lease (business bldg/land) Repairs and maintenance
Taxes and licenses
Travel expenses
Utilities
Uncategorized

 

The categories listed on the Transactions page, under Business - Spending, include all those listed as missing above, along with Insurance, Interest Paid, Loan Principal, and Taxes and licenses being included on the Report, but not in the Transactions categories. Now, I can see those 4 categories summing up smaller categories, but then where are the rest of the Categories, like Computers or Photo/Video Equipment (<$200, non-assets). It just seems to me that the report should capture all categories, whether they're listed separately or combined (like in the Insurance and Interest examples). Also concerning is the totals not matching. My report says I've got $55k in Business Expenses, but when select Business - Spending, I get $95k. That's a huge difference! So, I'd love some insight on how to look at these totals. Thanks!

 

Kurt_M
Moderator

Why don't my yearly totals for business spending match up with my Total Business Expenses in my reports?

We appreciate you getting back here in the thread, @6023mann. We'll point you in the right direction to help you fix the discrepancies inside your QuickBooks Self-Employed (QBSE).

 

Before anything else, know that we can see the urgency of this matter and that this isn't the experience we want you to have when using the program. Since the issue persists even after performing some basic browser troubleshooting, we recommend contacting our Customer Care Team. This way, they can check your account in a secure environment and conduct further investigation to determine the root cause of the problem. We'll write down the steps to get you going:

 

  1. Go to Help (?) and select Contact Us.
  2. Note: If you’re using the QuickBooks Self-Employed app, tap the + button and select Ask QB Assistant.
  3. Enter “talk to a human”, then select Continue.
  4. Select which way you want to connect with us.
  • Have us call you - Get a call from a support expert.
  • Chat with us - Start a conversation with a support expert.

 

See this page for more details: Contact QuickBooks Self-Employed Support.

 

In addition, here's an article to give you insights about the new expense categories inside QBSE: Updates to expense categories in QuickBooks Self-Employed.

 

Please let us know if you need further assistance managing expenses or performing tasks inside the program. We'll make sure to be around to help you out again. Stay safe, and have a good one.

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

Need to get in touch?

Contact us