Results 1 to 7 of 7

Thread: Negative amounts on Customer age analysis

  1. #1
    Full Member
    Join Date
    Oct 2014
    Location
    Cape Town, Muizenberg
    Posts
    28
    Thanks
    2
    Thanked 1 Time in 1 Post

    Negative amounts on Customer age analysis

    Hi,

    We have some debtors account reflecting small negative amounts i.e the customer overpaid (R100 here & there)..
    It's been on our age analysis for awhile even dating back to 3 years. We have sent a letter to all these debtors requesting their bank details in order for us to refund them but we've received ZERO replies. Unbelievable right?

    Anyway I just wanted to know if there is a way of writing this off from the debtors book??

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Yes, you can.

    You will need to process a Customer Journal, debiting the customer account and crediting a general ledger account of your choice, perhaps Sundry Income. You can use a narration along the lines of "Unclaimed overpayment by customer".
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Full Member
    Join Date
    Oct 2014
    Location
    Cape Town, Muizenberg
    Posts
    28
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks Neville.
    I was thinking of doing this but is this an acceptable accounting procedure?
    I don't know why I feel like I would be "stealing" the money if i move it to an income account...

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    If it bothers you, then perhaps open a Suspense account in the Balance Sheet and transfer the amounts there, so that they don't reflect as income, but rather as a potential liability.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Full Member
    Join Date
    Oct 2014
    Location
    Cape Town, Muizenberg
    Posts
    28
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks Neville

  6. #6
    Full Member EAB's Avatar
    Join Date
    Jun 2016
    Location
    Roodepoort
    Posts
    88
    Thanks
    0
    Thanked 13 Times in 12 Posts
    What usually happens is that the overpayments will be kept on the age analysis for 3 years, after that the amounts will be written off to the income statement. As per Neville's first comment.

    You are not stealing the money, you intended to pay pay the money but they didn't respond to your requests, seems like they don't want it. And if they didn't claim it after 3 years it will be highly unlikely for them to claim the money at all.

    I understand what Neville is saying, but it will not really be a liability because the you most likely will never pay the money back (not because you are stealing, but you can't get details to refund it). So if you show a liability it will be something that gets moved from the debtors to another balance sheet account and never gets cleared.

    Remember that if you are VAT registered you need to declare the amounts that was written off to the income statement

  7. Thanks given for this post:

    CuriousEL (28-Sep-16)

  8. #7
    Full Member
    Join Date
    Oct 2014
    Location
    Cape Town, Muizenberg
    Posts
    28
    Thanks
    2
    Thanked 1 Time in 1 Post
    This is helpful many thanks Werner

Similar Threads

  1. [Question] Customer Age Analysis
    By car trader in forum Accounting Forum
    Replies: 3
    Last Post: 03-May-16, 07:49 AM
  2. Replies: 1
    Last Post: 20-Jul-15, 01:56 PM
  3. IN PUTTING OF TAKE ON AMOUNTS
    By Tat in forum Accounting Forum
    Replies: 4
    Last Post: 14-Mar-14, 03:31 PM
  4. Duplicated Invoice amounts
    By Alan Wilson in forum Accounting Forum
    Replies: 1
    Last Post: 11-Jul-13, 02:22 PM
  5. Codes (an amounts) on IRP5?
    By J7J in forum Tax Forum
    Replies: 2
    Last Post: 19-Nov-12, 11:49 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •