How to Enter Bills in QuickBooks

It’s not as much fun as creating invoices, but the bills must be paid. Here’s how QuickBooks helps.

We’re in a bit of a transitional period with business bill-paying. Some paper bills still come via the U.S. Mail, however you may also be getting some through email. Others don’t come at all: You might get a reminder email, but you have to go to the vendor’s site to make a payment.

How do you keep track of it all so you don’t miss any due dates? You could record them on a calendar, but you’d still have to go back to the actual bill to retrieve the amount. But where is it? Is it online, in your email inbox, in a file folder, or hanging on the wall?

QuickBooks can organize this unpleasant process, saving time and helping you avoid confusion. Here’s how it works.

A 2-Step Process

QuickBooks divides your accounts payable tasks into two separate processes: entering bills and paying them. It requires some extra time upfront as you complete the first step, but streamlines the second so that the actual bill-paying only takes a few seconds.

To get started, click Enter Bills on QuickBooks’ home page to open a window like this:

Before you can pay a bill in QuickBooks, you need to create a record for it.

Before you can pay a bill in QuickBooks, you need to create a record for it.

The toolbar for the Enter Bills window is not pictured in the image above, but you don’t need it yet. Rather, you start by clicking the down arrow in the field next to VENDOR and selecting the biller’s name from your list (or clicking <Add New> if you haven’t yet created a record for that entity). The ADDRESS should fill in automatically, as should the date. 

If you set up default payment TERMS in that vendor’s record, your preference should show in that field and the BILL DUE date should be correct. Enter the AMOUNT DUE and complete any of the optional fields that the transaction requires (REF. NO., DISCOUNT DATE, and MEMO). 

Since this is a utility bill, the Expenses tab should be highlighted, and the amount you entered above should appear in it. Below that is the ACCOUNT field; open that list and choose the right one. Don’t worry about the CUSTOMER:JOB and BILLABLE fields. These will only be completed when you’re charging a customer for an expense or item. 

Warning: If you’re not familiar with the concept of assigning accounts to transactions, please schedule some time with us. This is a critical designation that affects so many other areas of QuickBooks.

Saving Your Work

The toolbar from the    Enter Bills    window

The toolbar from the Enter Bills window

Once you save your bill, you’ll be able to access it when it’s time to apply payment. How will you remember when it’s due, though? QuickBooks can remind you – or even pay it automatically. So, before you leave the Enter Bills window, click Memorize in the toolbar pictured above.

The Memorize Transaction window will open with your vendor already entered in the Name field. You’ll have three options here:

  • Add to my Reminders list. QuickBooks can add this bill to its list of Reminders. To ensure that you’ll see this every time you open the software and can make any changes necessary, open the Edit menu and click Preferences | Reminders | My Preferences. Click in the box in front of Show Reminders List when opening a Company file. Then click the Company Preferences tab (if you’re the administrator) and find the Bills to Pay row. Click the appropriate button to indicate whether you want QuickBooks to Show Summary or Show List, and enter the number of days before due date.

  • Do Not Remind Me. Just what it sounds like.

  • Automate Transaction Entry. You can only select this if the transaction will be exactly the same every time (except for the date). If the number of transactions will be limited, enter the Number Remaining. And tell QuickBooks how many Days in Advance To Enter.

If you choose the third option here, be very careful when you define the automation. You should really only do this if you’re an advanced user.

If you choose the third option here, be very careful when you define the automation. You should really only do this if you’re an advanced user.


When you’re done, click OK to close the box, and save the bill.

Next month, we’ll talk about the second step: the actual paying of bills. In the meantime, let us know if you want to schedule a session to go over any aspect of your accounts payable – or anything else in QuickBooks.

Social media posts

Are you missing bill due dates because you can’t seem to get your accounts payable organized? QuickBooks can help.

You can save an enormous amount of time and frustration if you use QuickBooks’ bill-paying tools. Are you familiar with how to do this? Ask us about this feature.

QuickBooks can remind you when your bill payments should be processed, or it can send them automatically. Let us help with setup.

Paying bills in QuickBooks is actually a two-step process. Once you’ve entered bills, paying them just takes a few seconds. We can show you how.





Customer Statements: When, Why, and How

rawpixel-589084-unsplash.jpg

If your business relies on invoices to get paid, there may be times when you need to create and send statements.

You enter into an informal contract with a customer when you send an invoice. You expect that you will receive payment in a timely fashion for goods or services you’ve sold.

That probably works most of the time. But what happens when it doesn’t, when you’ve sent a reminder and are still waiting? And what do you do when a customer orders frequently and is confused about what’s been paid and what hasn’t?

