Expense report

FrustratedInIowa · ‎March 14, 2020

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.

AileneA · ‎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:

On the left pane click Reports.
Type from the search bar and click the specific report.
Under Report period, modify the date.
Click the Customize.
Under Rows/Columns, select the specific columns you want to show in your report.
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!

View solution in original post

MorganB · ‎March 16, 2020

Gotcha, FrustratedInIowa. I can show you how to access this report:

1. Click the Reports tab in the left navigation bar.

2. Enter Transaction Detail by Account in the search bar.

3. Choose the Customize button in the top right corner.

4. Select Filter to expand the options.

5. Check the Account (or Class) box and choose the correct account for the Schedule C items.

6. Click the green Run report button at the bottom of the panel.

I recommend checking out the following link that offers additional details on customizing reports in QuickBooks Online.

I'll be here if you have any other questions.

View solution in original post

AileneA · ‎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:

On the left pane click Reports.
Type from the search bar and click the specific report.
Under Report period, modify the date.
Click the Customize.
Under Rows/Columns, select the specific columns you want to show in your report.
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!

Rustler · ‎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

FrustratedInIowa · ‎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

MorganB · ‎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.

FrustratedInIowa · ‎March 16, 2020

but how? thats my issue...i know it can be done, but how? lol

MorganB · ‎March 16, 2020

Gotcha, FrustratedInIowa. I can show you how to access this report:

1. Click the Reports tab in the left navigation bar.

2. Enter Transaction Detail by Account in the search bar.

3. Choose the Customize button in the top right corner.

4. Select Filter to expand the options.

5. Check the Account (or Class) box and choose the correct account for the Schedule C items.

6. Click the green Run report button at the bottom of the panel.

I recommend checking out the following link that offers additional details on customizing reports in QuickBooks Online.

I'll be here if you have any other questions.

Topics

Training

Community

Resources

Expense report

Expense report

Expense report

Expense report

Expense report

Expense report

Expense report

Expense report

Expense report

Need to get in touch?