Aaron Woolley

Aaron Woolley

Working With Bank Accounts

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!

Working With Bank Accounts

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
  • Writing a QuickBooks Check 0:30
    • Amount field
    • Other fields
    • Print check
  • Using Bank Account Register 7:40
  • Entering a Handwritten Check 9:45
  • Transferring Money Between Accounts 16:33
    • Funds Transfer Option
    • Transfer with Check Register
  • Marking Cleared Transactions 20:57
    • Bank Statement
    • Reconciliation Summary
  • Viewing Cleared Checks in the Register 27:05
    • Searching for Specific Check Amount

Transcription: Working With Bank Accounts

Welcome back educator.com.0001

We are going to go through the lesson of working with bank accounts.0003

And we are going to teach you how to write a check.0007

And using QuickBooks we are going to teach you how to use the bank account registers.0009

And opening up a register out to enter handwritten checks.0014

And also transferring money between accounts as well as marking clear transactions.0020

And viewing the clear checks and the register.0025

So, in QuickBooks. We are going to go ahead with your QuickBooks open in the sample file.0030

We are going to go ahead and look at the various ways that we can open up your checkbook register and how to write a check.0039

Now, of course, in transactions as I have stated before in other lessons.0048

Everything we do has a financial consequence or a financial transaction attached to it.0052

Every time we drive our vehicle we are using money or gas.0059

Every time we go to the store we have to buy something.0064

We are always doing something on our live that actually has a financial consequence to it.0067

So, with that, QuickBooks helps us to organize it and we are going to use the check writing ability.0074

Checks you can actually purchase. Laser checks and print checks directly from your QuickBooks system.0081

And that is what we are going to show you how to do now.0088

Assuming, that you have checks that can be printed in your printer.0090

So, using the home screen. You can always click on your home screen.0095

And with your home screen you can enter checks that way.0100

You are going to go right into the icon that says write checks.0108

Or you can go up to the banking menu bar and click on write checks.0113

Or from the icon menu you can click on the icon that says check.0120

And as you put your cursor over the icon it comes up write checks.0126

So, we will go ahead and click on that and that it is going to open up a window of writing checks.0131

You will notice that the very first upper left hand corner it is going to show you the default bank account.0138

We can change the bank account if we have multiple checking accounts.0144

Some businesses might have a checking account dedicated for payroll.0149

Some have one just for operating expense and payroll or other uses.0153

In this particular case we only have one checking account.0158

So we are going to leave that as is.0162

It will always show you according to your register what the ending balance is.0164

So that before you write your check you want to make sure you have enough funds to cover it.0168

So, we will see that and we will also notice that we have a couple of options.0173

This does look like a regular check here in the field and just below that we have a couple of options.0180

We can say it is an online payment or to be printed.0186

So, we are going to make sure that to be printed is marked.0191

That means we are writing a check in the system and we are going to print it on a check stock later.0194

So, the first thing we will do is we are going to go ahead and pay a telephone bill.0201

So, we are going to assume that we are going to pay Cal telephone let us say.0208

OK? And it is already in our vendor list.0214

So, once we type in Cal T it prefills it, auto fills it for us and we can hit tab.0217

It is going to say that there are some open bills for this vendor.0224

Which, assuming we have had bills we are going to go ahead and choose discontinue writing a check.0227

Without assign it to that we will go over to the Accounts Payable later and it moves us into the amount field.0236

Here in the amount field we are going to say we are going to pay $156 and 91 cents.0242

We will hit tab and you will notice that there it automatically will handwrite the amount in the amount field for us.0248

It will also pull in from our vendor list the address name and address of that particular vendor that we are paying.0258

We can put down in the memo field that this is for telephone expense or office telephone. Let us say.0266

OK. Now, once we have that filled out.0273

The lower portion of the check writing field is where we assigned the category expense that this item has.0283

So, we can click on the very first item or if we hit tab it will bring us over to that.0292

And we can drop down that menu bar.0297

And there we can actually type in telephone because that is the expense that this vendor is.0300

So, we type in TEL and it automatically pulls up the telephone expense.0307

Or we can choose from the drop down menu and we can hit tab.0311

