As Accountants we default to the tried and true – the journal entry – we use the traditional system of accounting to record, adjust and correct all things. A debit here, a credit there and voila, we are done.

Not so in QuickBooks® – Journal entries do not use “Items” and items are the backbone of all the subsidiary reports in QuickBooks®. When you run job profitability reports, the costs recorded by journal entries do not show up on the Profit & Loss by Job reports. This holds true for any item-based reports in QuickBooks®.

QuickBooks® likes to have all transactions start with the source document – a Sales Receipt, an Invoice, a Credit Memo, a Payment Receipt, a Deposit, a Bill, a Credit, a Bill Payment, a Check, a Credit Card Charge, a Statement Charge, an Inventory Adjustment, a Sales Tax Adjustment, a Sales Tax Payment, a Payroll Check or a Payroll Liability Payment.

There are very few reasons to create journal entries in QuickBooks® and they should be limited to non-transactional entries with the exception of outsourced payroll.

If you use a third-party payroll service like Paychex® or ADP, the payroll company sends you reports. To record the numbers from those reports into your company file where you need them, you can use journal entries.

You may also need to enter year-end adjustments for Depreciation, Amortization, Prepaid Expenses, Deferred Revenues, Accrued Payroll and Taxes or to allocate Net Income to Partner Equity accounts. These may be done in the form of journal entries and/or reversing entries.

Otherwise, it’s best to use the source documents. Using the forms allows you to maintain the integrity of the management reports like Sales by Customer or Sales by Item.

You should never make journal entries with Accounts Receivable and/or Accounts Payable accounts. While it may clear out the account to zero, you will notice on your Aging Reports that the fixes live forever in the clients’ QuickBooks® file.

Sources and Targets in Journal Entries

All of that being said; I am convinced that some of you are still going to insist on using journal entries for adjusting Accounts Receivable and/or Accounts Payable in QuickBooks®.

With that in mind, a final word of caution – do not use these particular Balance Sheet accounts that require a Customer or Vendor name to be associated with them as the first line in any journal entry.

The first line in a journal entry is the Source of the transaction. All subsequent lines are Targets of the transaction. When you enter a Source Name, QuickBooks® copies that name into any Target Name that you leave blank.

When you make a journal entry in QuickBooks® with Accounts Receivable/Accounts Payable as the first line item and assign a Customer/Vendor Name to that line, each subsequent line uses that Name even if you leave it blank.

For example, let’s say this is the journal entry that you give to your client to enter into their QuickBooks® file to tie out to the year-end trial balance:

This is what QuickBooks does with the transaction behind the scenes:

All lines of the journal entry are associated with the Customer Name “Bill Smith”.

Copying the Source Name creates issues when you filter a report for the Customer: Job Name and the report includes transaction lines that you do not intend; it distorts the report.

To avoid having Customer/Vendor Names incorrectly copied down to the blank lines of an adjustment –

  • Enter the accounts with names on the lower lines of the journal entry after the accounts without names, or
  • Create a dummy name on the Other Names list e.g. “No Name” and enter it on each of the Target lines.

The Mount Washington Valley Economic Council will be hosting a three-part QuickBooks® Boot Camp series, led by Rhonda Rosand, CPA:

Session #1: Introduction to QuickBooks® Products –  What’s Right for Me? 

Tuesday, February 24, 2015 – 8:30 AM – 11:00 AM

Whether you are keeping the books for your own business or for others, you need to be using the right tools. We will cover a multitude of options under the Intuit umbrella.

    • Desktop Pro and Premier
    • Enterprise Solutions and Point of Sale 
    • Desktop Hosted and Online Solutions 
    • Payroll – Full Service, Basic, Enhanced, and Assisted 
    • Third Party Applications 

Session #2: QuickBooks® Navigation Workflow and Basic Set Up

Tuesday, March 17, 2015 – 8:30 AM – 11:00 AM

Learn how to navigate your way around the Quickbooks Desktop and online versions, how to begin setting up your own company file and avoid some of the common pitfalls.

  • Navigation and Workflow
  • Common Pitfalls
  • Basic Set Up