If you’re using QuickBooks Online, you can easily send a statement, a list of sales transactions, credits, and payments. There are three kinds of these:

  • Balance Forward. This document emphasizes what’s currently owed by displaying it at the top. Below that is a list of sales transactions that occurred between two dates you specify.

  • Open Item. You select a date, and the statement shows all transactions that were completed before it.

  • Transaction Statement. There’s no total balance here, just the amounts billed and received for every transaction.

Setting Up Statements

Balance Forward    statements cover a period of transactions that you define.

Balance Forward statements cover a period of transactions that you define.

There are three way to create statements. You can:

  • Click the Plus (+) icon at the top of the screen.

  • Dispatch one while you’re in a customer record.

  • Launch a batch action from the Customer screen.

Before you create your first statement, though, make sure QuickBooks Online is set up the way you want it to be. Click the gear icon in the upper right of the screen and select Your Company  Account and Settings. Click the Sales tab and scroll down to Statements. Click Statements to open the options there.

You can List each transaction as a single line or List each transaction including all detail lines. Click the button in front of the one you prefer. If you want to Show aging table at bottom of statement, click in the box. This will show customers how many days each transaction is overdue.

Click Save when you’re done.


Creating Statements

If you’ve already started entering transactions so there’s some data in QuickBooks Online, click the Plus (+) icon in the upper right corner of the screen.

Tip: If you don’t see the plus (+) icon, you’re in an active screen. Click the X in the upper right to close it, saving it first if necessary.

Click Statement, which is located under Other on the far right. Under Statement Type, select Balance Forward. Below that is the Customer Balance Status field. Do you want to see customers with open balances, those who have overdue invoices, or all customers? The third option will include credit memos.

Select a Start Date and End Date. In this example, these were 04/09/2018 and 09/09/2018, and the statement date was 09/10/2018.  Click Apply. QuickBooks Online will display a list of matching customers. Click Print or Preview at the bottom of the screen to see your statements.


In this preview, the customer’s balance forward on 04/09/2018 was $8,245.05. A catch-up payment was made on 08/09/2018 and another invoice sent on 09/01/2018, which accounts for the    TOTAL DUE    at the top.

In this preview, the customer’s balance forward on 04/09/2018 was $8,245.05. A catch-up payment was made on 08/09/2018 and another invoice sent on 09/01/2018, which accounts for the TOTAL DUE at the top.

From this screen, you can either Print the statements or Close to go back to the previous page, where you can Save and Send.


Two Other Options

As we stated earlier, there are two other ways to create statements. Click Sales in the left vertical toolbar and highlight the Customers tab by clicking on it. Hover your cursor over a customer and click the down arrow at the very end of that line. From the list that opens, select Create statement.

You can also hand-pick multiple customers to receive statements. With the Customers window open, click in the box in front of your choices, and then click the down arrow next to Batch actions at the top of the list. Select Create statements.

The mechanics of creating statements in QuickBooks are fairly simple. But you don’t want to send an inaccurate one to a customer. Make sure your transactions are up to date before you generate any statements, and choose your date ranges carefully. As always, we’re available to help with this task – or any other area of QuickBooks Online that might be confusing to you. We’re here to help you be pro-active to avoid problems in the long run.


Social media posts

Are some of your customers behind on paying multiple invoices? QuickBooks Online lets you create statements that summarize unpaid transactions.

Is your cash flow suffering because of multiple unpaid invoices? Talk to us about your options, which include creating statements in QuickBooks Online.

QuickBooks Online offers three ways to create statements, including hand-picking the customers who should receive them. Follow these steps to set up this pro-active feature.

QuickBooks Online statements are lists of customer transactions that fall between specified dates. Talk to us about when and how you should use them.








How QuickBooks Online Can Improve Your Company's Financial Health

office-1209640_640.jpg

QuickBooks Online is more than just an online bookkeeper. It can help improve your cash flow, your customer relationships, your inventory readiness, and your future.

 

If you’re already using QuickBooks Online, you know how much impact its bookkeeping abilities have had on your company’s accounting operations. You’re saving time, which in-turn saves money, and you’re reducing errors. When a customer or vendor calls with a question, or you yourself need to track down a critical detail to solve a problem, you’re able to find solutions quickly.

You may already have learned, though, that QuickBooks Online’s benefits include much more than simply getting the numbers right. When you take advantage of all it can offer, you’re likely to notice more far-reaching effects.

 The Specifics

Let’s look at how QuickBooks Online accomplishes all of this. You can do much of it on your own, but we’re trained to help small businesses get the most out of QuickBooks Online. We can help you maximize the effectiveness of your accounting time so your company can:

 Better balance between income and expenses.

NJNAug28Photo1.jpg

QuickBooks Online provides quick, real-time overviews of your sales status.