It brings us over to the amount field.0316

And in the memo field we can always put in an additional memo if we wish.0318

At this point in time we are OK with that. We are going to leave it as is.0322

In these other fields, customer job and billing and class.0327

Customer job, just for your reference, references if we have an expense that were going to assign to a job.0332

For instance, if we are a construction company or a land set company.0341

And we are working on a job and we are paying for supplies for that particular job.0346

We can assign that to a customer that we can bill later.0351

And then there we can assign it to a customer for doing this for family.0355

And then we can bill that expense later into an invoice and we can recoup those expense.0360

So that is a nice way that we can recoup our expenses that way.0365

So, just that is a little side note.0373

Another side note is class of business.0376

We can actually classify this expense as well especially if we are going to bill it later to a customer.0378

We can assign it that this is new construction or remodel or it is overhead expenses.0384

So, we are just going to leave those blank for now.0390

But keep in mind that those are helpful tools that we can use in invoicing and recouping those expenses if they are for a client.0393

This point time we can say save and close and it is going to record.0402

Nice little recording sound. It is going to record that expense.0408

So, there is how we can write a QuickBooks check.0413

Now, that check is actually in there ready to be printed.0418

If we wanted to print it we are ready to print it to our printer and we have checks stocked in our printer.0422

From the file menu we can click on that. We can say print forms and will see checks.0427

We will choose checks and there is a check that we just wrote.0434

Assuming that we are in sequence with our checks numbers.0438

We can make sure that the check number is correct. This is 10080.0443

It is checked. If we hit OK it is going to bring us to a printer.0447

And then we can print it. We are not going to print it at this point in time.0451

But that is how we would print that check. I will hit cancel at this point.0454

So, now if we want to go ahead and move on with the lesson.0460

And say we are going to teach how to use bank account registers and show you how to open up a register.0464

Now, there is various ways of opening up a checking account register or any register in QuickBooks.0472

We can certainly look at the chart of accounts from the home menu or I call it the flowchart.0478

Because it has a nice flowchart of our workflow but over here it has chart of accounts.0484

We also can open up the chart of accounts by going up to lists and choosing chart of accounts.0490

Here it opens up our chart of accounts and we can have a list of everything.0499

It shows all of our banking accounts, our savings accounts etc.0503

We can go ahead and look at the savings account.0507

We can open up our savings account register.0511

And it shows all the items that have been cleared in our bank statement.0514

And the other transferring the funds that we have to.0518

So, if we want to look at the check that we just wrote.0522

Let us open up the check register.0526

So, we will close this particular one down by using the grey X to close this window down.0528

And we will go ahead and double click on the checking account.0535

And we will see that here is our Cal telephone that we just entered.0539

It went ahead and entered in that particular expense that we just entered into.0544

So, that helps us understand where and how are the taxes.0549

So, QuickBooks uses many forms like the check writing form.0553

As we look at that this is a form. An invoice is a form. Statements are forms0557

And every time we use a form it is a nice way that we can enter in the information very visually.0563

But in the background it goes to our register and it enters it into our register automatically for us.0569

So, that really helps us there.0577

So, that is how we open up a register.0581

We are going to show how to enter a handwritten check.0586

For instance, there is many times where you might have your checkbook with you.0590

When you are conducting business and you are on the road.0593

You might go to buy some supplies. You might go to a hardware store, wherever you might be.0596

And you actually handwrite a check and deliver that to the cash register or the cashier at the store.0602

Well, when we come back we have, hopefully. You have used the register in your little checkbook.0609

And you can come back to QuickBooks and enter in the data in your QuickBooks to record that transaction.0615

That is a common thing. Many people do that or write checks throughout the week.0622

And then they choose one day a week to bring in their check register handwritten and transpose it into their QuickBooks.0626

So, the register shows every transaction we have.0636

We are going to get into a little bit later on online banking.0640

And how to pull in the transactions directly from your bank account, online.0643

Downloading those transactions into QuickBooks.0649

That is one way of recording it but the best way I always find is manually making sure it is in there properly.0653

So, that when you download information from your bank it can actually reconcile it rather quickly.0659

