by Sunburst Software Solutions, Inc.
Archives by Month

quickbooks file

Cleaning Up Your QuickBooks File at Year End

Most of us strive for an organized work space and a clean desk – if not on a daily basis at least once in blue moon. But few of us ever think about including our QuickBooks file when we think of “cleaning up at year end”. You probably think I’m a little nuts, right? Well maybe I am, but……
Continue reading

QuickBooks Payroll Record Keeping Tips-How To Stay Organized

In order to be well prepared for a Wage & Hour audit that you need to keep your payroll records for the duration of EACH worker’s employment with your company PLUS 5 to 10 years! Most Human Resources and legal experts are suggesting this to ensure these records are available in the event a claim is filed,

Discover what records you need to have available for an audit and how to store that information without having to have a bunch of file cabinets in your office.

Continue reading

What Are DB File Fragments and Why Do I Get Them in My QuickBooks File?

DB file fragment is basically a measurement of how much your company file changes. It reflects how much and how often QuickBooks messes with it. This is not something peculiar to QuickBooks files. With any file in Windows, as changes to the file happen on the hard drive, Windows sometimes keeps segments of data together, and sometimes Windows will assign segments of data somewhere else on the drive. That “somewhere else”, in QuickBooks, is a DB file fragment.

When you restore a portable copy, it basically plops your file’s data into as much contiguous hard drive as it can find. Then when you do stuff in QuickBooks, the data changes and expands as new records are added or even modified. So Windows pushes the file out into new sectors of the drive and creates a new 'file fragment'.

Continue reading

QuickBooks 2013 – Where Have the Colors Gone?

QuickBooks 2013 has an entirely new look and I have to admit there are many things about the product redesign that I really like, however, the biggest issue that I have with the redesign is the fact that Intuit has removed the ability to change the color scheme of the software.

Where oh where can my QuickBooks colors be, Intuit took them away from me…….ya, I know that sounds like a really bad rendition of an old song - but color is an important part of our daily lives and is said to influence our mood. What do you think of the new grey-on-grey look of the QuickBooks top icon bar?

Apparently Intuit is hearing all of the negative feedback on the lack of color and are proposing a change - if you would like to see what they are proposing (and I think it's pretty lame) take this survey at https://survey.intuit.com/survey/survey_page.cfm

Continue reading

Weekly Wrap-Up: News You Can Use 6/1-6/7/2012

Weekly wrap-up of news and information from around the web – there’s so much information out there that it’s difficult (at best) to keep up! I’ve added a WordPress plug-in that grabs information from my Twitter stream to help me (and hopefully you as well) keep up with everything. Look for the Weekly Wrap-Up: News You Can Use every Friday. I'll try to be consistent and organize the information into the same categories each week.

See what caught my attention this week in these topics: Accounting & Taxes, eBooks/Webinars/Videos, Payroll/Certified Payroll/Prevailing Wage, QuickBooks, Small Business/Organization/Productivity, Construction, and Social Media/Marketing/Website Design.

Continue reading
About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert


I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.


QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Search our site
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:


Enter your email address:

Delivered by FeedBurner


We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!


QuickBooks Time Tracker