cancel
Showing results for 
Search instead for 
Did you mean: 
sweetjumbles
Level 2

Exclude from Profit & Loss/Tax Summary

I am using Self Employed.

I just relocated to a new state, and consequently am going to need to split profit/loss mid-year.

I created a Schedule C for 1/1-6/1/22 that I will use at tax time.  Now I need to for all intents and purposes "start fresh," so have excluded all transactions prior to 6/1.  Or so I thought.

They all still show up in my Profit and Loss Reports, which yes I know i can view in a custom date range, but the real problem is that the tax summary for Schedule C just shows for the whole year.  Is there any way to REALLY get rid of all excluded transactions from these reports so that I don't have to manually subtract Q1 and Q2 from Q3/Q4 at tax time?

5 Comments 5
jamespaul
Moderator

Exclude from Profit & Loss/Tax Summary

Hello, sweetjumbles.

 

Other than manually substracting the amounts from the quarters, I have another solution for you to split the data on the Tax summary report. 

 

We can categorize those transactions prior to June 1st as personal, so they won't be included on the Tax summary or the Profit and Loss report. Here's how to do it: 

 

  1. Go to the Transactions page.
  2. Set the date range prior to June 1st. 
  3. Set other filters if needed. 
  4. On the transactions list view, check those categorized records.
  5. After checking them, click the Mark as personal button to tag them as personal. 

 

personal0.PNG

 

Here are some screenshots that'll help you visualize the steps above: 

 

personal1.PNG

personal2.PNG

 

Though, we can also delete those transactions (by clicking on the Trash can icon after checking the transactions) from the Transactions page.

 

However, take note that deleting the transactions can't be undone. So if you want to keep records of those transactions, then categorizing them as Personal works best. 

 

If you'd like to know more about the Schedule C categories and how they appear on your reports, we can take a look at this article as our guide: Schedule C and expense categories in QuickBooks Self-Employed

 

Ready to tackle your estimated taxes in the future? We can bookmark this article in case you need help with them during tax time: Pay federal estimated quarterly taxes in QuickBooks Self-Employed

 

Do you have more questions about your Self-Employed records and the reports? Let me know the details and let's work them out. If you have any other concerns about the Self-Employed platform, add them to your reply. Always here to help. 

sweetjumbles
Level 2

Exclude from Profit & Loss/Tax Summary

Thanks for the interesting solution!  Items seem to change to personal, but then change back.  I wonder if my rules are messing with it....

 

Ultimately I discovered that I have to re-categorize each entry TWICE as personal.  It simply doesn't "stick" the first time around, but it's all good now.  Thanks again so much!

sweetjumbles
Level 2

Exclude from Profit & Loss/Tax Summary

I actually would have been more than happy to permanently delete them, but no such "trash can" icon appears on my page.  Am I missing a feature?

Candice C
QuickBooks Team

Exclude from Profit & Loss/Tax Summary

Good morning, @sweetjumbles

 

Thanks for coming back and adding that you're unable to see the trash can icon feature.

 

The reason why you may not see this option is because the transaction came from the bank. Moreover, the trash can icon only appears for transactions the were manually recorded. 

 

Since you don't have this action, I suggest excluding them to help you out. Here's how: 

 

  1. Go to the Transactions tab on the left-hand menu. 
  2. Locate the transaction and hit the Arrow to the left of the transaction to expand it. 
  3. Put a check in the Exclude this transaction box. 
  4. Tap Save

 

It's that easy! Review this guide on deleting and excluding transactions for more details. 

 

This should do the trick. If you have any other questions, don't hesitate to ask. Have a great day! 

sweetjumbles
Level 2

Exclude from Profit & Loss/Tax Summary

thank you for explaining that the trashcan is only available for manual entries.

 

While I did exclude them, they still showed up in tax and profit/loss reports.  I re-categorized them as personal in order to correct this, as mentioned as a solution above.  While I for some reason had to do this in batches, re-categorizing each entry twice in order for it to "stick," it seems to have worked now and the tax reports and profit/loss reports correctly show nothing prior to June.  The person who offered that suggestion was a lifesaver.


Fortunately this is a one-time issue and going forward each business year will be a normal calendar year in one location!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us