Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
Hello, @lhumbles.
Allow me to share with you the steps for creating a retention on customer payments.
First off, let's track the retainers you received from your customers by creating a liability account report:
After this, let's proceed on creating a retainer item to use when making an invoice:
Once everything is in place, you're now ready to enter the retention amount on the invoice:
Moreover, you can check out this article for additional reference about recording a retainer or deposit in QuickBooks Online: Record a retainer or deposit.
Furthermore, in case you need to run a report in the future, you can visit these articles:
Feel free to reach out if you have more questions about retainage or any QuickBooks-related queries. It's always our pleasure to help. Keep safe.
The instruction provided by @RogelioL work if you're on accrual basis. If you're on cash basis, assign an income account to the retention item under 'Income account'. Otherwise, QB will book the entire invoice amount as income regardless of the amount of payment received.
Hello, @lhumbles.
Allow me to share with you the steps for creating a retention on customer payments.
First off, let's track the retainers you received from your customers by creating a liability account report:
After this, let's proceed on creating a retainer item to use when making an invoice:
Once everything is in place, you're now ready to enter the retention amount on the invoice:
Moreover, you can check out this article for additional reference about recording a retainer or deposit in QuickBooks Online: Record a retainer or deposit.
Furthermore, in case you need to run a report in the future, you can visit these articles:
Feel free to reach out if you have more questions about retainage or any QuickBooks-related queries. It's always our pleasure to help. Keep safe.
QBO will not allow me to put an asset COA in the income account when adding the new Product/Service.
I appreciate you for chiming in this thread, WAS-adg. I'm here to provide information about adding assets to your income account when creating a new Product/Service in QuickBooks Online (QBO).
QuickBooks Online doesn't allow assigning an asset to an income account when adding a new inventory item. This is to ensure proper accounting practices and accurate financial reporting. However, for non-inventory and service items, you can assign asset accounts to income accounts.
You can also refer to this article on setting up product and service items you buy and sell but don't track as part of your inventory: Add product and service items to QuickBooks Online.
For future reference, you can reconcile your accounts to ensure they match your bank and credit card statements.
Please feel free to click the Reply button if you have other questions about adding an assets account when creating a new product/service item. I'm always here to help.
Hoping you can help. We are on cash basis and are having the following issue: For invoices with the item Retention included, even when no payment is received against an invoice, the retention amount on that invoice is posting under Sales in my cash basis P&L (the original amount shows the total invoice amount and the column "paid amount" shows the Retention amount). I cannot figure out why this is happening other than the fact that the retention amount on the invoice is a negative number, and QB posts the negative service item "Retention" as a sale (credit). This is clearly not correct and overstates cash basis sales. What am I missing?
More context:
We need to keep track of our retention balances separately from our regular AR. Payment cycle and billing timeline/method is different. Thus we have a Retention Receivable account and a Retention A/R account. We create the primary invoice for services (bid amount) separately from a Retention invoice. The primary invoice includes the total bid amount as one line item, and on the second line we have a Retention amount that is negative 5% of the total; thus a negative number reducing the total bid amount. That item "retention" then posts to the Retention Receivable account. As a second step, we create an invoice for the retention funds that will be collected in the future (can be up to 2 years later depending on the job duration). We use the same item "Retention" on the invoice, but post it to the account "Retention A/R" instead of "A/R". The Retention Receivable account thus acts as a clearing house (debit and credit from each invoice clears out the balance). I have attached an example of an invoice for your reference. The $879.80 on this invoice is posting to our August cash basis P&L even though no payments have been received.
I went back and read the thread - these are Retention not Retainers. That is the question that is asked by the first user. Perhaps this set up is incorrect as we are not receiving payment up front from customers, we are required to hold back (not invoice for) a certain % until after the job / contract is fully complete and signed off. Then we can bill the Retention amount to the customer and get paid.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here