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.
rcohen1101
Level 1

Expense reports

I have downloaded and catergorized transactions from my bank and credit card.  I want a simple report to just list what I've spent for expenses and the amount of income.  The various reports I try don't work.  Profit and Loss includes only some of the categories.  Balance sheet has them all, but I only want the report to include entries from July until now and when I choose a custom report and enter the dates, all the credit card transactions from the year are included.  Any ideas? 

1 Comment 1
Anonymous
Not applicable

Expense reports

Hi there, @rcohen1101.

 

The Profit and Loss Report includes only the categories designated as Income or Expenses. To display transactions categorized from your bank, ensure they were properly assigned to the designated expenses and income accounts. This will make them visible in the report.

 

Regarding the Balance Sheet Report showing transactions from last year, select the date range from July to the current date. This should filter out transactions that occurred outside this period. Therefore, we can double-check the Report Period entered, as the transactions displayed will depend on the dates selected.

 

Another way is to run the Transaction Detail by Account report. This report provides a breakdown of transactions entered on work orders for a specified reporting period and includes information entered into each entry. You'll only have to customize this by selecting the particular account and transaction type you want from the report. Here’s how:

 

  1. Go to the Report menu and search for the Transaction Detail by Account report in the search bar.
  2. Select the correct Report Period and click the Customize button.
  3. From the Filter dropdown, check the Account and Transaction Type boxes.
  4. Drill down in the Account dropdown and select the specific accounts you want to be added to the report, do the same with the Transaction Type.
  5. Select any additional filters you want to personalize the report and hit the Run Report button.

 

You can also view these resources to learn more about customizing reports:

 

 

Additionally, you can export your reports to obtain a copy or use them outside of QuickBooks. For complete guidelines, refer to this article: Export your reports to Excel from QuickBooks Online.

 

Feel free to reach out if you need any help with running the report, @rcohen1101. I’m happy to assist you. Have a great day!

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

Need to get in touch?

Contact us