WORKIN

G WIT

H LISTS

PR

ES

EN

TE

D B

Y Q

UA

L I TY

AC

CO

UN

TI N

G

SO

L UT

I ON

S

CONTACT INFOVicki Borror

618-978-8558www.QualityAccountingSolutions.com

VBorror@QASVB.comMy job is helping people with their QuickBooks & accounting problems.

QASQuality Accounting SolutionsHave a MBA and BS from SIUeAdvanced certified in QB by IntuitLecturer at SIUeHelp businesses de-bug their QB and accounting processes

CLASS FLOW

Using Premier 2013 Accountants copy Will have Q&A at end so please post questions Recorded session & slides will be posted.

ONLY 1 QB FILEYou should only have 1 QB

company per legal structure or tax id.

Do not mix legal entities.Can track parts of a business using

Classes.

TIPS & TRICKSBackup, Backup, Backup!!!! – Best not to do the backup on the same computer. o Offsite is the best solution.o If not, use a thumb drive or external hard

drive that is stored offsite.

TIPS & TRICKSSample companies are provided with the software and are great resources to try new setups or journal entries. You can also restore a backup of your company, with a different name, to use for experimentation.

ACCOMPLISHMENTS

Create and work with Lists Chart of Accounts Customers & Jobs Vendors

USING QUICKBOOKS LISTSQuickBooks lists organize a wide

variety of information, including data on customers, vendors, inventory items, and more.

Lists save you time by helping you enter information consistently and correctly.

SAVING TIME

Such as:Names, addresses, and other information about customersContact information for vendorsDescriptions and prices for products and

CHART OF ACCOUNTSThe Chart of Accounts (COA) may

be accessed from:Company menuHome screenLists menu

COA - CREATE NEW ACCOUNTCan create\edit\delete accounts by

using:Edit menuRight clickingAccount menu in the COA window

Need to know the type of account it is.

COA - SUBACCOUNTSUse Subaccounts to group accounts

that go together and where you want to have a subtotal:

InsuranceBuilding Insurance

Liability Insurance Do not book to the

Health Insurance heading account

COA - DELETING ACCOUNTSYou can only delete an account if it has NEVER had any activity posted to it (even if by mistake).Make it Inactive so it can no longer be used.This also applies to Customers & Vendors

COA - SAME NAMESHave 2 accounts that are the same

thing?Merge them by renaming one to the same exact name of the other.Answer YES to the merge question.

This also applies to Customers & Vendors

COA - REARRANGINGRearranging the COA will also

rearrange how they appear on the PnL.

Move them by clicking on the NAME or TYPE heading or dragging them.

COA - REPORTINGYou can create a report on any account by selecting it and right clickingSelect QUICKREPORT Can change dates at the top of the

report

This also applies to Customers & Vendors

CUSTOMERSCustomers are who pay (write the check to) you.Job is the work you are doing for the Customer.

May have several jobs for 1 customer

Do not use OTHER NAME

CUSTOMERS – QUICKADD VS SETUP

Accessed thru the Customer CenterQuickAdd – Name onlySet up – complete information.

Can be used for advertising\client touches

Better billing records

CUSTOMERS - EDITINGThe same rules apply to Customers

as did the COA:Merging namesNo deleting if any activityMake Inactive

CUSTOMERS - JOBSUse Jobs to

Track the types of work or from year to yearCreate job costing\revenue reports

CUSTOMERS - REARRANGING

Can click on the NAME or BALANCE headings to re-sortShow only Active, All, Clients with balances, etc.

This applies to Vendors too

VENDORSVendors are who you pay (give

money to).QuickAdd vs Setup:

Set up needed if going to print checks directly from QB.Do not use OTHER NAME

VENDORS - EDITINGThe same rules apply to Vendors as

did the COA & Customers:Merging namesNo deleting if any activityMake Inactive

CUSTOM FIELDSCustom fields can be added to Customers & Vendors (Items too).Hard to get to show up on reports though.

UPCOMING TRAININGLewis & Clark community College

Godfrey Campus - Benjamin Godfrey Campus 5800 Godfrey Road, Godfrey, Illinois 62035 • 618-468-7000

http://catalog.lc.edu/content.php?catoid=2&navoid=57#Other_Non-credit_Learning_Opportunities

QuickBooks Intro

Using QuickBooks

3

QUICKBOOKS INTROSeptember 30

Efficiently navigate using Toolbars and Home menuEnsure your Company file is set up properly and how to edit itCreate and work with Lists

Chart of Accounts, Customers, Vendors, Items

USING QUICKBOOKSOctober 14

Create Estimates and convert to InvoicesWhen to create Invoices or Sales ReceiptsReceiving payments and making DepositsDo I Write Checks or Enter and Pay billsTracking Credit Cards correctlyBank reconciliation

October 28Setting up InventoryDoing PayrollCreating and customizing reports, exporting reports to ExcelCustomizing forms & writing QB letters