Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Where do you manage your open
windows
|
1. Window Menu Cascade,
Horizontal, Vertical
2. View Menu
|
3
|
State the steps to customize
your icon bar and add a calculator with two separators after it
|
1. View Menu --Customize icon bar (ribbon)
– Add
2. Right click the icon bar and then Add or customize it from there
|
4
|
What are the steps to select cash or accrual basis and by default which is chosen
|
Edit Menu – Preferences – Reports and GraphsCompany Preference Tab – Cash basis.
By default it is on
Accrual.
|
5
|
Where is the balance sheet
reported
|
Reports Menu -- Company financials -- Balance Sheet
|
6
|
To see a journal entry for a
saved transaction
|
1.
In any form highlight press Ctrl-Y
2.
Right click to select the journal entry
3.
Edit Menu – New General Entry – Back Arrow
|
7
|
How to make a backup copy
|
File menu – Create backup
|
8
|
How to close Quick Books
|
1. Press on the X on the top right corner Or
2. File menu - Exit
|
9
|
How to open QuickBooks for
previously opened company
|
File menu – Open Previous - Company
|
10
|
How to Create a New Company in
QB
|
File – New
Company –Follow the Instructions
|
Lesson 2
Q
|
Details
|
A
|
Opened after
Running QB Program
|
||
1
|
Set up a new company file under
your name “student Arts”
|
File – New
Company – Enter Company information -- Follow the Instructions
Choose one of
three options Express Start 2. Detailed Start
3. Create
|
3
|
Use Retail
Shop or Online Commerce as your industry
|
|
4
|
Select sole proprietorshipwith January as
the start of its fiscal year
|
|
5
|
Do not use a password
|
|
6
|
You sell both services and products
|
|
7
|
Record each
sale individually and you do
not sell online products
|
|
8
|
You charge sales tax
|
|
9
|
Use the registration number 123456789
|
|
10
|
Yes to create estimate in your file
|
|
11
|
Chose the preferences:
Billing Statement: No
Progress Invoicing: Yes
Managing Bills: Yes
Do not Print cheques? I print cheques
Inventory: No
Do you accept Credit Card? No
Track time: Yes
Employee: No
Track Multiple Currencies: No
|
|
12
|
Select 01/01/2014
as your start date
Adjust your chart of accounts as
you see fit for your business and report on
changes
|
|
14
|
Proceed with the banking balance
of $8,359.00 on 12/31/13
|
|
15
|
Additional Task: You may do it now or
You may choose to do it later
with transactions input time.
|
Setting up Customers list
Setting up Vendors list
Setting up Account
Setting up Items
|
Lesson 3
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Create a new expense account
Advertising 1with a subaccount Advertising 1 cost, S for tax code
|
List – Chart of Account – Account -- New
|
3
|
Edit the subaccount to read
Advertising cost
|
List – Chart of Account – Highlight the Account – Control E or Edit.
|
4
|
Add your name for a new customer
use any address information.
|
Customer Menu – Customer Centre –
New Customer and Job or Control N -- OK
|
5
|
Additional information:
industrial type
|
Click Additional Information Tab to check; If
no Click Define Field (to add this field) -- OK
|
6
|
Payment settings: $3,000 as credit limit and
1 10% net 30 for payment terms
|
Click Payment Setting Tab and fillthe requirement-- OK
|
7
|
Create yourself as a new
employee use sin number 111 111 118 and use date
of birth 07/18/82 and fill any address Use
today’s date as the hire date
|
Employee Menu – Employee
Centre –New Employee fill the information in 5 tabs-- OK
|
9
|
Select your name for a new
customer. Create a new field for “twitter account”
|
Customer Menu – Customer Centre –
New Customer & Job – Additional Information tab – Define field -- OK
|
10
|
State how to merge two vendors:
|
Vendor I con, locate the two
account needed to be merged, select theVendor Nameone
needed to merged in to an-other vendor and edit it. In the field of Vendor
Name enter the name in which this account will be merged into and then
enter as that name appears in the field as you start typing -- OK
|
Lesson 4
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Write a cheque to the order of The phone company for a value of $100.choose the appropriate expense
account if necessary
|
Banking Menu – Write Cheques – Fill requirement– Save n Close
|
3
|
Transfer $4,000 from the Chequing to Saving account
|
Banking Menu – Transfer Funds – Fill requirement– Save n Close
|
4
|
Reconcile Chequing Account in the ending balance
-94284.67 for the month of November 2014. Bank Charges is 14.
|
Banking Menu
– Reconcile --Take the Reconciling Balance of
last month. The book balance is there for you only bank
needed. Take the Closing balance of the
Bank Statement-94,284.67. Input Bank Charges 14and Interest
Earned. Mark Tick toall the Cleared
Cheques for November 2014. The balance
should be zero that means it is reconciled. Make
General Entry for Charges
&Interest Earned.
|
5
|
Explain the procedure for the
bank reconciliation in details
|
Same as above
|
Lesson 5
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Enter $90
vehicle fuel charges using credit card – visa with
“S” in tax field
|
Banking Menu – Enter Credit Card Charges – Make
selection n fill in the requirements– Save n Close
|
3
|
Reconcile credit card visa account in the
ending balance type $4,845 and select all
entries before 31/12/2014
|
Banking Menu – Reconcile Credit Card –fill in
the requirements after selection
|
4
|
Pay by cheque (pay “Visa Credit
Card”) your credit card - visa bill
|
1. Banking Menu – Write Cheque –fill in the requirements after
selection – Save n Close
2. Vendor Menu -- Pay Bill – make Visa as Vendor– Save n Close
|
5
|
Create Fixed Asset “Van” and set up the accounts to track amortization on the new Van. Record asset’s cost for
$28,000
Record $1,200
for amortization
|
List – Chart of Account – Account –
New – Fill in the requirement Fixed Asset Van Control Account and Cost sub account of Van, Amortization
sub account of Van too. Or go through Accountant
Menu – Make a General Entry. – Save n Close
|
Lesson 6
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
On 31/12/2014,
White Ridge Company wants to bill Mr. Roy
Uchman: 2nd story who expects to pay later an amount of $600, Invoice
number 22. In template field selectIntuit Service Invoice. Items:
02 Site Work 1 item and finished renovation 1item and
G in the tax column.
|
Customer Menu
– Create Invoice – Make Selection and Input Requirement -- Save
n Close
|
3
|
Show the steps to review the
above journal entry
|
Customer Menu
– Create Invoice – Previous Invoice Arrow -- Close
|
4
|
Memorize the
invoice twice a month frequency
|
Customer Menu
– Create Invoice – Previous Invoice Click Memorize – Make Selection – Save n Close
|
5
|
Create a new service item: Plumbing 1 subunit of Pluming repairs and mainte-nance. $65
rate and S for tax
code and construction income for the account field
|
List Menu – Item
List – Item New – Make Selection and Input Requirement -- OK
|
6
|
Create a new price level: commercial
2 which give a decrease of 11% on price. Select your rounding method
|
List Menu
–Price Level List – Make Selection and input requirement --OK
|
7
|
Create a sales order for Mr. Roy Uchman items: Lighting retail: Table
Lamp for 1 unit and tax column G.Create an invoice from that sales order.
|
Customer Menu
–Create Sale Order – Make Selection and Input
Requirement – Make Selection Create Invoice – Save n Close
|
Lesson 7
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Create
yourself as a new customer and record a new job and name it “Pub” with credit
terms of $5,000
|
CustomersMenu – Customer
Centre – New
Customer & Jobs – Make Selection n
enter requirement -- OK
|
3
|
You are going
to pay White Ridge Construction a cheque number 655 having an amount of
$3,500.
|
CustomersMenu – Receive
Payments– Make Selection n enter
requirement –Save n Close
|
4
|
Record
receiving a payment fromRajyaguru, Kamlesk: Tea and Crumpets Room, a cheque
#400 for a value of $11,000 but refund the remaining amount after completing
the payment for invoice # 11.
|
CustomersMenu – Receive
Payments– Make Selection n enter
requirement –Save n Close
|
5
|
Make a deposit
for all un-deposited funds but preserve $600 for petty cash fund.
|
Banking Menu
– Make Deposits -- Save n
Close
|
Lesson 8
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Adjust PMT terms for vendor :Dobson’s
Exteriors to 1 % 10 net 30
|
Vendor Centre – Highlight n double click required Vendor -- Payment Setting Tab –Payment Terms
|
3
|
Enter a bill for Dobson’s
Exteriors with a date of 22/12/2014, amount of $1,000 in the Amount Due
field. Use the account of Maintenance and Repairs, use S tax.
|
Vendor Menu
-- Vendor Centre – Highlight n double click requiredVendor -- New Transactions –Enter Bills --– Make Selection n enter requirement –Save
n Close
|
4
|
Pay Bill on 31/12/2014 with
discount
|
--
New Transactions – Pay Bills
–- Make Selection n Pay Selected
Bills–Save n Close
|
Lesson 9
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Create a Memorized Report group
and call it Year End 2014
|
Reports – Memorize
Report - Memorize
Report List – New
Group –Enter Name – Click Ok.
|
a. Inside the group place P&L Standard,
|
Report --Company
n Financials – P&L
Standard – Memorize –Tick Save in Memorized Report Group – Make
Selection and Click OK.
|
|
b. Export the report into Excel
|
R --C
n F – P&L
Standard – Click Excel–Create New Worksheet – in new
workbook -- Click Export.
|
Lesson 10
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Create 3 Inventory items:
a. Inventory Name: A1, A2 and A3
b. Type: Inventory Part
c. Subunit of Materials Heading: Cabinets
d. Cost 100
e. Markup on cost 20%
f. Tax field: G in both areas
g. Income Account Field: Construction Income
h. Reorder Point: 5
i.
On hand: 10
|
Lists – Item
List – Item -- New –
Setting up Mark Up
Edit – Preferences
– Time n
Expenses – Co.
Preferences – Enter Markup –OK
Enable U/M
Single U/M Per item – Length – Meter
Make Selection n enter
requirement –OK
|
3
|
Create a Purchase order for 6 (2 A1, 2 A2, and 2 A3) items
from Barata’s Building Supplies
|
Vendor – Create
Purchase Order --Make Selection n Pay
Selected Bills–Save n Close
|
4
|
Set a single unit of measurement
(Meter) for the three units
|
Lists – Item List – Activities –Build Assemblies– Edit – Unit of Measure – Single --Save n Close.
|
5
|
Receive the Purchase order without bill
|
Vendor – Receive
Items -- Selection –Save n Close.
|
6
|
Receive the bill
|
Vendor – Enter
Bill for Receive Items -- Save
n Close.
|
7
|
Adjust inventory due to the fact
that 1 A3 unit Lost
|
Lists – Item List – Activities –Adjust Quantities -- Make Selection n enter QTY Diff–Save n
Close.
|
8
|
Create an Inventory Assembly Item call it: API.
a.
API Include 1 A1, 1 A2, 1 A3
|
Lists – Item List – Activities –Build AssembliesMake Selection n enter–Enter Cost after getting Total Bill of Material Cost – OK – Enter Q to Build Save n Close
|
Lesson 11
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Make sales tax payment for the 3rd
quarter (file taxes and pay if necessary)
|
Sales Tax– Manage Sale Tax -
Choose Receiver General - OR
File Sales Tax
Click the Receiver General
Select the Quarter
Enter Tab to Refresh
Click File return
Q How
would u like to file your return
Select Paper not
Online
Click Continue
Q would
you like print?
Click Yes to See the
Print Preview
Select Preview
Do not Print
Go to Lists – Chart of
Account –Chequing Account
Checking : from Chart of Account Chequing
Vendor: Receiver Payment
Customer: or A/R Receiver Payment
|
Lesson 12
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Make sure your payroll is setting is on.
|
Edit – Preferences – Payroll &
Employees – Company Preferences –QuickBook
Payroll Features - On
|
In the Employee
Defaults Information set the “Use time data to create pay cheques”
|
Preferences – Employee Defaults -
Use time data - On
|
|
In the Item
Name Column choose Performance Bonus for a value of $60
|
Earning – Item Name – Bonus – Rate
60
|
|
Set a new
weekly Payroll Schedule with 12/31/2014 as the pay period end date
|
Employee – Payroll
Setup – Add or Edit
Payroll Schedule – Payroll
Schedule – New – Enter Requirement - OK
|
|
Create new
Employee and enter all the
following details:
a. Employee First Name: Yours Last Name: Yours
b. SIN No: 111 111 112 not 8
c. Date of Birth: 07/18/83
d. Gender: Male
e. Address field: 389 go Street
f.
City, Province, and Postal
Code fields: Vancouver, BC T3P 5P3
g. Main Phone: 604 555-5896
h. Fax: 604 555-5874
i.
Hire Date: 11/29/2014
j.
Rate = $20 / hour
k. Pay schedule: weekly
|
Employee – Employee
Centre – New
Employee – Enter Requirement - OK
|
|
Run payroll
schedule for weekly employees specifically (employee just created) with 25
hours on 12/31/2014
|
Employee – Pay
Employees – Schedule
Payroll – Make Selection – Continue – Create Pay Employee – Make Selection – Print pay cheque from Quickbook.
|
|
Create the pay
cheque
2-
View it
3-
Pay your
payroll taxes from 12/01/204 to 12/31/2014
|
Lists – Chart
of Account– Chequing
– Check
Report – Employee
– PD7A Report to check how much
Employees – Payroll
Liabilities - Pay
Payroll liabilities – Make Selection
– Review – Continue OK
|
Lesson 13
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Turn on
estimates and progress invoicing option if necessary
|
Edit - Preference
- Job &
Estimates – Company
Preference - Selection
Yes for Do you create Estimate?Do you doProgress Invoicing?
|
3
|
Create a new
job for Uchman Roy call
t job 1
|
Customer Centre – Select Customer – Add Job -- OK
|
4
|
Create an estimate
on this job:
Item: Direct
Labour: Demolition Labour
Quantity: 10
Rate: 40
|
Customer Centre – Create Estimate – Enter requirement and Save n New
|
5
|
Duplicate this
estimate and add Item: Heading: Cabinets Wall Unit
Quantity: 6
]Markup 10%
|
Go back to the Previous
to make duplicate and add added requirement- save n close
|
6
|
Create an
invoice for this customer from the first estimate
Recording only
50% work done
|
Go back to the Previous
to make Invoice and create
Invoice- save n close
|
Lesson 14
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Turn on Time
Tracking Option if necessary
|
Edit – Preferences
– Time &
Expenses - Company
Preferences – Select
Do you track Time. Yes
|
3
|
On a weekly
time sheet Select Carol Walker from Dec. 8 to Dec. 14, 2014 to perform a work 8 hours on Monday
and 8 hours on Tuesday for Uchman Roy: 2nd
Story
|
Employee- Enter time - use weekly time sheet – Mark
billable
|
4
|
Create invoice
for the customer for the above. date it 12/31/2014
|
Create Invoice – Customer name – select the job – Save n
Close
|
5
|
Create a new Service item call
it Planning 1
Cost: 15,
Selling Price: 60 with G for the tax fields and Cost COGS use
Construction income account
|
Lists – Item List – New –
Enter requirements- ClickOkto
save
|
6
|
Record non-employee
time worked and choose: Rick’s Plumbing
Service Item: Direct Labor Plumbing Labor
Customer Hellin Hilda: 600 SQ Ft Additions
Type 8 in the
duration, date it 12/31/2014
|
Employee – Enter time – Time Single
Activity – Enter requirement and save and
close
|
Prepare his
cheque
Cost 100
and G for Tax
|
Banking – write cheque – select
Vendor – pop up and select and pay
|
Lesson 15
Q
|
Details
|
A
|
1
|
Select and open qblesson.qbb
file.
|
Opened after Running QB Program
|
2
|
Create a new invoice template
|
Lists – Template – Template – New – Make
Selection Invoice – OK- Manage Temple – Name it
|
3
|
Call it HW
template
|
Make Selection under company and Transaction Information
|
4
|
Add Phone
number and E-Mail Address features
|
Layout Design - Make sectiontion
|
5
|
Add the Ship
to feature on screen and on invoice and Due Date feature
on screen only
|
Column Tab – make selection – Change Order
|
6
|
Add Service
Date column on screen and on print and let it be the last
in order
|
Column Tab – make selection – Change Order
|
7
|
Change the “TOTAL” to read “TOTAL
AMOUNT”
|
Footer and
make selection and change
|
8
|
In the layout Design Move the
Title “Invoice” from top right to top center location change width if
necessary
a. Justify it center in both horizontal and vertical
b. Use double line pattern for border
c. Use Times New Roman for the font
d. Save and backup to present your work
|
Click Layout Design –
make Movement -
Properties - select – Centre for both
Border tab
– select – double line
|
No comments:
Post a Comment