You can’t begin to improve your company’s cash flow until you understand where the financial bottlenecks are. QuickBooks Online provides that information for both income and expenses in a variety of ways. In the image above, you can see that there are seven past-due invoices. Click on the orange bar to see a list of them, and you can automatically send reminders. QuickBooks Online also automates the process of sending statements.

You can also run accounts receivable and accounts payable reports that will show where you stand with customers and vendors, like Open Invoices, Uninvoiced Time, Unpaid Bills, and Accounts Payable Aging Detail. If you determine that one of your consistent problems with cash flow is late customer payments, you can set up a merchant account through QuickBooks Online to support credit card payments and bank transfers.

 More repeat business because of improved customer interaction.

Your customers are like gold. To build the best relationships possible with them, you need a clear, updated picture of their transactions, their payment details and history, and your interaction with them. QuickBooks Online provides templates for Customer Information records that provide all of that, along with their contact information and a real-time update of the status of their invoices and payments, estimates, time activities, etc. The latter is provided in the form of an interactive list with links to immediate actions you can take.

 A more stable, profitable inventory of products.

If your business sells products, you know that you have to be smart about inventory levels. Stock too much and you have too much money tied up unnecessarily. Too little, and you’ll be turning customers away and possibly losing their future business. QuickBooks Online’s inventory-tracking tools help you achieve and maintain that balance, so you know both when and how much to reorder.

NJNAug28Photo2.jpg

It’s easy to evaluate your inventory status very quickly in QuickBooks Online.

 QuickBooks Online also offers multiple inventory reports, like Inventory Valuation Detail, Physical Inventory Worksheet, and Sales by Product/Service Detail.

 Readiness for growth.

You may never want to acquire another company, or move into more spacious offices, or employ dozens of individuals. However, it’s not often that a company doesn’t want to be in a position to grow. And you never know when an opportunity will present itself that would require additional capital. Would you be ready?

If you’ve never applied for a business loan or tried to attract investors, you don’t know how much financial information you’ll need to provide, or in what format. There are very specific reports your potential lenders or investors will want to see, standard financial statements. QuickBooks Online includes templates for these, which include a Balance Sheet, Profit and Loss, and Statement of Cash Flows.

Like the reports we mentioned earlier, they’re easy to generate on the site, thanks to intelligent, customizable templates. Analyzing them, though, and making sure they’re ready to be seen by third-parties takes professional expertise. We can provide that for you. We can also help you better understand and use other elements of QuickBooks Online so that you’re taking advantage of all of its benefits. Contact us soon to set up an initial consultation.

How to Use Memorized Transactions in QuickBooks

Tired of repetitive data entry? QuickBooks provides a way to save time and keystrokes when you create some transactions.

Tired of repetitive data entry? QuickBooks provides a way to save time and keystrokes when you create some transactions.

We wrote last month about the benefits of having QuickBooks on your desktop. Among those we listed are three that have impact on every business that uses it. QuickBooks helps you:

  • Save time.
  • Save money.
  • Minimize errors.

There are numerous examples we could use to illustrate how the software accomplishes this. What we want to talk about this month is the use of memorized transactions. These are templates you set up that contain most if not all the information that could be repeated at specified intervals, eliminating the need for you to enter the same repetitive data regularly and reducing the chances that you’ll make a mistake.

You can create these transaction “models” for both sale and purchase transactions. For example, you might have wireless service bills that remain the same every month or vary by just a bit. Or, you have customers who have monthly standing orders for the same products, or services, or subscription fees. 

QuickBooks makes it very easy to set up transactions for repetitive use. Here’s how it works. We recommend you use one of QuickBooks’ sample files for this tutorial.

 

Creating a Template

Let’s start by creating a repeating bill. Click Enter Bills on the home page and complete all the fields that will remain the same every time the bill is created. In our example, we’re paying a utility bill whose Amount Due will change every month, so we’re leaving that blank. When you’re done, click Memorize in the toolbar to open this window:

 

Once you’ve created a transaction template, you’ll have to complete the fields in this window to memorize it correctly.

Once you’ve created a transaction template, you’ll have to complete the fields in this window to memorize it correctly.

 

 

 

 

 

 

The vendor name appears automatically in a field in the upper left. Below that is a list of four options. These have to do with how/if you want to be notified when it’s time to process a memorized transaction. Your choices are:

  • Add to my Reminders List. QuickBooks will display an entry in your Reminders List for each memorized transaction. Not using Reminders? Let us help.
  • Do Not Remind Me. Nothing will be done.
  • Automate Transaction Entry. You would only select this option if nothing but the date of the transaction changes when it recurs. QuickBooks would automatically process and dispatch the transaction.
  • Add to Group. If you have multiple recurring transactions that come due at the same time, you can create Groups and assign transactions to them (more on this later).
  • On the right side of the window, open the drop-down list in the field next to How Often and select from the options provided. Click the calendar icon to choose the transaction’s Next (Due) Date. If you only want QuickBooks to automate the entry a specific number of times, add that in the field next to Number Remaining. Then enter the Days In Advance To Enter.

 

