by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Tip – How To Handle Stored Materials and AIA Pay Apps

Print Friendly, PDF & Email

QuickBooks has no built-in ability to handle stored materials, like many of the more costly construction specific software programs.  This causes problems for contractors who need to generate AIA Pay Apps and need to make sure that their books (or accounting data) syncs with their AIA Applications for Payments.  This question was originally asked on the Intuit Community forums.

QuickBooks tipsI am unsure of the proper way to handle stored materials. My General Contractor lets us bill for stored materials used in construction by way of standard AIA Pay Apps.  I am needing a way of keeping my AIA Pay Apps and QuickBooks invoicing in sync.  All invoices are done with AIA payment applications so the GC never sees the QuickBooks invoices.  However, I still need to produce the estimate and progress invoicing in QuickBooks to keep my books straight.  I believe I should create an invoice for the stored materials and transfer this amount to the pay app but I am not 100% sure.  Also, when I receive the materials initially, I enter the bill from my vendor.  I am trying to make sure I am not generating duplicate charges for the same material.  I don’t think I want to cross over to using inventory because I would have nearly a year’s worth of invoices etc to convert.  Does anyone have any suggestions?


Best Practice for Handling Stored Materials and AIA Pay Apps

Because the General Contractor allows billing of stored materials on the AIA Payment Application you also need to include the amount of stored materials on your QuickBooks Progress Invoice in order for your accounting records to match your AIA billing records.

Here is an example of how you would handle it, both in QuickBooks and on the actual AIA Pay App.

Let’s say that you have a job where you are installing a large bricked patio and walkways with some decorative fountains and benches in a park.  The scope of work involves Site Work, Excavation, Concrete, Masonry, and Specialty Items (the fountains and benches).  We’ll focus on the Specialty Items in this example.  Your Original Contract Amount for the Specialty Items (the amount you will be billing the GC for just those items) totals $43,460.00.  The Vendor that your ordered the Specialty Items from delivers two fountains and a bench to the job site – but you aren’t quite ready to actually install or place them just yet – they become Stored Materials (because they are actually on the job site but not yet in place).  It’s time for you to generate your monthly pay application and you will be billing your GC for 50% of the original amount of the Specialties line item.

On your Progress Invoice, you’ll bill for $21,730.00 (50% of the Specialties line item) PLUS any completed work you’ve also done.  Below is what your QuickBooks Progress Invoice would look like.

Stored Materials

I like to use the memo field to hold a notes – on this Progress Invoice I would add the following memo:  “Specialty items delivered to job site – billed as stored materials.”

On the AIA Pay App, the $21,730.00 should appear in Column F – Materials Presently Stored (Not in D or E) on the Continuation Sheet, see below:

AIA Continuation Sheet

When it comes to entering your Vendor Bills and duplicate charges.  It would depend on how the Items in your QuickBooks Items List have been set up.  If each item has been set up correctly there shouldn’t be any issues.  (That is an entire blog post all by itself!).

In my opinion, tracking stored materials is not appropriate in this situation.  The Materials that are ordered, delivered to the job site, and are billed as stored materials are materials that are your company has ordered for this specific job.

I hope you find this article to be helpful, if so please take a moment to either leave a comment or share it on your favorite social media platform.



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.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
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