Weekly QuickBooks Tips and Tricks Newsletter

QuickBooks Edition - Issue 10.03

February 15, 2011

This past week I had the opportunity to spend a couple of days with Frank Abagnale (you probably know him from the "Catch Me If You Can" fame) and I learned so much! He has a free download available at http://www.abagnale.com/AbagnaleFraudBulletinVol9.pdf and on page 21 are some best practices for preventing embezzlement that you might want to review. In addition, I will be co-sponsored a three webinar series with Intuit, one of which is focused on errors and fraud in QuickBooks files. See additional details below.


In this issue:

  • Ask the Expert: Job Costing on Journal Entry
  • Ask the Expert: Large *.TLG file
  • Three Webinar Series with Intuit
  • Only until Feb. 25, 2011: Your clients can enter to win $300 to spend with you!
  • About Us
  • Quick Links

Tips and Tricks

Ask the Expert: Job Costing on Journal Entry

Q - When we record a multi-lined journal entry the line that shows up for all the lines of the journal entry throughout other reports is the first line of the je that has a customer assigned to it. How can we fix that? Submitted by Heidi

A - This is a known issue. Make sure you always do the first line as the “no customer” line then it will only pick up the customer on the lines that you need it. Then include the lines in the entry that require the customer:job on the subsequent lines. The result will be that the customer:job will only appear on those lines that have been specifically assigned, where as the other lines on the reports will not include the customer:job.

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

Ask the Expert: Large *.TLG file

Q - Ever since we have upgraded to QuickBooks Enterprise Solutions 11 our *.tlg file has been growing extremely large. In the past it seemed to clear when we did a back up, but even right after a backup it is still huge. I have called tech support and the only response they provide is to delete it. I have been doing that each week, but that does not seem to help. It is causing an issue with our online back up system, etc. Do you have any other suggestions?

A - This seems to be a common complaint since the addition of the new search functionality with the 2011 products. Based on our experience and confirmed with numerous discussion group postings, it seems that the change is related to the index created by the search function. While we love it because it is so fast, it seems that:
1. Most people do not even know it is there; and
2. Unless you use it extensively, it is probably not worth the issues associated with the large *.tlg file.

To check to see if you have this feature turned on or off, log in as Admin in single user mode. Navigate to Edit > Preferences > Search and make sure the check box is not marked for "Update Automatically." Once this preference is changed, complete your back up, delete the tlg file, and then a few days later confirm that it is not growing as quickly.

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

Three Webinar Series with Intuit

Looking for new tools to help you create more profitable, longer term engagements with your clients? We are thrilled to be presenting three sessions in conjunction with Intuit.These sessions each qualify for 1 hour of CPE while providing information that you can use with your client's QuickBooks data to developer deeper business insights, better recommendations, more billable work, and stronger client loyalty. Join us for these interactive sessions to learn more.

Double Check QuickBooks Data In Minutes with AuditMyBooks
Wednesday, March 2, 2011 at 10 AM Pacific/1 PM Eastern
1 Hour CPE is available
Sign Up: https://www2.gotomeeting.com/register/452363306

Get Instant Financial Results Easily with ProfitSee
Thursday, March 3, 2011 at 10 AM Pacific/1 PM Eastern
1 Hour CPE is available
Sign Up: https://www2.gotomeeting.com/register/535785106

Extend QuickBooks Reporting with XpandedReports
Wednesday, March 2, 2011 at 12 noon Pacific/3 PM Eastern
1 Hour CPE is available
Sign Up: https://www2.gotomeeting.com/register/911355867

Only until Feb. 25, 2011: Your clients can enter to win $300 to spend with you!

Just as a quick reminder, now is the time for your clients to sign up for ProfitSee, Profitably, and XpandedReports. Every time they access one of these three apps they will be entered into a contest to win one of 10 $300 prizes to use with a Certified ProAdvisor. Don't know much about these three offerings, watch the webinar recording below to give you a jump start and go check them out for yourself!

To access the recording: http://intuit.connectpro.acrobat.com/p17818278/

To find out more about the sweepstakes: http://workplace.intuit.com/appcenter/promos/haveagreatyear/home.aspx

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, February 15, 2011 - 12:20
Newsletter category: 
Accounting Software Secrets Tips & Tricks Newsletter