• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for employee

employee

How Does QuickBooks Attached Documents Handle Security?

Chief Mechanic · March 19, 2011 ·

QuickBooks Attached Documents Manage Users
QuickBooks Attached Documents addresses the need for security by providing 4 levels of application permissions across 8 areas of QuickBooks functionality under an account overseen by a single user.

Users log into Intuit’s secure servers using an email address and password. While we’re on the subject of security, there’s one small drawback: the password is not case-sensitive and is therefore not considered a strong password.

A QuickBooks Attached Documents subscription is managed by a Company Administrator, the sole pre-defined role supported by the service. A user with the role of Company Administrator can:

  • Edit the business profile
  • Add other Attached Documents subscriptions
  • Update the current subscription

Here’s a screenshot of the screen to add a new user, which shows the range of security settings. After a user is added, security settings can be modified by clicking on the Manage Users button in the upper right of the browser screen, followed by editing a specific user. You can only manage users from a browser-based interface, not from within QuickBooks itself. The Setup and Manage Users menu selection will only open browser access to Attached Documents.

Quickbooks Attached Documents Add User

The service supports 4 levels of application permissions:

  • Administrator: can perform all functions and manage users
  • Full Access: can perform all functions but cannot manage users
  • View Only: can view any attachment in any area but cannot add new attachments and cannot modify or delete existing documents
  • Custom Access: controlled access across 8 functional areas

Necessarily, the user with the role of Company Administrator must have Administrator application permissions, but other users can have Administrator application permissions as well. While those users will have powerful capabilities, they won’t have the powers specific to the role of Company Administrator, such as editing the company profile.

The Custom Access permission is used to control access to documents in functional areas of QuickBooks. Custom Access supports 8 functional areas:

  1. Sales and Accounts Receivable
  2. Purchases and Accounts Payable
  3. Checking and Credit Cards
  4. Time Tracking
  5. Payroll and Employees
  6. Inventory
  7. Sensitive Accounting Activities
  8. Company Documents

Within these 8 areas, there are 4 capabilities:

  • Add: this is a global permission; if a user can add an attached document, he can add it to any area
  • View: this permission allows a user to look at but not modify or delete a document
  • Modify: this permission necessarily includes the View permission
  • Delete: this permission is only available to a user with Modify permissions in the same area

Users assigned a Custom Access level can make use of their capabilities (i. e., Add, View, Modify, or Delete) on lists and transactions associated with that area of accounting. A user can be assigned to more than one area, a necessity in a small firm that still wants to set some restrictions on document access.

Before examining how Custom Access applies in specific areas, it’s important to understand how access to files in the Document Inbox is controlled. Any user with View permission in any area can see all unattached documents in the Document Inbox. Custom Access can’t take affect until after a document is attached and put into a specific area. Therefore, for documents requiring controlled access, care must be taken to start the upload process by attaching them from within QuickBooks. If you elect to upload a document to the Document Inbox and attach it later, it is viewable by any user with View permissions until it is attached to a list item or transaction.

8 Functional Areas

Let’s review which lists and transactions are associated with specific areas. Note that a list or transaction type can appear in more than 1 area. For example, the Other Names list appears in both the Sales and Accounts Receivable and the Purchases and Accounts Payable areas.

Sales and Accounts Receivable: Customers, Other Names, Fixed Asset Item List, Estimates, Sales Orders, Invoices, Sales Receipts, Credit Memos, and Payments.

Purchases and Accounts Payable: Vendors, Other Names, Fixed Asset Items, Bills, Bill Credits, Bill Payments, Credit Card charges, Credit Card credits, and Purchase Orders. Note that Checks – which represent a different transaction type – cannot be seen unless the user has View permissions in the area of Checking and Credit Cards.

Checking and Credit Cards: Vendors, Other Names, Fixed Asset Items, Checks, Deposits, Credit Card charges, and Credit Card credits. Note that users with View permission can see documents attached to transactions in bank or credit card accounts but cannot see documents attached to the bank or credit card accounts themselves. Note also that Transfers are not included in this area.

Time Tracking: Other Names and Timers.

Payroll and Employees: Employees, Other Names, Paychecks, Payroll Liability Checks, Liability Adjustments, and Year-To-Date Adjustments.

Inventory: Items, Vendors, Other Names, Fixed Asset Items, Bills, Bill Credits, Bill Payments, Purchase Orders, Item Receipts, Inventory Adjustments, and Build Assemblies.

Sensitive Accounting Activities: Accounts, Journal entries, and Transfers. Note that users with View permission can see documents attached to general ledger Accounts, but to also see documents attached to transactions in a particular area, View permission for that area is required. For example, to view a document attached to a Check, a user must have View permissions in the Checking and Credit Cards area.