So, we are going to go through how to enter a handwritten check.0666

I am going to close this window down so that everything is closed.0670

I go to window manual and I am going to say close all. So, everything is closed.0674

In order to enter in a handwritten check the place we need to go to is the check register.0680

So, to get that as you remember we can either from the home screen use the check register icon.0687

Or we can go up to lists and go to the chart of accounts and find it that way.0697

Or we can go to bank and we can say use register.0703

So, let us just choose that using register.0708

It is going to pull up and ask us which bank capital you want to use.0711

Well, in this case we are going to go ahead and use the check register.0714

Again as we notice in this screen we have our last transaction or check that needs to be printed for the telephone company.0721

So, in this case we are going to go ahead and look at the register.0730

In the very bottom line is a blank line just like you would see in your own bank account.0734

Check register that the bank gives you it is formatted the same way.0740

You have the date on one side. You have an area for your check numbers. You have an area for your payee.0745

You see the account which is the actual expense or category of expense that you have.0754

A memo field, the amount of the payment field and the amount of the deposit field.0759

So, all these up here correspond with each of these rows or items or tab areas here.0765

If you check register payment is up here. Memo is down here.0773

Payee is up here. Account is down here.0777

So, each of these it is a nice little check register.0779

So, in order to enter something we are going to go down to the very bottom of the check register into the open field.0782

We are going to assume that this date is our current date and we will hit tab.0790

Now, it is going to automatically update a check number for us on the next number.0796

So, we are going to put in a check number of 1204 because that is the check number that we have written.0802

And we are away and purchasing supplies we will hit tab into the next field.0808

And we went ahead and we bought supplies at Bayshore office supply. OK?0815

So, we were at the office supply store at Bayshore.0825

We handwrote a check number 1204. We will hit tab and it is going to give us a note.0829

Notice here it is saying hey it is not in the vendor list.0837

We do not have this in the main list. What would you like to do?0841

So, it asks us what we are going to quick add it. We are going to set it up.0844

Will he cancel at this point? We will just go ahead and click on quick add.0847

And it will add it to one of our name lists.0852

Here is the name list that we have to choose from.0855

It could be a vendor, a customer, an employee or another.0857

I typically recommend never using other.0862

Pretty much every individual or company that you are going to deal with will either be a vendor.0865

Someone that you need services from and you are paying services for.0871

A customer, someone who pays you for services you provide and employees, someone who works for you and other.0876

I do not know but pretty much most every person you deal with or company.0884

Will follow on one of these 3 categories and other I do not really see.0889

And I advise not to use that as often as possible but it is there just in case.0894

In this case for Bayshore office supplies is going to be a vendor.0899

We will click on OK and it will automatically add it to our vendor list.0903

Now, as we hit tab it goes directly to the payment field.0909

And in this case we paid $99 and 95 cents for office supplies.0912

We will hit tab and it will bring us directly to the account or category of expense area.0918

And this is where we can drop down the list.0925

Or at this point in time we can actually type in supplies or office supplies.0927

There we go. If we type in office supplies it will bring us directly to that expense category.0935

And we can click on tab and it brings us into the memo field.0940

In which we can say this is what we bought. We bought an office chair.0946

So, we can type in office chair. Once we hit tab it is going to record that particular item for us.0951

And that was Bayshore office supply, up here, check number 1204.0961

It puts it in date order as well as check order number.0968

As you can tell this check number is a lot smaller than these other check numbers.0974

So, these are listed below it and more recent. So, it puts it up there for us.0978

So, that is all done and so now we know how to enter in handwritten checks.0984

The next thing we are going to go through is transferring money between accounts.0994

Now, you might have money in your savings account.0998

You are using money from your checking account to purchase office supplies, to purchase things, pay people, and pay contractors, whatever.1002

But sometimes there is a need where you need to transfer money between your savings and checking account or other accounts.1009

So, we are going to show you how to transfer and record those transfers of funds.1017

First thing I am going to do is I am going to close this window down.1023

So, we have everything clean and fresh. I will open up my home screen again.1027

So, what we can do in transferring funds is a couple of ways to do it.1031

We can actually do it directly from the check register. OK?1038

