✦Template Printable Ideas Insights

"Mastering QuickBooks: Step-by-Step Guide to Creating a Customer-Based Expense Report

By

Keeping track of customer expenses is a crucial aspect of running your business, and QuickBooks offers an effective way to do this through expense reports. If you're a QuickBooks user wondering how to run an expense report by customer, you've come to the right place. In this guide, we'll walk you through the step-by-step process to create a customer-based expense report in QuickBooks. Let's dive in!

Before we begin, ensure you have the latest version of QuickBooks Desktop or QuickBooks Online. Also, make sure you're signed in as an admin user or have the necessary permissions to access and create reports.

Running an Expense Report by Customer in QuickBooks Desktop

QuickBooks Desktop provides a straightforward way to generate an expense report by customer. Here's how you can do it:

Free Excel Expense Report Templates | Smartsheet
Free Excel Expense Report Templates | Smartsheet
Export Customers List in Quickbooks,
Export Customers List in Quickbooks,
Ask Questions & Get Help | QuickBooks Community
Ask Questions & Get Help | QuickBooks Community

First, open your QuickBooks Desktop and navigate to the "Reports" menu. Then, select "Expenses by Customer" from the "Company & Financial" sub-menu.

Step 1: Setting Report Parameters

In the pop-up window, choose the date range for which you want to see expenses. You can select a predefined range like 'This Year' or 'Last Year,' or create a custom range by choosing specific start and end dates.

Ready-To-Use Expense Report Template With Chart - MSOfficeGeek
Ready-To-Use Expense Report Template With Chart - MSOfficeGeek
professional Expense Report | Templates at allbusinesstemplates.com
professional Expense Report | Templates at allbusinesstemplates.com
Are you tired of seeing the “unbilled” screen come up when invoicing your customers?
Are you tired of seeing the “unbilled” screen come up when invoicing your customers?

Next, make sure the 'Include inactivating transactions' checkbox is marked if you want to include closed or inactive transactions in your report. Once you've set your parameters, click 'OK' to proceed.

Step 2: Customizing Report Columns

After setting the report parameters, you'll see a list of columns that will appear in your expense report. By default, QuickBooks includes columns for 'Customer:Job,' 'Amount,' 'Date,' 'Account,' and 'Class.' If you want to add, remove, or rearrange columns, click on the 'Customize Column' button.

In the 'Customize Columns' window, select the columns you want to include or remove using the checkboxes. You can also rearrange columns by dragging and dropping them in the 'Drag and Drop column names here to change the order' area. Once satisfied with your column selections, click 'OK' to return to the report.

QuickBooks Online Reclassify Transactions – Accountant View
QuickBooks Online Reclassify Transactions – Accountant View
Expense Report Template - Excel Word Template
Expense Report Template - Excel Word Template
Sample Expense Report Templates
Sample Expense Report Templates
Sample Financial Report Templates
Sample Financial Report Templates
Office Supplies Expense Report Template Visme
Office Supplies Expense Report Template Visme
a person using a laptop computer on top of a desk with calculator next to it
a person using a laptop computer on top of a desk with calculator next to it

Running an Expense Report by Customer in QuickBooks Online

Running an expense report by customer in QuickBooks Online is a similar process, with a few slight differences. Here's how to do it:

Log in to your QuickBooks Online account and navigate to the 'Reports' tab in the left menu. Then, select 'Expenses by Customer' from the 'P&L' sub-menu.

Step 1: Setting Report Filters

In the 'Expenses by Customer' report, you'll see a filter bar at the top, allowing you to customize your report. Click on the 'Date' dropdown to choose the time period for your report. You can select predefined ranges like 'Last 30 days' or 'This fiscal year' or create a custom range using the 'Start / End' date fields.

Expense Report Template
Expense Report Template
Free Word Templates
Free Word Templates
a printable work schedule for employees to do their tasks in the company's office
a printable work schedule for employees to do their tasks in the company's office

Additionally, you can filter the report by other criteria like 'Customer' and 'Class' using the respective dropdown menus.

Step 2: Customizing Report Columns and Display

Below the filter bar, click on the 'Column' or 'Display' dropdowns to customize the report's layout and content. The 'Column' dropdown lets you add, remove, or rearrange the columns in your report. The 'Display' dropdown provides options to display or hide subtotals, grand totals, and other report elements.

After customizing your report settings, the report will update automatically to reflect your changes. You can then print, export, or manually enter data changes as per your requirements.

And there you have it! By following the steps outlined above, you can now create expense reports by customer in both QuickBooks Desktop and QuickBooks Online. Regularly running these reports will help you maintain a clear overview of your expenses, identify costs trends, and make data-driven decisions to optimize your business's financial health. Happy bookkeeping!