Wednesday, June 20, 2018

All About Sales Receipts in QuickBooks

All About Sales Receipts in QuickBooks


Documenting every sale carefully helps ensure that your financial records and reports will be accurate. The sales receipt is the right tool for this in specific situations.


You know how important it is to obtain receipts for the expenses you and your employees incur. You need to record them, analyze their impact on your cash flow, and claim some of them on your income taxes.


Your customers, too, expect to receive forms documenting purchases they’ve made from you. When they pay you immediately for goods or services, you’ll give them a sales receipt, rather than invoicing them for future remittance. Not only will your customers have a record of the transaction – you will, too.


QuickBooks supports the creation and tracking of sales receipts. It manages the mechanics of this important task incredibly well. It eliminates the need to enter receipt data twice, once on a paper copy for your customer and again in your accounting system. This QuickBooks feature not only minimizes errors, but saves time and lessens the possibility of disputes down the road.


A Simple Form


Here’s an example of a situation that illustrates the importance of really learning about and understanding QuickBooks before you start entering live data. Say you got a check from a customer on the spot for a house painting job you completed. When you look at QuickBooks’ home page, which icon do you click?


You might be tempted to click Receive Payments, since that’s exactly what you’re doing. But that screen is reserved for revenue that comes in to satisfy outstanding invoices and unpaid items on billing statements. Instead, you’d click Create Sales Receipts to open the Enter Sales Receipts window. Here’s a partial view of what you’d see:


When a customer pays you immediately for goods or services, you need to open and complete the Enter Sales Receipts window.


If you’ve already entered your customer and item/service records in QuickBooks, you can record your sale very quickly here. Even if you haven’t, or if you need to create a new record on the fly, you can select <Add New> when you open the drop-down option lists for the Customer:Job and Item fields.


Warning: Do you need to track inventory levels for products you sell? Have you created thorough records for these items? There is information that QuickBooks needs to help ensure that you don’t run out of stock or keep too much on hand. Let us walk you through the software’s inventory-management tools so you can take advantage of all the benefits they offer.


Once you’ve selected the appropriate customer, Class (if you use this feature), and Template (Here again, do you understand that you can either use the default sales receipt form provided by QuickBooks or customize it? We can help here), make sure that the Date and Sale No. are correct.


Next, click on the icon representing the transaction’s payment method, choosing from Cash, Check, Credit Card, or eCheck. Click the More button if your method isn’t listed there. Here, you can add new options by selecting Add New Payment Method. A small window will open allowing this. If you want to modify this list further by, for example. editing and deleting the default methods, clear and close the current sales receipt, open the Lists menu, and select Customer & Vendor Profile Lists | Payment Method List. This window will open:


Click the down arrow in the Payment Method field near the bottom of this window to see your modification options.


Once you’ve chosen the desired Payment Method (and entered a check number if necessary), you’ll complete the rest of the sales receipt much like you would an invoice, by selecting the correct products or services, the quantity you’re selling, and the transaction’s tax status. QuickBooks will fill in the rest if you’ve created complete item records.


When you’re done, save the sales receipt. Information about the transaction will be available in standard places like the Customer Information screens and various reports.


Whether your revenue comes instantly (documented by a sales receipt) or as longer-term payment on an invoice, your company’s income is just one element of the cash flow equation. Are you able to create and interpret the reports that can help you understand these complex calculations, like Cash Flow Forecast and Profit & Loss? You probably run some of QuickBooks’ more basic sales reports regularly, but consider bringing us in to do the deep analysis needed to make better business decisions.
Social media posts


Did you know you can modify the list of payment methods available in QuickBooks? Click Lists | Customer & Vendor Profile Lists | Payment Method List.


There are two primary ways to record income from customers in QuickBooks: Receive Payments and Create Sales Receipts. Do you know when each should be used?


Analyzing your company’s cash flow is more complicated than simply comparing income to expenses. We can help you understand how this works, and why you need to know.


