A couple of questions:

Hidden Columns - I previously hid some columns and am now trying to unhide them; I have tried the obvious highliting the columns on either side of the hidden column and clicking Format / Column / Unhide, but it's not working. ????

Balance Sheet Accounts - Where I have an account that I have used with several departments, the account without a department after it is being reported as though it is a roll-up account; I want it to report in the report writer as a stand alone detail account; for instance I use both #1020 and #1020-1 as separate cash accounts. The report writer is reporting account #1020-1 correctly, but in #1020 is showing the total of both #1020 and #1020-1 instead of just #1020. ???? I'm not sure if there has been a change with one of the upgrades because my reports used to work.

Thanks in advance - Sue

Hi Holiday,

1) Try selecting the entire sheet (the grey square to the left of column A and above row 1) and then Format / Column / Unhide. This will unhide all hidden columns.

If this doesn't work, then select the columns as you did before (using drag or Shift-click to select, not Ctl-click). Then resize one of the selected columns to a slightly bigger/smaller size. This will resize all columns to the same width, including any that are hidden - essentially revealing the hidden columns.

2) In the main part of the program (not within the financial reporter), you can create a new department code with a blank code - give it a description. This 'blank' department will now be selectable from the Department drop-down in the Financial Reporter and accounts without a department can be specifically selected.

What syntax are you using for your account range? I assume it is in Column B, something like 1020-` or 1020-* or 1020 or something else?

Hi Sue

You would be wise to assign a new account to 1020-1 instead of using the department segment to distinguish 1020 from 1020-1.

The driving force behind a chart of accounts is to support financial reporting. If you want your Balance Sheet to always show 1020 and 1020-1 as separate rows, then they should have different account numbers. That's what account numbers are for.

Regards

Steve

Thanks for your reply Steve. I inherited this chart of accounts (a dog's breakfast!) as the previous accountant had set it up this way under AccPac Plus(the use of departments with balance sheet accounts is much more compounded than what I explained, and there is very little room to create new accounts in logical spots). For now, I'm just trying to work around what I have been handed. Thanks anyways! Sue

Thanks, the first suggestion for unhiding didn't work (I had already tried that) but fortunately the second suggestion worked!

As for creating a new department with a blank code, I am forced to give an account to 'close to'. If I leave it on my retained earnings account, will it recognize that it is a balance sheet account and NOT close it to retained earnings?? If I could restructure my chart of accounts to work around the problem I would; however I have inherited this COA and I have very limited room to reconfigure the chart to eliminate the problems that are arising as a result.

Thanks - Sue

Hi Holiday,

As long as your balance sheet accounts are all set up correctly (ie the accounts are set to be Balance Sheet type and not Income Statement by accident), then they will not be affected by the Close Inc/Exp Accounts (Close Year) process. Close Year only looks at I/S accounts to close to retained earnings, and any B/S account that has a department will not be closed - you've probably seen this for your cash account 1020-1.