Accounting for Factoring Receivables in QuickBooks Online

[@woodbridllc9344]

Seriously Seth? Are you real? You made these factoring transactions so easy to understand, all of them...and believe me I don't understand English very well...but I understood everything you said!!!! I will put you a red carpet everywhere you go!!!! THANK YOU SO MUCH!!!!

[@nerdenterprises]

Thank you so much!!!!

[@kathybennett142]

This video is the best I've seen explaining the bookkeeping of factored invoices. Thank you for sharing.

[@nerdenterprises]

Why THANK YOU Kathleen!

[@Tiffany.B.]

I agree. I'm a new bookkeeper and I want to niche down to owner operators. This is a service I want to offer but I couldn't find a good tutorial on it until now

[@phyllisjrcrestorationdecordesi]

FINALLY! the breakdown of factoring invoices that makes so much more sense to me! Thank you!!

[@marigalloway]

This video is great. I reference it ALL THE TIME.

[@nerdenterprises]

Thank you! If you love this video then you will really love my course on this topic: nerdyurl.com/factoring

[@CJ-bk8tt]

Just wanted to say thank you! 3 years later and this video is still proving itself to be valuable. Again, thank you.

[@nerdenterprises]

Amazing, thank you so much for sharing!

[@leagbor]

@@nerdenterprises Hello, kind of three years late. What happens when the invoice is “recoursed” And other adjustments?

[@nerdenterprises]

@@leagbor It's a little involved for comments on KZbin, but essentially you have to follow the money. If the factor forces you to buy the invoice back (recourse) then you have to repay any amounts they advanced you against that invoice, possibly plus interest, and now it's back on you to either collect or write it off as bad debt.

[@hannahsilva7443]

This was invaluable to me - thank you! I am cleaning up back books and I'm not an accountant, but the wife of a business owner. So grateful for the help. Also, I just found out that my factoring company charges way less than most, so that was awesome to know, too! :) Many thanks!

[@nerdenterprises]

Thank you! I am so glad you found it helpful! You should see my course on this subject ;)

[@tonyprince916]

Thank you so much! The instructions I got from the factoring company were complete crap, but this made it crystal clear. Thank you for your time explaining the ins and outs of how to do this properly!

[@nerdenterprises]

Thank you! I am so glad this helped!

[@tabezona85]

Best factor invoice video in youtube. But... Here's a challenge for you. How do you record in QB a partial payment because the factor paid one of your vendors directly? Client Invoice $1000 Vendor bill directly related to the client invoice above $800 Factoring company paid $800 to my vendor. My initial deposit $150 Factoring fee $15 Escrow account $35

[@CouchCourt-n4x]

I literally come back to reference this just to make sure Im doing this right 5 years later thanks to quickbooks finally allowing us to upload journal entries because just to factor the invoice its like 4 lines multiplied by 50 a week doing this manually was a part time job now we can do this in minutes

[@nerdenterprises]

Thank you! I am so glad you find this helpful!

[@lesliemeadows1490]

BTW our business is cash basis if that makes any difference in the manner it is entered but I do use the correct date for deposit received and payment date

[@Jay-tt3px]

You're the best! Thank you!

[@LUIZAT2004]

Thanks for the clarification. And what about the interest on the operation. Beside the bank fee, there is the finance expense.

[@nerdenterprises]

Assuming that is deducted from their payments to you, it would be handled the same way - as a deduction from the deposit booked to interest or finance fee.

[@KimberlyDana-f6x]

Can you do another video from the vantage point of the factoring company?

[@AmyNoelonDyslexia]

4:50 making the bank deposit.

[@nerdenterprises]

Thank you. We've added this into the index in the video description.

[@brendagallegos3]

Do you have a video on how to reconcile QuickBooks for factored Invoices

[@nerdenterprises]

Hi! I have an entire course on the subject: nerdyurl.com/factoring This walks you through every aspect of the accounting for factoring receivables.