Session #3: QuickBooks® Reports and Customizing Forms and Templates

Tuesday, April 7, 2015 – 8:30 AM – 11:00 AM

Learn how to customize forms and templates and create Quickbooks reports that are useful management tools for your business. Understand the difference between profits and cash.

  • Customize forms and templates
  • Revenue Planning
  • Quickbooks Reports
  • Cash Flow Management

Courses are $35.00 and are held from 8:30am-11am at:

Granite State College
53 Technology Lane
Conway, NH 03818
To register, call Holly at (603) 447-6622, or email her at holly@mwvec.com.

When you run financial statements on a Cash Basis in QuickBooks®, the results may not be what you expect. For example, you may find balances for Accounts Receivable and/or Accounts Payable on Balance Sheets run on a Cash Basis. This often means that the client has assigned a Payable or a Receivable to a Balance Sheet account, rather than to an Expense or Income account. There are other reasons this happens too.

Reasons for Accounts Receivable on a Cash Basis Balance Sheet

  • There may be open balances on Invoices that use Items linked to Balance Sheet accounts. An example would be a Customer Deposit linked to a Liability account.
  • There may be a prorata cost of Inventory Items listed on open Invoices. For example, if an Invoice that includes Inventory Part Items is half paid, half the cost of the Inventory Part Items will remain in Accounts Receivable.
  • There may be unapplied credits from Credit Memos or Payments. You can find these entries easily because they appear as negative numbers on the Open Invoices report.
  • There may be Sales Tax due listed on an accrual basis. You can change the Sales Tax Preference to Cash Basis to eliminate this problem. CAUTION: Check with your State taxing agencies for rules regarding payment of Sales Tax – some States require the basis for Sales Tax accruals to match the basis for Income Tax filing.

Reasons for Accounts Payable on a Cash Basis Balance Sheet

  • There may be Bills using Items linked to Balance Sheet accounts.
  • There may be Bills entered for a Note Payable or to buy a Fixed Asset.
  • You may find the cost of Inventory Part Items on open Bills.
  • There may be unapplied Vendor Credits or Prepayments

To review balances in Accounts Receivable and/or Accounts Payable: Filter a transaction report with a paid status of Open transactions and date range of All to get a report showing the transactions that QuickBooks® did not reverse as part of the internal Cash Basis conversion.

  1. From the Reports menu, choose Company & Financial
  2. Choose Balance Sheet Standard from the submenu
  3. Click Customize Report
  4. Select Cash as the Report Basis
  5. Click OK
  6. Double-click the balance in the Accounts Receivable and/or Accounts Payable account
  7. Click Customize Report, and then click the Filters tab
  8. In the Filters list, select Paid Status and then select Open
  9. Click OK

To complete the Cash Basis conversion, use a Journal Entry to adjust away the Accounts Receivable and/or Accounts Payable balances. For the Journal Entry, create a Customer called ***A/R CPA Use Only*** and an Accounts Payable Vendor called ***A/P CPA Use Only***. Use these names to transfer the balances to whatever accounts you choose for the adjustments.

These Journal Entries are Reversing Entries as of the first day in the next fiscal period and you must apply the Journal Entry and the Reversing Entry against each other to offset them or you will have Unapplied Credits going forward.

Do not use Accounts Receivable and/or Accounts Payable as the first line of a journal entry in QuickBooks. See our next Accounting Professionals Only newsletter.

New Business Directions offers QuickBooks consulting, outsourced accounting, business and CFO services to small and mid-sized organizations. If we can help you in anyway, please contact us.

Many Retail stores sell inventory on consignment. It’s important to keep track and to know how much inventory you have in stock, who it belongs to and where it’s all located.

Let’s start our discussion of Accounting for Consignments in QuickBooks with a few basic definitions.

  • Consignment – the act of consigning, which is placing any materials in the hands of another.
  • Consigned Inventory – the goods shipped by the Consignor to the Consignee.
  • Consignor – the owner of the inventory – the person who hands over the goods to be sold.
  • Consignee – the seller of someone else’s goods – the person who receives the goods to sell.

