Aaron Woolley

Aaron Woolley

Analyzing Financial Data: Create & Customize Preset Reports

Slide Duration:

Table of Contents

Section 1: Introduction
Bookkeeping Basics

10m 25s

Intro
0:00
The Accounting Equation
0:10
Assets
1:15
Liability
2:19
Equity
3:11
Debit vs. Credit
4:10
T Account
4:40
How Your Bank Treats Your Account
5:02
Your Books
6:08
Chart of Accounts
7:15
Balance Sheet Accounts: Assets
7:25
Balance Sheet Accounts: Liability
7:40
Balance Sheet Accounts: Equity
8:22
Income Statement Accounts
9:03
Income
9:06
Expenses
9:26
Net Income
9:48
Getting Started

16m 34s

Intro
0:00
Using Forms
0:13
How to Edit Customer Form
1:06
How to Edit Vendor Form
1:37
Using Lists
2:34
Customer Lists
2:39
Vendor Lists
2:47
Employees Lists
2:59
Using Registers
3:16
Check Register
3:22
Chart of Accounts
3:40
How to Use Register
6:27
Getting Around QuickBooks
7:54
Navigating Through the Home Screen
8:08
Managing Employees
9:59
Managing Open Windows
11:23
The Menu Bar
12:02
The Icon Bar
12:28
QuickBooks Centers
12:50
Customers, Vendors, Employees Center
12:53
Banking Center
13:06
Report Center
13:38
Lead Center
13:46
Search Information
14:17
How to Search for Information on a Customer
14:28
The Homepage & Workflow
15:12
The Chart of Accounts: Assets, Liabilities, Equity
15:37
How to Access Chart of Accounts
15:45
Setting Up QuickBooks

20m 51s

Intro
0:00
The Express Start
0:23
Create New Company
0:49
Entering Company Information
0:55
Enter Business Contact
2:24
Preferences
4:16
Adding Contacts
4:22
Adding Products and Services
4:28
Adding Bank Accounts
5:26
Review the Chart of Accounts and Customize
6:10
Check Chart of Accounts Set Up
6:48
How to Add To Chart of Accounts
7:20
Entering Bank Accounts and Opening Balances
8:00
Edit New Bank Accounts
8:28
Add New Bank Accounts
8:52
How To Open Balance
9:58
Adding Customers
10:27
How to Add New Customers
11:05
Adding a Job
12:33
Add New Job For Customer
12:50
Adding Vendors
15:01
Access Vendor Center
15:17
Add New Vendor
15:33
Adding Additional Accounts
16:33
Adding New Accounts in Chart of Accounts
16:53
Adding Items (Products & Services)
18:06
Add New Item to Sell
18:45
Section 2: Working With Lists
Working With Lists, Part 1

31m 24s

Intro
0:00
Editing The Chart of Accounts
1:08
Edit Account
5:10
Adding Subaccounts
6:17
New Subaccount
7:50
Working with Customers & Job Lists
11:32
Add new customer
13:25
Providing Additional Customer Information
17:50
Providing Customer Payment Information
22:10
Working with the Vendor Center
24:08
Add new vendor
25:50
Providing Additional Vendor Information
28:28
Working With Lists, Part 2

46m 1s

Intro
0:00
Working with the Employee Center
0:24
Add new employee
2:01
Add contact information
4:02
Additional employee information
5:31
Employment information
6:26
Adding Custom Fields for Customers, Vendors, Employee List
7:28
How Many Lists You Can Add And For Who
8:46
How to Add Customer List
9:35
Define Fields
10:37
Adding Custom Fields for Items
13:26
Open Item List and Edit
14:15
Define Fields/ Setup Custom Fields For Items
15:54
Managing Lists
17:01
Ways to Sort Lists
17:14
Add Items to Chart of Accounts
17:32
Add Owner's Equity, Draw, and Contribution under Equity Account
17:59
Sorting Lists Manually
19:31
Making Sub Accounts
20:35
Sorting Lists
23:26
Sorting Lists in Ascending or Descending Order
23:54
Sort by Name, Balance, etc., Ascending or Descending
24:26
Merging List Items
26:08
Merging Vendor Example
26:53
Renaming List Items
28:55
Renaming Item Example: Checking Account
29:13
Deleting List Items
29:56
Deleting Customer Example
31:19
Viewing Inactive and Active Customers
32:32
Printing a List
33:26
Printing Customer List
33:58
Printing for Just One Customer
34:40
Print Particular Info for One Customer
35:08
Adding or Editing Multiple Items at One Time
37:04
Example: Changing a Zip code
37:39
Working with the Lead Center
41:43
Finding the Lead Center
42:09
Add New Leads
43:05
Add Multiple Contacts to Lead Center
44:34
Convert a Lead to a Customer
45:16
Section 3: Accounts
Working With Bank Accounts

29m 11s

Intro
0:00
Writing a QuickBooks Check
0:30
Amount field
3:59
Other fields
5:27
Print check
7:00
Using Bank Account Register
7:40
Entering a Handwritten Check
9:45
Transferring Money Between Accounts
16:33
Funds Transfer Option
17:24
Transfer with Check Register
19:18
Marking Cleared Transactions
20:57
Bank Statement
23:31
Reconciliation Summary
26:11
Viewing Cleared Checks in the Register
27:05
Searching for Specific Check Amount
27:40
Using Other Accounts in QuickBooks

