QuickBooks Strategist
Marti DenUyl's Blog
QuickBooks Strategist

Recently Asked: I was using the wizard in the online banking center and linked the wrong bank account and didn’t realize it until I exited the wizard. I didn’t download any transactions, how do I unlink the bank account?

If you are certain you haven’t downloaded any transactions into QuickBooks, the process to unlink the bank account is painless. (If you did download transactions please contact me prior to performing the steps below as you might have other issues we need to address first, such as duplicate entries) 

Go to the List menu and click on Chart of Accounts.  Highlight the bank account that you linked in error.  At the bottom left, click on the Account tab.

Select Edit Account.  The following window will open:



Click the circle next to Deactivate All Online Services.

The account should now be deactivated. If any messages pop up after you deactivate the account, make sure to write it down and forward it to me.

If you found this information helpful, please consider leaving feedback via my QuickBooks ProAdvisor Site. Thanks!

Bookmark and Share

Recently Asked: I prefer viewing deposits via the checking account register. In the deposit window I use the “Received From” field but the names don’t show in the register. Is there another way to view names associated with the deposits?

If you are only concerned with the deposits, I suggest using the Deposit Detail report. You can locate this report under the banking area in the report center.  It will look similar to this:

 The "Name" column usually appears by default. If it doesn't show up in your view, click the Modify Report... button in the top left corner and the following window opens on your screen:

In the Columns box, locate and click on Name, then click the OK button.

If you found this information helpful, please consider leaving feedback via my QuickBooks ProAdvisor Site.  Thanks!

Bookmark and Share

EHTC's QuickBooks Hands-On Beginner Class

When:     Thursday June 10, 2010   9:00 AM – 4:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.

 

 

 

Bookmark and Share

EHTC's QuickBooks Hands-On Beginner Class

When:     Tuesday May 11, 2010   9:00 AM – 4:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.

 

 

 

Bookmark and Share

EHTC's QuickBooks Hands-On Beginner Class

When:     Friday  April 23, 2010   9:00 AM – 5:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.

 

 

 

Bookmark and Share

Reports That Help Fight Fraud - Audit Trail

Because the Audit Trail function in QuickBooks is always on, it reduces fraud since users are unable to turn off the tracking of transactions to hide their fraudulent activity.  To access the Audit Trail report go to Reports/Accountant & Taxes/Audit Trail.

The report will default to the current date but you can edit the date range to suit your needs. Once you have set the desired date range you can review the transactions that pass through QuickBooks. The report can be a little overwhelming to view, but you can use filters to simplify the report. Set the filters by clicking on the Modify Report Button.  Under the Filter tab you can choose the type of data you would like to review (see Figure 1).

 

Figure 1

If there have been any changes to the original transaction the most current change will be listed as “latest” and previous versions of the transaction will be listed as “prior.” This makes it easy to see what changes have been made to the original transaction. You will also be able to determine who entered/modified the transaction as well as the date the changes were made, as shown in figure 2.

Figure 2

Activity to watch for:

  • Customer/Vendor names you don’t recognize
  • Discounts that don’t line up with your company policy
  • Write-offs to Bad Debt expense
  • Changes to prior periods

It is good practice to regularly use the Audit Trail report as part of your month end closing procedures to limit your company’s exposure to fraud.

EHTC's QuickBooks Payroll Class

 

When:  Wednesday March 31, 2010    8:00 AM – 12:00PM

 

Where:  Echelbarger, Himebaugh, Tamm & CO PC’s Training Facility

 

Price:    $199.95 per student, payable by check or credit card

 

Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

 

This class will be taught by Certified QuickBooks ProAdvisor Karen Rosenberger.  Attendees will receive a training workbook to use during the class and to take back to their office.

 

QuickBooks Payroll Class Topics:

 

 

·         Payroll Tax Definitions

·         Understanding the Employee Center

·         Setting Up the Payroll

o   Wage Items

o   Deduction Items

o   Tax Items

·         How to Process Payroll

·         Payroll Liability Payments

·         Preparation of Quarterly and Year End Reports

 

 

Contact Marti for more details about the class agenda and topics.

Bookmark and Share

EHTC's QuickBooks Pro Hands On Beginner Class

When:     Thursday March 4, 2010   9:00 AM – 4:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.

 

 

Bookmark and Share

EHTC's QuickBooks Pro 2009 Hands On Beginner Class

When:     Wednesday February 17, 2010   9:00 AM – 4:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Payroll Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.


Bookmark and Share

EHTC's Quickbooks Pro 2009 Hands-On Beginner Class

When:     Thursday December 10th, 9:00 AM – 4:00 PM (includes lunch)

Where:    
Echelbarger, Himebaugh, Tamm & Co PC's Training Facility
                  5136 Cascade Rd Ste 2 
Grand Rapids, MI 49546

Price:       $199.95 per student, payable by check or credit card


Register:  Call 616-575-3482 and ask for Marti DenUyl or send an email to martid@ehtc.com

This class will be taught by QuickBooks Certified ProAdvisors Marti Den Uyl and Karen Rosenberger.

To ensure maximum hands-on exposure to the QuickBooks application, we're limiting the class size to the first six students who register and submit payment. Attendees will receive a QuickBooks training workbook to use during the class and take back to their office.

QuickBooks Beginner Class Topics:

  • Chart of Accounts
  • Working with Bank Accounts
  • Credit Cards
  • Customer Cycle
    • Setting Up a New Customer
    • Custom Field
    • Entering Sales Information
    • Receiving Payments and Making Deposits
  •  Vendor Cycle
    • Setting Up a New Vendor
    • Custom Field
    • Entering Bills
    • Paying Bills
  • Sales Tax Overview
  • Bank Reconciliation
  • Printing/Emailing Forms
  • Overview of Financial Statements and Reports
  • Overview of Company/Individual Preferences

Contact Marti for more details about the class agenda and topics.

Bookmark and Share

Blog Software