There are two sides to the consignment equation – Consignor and Consignee. In this article, we will discuss the situation from the viewpoint of the Consignor. Note: We will also assume that you are using QuickBooks Premier and not Pro or Enterprise.

As the Consignor, you own the inventory – it’s your asset and your responsibility and if the product is damaged, it’s your loss. You are the party at risk and have an insurable asset. You’ve consigned it, or handed it over, to someone else who has agreed to sell it on your behalf in exchange for a pre-determined fee or percentage as well as reimbursable out-of-pocket expenses.

In QuickBooks, it’s as simple as creating a separate section in your Item List for Consigned Inventory and listing each Item as a Sub-Item with an identifier (Cons) that categorizes it as consigned. These are still Inventory Parts and are mapped to the same Cost of Goods Sold, Income and Inventory accounts as your other Inventory Items. Note: You may wish to create a separate Inventory Asset account for your Consigned Inventory, however this is optional.

01-2015

To transfer the Items from your Regular Inventory to Consigned Inventory, it’s an Inventory Adjustment for Quantity only – the value of your inventory does not change, only the location of the Items for sale. Adjust Inventory/Quantity On Hand is located under the Vendor Menu.

01-2015-A

In addition to creating an Inventory Adjustment, you will need to create a Sales Order to the Consignee for the Consigned Inventory. Create Sales Order is located under the Customer Menu. This is a non-posting entry in QuickBooks and will show the Inventory as committed to the Consignee and not available for sale to others on an Inventory Stock Status Report.

01-2015-B

As you receive reports of Sales of your Consigned Inventory from the Consignee, or better yet, as you conduct a physical inventory of your Consigned goods at the Retail location, you will create an Invoice in QuickBooks from the Sales Order to the Consignee to bill for your pre-determined percentage of the sale, less reimbursable expenses.

01-2015-C

These are the steps to account for Consignments from the perspective of the Consignor.

There are many more steps involved in accounting for Consignments from the angle of the Consignee. We’ll cover these in a later edition of our newsletter – stay tuned.

As always, if you have any questions on any of the procedures for recording Consignments in QuickBooks, please contact us. We’re happy to help.

Accurate, thorough item records inform your customers and help you track inventory levels correctly.

Whether you’re selling one-of-a-kind items or stocking dozens of the same kinds of products, you need to create records for each. When it comes time to create invoices or sales receipts, your careful work defining each type of item will:

  • Ensure that your customers receive correct descriptions and pricing,
  • Provide the information you must know about your inventory levels, and,
  • Help you make smart decisions about reordering.

You’ll start this process by making sure that your QuickBooks file is set up to track inventory. Open the Edit menu and select Preferences, then Items & Inventory. Click the Company Preferences tab and click in the box in front of Inventory and purchase orders are activated if there isn’t a check in the box already. Here, too, you can ask that QuickBooks warn you when there isn’t enough inventory to sell. Click OK when you’re finished.

CC-12-2014C

Figure 1: You need to be sure that QuickBooks knows you’ll be tracking inventory before you start making sales.

To create your first item, open the Lists menu and select Item List. Click the down arrow next to Item in the lower left corner of the window that opens and select New. The New Item window opens.

Warning: You must be very precise when you’re creating item records in order to avoid confusing your customers and creating problems with your accounting down the road. Please call us if you want us to walk you through the first few items.

QuickBooks should display the list of options below TYPE. Since you’re going to be tracking inventory that you buy and sell, select Inventory Part. Enter a name and/or item number in the next field. This is not the text that will appear on transactions; it’s simply for you to be able to recognize each item in your own bookkeeping.

CC-12-2014B

Figure 2: Let us work with you if you have any doubts about the data that needs to be entered in the New Item window. It must be 100 percent accurate.

In the example above, the box next to Subitem of has a check mark in it because “Light Pine” is only one of the cabinet types you sell (you can check this box and select <Add New> if you want to create a new “parent” item on the fly). Leave the next field blank if your item doesn’t have a Part Number, and disregard UNIT OF MEASURE unless you’re using QuickBooks Premier or above.

