QuickBooks Pro 2000 Easy Learning: 2007

Sunday, December 2, 2007

How to export a report to Microsoft Excel

To export a report to Microsoft Excel

You do not need to open Microsoft Excel. QuickBooks Pro will open the application for you when you export the report.

To do so, you have to display the report in the Report window first.
However, you can also select the report in the Report Finder.
And then click on the Excel button at the bottom.
After that select whether you want to create a new spreadsheet or add the report as a new sheet in an existing spreadsheet.

How to Filter the Selected Report

To Filter the Selected Report

First of all, you have to select the Report tab from the menu bar and choose Filters.
However, you can also click Customize in the Report Finder dialog box. After that click on the Filters.
And then you can select what you want to filter for from the list of filters.
Fill in the fields that appear as the picture below shown.

How to add a Column to the Selected Report

To add a Column to the Selected Report

Reports that list individual transactions can show other columns of data in addition to the ones you see when you create the report.

In the Report window, or the Report Finder, click Customize.
To add columns, you have to select the columns that you want to add.
To delete columns, you have to clear the checkmark for each column you want to delete.
Finally, click on the OK button.

How to change the Date of the selected Report

To change the Date of the selected Report

All reports have a default date range when you create them. You can have the report cover a different period of time if you wish.

To use a different preset date range, select one of the ranges shown on the Dates drop-down list.

To change to a period of time not specified by one of the preset ranges, click the calendars to change the dates shown in the From and To fields.
When the calendar appears, click the arrows to display the month you want, then click the day of the month.

How to work with Report Finder

To work with Report Finder

With the Report Finder, you can browse the reports related to what you're interested in and learn what each has to offer, and locate the exact report that you need.

Click on the Report Finder tab from the navigator bar as shown as below.

After that you will see a Report Finder dialog box appear.

For further information about that report, simply double-click on the report.

How to work with Preferences

To work with Preferences

Here you can change the option to suit the needs of your business and your personal style of working.

From the Tools menu, choose Preferences tab.

You can also click on the Edit tab from the menu bar and select Preferences.
You can use the scroll box on the left to display the preferences for another area of QuickBooks.

How to work with Accountant’s Review

To work with Accountant’s Review

An accountant's review copy allows an accountant to review and make corrections to a copy of your data while you continue to work, and then merge their changes back into your file.

From the Tools menu, click on the Accountant’s Review as shown as the picture below.

You can make an accountant's review copy on a diskette.
Your accountant can review your data and make changes. Not all the changes are allowed.
When you have finished, your accountant can save the changes, typically to a diskette.
After that you can merge the changes into your data.

How to work with Back Up

To work with Back Up

You should make a backup copy of your company on a daily basis. Backup copies are important insurance. If you lose any data, you can still restore data from your backup copy.

Select the storage media on which you will back up your QuickBooks Company.
From the File menu, choose Back Up.
You can also straight away choose the Back Up tab from the Tools menu in the navigator bar.

After that you can change the name that QuickBooks suggests for the backup file.
And then change the suggested location for the backup file.
Finally, click on the Save button. Then the data of your company will be back up.

How to work with Timer Import or Export

To work with Timer Import or Export

Time Import or Export allows employees to track their time at their desks as they work. After activities have been timed or entered in the Timer, you can transfer them to your company file. Then you can invoice clients for the time or pay employees for their work.

From the Tools menu in the navigator bar, choose Timer Import/Export.

And then you can choose "Import Timer Data" or "Export Timer Lists".

How to work with Make Journal Entry

To work with Make Journal Entry

The General Journal Entry window is for accountants or people who prefer the traditional system of accounting by entering transactions in a general journal. If you are unfamiliar with how a general journal works, you do not need to use this form.

First of all, you have to enter to the Banking menu and choose Make Journal Entry tab.

After that you will see the General Journal Entry dialog box.

Choose the date, account and the name to make the journal entry.

How to make Entries in the Register

To make Entries in the Register

You can enter checks and deposits directly in a bank account register instead of using the Write Checks window and the Make Deposits window to create the transactions. In QuickBooks, a bank account register can represent a checking, savings, money market, or petty cash account.

Open the register for the account you want to use.
Click in the blank entry at the end of the register.
Enter the date, check or deposit number, and payee in the fields.
Enter the amount:

