Item incorrectly posted to wrong income account

Chelsea
Chelsea Member Posts: 5
edited January 2020 in Reckon Accounts (Desktop)
Hi all! 

Need help please! I am using Reckon Accounts Enterprise 2019.

I have noticed that when i am invoicing freight to our customers, reckon is posting that income to 'sales'. I have looked in our item list and our 'freight' item is set up to be posted to 'recoveries' not sales as it is currently doing. Has anyone else had this issue where an item/charge is being incorrectly posted to an income account it is not set to go to? 

Thank you in advance!  

Comments

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

    Hi Chelsea

     

    This is usually the result of having another (very similarly-named) Item where that one has been setup to post to “Sales”

     

    In your Item List, ensure you are viewing the complete list (Tick the checkbox at the bottom to “Include inactive”) then click on the Name column Header to sort your list alphabetically.

     

    If you have the Account column displaying in your list, you can see there where each Item is posting to.

     

    I suspect you have 2 Freight Items similarly named ….

     

    • If they are the same account Type, you can “Merge” them by right-clicking on the one to be merged & editing the name to be exactly the same as the correct one

    Or

    • You can edit the incorrectly-linked one to post to the “Recoveries” account also (RA is very smart & will ask if you want to update previous transactions so you don’t have to go back to update each one individually!)

     

    NOTE: If they are different Item types, they cannot be merged.  Service Items cannot be changed to another type but any other scan be & this can then be merged.

     

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    shazinoz2@bigpond.com

    www.accounted4bs.com

    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!)
  • Chelsea
    Chelsea Member Posts: 5
    edited January 2020
    Hi Shaz, 

    Thanks for your reply! Unfortunately we only have 1 freight item and it has always been posted to recoveries. I will try to attach a screenshot. Could there be any other reason? Should i try to edit to a different income account and then change it back to recoveries to see if it reboots it? Thanks! 


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

    Hi Chelsea

     

    Hmmm …. I have never encountered that happening.

     

    • Is it in a report that you’ve seen that it’s incorrectly posting to Sales?  Drill down (double click) on that Freight line & have a look at that particular line in that transaction.  Is it definitely the “Freight” Item & is it a current-dated transaction?

     

    • Is Recoveries an Income-type account?

    Do you have this Freight Item setup for both Sales & Purchases?

                   I am wondering if you have it posting to a COGS or expense account …?

     

    • Do you Verify your Company File regularly?  There could be a technical data glitch in the background.

                   I’d recommend running a Verify & then - even if no errors are detected - running Rebuild x 3 on    your Company File, then check for this issue again.

     

     

    Another possibility is that the Item was originally setup to post to the “Sales” account but later changed to post to “Recoveries” at which time “No” was selected at Reckon’s “ … update previous transactions …. ?” message prompt.

     

    I would suggest setting up a new Freight Item & then merging them but I see it’s a Service Item & this Item type won’t merge.

    You could try editing it to a different Income account, then back again - as you’ve suggested - & see if that refreshes it …?

     

    So failing all of the above, the only other option would be to set up a completely new Freight Item – Edit the old one’s name to “xFreight” or similar to differentiate - posting (for Sales) to the Recoveries (Income) account.

    Unfortunately, you’ll need to edit previous invoices one by one to change to the new Freight Item.

     

     

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    shazinoz2@bigpond.com

    www.accounted4bs.com


    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!)