How can I setup payment terms for a customer who has 45 days from end of month?

Bryan_7001179
Bryan_7001179 Member Posts: 2
edited August 2019 in Reckon Accounts (Desktop)
How can I setup payment terms for a customer who has 45 days from end of month? All I can see is Standard - due in xx amount of days or date driven due before the xx day of the month. Neither of these options will work. I need 45 days from the last day of the month, this could range from 75 days (1/6/2014) to 45 days (30/6/14) as an example. Thanks, Bryan

Comments

  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    Bryan you cannot. That's an very odd request.
  • Bryan_7001179
    Bryan_7001179 Member Posts: 2
    edited July 2014
    Thanks Kevin, I have similar terms with a few customers. I am surprised is seems that odd. Perhaps they can make some changes in later versions. Bryan
  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    I'm surprised you are surprised. I've only been a bookkeeper for fifteen years and I've never heard of it before. One thing I'd like to do that reckon doesn't allow is eom after eom.
  • Mirko
    Mirko Alumni Posts: 1,258 ✭✭
    edited November 2015
    Hey Bryan,

    I managed to get this work with a bit of tweaking (and help from my colleague John).

    I made an invoice on 10/07 22/07 & 25/07 and with the settings in the image below managed to get due date of 15/06 for all of them.

    image

    Try this out.

    - Mirko
  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    Mirko mate, try it with February 1st. It gives you 43 days. Like I said, Ive tried every permutation of this and I don't think it will work. Cheers.
  • Mirko
    Mirko Alumni Posts: 1,258 ✭✭
    edited November 2015
    Granted Kevin, it may be possible if you set up 4 permutations which coincide with whether the next month has 28,29,30 & 31 days. It's getting way out there but it's possible, not very pretty at all though!

    Easiest would be to set up singular rule for 28 day month as each month has 28 days, but would not give you true representation of 45 days in 11 out of the 12 months in a year, and 12/12 in a leap year.

    I'll send off both your (EOM after a EOM) and Bryan's feedback to development for future consideration.

    Thanks!
  • ARC BookKeeping
    ARC BookKeeping Member Posts: 168
    edited August 2014
    Hi ya All,

    I have just had a play....
    Is my maths wrong or does this work..... give it a try... 
    image

    please tell me I am wrong cause it is doing my head in....lol

    Cheers
    Angie Carlyle
  • ARC BookKeeping
    ARC BookKeeping Member Posts: 168
    edited August 2014
    Think i have answered my own question..
    Invoice dated 1/1/14 would be due 45 days from 31/1/14 which is 17/3/14 not 15/3/14 which is what would generate with the above.... so they would only get 43days not 45days and on months with 31 days in the middle they would get 46days .....

    so no it doesnt work

     bugga...
  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    With the most humble and sincere respect that is what I said at the outset. I have been over this year's ago. It simply can't be done.
  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    Sheryl it cannot be done. This has been done to death already. The only possible work around is to change the due date manually on the invoice every time. I can appreciate you would like a fix but I think accepting it isn't possible might be helpful at this stage.
  • Kevin V. Russell
    Kevin V. Russell Member Posts: 265
    edited June 2015
    No problem Sheryl, this is what I do.
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited September 2018
    Hello Bryan, Depending how serious you would like to get this fixed, as there is no straight solution within Reckon Accounts, we have been looking at this issue,we can get you tool installed which will automatically set the terms from 30 days to 75 days without you doing it manually. However, we cannot achieve this in Hosted version. We are at this moment trial stage of hosting Reckon Accounts ourselves and be able to provide this tool. we would say we can finalise the trial stage in next 3 months time or so. if interested contact us on :chandra@cosmicaccountinggroup.com.au


    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Paul Roseblade
    Paul Roseblade Member Posts: 1
    edited January 2015
    This reply was created from a merged topic originally titled How do I set up custom payment terms 45 days from end of month, in Accounts Accou.... I need to set up custom payment date terms for a customer who pays 45 days from the end of the month that the invoice was raised. I have Accounts Accounting 2014. Can anyone help?
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016

    Hi Sheryl,

    I have just had a play and it seems that if you enter due 30th and next month 30 days it works. Assuming you accept the 28th February as the "30th" of the month.

    I tried 31 days, but that does 2 months if the invoice is raised on the 31st.

    Kind regards,

    Sally McIntosh (sally@samsolutions.com.au)

  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016
    No it doesn't Kevin, but Sheryl was asking for 30, not 45.
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016
    It didn't. Sheryl asked a similar but different question. So rather than starting a new post, she commented on this post and I answered for her.
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited September 2018
    Paul, look at my above comments above , its possible.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited September 2018
    not possible within Reckon, yes, but we can do it thru add on tool , as i said above.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Tracey Brown
    Tracey Brown Member Posts: 1
    edited February 2017
    Did this ever get fixed? Drives me crazy that I can't send accurately aged statements. It's a basic necessity and makes us look very unprofessional.

    I am very surprised that a bookkeeper of 15 years hasn't heard of these terms from EOM. I've been working in accounts for over 20 years and have never worked in a company that doesn't have 30 days from EOM terms.