Company Documents: Documents attached to the company file itself via the Company Information window.

This last area is not an accounting function similar to managing A/R or A/P. Instead, it includes more general corporate documents that are connected to accounting and recordkeeping. Documents here include those attached to the Company Information via the Company->Company Information… menu selection. A screenshot of this point of attachment is shown below. Examples of documents that might be attached here include corporate organization documents such as articles of incorporation, bylaws, or meeting minutes.

QuickBooks Attached Documents Company File

A few examples of how applying security in QuickBooks Attached Documents will illustrate the power and flexibility of this security model. First, consider the need to upload bank statements but to restrict access to selected individuals. Bank statements attached to the Account are only viewable by users with access to Sensitive Accounting Activities, so the specific bank account to which the statement applies is the best point of attachment. We don’t recommend bank statements be attached to other list entities, such as Other Names, because documents attached to those lists are accessible to other areas.

Next, consider the need to upload payroll tax forms. If every user requiring access to the payroll tax forms will also have access to the Sensitive Accounting Activities area, one good point of attachment might be the liability account to which the tax form relates. Another approach might be to treat these forms as Company Documents, and attach them to the Company Information. A workable but slightly less desirable method would be to create employees representing the tax agency as placeholders and attach tax forms to the relevant placeholder employee. However, even though a tax form is often accompanied by a payment to a Vendor, we don’t recommend attaching a tax form to a Vendor because documents attached to that list item would be accessible to other areas, such as Purchase and Accounts Payable.

Both of these examples illustrate an important concept in making use of security in Attached Documents. Start by attaching a document to an area with the greatest restrictions and only attach it to other areas as required. If you attach a document to areas that include lists or transaction types that overlap, you may end up making the document available to a wider audience than you originally intended.

Vote This Post DownVote This Post Up (-1 rating, 3 votes)
Loading...

How Do I Resort Lists?

Chief Mechanic · September 11, 2010 ·

Lists are one of the foundations of QuickBooks, and from time to time they can become out of order.  That’s when they need to be resorted.  Some common indicators that it’s time to resort your lists include:

  • the list itself is out of order
  • an element is missing
  • new entries in a list appear at the top of the list instead of in their sorted order
  • you can’t turn on the account number preference
  • selecting a Customer:Job, Vendor, or Employee in a Center fails to display existing transactions for that name
  • Names don’t properly auto-fill when entering a Name filter on the Advanced tab of the Edit->Find… function

Resorting any list will undo any special order you’ve applied to the list, and this activity can’t be done in multi-user mode.  It’s always a good idea to backup your company file before undertaking an action that can’t be undone.

There are 8 lists that can be resorted. They are:

  1. Customers:Jobs
  2. Vendors
  3. Employees
  4. Other Names
  5. Accounts
  6. Items
  7. Memorized Reports
  8. Memorized Transactions

Since this technique is often used to address possible data corruption, we’ll outline the most efficient technique to resort multiple lists, but you can also choose to resort an individual list by opening up a Center and right clicking on a list element.

The first 4 lists are collectively referred to as Names or Entities, and there’s an easy way to resort these 4 lists:

  1. Open the Write Checks window by clicking on Banking->Write Checks or using the keyboard shortcut Ctrl + W
  2. In the Pay to the Order of field, click Ctrl + L
  3. Opt to include inactive list entries by clicking the Include Inactive checkbox
  4. Click the Name button and choose Re-sort List from the menu
  5. Click Ok to resort the lists
  6. Uncheck the Include Inactive checkbox

The screenshot below shows the combined Name list in Step 4:

QuickBooks Enterprise Solutions 10 Resort Name List

Our related article explains how to provide easy access to this combined list of all Names.

Resorting the Chart of Accounts and Items lists follow similar procedures, except each of these lists will have to be resorted individually.  To access the Chart of Accounts, click the Lists->Chart of Accounts menu selection or use the keyboard shortcut Ctrl + A.  To access the Items list, click Lists->Items.  Opt to include inactive list entries, resort the list from the button in the lower left of the window, and uncheck the Include Inactive checkbox before proceeding to the next list.

Resorting Memorized Reports and Memorized Transactions are similar to the above steps, except there’s no need to include inactive list entries since they’re not allowed on these lists.  To access Memorized Reports, click the Reports->Memorized Reports->Memorized Report List menu selection; to access Memorized Transactions, click Lists->Memorized Transactions or use the keyboard shortcut Ctrl + T.

After resorting lists, close and reopen your company file (.qbw) to insure that all changes are successfully written to disk.

Resorting lists is discussed in this Intuit knowledge base article.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

How Can I Display a List of All Names?

Chief Mechanic · September 5, 2010 ·

