• 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 invoice

invoice

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...

What’s the New Paid Stamp For QuickBooks 2011?

Chief Mechanic · September 19, 2010 ·

For QuickBooks 2011, Intuit improved the Paid stamp to reflect the date the customer invoice was paid, as shown in the screenshot below.

QuickBooks 2011 Create Invoices Window With Date Paid Stamp

Unfortunately, a Paid stamp is also applied to vendor bills, and that stamp does not reflect the date the bill was paid.

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

What Is the New History Tab In QuickBooks 2011?

Chief Mechanic · September 19, 2010 ·

For QuickBooks 2011 and Enterprise Solutions 11.0, Intuit added a History tab to several key windows in QuickBooks:

  • Enter Bills
  • Create Purchase Orders
  • Create Item Receipts
  • Create Invoices
  • Create Credit Memos/Refunds
  • Enter Sales Receipts

Unfortunately, it’s not included on the Receive Payments window.

The History tab can be quickly opened and closed, and shows a Summary, Recent Transactions, and Notes for the vendor or customer.

Here’s the History tab in its closed state. To open it, just click on the left-pointing arrow.

QuickBooks 2011 Enter Bills History Tab Closed

With the tab open, you can close it by clicking on the right-pointing arrow.

QuickBooks 2011 Enter Bills History Tab

Each History tab contains intelligent links to functions that allow you to edit the displayed entity, edit notes, and prepare pre-filtered reports. For example, the Open Balance link in the Enter Bills window opens a pre-filtered Vendor Open Balance report, which is a modified Unpaid Bills Detail report for the currently displayed vendor.

By providing an easy way to display recent activity during transaction entry, the History tab will help to reduce the chance of erroneously recording a duplicate transaction.

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

Are There Restrictions On Making General Journal Entries To A/R and A/P Accounts?

Chief Mechanic · September 13, 2010 ·

Yes, there are a few restrictions on making General Journal Entries to Accounts Receivable (A/R) and Accounts Payable (A/P) accounts.

Normally, the preferred way to change the balance in an A/R or A/P account is by recording transactions, such as customer invoices or vendor bills. However, sometimes it’s more convenient to make a General Journal Entry.  A common use of General Journal Entries to A/R or A/P accounts is to set up customer or vendor balances in a new QuickBooks company file.

If you opt to make a General Journal Entry to an A/R or A/P account, such entries are subject to these restrictions:

  1. You can’t use more than 1 A/R or A/P account in a single journal entry
  2. You must enter a customer name for a General Journal Entry to an A/R account and a vendor name for a entry to a A/P account

Here are some of the warnings you’ll see if you attempt to violate these restrictions:

QuickBooks Premier 2009 General Ledger Warning 1
QuickBooks Premier 2009 General Ledger Warning 2
QuickBooks Premier 2009 General Ledger Warning 3

Here’s an example of a General Journal Entry to 1 A/P account that meets the restrictions:

QuickBooks Premier 2009 GL Make General Journal Entries Accounts Payable

While not an absolute requirement, QuickBooks prefers that transactions involving A/R or A/P accounts have that account on the first line of the General Journal Entry.  The first line of a General Journal Entry is the source of the transaction.  Sources and targets are an important concept in QuickBooks.  For more information, see our article on sources and targets.

When you record a General Journal Entry to an A/R or A/P account, the General Journal Entry will appear in the transaction list for the customer or vendor specified in either the Customer Center or Vendor Center – provided that the A/R or A/P account is on the first line of the general journal entry and is therefore the transaction source.  General Journal Entries that debit (increase) A/R will be similar to a customer invoice and can be paid in a similar fashion.  General Journal Entries that credit (increase) A/P will be similar to a vendor bill and likewise can be paid just like other vendor bills.  However, some data fields are not filled in when recording transactions for a customer or vendor via a General Journal Entry.  For example, the Terms and Due Date fields on a General Journal Entry for a vendor are left blank, as shown below. (Note: The single screenshot below shows a customized Vendor Center with the separate Pay Bills window placed on top of it to illustrate several of the points discussed in this article.)

QuickBooks Premier 2009 Vendor Center Plus Pay Bills

Beyond restrictions on making General Journal Entries to an A/R or A/P account, there are other restrictions that apply to making General Journal Entries, such as currency restrictions in multicurrency environments.

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

How Do I Change an Onscreen Form Such As Create Invoices To Show More Line Items?

Chief Mechanic · September 12, 2010 ·

Making changes to the windows of QuickBooks is easy.

Let’s use the Create Invoices window as an example.  By default, this window shows just 2 invoice lines.  In this article, we’ll change the default look.  An important point to keep in mind is that you should not close the Create Invoices window until you’ve completed all the steps in this article.  Otherwise, you’ll lose your work and need to start over.

Here’s the Create Invoices window in its smallest form.  Pay close attention to the right border.  We’ve positioned our mouse pointer directly on the border, and it’s now turned into a left-right arrow.  It only provides this functionality when your mouse is positioned directly on the border; if you move it off the border, your pointer shape and function will change.

QuickBooks Premier 2009 Create Invoices Right Border

With your mouse pointer positioned directly on the border, make the Create Invoices window bigger by dragging this border to the right.  To drag something in Windows, hold down your primary mouse button while moving it to the desired position.  Since we started with the smallest form, we can’t drag it to the left.  Next, drag the bottom border down and watch more invoice line items immediately appear.  Re-size the window to fit your needs.

Let’s carry our customization 1 step further.  Position your mouse directly on the fine line between any 2 columns, such as the one between U/M and Rate.  Your mouse pointer will change to another type of left-right arrow.

QuickBooks Premier 2009 Create Invoices Column

To change the width of a column, drag the pointer when it’s positioned directly on the line between 2 columns and is in the shape shown above.  Again, it only provides this functionality when your mouse is positioned directly between 2 columns; if you move it away from this position, your pointer shape and function will change.  One common need in re-sizing a window such as the Create Invoices window is to increase the width of the description field.  With this knowledge, that’s now an easy task.  Re-size any column to suit your needs.

Once you’ve completed customizing the look of your Create Invoices window, you need to save your work.  To do that, do not close the Create Invoices window.  Instead, go to the Edit->Preferences menu, and choose Desktop View from the submenu shown.  Since QuickBooks can store different desktop settings for individual users, be sure you’re on the My Preferences tab.

QuickBooks Premier 2009 Preferences Save Current Desktop

Click the radio button Save current desktop and click OK.  Your changes to the Create Invoices window are now saved.  To confirm that, close the Create Invoices window and re-open it.  It should now open to your customized size and layout.  Since you’ve just saved your desktop with the Create Invoices window open, that window will open the next time you start QuickBooks.  If you want different windows to open by default, simply open them and save the desktop in that state.

This same technique can be applied to most, if not all, data entry screens in QuickBooks.

Vote This Post DownVote This Post Up (+2 rating, 4 votes)
Loading...
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 5
  • 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–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help