Skip to main content
N
newyorktutor
November 21, 2023
Question

report showing expense and bank account

  • November 21, 2023
  • 1 reply
  • 0 views

hoping to create a report showing expense, class and bank account from which it was paid all in one report. any suggestions? thanks

1 reply

A
Archie_B
November 21, 2023

Hello there, newyorktutor.

I'll show you how to create a report that includes all of the information you'll need.

In QuickBooks Online, we can use the Transaction Detail by Account report and create an overall report showing expenses, classes, and the corresponding bank account.

 

Here's how:

 

  1. Go to the Reports menu.
  2. In the search bar, type in "Transaction Detail by Account" and select the corresponding report from the suggestions.
  3. Click the Customize button.
  4. In the Rows/Columns section, click on Change columns and make sure to include Class.
  5. Under the Filter section, put a checkmark for Transaction Type, then select Expense.
  6. In the same section, put a checkmark for Accounts, then select the bank account you want to see in this report.
  7. You can also change the report period, and any other settings to fit your needs.
  8. Once done, hit the Run report button.

 

The report will now show expenses, classes, and the bank account used to pay them all in one place. I've included this article to show you how to use all of the features to personalize your report: Customize reports in QuickBooks Online.

 

If you need to know how to export, email, or print reports in QuickBooks Online, you can check out this link: Run reports in QuickBooks Online.

 

Feel free to leave your follow-up questions or other concerns about reports in the comment section below.  I'll be around if you need my help. Keep safe!

N
newyorktutorAuthor
November 21, 2023

Thanks Archie. The problem with that report is that CLASS does not show up for Bill Payments and most of the expenditures I am trying to track are not straight expenses. They have bills and bill payments. Any other thoughts would be greatly appreciated.

J
Jelayca V
November 21, 2023

Welcome and thank you for reaching out to the Community,  @newyorktutor.

 

I understand that you want to view a report that displays expenses, classes, and bank accounts in bill payments. However, it's important to note that when you create or enter bill payments, there is no option to add a class, so the class won't appear in the report.

 

It's important to note that class tracking is mainly associated with expense or income transactions, rather than the payment of those transactions. Although you can't directly assign a class to bill payments, you can still track the classes related to the bills and generate reports to analyze the class-specific expenses.

 

If you want to see the payments you've made and the bills that go with them, you can pull up the Bills and Applied Payments report. From this report, you can customize  the fields you want to see, make changes to the columns, filter vendors, and customize header and footer. 

 

For information on how to export, email, or print reports in QuickBooks Online, check out this link: Run reports in QuickBooks Online.

 

I hope this clarifies things for you. If you have any further questions about reports in QuickBooks Online, please don't hesitate to reach out to us. We're always here to help you. Have a good one. 

Terms & ConditionsAccessibility statement