Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > QuickBooks > Customizing Forms in QuickBooks 2019 – Part 2

Customizing Forms in QuickBooks 2019 – Part 2

Watch QuickBooks 2019 video tutorial, we will continue talking about customizing forms and show you how to modify the columns, progress columns, footers, and print setting.


Facebook


Linkedin


Twitter

Okay, welcome back! We are on part two of Creating Reports. I wanted to go ahead and continue where we left off, and talk about the customization of your different templates in QuickBooks.

We just finished up with the Header tab. Now let’s look at the Columns tab. When you go down the list, you can again choose (if you’d like to see each of these options on the screen) and/or choose to print them. But, you can also show the order from left to right you’d like the columns to appear in.

Let’s go down the list and look at this.

We could choose to have the service date if we’d like. We could also choose to have the item print. Now, I want you to notice that item will always be on the screen. Because you have to see it here! In order to choose an item. But, you do not have to print it. And I probably wouldn’t!

If you remember, I told you when we talked about items, that’s when you set up items. You can name them anything you want. Because you’re the only one that will see them.

Your customer will see the description. However, they’ve got the manufacturer’s part number. They’ve got quantity, unit of measurement, rate amount. And you can see the list down here!

Now, a couple of things I want to tell you. This quantity field right here. This is a calculating field. So, if you have a situation, where you need to say quantity ordered and then, quantity shipped. This needs to be the quantity shipped field. You would come down to the other down here. And, make this quantity ordered.

That way this one will calculate for you. Let’s say you don’t want the unit of measurement and rate is always at the end and the amount is the very end. So you always have the rate and then the amount. You can’t change that. The amount is always the last one. So it looks like now we’re going to have the item, which is not going to print, the description, the quantity, the rate, and the amount.

Now let’s go over to the Progress columns. This is pretty much the same. It has to do with estimating jobs. If you want to know how much has already been estimated and you want to show all that on an invoice you could go down and do the same thing here.

Then you have the Footer tab. Now, I want you to notice down at the bottom, this is what’s in the footer now. They’ve got the subtotal. They have the sales tax, the total, payments and credits, and balance due. That is way too many fields to have at the bottom of your template.

I would probably do something like this. So, first of all, customer message is going to go right in here! That’s going to be things like “Have a nice day”, “Thank you for your business”.

I would probably take off subtotal. I would take off sales tax. Now sales tax will always print up here underneath the last line item. So, you’re not telling QuickBooks you don’t want to see the sales tax.

You’re just not going to show it down here: Payments and credits and then balance due. So, typically this is what you’ll see on a generic invoice in QuickBooks.

Now, every now and then. You may have a customer that says, “Can you send me an invoice that shows me the balance due on an invoice”, if they have been making payments, for example. If that’s the case, then, you would do something like this. Where you have the total, the payments, and then the balance due. We’ll leave it like that.

The last tab is Print. Here! You can choose some printer settings. If you want to get to these options, you have to check Use specified printer settings below. But here! You could have your orientation portrait or landscape. You could tell QuickBooks, you want two copies automatically. If you have a different size paper, you can set that up as well.

It’s going to print page numbers on any forms that have more than two pages. And you probably want the trailing zeros. That’s basically if something cost $54 it’ll actually put the point-zero-zero in there for you.

And that’s really all you have to do for the additional customization options.

What I’d like to do now is take this even further and go into the Layout Designer and show you how to actually make these columns look the way you’d like them to look, move the picture, and make it just look like you would want it to look in your business.

Cindy McGuckin

Cindy McGuckin is an IT trainer with over 20 years of experience. Cindy currently manages the IT Training Department at Trident Technical College, she's a Member of the Association of IT Professionals, Charleston, SC chapter and the Treasurer of the South Carolina Association of Continuing Higher Education. Cindy is a Microsoft Office and QuickBooks expert and her online courses have received hundreds of 5-star reviews. Her no-nonsense approach to teaching complicated topics makes her classes engaging and interesting.

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Project 2019: Accessing Task Properties

Formatting Objects in PowerPoint 2016 Part 1

How to Do Hanging Indent on Word?- 2 Easy Methods

Linking Shapes and Diagrams in Visio 2010

Introduction to Power Automate

How to Set Up a Chart of Accounts in QuickBooks Pro 2017 Part 1

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)