QuickBooks comes with a template for creating sales receipts, but you have the ability to modify it if needed. Ask us about the software’s customization tools.

Friday, June 8, 2018

Using Product and Service Records in QuickBooks Online

Last month, we created product and service records in QuickBooks Online. This month, we’ll explore how they’re used on the site.


If you ever did your accounting manually, you probably remember how tired you got of writing or typing the same things over and over. You may have had your customers’ addresses practically memorized, and your product price list was always close at hand, though you knew that by heart, too.


QuickBooks Online eliminates that duplicate data entry, saving time and reducing errors dramatically. Because of the product and service records you’ve created, completing sales and purchase forms can now be an easy, accurate task. You’ll also have fast access to information about your inventory levels and the profit you make on items. You’ll know what’s selling and what’s not, and when it’s time to reorder.


Here’s how.


Picking Products


Much of your accounting work probably consists of filling out forms. Whenever you create one of these invoices or sales receipts or purchase orders, you already know that you can open a drop-down list and select the name of a customer or vendor. QuickBooks Online lets you enter data about what is being bought or sold in the same way.


To see how this works, open an invoice form and complete and/or verify the fields at the top (customer, date, terms, etc.). Click in the first PRODUCT/SERVICE field, and then click the down arrow to see the list of items and services you sell.




When you create a sales or purchase form, you’ll be able to select the appropriate product or service from the drop-down list – or add a new one.


When you select an item, the description and price will fill in automatically. You’ll have to add the quantity and click in the box below the column labeled Tax (if applicable). QuickBooks Online will calculate the total cost of the product or service on that line. If you need to enter additional sales, proceed to the PRODUCT/SERVICE field in the second line and repeat those actions until you’re done and can save the transaction.


Working with Items


What do you do when you need more information about a specific product than just its description and price? Do you have to return to its individual record?


No. QuickBooks Online includes a great tool that provides real-time updates on your inventory items and lets you work with them. Click the Sales tab in the left vertical menu, and then on the Products and Services tab at the top. The table that opens displays numbers for every item’s quantity on hand and reorder point. Look at the end of each line, and you’ll see a drop-down list labeled Edit that looks like this:




QuickBooks Online’s Products and Services page provides real-time inventory updates, as well as item-management tools.


As you can see, there are a number of actions you can take here on individual products.


Warning: If you think there’s a reason you should Adjust quantity or Adjust starting value, please talk to us first. Your inventory records need to be precise. We can schedule a session to go over this and other concepts you need to understand in order to keep inventory counts accurate.


You can take some of these actions on multiple items simultaneously. Click the down arrow in the Batch actions field above this Edit menu. Click the boxes in front of the products you want to work with and select the desired activity (unavailable ones will be grayed out in the list). Take extra care with this mass modification tool.


Multiple Reports
QuickBooks Online contains templates for numerous inventory-related reports that you can customize.


QuickBooks Online’s Product and Services screen may be all you need in your daily work, but there will be times when you need more analytical assistance. You can turn to the site’s specialized reports for more in-depth scrutiny. Click the Reports tab in the left vertical pane. Make sure the All Reports list is active and select Manage Products and Inventory to see what’s available, including:
  • Inventory Valuation Detail.
  • Sales by Product/Service Detail.
  • Physical Inventory Worksheet.


Reports are easy to run but can be difficult to customize correctly and interpret. If we’re not working with you already on the complex standard financial reports that should be reviewed monthly or quarterly, talk to us. The more you understand about the financial status of your company, the better your decisions will be.


Social media posts

  • Does your business sell products? If so, are you using QuickBooks Online’s inventory tools to their fullest? Talk to us.
  • Once you’ve created records for products and services in QuickBooks Online, it’ll be much easier and faster to complete sales and purchase forms.
  • Your business can’t make smart purchase and reorder decisions without good reporting tools. QuickBooks Online has them.
  • How quickly could you provide counts for your inventory items? It takes seconds in QuickBooks Online. Ask us how.

Friday, June 1, 2018

