The Book-keepers Forum (BKF)

Post Info TOPIC: Urgent: Unreconciled items


Guru

Status: Offline
Posts: 501
Date:
Urgent: Unreconciled items
Permalink Closed


Hi,

 

I am faced with the following situation and was wondering whether anybody is able to help:

 

1. A client invoices several different customers for the services they provide them as normal

2. The payment received by the client does not match exactly to the invoice amount - this is due to the way the payment schedule is agreed.

3. The above is done by a third party on behalf of the client who deduct their fee as well as withold the input VAT  - which is transferred to the client when the VAT return is complete in order to allow a payment to be made to HMRC.

My concern is that the customer accounts on the system will always show as being outstanding for payments as the payments received are not matched off properly against customer invoices - therefore this will create a large debtor balance at year end which will be incorrect.

What is the best way to approach this.



-- Edited by NA_AA on Tuesday 24th of January 2012 09:17:35 PM

__________________

Thanks, Nadia.



Senior Member

Status: Offline
Posts: 426
Date:
Permalink Closed

sorry I really am having trouble picturing the true difference on the accounts etc - if you want to email the question over with any figures Ill have a go at helping.



__________________

 

Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900

Payroll & bookkeeping solutions - info@completebookkeeping.co.uk

www.completebookkeeping.co.uk

IAB Training centre - Ringwood

 



Expert

Status: Offline
Posts: 2085
Date:
Permalink Closed

What you are describing sounds very much like your client is using a factoring company. If this is the case the way I do it is to set up the factor as a bank account and show their fees in a similar way to bank fees. The invoice less fees should should match the payments. The VAT is then just shown to be paid from the factor 'bank' account rather than a normal current account. Most factoring companies will also provide regular statement to allow ou to reconcile their account.

Kris

__________________

BKN Most Innovative Accountancy Firm 2012

Director and Co-Founder of The Bookkeepers Alliance

 



Senior Member

Status: Offline
Posts: 210
Date:
Permalink Closed

Agree with Kris - if it's a factoring account - set up as a separate bank account. Make sure that you allocate the correct (full) amount of the payment to the customers, not the discounted amount (unless of course, the customer really has underpaid).
Watch out with the Factoring statements (if it is factoring) as most Factors produce two sets of statements, (a sales ledger statement and a "client funds" statement - so, ensure that you are reconciling to the correct figure for the overall liability to the Factors).

I did a series of blogs on factoring last year, and you might find the one on bookkeeping helpful.
http://www.happyaccountant.com/2011/08/bookkeeping-for-factoring/


__________________

Louise @Figurate   Tel: 01604 288024
web: www.figurate.co.uk - Chartered Management Accountants
blog: www.happyaccountant.com - free info on accounts, bookkeeping & tax plus the occasional meandering 



Guru

Status: Offline
Posts: 501
Date:
Permalink Closed

Yes they are using a factoring account - it's quite confusing how the payments are applied / should be applied against the customer accounts:

What things / statements should I request from the factoring company?

__________________

Thanks, Nadia.



Expert

Status: Offline
Posts: 2085
Date:
Permalink Closed

Who is the factoring company?

__________________

BKN Most Innovative Accountancy Firm 2012

Director and Co-Founder of The Bookkeepers Alliance

 



Guru

Status: Offline
Posts: 501
Date:
Permalink Closed

I do not have the full details as yet - this is the scenario presented to me, and I have to decide whether I want to take on this work as I am not familiar with work which involves factoring

__________________

Thanks, Nadia.



Expert

Status: Offline
Posts: 2085
Date:
Permalink Closed

I have had a few clients who used factoring. They all used Bibby. The range of reports were reasonable and could be downloaded from a client area of the website.

Kris

__________________

BKN Most Innovative Accountancy Firm 2012

Director and Co-Founder of The Bookkeepers Alliance

 



Guru

Status: Offline
Posts: 501
Date:
Permalink Closed

Does the involvement of factoring add alot more complexity to the normal book-keeping work?

__________________

Thanks, Nadia.



Senior Member

Status: Offline
Posts: 210
Date:
Permalink Closed

Yes, it's additional work. For a start, it's another bank account to reconcile and some extra data input. How much more complex depends on the Factor. Some Factors produce excellent reports, and make certain things easier (for example they some make it clear which invoices have been paid, without you having to trawl through remittances). Others have terrible reports (quite frankly) and create a lot of additional work.

Ask the client if you can see some reports, so that you can get an idea of the volume etc... and also if they can arrange for you to have online enquiry access to their Factoring account (otherwise you will spend a good deal of time "chasing" for the correct report).

Also, not all clients understand what their Factoring reports mean - so be prepared to go directly to the Factor in the event of a query (and make sure both client/Factor would be happy with this) - hopefully, once you're on top of it all, this will be a rare occurence.

__________________

Louise @Figurate   Tel: 01604 288024
web: www.figurate.co.uk - Chartered Management Accountants
blog: www.happyaccountant.com - free info on accounts, bookkeeping & tax plus the occasional meandering 

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About