In QuickBooks, Customers, Customer:Jobs, Vendors, and Employees are called Names.  In transaction entry screens, the selection of a Name is filtered to include only the type of Names normally associated with that transaction type.  For example, when entering a Vendor Bill, the selection of a Name is filtered to only include Vendors.

Sometimes, it’s helpful to be able to review a list of all Names in one place, especially when trying to follow a consistent pattern if an entity appears on more than 1 list.

To display a list of all Names, follow these simple steps:

  1. Open the Write Checks window by clicking on the Banking->Write Checks menu selection or using the keyboard shortcut Ctrl + W
  2. In the Pay to the Order of field (ie, the check payee), use the keyboard shortcut Ctrl + L to display a list of all Names
  3. Add the Name List window to the Icon Bar by clicking on the View->Add “Name List” to Icon Bar… menu selection
  4. Assign a Label and Description to the new window
  5. Optionally, change the default icon selection that will appear in the Icon Bar to represent the Name List
  6. Click Ok

You now have a list of all Names in an easy-to-access window. The list provides a consolidated window of 4 pieces of information: Active Status, Name, Name Type, and Balance Total.

QuickBooks Enterprise Solutions 10 Name List

Note that the Write Checks window was used to access all Names because a check can be written to all of the different Name types and by-passes the filtering set by QuickBooks on different transaction types.

Vote This Post DownVote This Post Up (+1 rating, 1 votes)
Loading...

How Do I Export Transactions from QuickBooks?

Chief Mechanic · August 26, 2010 ·

QuickBooks supports 2 methods to export transactions:

  1. The Export… button on the Find window
  2. Exporting from a Center, such as the Customer Center

The first method supports exporting a transaction type for more than 1 customer, vendor, or employee. This is appropriate where you need to analyze or exchange a broad but filtered set of data. The second method is designed for exporting transactions for either a single or multiple customers, vendors, or employees. This technique provides the flexibility to produce an export file that would be useful to review one account to address a specific business issue, such as resolving a customer’s payment history, or to export a range of 1 transaction type. Both export methods are based on common elements.

We’ll demonstrate both methods.

Exporting Transaction Data from the Find Window

Using the Find window, transaction data can be exported for more than 1 customer, vendor, or employee. Filters can be applied to reduce the transactions to be exported down to just 1 customer, vendor, or employee. To get started, click the Edit->Find… menu selection.

QuickBooks Premier 2009 Export Find Invoice

In this example, we’ll export all customer invoices. From the Transaction Type pull down menu, choose Invoice and then click the Find button. QuickBooks will locate and display the number of matches. For our sample data, there are 114 invoices. This data could be filtered further by choosing a Customer:Job, a Date range, a specific Invoice #, or an Amount. Additional filter options are available on the Advanced tab. Our goal for this export is to export all invoices, so we won’t enter additional filter criteria. To proceed, click the Export… button.

The Export window provides the ability to send the exported data to a comma separated values (.csv) file or an Excel workbook. Exports to Excel are only compatible with Microsoft Excel 2000 or later, and you can choose either a new or existing workbook. For this example, we’ll opt to export the data to a new Excel workbook.

QuickBooks Premier 2009 Export Basic

On the Advanced tab, export settings can be customized further. To complete the export, click the Export button.

QuickBooks Premier 2009 Export Advanced

QuickBooks will automatically launch Microsoft Excel with the exported data loaded. Here’s a screenshot of Excel 2007 with exported transaction data loaded.

QuickBooks Excel Export 1

Exporting Transaction Data Starting in a Center

Using a Center, such as the Customer Center, you can flexibly export transactions for either a single customer, vendor, or employee or a filtered list of all transactions relevant to that Center. In this example, we’ll demonstrate exporting data for 1 customer, a common task to review a customer’s purchase history, as well as transactions for a range of customers.

To start, open the Customer Center and choose the customer whose data will be exported. In our example, we’ll choose “Abercrombie, Kristy” (an example only from the sample data) from the customer list displayed on the left.

QuickBoks Premier 2009 Customer Center Export 1

With a customer selected, click the Excel button in the toolbar, followed by the Export Transactions… menu entry in the menu that appears below. This will export the transactions displayed for this individual customer. These transactions can be filtered by changing the values in the pull down menus above the transaction list. Export to Excel will proceed as described above, with the ability to export the transactions to either a new or existing workbook. Note that this method doesn’t offer an ability to export to a .csv file. That’s not an important consideration here, since a .csv file would only be useful in exporting a large number of transactions.

To export transaction data for more than 1 customer from the Customer Center, click the Transactions tab. A list of the available transaction types is shown on the left, with all of the transactions that meet the filter conditions on the right. Change the filter conditions as needed. In our example, with no additional filters, this transaction export will mirror the results we exported using the Find window. To proceed, click the Export… button on the toolbar.

QuickBoks Premier 2009 Customer Center Export 2