13m 25s

Intro
0:00
Other Account Types in QuickBooks
0:36
Tracking Credit Card Transactions - Entering Credit Card Charges
0:58
Reconciling Credit Card Statement
3:52
Reconcile Credit Card
5:00
Marking Cleared Transactions
5:57
Paying a Credit Card Bill
8:11
Entering Bills
8:34
Writing a Check
10:15
Using Other Accounts: Assets & Liabilities

30m 16s

Intro
0:00
Working with Asset Accounts: Setting up an Asset Account
1:24
Add New Account
2:30
Enter Opening Balance
4:34
Setup Asset Account to Track Depreciation
7:33
Add Subaccounts: Cost & Depreciation
10:32
Enter in Depreciation of Transactions
13:01
Working with Liability Accounts: Tracking a Loan / Long Term Liability
15:39
Add Long Term Liability / Loan Account
17:09
Tracking Fixed Assets
20:29
Add New Asset
21:36
Recording a Payment on a Loan
24:23
Understanding Equity Accounts
27:03
Add New Equity Account
29:20
Section 4: Sales Information
Entering Sales Information, Part 1

24m 23s

Intro
0:00
Using Sales Forms - Various Types of Sales Forms
0:07
Invoice Overview
0:56
Sales Receipt Overview
3:09
Generate Statement
4:38
Choosing a Template for Sales Forms
6:00
Filling in Customer Information
7:54
Create an Invoice
8:04
Invoice in Accounts Receivable Ledger
10:28
Repeating a Sale - Memorized Transactions
11:36
Memorize Invoice
12:52
Memorized Transaction List
14:01
Batch Invoices
14:55
Create Batch Invoice
15:21
Entering a New Service Item
20:13
Add new service
21:25
Entering Sales Information, Part 2

12m 33s

Intro
0:00
Using Multiple Price Levels - Create New Price Level
0:07
Create Price Level List
1:49
Associating Price Level with Customers
4:27
Edit Customer
5:53
Using Price Levels on Sales Forms
7:09
Choose Rate
8:56
Assigning Price Levels To Individual Line Items
10:38
Entering Sales Information, Part 3

22m 33s

Intro
0:00
Managing Overdue Customer Payments - Using the Collections Center
0:21
Collections Center
0:39
Create Invoice Letters
2:00
Prepare an Invoice Letter
3:09
Generating Reminder Statements
7:32
Assess Finance Charges
9:14
Preview Statement
9:42
Processing Sales Orders - Invoices Against Sales Orders
10:28
Open Sales Orders by Item
12:04
Create an Invoice
13:24
Tracking Back Orders
14:36
Create Invoice from Sales Order
16:37
Receiving Items
18:21
Check Item List / Inventory
19:22
Create Sales Order
19:58
Section 5: Payments & Deposits
Receiving Payments & Making Deposits, Part 1

12m 40s

Intro
0:00
Recording Customer Payments - Record a Payment in Full for a Single Job
0:20
Receive Payments
0:40
Undeposited Funds Account
2:25
Entering a Partial Payment
3:42
Assign Payment
6:36
Applying One Payment to Multiple Jobs
8:10
Entering Overpayments
9:44
Leave or Refund Amount
10:51
Issue a Refund
11:28
Receiving Payments & Making Deposits, Part 2

15m 8s

Intro
0:00
Handling Down Payments or Pre-payments
0:07
Apply Credits
4:30
Making Deposits - Selecting Payments to Deposit
5:58
Payments to Deposit
6:26
Make Deposit
8:02
How QuickBooks Handles the Deposit
10:16
Entering & Paying Bills

22m 1s

Intro
0:00
Handling Bills in QuickBooks
0:23
Using QuickBooks for Accounts Payable
2:24
How to Bring up the Accounts Payable Register
3:04
Entering Bills
4:03
Enter New Bill
4:30
Add Vendor to List
6:29
See the Balance
8:48
Paying Bills
11:17
Turning on Reminder List
11:49
How to Pay a Bill
13:34
How to Print the Checks
16:21
How QuickBooks Records Your Bill Payment
17:08
How to See Your Checking Account / Bill Payment Check
18:38
Section 6: Analyzing Financial Data
Analyzing Financial Data, Part 1

11m 42s

Intro
0:00
Understanding Your Business Using Reports
0:11
When to Use a Quick Report
2:41
Creating Quick Reports
3:05
How to Look at Details for Quick Reports
4:05
Zoom In on a Quick Report
5:19
What You See When You Zoom In On An Item
6:06
Customizing Quick Reports
6:53
How to Customize A Report
7:28
How to Add Transaction Number to QuickReport
7:57
How to Move Columns Around
8:14
How to Change Header
9:42
Analyzing Financial Data: Create & Customize Preset Reports

29m 26s