Fill in the PURCHASE INFORMATION and SALES INFORMATION fields (or select from the lists of options). Keep in mind that the descriptive text you enter here will appear on transaction forms, though customers will never see what you’ve actually paid for items, of course (your Cost, as opposed to the Sales Price).

QuickBooks should have automatically selected the COGS Account (Cost of Goods Sold), but you’ll need to specify an Income Account. Please ask us if you’re not sure, as this is a critical designation. The Preferred Vendor and Tax Code fields will display lists if you’ve already set these up.

QuickBooks should have pre-selected your Asset Account. If you want to be alerted when your inventory level for this item has fallen to a specific number (Min) so you can reorder up to the point you specify in the Max field, enter those numbers there (the Inventory to Reorder option must be turned on in Edit | Preferences | Reminders).

If you already have this item in stock, enter the number under On Hand. QuickBooks will automatically calculate Average Cost and On P.O. (Purchase Order).

Click OK when you’ve completed all of the fields. This item will now appear in your Item List, and will be available to use in transactions. When you want to create, edit, delete, etc. any of your items, simply open the same menu you opened in the first step here (Lists | Item List | Item).

CC-12-2014A

Figure 3: The Item menu, found in the lower left corner of the Item List.

Precisely created Inventory Part records are critical to accurate sales and purchase transactions. So use exceptional care in building them.

Our last two newsletters focused on what was new in QuickBooks Pro and Premier for 2015; first for Accountants and then for Clients. If you missed them, they are posted on our blog.

In the next two issues, we will cover what’s new in Intuit’s more robust software – Enterprise – in the recently released 2015 version.

In my opinion, the most significant changes to Enterprise are in the Preferences that control what users can and cannot do within their company files.

Disallow Negative Inventory

In the past, QuickBooks© has allowed you to sell products that you do not have in stock – at least not according to QuickBooks. There was a preference that if set, would warn you that you were selling something that was not in stock, but it would not prevent you from doing so.

This caused all sorts of problems – having negative quantities on hand threw off the Cost of Goods calculations, caused errors in reporting and in some cases lead to recurring data damage.

In the 2015 release, we now have an option in the Items and Inventory Preference that says “Don’t Allow Negative Quantity”. Selecting this option will prevent you from processing a transaction that causes negative inventory.

It only works to block transactions from going negative if they have a balance of zero or greater. If the quantity is already negative, it does not prevent it from becoming further negative.

This only works with Quantity on Hand. If you select the Preference to Disallow Negative Inventory, you will no longer be warned that a Sales Order or Inventory Assembly creates a negative Quantity Available.

If you decide to use this Preference, take the time to review the new report called Negative Item Listing under Reports – Inventory and correct ALL negative inventory quantities before enabling this Preference.

Disallow Sales to Overdue Customers

Under the Sales and Customer Preference, we can now select the option
“Do Not Sell to Overdue Customers”. This works for Invoices, Sales Receipts and Sales Orders, but not for Credit Memos.

You will want to make sure that your Customer Terms as they relate to Due Dates and exactly what constitutes Overdue, are set up properly before selecting this option. There is no Admin user override and this is not a User or Role specific preference so it could become quite restrictive if not set up properly.

Hide Opening Balance Fields

The leading cause of postings to the Opening Balance Equity account is entering the Opening Value when setting up Customers, Vendors, Assets or Inventory accounts and items.

In 2015, we have the option to hide opening balance fields in Names and Items. It’s under the Accounting Preference tab. The field will be visible, but grayed out.

I only wish that Intuit had made the default preference to Hide this field; it would save us countless hours of reversing duplicate transactions.

These are only a few of the changes to Enterprise for 2015. Stay tuned for our next article and we will cover more of what you can expect to see for improvements.

Part 1 of our What’s New in Enterprise for 2015 focused on the changes to the Preferences. This issue will cover some of the other changes that were made to enhance this more powerful and robust version of QuickBooks.

Total Columns on Forms

In addition to being able to total the dollar amounts on transaction forms, we can now total Quantity and Custom Fields such as weights and counts specific to our industry.