[@lesliemeadows1490]

Thanks for your reply.

[@s.victoriavindas488]

Hello! I have a Question What is the best way to register when the factoring company does not keep reserves and the just pay the whole ammount with "Fees" , and "Expeses" Deducted ?

[@nerdenterprises]

It's the same process, but you don't need to account for the reserve. So the Loan amount is the total invoice amount (same as in the video) and you'll deduct the fees etc... and that will reconcile with the net amount deposited into your account. Then when the client pays, you wipe out the loan amount, and write off the receivable. Presumably you don't get any of that money since the factor advanced you 100% of the invoice.

[@jessicahill3545]

Thanks for explaining the factoring on this video. I am having trouble with the debits and credits and how the Loan Payable gets cleared. Any way to get a journal listing for each of these 3 steps in your video?

[@kyliebarta621]

This was helpful. I do have a question, after receiving the deposits and such, receiving payments, and the company writes a check to the bank for the full amount. Will that check go to the NP Factor account to reduce it to zero?

[@accountingmatrix]

That will only reduce it to zero if there are no other outstanding factored receivables in the Factor Loan Payable, but conceptually yes, the collection of the amounts from customers to the factor gets applied to the receivable and offsets the loan payable. Generally, the company does not write a check to the bank to pay off the loan because the loan is paid off by the customers when they pay their invoices directly to the Factor. If the customers pay the company directly, then they do need to turn around and repay the loan amounts to the Factor.

[@avi8641]

Thank you for this tutorial. How do I record in QBO transaction where my factoring company is actually sending the advancement to my vendors rather than awarded it to my bank account? Only once my invoices have been paid by the customer and the loan has been paid off, my factoring company will send the remaining money to my account. I've followed all the steps in the video but something doesn't add up. Thank you in advance!!

[@nerdenterprises]

Hey sorry for the delay in answering this! I would set up a bank account called, "Factor Clearing" or something like that. Then you can record the advances as deposits into that account while you set up the loan balance. Then you can record a bill payment out of that account to pay your suppliers. This way you get everything booked without it impacting your actual cash balance.

[@jaybook]

Thank you for this video Seth. The visual on top of the explanation makes this pretty easy to understand. Of course real life is less than ideal, but this is a great foundation. I was wondering - what's your position on the different way that more people(from what I can find) are teaching this, especially in regards to factoring with recourse? Specifically, you set up a loan whereas other sources are crediting A/R to sell the invoice to the factor. And then there's a recourse liability as well. Personally, I prefer the way you teach it, especially if by creating a loan for the full invoice the recourse liability is built in.

[@nerdenterprises]

Hey Justin! Thank you for your kind words. My issue with recording a credit to A/R is that we're marking a receivable as paid before the customer has paid. We're effectively marking something as paid that the customer hasn't paid yet. In short it's not bulletproof. It's BulletHOLE accounting. FYI I have a course on this that goes even deeper and also offers a few pretty slick (my opinion of course) templates to help you calculate and track everything: www.nerdenterprises.com/v2-factoring-receivables

[@jaybook]

@@nerdenterprises thanks for the info Seth! I will keep that course in mind because I'm a new bookkeeper and I may want to make trucking(which I've heard is a common industry that uses factors) companies one of my niches. Does that course offer any support if you're still stuck on something? One more question for you if I may - I recently watched your other video, which is older, on this topic but for QB desktop. In that one, you had made the loan the amount of the advance instead of the gross amount, and you took out the fee on the first payment as well as the second. On the former, is that a preference thing or have you changed your preferred method to the gross amount? On the latter, is that just dependent on when the factor deducts their fees?

[@nerdenterprises]

@@jaybook After years of working with many clients 1:1 (many as a result of that older video you saw) I realized that from the Factor's perspective the Loan amount was the gross amount of the receivable. So while the old way was correct in the sense that everything would reconcile, this way is more "Bulletproof" because we can tie our balance sheet to the Factor's reports.

