inactive accounts showing in budget

Debra_9787839
Debra_9787839 Member Posts: 6 Novice Member Novice Member
Using Reckon Accounts Premier Edition 2018 (Desktop) (Australia)
We have recently built a budget using the Company/Planning & Budgeting feature.
Only active accounts were shown in the budget building.
When we review our budget (Reports/Budgets & Forecasts/Budget vs Actuals) inactive accounts  (accounts we have never used) report as well active accounts to which we have allocated values. 
We have set the advanced report filter  to do not display inactives. 
How do we prevent these inactives showing in the budget/actuals reporting. 
There are many of them so deleting  from the chart of accounts will be time consuming and should not be necessary since the filter should hide them.  Deleting from Excel monthly would also be painful..!!
We do not want to hide active accounts with a zero bal.
Grateful for any assistance. 
Thanks
Debra

Comments

  • Kerri_6634298
    Kerri_6634298 Member Posts: 36 Novice Member Novice Member
    edited September 2018
  • Robert Smeallie_9600650
    Robert Smeallie_9600650 Member Posts: 83 Novice Member Novice Member
    edited September 2018
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,813 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited September 2019

    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!)
  • Kerri_6634298
    Kerri_6634298 Member Posts: 36 Novice Member Novice Member
    edited September 2018
    Why I asked is because not like other software Reckon Accounts correctly reports any balances still in accounts (both P&L and balance sheet) if those accounts are required in the reports dates requested. What that means is that even if a account is made inactive but still has balance as at the date of the report it will show. 
  • Kelly Day
    Kelly Day Accredited Partner Posts: 43 Accredited Partner Accredited Partner
    edited November 2019
  • Debra_9787839
    Debra_9787839 Member Posts: 6 Novice Member Novice Member
    edited September 2018
    Hi Robert.  The accounts are inactive, but still showing in the budget/actual report.
    Thanks
    Debra

  • Debra_9787839
    Debra_9787839 Member Posts: 6 Novice Member Novice Member
    edited September 2018
    Figures I have put into the budget are showing in correct columns; but inactive accounts are showing zero.
    Thanks Debra
  • Debra_9787839
    Debra_9787839 Member Posts: 6 Novice Member Novice Member
    edited September 2018
    The inactive accounts showing have never been used.
    Thanks
    Debra
  • Debra_9787839
    Debra_9787839 Member Posts: 6 Novice Member Novice Member
    edited September 2018
  • Robert Smeallie_9600650
    Robert Smeallie_9600650 Member Posts: 83 Novice Member Novice Member
    edited March 2019
  • Debra_9787839
    Debra_9787839 Member Posts: 6 Novice Member Novice Member
    edited September 2018
    HI Robert
    What heading is that option under in preferences ??
    Thanks and regards
    Debra

  • Robert Smeallie_9600650
    Robert Smeallie_9600650 Member Posts: 83 Novice Member Novice Member
    edited September 2018
    Hi Debra

    I just looked through the Preferences area in my copy of Reckon Accounts and I couldn't find it. I might have been thinking of MYOB which I studied at TAFE and when creating my user notes for Reckon I didn't cover it. I know I saw it somewhere and if you go through the many customisations available in Reckon you might find it.

    Robert Smeallie
  • Rhodes Biloela Pty Ltd
    Rhodes Biloela Pty Ltd Member Posts: 46 Novice Member Novice Member
    edited March 2019
    In 'Chart of accounts' you can click on individual accounts and make them inactive. Here you can show or hide inactive accounts. This however doesn't mean that if relevant those accounts won't show up in your budget or in other accounting areas such as the Company Snapshot. Reckon doesn't appear to give you the option to choose which accounts you want included or not included in your overalls except perhaps in actual reports where you can modify the report and select only the items you want included in the report. 

    Depending on the accounts if might be easier to just delete the account from the system. Keep a note or screenshot somewhere perhaps if you need to if that account was relevant in the last financial year. You should still be able to do an accountants report though and see all those changes. 

    I haven't found a way around this either which is why I was hunting for any info on here. Would save me a lot of time having to delete stuff if I could customise exactly what I want. Reckon takes away a lot of the back end work and does it behind the scenes which is supposed to make using this really simple. Especially for those who do not have a lot of higher education in accounting and business principles but also makes it difficult if you want control of those things because very little is actually manual in these types of systems. 

    I think this was probably what Robert was thinking of when talking about hiding inactive accounts. You can hide it from your view of accounts but it will still show up anywhere that the system deems relevant. Maybe have a look at what the account is setup as and see if you can change that so the system thinks its something different. 
This discussion has been closed.