Or we can go up to banking and choose the transfer fun option and this is the easiest way to do it.1044

So, I will show you this way method first then I will show you how to do it in a check register.1052

And I will show you how to fix it.1057

So, first thing we are going to do is we are going to click on banking from the banking menu.1059

We will choose transfer funds. It brings up a window or another form that we can fill out.1064

The date. We are going to assume this is the correct date as of today's day December 15, 2016.1073

And the next thing we are going to do is we are going to say.1081

We are going to transfer funds from our checking account into our savings account. OK?1084

Now we want to see let us say we want to transfer a $5000. OK?1094

So, this is what we will do. We are transferring $5000 from our checking account to our savings account.1103

Once we do that we can say save and close. It is all correct and say save and close.1113

It says you are transferring funds between two accounts.1121

The online transfer check box is not selected.1124

This means the transfer will not occur only in your company file. It will only occur in your company file.1126

You should make sure that it has been done in your bank file as well. It is what they are telling us.1133

That is fine. It has already been done in our bank. OK?1138

So, sometimes we can go ahead and make sure that is done our bank account and most of times we go to our bank.1142

We write out a check from our checking accounts and say deposit this into my savings account.1149

And this is what we have just recorded.1153

To check that we are going to look at the check register.1156

We will look at our checking account and we will see that we have this.1160

We wrote a check of $5000 to our savings account and it says it is a transfer.1164

So, this gives us an idea and it tells us exactly what type is.1171

We can also record it directly here if we want it to by saying.1175

Let us say I am going to make a $1000 transfer to my savings account.1181

So, under the payment amount I would put that $1000 in there.1185

And then I would drop down the expense menu and I could say savings and choose that savings account.1191

It automatically says transfer and I can just say I put the reason in additional funds transferred.1198

OK? And hit tab. It will record that as well.1211

So, here it is. Here is the 2 ways.1213

One was using the funds transfer option field.1215

Or we can go directly into the check register and we can enter it that direction.1219

I am going to go ahead and remove this particular transfer that I did just now of a $1000.1226

I put it in. it is a mistake so I will show you how to delete that.1232

I am going to highlight that transaction. I am going to go up to the edit menu and I am going to say delete or void.1236

At this point I will delete it. It was a complete mistake and I will delete that just for this purpose here.1245

So, that is how we transfer funds between accounts.1252

Now, we are going to go ahead and show you how to reconcile your bank account using QuickBooks.1258

Now, of course after we utilized QuickBooks we are putting in all these transactions.1264

We are entering in handwritten checks.1268

We are entering in information from our bank account. We are downloading information.1271

All sorts of transactions are occurring in every month. We get a bank statement from our bank.1277

The most important thing you can do in your business.1283

Do yourself a favor and reconcile your bank every month.1286

If you can actually reconcile things online, keeping track of it on a daily or weekly basis.1291

That is better for your financial health.1297

So, what we are going to do is utilize our QuickBooks to help us with this.1299

It is a much easier function to do using QuickBooks to reconcile rather than completely manual.1304

Once we get in the mail we will get our bank statement every month.1312

Usually around the 5th or by the 10th of the month we will get the previous month transactions or the banks statement.1318

So, there is several ways of us running our bank statement and in reconciling that.1325

We can choose from the home menu our reconcile button or we can go up to the banking menu item and choose reconcile.1331

When we do that and click on reconcile it pulls up the reconciliation module.1340

With a nice little form and says which account we are going to use.1346

We can choose which bank account we are going to reconcile.1348

We can do credit cards. We can do all sorts of things.1352

Right now we are going to go ahead and reconcile our checking account.1354

With this we are going to make sure that we have from our bank statement.1359

We are going to put in an amount of 15.304 and 57 cents.1363

And if you have kept up with the lessons it should work with this.1371

But we are going to put in a service charge of $14 with a service date of 12-15-2015.1375

We are going to make sure that the statement date is 12-15-2015.1382

We are going to assign the service charge that the bank charges us of $14 to bank service charges.1387

Now, with this, once that is done we can go ahead and put in an interest earn.1395

If the bank gave us interest on the service date at the same time, 12-15-2015, and assigns that to interest income.1399