This is available on Invoices, Sales Receipts, Sales Orders, Purchase Orders, Checks, Bills and Credit Card Charges. The Custom Field must be a numeric field and not text.

A section has been added to the Subtotal Item to allow you to edit and select which columns to total on forms.

This feature does not work well with Units of Measure. There is no way for the program to understand 2 each or 2 dozen and make the proper calculation. It’s also a little tricky for Group Items but it can be configured to work for this type of item.

Sort on Columns in Transactions

We now have the ability to sort columns on our transaction forms. This is available in Estimates, Sales Orders, Invoices, Assemblies, Checks, Credit Card Charges, Bills, Item Receipts, Credit Memos, Sales Receipts, Weekly Timesheets and Purchase Orders.

It behaves property with Subtotal Items by sorting those items above the Subtotal separately from the items below the subtotal. It does not do as well with Group Items.

Other than making the forms look neater, I don’t really understand it’s purpose here.

Search Within Transactions

This feature I like for when I am trying to find that needle in a haystack, like on lengthy purchase orders when I can’t remember if I added something to my order and I want to go back and look for it.

CC-10-21-2014BIt’s located on a separate tab in the transaction menu ribbon. Just type in the box and it will search the displayed transaction for matches to your inquiry. It looks at the Item Code and the Description only – not custom fields.

Shaded Lines on Forms and Reports

For me, this makes my forms and reports easier to read by alternating shaded lines. This option is available in the print window and is stored in the local printer preferences; it is saved per form and per user.

The option is available on Estimates, Sales Orders, Pick Ticket lists, Packing Slips, Invoices, Purchase Orders, Bills, Item Receipts, Sales Receipts, building Assemblies, the physical inventory worksheet and item price lists.

Show Cost on Sales Forms

This field is available for Sales/Work Orders, Invoices and Sales Receipts. It is only a screen option and will not print on the forms themselves. It allows you to see your cost as your making a sale and with the new Subtotal feature, you can compare your total cost to your total sale.

Keep in mind that this is Cost, not Average Cost. I can imagine that this would be useful in calculating customer discounts or mark-downs at the time of a sale to make sure that you’re not selling below cost.

Print Footer on Last Page Only

I’ve been waiting for this one, unfortunately it’s only in Enterprise 2015 and not Pro and Premier 2015. The option is located in the additional customization settings of the form template on the last tab – Print – Only Show Total on the Last Page.

CC-10-21-2014This avoids having that blank Total Box show on the first page of an invoice with multiple pages. It suppresses the entire footer with the exception of custom text boxes and page numbers.

It affects Invoices, Sales Orders, Estimates and Purchase Orders. For some unknown reason it is not currently available on Credit Memos or Sales Receipts. Maybe they will add that later.

There are quite a few more changes in Enterprise 2015 – too lengthy to cover in this article – and I am sure that there will be more to follow. At the time of this writing, rumor has it that there will be a big announcement regarding the Enterprise platform at the QB Connect conference in San Jose next week – I’ll let you know what I find out.

QuickBooks 2015 Desktop has just been released and there are several new features and improvements to old ones that you will want to take a look at to see if it has something worth upgrading for.

Insights Dashboard Insights is similar to the old Company Snapshot, which is still available. It’s a dashboard view of your financial position with a more up-to-date user interface. You can find it as a tab on the Home Page and configure the view using the gear icon in the upper right-hand corner of the screen. It’s customizable – you can add your logo, decide what you want to see and print the details of the entire screen. You can also click on the graphs to see a report with the supporting details.

Time and Expense on the Income Tracker – You can now view Unbilled Hours for Work in Progress by Dollars and sort the on-screen information in the Income Tracker. If you’re not familiar with the Income Tracker, that was a new feature in QuickBooks 2014.

Improved Reporting – This is great for those of us who are now having a difficult time with seeing our monitors without magnifiers. The on-screen reports have a more modern design with background shading, vertical and horizontal lines, increased line spacing, row alignment and indentation.