Further Explanation Needed

We’d like to expand on two of the concepts discussed here. First, advance notice for transactions. If you’ve selected Add to my Reminders List for any memorized transactions, you need to tell QuickBooks how far in advance your reminders should start to appear. Open the Edit menu and select Preferences, then Reminders.

If you want    Reminders    for memorized transactions, you’ll need to tell QuickBooks what your    Preferences    are.

If you want Reminders for memorized transactions, you’ll need to tell QuickBooks what your Preferences are.

 

Memorized Transactions Due appears toward the bottom of the Company Preferences list. Click on the appropriate button to indicate whether you want to see a summary or a list in your Reminders (or nothing at all) and how many days in advance the alert should appear.

Also, Groups. As we mentioned earlier, you can combine memorized transactions due at the same time within a group. To create one, go to Lists | Memorized Transaction List. Click the arrow next to Memorized Transaction in the lower left, then click New Group and give it a name. Choose from the options available for notification and click OK

Now you can add memorized transactions to this Group by right-clicking on it, selecting Edit Memorized Transaction, and clicking in the button next to Add to Group. Click the down area to the right of the field assigned to Group Name and select the one you just created.

 

You can add memorized transactions to a    Group    and process them at the same time.

You can add memorized transactions to a Group and process them at the same time.

 

Caution Advised

We’ve explored this QuickBooks feature with you because we wanted you to see one of the ways that the software can save time and minimize errors. There are many others, and we’re always happy to introduce you to more.

The mechanics of creating memorized transactions are fairly simple. But mistakes can be costly in terms of bills that don’t get paid on time (or at all) and items or services that don’t get invoiced. If you’re new to QuickBooks, we certainly suggest you not work with these on your own. Even if you’re a seasoned user, you may want our help setting up memorized transactions for the first time. Let us know if you need assistance with this or any other element of QuickBooks accounting, we’re ready to help.

Establishing Preferences in QuickBooks: Part II

Before you start entering data, make sure QuickBooks is set up appropriately for your   company.  &nbsp;

Before you start entering data, make sure QuickBooks is set up appropriately for your company. 

QuickBooks was designed to serve the needs of millions of small businesses. To do that,  it had to include the tools and processes suitable for a wide variety of companies. But  Intuit recognized that every organization is unique, so your copy of QuickBooks can be customized in ways that make it work best for you.  You could just dive in and start adding records and transactions. But we recommend you do some setup first. If you don’t, you may run into some issues later, such as finding that some features you need haven’t been turned on, for example, or that QuickBooks is simply not doing some things the way you do. The good news is that you can change many of these. 

Getting There QuickBooks refers to these options as Preferences. You’ll find them by opening the Edit menu and selecting Preferences

To start customizing QuickBooks so it works best for you, open the      Edit    menu and   choose      Preferences   .&nbsp;

To start customizing QuickBooks so it works best for you, open the Edit menu and choose Preferences

As you can see, the left vertical pane contains a list of Preference types. Click on any of   these to change the option screens to the right. Always click the tabs labeled My Preferences and Company Preferences to make sure you see everything that’s displayed for each type (sometimes one will have no choices). 

 Setting Up Reminders Let’s look closely at one set of Preferences: Reminders. It’s very important that you visit these screens when you begin using QuickBooks. Depending on how big your company is and how complex your accounting processes are, there may be things you need to do every day, like pay bills and follow up on overdue invoices. It would be nearly impossible for you to do everything on time if you didn’t ask QuickBooks to keep track of critical dates and remind you of them. 

Click Reminders in the left vertical tab. You’ll see one option under My Preferences. Do you want QuickBooks to show Reminders List when opening a Company file? If so—and this is a good idea—click the box in front of that line if there isn’t a checkmark there already. 

Then click Company Preferences. Here’s where you’ll tell QuickBooks whether you want to see summaries or lists for each reminder, or neither. You can also specify how much advance notice you want for specific tasks by entering a number of days. QuickBooks comes with default settings, but you can easily change these.

QuickBooks comes with default settings for      Reminders   , but you can enter your own    Preferences    here.  &nbsp;

QuickBooks comes with default settings for Reminders, but you can enter your own Preferences here. 

As you can see, it’s easy to specify your Company Preferences. Click the appropriate button under Show Summary, Show List, or Don’t Remind Me. If you’ve requested a reminder, delete any number that appears in the box in front of days before or days after and then enter your own. 

Critical Areas We recommend that you look through all of QuickBooks’ Preferences and change any that don’t fit your company. Some simply have to do with the way QuickBooks displays information and how it functions, but others have direct impact on your accounting work. As always, we’re available if you have questions here. 

