finance | QuickBooks for Contractors blog

30Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Balance Sheet by Class Report – Part 8

QuickBooks 2011 - What's New?, Reports

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions; and it gives users the option of selecting “Classes” (fund, location, profit center, or other category) as their column/class grouping. Over the last several days, I’ve been discussing and sharing some information about how we all will need to change our data entry procedures in order to utilize the Balance Sheet by Class Report available in QuickBooks 2011; little did I realize when I started delving into the specifics of this report, that making it work would be so complex. Previous QuickBooks 2011 - New Balance Sheet by Class Report articles include: Part 1, we touched…

28Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Balance Sheet by Class Report – Part 6

QuickBooks 2011 - What's New?, Reports

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions; it gives users the option of selecting “Classes” (fund, location, profit center, or other category) as their column/class grouping. Over the last several days, I’ve been discussing and sharing some information about how we all will need to change our data entry procedures in order to utilize the Balance Sheet by Class Report available in QuickBooks 2011. In previous articles: QuickBooks 2011 – New Balance Sheet by Class Report – Part 1, we touched briefly on the fact that transactions will have to be entered in a very specific manner and there are many data entry…

27Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Balance Sheet by Class Report – Part 5

QuickBooks 2011 - What's New?, Reports

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions. it gives users the option of selecting “Classes” (fund, location, profit center, or other category) as their column/class grouping. Over the last several days, I’ve been discussing and sharing some information about how we all will need to change our data entry procedures in order to utilize the New Balance Sheet by Class Report available in QuickBooks 2011. In previous articles: QuickBooks 2011 – New Balance Sheet by Class Report – Part 1, we touched briefly on the fact that transactions will have to be entered in a very specific manner and there are many data…

24Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Balance Sheet by Class Report – Part 4

QuickBooks 2011 - What's New?, Reports

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions; it gives users the option of selecting “Classes” (fund, location, profit center, or other category) as their column/class grouping. Over the last several days, I've been discussing and sharing some information about the limitations of the New Balance Sheet by Class Report available in QuickBooks 2011 which may make using this report unsuitable for some users. In previous articles: QuickBooks 2011 – New Balance Sheet by Class Report – Part 1, we touched briefly on the fact that transactions will have to be entered in a very specific manner and there are many data entry transactions…

21Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Balance Sheet by Class Report – Part 2

QuickBooks 2011 - What's New?, Reports

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions. This will enable QuickBooks users to perform divisional accounting with QuickBooks, which was previously impossible or required significant duplication of effort. While this report has been one that has been requested by many QuickBooks users and the accounting professionals who support them, it is not without limitations and drawbacks, making this a report that will be able to be used by some companies and in some instances but not all. In our previous article, QuickBooks 2011 - New Balance Sheet by Class Report - Part 1, we touched briefly on the fact that transactions will have…

14Sep 2010 by Nancy Smyth

QuickBooks 2011 – New Average Days to Pay Report

QuickBooks 2011 - What's New?, Reports

The Average Days to Pay report was first introduced in QuickBooks 2011, however, also available in QuickBooks 2012, 2013, and 2014 As the name implies, the Average Days to Pay Report shows you the average number of days that it took each customer to pay the invoices that you sent them. To find this report, from the Report menu in QuickBooks Pro and Premier 2011 and Enterprise 11.0 -> choose Customers & Receivables -> Average Days to Pay. [caption id="attachment_962" align="aligncenter" width="292" caption="Right click on the image to enlarge it."][/caption] The report lists all paid invoices and statement charges; grouped together by customer and job. For each invoice (transaction) the report shows the number of days that it took the customers to pay the invoice. QuickBooks will calculate the number…

27Aug 2010 by Nancy Smyth

QuickBooks Tip-Chart of Accounts, Your CPA & Your Tax Return

QuickBooks Setup & Cleanup

Many companies fail to set up their charts of accounts correctly in QuickBooks. Over the years I have seen charts of accountants that look like a collage of accounts in helter skelter format without any logical order, containing duplicate if not triplicate accounts, inconsistent protocols, and even inappropriate, if not undecipherable, names. At tax time, when their CPA receives either a backup or Accountants copy of the file like OR reports that have been created from the file, it becomes an even bigger mess. The trial balance that must be created by the tax preparer requires countless hours of reclassifications and groupings to mesh and coordinate the amounts within the file to the classifications required on tax returns and financial statements. Business owners then bear the costs of needless and…

26Aug 2010 by Nancy Smyth

QuickBooks Tip – Modifying & Working with your QuickBooks Chart of Accounts

QuickBooks Setup & Cleanup

Setting up or modifying an existing Chart of Accounts is not an overwhelming task in QuickBooks. If you are new to QuickBooks, when you create your company file (File menu -> New Company), the EasyStep Interview provides you with a “wizard”, industry specific templates, and example accounts are even suggested. If you need a starting point, grab your tax return or financial statement compiled by your outside accountant, and enter the accounts you find there, turning summary accounts from the financial statements into subaccounts in QuickBooks. If you have already started using QuickBooks you can easily add, edit, or merge accounts in your Chart of Accounts for your business with a matter of a few clicks of your mouse by selecting the Lists menu -> Chart of Accounts OR Company…

25Aug 2010 by Nancy Smyth

QuickBooks Tip – The Chart of Accounts, What It Is & It’s Many Uses In Your Business

