Filtering a Report - Selecting most of the items from a list
When filtering reports in
QuickBooks, you may want to select most of the items on a particular list, but not all items to appear on your report. First
choose the "selected" option from the list (selected accounts, selected names, etc).
Normally you would
check each item that you want to appear on your report. However, if you want to check all the items on the list, click the
first item and do not release the mouse button. While holding down the mouse button, slide the mouse pointer down just below
the list.
When QuickBooks is done – all of the items on the list will be checked. Release the mouse button. Now you
can manually click the items to remove the ones that you do not wish to include in your filter.
Password Protecting QuickBooks
To password protect your QuickBooks data file click on Company
in
the menu bar, then Set Up Users. From here, you can assign a password for the main (Administrator) account in QuickBooks. You
can also set up user accounts, passwords, and different levels of access if you have multiple people using your QuickBooks
file. Make sure you keep your newly created password in a safe place (just in case you forget it!)
How To Setup QuickBooks to share with another computer.
To allow the sharing of your QuickBooks
file,
your best option is to have a computer network in place. This network will provide the foundation for you to then share the
file between two or more computers. You can have either a wired or wireless network within your office.
It is also
possible to take a backup copy of the QuickBooks file from one computer and restore it to a second computer to allow sharing
of the information. However, I don't recommend this if both computers will be entering QuickBooks data. If you do this, you
won't know who has the most recent copy of the data file, and things can get messed up quite easily. Your best bet is to talk
to a local computer consultant about a network for your home or office.
Use QuickBooks Pro to
manage your business and personal checking account.
QuickBooks Pro can be used to manage many different files.
In your case, you could have a QuickBooks file called "Business", and a completely separate QuickBooks file called
"Home" to manage the separate checkbooks. For more information on the creation of a new company file, click on File
in the menu bar, then New Company.
How to set up accounts for
contractors that will be given 1099s.
The first thing you must do is tell QuickBooks that you will be issuing
1099s. Click on Edit (from the menu bar), then Preferences. Scroll down until you find the picture that says
"Tax:1099" and click on it. On the Company Preferences tab, answer yes to the question about the issuance of 1099
forms, then follow the rest of the instructions on this screen.
Next, you'll need to identify those vendors who
are eligible to receive a 1099. Click on Vendors, then Vendor List. Double-click on the first vendor in the list, then the
"Additional Info" tab. In the lower left hand corner, put a check mark in the box that says "vendor eligible
for 1099" and enter their tax ID number they have provided. Repeat this process for any vendors that need to receive a
1099.
Finally, to run the 1099's and related information, click on Reports, then Vendors, then either of the 1099
reports. Verify the data, correct if necessary, and print your 1099's all within QuickBooks.
It's important to
review this topic with your accountant to ensure you are collecting the proper information and preparing the 1099 forms
correctly for your business.
Keeping Your 941 Report
Accurate
Do not pay your payroll liabilities from the "Write Checks" window. If you use this window,
QuickBooks will warn you to use the "Pay Liabilities" window, but will let you write the check. However when you
print the 941, it will not reflect any payments that you made using the "Write Checks" window.
Use the
"Pay Liabilities" window to create checks for all tax liabilities. Using this window will ensure that the payments
are reflected accurately on the 941 report and that your liability accounts are properly reduced.
Quickly Closing All Open QuickBooks Windows
To close all open QuickBooks Windows quickly, click on
Window on the menu bar, and then Close All.
Using the History Button
- The
History button shows you all the transactions related to the one you are currently viewing.
- For example, view any
invoice that you know is paid, then click on the History button.
- Then you'll see the payment details on your
screen instantly.
Keys that help you save lots of time when working with
dates
(Just type the key shown in the date field.)
- T = today's date
- M = First day of the month you are working in
- H = Last day of the month you are working in
- Y = First day of the
year
- R = Last day of the year
- + = Move the date forward by one
day
- - = Move the date backward by one day
Chart of
Accounts Shortcut
CTRL+A brings up the Chart of Accounts right away
Closing
QuickBooks Shortcut
ALT+F4 closes QuickBooks software
Calculator
Shortcut
When working in a register, you can use the = to bring up the calculator when adding or subtracting
from an account
How to turn on the Reminders feature when opening a company
file
- Click on Edit
- Click on Preferences
- Click the picture of Reminders from the list that appears
- Make sure a check mark is
in the box marked "Show Reminders list when opening a company file"
- Click the OK
button
How to customize the settings on your QuickBooks
desktop
- Edit
- Preferences
- Desktop View
Fast access to company files you have used
recently
Use the Open Previous Company option found on the File menu to give you fast access to company files
you have used recently
Memorized Transaction Shortcut
CTRL+T will bring up
your
Memorized Transaction list immediately
How to back up your important QuickBooks
data
- Click on File
- Click Back Up
- Complete the location where the file will be backed up (i.e. floppy disk in A: or other disk)
- Click the Back Up button
