✦Template Printable Ideas Insights

How to Create Vendor Expense Summaries in QuickBooks

By

Streamlining your accounting processes in QuickBooks often involves creating expense reports for oversight and auditing purposes. Summarizing expenses by vendor is an excellent way to track your spending and ensure each transaction is legitimate. Here's a step-by-step guide on how to print expense reports by vendor summary in QuickBooks:

Before diving into the printing process, ensure your expenses are accurately categorized. Double-check that each expense is assigned to the correct vendor. This step is crucial for generating an accurate and useful report.

generating the Expense Report

Your first step is to create the expense report you want to print. In QuickBooks, navigate to the 'Reports' menu, then select 'Accountant and Taxes'>'Profit & Loss Detail by Class.'

a business invoice form is shown with the text,'business invoice and
a business invoice form is shown with the text,'business invoice and
Bookkeeping Spreadsheet, Revenue Tracker, Expenses Tracker, Profit Loss Template, Excel & Google Sheet, Self-employed bookkeeping Template
Bookkeeping Spreadsheet, Revenue Tracker, Expenses Tracker, Profit Loss Template, Excel & Google Sheet, Self-employed bookkeeping Template
How to Transfer Funds in QuickBooks Online
How to Transfer Funds in QuickBooks Online

This report allows you to view detailed expense information by vendor, making it ideal for your needs. Customize the report by including the vendors you want to track and ensure the ' expenses' box is checked under 'Display.'

Filtering and Sorting the Report

QuickBooks offers various ways to filter and sort your reports for better organization. Click on the 'Customize' button at the top of your report. Under the 'Filter' tab, you can narrow down your report by date, class, location, and more.

Cash book in Excel for Tracking Income and Expenses, Personal Budget Spreadsheet
Cash book in Excel for Tracking Income and Expenses, Personal Budget Spreadsheet
Small Business Spreadsheets for Google Sheets & Excel
Small Business Spreadsheets for Google Sheets & Excel
Easy small business finances. Track monthly income & expenses on ONE sheet!
Easy small business finances. Track monthly income & expenses on ONE sheet!

For a vendor summary, focus on filtering by vendor. In the 'Sort By' dropdown, choose 'Vendors' to sort your report in alphabetical order by vendor.

Finalizing the Report

After filtering and sorting, ensure your report is displaying the necessary information. Check the 'Columns' tab under 'Customize' to include or remove data such as Account, Product/Service, and Sales Rep.

Once satisfied, click 'OK' to finalize your report. You'll see a preview of your expense report by vendor summary, ready for printing.

How to Create a Recurring Expense in QuickBooks Online
How to Create a Recurring Expense in QuickBooks Online
Small Business Bookkeeping Template | Google Sheets & Excel Tracker
Small Business Bookkeeping Template | Google Sheets & Excel Tracker
Online Business Tools Essential Income & Expense Spreadsheet Templates for Small Business 🛠️
Online Business Tools Essential Income & Expense Spreadsheet Templates for Small Business 🛠️
Small Business Bookkeeping Template, Excel and Google Sheets Income Expense Profit Tracker with Dashboard, Instant Download Spreadsheet
Small Business Bookkeeping Template, Excel and Google Sheets Income Expense Profit Tracker with Dashboard, Instant Download Spreadsheet
Everything Etsy sellers need to track profit ✨
Everything Etsy sellers need to track profit ✨
Easy Accounting Excel Simple and Easy Business/expenses Planner Template - Etsy 📖
Easy Accounting Excel Simple and Easy Business/expenses Planner Template - Etsy 📖

Printing the Expense Report

Now that your expense report is ready, it's time to print it. In the top-right corner of your report, click on the printer icon or select 'Print' from the 'File' menu.

In the 'Print Reports' window, choose your printer and the number of copies. Under 'Print Style,' select 'Normal' for a straightforward printout or 'Condensed' for a more compact version. Click 'Print' to send the document to your selected printer.

Reviewing and Saving the Report

After printing, review the expense report to ensure it matches your QuickBooks data. If everything is in order, consider saving the report for future reference or external audits.

Bookkeeping Onboarding Pricing Calculator Google Sheets Template Automated Client Setup
Bookkeeping Onboarding Pricing Calculator Google Sheets Template Automated Client Setup
Bookkeeping Spreadsheet Template (Excel, Google Sheets) Income Expense Sales Tracker, Tax Tracker, Invoice Tracker
Bookkeeping Spreadsheet Template (Excel, Google Sheets) Income Expense Sales Tracker, Tax Tracker, Invoice Tracker

To save the report, click on the 'File' menu and select 'Save As.' Choose a location on your computer to save the file and select the format, such as Excel or PDF, based on your preferences.

Printing expense reports by vendor summary in QuickBooks doesn't have to be a daunting task. With these simple steps, you can generate and print detailed, organized expense reports that save you time and help maintain your accounting accuracy. Happy printing!