[@jaybook]

Thank you so much Seth for clarifying that and for your time :)

[@nerdenterprises]

@@jaybook My pleasure.

[@lauracrean6178]

Thanks for the video. I have two question; hopefully you can provide some insight. 1. Factoring company doesn't provide us with advance until we request it. I assume I wouldn't use 'Checking - 1234'/a bank account for Bank Deposit. Set up a current asset/advance account and I can show any request of funds via transfers into our bank account? 2. Factoring company purchases invoices end of each month. They purchase about 200 out of 210 invoices each month after I create these and send to customers each month end (invoices created & AR in balance sheet). In following the video I now have: - AR balance (or accepted and non accepted invoices) - an Advance account; and; - a Reserve account So duplication. I'm unsure if I should/can change where the invoice amounts go (default to AR in Chart of accounts)?

[@nerdenterprises]

Hi Laura. Yes, it seems like you would set up some sort of an asset account reflecting the value of the sold invoices as what you can draw against. Then for item 2, yes, you have an extra asset account for the invoices you've sold, but didn't choose to get funded on.

[@hannahsilva7443]

Quick question - if you see this. Would you handle transactions from Square the same way? I'm trying to figure out how to manage fees in general for accounting. Many thanks!

[@nerdenterprises]

Square is pretty different. You're processing payments on sales, so the payments come in and you have to handle the fees, but there's no loan against them and no receivables behind it.

[@hannahsilva7443]

@@nerdenterprises Thank you!

[@poiisedfan6810]

What should be done with the bank feed, once the payment actually hits the checking account?

[@nerdenterprises]

If this is done correctly the transactions in the bank feed will easily match the ones you've recorded in QuickBooks Online.

[@kwamehorton9054]

It seems you could have explained this a little simplier as most companies do not put the money their factor fund company is holding for them, hence the term "reserve", directly into thier bank account, instead the reserve goes into the factor funds bank account. I know you attempted to explain that approach next, but why not explain this approach first? But thank you for the video.

[@morreenklement9345]

This has been so helpful! We will get our reports on a monthly basis. From watching your video, will we have to show our customer's invoices as unpaid until we get the report from the factoring company? Our customers are emailed links to see the invoices currently and we don't want to confuse them by showing its still unpaid even after they pay the factoring company.

[@nerdenterprises]

Thanks Morreen! Yes the idea is that you don't want to mark an invoice paid until it has actually been paid. The Factor isn't paying the invoices. They are advancing you monies against those invoices. Most factors have a portal you can log into so you can see any payments that came in. So you shouldn't have to wait a month.

[@morreenklement9345]

Gah! Of course. Thank you!

[@relaxedclub9425]

What is the difference between the 1st & 2nd bank deposit? I tried it & 2 bank deposits are created to match the net pay in bank feed. These created 2 matches in bank feed & actually only one match is needed

[@nerdenterprises]

The first deposit you record in this process is when you receive funds from the factoring company in exchange for the receivables you pledged. That part is just a loan. There would only be one deposit to record here and that would match the funds you received from the Factor. The second deposit in the process comes later when the customer pays the Factor. The Factor will collect those payments, pay off what they've loaned you against those receivables, deduct any fees, balance escrow (if applicable) and then send any remaining funds.

[@mattc5268]

Is this recourse you are showing

[@melissajones857]

Thank you for this video! It helped me so much. I do have one question.. what do I do with all the ACH transfers for these payments made that are still in my "banking" section waiting to be transferred into quickbooks online?

[@nerdenterprises]

Hey sorry I missed your comment. If you have transfers from the factor, they are either the original loan amount, which the video explains how to handle, or they are fundings after the original loan which means you have to refer to the factor's reports to find out what invoices were paid, how those were applied to repay the loans, account for any fees and escrow, and then the funding (ie the transfers into your account) are the difference they owe you back. I think to give you a better answer I would need to see what's going on in your books and with the Factor reports etc...

