“Stuff” No One Ever Told Me About…

Being a business owner presents many challenges, these are just some of them!

Print Friendly

Thinking of developing a WordPress blog or a Joomla website?  Microsoft offers a free web development tool, called WebMatrix, which includes EVERYTHING you need for website development – all installed locally on your computer so you can learn how to use WordPress or Joomla before actually making your site live with a website hosting provider.

Microsoft WebMatrixI discovered WebMatrix a few weeks ago when I wanted to test some new WordPress plugins for this blog and I also needed to take a look at Joomla 1.6 in preparation for upgrading our website later this year.  Previously I had used another tool and was having issues installing it on my Windows 7 laptop; I can’t tell you how thrilled I am to have found WebMatrix – it’s so much easier to use than the previous tool!

To begin the download and installation process for WebMatrix, go to http://www.microsoft.com/web/webmatrix/, click on the green Install WebMatrix button on the upper right.

NOTE:  If you can’t download WebMatrix, download the Microsoft Web Platform Installer 3.0 first from http://www.microsoft.com/web/downloads/platform.aspx

Download complete instructions by clicking here.

Print Friendly

social media marketingSocial media and marketing your business articles are widely available, and I tend to read a lot of them, however,  one thing that has always plagued me is how often should you post, tweet, email, etc.  How much marketing is enough and how much is too much?  After all no one wants to be considered an annoying spammer.

Market Unto Others As You Would Have Them Market Unto You… We are adopting this new marketing attitude here on the QuickBooks for Contractors blog; we’ll continue to provide a new daily blog post; however, we will be far more prudent in the manner in which we will be publishing the content.

You can find us on LinkedIn – QuickBooks for Contractors group, Twitter, and FacebookAfter today we will no longer be sharing our content on multiple LinkedIn groups.

OR subscribe to our blog via email or RSS Feeds.

We want to make sure that you are receiving our content because YOU WANT TO rather than because we are pushing it at you from multiple platforms.

Here’s Why

Sometimes I think that I’m on information overload  from all the updates that I receive on a daily basis – between LinkedIn, Twitter, Facebook, RSS feeds and email.  I bet that many of you feel the same way.

There are times when I wonder if I’ll ever get any work done because there is so much “stuff” to read.  Monday is an especially bad day, for me anyway – Monday morning typically finds me downloading anywhere between 225 and 275 pieces of email!

As business owners we all need to market our business, therefore, we blog, tweet, and update.  But are we blogging, tweeting an updating the right things with the right frequency?  Or we coming off as spammers?

I guess I was in a researching mood over the weekend; either that or I was just at the point where I really felt that I needed to know this information and what I discovered I felt I should share with others.

Blogging:

Striving to publish a blog article on a daily basis is an awesome goal and is something that just about all of the articles that I’ve read have suggested.  If you don’t feel that you can come up with new content on a daily basis (and it is a lot of work) then come up with a schedule that you can stick to; once a week, twice a week, or even three times a week, and then be consistent.

BUT, you need to make sure that what you are blogging about is good content – something that is relevant to your audience.  Ultimately, your audience is vast and includes more than just your circle of friends and followers.  This happens when your blog is discovered by Search engines, which then send people outside of your circle to your blog.  This is known as “organic” traffic and “inbound marketing”, people finding us instead of just us pushing our content out to others.  We should ALL strive for organic traffic.

Twitter, LinkedIn and Facebook

You can integrate your Twitter Tweets with your LinkedIn and Facebook status so that every tweet you make shows up in all three places.  We can also link our blog to our Facebook business page, which then flows over onto our personal page.

Does it make sense to push the same content everywhere?  We need to keep in mind that if we appear in each of these network updates  multiple times each day promoting the same content to the same people that it begins to look spammy and gives the appearance that we are trying to hard to promote ourselves.

Marketing articles suggest that you update these statuses at least 3-5 times a day and that each tweet contain something new and relevant in order to not appear like a spammer.  But if we have the same connections on each of these networks, aren’t we just overloading them with the same information via different methods?

Email Marketing

Our email Inboxes contain an unlimited amount of “stuff” – emails from clients, friends, ads, newsletters, RSS feeds and SPAM.  Keeping it cleaned out is a full-time job in itself.    If you are a business owner it seems that all the marketing articles say that email promotion is the way to go.  Just be careful on how frequently you send out promotional articles and ALWAYS provide a way for the recipients to “opt-out” of receiving future emails for your company – and be sure to honor the opt-out requests.  The last thing that you want to have happen is to have your emails frequently reported as spam.

Newsletters

Newsletters that contain relevant content should be sent out on a regular basis – weekly, bi-weekly, monthly, quarterly – whatever schedule that works for you.  People tend to sign-up or “opt-in” to receive your newsletters because they feel that the information you offer will be relevant to them.

Closing

If every business owner were to use each of these methods as recommended I think that we will end up as being an annoyance instead of a valued and trusted source of information.

What are your thoughts about Social Media and Marketing?  How Much is TOO MUCH; and are you feeling like you are experiencing massive information overload like I am?  How are you handling it?

