Skip to main content
February 15, 2024
Question

how to make a report for checks written

  • February 15, 2024
  • 1 reply
  • 0 views

I want to create a report that will give me a summary of all checks written within Quickbooks for each vendor.

 

There is nothing too complicated that I need, just Vendor name and total amount of checks written out to them.

 

How can I create this? I am using Quickbooks Desktop Pro Plus 2023.

1 reply

February 15, 2024

I'll share the instructions on achieving your goal in your QuickBooks Desktop (QBDT), dolsvoid.

 

You can run the Check detail report and customize its data to display the information needed. I'll guide you through the process:

 

  1. Go to the Reports menu, then choose Banking.
  2. Select Check Detail.
  3. Click on Customize Report.
  4. Go to the Filter tab, then select Transaction Type.
  5. Click on Check in the Transaction Type dropdown button.
  6. Enter Name in the Filter tab.
  7. Choose the vendor.
  8. Edit the report period in the Date field.

 

You'll want to save the configuration settings of your report. Visit this article: Create, access, and modify memorized reports.

 

You can always count on me if you need a hand managing reports within the program. Just hit the Reply button, and I'll be right here to assist you. Keep safe.

dolsvoidAuthor
February 29, 2024

This report for whatever reason only starts generating check payments starting in May on 2023, for some reason doesn't include February even though I set the start day to be 01/01/2023. Why?

February 29, 2024

I appreciate your patience in following the steps provided by my colleague, @dolsvoid

 

To find the root cause of the missing check transactions, we need to check if there are any check transactions for February. If there are, please double-check the filters of the reports. If everything looks okay, let's run the Verify and Rebuild troubleshooting to check if there is a data issue.

 

Here are the steps to verify your company data:

 

  1. Go to Window then select Close All.
  2. Go to File, then select Utilities.
  3. Select Verify Data. If you see: 
    1. QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
    2. An error message—search for it on our QuickBooks Desktop support site for how to fix it.
    3. Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

 

Now, let's Rebuild your company file data:

 

  1. Go to FileUtilities, and then select Rebuild Data.
  2. QuickBooks will ask you to make a backup before it rebuilds your company file. Select OK. A backup is required before you can rebuild.
  3. Select where you want to save your backup, then OK. Don’t replace another backup file. Enter a new name in the File name and select Save.
  4. Select OK when you get the message Rebuild has completed.
  5. Go to File, select Utilities, then select Verify Data again to check for additional damage. 
  6. If your error can't be found, you can restore a recent backup. Go to File then select Open or Restore Company.

 

Additionally, you can memorize your reports to save your customizations for future use.

 

Please let us know if you need further assistance in generating your check payments report. We're always here to help.