[@harshalmagar16]

Can you confirm how we can clear the "Checking - 1234" account that you had created. As it will always show on the Balance sheet which is wrong.

[@nerdenterprises]

Hi. That's the actual bank account. Of course that will always show up on the balance sheet. It is absolutely correct, I promise.

[@NicoleDiVincenzo]

How do you record invoices that were sent to the factoring company that did not end up being factored but the invoice amount was sent to the escrow(reserve) account?

[@nerdenterprises]

I'm not sure I follow. If the invoice was sent to the escrow reserve account, doesn't that mean that it was in fact, factored? If it was just an entry you made on the books, you can reverse it. I probably need a little more information to understand how to answer this properly.

[@jessicahill3545]

Where is the write-up that you are speaking about?

[@nerdenterprises]

The link is in the description: nerdenterprises.com/factoring-receivables-in-quickbooks-online/

[@thomasenzmann6225]

Please someone tell me why factor reserved account needed?

[@nerdenterprises]

Many factors hold on to some of your money as a sort of security deposit. That's what the reserve account is for. If your factor doesn't do that, then you don't need it.

[@thomasenzmann6225]

@@nerdenterprises what's wrong if I treat it this way?......... make deposit from Factor Loan Payable with only advance. after when We get paid then receive payment to undeposited fund and transfer this fund deducting bank charge and loan payment to bank placing minus sign before bank charge and loan payment of specific invoice. (NB--I am a new qbo learner)

[@nerdenterprises]

@@thomasenzmann6225 The simple answer? Your books won't be accurate. I would want to know the true amount of what I owe on the loan, and I would want to know how much of my money the factor is holding onto. Also easy to mis-state fees (the expense or cost of this) when you're not recording things at their true amounts.

[@kaitlynmacdonald2564]

When I am adding my transactions from my accounts to QBO... my received money from factor... which manually entered bank deposit do I match it to? Or do not match it and add it separately?

[@nerdenterprises]

If you are entering your transactions correctly the deposits should match. You can't add them because you need all of the details that I described in this video.

[@NaseemMatteson]

How do you do Factoring people's bookkeeping in QBOA? Like how would they get these into their Accounting software? So when they paying the down payments and settlements, they are using Accounts receivable and Accounts payable, in 1 transaction.? Thanks

[@nerdenterprises]

Hi Naseem. I am not sure I follow the question. QBOA is just the accountant's portal where you manage your accounting clients. The above video shows you the precise process for how to record this in QuickBooks Online (which is the accounting software). As you'll see in the video above, we are not using Accounts Receivable or Payable for most of this. We have a Loan Payable, and Likely an other current asset for the escrow amounts that the factor withholds. The only time accounts receivable is used, is when the customer pays, and then we have to show the receivable as paid.

[@NaseemMatteson]

@@nerdenterprises Quickbooks Online Advance

[@NaseemMatteson]

@@nerdenterprises I'm sorry for the confusion, I'm trying to figure out accounting for a factoring business and I would like them to be on Quickbooks Online but they are using AP and AR in the same transaction. And that is throwing me off. Was looking for some help on ytube and came across this video, so thought to ask if you had any suggestions or videos on that? Thanks

[@nerdenterprises]

@@NaseemMatteson Hi, no that's a mess. I would untangle it and have them do it the right way :)

[@NaseemMatteson]

@@nerdenterprises what's the right way? I am so confused. Is there a sample or a video of the right way?

[@nerdenterprises]

THIS JUST IN... My Bulletproof Bookkeeping ™ Guide to Factoring Receivables course is now live: nerdyurl.com/factor-checkout

[@robynbanks1941]

Hello do you have an email ? A way to get in touch with you? Or if you could answer my question. What should i do in the event after the 30 days have passed and i received payment from the customer but they short paid me? But the factoring company provided me with the full amount. How do i go about entering that when I’m doing the bank depositing part of the undeposited funds?? Pleaseeeeee help