Intro
0:00
Creating and Customizing Preset Reports
0:35
Company & Financial
0:54
Customers & Receivables
1:04
Sales
1:53
Jobs, Time & Mileage
1:55
Vendors & Payables
2:35
Purchases
2:45
Inventory
3:06
Employees & Payroll
3:22
Banking, Accountant & Taxes, Budgets & Forecasts
3:43
Lists
3:49
Industry Specifics
3:54
Using the Report Center
4:37
Categories of Standard Reports Available
5:15
Creating a Balance Sheet Comparison Report
7:29
Filtering Reports
9:50
Customize Report
10:20
Saving Reports in PDF Format
13:58
Creating and Customizing a Sales Report
15:24
How to Change the Date to a Custom Date
16:30
Using Quickzoom in a Preset Report
17:49
What is Quickzoom?
17:55
How to Zoom
18:19
Widening and Narrowing Reports
19:59
Saving Report Settings and Creating Memorized Report Groups
20:50
What are Memorized Reports and What Are They Used For
21:04
Memorized Reports List
21:43
How to Create A New Memorized Report
22:19
Memorizing Preset Reports
22:48
Saving Report
24:14
Adding Reports to Memorized Report Groups
24:42
Adding Reports
26:49
How to Display Reports
28:50
Analyzing Financial Data: Printing, Exporting, and Quickinsight Graphs

30m 12s

Intro
0:00
Printing Reports
0:17
Preview Before Printing
2:34
Processing Reports in Groups
3:38
How to Run Reports in Groups
4:51
How to Display All Reports in a Group
6:09
Exporting Reports to Microsoft Excel
7:15
Purpose of Why People Export To Excel
7:48
Sending the Report to Excel
9:13
Formatting Options
12:08
Changing Filters
14:30
Choosing and Changing Different Filters
16:30
Creating Quickinsight Graphs
17:51
Creating an Income and Expense Graph
18:41
How to Create the Graph
19:46
How to Read the Pie Chart
20:05
Customizing Graph Data
24:16
Choosing by Customer Instead of Account
24:50
Using Quickzoom with Graphs
25:10
How to Zoom on a Particular Customer
26:15
Customizing How Graphs Display
28:31
How to Change Graph Into 2D
29:03
Section 7: Inventory
Setting Up Inventory

23m 51s

Intro
0:00
Turn On Inventory Feature
0:43
Enter Products Into Inventory
1:44
Entering Product Through Vendor Menu
2:07
Add New Item
2:43
Reordering Item and Reminders
6:00
Ordering Products/ Creating P.O's
7:02
How to Create Purchase Orders
8:05
Look Up Outstanding Orders
10:46
Getting a Report of Purchase Orders
11:34
Choose and Open Quick Reports
12:48
Receiving Inventory
13:47
Receiving Inventory Without an Invoice
14:13
Reviewing the Inventory List
15:38
Entering a Bill for Inventory
15:59
Entering Bill for Received Items
16:45
Manually Adjusting Inventory
18:31
How to Get to the Adjust Quantity On Hand Page
19:16
Add New Account
20:23
Check and Review Inventory List
22:59
Inventory: Tracking Finished Goods

22m 10s

Intro
0:00
Use Group Items or Create Inventory Assets?
1:57
Tracking Items Through Group Items
3:02
Using Inventory Assembly
3:42
What is a Bill Point?
4:58
Setting a Default Markup
6:16
Adding a Basic Mark Up
6:31
Add a Labor Item to Use in Assemblies
7:26
How to Add New Labor Item in Assembly
7:53
Creating Inventory Assembly Items
9:54
Adding New Assembly Item to Inventory
10:40
Adding in Assembly Labor
14:22
Editing the List
14:53
Building Finished Goods
16:05
Changing Sales Price
16:48
How to Build Assemblies
17:51
Understanding the Effects of Building Items
19:24
Run Report to Generate Item List
20:24
Inventory: Units of Measure

13m 14s

Intro
0:00
Setup Single Unit of Measure
2:12
How to Edit Unit of Measure on an Item
3:18
Setup Multiple Units of Measure
5:32
Setting up Preferences to Multiple Units of Measure Per Item
6:13
How to Edit Multiple Units of Measure on an Item
6:49
Assign Units of Measure to Items
8:44
Edit Items to Assign UN Set
9:01
Assign Measure Sets
9:42
Open Purchase Order and Select Unit of Measure
10:41
Use Units of Measure on Sales Forms
12:47
Section 8: Tax
Tracking and Paying Sales Tax

21m 41s

Intro
0:00
Setup Tax Rates & Agencies
0:44
Setting Up Sales Tax Code List
0:55
How to Set up Tax Rate for Example City
3:26
Add New Item to Item List
3:46
Checking and Editing Item Through Vendor Center
7:20
Grouping Single Taxes
7:50
Why Taxes are Grouped
8:05
Creating New Sales Tax Group
8:59
Choose Tax Item to Add Into Group
9:51
Indicate Who and What Gets Taxed
10:45
Add New Customer To Assign Tax To
11:06
Invoicing Customer
13:03
Apply Tax to Sales
14:30
Editing Item and Choosing Tax Rate
14:53
Create a Sales Tax Liability Report
15:26
File Sales Tax Return/ Creating Liability Report
15:40
Use the Sales Tax Register
18:14
How to Read the Sales Tax Payable
18:35
Paying Your Tax Agencies
19:34
How to Pay Sales Tax
19:52
Choosing Which Items to Pay For
20:21
Print Checks
21:06
Section 9: Payroll & Invoice
Payroll Basics