Field Search Boxes – Finally! When customizing reports we can now search for the columns we want to add to our reports from the filter list that is now in alphabetical order and searchable, instead of scrolling up and down looking for a needle in a haystack.

Comments on Reports – In QuickBooks 2015, you will be able to add comments to reports, snapshot save them as Commented Reports and email them with the comments attached. The comments are numbered sequentially and will print as a separate page. Please keep in mind that emailing sensitive information is not secure.

Multiple Reports in Single Email – instead of sending one email per report or creating PDF’s of multiple reports, storing them in a folder and then emailing them, you can now process and email multiple memorized or commented reports from the multiple reports menu. Again, emailing is not the preferred method of sending sensitive financial information as it is not secure. We recommend using a secure portal for transmitting data.

Manufacturer’s Part Numbers – in QuickBooks 2015, we can add the Manufacturer’s Part Number to our forms without using up a valuable custom field. This is available on Invoices, Sales Receipts and Sales Orders, but not Credit Memos. Be careful, this is an editable field and can be copied back to your Item List.

Pin Notes – the Notes section of Customers and Vendors has been re-designed and we can now pin important notes to the top of the view screen so that it always shows and is the default note on reports.

Reminders Dashboard – The Reminders now show up as a dashboard with To Do Notes. It’s easier to understand and work with than previous versions.

Terminate QB on Workstation – This new feature is dangerous at best. In a multi-user QuickBooks file, the Administrator can now switch to single-user mode without the permission of the other users who may be logged in. It closes even if the other users have unsaved data. I am recommending that all Admins forget that I told you about this feature.

Invoice for Selected Items on Sales Orders – We can now select which items we want to Invoice from a Sales Order.

Unless you see something in these changes that has been an issue for you, there is no real reason to upgrade. If Intuit stays true to form, the 2012 version of QuickBooks will be sunsetted in May of 2015 at which time those users will be required to update if they wish to continue using online banking, payroll and email features from within the program.

New Business Directions offers QuickBooks consulting, outsourced accounting, business and CFO services to small and mid-sized organizations. If we can help you in anyway, please contact us.

QuickBooks 2015 offers some new features that we are excited to share with our fellow accounting professionals. The Accountant Toolbox, Client Collaborator and Report Comments are a few of the latest features available to accountants that we will explore in this newsletter.

Accountant Toolbox

In Pro and Premier versions of QuickBooks 2015, when you log into your clients’ QuickBooks file as the External Accountant, you will have an Accountant Toolbox available to you.

Instead of taking the file back to your office and restoring it to work on it with your tools while the client waits patiently and cannot use the file, you will be able to perform tasks right at their office on the live data file.

You will either need to be a ProAdvisor or have purchased the QuickBooks Accountant Plus subscription in order to use this Accountant Toolbox. From the Toolbox, you will be able to:

  • Batch enter and/or reclassify transactions
  • Preview the status of reconciliations
  • See a list of your memorized reports
  • Access the Client Data Review Tools
  • All other features previously only available in the Accountant Center.

With Client Data Review, you will be able to track changes made by the client; changes to lists, anything that was merged or deleted, you will be able to correct client data errors, record review notes, troubleshoot beginning balances, write off small Accounts Receivable balances, apply open credits, troubleshoot Inventory and correct Sales Tax and Payroll Tax errors.

Comments on Reports

With QuickBooks 2015 for Accountants, you will be able to add comments directly onto the Reports that you generate for your clients. You can save these reports as Commented Reports, similar to Memorized Reports, and you will be able to batch print and batch email these reports to your clients. Now you can avoid drafting lengthy emails outside of QuickBooks with this handy feature.

Figure 1: This screenshot captures the process of adding comments to reports.

Send Portable Company File

The Portable Company File feature has been streamlined. It’s a one-time setup and you can decide whether to send a Portable Company File or an Accountants’ Copy.

Client Collaborator

This was new in 2014, however it has been a best kept secret. This tool allows you to associate questions with specific transactions and track conversations between you and your client. Interactions between the accountant and the client are stored on a secure server and accessed online ensuring that nothing is lost.

