Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
F
FrustratedInIowa
March 14, 2020
Solved

Expense report

  • March 14, 2020
  • 2 replies
  • 0 views

Ok, I would like some advice regarding this profit and loss statement and why it is including items from invoiced items. Would that be because the invoice was paid? and also, all i really want or need, is a report by category or split as qbo calls it.  but just of everything that comes in or out of my bank accounts...thats all, easy peasy...but i cant find anything similar and i have been looking forever. 

Best answer by AileneA

Thank you for reaching out to the Community. It's my priority to help you sort this out, @FrustratedInIowa.  

 

Let me share some insight into profit and loss, it shows all the transactions type you have created, like Sales, Income, Invoices, Expenses, Taxes. This will determine if you gain or lose something. Thought, you can customize and filter if what transactions you wanted to show up in your Report.

 

Let me show you how: 

 

  1. On the left pane click Reports. 
  2. Type from the search bar and click the specific report. 
  3. Under Report period, modify the date. 
  4. Click the Customize.
  5. Under Rows/Columns, select the specific columns you want to show in your report. 
  6. Tap Run report once done. 

 

For the Report that only show in and out from your bank you can run TRANSACTION LIST WITH SPLITS and customize it under the filter, drop-down arrow under Transaction Type mark check and select the category that comes in and out of your bank (Example: Tick box the Check, Payment, Credit card, Credit, Bill Payment, Paycheck) This are the example of  transactions that coming in and out. Then click Run report to appear in the report.

 

For additional information on this, I recommend the following articles: 

 

 

Fill me in if you need anything else about Running report. I'll be more than happy to help you. Have a great day!

2 replies

A
AileneAModeratorAnswer
Moderator
March 14, 2020

Thank you for reaching out to the Community. It's my priority to help you sort this out, @FrustratedInIowa.  

 

Let me share some insight into profit and loss, it shows all the transactions type you have created, like Sales, Income, Invoices, Expenses, Taxes. This will determine if you gain or lose something. Thought, you can customize and filter if what transactions you wanted to show up in your Report.

 

Let me show you how: 

 

  1. On the left pane click Reports. 
  2. Type from the search bar and click the specific report. 
  3. Under Report period, modify the date. 
  4. Click the Customize.
  5. Under Rows/Columns, select the specific columns you want to show in your report. 
  6. Tap Run report once done. 

 

For the Report that only show in and out from your bank you can run TRANSACTION LIST WITH SPLITS and customize it under the filter, drop-down arrow under Transaction Type mark check and select the category that comes in and out of your bank (Example: Tick box the Check, Payment, Credit card, Credit, Bill Payment, Paycheck) This are the example of  transactions that coming in and out. Then click Run report to appear in the report.

 

For additional information on this, I recommend the following articles: 

 

 

Fill me in if you need anything else about Running report. I'll be more than happy to help you. Have a great day!

F
FrustratedInIowaAuthor
March 16, 2020

thank you for your response as it is helpful, however, i would like that report to total the expenses by transaction category...or a similar report

that is where i think i am having the issue, is that I just want to know each individual 'schedule c' category totals. those are the numbers that would come out of the check books...as i am trying to get this stuff in to my attorney to get these income taxes done. tia

Morgan_B
Morgan_BQuickBooks Team
QuickBooks Team
March 16, 2020

Thanks for that additional info, FrustratedInIowa.

 

In this instance, you may want to try the Transaction Detail by Account report. Once you've accessed this report, you could then customize it to only show the Schedule C category. 

 

If you're still unable to see the exact data you need on the report, please let me know and I'd be glad to submit feedback on your behalf.

Rustler
Rustler
Level 15
March 15, 2020

@FrustratedInIowa 

 

Items control the account that is posted to, so if an item is posting to an expense account and not an income account then edit the item and select the correct account under sales.

You don't run reports on the bank account for the P&L. When you pay an expense, more than one expense in a payment, the register shows split. All that means is that more than one account was posted to. You can edit the payment to see what accounts you used, or in the P&L the expense account will show the total. If you click on the P&L expense or income account total you get a detailed report.

Reports are either accrual based or cash based, that is your choice. Accounting is done in the accrual basis by default.
accrual - bills and sales count as expense and income as of the date you have on the transaction
cash - only paid bills and paid sales count as expense and income
on the P&L

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement