Aaron Woolley

Aaron Woolley

Analyzing Financial Data: Printing, Exporting, and Quickinsight Graphs

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: Printing, Exporting, and Quickinsight Graphs

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
  • Printing Reports 0:17
    • Preview Before Printing
  • Processing Reports in Groups 3:38
    • How to Run Reports in Groups
    • How to Display All Reports in a Group
  • Exporting Reports to Microsoft Excel 7:15
    • Purpose of Why People Export To Excel
    • Sending the Report to Excel
    • Formatting Options
    • Changing Filters
    • Choosing and Changing Different Filters
  • Creating Quickinsight Graphs 17:51
  • Creating an Income and Expense Graph 18:41
    • How to Create the Graph
    • How to Read the Pie Chart
  • Customizing Graph Data 24:16
    • Choosing by Customer Instead of Account
  • Using Quickzoom with Graphs 25:10
    • How to Zoom on a Particular Customer
  • Customizing How Graphs Display 28:31
    • How to Change Graph Into 2D

Transcription: Analyzing Financial Data: Printing, Exporting, and Quickinsight Graphs

Welcome back to Educator.com0000

In this QuickBooks lesson, we are going to discuss analyzing financial data, printing, exporting and quick inside graphs.0003

The first thing that we are going to talk about now is reporting or actually printing the reports that we have generated.0011

It is a simple process, but we need to go over it so you understand.0017

The previous lesson, we discussed how to generate reports, how to generate the standard reports that comes with QuickBooks,0021

how to customize those reports and make them a little more meaningful for our business.0027

In order to print a report, let's pull one up.0033

The first thing we are going to do is we are going to the Report menu, and by selecting Reports from the Menu bar,0035

we are going to choose just a standard balance sheet at this point in time, so we will just say a Balance sheet summary.0042

So, I will choose the balance sheet summary by clicking on Reports, go into Company and Financial and clicking on Balance sheet summary.0050

It pulls up the standard balance sheet in summary, and at this point in time, I am going to change the date to be at the year-end for this current year.0058

So, under the As of and the date, I will pull down the little icon that has a little calendar to it.0066

And I will select the 31st of December, and I will click on Refresh. Now, I have the year-end report here for a summary of balance sheet.0071

Notice that it does give us the assets that will equal the total liabilities and the equity.0083

QuickBooks does a fantastic job in keeping things balanced and making sure that that balance sheet is balanced.0088

If there is an item that is at a balance and your assets and your liabilities and equity do not balance, there would be something wrong with your file.0094

And it might be a corrupt file, and then, a pro advisor or a QuickBooks professional will be able to assist you in getting that corrected.0102

But, typically, QuickBooks does a fantastic job. I have never seen anything where it goes out of balance.0111

But, if that does occur, then, QuickBooks has a solution for it in their technical support.0117

So, here, we have our balance sheet, and in order to print it, the first thing that we will do is we will notice up in the Menu bar in our Options,0123

within the report, there is our customized report where we can filter items and customize our report and to make it a little more meaningful for us.0130

We can memorize a report, or we can print it, and at this point, we are going to choose the Print option.0140

And within Print, we can actually print it from it and go directly to a printer.0146

I am going to choose Preview, so I can see what it looks like, so I will select Preview, and there is my report.0149

Notice that when I am in the display of the body of that report, I have a magnifying glass with a plus sign in it,0157

which indicates that if I click on it, it would zoom it in or my options above, I can print from it, or I can zoom in, ask for help or close the report.0166

At this point, I am going to click Zoom in. It zooms into the reports.0175

So, now, I can see it a little more legibly, so I can see what it looks like and how it is going to print.0181

If I am satisfied with that, I will go ahead and simply select the Print button. It will print in my printer.0186

At this point, notice the magnifying glass has changed, and now, it has a minus sign inside it.0193

So, if I click on the minus sign, it will resume back to the full screen. I am happy with that.0199

Assuming I printed it, I will go ahead and close it, and now, it goes back to the Print report screen, and I will close that, too or cancel it.0205

So, now, I have done my print on the particular report that I wanted to display.0212

The next section we want to discuss now is processing reports in groups.0219

We have discussed how to create certain reports that might be required by our accountant for taxes.0224

Or maybe a month then, we want to have a series of reports that we conclude at the end of each period0230

or at the end of each month that we might want to have to keep track of our business, sales reports.0236

There might be P&L reports. There might be balance sheet reports.0241

There might be inventory reports. We might have expense reports.0245

We might want to have various or a variety of reports that go into an analysis that management would use.0250

So, at this point, assuming that we have maybe at year-end, we have a certain number of reports.0259

Many times, our accountant will require these reports for us in order for them to prepare our taxes.0265

So, keeping that in mind, 12 months goes by, and after you have created all these reports,0271

if you were on top of things, you would have memorized those reports, put them into a category under the Memorized Report group,0278

and then, you would not have to think about it. The next time, you could just run them.0286

So, assuming we want to run these reports at year-end in a group, we do not have to regenerate them by searching through reports.0290

Under the menu list, we will choose Reports.0298

And again, maybe our accountant is looking for a P&L and a balance sheet and a sales reports or inventory reports, your 1099 reports.0302

So, instead of searching for all these different reports and remembering what the accountant needs,0310

if we rememorize those reports and put it in a list, for instance, Year-end, then, we can print those reports all at once, so let's do that.0316

Under the Reports menu, we are going to choose Memorize reports, and choose the Memorize Report list.0326

Under the Memorize Report list, we will see all the various reports that we have generated and put into groups.0331

In this option, we have all these different year-end reports.0338

We have the balance sheet year-end report, an income tax summary and a 1099 summary that let's say our accountant requires for taxes.0344

At this point in time, we have looked at it, and if we click on Display, we will have all of those reports...0352

After we have highlighted Year-end, if we click on Display, I will do that one more time.0362

If we highlight the group Year-end, and we click on Display, it shows us all of those available reports in that group that we can choose to display or print.0366

At this point in time, we can all leave all of those three reports with a check mark on them, and we can either print them, or we can display them.0377

At this point in time, I would go ahead and display and boom. It will generate all three reports at once, so that we can get all those reports.0387

And from here, we can review them, make sure they are correct and print them.0396

Change the date if we need it to be the end of the year etc., and we have all of those reports generated all at once.0401

And we do not have to have that accountant bothering us and pestering us to get the data that they require, so they can file those tax returns.0409

At this point in time, I will go ahead and close all my windows.0420

So, now, that we have learned how to process through those reports in groups and printing those reports - excuse me -0425

the next thing we are going to talk about is exporting those reports to Excel.0433

Excel is a wonderful tool. If you are familiar with it, wonderful.0440

If not, I suggest getting to know Excel a little bit better because you can manipulate and customize your data in many other ways better.0445

This could be very meaningful and helpful to your business, so we are going to discuss how to export the data or reports to Excel.0455

Now, a lot of times, we might want to be able to sort our data in a different way.0464

We might want to sort it by name. We might want to sort them in more complex ways than what QuickBooks might allow.0472

So, using Excel will help us to manipulate that data into a little more meaningful operation for us, so we can get better management decisions.0480

How to send a report to Excel: the first thing we want to do is we are going to go ahead and look at that.0493

We have various features within Excel that we can utilize.0499

For instance, there are some defaults that we can do in QuickBooks that when exporting to Microsoft Excel, we can utilize this default.0504

There is an Autofit. It sets the column widths in Excel wide enough to display your data without it cutting off words.0514

There is Freeze panes. It allows us to scroll through the data while keeping the row and headers viewable.0520

And there is grid lines. We can turn off the grid lines with an Excel or not.0527

And so, we can customize it that way in viewing, and it can customize our data.0531

We can also have a report already memorized in Excel, and when we run new data, we can actually update that report using Excel.0541

So, first thing that we want to do is we are going to send a report to Excel, so let's get started.0550

From the Reports menu, we want to make sure that we are going to choose Company and Financial.0554

And we are going to choose the Balance sheet standard report. That gives us more detail than the summary.0559

At this point in time, I am going to keep the data, I guess, at 12-15. That is fine.0567

It is the current time, and we are going to modify it just a little bit, so we will sat Customize that report.0571

We are going to add a couple of things. The thing that we are going to add is we are going to look at the dollar change under the Add subcolumns for.0580

We are going to click on the previous period, so we want to see a dollar change and a percentage change for the previous period.0590

So, we are going to look at the current period. Then, we are also going to compare it with the previous year of that period.0598

So, we want to see that, and we will click on OK.0604

At this point now, we have customized this balance sheet to include the current year and then, the previous year's numbers.0608

And then, we can see the dollar change and percentage change, so we can see that our cash on hand has actually increased by 57.9%.0618

Our accounts receivable has increased to 154.9% and etc.0628

So, we can, kind of, look at that. Luckily, our liabilities have only increased by 9.5%, or actually that is our total assets.0633

But, we can see where we are at with our business. When we look at accounts payable, that has increased significantly etc.0643

So, we can, kind of, get an idea where we are at and how we are changing in the balance sheet.0649

But, with this data, we can go ahead and export it to Excel and get some more options for us.0654

Now, we have our report, and you will notice up within the Report are Report headers or Report options:0664

Customizing the report, Share template, Memorize, Print, E-mail and Excel.0671

So, when we drop down that menu for Excel, it gives us a couple options.0678

We can either update an existing worksheet if we have already run this report, or we can create a new worksheet.0682

At this point, we are going to go ahead and create a new Excel worksheet.0688

When we get to the next screen, it is going to give us some options.0694

Again, it gives us the other option. It is either Update an existing workbook or Create a new worksheet within a new workbook.0701

We also have other options where we can update an existing worksheet,0710

replace an existing worksheet, create just a CSV file or a Comma-Separated Value file.0714

And then, we have some advanced options. At this point, we are going to choose Advanced options and look at what we can do.0720

Here, we want to make sure that we have our formatting options done properly.0727

We want to see that there are colors within our formatting. We get a little fun with colors.0733

Under the Excel options, we want to make sure that Autofit is selected. We want to make sure the Freeze pains is selected.0739

We want to show the gridlines within Excel. We want to make sure that, that is selected, so we have those items there.0749

Autofiltering is something that I prefer to have on as well as include the QuickBooks export0756

guide worksheet with helpful advice, so you could read through that, as well.0763

It is a helpful solution there. With this, we can go ahead and click on OK, and here, we can click on Export.0767

QuickBooks will now launch Microsoft Excel so that we can utilize those functions.0781

Now, it has our Excel, our report here in Excel. It is the same report if we go back to our QuickBooks, there is the report.0788

And now, we go to our Excel, and it is the same data just in a different format, so it should look similar to this.0801

Your screen should look like this if you have Excel. If you do not have Excel, just follow along with us.0810

And when you do have Excel, you can utilize these features.0818

So, we have that there. If we wanted to save the report, we could choose Save from Excel, in File, Save and save it there at this point.0822

So, that is how we could go ahead and choose our...oops. That is how we export the data within Excel.0834

Next, we are going to go ahead and continue on with that, and we are going to talk about filtering a report and using Excel.0848

And, here, we have all the data here, and in Excel, we can look at the different0854

dropdown options because we went ahead and said we want to do the filtering.0859

Under the Advance tab within QuickBooks to export to Excel, we wanted that dropdown filters.0863

So, here, we have a dropdown arrow, and we can go to the Dollar change column and drop that arrow down.0870

And we can notice that we have some options. We have all these different dollar figures here.0879

In the Dollar change field, we can go ahead and get to the greater than feature, or we want to select maybe a ten of an option here.0885

We can, sort of, from largest to smallest, or we can choose different dollar values.0896

If we can look at it, we do not want to see blanks maybe. We want to remove the blanks.0903

We do not want to see blanks. We can look at things at an inch.0908

We can also sort it and say we want to see only...maybe we just want to see things that are greater than zero.0914

So, if we want to sort this and just see values, a dollar change value that is less than zero, we can say Less than zero.0924

Let's go here, and we can say Less than, so we can choose Microsoft Excel version 2010.0934

When we say Number filters, we can choose the Less than option, and under the dollar change is Less than.0943

We can just type in zero, click OK, and now, it just gives us a dollar change of anything less than zero.0952

So, it gives us that. It sorts our report to say dollar change is less than zero.0961

It gives us an idea of how that works, and we can make it our data that way, as well.0968

If we want to look at a different, maybe, percentage change, we can clear that filter out by choosing the dropdown menu, go into our Number filters,0973

unchecking that box that says Less than and clear that out and click OK, and it brings it back to our...let me get back here select All here.0981

If we select All, it will give us everything again, so we are back to normal by selecting All.0998

So, by dropping out menu down, selecting All, it brings us back to normal, and we do not have any further filters.1004

If we want to filter just a percentage change, we do not want to see things that are less than zero.1013

And on that, we can do the same thing by going to the Percentage change, go to the number filters and say Less than and say Less than zero.1020

It will give us similar information, OK?1032

In order to clear that, in the Percentage change file, we will choose the dropdown menu, choose Select all, click OK, and it will give us everything again.1035

Everything you will notice if you drop it down again that Number filters is not selected again.1045

So, we can manipulate our data, look at things and analyze it in different ways.1050

At this point in time, we are going to close down Excel, and we will go ahead and not save the report. I will close this down.1056

It will say Do you want to save? And I will say Don't save, so it is going to close it down.1064

The next thing that we want to talk about now is creating quick insight graphs.1072

Now, QuickBooks has a feature where we can actually graph some of our data and display it in a graph mode, which is rather helpful.1078

We can look at income and expense graphs. We have sales graphs.1088

We have accounts receivable graphs. We have accounts payable graphs, net worth graphs.1092

We have budget versus actual graphs, so we can look at our data and a graph will go stand point.1098

And that, kind of, gives us a better picture sometimes versus just looking at plain numbers black and white.1105

If we see it in a pie chart or a bar graph, it can, kind of, see where the trends are, and we can draw a line on that.1110

The first thing we want to do is we are going to create an income and expense graph.1120

At this point, I am going to go ahead and close all my windows down by clicking on Window and selecting Close all. Then, it will close all my windows down.1123

Now, let's go ahead, and let's look at suppose our business, we want it to be very profitable.1131

We need to keep track and keep an eye on our expenses.1138

So, we should be able to be especially concerned with the proportion that we are spending relative to the income that we receive.1141

A lot of times, if you are at a business, that you are doing jobs, and each job has cost related to that job,1148

that you might want to look at that job and see how much you are actually making.1155

Are you making a profit on that particular job or not?1161

A lot of times, people are not paying attention to that, and when they get into the numbers,1163

they realize that they are actually spending more money trying to make that money.1167

And so, it is not very profitable, and they are not bidding things properly.1171

If you are earning $20,000 in income, and we do not want to spend $30,000 in expenses for that, so we want to keep it within budget.1176

So, let's go ahead and create an income and expense graph, so that we can see things visually.1185

From the Reports menu, we are going to go down to Company and Financials.1190

And we will notice towards the bottom, we will see an income and expense graph.1195

So, we click on that, wa-la, it is going to give us a report with the pie chart and a bar graph.1200

And it is going to give us our income in green and our expenses in red.1207

And we can see where our expenses per period are really lining up and how we are doing.1210

In this case, this business is increasing in their revenues, and their expenses are increasing, as well, and we have a little trend analysis for that.1217

If you look at that, also, you are looking at just those periods within the year.1226

But, your pie graph is only showing a certain number of your expenses because it is not large enough to create all the categories.1230

So, you can actually go to the next group.1241

If you will notice, within this report, this bar graph, we have various options up here, and you will see it says Next group.1244

Over here in the specific expenses are related out, and they are pied out here.1252

And the key is on your right, so it says Job expenses, Payroll expenses, Cost to get sold, Insurance, Automobile, etc.1259

So, you can see the Automobile expenses right here, and we have our tools and machinery in red,1266

which is this little sliver over here, our utilities, this tiny little blue sliver over here.1273

We have this little pink one. This is printing and reproduction with the tiny little sliver over there.1278

So, it, kind of, gives you an idea in a pie chart where everything is, but the other expenses here is 81%.1283

So, let's go to the next group, and it will show us additional.1292

Here is depreciation expense in relationship to these items, as well, and this is the next group of expenses within that percentage there.1295

So, we have our expenses, kind of, broken out.1306

So, I always find that the bar graph gives us a nice trend and see where we are1311

at in growth and income and in our expenses in relationship to that net income.1317

And it looks like we are getting a little more profitable here as we have higher volume, so that is our quick insight in income and expense graph.1321

The features in QuickBooks, quick insight graphs or various reports here.1333

Every graph window except for the net worth and the budget versus the actual graphs1340

shows a bar graph on the top, a part of the window and a pie chart in the bottom.1345

The bar graph will usually show the totals for both income and expenses, and, of course, the pie chart breaks it out by expense category, and that is nice.1350

And that is expenses. We can always choose down at the bottom, it has an income tab.1366

So, if we click on that, it will just show us income, what our income is broken out as in more detail.1371

Still, it gives us the same bar graph, but the pie graph gives us a little more detail in that we have construction income, which is 99.06% of all income.1378

There is reimbursement income, other income and interest income, and of course those are the tiny little slivers that we see over here in this pie graph.1389

So, that pie chart, kind of, breaks down those income and expenses.1396

That is helpful if we have various revenue streams. This could be a nice visual for us to break that down because these are smaller categories that we have.1403

We do not have as many as the expense categories are shown here.1413

Every graph has a button bar up above that we can click to customize a graph, and we can choose it by class, by customer.1419

We can look by account etc. by date. We can change the dates.1428

We can customize it to get a better picture of our pie graphs, OK? Oops, here we go, get back there.1432

So, that is our quick insight graphs, and we are going to now, kind of, look at customizing graph data at this point1446

in time now that we have created an income and expense graph, and we can see what those look like.1457

Now, we are going to talk about customizing graph data when we have that data in there, so let's list that down.1462

Being back in QuickBooks, we are going to close this particular report down.1471

And actually, I will just keep this one up since we are going to be using this one. Keeping this report up, we can choose it by customer.1477

For instance, let's look at the graph data, and we can choose the customer. Right now, it is by account.1486

We can say it by customer by clicking on the option up there, the upper left.1492

By customer, it will give us an overview of the income and expense by customer, and it will give us more data with that.1497

So, that customizes it for us, and if we wanted to zoom in on any one of these months,1505

we can choose and say "Well, this was a pretty good month here”, and I can double click on the expense here.1510

And it should open up a little more detail for me as our system is way laid.1516

So, now, it will give me a graph of just that particular period of time.1524

By double clicking on that, it will see what my expense summary is etc., the overhead or the 100% on that.1528

So, that is a helpful little tool, we can zoom in, and anywhere we see that magnifying glass with that Z, it will zoom in on us.1535

And it will give us the further detail. We can do it by class, as well in the quick zooms.1543

So, as we see, that using quick zooms and graphs, it gives us the idea and more information if we can see that.1551

The next thing we want to do is we are going to go ahead and look at the display sales for Anton.1563

So, we are going to pull up more of a zoom on a particular customer here.1569

By customer, we will click on that, and we will look at just a particular customer for a month, and we will try to find that.1576

I am going to go to June and double-click on my income and see where we are at with that.1589

And here, we have in June, I have a variety of customers for income, so if you choose in June,1597

that might give you the same graph that breaks up the income by various customers.1604

I am going to choose Chris Baker here since he is a larger portion, or I can even look at Jennifer Ron at 67%.1611

So, let's look at Jennifer Ron right now. I will double click on Jennifer Ron, and it will pull it up.1620

And I can see the detailed transactions for her and the invoices that we have sent out to them or to Jennifer Ron.1626

And we could see how that income is broken out on a more detailed display.1637

Then, if I am curious about a particular invoice, I can go ahead and find that invoice, double click on in, for instance, on this 12,000.1643

I can see it. It has been paid.1650

And I can see the details of what that invoice is all about that we did some floor plans, installation and labor etc. and removal.1652

So, that gives me a detail of that particular customer.1661

If I want to look at another one, I will find down here Jeanette Mimeo, the red one. I will double click on Jeanette.1664

It will give me the detail of the invoices and income that we generated with this particular individual.1671

Or I can look at the individual invoices from here, too.1677

This is a credit card charge that they were able to pay their bill with.1682

So, that gives me a little further information on that, and I can see how they have been paying their invoices there.1689

The next point, that is how we can quick zoom on graphs just like any other report that quick zoom is available.1700

And we can utilize that to our best ability.1707

The next thing we are going to talk about is customizing how graphs will display, and we can look at them in 3D or 2D.1710

At this point, we are looking at 3D graphs, but we can actually change them into maybe a 2D.1719

Maybe this does not give me all the slivers that I need on this particular graph, so maybe I want to look at it in 2D rather than in 3D.1726

So, in order to do that, I need to go to my Preferences.1733

So, I am going to choose from the Menu bar the Edit function and go all the way to the bottom to Preferences.1735

And under Preferences, I can go down here and see on the very left column where Reports and Graphs is, and I can click on Reports and Graphs.1744

And I will notice that I have drawn graphs in 2D as an option on the upper right section.1754

So, I will choose that, and it will give me a 2D graph, so I am going to click OK. It will change this graph to 2D.1762

Now, I can see those slivers a little easier since there is more information, more data, smaller items.1771

I can see those smaller slivers in here a little more clearly, and it gives me a better view of that.1779

In the 3D mode, it was harder to see these other smaller income clients.1785

So, that is how we do that in Displays.1792

This is QuickBooks reporting, displaying, printing, the quick insight graphs.1797

I hope you enjoyed this, and we will see you again next time at Educator.com.1805

Thank you for visiting.1809

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.