Transaction export will proceed as described in our discussion using the Find window. In other words, you’ll be able to export to either a .csv file or an Excel file.

Vote This Post DownVote This Post Up (-1 rating, 1 votes)
Loading...

What’s the Best Way To Track Affiliate Sales in POS?

Chief Mechanic · August 26, 2010 ·

Sales by affiliates are an increasingly common phenomenon, especially in online sales. Typically, these sales need to be tracked much like sales by a commissioned salesperson, both to monitor the commission to be paid to the affiliate and to track the effectiveness of that marketing channel.

We recommend using 1 of 2 methods to track affiliate sales in POS:

  1. Define the affiliate as an employee
  2. Enter a Promo Code for the affiliate on receipts and sales orders

Our recommended approach is to define the affiliate as an employee and enter that employee code in the Associate field on each receipt and sales order. This is analogous to recording a sales rep on a transaction. Although POS doesn’t use the Sales Rep from QuickBooks financial, software, using an employee code in this fashion serves a similar purpose.

Both of these approaches allow you to track affiliate sales by using the built-in reporting features of POS.

Method 1 – Define the Affiliate as an Employee

To track affiliate sales by defining the affiliate as an employee, keep in mind that employee data is not shared between QuickBooks financial software and POS. Also, an employee (or Associate on the New Sales Receipt window) is not the same as a Cashier. To define a new employee, click Employees->Employee List, followed by the New Employee button. Enter an employee for each affiliate whose sales you want to track.

QuickBooks Point of Sale Employees New

One important consideration in using an employee code to track affiliate sales is to accurately record the Commission %. If a single affiliate gets a different Commission % for different sales, you’ll need to enter multiple employee codes for that affiliate. When you record receipts or sales orders, you’ll need to enter only those items on that receipt or order that receive that commission rate, since you can only enter one employee code (or Associate) on a receipt or sales order. Moreover, the Commission % only applies to receipts and sales orders recorded after the Commission % is recorded. If you record a Commission % of 0.00 (which is the default), POS won’t calculate any commissions on receipts or sales orders until you change it, and then it will only apply to new transactions, not those already entered. If there’s a change in the commission for your affiliate, it’s important to update the affiliate’s employee record immediately on the effective date of the change, before new transactions are entered so that your commission reports are accurate.

The commissions that POS calculates aren’t shared with QuickBooks financial software, so you’ll have to use POS reports as an aid to record commission expense in QuickBooks financial software on your own.

QuickBooks Point of Sale Employees New 2

During transaction entry, enter the employee code for the affiliate responsible for this transaction in the Associate field. Because the employee code is selected from a pre-defined pull-down menu, there’s less chance for data entry error. However, POS can’t require entry of an employee in the Associate field, so there’s some risk that all affiliate sales data won’t be captured.

QuickBooks Point of Sale Make Sale Employee

There are a variety of built-in reports showing sales by employee found on the Reports->Employees menu, and these readily lend themselves to reporting on affiliate sales. In addition to reports, POS offers a basic pie chart showing the sales contribution of employees.

QuickBooks Point of Sale Employee Sales Report

Method 2 – Enter a Promo Code for the Affiliate on Receipts and Sales Orders

To track affiliate sales by entering a Promo Code on each receipt and sales order, just enter the code for each affiliate in the Promo Code box.

QuickBooks Point of Sale Make Sale Promo Code

Optionally, to insure affiliate sales data are properly captured, consider requiring a Promo Code on receipts and sales orders by checking the Sales preference Require a Promotional Code on receipts and customer orders on the Edit->Preferences->Company menu.

QuickBooks POS 8 Company Preferences Promo Code

Using a Promo Code can be an effective way to capture and report on affiliate sales because of the availability of an off-the-shelf report on sales by Promo Code. To generate the report, click on the Reports->Sales->General Sales – Promo Code Summary menu.

QuickBooks POS 8 Reports Menu Promo Code Summary

Here’s that report:

QuickBooks POS 8 Promo Code Summary Report

The drawbacks to using a Promo Code to track affiliate sales are twofold. First, Promo Codes are not defined and selected from a list, so extra care needs to be taken to consistently use the same code and avoid data entry errors. Secondly, if a Promo Code isn’t required, there’s a chance it will be omitted from a receipt or sales order inadvertently. On the other hand, if a Promo Code is required and affiliate sales aren’t a large portion of transactions, there’s an extra step in transaction entry that otherwise wouldn’t be required on the majority of transactions.

We recommend defining each affiliate as an employee to capture affiliate sales. It’s more reliable, and there are better reporting tools. However, for firms that don’t want to include affiliates on employee lists, using a Promo Code is a workable alternative.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2021 QBGarage.com · Privacy · Terms & Conditions · Site Help