17m 56s

Intro
0:00
Setup Payroll Items
0:54
Add to Subscription
1:07
Add Employee
2:26
Creating and Adding Personal Information
3:41
Adding Payroll/Compensation Information
4:43
Setup Taxes
6:27
Make a Payroll
8:36
Start a Scheduled Payroll
9:49
How to Edit Each Employee's Payroll Summary
10:30
Custom Items on Payroll
12:12
Print Payroll Checks
14:36
Print Later
14:39
Pay Payroll Liabilities
14:49
Forward Taxes to Authorities
15:06
Generate/Sending Check
15:46
Section 9: Payroll, & Invoice
Estimating & Progress Invoicing

14m 29s

Intro
0:00
Turning On Estimates and Progress Invoicing
0:21
Create a Job
1:30
Adding new job
2:22
Create an Estimate
5:14
Printing Estimate
7:56
Create Progress Billing
8:22
Invoice Estimate
8:32
Run Report: Job Progress Invoice vs. Estimate
10:46
Update Progress on Job Status
12:25
Edit Job Status
12:34
Make an Estimate Inactive
13:20
Section 10: Time Tracking
Time Tracking

17m 16s

Intro
0:00
Turn on Time Tracking
0:23
Entering Time Data
1:27
How to Enter Time for Labor Per Job
2:45
How to Start Time Ticker While On Job
4:22
Recording Employee Time on a Weekly Timesheet
5:40
Use Weekly Timesheet
6:17
Enter Reimbursement Costs
7:59
Write the Check
8:38
Invoice a Customer for Time and Costs
10:19
Create an Invoice
10:33
Invoice for Time for Labor
11:54
Reports: Time by Job Reports
13:13
Paying Non Employees for Time Worked
14:27
Using Time Sheet & Jobs
16:37
Section 11: Customizing Forms & Writing QuickBooks Letters
Customizing Forms and Writing QuickBooks Letters

13m 43s

Intro
0:00
Customizing Invoices
0:10
Create Invoice
0:34
Customize Invoice
1:10
Downloading New Layouts
2:50
Create New Design
3:10
Designing Custom Layouts for Forms
5:11
Layout Designer
7:08
Using QuickBooks Letters
9:56
Create an Invoice Letter
10:22
Collection Center
11:49
Email From Collection Center
12:31
Loading...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of QuickBooks
Bookmark & Share Embed

Share this knowledge with your friends!

Copy & Paste this embed code into your website’s HTML

Please ensure that your website editor is in text mode when you paste the code.
(In Wordpress, the mode button is on the top right corner.)
  ×
  • - Allow users to view the embedded video in full-size.
Since this lesson is not free, only the preview will appear on your website.
  • Discussion

  • Download Lecture Slides

  • Table of Contents

  • Transcription

  • Related Books

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

  • Unlimited access to our entire library of courses.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lesson files for programming and software training practice.
  • Track your course viewing progress.
  • Download lecture slides for taking notes.
  • Learn at your own pace... anytime, anywhere!

Analyzing Financial Data: Create & Customize Preset Reports

Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.

  • Intro 0:00
  • Creating and Customizing Preset Reports 0:35
    • Company & Financial
    • Customers & Receivables
    • Sales
    • Jobs, Time & Mileage
    • Vendors & Payables
    • Purchases
    • Inventory
    • Employees & Payroll
    • Banking, Accountant & Taxes, Budgets & Forecasts
    • Lists
    • Industry Specifics
  • Using the Report Center 4:37
    • Categories of Standard Reports Available
  • Creating a Balance Sheet Comparison Report 7:29
  • Filtering Reports 9:50
    • Customize Report
  • Saving Reports in PDF Format 13:58
  • Creating and Customizing a Sales Report 15:24
    • How to Change the Date to a Custom Date
  • Using Quickzoom in a Preset Report 17:49
    • What is Quickzoom?
    • How to Zoom
    • Widening and Narrowing Reports
  • Saving Report Settings and Creating Memorized Report Groups 20:50
    • What are Memorized Reports and What Are They Used For
    • Memorized Reports List
    • How to Create A New Memorized Report
  • Memorizing Preset Reports 22:48
    • Saving Report
  • Adding Reports to Memorized Report Groups 24:42
    • Adding Reports
    • How to Display Reports

Transcription: Analyzing Financial Data: Create & Customize Preset Reports

Welcome back to Educator.com.0000

This is QuickBooks lesson: analyzing financial data, how to create and customize pre-set reports.0002

Now, in addition to QuickReports from the previous lesson, QuickBooks has dozens of pre-set reports formats0009

that we can create Profit and Loss Reports, Balance Sheet Reports, Accounts Receivable Reports, Sales Reports,0018

Accounts Payable Reports, Inventory Reports and many other reports that are standard with QuickBooks.0026

So, we are going to talk about creating and customizing pre-set reports to begin with.0033

And just to let you know, in QuickBooks, we have a variety of pre-set reports.0038

Now, to get to the Report Center, from the Menu button in QuickBooks, if we look at Reports, there is a Report Center.0044

So, we can look at that, or we can actually look at the various categories that are there within QuickBooks.0052

There is Company and Financial that is going to give us profit and loss, Balance Sheet Reports that are very vital to our business.0058

