QuickBooks fast track trainingTime # 16 hours

Done By :Firas AL-RamlyQuickBooks Premier Reseller

Jeddah-Saudi Arabiafnramly@alraqeem.com

M:+966 506623491

Open new company & customize it

• Open new company (File New company)– Sample

– Express Start

– Detail

• Icon Bar (View)– Hide/Left/Top

– Customize icon Bar

– Add reports/Screen to icon bar

• Edit – Preference– Enable Account Number

– Enable Cost center

– Press enter to move between column

– Show default date today/last day in transaction

– Show lowest account only

– Default 30 days for payee bill

– Enable tax (on/off)

– Enable foreign currency

– Change color of screen

QuickBooks Chart of Account types

Balance Sheet

Asset

BankOther Current AssetARFixed AssetOther Asset

Liability + Equity

AP

Other Current LiabilityLong term liabilityCredit CardEquity

Profit & Loss

IncomeCost of good SoldExpenseOther IncomeOther Expense

COA

• Accrued

– Salaries Accrued

– Vacation & Tickets

– Audit

– Zakah

• Prepayment

– Employee loans

– Prepaid Rent

– Advance to supplier

Money-Out

Expense Item

ExpenseStationaryOffice supplyEmployee loans

• Stock/service items– Buy stock item for selling

purpose

– Buy Service Item for selling purpose

PrepaymentPrepaid rentPrepaid medical insurance

Fixed AssetCreate PO assetRecord Asset

Supplier Name: Manart Stationary

Invoice# AD-1202

Net 75

SN Description Qty U. Price Total

1 Ink 85 10 100 1,000

2 A4 10 44 440

3 Stapler 10 56 560

2,000

Employee: Ahmed Abdullah

We issue a check#50050 from SAMBA amount 10500 as loan deductable every month 500

Employee: Yousuf Ali

We issue a check#50051 from SAMBA amount 60000 for annual house rent

Employee: Ghada Nasr

We issue a check#50052 from SAMBA amount 60,000 for kidz school fees

Prepayment Rent

Cost Center Yearly Amount Claim Date

Hail 50,000 Jan/2012

Riyadh 200,000 Feb/2012 – Two payment

Jeddah 150,000 Feb/2012 – Two payment

Makkah 60,000 March/2012

Bupa Medical Insurance

Firas AL-Ramly 10,000

Ahmed Saleh 12,567

Ezzat Abdullah 23,000

Yousu Ezz 22,500

Abdullah 10,500

Nasser ALHoui 5680

84,247

Fixed Asset

Date of Purchase

Vendor Asset Description Cost

14/01/2012 Shaker LG Split 50,000 Units 12,000

14/01/2012 Shaker LG Split 50,000 units 12,000

20/02/2012 PC Time DELL 710 4gb ram/ 2 TB 12500

15/05/2012 ALJ Toyota Hilux 2012 – TGN 2000 75000

Stock

Supplier Date Desc Cost QTY Selling

BDLINV#300

12/05/2012

Dell R710 8250 20 12000

BDLInv#450

20/05/2012

Dell 780 2850 50 3020

BDLInv#560

31/05/2012

Inspiron 2420 25 2920

MutwaliInv#uey345

5/06/2012 SamsungLED 40” HD

4000 30 4500

Desc Cost Selling Price

Server Installation - 2000

Home delivery/Ahmed Ali 30 50

Shipping/Aramex 20 75

Support - 200

Services

Money In

• Invoice • Sales Receipt

Desc QTY U.Price

R710 1 13500

Inspiron 4 3300

Dell 780 3 4000

Client Name: Educon Inv#100010/June/2012 Total invoice = 35400

Desc QTY U.Price

R710 1 13500

Server Installation

1 2000

Client Name:ROMCO Inv#100111/June/2012 Total invoice = 15500 Net 30

Desc QTY U.Price

Inspiron 4 3300

Shipping 4 0

Client Name:ROMCO Inv#100212/June/2012 Total invoice = 13200 Net 30

Description QTY U. Price

Inspiron 1 0

Client Name: Ring Road Est Inv#100312/June/2012 Total invoice = 0Net 30

Description Qty Estimated Cost Estimated Revenue

Consultant Fees 5 - 50,000

R710 10 82,500 120,000

Inspiron 100 242,000 290,000

Dell 780 100 285,000 302,000

Client Name: Ministry of information Rabigh Project

Description QTY U. Price

Consultant Fees 1 10000

Client Name: Ministry of information Inv#1004Rabigh Project12/June/2012 Total invoice = 10,000Net 30

Other topics

• Memorized Transaction

• Reports

• Bank Reconciliation

• Fixed Asset

• Payroll

• Security• Add role

• Add user

Reports

• Balance Sheet

• Profit & Loss

• Profit & Loss by class

• Profit & Loss by month

• Profit & loss compare to budget

• Budget performance

• Cash Flow

• AR Aging

• AP Aging

• Inventory valuation summery

• Open sales order

• Open Purchase order

BILL

2.EXCEL

2.EXCEL

BILL

QuickBooks ShortcutsNew Ctrl + N

Edit Ctrl + E

Delete Ctrl + D

Lookup Ctrl + L

Use it Ctrl + U

Insert line Ctrl + Ins

Delete Line Ctrl + Delete

Memorize Transaction Ctrl + M

Memorize Transaction list Ctrl + T

Write check Ctrl + W

Chart of Account Ctrl + A

Invoice Ctrl + I

Journal Voucher Ctrl + Y

Quick Reports Ctrl + Q

Customer Center Ctrl+J

Help

• Learning Center

• Manual Documnetation– http://support.quickbooks.intuit.com/support/Articles/INF12758

– http://enterprisesuite.intuit.com/everythingenterprise/training/basic.jsp

– http://enterprisesuite.intuit.com/everythingenterprise/index-logged-in.jsp?rmid=25786_001_VPEM3FSPActive&rrid=43062311

• F1 Help

• Google search

• Youtube/ Facebook /twitter

• Books