This feature is located in the Accountant Menu under Ask Client about Transaction. Sign in to your Intuit account with your user ID and password and follow the onscreen prompts to create and send your questions to the client. The client will receive a secure email, log in to their QuickBooks file and view the conversation list, answer your questions and then you will be notified to review and close the conversations.

Figure 2: Here you can see the conversation trail of several transactions. No need for emailing your client with transaction details and questions, as you can do that now directly from QuickBooks.

New Business Directions helps small business owners streamline the process of making money with QuickBooks consulting and training services and provides outsourced accounting, business and CFO services. If we can help you in anyway, please contact us.

Getting QuickBooks ready to process payroll is a complex, time- consuming process. Here’s what you can expect.

Payday. You look forward to it when you’re young and working at your first part-time job.

But as a grown-up who needs to start processing payroll for your employees, you probably anticipate it in a different way, perhaps even with a sense of dread. QuickBooks handles the real grunt work once you’ve done the initial setup, but those early hours you spend preparing to print your first paycheck can be challenging.

Fortunately, QuickBooks’ payroll setup tool can guide you through the process. Once you’ve signed up for payroll, open the Employees menu and select Payroll Setup.

 

Figure 1: The QuickBooks Payroll Setup tool tells you’ll what information you need to supply in order to start paying employees.

Easy Operations

The first screen you’ll see in this step-by-step, wizard-like setup guide contains a link to QuickBooks’ payroll setup checklist. You don’t have to assemble all of the information you’ll need about your company, your employees, and your payroll taxes, but we recommend that you gather as much as you can before you start.

You’ll advance through setup by completing the information requested and then clicking the Continue button in the lower right (or, sometimes, Next; there’s also a Previous button available often). If you don’t have a particular detail immediately at hand, you can continue on and come back later. You’ll be able to edit your work then.

To back out of the whole process and return at another time, click the Finish Later button in the lower left.

Building a Framework

QuickBooks first wants to know about the various types of compensation and employee benefits your company offers. To start adding your Compensation options, click Add New. Click in the box in front of any pay types you support (Salary, Hourly wage and overtime, Commission, etc.) to create a check mark. When you click Next, this window opens:

Figure 2: It’s easy to indicate the types of compensation your company offers.

Keep clicking Next after you’ve completed each screen until you come to a page that lists all of the compensation types you’ve defined. To make any changes, highlight the type and click Edit to modify or Delete to remove. Then click Continue when you’re finished.

The next section is probably the most difficult: Employee Benefits. Here, using similar interface conventions to enter information and navigate, you’ll provide information about your company’s:

  • Insurance benefits
  • Retirement benefits
  • Paid time off, and
  • Miscellaneous items (cash advance, wage garnishment, mileage reimbursement, etc.).

It’s absolutely critical that you set these up accurately, or you’ll have unhappy benefits providers – and employees. If you’re not absolutely confident of an answer, it’s better to leave an item unfinished and come back later. You may want to ask us to work with you as you complete this section.

People and Taxes

QuickBooks will then ask you about your employees. Have your W-4 forms handy for this section, as you’ll need to know Social Security numbers, birth dates, etc.

 

Figure 3: On this screen, you’ll tell QuickBooks what type(s) of compensation and their dollar amounts apply to the employee.

All of those details you entered earlier about company benefits comes into play here. Once you’ve defined an employee’s compensation types and amounts, the next screen will display the additions and deductions that your company supports. You will have set up defaults for some of these, but you can modify them for individual employees.

There are numerous other details that you’ll have to supply for your staff, like how vacation and sick hours accrue, what state will want to collect taxes from them, and what their filing status is.

Unless you’ve worked with payroll before, you’re going to want our help in completing the payroll tax section. Once it’s done correctly, QuickBooks will calculate taxes due and help you pay them.

Finally, QuickBooks helps you determine whether you’ll need to enter any previous payroll data from the current year before you start to process your payroll in the software.

Whether you’re switching from manual payroll or a payroll service, or simply getting ready to pay your first employee, QuickBooks payroll-processing tools can help you save time and foster accuracy – as long as you get the details from the start.