Again, garbage in, garbage out.0065

So, if we do not put all the data in, we are not going to get a clear picture of our business.0070

So, it is vital that you put every bank transaction, every credit card transaction that is related to your business into QuickBooks0075

and categorize them properly in according to expense or whatever category that transaction has- sales reports, discounts that we give.0083

Make sure that you do that especially if you are going to discount an item that you are selling or a service that you are selling.0095

Make sure that the proper value is reported on the invoice and then, if there is a discount given so that you can track those.0099

And you see where your profitability is.0107

There is Customer and Receivable Reports. There is Sales Reports.0110

There is Jobs, Time and Mileage Reports, so we can keep track of our job costing.0115

That is a vital thing if you are a construction company or a manufacturer to see what those job are actually costing you.0121

Many customers of mine have seen that they thought they are a little more profitable than usual.0128

And then, when they actually go into every associated cost to that particular job, they are realizing0135

that they are actually not charging enough for that job, and they are actually losing money.0140

So, make sure that you attribute every cost, every expense to that job, so you can do job costing a little more accurate.0146

There is Vendors and Payables, so we can look at our Vendors, how much money we are spending with our0155

vendors, our suppliers, and what our payables, and the amount of money we owe to our vendors.0159

Purchases, so we can see what we are purchasing for our item, for our resell.0166

What is our amount? Maybe we are spending a lot of money with one particular vendor on items.0171

It might prove to our benefit to maybe renegotiate term so we might be able to get a lower0176

price on those items that we are reselling since we are being such a great customer to them.0182

There is Inventory Reports, vital to a business that is dealing with inventory.0186

There is an Inventory Control so we can go through those reports, and it will help us manage it a little better.0192

And we can keep our cost down and actually eliminate loss.0198

There is Employee and Payroll. If we are on Payroll, we can actually have a variety of payroll reports that will help us0202

understanding what our employees are doing especially if we are dealing with job costing and the time and efforts that0208

our employees are spending per job, so we can do time and billing for our customers, too on our job costing.0216

Banking Reports, Account and taxes, there is Budget and Forecasting lists for the items and services and products and services that we are providing.0223

We can look at all of those. We can look at our Industry-Specific if we are contractor or if we are manufacturer.0231

There is some Industry-Specific Reports that come standard with QuickBooks if we opted on those industry versions of QuickBooks.0239

So, then, there is Contributor Reports if you are using a premier or a higher version.0247

There is Contributor Reports where some other QuickBooks user have customized certain reports that might be beneficial to you.0252

If it is beneficial to them, to making their business successful, we might be able to look into their reports,0260

what they have done and how we can improve our business in the same way.0265

So, those are the variety of reports that we have that help us manage our business a little more accurately.0269

The next thing we are going to discuss now is using the Report Center in QuickBooks.0277

So, Report Center has a variety of ways to get to those pre-set reports.0282

Like I said, there is the Quick menu option here from the Report area.0286

Or we can just choose the Report Center, which is a more visual aid in looking at those reports.0291

So, when we pull up the Report Center, it is a good way to kind of see and visualize what those reports might look like.0297

Now, of course, my version gives me an option to say "Hey, there is new Contributor Reports explore now option.0304

I am going to close that down. You may not have that function there.0311

So, here in the Report Center, we have the categories of standard reports that are available to us, Purchases, Inventory Reports, etc. on our left side.0314

We, are, then, going to look to the right upper hand portion of how we are going to look at those reports.0324

So, If I look over here and look at the grid view...this is the grid view of each report.0332

It gives us, kind of, a visual summary of what that report might look like in the format in which it is.0336

And we can scroll down and see the various reports there, Incoming and Expense Reports.0344

We can look at the Balance Sheet Net Worth, and we can see these different type of reports here, OK?0349

There is some Graph Reports, different things that we can look at, a Cash Flow Report, and that is the grid view of the Report Center.0354

If we go back to the top and go to the Lists view. It will give us a list of the reports and what those standards are.0363

So, we can look at the Lists view, as well.0373

That is helpful if you know exactly which you are looking for, or you can go to the carousel view, and it is more of a visual aid this way.0375

And you can look at each report by clicking on the right end, or you can even use your arrow key on the keyboard to move through the various reports.0385

And it gives you, kind of, a visual of what those reports might look like in the carousel view.0395

So, I want to go back to the grid view, and if I want to go down to look at these views here, I can click on the Contributor Reports on the right.0400

As we discussed, those are the reports that other QuickBooks users have uploaded for our benefit in Industry-Specific.0414

So, here we are, we are in general product based business, and these are some of the customized reports0425

that other QuickBooks users have contributed, so we can look at those, and there is some examples there.0432

There is a Profit and Loss by month. We can look at that, and there is various reports there.0438

So, that, kind of, gives us an idea, an overview on the Report Center, on how to navigate through that Report Center.0443

Now, I am going to go ahead and discuss creating the Balance Sheet Comparison Report.0450

We are going to talk about looking at a specific pre-set report in the balance sheet.0453

So, with that, we are going to understand, or if we click on Standard Reports back to the QuickBooks standard pre-set reports,0459

we can scroll down to the balance sheet area, and there is the balance sheet.0468

