AR and dating issues

Jelfor6
Jelfor6 Member Posts: 6

Hi, our terms for all our customers are 30 days from EOM

Some of our customers purchased goods as at 1/10/2020 and they are showing up as due 31/10/2020 when it should be 30/11/2020, and they are showing up on the AR list as 1- 30days which they should be current. Does anyone know why this maybe happening ?

We are using Reckon Hosted

Thank you

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited November 2020

    The EOM terms can occasionally be out by a day or 2 because it's configuration is date driven (eg "30") so this can be slightly out when there are more or less days in a month.  I always check the Due Date on a transaction & amend it manually where necessary.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • JudyA
    JudyA Member Posts: 56 ✭✭✭

    Hi Jelfor6,

    Check your set up for your terms to see if there is an error, as what you describe sounds like it's set up as 30 days. I have this set up for 30 Days EOM:

    And this is for 30 days:

    Both seem to do what they are supposed to. I hope that helps.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    @Jelfor6 JudyA's screenshot above for "30 Days EOM" illustrates my previous answer. 

    This is the correct setup however because some months have 28, 29 or 31 days, the "Date Driven" has the occasional hiccup as you can only specify a single date in the "Net due before the ...." box.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Jelfor6
    Jelfor6 Member Posts: 6

    Hi


    Judy A where do I go to check this ? Is it each customer, I can not seem to find it

    Shaz Hughes - How do I manually change a due date ? I do not have it on the invoice as far as I can see ???


    Sorry for all the questions

  • JudyA
    JudyA Member Posts: 56 ✭✭✭

    To access the terms, on the top tabs go to Lists>Customer & Supplier Profile Lists>Terms List

    You may need to set up a new 30 Day EOM, and you can do that from the bottom of the page under Terms>New

    You can then add these terms under each customer so that they come up automatically when you invoice them. If you have a large customer list it might be easier to add the terms when you create an invoice. (See screenshot below.) When saving the invoice, you should be asked if you would like to update the terms for that customer.

    As for the due date on the invoice, when you click on the invoice tab, do you have something like this on the RHS?

    It's here that you can change the due date. If it's not showing, then you will have to play around with your invoice template settings.

    I hope that helps.

  • Jelfor6
    Jelfor6 Member Posts: 6

    Hi Judy


    Thank you that has helped I have changed my net due driven date from 31 to 30, so hopefully next month it will be correct, it hasn't seemed to changed the historical invoices, buts that ok.

    With the invoice template I have been asked to use, it doesn't have a due date section, it is PO, Terms, Ship via, so I will just keep an eye on it next month, and see if the change to the driven date fixes it