Print Friendly

Have you ever had a dream where you desperately needed to run fast (you’re being chased by Sasquatch, say) but your feet just won’t go? Your feet can only go in slow motion?

Is your QuickBooks file slow as molasses?If some of your QuickBooks reports seem stuck in molasses, or it’s taking a minute or more to save an invoice, that’s about as fun as a bad dream.

Performance problems in QuickBooks are one warning sign that your QuickBooks data file is probably getting too big. (How big is too big? We’ll look at that in a minute.)

Another warning sign is when you get random errors or crashes in QuickBooks. It doesn’t crash ALL the time, and you can’t reproduce the problem whenever you want (as if you want to!) But QuickBooks sometimes flakes out and crashes. This is probably related to the file being oversized.

Or maybe there IS one particular process that QuickBooks consistently fails on (backing up, verifying, rebuilding, and upgrading are the most common.) Since we troubleshoot these kinds of database problems all the time, we see lots of QuickBooks data files, and many of the files with these kinds of problems happen to be very large files.  In my opinion, that’s no coincidence.

Here are some comments QuickBooks users have made to us about their large files:

  • “Speed has degraded over the years and causes systems to lock up.”
  • “slow due to too much data”
  • “slowness, occasional crashes”
  • “Generally slow but the file is so huge that when we try to do a tax report it crashes every time”
  • “Cannot upgrade because file size is so big”
  • “Data file is really big, very large number of DB file fragments, cash reports take a LONG time to run, some reports won’t export to excel at all”

So, how big is too big?

Some say that 100MB is the effective upper limit for QuickBooks Pro or Premier files. I don’t agree with that; we talk to people with files in the 100-200MB range all the time who are doing alright.

Really, the proof is in the pudding. If QuickBooks is performing well for you – consistently fast and stable – then your file size is probably fine. Especially if it’s under 250MB. If it’s not performing well, then there’s a good chance it’s getting as unhealthy as that poor guy in the “Supersize Me” video.

Enterprise Series is designed for more simultaneous users, more transactions, bigger lists, and larger files. How big is too big for Enterprise? Again, it’s not a hard line, and the most important issue is how well it is performing. I’d say if the file is bigger than 750MB, or is running into performance/stability issues, then you might look at options to bring the file size down.

What options?  What can be done if my file is showing warning signs?

You can run the Cleanup command in QuickBooks (aka Archive/Condense). This will bring the file size down some, but in many cases not enough to make a difference.

We can supercondense the file, which can reduce its size by 50%.

Or you (or us, or others) can recreate your file from scratch, creating a blank new file and bringing selective information from the old file into the new file. File size reduction of 90% is common here.

The main thing is this: If the performance or stability of your file is becoming suspect, it is good to be proactive and take steps to address the problem sooner rather than later. “Later” in that scenario often becomes “crisis”.

About the author: Shannon Tucker is an accounting database specialist and the President of AccountingUsers, Inc. You can reach him at 719-395-8750 or tucker@accountingusers.com

Print Friendly

AuditorGiving your QuickBooks company data to an IRS Auditor is almost like inviting a stranger into your home – you don’t know what they will do, and at this point in time, I haven’t found any information on exactly what an Auditor will look for or what they will do once they do get their hands on your data file.

To be honest, I don’t even know if they are required to return your QuickBooks (or Peachtree) data file to you once they are done.  I do have to assume that they are required to do so, but you never know………..

Hopefully, you will follow the suggestions outlined in An IRS Audit and They Want Your QuickBooks File – Best Practices article and provide a data file that ONLY contains the year in question.

The last thing that you really should do before handing over the file to be audited is to create an External Accountant User for their use – do not give them your Administrator password.

An External Accountant is a fairly new type of QuickBooks user account that was introduced a couple of years ago.  Anyone who logs into your QuickBooks file as an External Accountant User has access to all areas and information contained in your data file with the exception of sensitive customer data, such as credit card information (if you keep customer credit card data in your file).

To create an External Accountant User

You will need to be logged into QuickBooks as the Administrator and I believe you need to be in single-user mode.

  • From the Company menu, choose Setup Users and Passwords
  • Select Add User
  • Enter a new user name and password – write this information down and give it to the auditor, and click Next
  • Choose External Accountant in the Access screen and click Next

external accountant user

  • Click Yes on the Warning message to confirm that you want to create an External Accountant User

external accountant user warning

  • Click the Finish button

By creating the External Accountant user, you will be able to pull up an audit trail report to see if they changed anything if the file is returned.  Of course this is getting a little paranoid, but one of the fears that I’ve seen people discussing is what if the auditor goes in and changes something…….

Please feel free to leave your own comments, suggestions and thoughts for best practices on this new procedure – it will be of benefit to everyone.

Search…….

Loading

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management.
Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime
February 2012
S M T W T F S
« Jan    
 1234
567891011
12131415161718
19202122232425
26272829  
Top 10 Blogger Award Toolbox for Finance