and we can look at the Balance Sheet Reports and scroll down to the Balance Sheet Previous Year Comparison Report.0476

And when we click on that, it will pull up...we can highlight it, and we can run it by clicking on the green Run button.0483

It will pull up that particular report for us. I am going to go ahead and close down my Report Center from behind.0491

Since I have that report that I want, I am going to close that Report Center down just so0498

we can see the Balance Sheet Previous Year Comparison Report without any further distraction.0501

So, when we look at that, we can go ahead and see the various balance sheets comparing0507

from 2015 to the current year, 2016, assuming that is the year in which we are working.0513

Now, we have a variety of things. For instance, we have detail, for instance, on our liabilities and other current liabilities.0521

We have our payroll liabilities, and there is a detail accounting of those liabilities.0527

Federal withholding, FICA payable, the Federal Employment Payable, the State Withholding and etc., that the employer is0534

withheld from the payroll of each employee, and those need to go to the various state agencies, our IRS agencies, as well,0542

and, of course, health insurance to the insurance premium that we are providing.0550

And so, with that, if we notice up in the menu button bar of that report, there is a Collapse. This is detailed view.0555

If I click on Collapse, it will go ahead and summarize the sum total of the payroll liabilities.0563

If we go ahead and expand it, it will give us more of a detailed view.0571

So, we can collapse it, print that out, so it is more of a collapse view or less detailed.0576

Or we are going to expand it again, and then, we can look at the report on that direction.0582

So, keeping that display open, now, we can look at the Balance Sheet Report, and we can maybe learn how to filter and do a little bit of filtering.0587

Maybe there is a use on the balance sheet, but we do not want to show the liabilities or the equity accounts on this particular report when0595

we are just going to discuss and analyze our assets, and maybe we want to show that for an analysis review of management or whatever.0604

So, we have a use for that, and we want to filter only the asset accounts in this exercise.0612

So, the Customize this report, that is what we have already opened.0618

Up in the upper left button of the menu button, you might have something that is called Customize Report or Modify Report.0621

Mine says Customize Report. Your version might say Modify Report, but it is the same functionality.0629

So, click on that button that says Modify or Customize report, and that is going to bring up the Modify Report window.0634

We have a variety of options that we can choose on this report, but what we want to do is filter it.0642

We are going to filter only the asset accounts. That is what we want to do.0647

So, we are going to choose the Filter tab, and under the Filter section, we want to make sure the account is highlighted.0650

And then, in the middle section where it says Account, we are going to drop down our Option menu.0659

And you will see that we have a variety of filters that we can choose.0664

We can literally just choose one account and look at that one particular account we like, but in this case, we are going to filter it by All Assets.0670

So, we will choose All Assets there.0678

By choosing All Assets, of course, we are going to be eliminating the liability and the equity accounts in this report.0681

So, at this point, we like what we have, and our filter, we will choose OK.0690

And it is going to refresh that report so that when we scroll down, we are not going to see any liability or equities.0695

What we will see are only the asset accounts.0703

We can still collapse it on a view and look at more of a summary view there, or we can expand it and look at the detail of each items there.0705

So, that is how we can filter our reports.0715

Notice that some of the filters that we are reporting, we can do more than one thing, and it depends what we want to do.0721

For instance, if we look at those filters again, just get an idea of what you actually can do if you filter out an item,0727

and you choose to filter items, you can actually filter the products and services that we offer our customers.0738

So, you can look at certain order sales or purchase orders or sales forms. It is going to pull out just those line items from sales forms or invoices.0745

If we filter through Name, it is going to give us an option of filtering by customer, or we can filter by vendor only or by the employee or other name lists.0758

So, we can actually filter a particular customer or a group of customers or whichever we want.0772

But, that is going to give us an idea how we can filter out just vendors or employees or that, sort of, thing for our reports.0778

If we choose Transaction Type to filter, that is going to help us filter any transaction including invoices,0786

cash sales, statement charges, customer payments, bank deposits, purchase orders or item receipts,0793

bills, bill payments, credit card charges, checks, pay checks and general entries.0801

So, we can filter all these different types of transactions- invoices, payments, etc. So, we can filter every check payable personally.0807

We can look at all bank accounts and every check written or all deposits written or whichever.0817

We can filter that and see directly what we want by transaction.0823

So, that, kind of, helps us a little bit understanding what we can use those filters for and what those filters can be used for.0828

So, at this point, we are going to now talk about saving reports.0835

Once we have a report, we want to save it as a portable document format, a PDF, and that is very helpful.0838

So, when we do a period of reporting, we might want to take a snapshot of that.0847

And we can actually save it as a PDF, e-mail it to management or other concerned parties in our business, so we are going to learn how to do that.0851

So, we are going to go ahead and with this report still open,0859

we are going to choose up here under the File menu with the report open, we can say Save as PDF.0864

Under the File menu, when we choose Save as PDF, it is going to pull it up and gives an option of where to save that file.0878

So, at this point in time, we can go ahead and type in whatever we want to call it, Balance Sheet, Assets, etc., and we can name that file.0885

At this point, I am not going to go ahead and save it, but you can see where you can save it in any directory.0895

You can choose on your desktop or a business file that you have on your computer.0901

Normally, I would hit Save at this point, but at this point, I will not save that.0906