There are many that you will probably want to visit. They may have numerous options, but here’s some of what you can establish in each: 

  • Accounting. Do you want to use account numbers and classes?
  • Checking. Which accounts should QuickBooks automatically use for tasks like 
  • Open the Pay Bills, Open the Make Deposits, and Open the Create Paychecks
  • Finance Charge. Will you be assessing finance charges on late payments from customers? What’s the interest rate, minimum finance charge, and grace period? 
  • Items & Inventory. Do you want inventory and purchase orders to be active?
  • Multiple Currencies. Does your company do business using other currencies? 
  • Payments. Can customers pay you online? What methods can they use?
  • Payroll & Employees. Will you be processing payroll using QuickBooks?
  • Sales & Customers. Do you want to use sales orders? How should QuickBooks handle invoices when there are time and costs that need to be added? 

You can see why it’s important to study QuickBooks’ Preferences early on. It’ll help you avoid unnecessary roadblocks and ensure that your company’s needs are reflected well in the software. 

           

Establishing Preferences in QuickBooks: Part I  

Before you start entering data, make sure QuickBooks is set up appropriately for your   company.  &nbsp;

Before you start entering data, make sure QuickBooks is set up appropriately for your company. 

QuickBooks was designed to serve the needs of millions of small businesses. To do that,  it had to include the tools and processes suitable for a wide variety of companies. But  Intuit recognized that every organization is unique, so your copy of QuickBooks can be customized in ways that make it work best for you.  You could just dive in and start adding records and transactions. But we recommend you do some setup first. If you don’t, you may run into some issues later, such as finding that some features you need haven’t been turned on, for example, or that QuickBooks is simply not doing some things the way you do. The good news is that you can change many of these. 

Getting There QuickBooks refers to these options as Preferences. You’ll find them by opening the Edit menu and selecting Preferences

To start customizing QuickBooks so it works best for you, open the      Edit    menu and choose      Preferences   .&nbsp;

To start customizing QuickBooks so it works best for you, open the Edit menu and choose Preferences

As you can see, the left vertical pane contains a list of Preference types. Click on any of   these to change the option screens to the right. Always click the tabs labeled My Preferences and Company Preferences to make sure you see everything that’s displayed for each type (sometimes one will have no choices). 

Setting Up Reminders Let’s look closely at one set of Preferences: Reminders. It’s very important that you visit these screens when you begin using QuickBooks. Depending on how big your company is and how complex your accounting processes are, there may be things you need to do every day, like pay bills and follow up on overdue invoices. It would be nearly impossible for you to do everything on time if you didn’t ask QuickBooks to keep track of critical dates and remind you of them. 

Click Reminders in the left vertical tab. You’ll see one option under My Preferences. Do you want QuickBooks to show Reminders List when opening a Company file? If so—and this is a good idea—click the box in front of that line if there isn’t a checkmark there already. 

Then click Company Preferences. Here’s where you’ll tell QuickBooks whether youwant to see summaries or lists for each reminder, or neither. You can also specify how much advance notice you want for specific tasks by entering a number of days. 

QuickBooks comes with default settings for      Reminders   , but you can enter your own    Preferences    here.  &nbsp; &nbsp; &nbsp;

QuickBooks comes with default settings for Reminders, but you can enter your own Preferences here.    

As you can see, it’s easy to specify your Company Preferences. Click the appropriate    button under Show Summary, Show List, or Don’t Remind Me. If you’ve requested a reminder, delete any number that appears in the box in front of days   before or days after and then enter your own. 

Critical Areas We recommend that you look through all of QuickBooks’ Preferences and change any that don’t fit your company. Some simply have to do with the way QuickBooks displays  information and how it functions, but others have direct impact on your accounting  work. As always, we’re available if you have questions here. 

There are many that you will probably want to visit. They may have numerous options, but here’s some of what you can establish in each: 

  • Accounting. Do you want to use account numbers and classes?
  • Checking. Which accounts should QuickBooks automatically use for tasks like  Open the Pay Bills, Open the Make Deposits, and Open the Create Paychecks
  • Finance Charge. Will you be assessing finance charges on late payments from 
  • customers? What’s the interest rate, minimum finance charge, and grace period? 
  • Items & Inventory. Do you want inventory and purchase orders to be active?
  • Multiple Currencies. Does your company do business using other currencies? 
  • Payments. Can customers pay you online? What methods can they use?
  • Payroll & Employees. Will you be processing payroll using QuickBooks?
  • Sales & Customers. Do you want to use sales orders? How should QuickBooks  handle invoices when there are time and costs that need to be added? 

You can see why it’s important to study QuickBooks’ Preferences early on. It’ll help you avoid unnecessary roadblocks and ensure that your company’s needs are reflected well in the software. 