QuickBooks Setup & Cleanup

The Chart of Accounts is the most important QuickBooks list. It is the backbone for a company to track how much money it has, how much money it owes, how much money is coming in, and how much money it is spending. [caption id="attachment_510" align="aligncenter" width="300" caption="Right click on the image to enlarge it."][/caption] It is not necessary to have a chart of accounts that provides for every conceivable transaction. Instead, the chart of accounts should include the minimum number of accounts necessary to capture the appropriate financial information and be flexible enough to allow for future growth. The chart of accounts should be designed to include the accounts necessary for both financial and income tax reporting. QuickBooks makes it easy for you to set up a chart of accounts.…

03Aug 2010 by Nancy Smyth

QuickBooks Payroll Services-Which Option is Right for You?

Payroll Tips, QuickBooks Setup & Cleanup

Figuring out which QuickBooks Payroll option is right for your business can be a pretty daunting task; especially with all of the payroll options that are now available. We all know one thing - if you have employees, you have to pay them! That's simple. Determining which QuickBooks Payroll option is the right solution for your company is a different story though - let's look at the options available: Intuit Online Payroll – internet based and totally removed from your QuickBooks desktop company data file. It comes in two versions – Basic and Plus. Basic includes the ability to process an unlimited number of payrolls each month, includes free direct deposit or allows you to print checks and check stubs on your own printer – directly from the on-line system;…

30Jul 2010 by Nancy Smyth

QuickBooks for Contractors Tip – Basics of Progress Invoicing

Customers & Accounts Receivable

Progress Invoicing is a standard feature of QuickBooks® Pro, Premier, and Enterprise editions; each of these versions also offer several options for invoicing as well. In order to implement the Progress Invoicing function you must also utilize the QuickBooks Estimate function – this will eliminate repetitive data entry and help you achieve good job costing reports, such as Estimate vs. Actual reports. To activate Progress billing you MUST first log into QuickBooks as the QuickBooks Administrator and be in single-user mode. From the Edit menu -> choose Preferences -> scroll down to Jobs & Estimate -> and click on the Company Preferences tab. Once you are in the Company Preferences tab, review and set the options as follows: Do You Create Estimates – should be set to Yes Do You…

29Jul 2010 by Nancy Smyth

An Introduction to Progress Invoicing

Customers & Accounts Receivable, The "Sunburst" Website

Progress Invoicing (also called progress billing, percentage of completion billing, or partial billing) involves billing from an estimate (or Schedule of Values) over the course of time and could be considered a type of installment billing. Progress billing is commonly associated with the construction industry; however, it is common in other industries as well. QuickBooks® Pro, Premier, and Enterprise editions all offer several options for invoicing and a Progress Invoicing function is also available. Some projects or jobs will require only a single invoice, others will require two invoices, others may require three invoices (one at the start of the job, one when you are 50% done, and the other when you are finished), other projects might require that you submit monthly progress invoices over the course of months or…

28Jul 2010 by Nancy Smyth

Certified Payroll & AIA Billing Updates

Certified Payroll/Prevailing Wage, Customers & Accounts Receivable, The "Sunburst" Website

We've been testing, debugging, and documenting numerous certified payroll and AIA billing updates for the last few weeks - I've posted some of the information behind the changes here in our blog. Today, I just send out a newsletter to over 2,000 construction companies (in all 50 states) who use our software - Glad I use Constant Contact to keep everyone up to date, otherwise they would get me for spamming :-) Below are highlights from the newsletter. Certified Payroll Solution Updates: There are several new enhancements, changes, and requirements available for Certified Payroll Solution; some at the State level for certified payroll reporting and others at the Federal level for EEOC Reporting - each item has a link to our website where you will find complete instructions. Be sure…

12Jul 2010 by Nancy Smyth

Calculating & Displaying Fringe Benefits on a Certified Payroll Report

Certified Payroll/Prevailing Wage, QuickBooks 2010 - What's New?, The "Sunburst" Website

One of the biggest causes of confusion for contractors working on government funded construction projects is “how to calculate and display fringe benefits” on a certified payroll report. In recent months, I have repeatedly seen posts from QuickBooks users on the Intuit Community Forums asking how the fringe benefit rate is calculated and then displayed on the Certified Payroll Report in Excel, which is now a standard function of QuickBooks Premier and Enterprise when used in conjunction with Enhanced Payroll, and I really haven’t seen any good responses. Hence today’s blog post. Background: Contractors who work on government funded construction projects are required to pay their employees a “prevailing” rate of pay; based on where the project is located and the type of work they are performing. This “prevailing rate…

09Jul 2010 by Nancy Smyth

QuickBooks Tip – Handling Retainage

Customers & Accounts Receivable, The "Sunburst" Website

Retention or retainage is usually a specific percentage, for example 10%, of the total contract that is held back by the project owner in reserve to protect the owners interest. Retention is not held in a lump sum, but rather held at the stated percentage for the amount requested on each application for payment. Your contract should set the terms, including the percentage and when the hold-back will be paid. Contractors using QuickBooks often run into difficulties when handling retainage/retention; simply because the software doesn't have a means to automatically deal with it. Because QuickBooks doesn't have a built-in retention function, like many of the more expensive construction specific software program, QuickBooks users must initiate work-arounds and make QuickBooks track retainage that is held on each progress invoice. Over the…

Tag: finance