Polish Your Image: Customize QuickBooks' Forms

The invoices and other forms you send to customers and vendors should reflect your company’s attention to detail, accuracy, and consistency.


Every opportunity you have to interact with your customers and vendors is critical. Whether it’s a phone call, an in-person connection, or an email, how you present yourself reveals a lot about you. Are you efficient? Friendly? Do you handle orders and problems and payment issues quickly and carefully?


Your accounting forms can also contribute to your image. They should always be:
  • Neat and attractive.
  • Easy to read, with the most important information displayed prominently.
  • Consistent with any graphics you use on other company materials.
  • Accurate, above all.


You might be able to use at least some of QuickBooks’ form templates as is, without any modifications. But couldn’t they be better? More visually appealing? Formatted to include only the fields that your business most often needs? QuickBooks contains the customization tools you need to make them so.


Improving What Exists


You can personalize your QuickBooks forms and make them consistent with any design themes your brand may use.


We’ll look at the modification options for an invoice, though, depending on what version of QuickBooks you’re using, you can also work with sales receipts, purchase orders, statements, estimates, sales orders, and credit memos. Start by opening the Lists menu and selecting Templates. Highlight Intuit Product Invoice in the list. Click the down arrow next to Templates in the lower left corner and choose Edit Template.


The above image displays part of the window that opens. Here, you can add a logo, change the color scheme, and change fonts for your company’s contact information and the labels that identify each field (like Bill To, Terms, and Quantity). The right pane of this window shows you what the form will look like as you make changes.


Nothing you’ve done so far will prevent you from using Intuit’s pre-printed forms. But when you click Additional Customization at the bottom of the screen, you’ll be warned that if you make modifications beyond this point, the forms may not print correctly. To be safe, click Make a Copy. You’ll be able to print this new version on plain paper.


Deeper Customization


The image below shows you part of the window that opens when you click on Additional Customization. The first two columns here are the most important; they let you specify the labeled fields that will appear on your invoices. When Header is the active column, you’ll be able to choose the content that will go at the top of your form, like Date, Invoice Number, and Terms.


Next to each default label, you’ll see boxes for Screen and Print. Click in these boxes to create or delete checkmarks; this will indicate whether each label will appear in the software itself and which will be printed for your customers to see. If you’d like to change the language QuickBooks uses to describe each, enter your preferred word or phrase in the Title column.


With the Header column highlighted, you can shape the appearance of the top section of your invoices.


Warning: As you’re checking and unchecking boxes, a dialog box may open telling you that your changes will cause some fields to overlap on your form. If you click the Default Layout button, QuickBooks will make automatic adjustments to fix this. Clicking Continue means you’ll have to use the software’s Layout Designer to make your own adjustments. This tool is not particularly intuitive, and it requires some design skills. If you must work with the Layout Designer, let us help.


When you click the Columns tab, you’ll see a list of the fields available for the main body of your invoices, like Description, Quantity, and Rate. This works similarly to how you just modified the Header, with one exception: You’ll be able to enter numbers in the Order column to specify the placement of each field. Here again, you’ll be able to watch a preview of your form change in the right pane.


If you want to start over, click the Default button to revert the form to its original state. When you’re done, click OK.


Neatness Counts


Whether you print and mail your forms or simply dispatch them electronically, we strongly encourage you to make them as professional and polished as you possibly can. Their appearance will enhance or detract from the image your customers and vendors have of your business. Let us know if we can help here. We’d be happy to help you learn about and implement the customization options that QuickBooks offers.




Social media posts

  • Don’t need all the fields in QuickBooks’ customer and vendor forms, or need more? We can help you modify them.
  • QuickBooks comes with pre-formatted templates for forms like invoices. You can use them as is or change them. Ask us how.
  • Does your business use graphics and fonts and colors in materials to reinforce your brand? You can modify QuickBooks’ forms to be consistent.
  • QuickBooks offers a Layout Designer that gives you control over the appearance of customer and vendor forms. We can help you use it.