Accounting for Factored Invoices

My brain is failing me on how to set up our Free Agent accounting system to handle payment of factored invoices by the factoring company.

We upload our invoices to be factored on a Friday and 90% of invoice value hits the bank by Wednesday in one big lump sum.

When the bank transactions are uploaded it flags the big factored payment as unexplained. The problem is it can't be explained with the standard options given.

What's the best way to get round this

Should we delete the flagged lump sum from the bank upload and manually pay 90% of each invoice factored?

Then I run into the problem of factoring fees not allowing the full invoice value to be paid...

I'm sure it's simple but I can't get my head around the accounting transaction...

I'll no doubt get the accountant in to sort it in the next week but a heads up would be good.
 

David Griffiths

Free Member
  • Jun 21, 2008
    11,553
    3,669
    Cwmbran
    It depends to some extent on how closely you want to track your invoices and accounts receiveable within Freeagent. In other words, do you want to enter all of your invoices into the system and track individual customer payments so that you know how much each owes?

    Or are you content to simply enter totals into Freeagent and rely on the factor for detailed listings?

    Going the first route

    1 Set up a new bank account called Factoring Account. This will track money paid to the factors from customers and money transferred to you.

    2 Raise your sales invoice in the normal way, as if you were sending it direct to the customer - you may actually do that.

    3 The initial payout that you receive is booked as a transfer from the factoring account to your local current account. In fact this applies for all payments from the factor to your bank.

    4 When the customer pays, or part pays, credit the invoice and bank the money in the factoring account (reflecting the fact that the factoring company received the cash.

    5 Factor fees and interst are shown as payments from the factor account to the relevant expense.

    That's basically it. You should be able to use the monthly reports from the factors to check your sales ledger balances and the factoring account balance. In fact, depending on the company, making sense of the statements might be the biggest challenge! :)
     
    • Like
    Reactions: CKG
    Upvote 0
    In fact, depending on the company, making sense of the statements might be the biggest challenge

    My thoughts exactly. The statements are horrid.

    Thanks for the explanation. It was the creation of the additional factors bank account I was missing.

    Can't see the wood for the trees sometimes.
     
    Upvote 0
    Hello,
    I think opening bank account to be able to account for factoring is a bit more of a headache than figuring out Free Agent. I have created a Bill for the fee paid to a factoring company. Then added a manual bank entry for the amount of the fee (if you date it close enough to when the payment of your factored amount is coming through then Free Agent will pick it up easily). Then I went into the automatic bank entry for the full amount paid by the factoring company and added the two invoices as explanations one by one indicating that full amounts have been paid. Free Agent then offered my manual bank entry as an explanation for the balance. So all three entries were now sitting there and everything was balancing!

    Cheers!
     
    Upvote 0

    Latest Articles

    Join UK Business Forums for free business advice