Weekly QuickBooks Tips and Tricks Newsletter

QuickBooks Edition - Issue 10.16

July 19, 2011

We Need Your Help

We have been helping Intuit get the word out about the App Center products. As part of that there is now a 12 month subscription available for ProAdvisors and a series of webinars to provide you information on the products. See the details below. In addition, we are working with the IPP Marketing Team about what ProAdvisors would like to have available to help their clients. As a result, we have a 4 question survey to accumulate your opinions. It should only take you a couple of minutes but I would really appreciate your participation. Here is the link: https://www.surveymonkey.com/s/7B876Z2


In this issue:

  • Ask the Expert: Merging List Entries
  • Bill.com Promotion for QuickBooks Online Users: Worth up to $75
  • FREE 12 Month Subscriptions for ProAdvisors
  • Upcoming Live Events
  • About Us
  • Quick Links

Tips and Tricks

Ask the Expert: Merging List Entries

Q - My lists have gotten a little out of control with numerous duplicates. How do you recommend I clean up the chart of accounts and vendor lists?

A - The easiest way to clean up the lists is to edit the one you once to get rid of and change the name (or account number) to match the one you want to keep. This process does require single user mode. Once you make the change, when you save it, a message will appear that confirms that you want to merge the two names together. Acknowledge the warning and all the transactions will be merged together with the new name. To see what has been edited or merged, the easiest way is with the Accountant Edition is to use the Client Data Review to see the list changes.

For the vendor list, the merge process is the same as above. If the duplicates are the result of downloading bank transactions, the most current versions have the concept of renaming rules. For older versions it was a more cumbersome "alias" concept. For the more current versions, first merge the duplicates, then there is a link to the renaming rules list in the upper right of the Banking > Online Banking Center screen for review of the rules that have already been set up. Then within the matching window, if the payee name is changed, a pop up box will appear stating that "All future downloaded transactions from this downloaded payee will be automatically renamed." Once the renaming rull has been created, it is possible to edit it. For example, "Office Depot 1234" can have a renaming rule so that it will be renamed to "Office Depot." Then that rule can be modified to contains, begins with, ends with or exactly matches a specific name. From the renaming rules screen it is also possible to remove a rule.

As a resource for this and other questions, submit a question via "Ask the Expert" or attend our free, monthly discussion forum webinar.

Bill.com Promotion for QuickBooks Online Users: Worth Up to $75

Bill.com, the leader in integrated bill payment, online invoicing and cash management solutions for small and medium-sized businesses (SMBs), has just added seamless synchronization with QuickBooks Online. QuickBooks Online customers can now view invoices online, route bills for approval, and pay them online through Bill.com. All bill and payment activity is matched accurately in QuickBooks Online eliminating the need to manage multiple systems.

Take advantage of a limited time, special promotion to use Bill.com and have Bill.com pay your phone bills for the next 3 months (up to $75). Thousands of businesses are already using Bill.com to save over 50% of the time and cost it takes to pay bills. And now the savings is even greater…let Bill.com pay your bills for you by taking advantage of the special promotion. With the integration, it’s easy to get started instantly. Now you can download all open invoices from QuickBooks Online directly into Bill.com - along with vendor lists and chart of accounts. You can begin paying bills instantly and avoid the time and costs of starting a new system. Bill.com gives you complete control over your finances and gives you peace of mind to enjoy why you’re in business in the first place.

Learn more about the promotion: http://appcenter.intuit.com/promos/bill.com-its-on-us

FREE 12 Month Subscriptions for ProAdvisors

:I am thrilled to be included in another Intuit promotion. Intuit is currently offering 12 month subscriptions to four different applications as a pilot ProAdvisor program. Simply go to http://appcenter.intuit.com/promos/growyourpractice and click on request a subscription and scroll down to the form. Fill in your contact information including you ProAdvisor Contract Number (log in to https://proadvisor.intuit.com/login/ and you will see the contract number next to your name. When you press Submit, it will provide you the opportunity to choose a Business Profile name that you have already created, or choose a new one, and you will be subscribed to a no fee, fully functional, single user subscription of the application. The four applications that are currently included are:
* ProfitSee
* EZ Analytics
* AuditMyBooks
* XpandedReports

On that same web page there are also 1 hour webinars (with CPE credit available) featuring one of the four products each Thursday in July. Sign up today!

For all the details, links, etc: http://appcenter.intuit.com/promos/growyourpractice

The Sleeter Group Accounting Solutions Conference

Below are some live events in the next couple of months. If you are attending, let me know. I would love to catch up with you in person! For the full schedule including remote events, please visit our Training Calendar.

September 18-20, 2011: Accounting C4 (Cloud Computing Collaborative Community) Conference powered by RightNetworks, Boston. I will be presenting a few sessions including those for XpandedReports and Legrand CRM.

November 7-9: The Sleeter Group Accounting Solutions Conference, Las Vegas, I will be attending and I am serving on the Developer Advisory Panel for the Awesome Add-On Consulting & Awards Program. Use code "BN2011" for a discount on the registration fee prior to August 31, 2011 (the code can only be used during Super Early Bird or Early Bird period) for a Regular or Combo registration on Regular or Combo registrations only - not Member or Multi registrations. Registrant may not combine use of promo code with new attendee discount; however, registrant may receive credits for referring new attendees.

About Us

McWilliams and Associates can help you keep pace with all your QuickBooks clients. Through many self-service options on our website www.accountingsoftwaresecrets.com, group settings like seminars and webinars, or one-on-one services, we help you quickly and painlessly navigate through the obstacle course of QuickBooks and related add-ons. Our clients are primarily from all over the United States with 95% of our work being done remotely with other Accountants and Pro Advisors, or with their clients if they prefer. We do not do any income tax work or financial statements so there is never a conflict of interest. Most of our QuickBooks consulting clients need 2-6 hours with us to deal with a specific issue, transition, or just for those occasional questions that come up.

In addition to QuickBooks we love working with integrated applications: Some specific examples include XpandedReports, Fishbowl Inventory, and Legrand CRM. We have experience with all these products and would love to partner with you as you help your client address needs that are beyond the scope of QuickBooks alone.

If you want more information on how we might best work together, call 800-787-8744. We would love to talk with you about your needs and any special deals we have for Bookkeepers, Accountants, and ProAdvisors.

Quick Links

Monthly Discussion Forum

XpandedReports for QuickBooks - Use affiliate code of "4luvofbiz" for an additional 1 month extension on the 1 month trial for the desktop (XR 4.3) product.

Virtual Time + Expense - I have been able to negotiate the same deal as I am getting for you: FREE! Free accounts will be provided to accounting professionals who provide accounting services to other companies on a full-time basis by using the link below.

AuditMyBooks - Interested in learning more about detecting errors and fraud in small business accounting systems? Visit my affiliate site to download the white paper titled “Protecting Your Business from Accounting Errors & Fraud”.

We have a non-ownership business relationship with Intuit, XpandedReports, Fishbowl Inventory, AuditMyBooks, Virtual Software, BQE Software, The Sleeter Group, Alterity, MISys, RightNetworks, Insynq, Remote Accounting Solutions, CA CPA Education Foundation, and CPE Link.

Tuesday, July 19, 2011 - 21:15
Newsletter category: 
Accounting Software Secrets Tips & Tricks Newsletter