Factoring

Factoring

Didn't find your answer?

Hi,

Please can somebody guide me with the following factoring issue.

1. Note that customer invoices have been loaded into Sage following the normal process

2. However, the outstanding debt from the above customers has now been sold off to a third party debt collecting agency

Please can you guide me with how to account for the factoring issue in Sage so that:

- the customer accounts are no longer showing an outstanding debt

- how to account for the admin charge bu the factoring company

- how is the bank affected?

Your help will be much appreciated

KR

Replies (9)

Please login or register to join the discussion.

Routemaster image
By tom123
31st Mar 2012 18:12

Create a new 'sage' bank account.

I would suggest you create a new 'Sage' bank account.

Post a customer receipt to this internal account, for the full value of the customer invoice.

Post a bank transfer between the internal account and your normal current account for the amount of funds received.

Post a bank payment, from your internal account, to factoring charges for the difference.

 

Note that, in normal factoring, you would not normally show the individual invoices as paid off just because factoring funds have been advanced against them - but I guess from your question these particular debts have truly been sold, rather than just advanced against.

Thanks (0)
avatar
By nadia_a
31st Mar 2012 18:24

Thanks Tom

 

Yes, the debts have been sold off to third party.

 

One question I do have regarding you point below just to clarify:

' Post a customer receipt to this internal account, for the full value of the customer invoice'

- Do I post one journal to clear all the outstanding debt against the customer and post the 'payment' against the internal account

- Post the factoring charge as an expense to the P&L, which is paid via the internal account

- then funds from the internal account are transferred to the business bank account 

Thanks (0)
Replying to marks:
Routemaster image
By tom123
31st Mar 2012 18:48

That seems fine.

You have said that you are going to post a journal to clear the customer balance. I think you should use the transaction type of customer receipt - hence the reason for using a 'bank' account so that you have the option of that type of transaction.

You could manage the same routine via credit notes directly to nominal accounts, but that would involve more transaction entries.

Thanks (0)
Replying to Edwin Shelton:
avatar
By nadia_a
02nd Apr 2012 08:39

what happens at year end

Tom,

I was just wondering what would happen at the year end - I am assuming that the 'internal' bank account will have a balance - would this need to be accounted for on the balance sheet at year end when the accounts are prepared for the prior year?

Thanks (0)
avatar
By nadia_a
31st Mar 2012 18:51

Thanks very much Tom - very helpful

Thanks (0)
By ChrisScullard
31st Mar 2012 22:24

All seems overly complicated to me.  If you know that the cash received equated to 90% of the debtor balance then allocate the cash received to the invoice in the usual way.  You can then clear the balance (i.e. the factoring fee) either by using the discount funtion when allocating cash in the bank module or by raising credit notes to clear the outstanding balance - simply change the default nominal to the factoring charge nominal.

Thanks (0)
Man of Kent
By Kent accountant
31st Mar 2012 22:55

Agree with Tom

Makes reconciling to the factoring statement at the month end very straight forward

Thanks (0)
Man of Kent
By Kent accountant
02nd Apr 2012 13:27

Year End

@nadia_a

The balance should be shown in creditors <1 year, it would be accurate to disclose it separately in the notes as 'factoring account'. This balance should be reconciled to the factoring  company's statement.

Thanks (0)
avatar
By Chris Smail
02nd Apr 2012 14:06

Now hang on

Is this a normal factoring arrangement? If so the debt remains on your books and you borrow money against it using a dummy bank overdraft as discussed above.

 

Or is it a totally dead debtor where you have handed over all rights to a collection agency in return for a fixed fee. In which case what you get from the debt collector goes against the invoice and you write the balance off.

Thanks (0)