For checks and fees - Enter the amount in the Payment field.

For deposits and interest earned - Enter the amount in the Deposit field.

How to work with Check Register

To work with Check Register

From the Banking menu, click on the Check Register tab.

After that select the date that you want.
Double-click on the account you want, you will see the detail of the Bill Payments by check.

How to work with Reconcile

To work with Reconcile

First of all, you have to choose the Banking tab from the navigator bar.
After that you can click on the Reconcile icon as shown as the picture below.

And then you will see a dialog box below.

Choose an account to reconcile.
Double-click to see the detail of the credit or the deposits.

How to work with Credit Card

To work with Credit Card

First of all, you have to choose the Credit Card tab from the Banking menu.

After that you have to choose the credit card.

How to work with Deposits

To work with Deposits

First of all, you have to click on the Deposits tab from the banking menu.

And then select the payment that you want to deposit. Click OK.

How to work with Transfer Funds

To work with Transfer Funds

First of all, you have to select Transfer Funds from the Banking menu.

After that you have to select from where you want to transfer the funds and to where you want to transfer the funds.

How to write Check

To write Check

From the Banking menu, click on the Write Check tab.

After that you have to choose whether you want Saving or Checking from the Bank Account drop down box.

How to work with Adjust Liabilities

To work with Adjust Liabilities

If you are using Deluxe Payroll, you cannot adjust the liability balance for liabilities paid by the Payroll Service (federal and state tax liabilities). However, you can adjust the liability balance for local or other taxes not supported by the Payroll Service.

From the Employees menu, click on the Adjust Liabilities tab.

And then you can choose to adjust the company liabilities or employee liabilities.

How to work with Payroll Items

To work with Payroll Items

Payroll items are a unique feature in QuickBooks. There are payroll items for compensation, taxes, other additions and deductions, and employer-paid expenses.

From the Employees menu, click on the Payroll items tab.

After that you will see the Payroll Items dialog box.

How to work with Employees

To work with Employees

First of all, you have to choose the Employees tab from the Employees menu in the navigator bar.

After that you will see all the employees are listing out.
To see the detail of the employee, simply double-click on the employ’s name.

How to work with Process W-2

To work with Process W-2

After you print your W-2 forms, you also need to print a single W-3 form that summarizes the individual W-2 forms. QuickBooks calculates the amounts for the W-3 form by adding up the amounts on the W-2 forms. Unlike the W-2 forms, you cannot edit the W-3 form.

Choose the Process W-2 tab from the Employees menu in the navigator bar.

Then you will see the dialog box as below appear.

How to work with Pay Liabilities

To work with Pay Liabilities

From the Employees menu in the navigator bar, choose the Pay Liabilities tab.

After that you will enter to the Pay Liabilities dialog box.
Here you can see what you want about the Pay Liabilities.

How to work with Pay Employees

To work with Pay Employees

From the Employees menu, Click on the Pay Employees tab.

After that you can modify or choosing the option that suit your company.

How to work with Time or Enter Single Activity

To work with Time or Enter Single Activity

From the Employees menu, choose Time Tracking, and then choose Time/Enter Single Activity.

Enter the date the work was performed and the name of the person who performed the work.
Enter the Customer:Job and Service Item.
In the Duration field, enter the number of hours worked on this date and this job.

How to work with Use Weekly Timesheet

To work with Use Weekly Timesheet

From the Employees menu, choose Time Tracking and then choose Use Weekly Timesheet.
Enter the name of the person who performed the work and press Tab.
If there exists time data for this person for this week, QuickBooks Pro displays it. You can edit the entries.
If necessary, change the date range of the week displayed.
To change to the previous week, click Previous; to change to the next week, click Next.
To change to any other week, click Set Date and enter a date in the week you want to display.

How to work with Print 1099s

To work with Print 1099s

This option allows you to print the purchase order within the date that you specified.

Choose the Print 1099s from the Vendors menu in the navigator bar.

And then you can select the date, which the purchase orders to be printed.

How to work with Adjust Quantity on Hand

To work with Adjust Quantity on Hand

First of all, you have to click on the Vendors tab from the navigator bar and select Adjust Qty on Hand tab.
After that you will enter to the Adjust Quantity/Value on hand dialog box.
Here you can check for the new quantity, current quantity and so on.