by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks 2011-Estimates & More Excluded from Closing Date

Print Friendly, PDF & Email

QuickBooks 2011 offers the ability to exclude Estimates, Sales Orders and Purchase Orders from the Closing Date lock.  This is a key piece of functionality that will be attractive to contractors and other business types who often have open Estimates, Sales Orders or Purchase Orders; which I just learned about yesterday in a “New Features in QuickBooks 2011” webinar presented by Joe Woodard.

QuickBooks 2011 New FeaturesThe Closing Date feature in QuickBooks is designed primarily to protect transactions from previous reporting periods from being changed – for example, it is often a general practice for an accounting professional to set a closing date in a clients QuickBooks file after they have finished preparing their tax returns.  Setting a Closing Date allows the accountant to know that the client cannot go back and make changes to transactions that would impact the tax returns that were filed.

Unfortunately, the Closing Date feature works as a “lock”; and effectively prevents a user from making changes to open “non-posting” transactions such as Estimates, Sales Orders, and Purchase Orders.

It’s common in the construction industry to have Estimates that remain open for 6 months to sometimes several years – depending on the size of the job, when they were awarded the contract, and even when they actually start to work on their piece of the project.

With previous versions of QuickBooks, a business owner who utilized these types of non-posting transactions could not use this feature until AFTER the transactions had been closed (Estimate fully invoiced, Sales Orders fulfilled, or Purchase Order completely received); however, their accountants would frequently enter a closing date when they were finished with the tax return.

This caused a lot of hassle and additional work for the business owner.  They would need to create a 2nd Estimate in it’s entirety and then create a single progress invoice billing out everything that they had billed up until the time that their books were “closed” by their accountant – they then had to set the invoice as  “Mark as Pending” so that it wouldn’t show up in their Accounts Receivable.

With QuickBooks 2011, you can now choose to exclude these open, non-posting transactions when you set a closing date!

If you are a QuickBooks user be sure to tell your accountant about this feature, and if you are an accounting professional, ask them if they need access to these transactions BEFORE you set the closing date, they’ll love you for it!

This option is available from the Edit menu -> Preferences -> Accounting -> Company Preferences tab -> click on the Set Date/Password button -> then check the option to “Exclude”.

exclude estimates from closing date

Right click on the image to enlarge it.

To some this will seem like a small and perhaps unimportant change; but for some it will be a HUGE improvement in the functionality.

how to complete a certified payroll report Request our FREE 142-page “What’s New in QuickBooks 2011? eBook, by completing a simple request form.

This eBook will provide you with with all the information I’ve posted here in our blog, plus MORE!

Once you’ve completed our simple request form, you’ll have instant access to this 142-page .pdf eBook, designed to be duplex printed and put in a binder for future reference.

5 Responses to QuickBooks 2011-Estimates & More Excluded from Closing Date

Leave a Reply

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