inactive accounts showing in budget

  • 1
  • Problem
  • Updated 2 months ago
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
Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
Photo of Kerri

Kerri, Accredited Partner

  • 402 Points 250 badge 2x thumb
Are the figures showing in the actual column?

Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb
Figures I have put into the budget are showing in correct columns; but inactive accounts are showing zero.
Thanks Debra
Photo of Robert Smeallie

Robert Smeallie

  • 880 Points 500 badge 2x thumb
Hi Debra,

I think that the best time to remove inactive accounts is at end-of-year rollover and if you had no transactions involving those accounts in the new financial year you should be able to delete them or at least make them inactive so they don't appear in the reports.

Robert Smeallie
Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb
Hi Robert.  The accounts are inactive, but still showing in the budget/actual report.
Thanks
Debra
Hi Debra

In the report, click on "Modify Report" (top left) then click on the "Advanced" button in the "Display" tab.  This opens the "Advanced Options" & allows you to select to display both Rows & Columns that are:
* Active
* All
* Non-zero

There is also a checkbox below to "Show only rows & columns with budgets" 

Don't forget to "OK" out of each window to save any changes you make.
(Edited)
Photo of Kerri

Kerri, Accredited Partner

  • 402 Points 250 badge 2x thumb
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. 
Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb
The inactive accounts showing have never been used.
Thanks
Debra
Photo of Kelly Day, Accredited Partner

Kelly Day, Accredited Partner, Accredited Partner

  • 2,034 Points 2k badge 2x thumb
Another filter to try is:
Modify report
Filter by Amount
Amount > .01
As Kerri says, if there is nil balance associated with the inactive accounts, then this should remove any other 0.00 balance accounts for the date range

Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb
We want "active" accounts with a zero balance to show in the budget reporting.
I guess I could put .01c in every zero active account's budget and then filter by >.01.
However, the advanced filter should do as is says and eliminate view of inactive accounts..
Thanks all for comments.
Debra
Photo of Robert Smeallie

Robert Smeallie

  • 880 Points 500 badge 2x thumb
Debra

There is a setting in Reckon Accounts under Preferences where you can either show or hide Inactive Accounts.

Robert Smeallie
Photo of Debra

Debra

  • 122 Points 100 badge 2x thumb
HI Robert
What heading is that option under in preferences ??
Thanks and regards
Debra
Photo of Robert Smeallie

Robert Smeallie

  • 880 Points 500 badge 2x thumb
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