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

Check Detail Report

The Check Detail in QBO does not include Bill Detail with each acct number. I used this all the time in Desktop to run through each Check number to double check all expense accounts associated with the Bill Lines. 

 

Is there a way to do this in QBO?

 

Need list by check with vendor and Bill that it is paying with each account line on the bill. 

8 Comments 8
ReymondO
Moderator

Check Detail Report

Hello, @lork.

 

I'm happy to provide information about the Check Detail report in QuickBooks. This report currently displays the checks you've written, including the date, payee, and amount, as well as the expense and bill payments created within the program. However, it doesn't include the details of your bills.

 

As a workaround, you can run the Bills and Applied Payments report. Then, add a vendor column and other details you need to display the necessary data. Here's how:

 

  1. Go to Reports and run the Bills and Applied Payments report.
  2. Click Customize, then go to the Rows/Columns section.
  3. Check the Vendor box. You can also add other details in the column. Simply check the boxes for the info you want to add.
  4. Select Save and close.

 

For additional reference about customizing reports, you can check this article: How to get the most out of your financial reports.

 

If you have any additional questions about running reports in the program, feel free to ask. We're here to help. Have a great day!

lork
Level 2

Check Detail Report

This doesn't provide me with the Bill Line(s) - GL Accounts of the Bill

 

What report can I print to get the BILL LINE(S) WITH ACCOUNT NUMBER?

 

This is crazy that this is not available in QBO. The check detail on desktop report had it all in one report.

Shania_C
QuickBooks Team

Check Detail Report

Hi there, @lork.

 

Allow me to share some information about your concern where you're unsure of what report should you print to get the bill lines with account numbers in QuickBooks Online.

 

To view the account number, you can check the Check Detail report and customize it by selecting and reordering columns. Additionally, make sure that "Enable account numbers" is turned on in the settings to be able to see the account number.

 

Here's how:

 

  1. Go to Settings and select Account and Settings.
  2. Select the Advanced tab.
  3. Select Edit in the Chart of Accounts section.
  4. Turn on Enable account numbers. If you want account numbers to show in reports and transactions, select Show account numbers.
  5. Select Save and then Done.

 

Moreover, you can also check the Chart of Accounts to verify if there are numbers seen in the transactions.

 

Step 2: Assign account numbers

 

  1. Go to Settings ⚙, then select Chart of Accounts.
  2. Select ✎ Batch Edit above the Action column.
  3. In the Number column, add account numbers.
  4. Once you’re done, select Save.

 

To see your accounts’ numbers, go to the Chart of Accounts. Select Settings above the Action column. Make sure the Number is checked.

 

Once your Account number already showing, you can check out this article to learn how to set up and add accounts to your chart of accounts also learn how to run basic reports in QuickBooks: 

 

 

We're glad to have you on board in our Community. If you have any questions or concerns about your bill lines with account numbers, feel free to ask. Keep Safe!

lesfen
Level 2

Check Detail Report

That would be fine if there were actually a "Bills and Applied Payments" Report.

 

How can I find all payments made to XYZ Inc?   

Candice C
QuickBooks Team

Check Detail Report

Good evening, @lesfen

 

Welcome back to the Community! I'd be more than happy to help you locate this report within your QuickBooks Online account. 

 

Let's try to get this report showing in your account. Use the instructions below to find the report under the "What you owe" section of the reports page:

 

  1. Go to the Reports tab on the left-hand menu bar.
  2. Select Reports.
  3. Tap Standard.
  4. Scroll down until you see What you owe.
  5. Choose Bills and Applied payments.

 

Here's a visual: 

 

 

Feel free to come back if you have any other questions. Have a great day! 

ts121
Level 1

Check Detail Report

I'm having the same issue, and QBO support does not understand what is needed.

 

When running the check detail report or the Bills and applied payments report, the account that is shown is simply AP for bill payments. What I need is for the report to show is the expense account for the bill. For example, I enter a bill that is applied to "maintenance expense", and then write a check to pay that bill, I need a report that shows the check number, who the check was for, check date, and the expense GL account. Having it show Accounts Payable is not helpful to see what expense account the payment is for. 

 

Additionally, I need a report that shows ALL checks that were posted for a certain date range. I wrote 5 checks yesterday: 4 bill payment checks, and one refund check. Running a check detail report does not show the refund check. This is a standard report to have in any and all accounting software that show all checks run, regardless of how they were run. Who at QBO will solve this basic problem?

BigRedConsulting
Community Champion

Check Detail Report

@lork  RE: I used this all the time in Desktop to run through each Check number to double check all expense accounts associated with the Bill Lines. 

 

QuickBooks Online reporting is very weak compared to Desktop. You may find many more reports that you can't run either with Online.

 

If you expect Online to be a reasonable replacement for Desktop, you will be disappointed.

BigRedConsulting
Community Champion

Check Detail Report

@ts121  RE: I'm having the same issue, and QBO support does not understand what is needed.

 

That is a general understatement. They do not understand accounting, QuickBooks, or simple questions about either.

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

Need to get in touch?

Contact us