At this point our bank does not give us much interest at all or do they?1406

So, we will go ahead and click OK.1410

From here when we have our bank statement in front of us.1412

I always recommend going by line, item by item and making sure it is on the bank statement.1416

Whatever is on the bank statement we want to check off on our QuickBooks.1422

So, these deposits are on our bank statement.1427

So, we are going to check those off and we are going to go through each one and we are going to check them off.1431

And we are going to check on this bank transfer and we are going to check it off.1434

We are going to check on all this things and we will check them off.1441

The transfer money here, the $1000 here, deposit etc.1445

The only ones we are not going to record are the items of 12-12 beyond. OK?1450

So, we do not have those. We will go ahead and check all of these.1458

We will notice all this checks that we have written. We are going to look at it by check number.1464

We can sort this trough anyway we like.1468

If we do not want to do it by check number we can do it by dates.1472

OK, or we can do it by check number and it is going to list the items first that are here.1477

Now that we have 12-15 these things were automatically done assuming from our bank.1482

So, we will check those. We are going to check everything here on this.1488

So, we will make sure we say mark all and I want to make sure I uncheck these 12-12 here, beyond here.1493

Ok, actually it is beyond 12-12 these deposits here.1499

So, when I make sure everything is exactly as it should be on my bank statement.1506

And it is checked off and cleared with the checkmark from our bank statement meaning it cleared the bank.1510

So, we are going to go ahead and put a checkmark next to those transactions.1518

That means that it has been cleared through the bank.1522

When we look at our bottom right corner this the most important thing we want to look for is that everything was cleared.1526

Our ending balance in our bank statement according to this little sample is 15.304 and 57 cents.1534

And we cleared 15.304 and 57 cents worth of transactions.1541

We have put a checkmark next to those transactions which equaled 15.304 And 57 cents.1546

The difference is zero. If we do not have a zero difference then there is a problem with our reconciliation.1553

Assuming that we did it correctly and you are following along.1561

Then we just go ahead and say reconcile now.1565

And we bring it to the next window after it reconciles and it says you want to print the reconciliation?1569

Yes, we normally want to print it.1577

At this point we will just display it and it will go ahead and display it.1579

That was just a quick little error message for Adobe.1583

But it pulls up our reconciliation summary and the other one that we get is our detail.1586

And it lists all the cleared transactions.1594

And then it lists the transactions that have not been cleared on our register.1597

So, it will show us our bank balance and it will show us our actual register balance.1603

So, here is our bank balance. Our bank shows 15.304.1610

We have some deposits in transit that have not hit the bank yet or it is not on the bank statement.1614

So, therefore our actual register balance is the 41.000.1620

Now, we are going to go ahead and show you how to view the cleared checks in the register.1624

Once we go ahead and clear out all the items that have been cleared through the bank.1629

We can actually look for those.1635

So, using QuickBooks we can open up our check register.1637

I am going to menu and choose use register or check from our home menu. The checks register at the bottom.1642

We are going to look at the checking account and we will choose OK.1652

From here we will notice that all these items have been cleared and marked.1655

But let us say we want to go ahead and find a particular amount that we entered.1660

We are looking for say $500 or $5000.1666

We can go up to the go to button in the upper left corner of the check register.1671

And it will give us a nice little search.1679

From here we can search for any particular name. Let us say we want to look for the Cal telephone.1681

And we can say go back and I will go back to the most recent or we can go back to the last time we have paid him.1688

And go back and keep on hitting back and it is going to highlight each time we have paid Cal telephone.1694

OK and it will show each check throughout the year. If not we can choose other things.1700

Let us say we want to find a particular amount.1708

We cannot remember who we have paid it to but it was $500.1710

So, we can go to go to. Which field? We can say the amount and we are going to search for $500.1713

Go back to the most recent $500. There is the deposit or maybe there is a check.1723

Oh, there is a check that we have paid to Washout a and son painting for $500. OK and so forth.1728

So, we can look for things of that nature. So that kind of helps us there.1735

OK, so that is how we can certainly look for specific transactions that we like.1740

Thanks again for using educator.com. We will see you next time.1747

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.