Question

vendor report totals

Forum|Forum|5 years ago
March 26, 2021
5 replies
40 views

I have one vendor I pay by check every week. I always pull up the vendor and click customize report. I customize the report with name, memo and amount. I cannot get this report to total the check amounts/total amount I have paid so far. I always have to add them up.

QuickBooks Desktop

Rubielyn_J

Level 8

It's good to see you here, @cab21.

I can help you run a report showing the total amount you paid to your vendor.

We can generate the Expenses by Vendor Detail report and add some filters to reflect the data you need. Let me show you how:

Go to the Reports menu.
Select Company & Financial and then choose the Expenses by Vendor Detail report.
Click the Customize Report button.
Under the Display tab, choose the date.
Then go to the Columns section.
Put a checkmark next to Name, Amount, and Memo.
Go to the Filters tab, under Filter select Name.
Under the Name dropdown menu, choose the vendor.
Lastly, click OK.

I also encourage you to view this article to learn more about how to personalize reports in QuickBooks: Customize vendor reports.

Additionally, you can memorize reports to save current customized report settings to be available for future use.

Please keep me posted if you have any other questions with reports in QuickBooks. I'm more than willing to help. Have a wonderful day!

C

cab21Author

It's not an expense account. I have a CIP land account set up under other current asset as we are developers. the vendor check is posted to the CIP land account. How do I filter the report to show the vendor check payment totals with the OCA land account?

C

Charies_M

Level 9

Thanks for adding details to your concern, cab21.

To achieve your goal, you can run the Transaction List by Vendor report and filter the Account section to show CIP Land as well as the Transaction Type. I'll walk you through the steps on how to do it:

Go to Reports and choose Vendors & Payables.
Select Transaction List by Vendor
Click the Customize Report button.
Select the Filters tab.
Choose Account from the Filter list and select CIP Land from the list of accounts.
From the Filter tab, click Transaction Type and choose Payment from the list.
Click OK to save the information.

Find out more about managing reports in QuickBooks Desktop through the following articles:

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

Count me in if you have further questions while working with vendor reports or anything about QuickBooks. I'm always available to help. Keep safe.

C

cab21Author

Perfect. Thanks. One more question

While I have the CIP account. I would like to run payroll and add it to my CIP account. I filtered the CIP account to include certain expenses like fuel for equipment, M&R on equipment etc. How do I filter payroll to be included in this report.

RenjolynC

Level 9

Hello again, cab21.

To include the CIP account in your payroll transactions, you'll want to set up the accounting preferences for your payroll.

Here's how:

Go to Edit > Preferences.
On the left panel, select Payroll & Employees.
Click the Company Preferences tab.

Here's a sample screenshot for a visual guide:

You can check out this article for more details about the setup: Set Preferences for Payroll.

Once done, you can run a separate report called Payroll Transaction Detail. Then, customize the report to include the Account column.

To learn more about reports and customization, feel free to open these guides:

For any follow-up questions or other concerns with QuickBooks Desktop, please leave a reply below. Me and my colleagues are always here to help. Take care and stay safe!

Sign up

Login with SSO

Let's get you signed in

Login with SSO