But, that is how we can save that as a PDF file, and QuickBooks will automatically save it as a PDF, so that is what we can do there.0909

From this point, I am going to go up to Window and close all my windows so we can go on to our next section of our lesson.0917

And we are going to talk about creating and customizing a sales report.0924

Now, sales reports is vital to our business, of course. It is the lifeblood- sales.0928

So, there is a variety of reasons and reports that we want to look at our sales to see where we need improvement in our business.0933

So, to create a sales report, again, I am going to use the Menu button.0941

Instead of going to the Report Center, I am just going to go straight to the Sales area under the Reports menu.0947

And from here, I am going to choose Sales by Customer Summary, so I am going to choose Sales by Customer Summary in the submenu.0953

It is going to pull up a report of the sales by customer.0962

So, here I can see all the different sales that we have had for a given period of time in our date section.0967

Now, this is a month-to-date period from December, and assuming that today is the 15th of December, 2016, it is giving me, kind of, a month-to-date default.0974

So, let’s say we want to go ahead and change that date and customize the date.0987

So, under the Date option where it says this month-to-date, we are going to drop down that menu, and we can actually choose a custom date.0992

So, go to the very bottom of those options and choose Custom, and if we hit tab, it goes into the first date field.1002

And at this point, I can say January 1st of 2016, let's say, and then, I want to do January 31st, 2017, OK?1010

So, if I type in January 31st, 17. It will give me a full year. Actually, I am going to...yes, so it gives me, kind of, an idea there.1028

Let me just do the one month for the 16th of January 2016. We will go back to that direction, just the one month.1040

So, January 1st, 2016 through January 31st, 2016, so it goes back a little bit.1048

We are going to see all these sales by customer in that given period of time.1055

And so, that gives us an idea of what that is and how we can create the customized sales report.1064

Now, we are going to actually talk about using QuickZoom in a pre-set report. What is QuickZoom?1068

QuickZoom is what some people might call drilling down from a report to get further detail on a report.1074

So, we look at this. When we are looking at any given report, when we highlight a figure in this report, you will notice the icon or the pointer.1081

Your mouse pointer changes to a magnifying glass with a Z, which stands for Zoom.1094

So, if we highlight and position the mouse pointer over, let's say, the first item that says 1999, or in my case, it is Mike Valic for a utility shed of $1999.1099

You can choose anything in your report if it is different from mine.1116

If we double click, when we have the magnifying glass with the Z on it, we double click on that.1120

It is going to pull up the Sales by Customer detail for that, that consists of the 1999 invoice, so we are going to see that this is one invoice.1125

It looks like it is invoice no. 1022, and it gives us further detail of that particular report, and we can see that. It pulls up more detail of that.1134

If we look at this on the detail, we can see certain invoices, and let's look at the detail of this particular invoice.1149

So, I can click on the 799, the bottom, and it will pull up the detail of that actual invoice.1159

It just shows that...it just so happens that, that particular customer only has one invoice for that particular month, but it pulls up the invoice.1168

You will notice that QuickBooks stamps in a Paid and when it was paid on that particular invoice, so that helps us.1176

We can look at the detail of this invoice and what it consists of and how we invoice them and when we did that.1184

At this point, we can go ahead and close all our window, so I go up the window and close all for that.1189

Just understand that in Reports, you can actually widen or narrow the columns in Reports.1198

If we pull it back up again, go to the Sales Report and say Sales by Customer Summary or actually1207

Sales by Customer Summary report, when we look at that, we can widen or narrow those items.1212

So, If I wanted to widen this, I can put my mouse pointer just over those diamonds where it gives me, kind of, a cross arrows.1220

And if I click on it with the left mouse button and drag it, it will make that column a lot larger.1228

So, I am happy with the size of that, so we will make it smaller there.1234

That is just a few items that you can customize those things with your Reports.1239

Now, we are actually going to learn how to save report settings and create memorized reports in groups.1246

Once we like the particular customized reports that we created, we can actually memorize those in groups and assign those.1255

For instance, we might have some year-end reports or month-end reports whatever that we want to run every year.1263

Maybe our accountant says "Hey, I need to see a 1099 report, and I need to see some year-to-date figure reports".1270

So, we can actually create a group in our Report section that says "Hey, this is what my1277

year-end report should look like, and this is what my accountant usually wants me to see".1283

So, we can actually create memorized reports and save those for future reference.1287

And then, we do not have to recreate the wheel or reinvent the wheel there.1294

So under our Reports menu, we will notice there is a second item down. It says Memorized Report section.1298

So, under here, we can look at the Memorized Report list, and we will see a listing of all our memorize reports.1304

There are some standard ones that comes with QuickBooks under Accountant and Banking, Customers and etc.1311

And we want to go ahead and create one.1317

So, what we are going to do in the Memorized Report list, we are going to look at the Memorized Report button and choose a new group.1320

So, we want to create a new group, let's say, called Year-end. OK, that is fair enough.1328

A lot of times, we need year-end reports especially for accountants or CPAs.1333

Under the Memorized Report list, down at the bottom, we have our Memorized Report menu option.1338

We are going to click on the arrow, and from there, we are going to choose New Group.1344

