QuickBooks Tip - Handling Retainage

Retention or retainage is generally a specific percentage, for instance 10%, from the total contract that's held back through the project owner in reserve to safeguard the proprietors interest.  Retention isn't in a lump sum payment, but instead held in the mentioned percentage for that amount asked for on each application for payment.  Your contract should set the terms, such as the percentage so when the hold-back is going to be compensated.

Companies using QuickBooks frequently encounter difficulties when handling retainage/retention due to the fact the program does not have a way to instantly cope with it.

Because QuickBooks does not possess a built-in retention function, like most of the more costly construction specific computer software, QuickBooks customers must initiate work-arounds making QuickBooks track retainage that's held on each progress invoice.

Through the years, I have seen several work arounds that various companies, their bookkeepers, as well as their an accounting firm have implemented, for example:

Simply departing the retention quantity of each invoice relaxing in their open A/R.Billing just for the amounts on each line item they're taken care of.Developing a Customer known as Retentions Receivable after which making some fancy Journal Records each billing period to maneuver the retainage in the coming initially from customer towards the Retentions Receivable customer.Utilizing a QuickBooks Discount Item to subtract retainage on individual bills and mapping it towards the Chart of Accounts as either an Earnings Account or Expense Account.Creating some other Current Resource Account, known as Retainage (Retention) Receivable and by using "Products" instantly slowly move the money for this account on each invoice that's produced.Developing a Sub-Account of A / R known as Retainage (Retention) Receivable after which by using Products and extra bills slowly move the retainage amounts into this recently produced A / R sub-account.

All these techniques has their very own disadvantages, however, the very first three (4) techniques referred to make the most issues with the companies accounting records and therefore are techniques which i recommend that you simply avoid.

The simplest manner in which I understand of, is monitoring Retainage as some other Current Resource Account in your Chart of Accounts - Balance Sheet section however, MUST get together with your accountant and also have him train you to definitely perform a journal entry which will take away the amount from Earnings.

To apply this technique:

Add some other Current Resource account for your Chart of Accounts known as Retainage or Retention Receivable.Create some other Charge OR Service item inside your Item List known as "Less Retainage", map this towards the account you produced in Step One,  as well as in the speed box enter -10.%.Create another Other Charge or Service item inside your Item List known as "Retainage Due", again mapping it towards the account you produced in Step One.Make certain that you've a Subtotal item inside your Item List.Make your Invoice or Progress Invoice billing for that full amount before any retainage is withheld.  Around the first blank line at the end from the Invoice, choose your Subtotal item and your Less Retainage item - the total amount around the invoice which goes to someOrUr has become the total amount after retainage, and also the retainage money is moved to another Current Resource Account. You will get Reviews around the Retainage Receivable account showing who owes you what by visiting your Chart of Accounts, click the account produced in Step One to focus on it, click on the Report button at the end from the window and selecting QuickReport.When you're prepared to bill for retainage, produce a "normal or regular" invoice while using Retainage Due item and entering the right amount of money in the report.

When I mentioned earlier in the following paragraphs, this is actually the simplest method - since it is just adding two additional products to the foot of your invoice and all sorts of math and jobs are accomplished for you however, the quantity of retainage that you simply subtracted turns up inside your Profit & Loss Report inside your Earnings Account (even when you take the reviews on the Cash Basis) which does require that the Journal Entry be produced to get rid of this out of your Earnings. You should talk to your take into account the correct entry.