Anatomy of a QuickBooks Inventory Item 

If you have an item-heavy business, you need tools to track your inventory. QuickBooks provides them. 

 When you started your business, maybe you were able to keep track of your inventory by  peering in the closet or your garage. As you grew, that simply took too long. But you grew tired of running out of stock because you didn’t have time to constantly check its  levels, and you forgot about items that didn’t sell and were tucked away in a corner. 

You need inventory-tracking. QuickBooks can help you create thorough records for each product you sell. It keeps track of how much you have on hand and warns you when your stock is running low. And its reports tell you what’s selling and what’s not, so you can make better, smarter purchasing decisions. 

Activating Inventory-Tracking

Before you get started creating item records and including them in transactions, you 

need to make sure that QuickBooks is set up to start tracking. Open the Edit menu and click Preferences. Click Items & Inventory in the left vertical pane and then select 

the Company Preferences tab. This window will open: 

QuickBooks needs to know what your intentions are when it comes to inventory   tracking.&nbsp;

QuickBooks needs to know what your intentions are when it comes to inventory tracking. 

First, of course, click in the box to the left of Inventory and purchase orders are   active if it isn’t already checked. Click the next box down if applicable. The rest of this window deals with two concepts you need to understand. Quantity on Hand refers to  the number of items that you actually have. Quantity Available subtracts items  currently on Sales Orders.

QuickBooks will warn you if you don’t have enough of a specific item to commit to a customer. You just have to decide which definition of Quantity you want to use. When you’re done here, click OK.  

Accuracy Matters

Now you can start entering records for the products you sell. Accuracy is absolutely essential here. You’ll see why as you explore QuickBooks’ tracking capabilities. 

There are a few ways to open an item record window. You can click Items & Services in the upper right corner of the Home Page, or open the Lists menu and select Item List. Both will open a window displaying any item records that have been entered in a 

register-type view. Right-click anywhere and select New, or click the arrow next to Item in the lower left corner and select New

Double- and triple-check your work as you enter information in the QuickBooks item   record window.  &nbsp;

Double- and triple-check your work as you enter information in the QuickBooks item record window. 

QuickBooks lets you create records for numerous types of items, including Service,   Discount, and Inventory Assembly. To see how inventory-tracking works, select Inventory Part from the drop-down menu under TYPE. Next, enter an Item Name/Number in that field.  

 If you’ve already named a main category (like Hardware, in the example above) and  want to place your product in a subcategory of it, click the Subitem of box and choose  from the drop-down list. Manufacturer’s Part Number is optional. You can ignore UNIT OF MEASURE, if this isn’t an option in your version of QuickBooks. 

Purchase Information

If you buy this item from a vendor, fill in this side of the window. Write the description that should appear on purchase transactions when you place an order. Enter the cost you pay for it, and select the COGS (Cost of Goods Sold) account if the default isn’t correct. Do you buy this product exclusively from one supplier? Select the name in the drop-down menu under Preferred Vendor. Sales Information Enter the description you’d like customers to see on invoices and the price you’ll charge. If you’re at all unsure of what to select for Tax Code or Income Account, we can go over your Chart of Accounts with you and explain how its accounts are used in records and transactions. 

Inventory Information 

Here’s where the software’s tracking capabilities come in. QuickBooks will probably default to your Inventory Asset account, which is fine. Enter the minimum number of items that should be in stock when you get a reminder to reorder, and the maximum you want to have at any one time. Fill in the On Hand field with the number you currently have. QuickBooks will automatically calculate the Total Value. In the screen shot above, you see an example of what that last line looks like once you start using that item in transactions. You’ll see its Average Cost and the number that are currently on purchase orders and sales orders. Creating records for every product you sell can be tedious, time-consuming work. But the payoff comes in the real-time knowledge you’ll have of your inventory that will lead to better, smarter purchasing decisions.

 

As always, we stand ready to help. 

 

 

                      

Use Recurring Transactions in QuickBooks Online

Save time and ensure that repeating transactions are processed as scheduled.

Save time and ensure that repeating transactions are processed as scheduled.

You know how much time QuickBooks Online already saves you. Customer, vendor, and item records need never be entered again once they’re created for the first time. Pre-built forms use your record data to complete transactions quickly and accurately. Customizable report templates provide real-time overviews of your financial status in every area.

There’s another way QuickBooks Online can reduce the time you spend on accounting chores: recurring transactions. If you have invoices, bills, and other transactions that occur on a regular basis, you can save all or part of their data to use again. You can even choose to have them dispatched automatically. 

Here’s how it works. You need to create a template, a type of model, for each recurring transaction. To do this, simply create the transaction you want to repeat. Say it’s an invoice for a service you provide monthly to a company or individual. You’d fill in all the required fields, then click Make recurring in the horizontal toolbar at the bottom of the screen. This window will open:

When you click    Make recurring    at the bottom of a transaction, this window of options will display.

When you click Make recurring at the bottom of a transaction, this window of options will display.

Select the Customer first by clicking the arrows to the right of the blank field. QuickBooks Online will fill in contact information and automatically display name that as the Template name. You can leave it there, or you can try to think of a phrase that describes the transaction, so you’ll remember it. Next, you need to decide how QuickBooks Online will handle the transaction. There are three options:

  • Scheduled. Be very careful with this one, since QuickBooks Online will automatically create and dispatch it. This only works if the information in the transaction—minus the date—is always exactly the same.
  • Reminder. This is safer. QuickBooks Online will display a reminder in time for you to complete and process the transaction.
  • Unscheduled. QuickBooks Online will do neither of the above, but the template will be available to use as you need it. This is good for infrequent transactions that share some common information.

Next, taking into account variables like delivery methods and due dates, enter a number in the field in front of days in advance. Then skip down to Options and click the box in front of all the statements that apply to that transaction. The bottom line in this window contains the fields that will let you specify the transaction’s Interval. Click the arrows next to each field to open its menu. 

In the example above, we’ve indicated that the invoice occurs monthly on the first day of the month, starting on January 1, 2017. You don’t know how long this will recur, so we’ve left End set to None. When you’re satisfied with everything in the window, click Save template in the lower right corner.

To see a list of the repeating transactions you’ve defined, click the gear icon in the upper right corner of the screen and select Recurring Transactions. A table displaying them will open and display columns including Type, Interval, and Previous Date. Look toward the end of one of these lines. To modify the template, click Edit.

The    Recurring Transactions    screen gives you an overview of the templates you’ve created and provides links to action options.

The Recurring Transactions screen gives you an overview of the templates you’ve created and provides links to action options.

There are other options here that vary depending on the type of transaction. In the screen shot above, the template is a bill. You can:

  • Use it to create a new transaction,
  • Duplicate it and modify it, to make a new template,
  • Pause it, to temporarily suspend its recurrence,
  • Skip next date and resume after the next interval, or
  • Delete it.

QuickBooks Online also includes a report that will display all the templates you’ve created. Click Reports in the left vertical pane, then All Reports (unless this list is already active), then Accountant Reports. You’ll find the Recurring Template List in the lower right corner.

Recurring transaction templates can save you a lot of time and increase accuracy. Conversely, they can result in unbilled revenue and past-due bills—or even duplicate transactions—if they’re not created with precision. We’d be happy to step in and guide you through the process for the first time.

Paying Bills in QuickBooks Online 

In a previous column, we talked about setting up bills in QuickBooks Online. Now it’s time to pay them.

We recently laid out the benefits of using QuickBooks Online for bill entry and payment. It’s faster than manual methods. It leaves an electronic record of your accounts payable. And it helps ensure that bills are paid accurately and on time.

As we discussed, QuickBooks Online employs a two-step process for bill payment. Once you’ve completed the first (setup), the hard part is done, and you can move on to fulfilling your financial obligations. Let’s take a look.

Warning: Because you may be “handling” a lot of your bills twice in QuickBooks Online, this system can take some getting used to. We’ll be happy to walk you through the process until you’re comfortable.

Before you can pay a bill, you must create a template and enter its details. You can even set up payments to recur, as shown here.

Before you can pay a bill, you must create a template and enter its details. You can even set up payments to recur, as shown here.

To review quickly, we created a bill by clicking on the plus (+) sign at the top of the screen and selecting Bill under Vendors. Once you’ve created a bill, you can click on Make recurring at the bottom of the screen to establish periodic payments (as pictured above). You can choose to have payments that are always the same sent automatically, or you can request a reminder so that you can change the amount before emailing or printing. Those reminders appear when you first log into QuickBooks Online. You can access them by clicking on the corresponding link under Tasks

Making Payments

QuickBooks Online makes it very easy to pay bills. You can do so from a handful of different screens on the site – sometimes in multiple places on the same page.

  • Click on the Vendors tab in the vertical toolbar on the left side of the screen. The page that opens displays a horizontal chain of bars near the top, color-coded to indicate what they represent: Purchase Order, Open Bills, Overdue, and Paid Last 30 Days. Each segment tells you how many transactions share that status as well as their total dollar amount. When you click on a segment, the table below changes to include a list of the actual transactions. At the right end of each line is a Make Payment link that you can click to get a payment screen. If you want to see the actual bill that was sent, click on the Vendor name itself.
  • You can click on the plus (+) sign at the top of any screen where it appears and go to Vendors | Pay Bills.
  • Open the bill itself and click on the Make Payment link in the upper right corner.