Under the New Group Name, we are going to type Year-end. Once we have that typed, we can click OK, and it creates a new group called Year-end.1349

So, now, we went ahead and created a new memorized report group.1358

Now, we can start adding reports to that, and we can memorize pre-set reports for it.1364

So, from this point on, now, that we have our new group called Year-end highlighted in there,1370

we are going to go ahead and create a new one that says Income Tax Summary.1377

So, we are going to go ahead and run a report and memorize that, and we are going to memorize this particular report.1383

One of those things is going to be the report Income Tax Summary.1389

So, when we are going to click on Reports under the top menu button, and we are going to go down to accountant and taxes.1393

And down here at the very bottom, second to the last, we are going to see an Income Tax Summary report.1401

So, we will click on that, and it will run this report and gives us an Income Tax Summary report1406

that might be very helpful to our accountant who is going to run our taxes for us.1412

So, we notice that it is running a particular year for the full year, January 1st through the 31st of that year of December.1417

So, there, now, we have the report, we want to memorize this report.1427

The next section we are going to do now is we are going to go up to the menu Report bar.1430

And you will notice, there is a button up here that says Memorize.1436

So, click on the memorize, so it is going to remember this report.1439

And at this point, we want to leave the name as is, but we are going to save it and click on the option that says Save and memorize report group.1443

So, we are going to check that. Notice, we can assign it to any group we want.1454

At this point, we want the top one that says Year-end.1458

Click OK, and you will notice that it just added under Report Year-end. Out of the Memorized Report, it added Income Tax Summary Report.1462

So, that, kind of, helps us there.1472

I am going to go ahead and close this particular report, and now, we can learn how to add reports to those memorized groups.1474

So, once we have a particular group created - Year-end Report group - we want to add some reports to it.1484

For instance, we already have a 1099 Summary report. If you do not have a 1099 Summary report in your listing, I will show you how to add that.1493

You go up to the Vendor menu. We want to run the 1099 summary report.1503

So, we will go down and say Print or /efile 1099, and we can find the 1099 Summary Report there.1508

We will click on that, so it will run the report for us.1518

It is giving us the same full year in which we are supposedly working in 2015, and from here, we will go ahead and memorize that.1521

This has already been memorized, but if you memorize it, you can just save it and then, click OK, and it is already memorized for me.1530

So, that just gives you an idea on how you can run your 1099 Summary report. Mine is already on the listing.1540

And to move it, if I want to edit that Memorized Report, I can choose the Memorized Report, and I can say edit this, and I can save it in a particular group.1546

And if I click on the check mark that says Save and memorize report group and assign it to Year-end, it will move it.1559

Or the other way, I can move the diamond underneath the Year-end. I should be able to move that.1567

And if I left click on the diamond, when I highlight the mouse pointer over that diamond next to the left 1099 Summary, so I get a little cross arrows.1576

If I left click that and drag my mouse to the right just under Income Tax and under Year-end, it will assign it to the Year-end Memorized Report group.1589

And so now, we have that 1099 and Income Tax Summary under Year-end Reports.1601

We can go ahead and add another one so you get a little help there.1607

Let's run another report we want for Year-end. Maybe, we want Balance Sheet Year-end.1612

We want to see what our year-end balance sheet is, so under the Memorized Report list, see if we have it here.1617

I do not see a Balance Sheet Year-end, do you? I do not see it, so I am going to run that report.1625

If you have a Balance Sheet Year-end report, you can choose it and drag it up to the Year-end section, or you can click on memorized report and edit it.1631

At this point, I am going to run the Balance Sheet Year-end Report by clicking on Reports, go to Company and Financial1639

and go down to the Balance Sheet Report, and I will run the balance sheet standard report.1649

And I will make sure that it is year-end, so I will choose the date.1657

Once I have the report up, and I change it to 12-31-2016 for this year...1661

Actually, I am going to choose it for this 15th because I think everything else is for the 15th.1670

So, I can change the date to be year-end for the current year, and then, I will click on Memorize that report.1675

And I am going to save it under Year-end. It will add that.1683

Now, I have it saved. I want to save the name, so I am going to change that.1686

Now, it says saved. Well, I wanted to save Balance Sheet Year-end, so I am going to highlight that report,1689

go down to Memorized Report, edit Memorized Report, and I can change the name to Balance Sheet Year-end Report.1696

Click OK, and now, I have that, so I can run my reports by double clicking anything. It gives me the year.1706

And I have the consistent year for all those reports under the Year-end Report section, OK?1713

So, that is how we can add those reports to Memorized Report groups. It gives us the idea on how we can display those.1723

Anytime we want to display a report, we can highlight it. We can go down to Memorized Report.1731

And we can edit it or we can double click on it in which it will display that report for us anytime we like.1737

Or if we even highlight it once, we can just click on the Display at the menu button down below. It will display the report.1746

That is the end of this lesson on how to create and customize pre-set reports in QuickBooks.1755

Thanks again for joining us here at Educator.com. We will see you next time.1761

Educator®

Please sign in to participate in this lecture discussion.

Resetting Your Password?
OR

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Membership Overview

  • Available 24/7. Unlimited Access to Our Entire Library.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lecture slides for taking notes.
  • Track your course viewing progress.
  • Accessible anytime, anywhere with our Android and iOS apps.