QuickBooks Procedures - QuickBooks - Introduction



QuickBooks ProceduresMary Ann WallnerEmail: walln003@alumni.csusm.eduTelephone: (760) 809-7831Table of Contents TOC \o "1-3" \h \z \u Dealing with NSF Checks PAGEREF _Toc353726122 \h 6In QuickBooks, you can deal with NSF checks in either of two ways: PAGEREF _Toc353726123 \h 6Entering Statement Charges PAGEREF _Toc353726124 \h 6Creating Statements for Customers PAGEREF _Toc353726125 \h 6How to generate a statement to account for the NSF Charge PAGEREF _Toc353726126 \h 6How to create the NSF Item PAGEREF _Toc353726127 \h 7How to record the NSF fee and check in the bank register PAGEREF _Toc353726128 \h 7How to record the NSF check in your checking register PAGEREF _Toc353726129 \h 8How Enter a Statement Charge for the Customer’s NSF Fee PAGEREF _Toc353726130 \h 8How to create a statement to send to a customer PAGEREF _Toc353726131 \h 8Writing Off Bad Debt PAGEREF _Toc353726132 \h 9Treating Bad Debt as a Discount PAGEREF _Toc353726133 \h 9Using a Credit Memo to Write Off a Bad Debt PAGEREF _Toc353726134 \h 9Create New Expense Account in Chart of Accounts PAGEREF _Toc353726135 \h 9How to create the Bad Debt Item PAGEREF _Toc353726136 \h 10Creating the Credit Memo PAGEREF _Toc353726137 \h 10Setting Up and Managing Classes PAGEREF _Toc353726138 \h 11Changing the Preference to use Classes PAGEREF _Toc353726139 \h 11Set Up the Class List PAGEREF _Toc353726140 \h 11Apply a Class to an Invoice PAGEREF _Toc353726141 \h 11Add a Class to an Existing Invoice PAGEREF _Toc353726142 \h 12Running Class Reports PAGEREF _Toc353726143 \h 12Creating an Estimate and Progress Invoices PAGEREF _Toc353726144 \h 13Create a Job for a Customer PAGEREF _Toc353726145 \h 13Create an Estimate for a Job PAGEREF _Toc353726146 \h 14Converting an Estimate to an Invoice PAGEREF _Toc353726147 \h 15Create a Progress Invoice Based on an Estimate PAGEREF _Toc353726148 \h 15In QBs you can pass onto the Customer/Job the following costs: PAGEREF _Toc353726149 \h 16Preparing for Job Costing: PAGEREF _Toc353726150 \h 16Instructions for Adding a New Customer/Job PAGEREF _Toc353726151 \h 17Additional Information Tab PAGEREF _Toc353726152 \h 18Payment Info tab PAGEREF _Toc353726153 \h 18Job Info tab PAGEREF _Toc353726154 \h 19Methods of Entering Time PAGEREF _Toc353726155 \h 19Instructions for Tracking Mileage PAGEREF _Toc353726156 \h 21Instructions for Paying Bills PAGEREF _Toc353726157 \h 24Terms PAGEREF _Toc353726158 \h 24Understanding Payment Terms PAGEREF _Toc353726159 \h 24From the Vendors Center PAGEREF _Toc353726160 \h 24Instructions for Appling Discounts or Credits to Bills You Pay PAGEREF _Toc353726161 \h 27Applying a discount to a bill payment PAGEREF _Toc353726162 \h 27Applying credits to a bill payment PAGEREF _Toc353726163 \h 27Instructions for Creating Invoices with Billable Costs PAGEREF _Toc353726164 \h 28To do this task PAGEREF _Toc353726165 \h 28Set a preference for how to handle billable time and costs in the future PAGEREF _Toc353726166 \h 30Remove a cost from the list PAGEREF _Toc353726167 \h 31Jobs & Profitability Reports PAGEREF _Toc353726168 \h 32Job Estimates Reports PAGEREF _Toc353726169 \h 32Job Costs & Bills Reports PAGEREF _Toc353726170 \h 33Pricing Levels PAGEREF _Toc353726171 \h 34Fixed Percentage Price Levels PAGEREF _Toc353726172 \h 34Per Item Price Levels PAGEREF _Toc353726173 \h 34How to Create or Edit a Price Level PAGEREF _Toc353726174 \h 34Using Price Levels PAGEREF _Toc353726175 \h 35Setting Up and Managing Inventory PAGEREF _Toc353726176 \h 36Turn On the Inventory Feature PAGEREF _Toc353726177 \h 36Creating Inventory Items through the Item List PAGEREF _Toc353726178 \h 36Inventory Item Steps PAGEREF _Toc353726179 \h 37Creating a Purchase Order PAGEREF _Toc353726180 \h 37Receiving Shipments against Purchase Orders with a Bill PAGEREF _Toc353726181 \h 38Receiving Shipments against Purchase Orders without a Bill PAGEREF _Toc353726182 \h 38Including Expenses on a Bill for Items PAGEREF _Toc353726183 \h 39Adjusting Your Inventory PAGEREF _Toc353726184 \h 39How to make an Inventory Adjustment PAGEREF _Toc353726185 \h 39Activating Sales Tax and Setting Preferences PAGEREF _Toc353726186 \h 40Some Concepts PAGEREF _Toc353726187 \h 40Enable Sales Tax PAGEREF _Toc353726188 \h 40Sales Tax Items PAGEREF _Toc353726189 \h 40Procedures PAGEREF _Toc353726190 \h 41Multiple Jurisdictions PAGEREF _Toc353726191 \h 41Customers and Items PAGEREF _Toc353726192 \h 42Putting It All Together PAGEREF _Toc353726193 \h 43Paying sales tax PAGEREF _Toc353726194 \h 43Instructions for Removing Unpaid Invoices from QuickBooks PAGEREF _Toc353726195 \h 45Ways to use a pending sale PAGEREF _Toc353726196 \h 45Ways to Reverse Pending Option PAGEREF _Toc353726197 \h 45Reconcile Credit Cards PAGEREF _Toc353726198 \h 46Performing Account Reconciliation PAGEREF _Toc353726199 \h 46Enter a Bill for a partial Payment on the Credit Card Account PAGEREF _Toc353726200 \h 46Petty Cash Account PAGEREF _Toc353726201 \h 47Instructions for Opening the Petty Cash Account PAGEREF _Toc353726202 \h 47Funding the Petty Cash Account PAGEREF _Toc353726203 \h 47Instructions for Funding PAGEREF _Toc353726204 \h 47Entering in Petty Cash Expenditures PAGEREF _Toc353726205 \h 48Set Up Fixed Asset Accounts PAGEREF _Toc353726206 \h 49Create the Fixed Asset Account and Subaccounts PAGEREF _Toc353726207 \h 49Create a New Fixed Asset Item PAGEREF _Toc353726208 \h 49Record a Depreciation Transaction PAGEREF _Toc353726209 \h 50Memorize a Depreciation Transaction PAGEREF _Toc353726210 \h 50Setting Up and Working with a Long Term Liability PAGEREF _Toc353726211 \h 50Fund the Long Term Liability Account PAGEREF _Toc353726212 \h 50Write a check for the Down Payment PAGEREF _Toc353726213 \h 51Look at the Effect on the Fixed Asset Account PAGEREF _Toc353726214 \h 51Set Up a Loan in the Loan Manager PAGEREF _Toc353726215 \h 51Memorizing a transaction PAGEREF _Toc353726216 \h 53How memorized transactions work PAGEREF _Toc353726217 \h 53Using a memorized transaction PAGEREF _Toc353726218 \h 53Entering a transaction from the Memorized Transaction list PAGEREF _Toc353726219 \h 54Customize Your Reports PAGEREF _Toc353726220 \h 55Add a Filter PAGEREF _Toc353726221 \h 55Change the Font and Number Formatting PAGEREF _Toc353726222 \h 56Creating a Simple Report on Invoices PAGEREF _Toc353726223 \h 57Setting Up Users for a Company PAGEREF _Toc353726224 \h 58Set Up an Administrator PAGEREF _Toc353726225 \h 58Add a User PAGEREF _Toc353726226 \h 58Dealing with NSF ChecksIn QuickBooks, you can deal with NSF checks in either of two ways:You can re-invoice the customer, although this is not the preferred method if the original transactions involved sales tax. (because you would have to back out the tax out of the related liability account)You can also generate a statement for the customer, which does not affect sales or sales tax reports.Entering Statement ChargesIf you decide to enter a charge for a customer without producing an invoice you can use the Accounts Receivable register window. It is important that you choose the correct customer to whom you wish to apply the charge. Any transactions entered in a customer’s account receivable will show up on statements that you print for them.Creating Statements for CustomersThere are many opportunities in which you may want to send your customer a statement rather than an invoice.You may have one customer that has many jobs and you want to send them an itemized statementSending out itemized statements at the end of the year to make sure your records match your customer’s historyHow to generate a statement to account for the NSF ChargeCreate an Other Charge item for the NSF service charge (see below example)Records the bank’s NSF fee in your bank account register (use “bank service charge” as the account)Records the NSF check in your bank account register (indicate the customer/job as the payee and accounts receivable as the account).Enter a statement charge for the customer’s NSF feeSend the customer a statement that shows the NSF check and feeHow to create the NSF ItemClick the Items & Services icon in the Company center of the Home PageClick the Item Menu button and choose NEWChoose Other Charge as the typeTap TAB and type NSF ChargeTap TAB and then type Non-Sufficient Funds Service ChargeTap TAB and fill in the AMOUNT OR % (example $35.00)Tap TAB and then type “n” to choose Non as the Tax CodeChoose Other Income as the accountClick OK to create new itemHow to record the NSF fee and check in the bank registerClick the “Register” icon on the icon barClick OK to choose Checking as the account to useSteps for recording the NSF fee charged by the bank:Type date in the Date columnTap TAB and then tap DELETE to remove the check number automatically enteredTap TAB 2X and type amount charged by bank (25.00) in the Payment columnTap TAB, and then type ‘b’ to fill in Bank Service Charges as the accountTab TAB, and then type NSF fee-Name of Customer (Mission Renovations)Tap ENTER to accept new transactionNSF FeeRecording CheckHow to record the NSF check in your checking registerType date in the Date ColumnTap TAB, and then tap DELETE to remove the check number automatically enteredTap TAB, and type Renee Barley in the Payee sectionTap TAB, and type amount the payment amount (400.00)Click the Account field drop-down arrow, scrolling up if necessary, and choose ACCOUNTS RECEIVABLE from the list.Tap TAB, and then type NSF check as the memoTap ENTER to accept the new transactionHow Enter a Statement Charge for the Customer’s NSF FeeChoose Customers ~ Center Statement Charges from the menu barChoose the customer whose accounts receivable register you wish to view (notice the check amount is entered)Enter the information for the statement chargeRecord the TransactionHow to create a statement to send to a customerChoose Customers ~ Create Statements from the menu barChoose the date range for which you wish to create statementsChoose the customer(s) for whom you wish to create statementsChoose any additional options, such as a customer template and whether to create statements with zero balances(Optional) Click Preview to view the statement(s)Click Print or Email to deliver the statement(s) to the customer(s).2676525990601114425104775Writing Off Bad DebtIn QuickBooks, you can deal with writing off money owed as bad debt in either of two ways:You can treat it as a discount (your sales tax liability will not be affected)You can also use a credit memo (your sales tax liability will be affected). This is the recommended procedure unless the business has ready paid the Board of Equalization).Regardless of the method, you will need to create an Expense Account in which to direct the bad debt.Treating Bad Debt as a DiscountIn order to treat bad debt as a discount (not recommended), you would enter it as a discount in the Receive Payment window. Make sure, though, that you use the proper Expense Account for the bad debt (i.e., Bad Debt Expense). If you receive a partial payment from a customer, you can also choose to “Write Off the extra amount” in the Receive Payments Window if you do not expect to ever receive the remaining balance.Using a Credit Memo to Write Off a Bad DebtIn this method, you will create a credit memo in order to write off a bad debt. When you choose this method, you will use an “OTHER CHARGE” item to “route” the bad debt to the appropriate expense account (which will be debited), and Accounts Receivable will be credited. You can include both taxable and non-taxable bad debts on a single credit memo. You will finish the procedure by applying the credit memo to the original invoice. Create New Expense Account in Chart of AccountsClick on Chart of Accounts icon from Company CenterClick on Account button on bottom leftChoose Expense as the account type, and then click ContinueTap TAB 2X – and type Bad Debt ExpenseClick Save & Close to create the new accountHow to create the Bad Debt ItemClick the Items & Services icon in the Company center of the Home PageClick the Item Menu button and choose NEWChoose Other Charge as the typeTap TAB 1X and then type Bad DebtTap TAB and type amount of Bad Debt (example $215.00)Tap TAB and then type “n” to choose Non as the Tax CodeChoose Bad Debt Expense as the accountClick OK to create new itemCreating the Credit MemoClick the Refunds & Credits link in the Customers center of the Home pageChoose the correct customer from the Customer: Job fieldTap TAB, and type “BD1” as the Credit No.Click to remove the checkmark from the “To Be Printed Option”Click in the Item column, type “b” to choose Bad Debt, and then tap TABQuickBooks displays a warning that the Bad Debt Write-Off Item is directed to an expense account. In this case it is appropriate because a bad debt is an expense. Click OK to dismiss the warning.Click Save & CloseChoose the APPLY TO AN INVOICE option to apply the credit to an invoice as shown below, and then click OKClick done to apply the credit to all the selected invoices.4210050285750Setting Up and Managing ClassesChanging the Preference to use ClassesChoose Edit > Preferences from the Menu BarFollow these steps to change the preference4. Click OK to activate the new preference2. Click the Company Preferences tab3. Place a checkmark in the Use Class Tracking option box1. Choose the Accounting categoryOnce you turn on this preference, QBs will add class columns to many forms and registers such as the Create Invoices and Bills forms, and Customer Accounts Receivable registers. You can also run reports such as the P&L by class.Set Up the Class ListTo begin class tracking, you must create the classes you wish to apply to transactions.3743325217170Choose Lists > Class List from the menu barClick the Class menu button and choose NewType Team One, and then click NextType Team Two, and then click NextType Other or Operating, and then click OKClose the Class ListApply a Class to an InvoiceRecreate the following invoiceIf you a Classifying the entire Invoice into a single class use the drop-down arrow in the Class Field and choose desired classIf you need to Classify each item separately use the drop-down arrow in the Class Column and choose a different class for each lineRemember Classes can be should universally be applied to sales receipts,credit card charges, and all checks written.Add a Class to an Existing InvoiceTeam One was responsible for invoice number 8. Follow these steps to assign the proper class.1. Choose Team One for all 3 lines of the invoice2. Click Save and CloseChoose YES to save the changes to the transactionRunning Class ReportsChoose Reports > Company & Financial > Profit & Loss by ClassYou should also run a Profit & Loss Unclassified report and make a decision if you can/should reclassify all previously created transactions.Creating an Estimate and Progress InvoicesWhen you create an estimate, QBs creates a non-posting account that allows you to track your outstanding estimates (displayed at the bottom of your Chart of Accounts). You can create estimates for either customers or jobs. Before you can create an estimate, you must turn on this feature in your Preference window.Choose Edit > Preferences from the Menu BarFollow these steps to change the preference4. Click OK button3. Click Yes to choose Create Estimates & Progress Invoicing2. Click the Company Preferences tab1. Click the Jobs & Estimates categoryCreate a Job for a CustomerChoose Customers > Customer Center from the Menu barRight-click on Sam Smith Construction and choose Add Job from the shortcut menu.Follow these steps to finish setting up the new job:1. Display the Job Infor tab3. Type p to choose Pending from the Job Status List4. Tap TAB and type 09/30/08 as the Start Date5. Tap TAB and type 11/30/08 as the Projected End Date2. Type City Center as Job Name6. Tap TAB 2x and type Landscaping for new city center as Job Description8. Click OK7. Click the drop-down arrow and choose CommercialCreate an Estimate for a JobThe new created job now appears chosen in the Customer & Job List, ready for you to create an estimate.Make sure the new City Center job is chosen, and then click the New Transactions button on the Customer Center toolbar and choose Estimates.If necessary, click OK 3X to bypass the Tracking Change Orders on Estimates, Professional Services Form, and Manufacturing and Wholesale Forms windows.The create Estimates window opens, with the new job already filled in.4. Tap Tab 2X and type 30 as the quantity1. Tap Tab 2X and type t to choose Team One from the class listFollow these steps to create the estimate:9. Click Save & Close, clicking Yes to approve the transaction6. Tap Tab 4X and type i to choose Installation5. Tap Tab 1X and type 60 as the cost3. Tap Tab 3X & type d to choose Design2. Tap Tab 3X and type 0910088. Click Alt key + M and type We look forward to doing business with you! Then, tap Tab and Quick Add the new message7. Tap Tab 2x and type 60 as the quantityConverting an Estimate to an InvoiceOnce you have created an estimate, QBs allows you to invoice in stages rather than for the entire estimate amount. You can either invoice a customer for the entire amount or for a percentage of the total amount. You can even specify different percentages for each line items or which items to include. Once you have chosen how much you wish to include on the invoice, you will see an invoice based on the Progress Invoice Template. Notice the new columns included on this invoice template: Est Amt., Prior Amt., and Total %.Create a Progress Invoice Based on an EstimateChoose Invoices icon from the Customer CenterType c to fill in City Center form the Customer & Job List and tab Tab 1XQBs displays an Available Estimates window that lists all available estimated for the selected customer or jobSingle-click to select the Estimate in the Available Estimates window and tap ENTERThe Create Progress Invoice Based on Estimate window appears2. Click in the “% of estimate” box and type 33.333. Click OKThe Invoice will appear1. Click in the circle to the left of “Create Invoice for a % of the entire estimate”Tap Tab 3X and type 092308 as the DateChoose “We appreciate your prompt payment” in the Customer Message FieldClick Save & CloseJob Costing in QuickBooksUsing Jobs is another way to keep track of larger orders or jobs Using Jobs is more efficient to track income/expenses if you perform more than one job for a customer You can also use the Job Info Tab in the customer’s record to track the work statusIn QBs you can pass onto the Customer/Job the following costs:Billable Time:Record the hours spent on the job, using either a weekly timesheet or a single activity entry. Assign the hours to the customer or job. Each entry will automatically be checked in the Billable column on the form.Job-Related Purchases:Items purchased for a job, subcontracted services. Use a bill, check, or credit card charge to record the purchase. On the Items tab, enter each item or service you purchased. In the Customer:Job column, be sure to assign each item or service to the customer or job (if you're tracking by job).Overhead expenses:Expenses not caused by any specific job (rent, office supplies, etc.) should not be assigned to a Customer:Job. However, you might still want to see these expenses on job costing reports. To do that, create a dummy Customer:Job called "Overhead" and then assign all of your overhead costs to that fake job.Mileage:Record the mileage in the Enter Vehicle Mileage window. If you want to change the amount for this expense, you can change it on the invoice.Preparing for Job Costing:In order to conduct job costing in QBs, you will need to take three basic steps:Set up your data in the Customer & Job ListEnter all job revenues and expensesUse QuickBooks reports to analyze job informationThe first two steps are covered as long as you set up your customers and jobs correctly and then enter them properly on ALL sales and purchase.Instructions for Adding a New Customer/JobIn QBs, the term "customer" means anyone who pays you for your services or products.You can add new customers to the list at any time. QB uses the list to hold information about the people and companies to whom you sell your products and services.From the Customer Center click on Customers buttonThen click on the New Customer & Jobs button as seen below:This screen is used to:Add new customers to your Customer: Job list To change information about customers who are already on the list. While most of the fields should be obvious you need to make sure the information entered is correct and complete. 458914520320Use the Customer Name box to give the customer a name that you will recognize when recording transactions making sure to:Correctly spell their namePut last name first unless you want to identify them by their company’s nameCapitalize the first letter76200352425It is best to ignore the Opening Balance and As Of boxes.If you do this, you are essentially setting up the debit part of an entry without the corresponding credit part and will have to perform several journal entries in order to fix your incomplete bookkeeping. Additional Information Tab4554855184150It is best to supply as much additional information you can about your customers. If you click the Additional Info tab, QB displays several other boxes that you can use to collect and store customer information.Type drop-down list box to categorize a customer as fitting into a particular "customer type".Once you have assigned a customer type to each customer, you can create reports that provide useful information about the customers you serve. For example, if you have categorized your customers by market segment, you can create a separate sales report for each segment such as residential, commercial, industrial, etc.Terms drop-down list box to identify the customer's default payment terms such as Due Upon Receipt or Net 30.Rep drop-down list box identifies the customer's default sales representatives.Preferred Send Method is used to preset how you want to send invoices, statements, or estimates to this customer, including e-mail or Fax.Resale Number is entered indicating that you don't charge sales tax on items that a customer buys for resale. However, be cautioned that this field is for information only; you will still need to suppress sales taxes in the ordering process.You can also specify a default price level, and even click the Define Fields button to specify additional fields that you want to collect and report for the customer.3623310-180975Payment Info tabContains a set of boxes where you can record:Customer's Account NumberCredit LimitPreferred Payment MethodCredit Card InformationJob Info tab4486275386080The Job Info tab lets you describe information associated with a particular job being performed for a customer. You use the Job Info tab if you not only set up a customer but also set up a job for that customer.To add more than one job to a given customer, you need to choose “Add Job” from the customer menu screen.Billable Time and Costs FeatureThe Time Tracking feature allows you to create weekly timesheets so you can break down the hours by Customer/Job or to record single activities for a customer/job. In addition to these payroll benefits, time tracking allows you to:Invoice customers for the number of hours workedAutomatically fills in the hours worked on paychecksTracks time for subcontractors by automatically billing in time data on bills and checksTracks payrolls costs by job, class, or type of work performedTracks billable vs. non-billable timeMethods of Entering TimeWhen you enter a single activity, it is recorded on the employee’s weekly timesheet. A single activity can be entered by typing in the amount of time or by using the timer feature to actually track the exact amount of time on a task. If you choose to use the time feature, you can only use it for times activities on the current day.There are 2 methods by which you can enter time data in QBs:As a single activity when it occurs (see below)This “Not Billed” label is misleading. It indicates that this time has yet to be billed. The check in the Billable checkbox shows that you intend to use this data in the future to bill a customer.You can either type the amount of time in the single activity window or use the built in time to record the exact amount of time.By checking this box, you are choosing to bill the customer for this time.You can either type in the duration of a task or click “start to record the actual time.As a weekly timesheet when it occurs (see below)The column to the far right is the “billable” column. If a checkmark is in this field, you can bill the customer for the time. If an invoice icon appear, it means the invoice has already been billed.The weekly timessheet allows you to enter time data for multiple customer/jobs, service items, and payroll items for a single employee. You can use this information to create paychecks when you process payroll.The Copy Last Sheet button allows you to enter the data from the last pay period if it is the same, or so that you can use it with modifications.Vehicle Mileage TrackingQuickBooks can track mileage for your business vehicles. You can use the mileage information for tax deductions for your vehicles, and to bill customers for mileage expenses. You cannot use vehicle mileage tracking to reimburse your employees for mileage.Instructions for Tracking MileageGo to the Company menu and click Enter Vehicle Mileage. Click on the % Mileage Rates button to choose which rate will be usedBy checking this box, you are choosing to bill the customer for this time.Making sure you fill each area correctly!!Select a date from the calendar for the Effective Date and press Tab.Click Mileage Rates to enter the IRS rate for that date, then click Close.Enter the current mileage rates for vehicle mileage.Add a vehicle to the Vehicle List.Enter mileage for a vehicle.Run vehicle mileage reports.REMEMBER TO charge your customer for the mileage.Passing Expenses on to CustomerWhen you enter a bill, you may be purchasing equipment or supplies for which you wish to pass on the expense to the customer/job. QBs allows you to easily indicate which expenses are to be billed to a customer by providing a “Billable?” column in the Enter Bills window. Simply ensure that there is a checkmark in the column, and it will be easy to create a customer invoice for the item(s).The Cost of Goods Sold comprises expenses that are directly related to the manufacture of products or services that the company sells. Some expenses that might be considered Costs of Goods Sold are labor, raw materials, depreciation, and overhead. You cannot pass on the Cost of Goods Sold to a customer, so make sure that you use the proper type of account (expense) if the costs are to be billed to your customer. (FYI: it is instead incorporated into the final price of the product) Instructions for Paying BillsIn order to track your bills and bill payments (preferred method for proper accounting) it is paramount that you to use the Pay Bills process. The pay bills process is as follows:TermsA vendor is anyone you pay to run your businessPayment Terms is the date payments are dueAccount is the expense account on the Chart of AccountsA discount is an amount deducted from your bill by a vendorA credit (or bill credit) is money due to you from a vendor for overpayment of a previous bill, return of items, or any other reasonUnderstanding Payment Terms525780031750In QB you can specify Payment Terms when you set up the vendor's record in order to properly pay your vendors. QB uses the terms to determine:Bill due dateDate you must pay by, to receive a discount for early payment Example: 2% 10 Net 30 means "2% discount if paid within 10 days, with the net (or total) amount due in 30 days" if the terms are standard terms, or "2% discount if paid by the 10th of the month, with the net amount due by the 30th of the month" if the terms are date-driven terms.From the Vendors CenterEnter the Bill—using the Enter Bills form type all pertinent information related to the vendorSelect a VendorEnter the Amount of the billEnsure that the Payment Terms are correct per bill or vendor (should be set-up at the time you create a new vendor or anytime you pay a bill)Expense the bill, making sure to select the correct account(s) on the Expense tabMAKE SURE YOU, select a Customer: Job to whom you wish to pass the expense (see image below)Click OKBy checking this box, you are choosing to bill the customer for this time.Pay a Bill—Open the Pay Bills windowSelect the bill (s) waiting to be paidBe sure to double check the Payment Account and Payment Method for type of payment (checks, credit cards, Electronic Funds Transfer)Finally, if the Payment Account/Method is Checking go to File > Print Forms > ChecksBe sure to double-check that the Check # is correct!!Important technical information: If you enter a bill in the Enter Bills window, always use Pay Bills window to pay it.If you're sure you don't need to track your bills and bill payments, you can use the:Write Checks orEnter Credit Card Charges windowJust make sure to not mix your methods for a given billInstructions for Appling Discounts or Credits to Bills You PayApplying a discount to a bill paymentEnter the bill as normal and complete the payment information but don't record the payment yetSelect and highlight the bill for which you want to apply a discountClick the Set Discount button From the Discount and Credits window choose the Discount Account where you track income from discountsClick the Done button.Click the Pay Selected Bills button Applying credits to a bill paymentEnter the bill as normal and complete the payment information but don't record the payment yetSelect and highlight the bill to which you want to apply a creditClick the Set Credits buttonIn the Credits pane, select each credit waiting to be used for this billClick the Done buttonFinish paying the bill in the Pay Bills window Instructions for Creating Invoices with Billable Costs3781425172720To do this taskGo to the Customer center and click Invoices icon. Click the drop-down arrow at the top of the invoice from and choose client’s name from your Customer & Job List. Notice that the customer’s address and terms fill in for you from the underlying list.Then, tap Tab 1X (this is an important step in this process)The window below will appear and click on appropriate radio button then click on OK buttonWhen the Billable Time/Costs window appears, it means the customer or job you are creating an invoice or sales receipt for has outstanding billable time, expenses, mileage, or items.Use this window to choose whether to pass along billable time and costs at this time, and also to optionally set a preference for how this is handled in the future.Then click on the appropriate tab:TimeExpensesMileageItemsBe sure to check on the Options button to either:Enter a separate line on the invoice for each activityor Combine activities with the same service items.Then choose which option you want for transferring Billable Time into the invoiceNo matter which option you select, you can always add billable time and costs to your invoice or sales receipt later by clicking the Add Time/Costs button at the bottom of the form window.Notice that the billable expenses are automatically entered into the invoiceTo finish the Invoice, then tap 2X to move to the date field.295275320040Choose the correct date (reconfirm terms). When you type in a date you do not need to include the slash marks, QBs will format the date properly for you once you tab to the next field.Fill in the item(s) name for which you wish to bill your customer.Type the quantity for each item entered.Choose or type a customer message, if desired.Then decide how you want to print each invoice such as one-at-a-time for in batches from File menu, click Print Forms, and then click the type of form you want to print.In the Select (forms) to Print window, select the items you want to print.Click OKReview your print options, and make any necessary changes to them.Click Print.Be sure to remove the “To be printed” option if you are printing invoice one-at-a-timeSet a preference for how to handle billable time and costs in the futureTo do this taskChoose whether or not to display the Choose Billable Time and Costs window, as described above.Click Save this as a preference to skip this window in the future and automatically display (or not display) the Choose Billable Time and Costs window in the future. If you don't save your choice as a preference, QuickBooks will continue to display this Billable Time/Costs window in the future whenever you create an invoice or sales receipt with billable time or costs.Remove a cost from the listIf you know that you will never bill the customer for a cost, you can remove that cost from the list.To do this taskOpen an invoice and click Add Time/Costs to open the Choose Billable Time and Costs window.Click to open the Expenses tab.Click in the Hide column next to the Amount column.This removes the cost permanently from the list. It does not remove the original transaction (check, credit card charge, bill, and so on) from your records. Your reports will still show the cost as associated with the customer or job.Available Reports for Job CostingJobs & Profitability ReportsThese reports can be found in Pro, Premier and Enterprise in Reports > Jobs, Time & Mileage.Job Profitability Summary – This report summarizes how much profit your company has made from each customer.Job Profitability Detail – This report drills down to the detailed costs and revenues for each job phase you billed to the selected customer or job, so you can see which parts of the job were profitable and which parts were not.Item Profitability – This report summarizes how much profit you have made from each item or job phase you sell.Profit & Loss by Job – This report shows how much profit you are making or losing on each job.Unbilled Costs by Job – This report lists the costs you assigned to a specific customer or job but have not yet billed as reimbursable expenses.Job Estimates ReportsThese reports can be found in Pro, Premier and Enterprise in Reports > Jobs, Time & Mileage.Job Estimates vs. Actuals Summary – This report summarizes how accurately your company estimated job-related costs and revenues. The report summarizes estimated to actual costs and estimated to actual revenue for all customers.Job Estimates vs. Actuals Detail – This report drills down to the detailed costs and revenues for the selected customer or job. It compares estimated to actual costs and estimated to actual revenue for each job phase you billed.? That way, you can see which parts of the job you estimated accurately and which parts you did not.Job Progress Invoices vs. Estimates – This report compares each estimate with progress invoices based on the estimate. For each customer or job, this report shows whether or not the estimate is active, the estimate total, the total invoiced from the estimate on progress invoices, and the percentage of the estimate already invoiced on progress invoices.Item Estimates vs. Actuals – This report summarizes how accurately your company estimated costs and revenues for the items and job phases you sell. The report summarizes estimated to actual cost and estimated to actual revenue for all your items.Estimates by Job – This report lists all active estimates assigned to a customer or job.Open Purchase Orders by Job – This report shows the remaining purchase order line items that have not been received and their expected delivery date for each customer or job.Job Costs & Bills ReportsThese reports can only be found in the Contractors and Accountants editions of QuickBooks.? Some of them are also available in the Professional Services edition.Costs to Complete by Job Summary – Once you enter how far along each of your jobs are, this report summarizes the cost to complete each of your jobs that have active estimates. It also shows how far you are over or under your estimate.Costs to Complete by Job Detail – This report drills down to the detailed estimated cost by phase to complete the selected customer or job, and how far you are over or under your estimate.Job Costs by Vendor and Job Summary - This report lists the job-related expenses you have incurred for each job, subtotaled by vendor.Job Costs by Vendor and Detail – This report shows a detailed list of all the job-related expenses you have incurred for each vendor, subtotaled by job.Job Costs Job and Vendor Summary - This report lists the job-related expenses you have incurred for each vendor, subtotaled by job.Job Costs Job and Vendor Detail – This report shows a detailed list of all the job-related expenses you have incurred for each vendor, subtotaled by job.Job Costs Detail - This report lists the expenses you have incurred for each job. This report is useful if you need to break out all material supplier purchases, all subcontractors bills, and all the labor costs for each job.Unpaid Bills by Job – This report lists the bills you have not yet paid, sorted by customers and jobs. It lists only bills with an associated customer or job. This report is useful if you wait to pay vendor bills for a specific job when you receive a payment from the customer.Unpaid Job Bills by Vendor – This report shows all bills you have not yet paid, sorted by vendor or subcontractor, and lists any customer or job associated with each item on the bill.Expenses Not Assigned to Jobs – This report lists expenses that you have not assigned to a customer or job, totaled by vendor. Use this report to help identify costs that you may have forgotten to pass along to your customers.Job Status – This report lists information for each active customer and job.Pricing LevelsPrice Levels let you set custom pricing for different customers or jobs. Once you create a Price Level and associate it with one or more customers or jobs, each time you create an invoice, estimate, sales receipt, sales order or credit memo for those customers or jobs, QBs automatically pulls up the correct custom price for a customer or job. You create price levels, then use them on sales forms to adjust the price of an item. You can also manually adjust the prices while creating a sales form.Note:Price levels associated with customers are automatically used for billable time and reimbursable mileage items. They are not automatically used for reimbursable items and expenses from purchase transactions or invoices created from estimates.Fixed Percentage Price LevelsFixed percentage price levels let you increase or decrease prices of all items for a particular customer or job by a fixed percentage.For example, you might use a fixed percentage price level for a customer who gets a 10% discount on all the products and services you offer. Per Item Price LevelsPer item price levels let you set custom prices for items that are associated with different customers or jobs. For example, you might use a per item price level for your preferred customers who are charged $8 for product A (regularly priced at $10), $5 for product B (regularly priced at $5.50), and your standard price for product C. Note:Per Item price levels are only available if you have QuickBooks Premier or Enterprise editions. How to Create or Edit a Price Level5065395446405Note: You must have the price levels preference enabled to create or edit price levels.Go to the Lists menu and click Price Level list.Click Price Level at the bottom of the list and click New or Edit Price Level. 32365950Enter the Name of the New Price Level.Choose the Price Level Type.The type can be either Fixed % or Per Item.If you choose fixed percentage, you can increase or decrease prices on all items by a fixed percentage. You can also round sales prices up to the whole dollar, if you have set this Company preference when you elected to use price levels.If you choose per item, you have the flexibility to set the dollar amount prices of individual items for different customers or jobs. (only available if you have QuickBooks Premier or higher)For Fixed Percentage Price Levels, choose whether to increase or decrease and enter a percentage. (Fixed percentage price levels are not based on currency and are available for all customers)orFor per Item Price Levels, either enter the new price in the Custom Price column, or choose one or more items from the list and click the Adjust Selected Prices button to adjust the prices in bulk.For per Item Price Levels, the currency of the price level must match the currency of the foreign customer for whom you want to set the custom price for. Create a per item price level for each foreign currency as needed. Click OK to go back to the Price Level List.Using Price LevelsYou can use price levels in two different ways:You can apply a price level directly to items on a sales form.You can associate a price level with one or more customers or jobs.Note:If you associate a price level with a customer, whenever you create a sales form for that customer, items will automatically appear with the new amount. Applicable sales forms are: invoices, estimates, sales receipts, credit memos, or sales orders.Setting Up and Managing InventoryTurn On the Inventory FeatureChoose Edit > Preferences from the Menu BarFollow these steps to change the preference3. Place a checkmark in the 3 Purchase Orders & Inventory option boxes1. Choose the Items & Inventory category2. Click the Company Preferences tabClick OK to activate the new preferenceThe options for Inventory and purchase orders are made active automatically when you select this option.Creating Inventory Items through the Item ListBefore you can see anything on a sales form or purchase order –IT MUST BE SET UP AS AN ITEMAlong with the Sales TaxClick the Item & Services link in the Company area or go to the Lists menu and click Item List Click the Item menu button and choose New or Click “CTRL + N”.1542415457203076575104775Inventory Item StepsClick to choose Inventory PartTap Tab 1X and type Water FountainTap Tab 3x and type “Free Standing Water Fountain”Tap Tab 1X and type 14.50 as the CostsTap Tab 2X and type 42.00 as the Sales PriceChoose Sales as the Income Account (we will Quick Add this account)Click in the Record Point field and type 5 as the amountEither click Next to set-up another item or OKCreating a Purchase OrderClick the Purchase Orders icon on the Home Page in the Vendor CenterFollow these steps to create a purchase orderE. Click Save and Close to record the purchase orderB. Tap TAB 4X and then type 07/22/08D. Tap TAB, 2X, type 10 in the Qty column, and then tap TABA. Choose Creative Garden Designs as the VendorC. Click in the Item Column and type ‘w’ to fill in Water FountainReceiving Shipments against Purchase Orders with a Bill5257800131445From the Vendors Center click Receive Items icon and choose “Receive Inventory with Bill”Choose the correct vendor and tap TAB If there are open purchase orders for this vendor, QB gives you a chance to receive against them. Click YES in the Open PO’s Exist windowYou MUST click to place a checkmark in the first column next to the correct Purchase Order in the Open Purchase Orders window and then click OK.Be sure to change the date for proper trackingMake sure to change the line items if there are differences (inventory not received):Quantity4791075113030CostDeleting an item completely from the detail areaSave the item receiptThe Bill is now waiting to be paid from the Pay Bills windowReceiving Shipments against Purchase Orders without a Bill5257800131445From the Vendors Center click Receive Items icon and choose “Receive Inventory without Bill”Choose the correct vendor and tap TAB If there are open purchase orders for this vendor, QB gives you a chance to receive against them. Click YES in the Open PO’s Exist windowYou MUST click to place a checkmark in the first column next to the correct Purchase Order in the Open Purchase Orders window and then click OK.Be sure to change the date for proper trackingMake sure to change the line items if there are differences (inventory not received):5886450171450QuantityCostDeleting an item completely from the detail areaSave the item receiptWHEN the bill arrives select “Enter Bills Against Inventory” linkThen select the correct Vendor in the Select Item Receipt window and be sure to select the correct Items Receipt and click on OK.1857375267970The Enter Bills window will automatically pop-up next > Select the correct Item Receipt then choose OK.Including Expenses on a Bill for ItemsWhen you receive the items, QBs will use the Items tab rather than the Expenses tabSince Inventory is considered an Asset Account rather than an expenseFor all additional shipping and handling charges you incur – you must use the Expense tab If you are going to pay a bill with a credit card, use the ENTER CREDIT CARD CHARGES window, so that QBs will prompt you to receive against open POs.Adjusting Your InventoryChanging the Quantity of your InventoryYou can either enter the new quantity on hand (because you have conducted an annual inventory count) or the quantity different (this works well if you know how many items you have to remove) through the “Adjust Quantity on Hand: icon. If you choose to enter the quantity difference, make sure you enter a MINUS sign in front of the number to show a decrease in the number of items.Adjusting the Value of your InventoryIf you need to adjust the value of your inventory, you can use the same icon, but you will need to tell QBs that you want to adjust the value by placing a check make in the Value Adjustment checkbox.How to make an Inventory AdjustmentValue Adjustment checkbox4. Click Save & Close to record the inventory adjustment3. Click in the Adjustment Account field, type Inventory Adjustment and then tap TAB1. Type today’s date as the Adjustment Date2. Click in the Qty Difference Column to the right of the Birdbath entry and type -1Inventory Adjustment is a new account so QBs will prompt you to set it up.Choose Expense as Account TypeTap TAB and type 63500 as the account numberClick Save and Close to create the new accountActivating Sales Tax and Setting PreferencesSome ConceptsIf you are going to charge sales tax on an invoice, several things must be set up:The sales tax preference must be enabled.You need one or more sales tax items and possibly some sales tax groups in your Item List.When you create an invoice, you must have:taxable customer tax code selectedsales tax item or sales tax group selected for the taxPlus, any taxable charges must be set as being taxable on the detail lineEnable Sales TaxTo start, you need to enable the sales tax preference. Select Edit then Preferences and select the Sales Tax preference. Click on “Yes” for the question “Do you charge sales tax”.In the lower half of this screen there are several options to review to make sure they are set properly for your business (how often you pay sales tax, and so forth).Sales Tax ItemsBefore you can collect the tax fees, you must have an entry in the Item List. For Sales Taxes you will be creating one or more Sales Tax Items in the item list which are then joined together in a Group Tax Item. ProceduresYou can do this by clicking on the add sales tax item button in the preferences screen, or by adding an item to the item list in the normal way.Enter the percentage for the sales tax, and a vendor for who you pay that sales tax to (typically your state sales tax agency).Multiple JurisdictionsSo what do you do if you have multiple jurisdictions? You could have a situation where you have a state tax, a county tax, a city tax or even more. When you file your reports to the state tax agency you need to split out the amounts by jurisdiction, usually.To manage this, create a sales tax item for each jurisdiction. One for the state, one for each county you work with, one for each city. However you need to break it down for your reporting. Then, create a sales tax group item and add each of the jurisdiction taxes:If you use this sales tax group in an invoice the rate will be 8.1%, but the program will report each tax separately.Please note that if you have a large number of taxable jurisdictions this can become very complex. You need to have a sales tax item for each jurisdiction, and a sales tax group for each location that has different combinations. There are third party add-on products that help with sales tax tracking, but these usually are reasonable only if you have a large number of invoices to process.Back in the preferences section, in the dropdown list Your most common sales tax item you can select the sales tax item or group that you most commonly use.Customers and ItemsNow, let’s look at your customers and items. Some customers are taxable, others are not. Some items and services are taxable, others are not. We will set up both to have the usual value for taxation, although you can always override this when needed.Edit your customer, you can specify which sales tax item or group to use for this customer. Also, the tax code needs to be set – it should be set to tax.344741552705Edit your items to specify if they are taxable or not – select the tax code of tax.Putting It All TogetherAfter invoicing your customer the default values for the tax related questions are taken from the customer record and item records used. Three things must be set to have sales tax calculate: The customer tax code must be taxableThe tax item or group must be selectedThe tax setting on the item must be selected. If this all happens, sales tax is calculated properlyRemember, you can override these if you need to change something for a specific situation. If one line isn’t to be taxable for some reason, change the tax setting on that line to non taxable. If the customer should get a different tax rate, change the tax item or group for the invoice. You can?also change the?customer tax code.Paying sales taxCollected sales tax is held by QuickBooks (It is held in the Current Liability Account until time to paid)These taxes are never actually the property of your business therefore will never show up on the Profit & Loss ReportFind out what you oweUse sales Tax Payable registerUse Sales Tax Liability reportAs of 2007 QBs has a new feature that helps you manage all your sales tax activities The Manage Sales Tax window which provides links to all the tasks you will be performingTo view the report click the Sales Tax Liability LinkIf paying a different amount than displayed choose the Adjust Sales Tax Due LinkPay your tax agenciesInstructions for Removing Unpaid Invoices from QuickBooksWhen you enter an invoice, a sales receipt, or a credit memo, you can mark the sale as pending.525145055880Ways to use a pending saleTo do this taskWhen you've finished filling in the invoice or sales receipt, go to the Edit menu and choose one of the following:For an invoice, choose Mark Invoice as Pending.For a sales receipt, choose Mark Sales Receipt as Pending.For a credit memo, choose Mark Credit Memo as Pending.When you choose the command, QuickBooks displays and prints "Pending-non-posting” on the form.Save the transaction.5629275177165Ways to Reverse Pending OptionWhen it is time to reactivate the invoice or sales receipt, go to the Edit menu and choose one of the following:For an invoice, choose Mark Invoice as Final.For a sales receipt, choose Mark Sales Receipt as Final.For a credit memo, choose Mark Credit Memo as Final.Save the transaction and handle as normal.Reconcile Credit CardsYou can reconcile your credit cards the same way as you reconcile your bank.Once you have reconciled the credit card, you have the option to pay any amount due. You can choose to either write a check or enter a bill for the credit card payment. QuickBooks takes the balance due on the credit card and fills it in to either the Enter bills or the Write Checks window. If you don’t plan to pay the entire bill, you can enter the amount manually.5572125622300Performing Account ReconciliationFrom the Chart of AccountsSingle-click on the account you wish to reconcileClick the Activities buttonChoose the Account and enter the date of the credit card statement & ending balanceUsing the credit card statement enter in the statement date and ending balanceEnter any finance chargesClick ContinueChoose to show transactions on or before the statement ending data onlyEnter a Bill for a partial Payment on the Credit Card AccountChoose either the “Write a check for payment now” or “Enter a bill for payment later” option.Click OK to continue (there is a pause as QBs records the cleared transactions and opens the Enter Bill window. Once the transactions are cleared, QBs displays a congratulatory message.)Click the Close button at the bottom of the Select Reconciliation Report window to bypast creating a report. QBs displays the Enter Bill window.Follow these steps to complete the bill entry.Tap TAB and enter Refer InfoTab TAB & Enter DateTap TAB and enter Payment AmountTap TAB until you are in Acct Section and select correct acct.Enter Vendor NameClick Save & Close to record the bill and close the window.Petty Cash AccountPetty cash is the money you use for small out-of-pocket business-related expensesPetty Cash is a Bank Account typeSince you want to make sure your accounting system is as accurate as possible – it is best to track cash expenses in QuickBooksEase of UseBecause it is another Bank Account you can easily:Set the account upPut money into the account for fundingRecord the money you take out of it towards your expense accountsReplenish the accountInstructions for Opening the Petty Cash AccountOpen Chart of Accounts from Banking Center from the Home windowTap CTRL + N (shortcut for new account)Choose Bank as the account > then ContinueEnter Petty Cash as the name of the accountClick Save & CloseFunding the Petty Cash AccountIn order to have cash the account must be “funded”.Instructions for FundingType a check to Petty Cash (vendor) for the amount of the fund (the check must go through your regular bank)Choose Petty Cash in the Account ColumnSelect Save & Close to record the transaction Entering in Petty Cash ExpendituresTo enter the transactions you can use:Write Check method making sure to use Petty Cash as the Bank accountThe Register method which enters petty cash expenditures direction into the register.Set Up Fixed Asset AccountsCreate the Fixed Asset Account and SubaccountsYou will create a main fixed asset account for the truck and two subaccounts: Cost and Accumulated Depreciation. Click the Chart of Accounts button from the Company Center4286250110490Click “CTRL + N” to create the main fixed asset accountYou will be in the number section, type 16500 as the numberTab TAB and then type Company TruckClick Save & NewDouble check that FIXED ASSET is the Account typeTab TAB and type 16510 as the numberTap TAB and type Accumulated Depreciation as the Account NameClick in the Box to the left of Subaccount of, then Choose 16500*Company Truck as the subaccountClick Save and NewRepeat steps 6-9 for an additional subaccount for the Company Truck account names 16520*CostClick Save & CloseCreate a New Fixed Asset ItemChoose Lists > Fixed Asset Item List from the menu barClick the Item menu button and choose New form the menuTap TAB and type 25000 hereClick in the Serial # field and type V02Click this drop-down arrow and choose 16500*Company TruckTap TAB & type 070208Tap Tab and type 070110Tap TAB 3X, & type 2008 Ford F-150, greenType Ford Truck 1 hereClick OK buttonClick in the Asset Description field and type Ford F-150 TruckTap TAB and type Dixon Ford hereRecord a Depreciation TransactionYou will not record the 1st depreciation transaction. Don’t get worried when it shows the value of the asset as -$250 at the end of this step. You will enter the cost later in this lesson.From the Chart of Accounts, locate and double-click the Company Truck Accumulated Depreciation subaccountIn the Date area type – 073108Tap TAB 3Xand type 250 as the amount in the Decrease areaTap TAB and type d to prompt QBs to fill in 62400*Depreciation ExpenseClick RecordMemorize a Depreciation TransactionClick anywhere within the last transaction you createdChoose Edit > Memorize General Journal from the menu barFollow these steps to memorize the depreciation transaction.Tap Tab and type 59 as the Number RemainingTap TAB & type m to choose Monthly from the How Often listTap TAB & type 083108 as the Next DateType Co. Truck Depreciation as the NameClick OK and Close the register window. Click Yes if prompted to recordSetting Up and Working with a Long Term LiabilityFirst, you will create a new liability account.Click the Chart of Accounts icon from the Company CenterIn the Account Type choose – OTHER ACCOUNT TYPES – LONG TERM LIABILITYClick ContinueType 26000 as the Account Number and Truck Loan as the Account NameClick Save & Close to record the new accountFund the Long Term Liability AccountYou have just received the new truck, and California Bank and Trust issued the funds on your behalf to the car dealership. It is now time to record the starting balance for the loan and the cost of the truck.Double-click the Truck Loan account in the Chart of Accounts windowIn the Data area type 070208 as the date for this transactionTap TAB 3X and type 22500 as the loan amountClick the Account drop-down arrow and choose the Company Truck Cost subaccount – 16520*costClick Record and close the Truck Loan register windowWrite a check for the Down PaymentChoose Write Checks icon from the Banking CenterTap Tab, type Dixon Ford, and then tap Tab and Quick Add it as a vendorType 2500 as the AmountTap TAB 2X, and then type Down Payment on F-150 in the Memo sectionTab TAB 3X and type 16520 to choose the Cost subaccount in the Account Column, and then tap TABLook at the Effect on the Fixed Asset AccountScroll through the Chart of Accounts list until you see the Company Truck account and two subaccountsScroll down and notice that the two accounts you will use with the Loan Manager are already set up:60400*Bank Service Charges63450*Loan Interest, a subaccount of Interest ExpenseSet Up a Loan in the Loan Manager4343400100330Choose Bank > Loan Manager from the menu barClick the Add a Loan ButtonIn the Account Name area, choose Truck LoanChoose Dixon Ford as the LenderTap TAB and type 070208 as the Origination DateTap TAB and type 60 as the Term Click the Next button434340038100Type 080207 in the Due Date of Next PaymentTap Tab and in the Payment Account area type 440.24 Click the Next button457200087630Type 6.5 as the Interest RateChoose Checking as the Payment AccountMake sure that Loan Interest is chosen as the Interest Expense Account Make sure that Bank Service Charges is chosen as the Fees/Charges Expense Account Click the Finish ButtonMemorizing a transactionA transaction is any business agreement or exchange that you make with another person or business. In QuickBooks, you use various forms (invoices, bills, checks, etc.) to perform these transactions. If you have a transaction that you frequently enter, you can save time by memorizing it for future use.How memorized transactions workEnter the transaction as you'd like it memorized.If the content of certain fields will change each time you recall the transaction, leave those fields blank.For example, you might want to leave the Amount field blank on your monthly utility bill. That way, you can fill in the amount each time you recall the bill.Go to the Edit menu and click Memorize.In the Memorize Transaction window, enter a name that will help you recognize the transaction on the Memorized Transaction list.You then need to make the following choices:Whether you want to be reminded to enter the transactionHow Often the transaction will be enteredNext date the transaction will be enteredClick OK to memorize the transaction.If you are only entering the transaction information for future use, close the transaction window by clicking the Clear button and then clicking the close box at the top of the window.Using a memorized transactionIf you have a transaction that you frequently enter, you can save time by memorizing the transaction for future use.If you use the transaction on a regular basis (for example, monthly), you can set it up as a recurring transaction when you memorize it. Otherwise, you can use it as needed by entering it from the Memorized Transaction list.Entering a transaction from the Memorized Transaction listThis procedure assumes that you've already created the memorized transaction that you want to use.Go to the Lists menu and click Memorized Transaction List.Select the memorized transaction you want to use.Click Enter Transaction.Make any necessary changes or additions.Save the transaction.Customize Your ReportsThe QuickBooks default report basis is Accrual. Sometimes though you may need to have the default for a particular report changed to a Cash basisChoose Edit > Preferences from the Menu BarFollow these steps to change the preference2. Click the Company Preferences tab3. Click to Choose Cash1. Click the Reports & Graphs categoryClick OKAdd a FilterChoose Reports > Company & Financial > Profit & Loss by Class from the menu barFollow these steps to set a custom data range:3. Click Refresh2. Tap TAB and type 073108 to set the end date1. Tap TAB and type 06/01/08 to set the start dateModify Report buttonYou will see the Profit & Loss by Class report displayed for June-July 2007.Click the Modify Report Button on the report toolbar.Follow these steps to apply a filter that will include only income accounts on the report.3. Click OK1. Click the Filters tab2. Click this drop-down arrow and choose All Ordinary Income AccountsYou will now see the report with no expense accounts shown.Change the Font and Number FormattingClick the Modify Report Button on the report toolbarFollow these steps to change the formatting:3. Click Report Title in the Change Font for box4. Click Change Font2. Choose in Parentheses1. Click the Fonts & Numbers tab1. Click OK2. Click YES to change all related fonts 3. Click OK 3. Click the Color drop-down button and choose Maroon2. Click 16 for the Size1. Type t and choose Tahoma for the fontCreating a Simple Report on InvoicesQuickBooks doesn't provide a report that displays a simple listing of invoices (Date, Invoice Number, Customer, Amount on a single line). You can create this report using the following steps:Choose Reports > Banking > Missing Checks (yes, that's right, it's not a typo).Click OK in the Specify Account dialog that opens (it doesn't matter what bank account is displayed).When the Missing Checks report opens, click Modify Report.Move to the Header/Footer tab and change the text in the Report Title field to Invoices.Move to the Filters tab and make the following changes:In the Current Filter Choices box, select the Amount filter and click Remove Selected Filter.In the Filter list, select Account and then select your Accounts Receivable account from the Account drop-down list.In the Filter List, choose Transaction Type and select Invoice from the Transaction Type drop-down list.Move to the Display tab and deselect all columns except the following:DateNumNamePaidAmountClick OK to save your changes.A simple list of invoices appears, and QuickBooks inserts data about missing invoice numbers or duplicate invoice numbers in the appropriate places.Setting Up Users for a CompanySet Up an AdministratorChoose Company > Set Up Users from the menu barType “YOUR NAME” as the administratorTap Tab and type 123 as the passwordTap Tab and type 123 againClick OKWhen you choose a password for your company file, it should be difficult for anyone to guess. The password “123” is used here for instructional purposes; it should not be used for your own file.Add a UserClick the Add User button in the User List window, and then follow these steps to add “New Name”Tap TAB and type 123Tab TAB and type 123 againClick Next TwiceEach time you click Next as your move through the “Set up user password and access” screens, you can change the access for the user in one of nine areas.Choose the Full Access for Sales and Accounts Receivable option and click Next.Click in the circle to the left of Selective Access for Purchases and Accounts Payable. The Create transactions only option will be automatically selected.Click Finish (notice the user has been added to the User List)Click View User (you will see a summary of the access you have given to the user. You can change this at any time by opening the User List, clicking on the user’s name, and clicking the Edit User button.Click the Leave button in the View user access windowClose the User List. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download