A partial view of the    Bill Payment    screen

A partial view of the Bill Payment screen

When you’ve opened a bill that you want to pay, double-check the information in the upper part of the screen. The Vendor details should, of course, be correct, but make sure the date reads as it should. And look in the box to the right of the vendor’s name. If it’s not displaying the correct account for the transaction, click on the double arrows and select the right one.

QuickBooks Online will follow its own numbering system for bill payments. If you want to assign your own by entering a reference number of some kind, delete what’s showing in the Ref no. field and add your own. The Bill Payment # in the upper left will change to reflect that.

If there are multiple bills in the list below, click in the box in front of the one(s) you want to pay to create a checkmark. Look at the end of each line, too. QuickBooks Online defaults to a full payment for bills. If for some reason you’re planning to make a partial payment, replace the dollar amount in the Payment box with your own. In the bottom left portion of the screen, you can enter a Memo if you’d like and add an Attachment. When you’ve checked everything for accuracy, click Save and close or Save and new in the lower right corner.

Automation Helps

Paying bills manually can be painful. Beyond the fact that you’re watching money leave your accounts, the mechanics of writing checks and/or dispatching electronic payments on time—and keeping everything organized—can be a constant challenge. QuickBooks Online’s bill-paying tools can help with that.

Customizing QuickBooks Online Forms

Make a good impression on your customers by sending them well-designed sales forms. QuickBooks Online helps you create them. 

Your company’s “brand” can be composed of many things (and has many definitions), but it’s really about what pops into your customers’ minds when they think of you. Key components include your logo, your color scheme, and any other identifying visual element that people associate with your business.

A good way to reinforce this image is by making sure that a unifying graphic theme runs through every piece of print or web-based customer content you create, like your website, brochures, blog, and ebooks. Your brand should also be visible on all sales forms you dispatch, like invoices and receipts.

QuickBooks Online comes with its own default sales form style; this is the layout and content that will automatically display when you start a new transaction. You can easily change this and have it apply to all transactions.

Your logo is an important element of your company’s brand. QuickBooks Online lets you include it on sales forms.

Your logo is an important element of your company’s brand. QuickBooks Online lets you include it on sales forms.

Here’s how it works. Click on the gear icon in the upper right of the screen, next to your company name. Select Custom Form Styles to open the table of existing styles. There should be one labeled Standard, though there may be another labeled Classic. You can make either the default by clicking Make Default or Remove as default using the down arrows and links under ACTION at the far right of each row.

Click the Edit link for the default style. This screen contains many of QuickBooks Online’s customization tools. The Style tab in the left vertical toolbar is automatically highlighted. In the column to its right, click through the five design options available and leave the desired one selected. Then click the plus (+) sign in the upper right of the screen. Browse for your logo file when the directory opens and double-click on it to add it to the top of your sales forms. Choose the color scheme you want by clicking in the correct box displayed below.

When you’re done there, click on the Appearance tab to specify your logo’s placement and change any other settings.

Content Critical

You can decide which fields should and shouldn’t appear on your sales forms by checking and unchecking boxes.

You can decide which fields should and shouldn’t appear on your sales forms by checking and unchecking boxes.

You won’t necessarily need to make every data field available on your sales forms. But you want to include every field you might possibly need without displaying extraneous content areas. QuickBooks Online lets you turn fields on and off and change their labels easily by checking and unchecking boxes.

Click the Header tab on the left to start this process. Among your options here are:

  • Form names. Do you want invoices to say “Invoice,” for example? Do you want to use form numbers and allow custom transaction numbers?
  • Company. How much of your company’s contact information should appear?
  • Customer. Do you want fields for Terms, Due date, etc?
  • Custom. Do you need to define custom fields?

You’ll see more options when you click on the Activity Table tab in the left vertical pane (see image above). Not only can you choose what content appears and how its labels read, but you can also indicate what percentage of that line each entry should occupy. Under WIDTH%, click on the plus (+) and minus (-) buttons to the right of each number to size it (your numbers, of course, should total 100).

Warning: Many of the decisions you have to make when customizing sales forms are simple. Others take some consideration, like custom fields and the handling of billable time. We can help you with these.

Click on the final tab in the left navigation pane, Footer, to add or edit text that should be displayed at the bottom of your sales forms. Click Save in the lower right when you’re done.

Some settings may need to be tweaked in    Account and Settings.

Some settings may need to be tweaked in Account and Settings.

Note: As you’re browsing through the content options available as described above, you may find that a field appears to be missing or needs a default setting changed. If this occurs, click on the gear icon in the upper right of the main screen, then on Your Company | Account and Settings. Click on the Sales tab in the left vertical pane to get to Sales form content.

Consistent, well-designed sales forms will help promote your brand and present a polished, professional image to your customers.