Bug in Hidden Accounts appearing in Drop-Down Lists

Hello ACCOUNTS blog readers.

I think I have discovered a bug, but I want to run it by you all before I change it. It has to do with the fact that it appears that hidden accounts are appearing on drop-down lists of accounts you can use in transactions, when they shouldn’t.

The one time that I believe hidden accounts should appear in drop-downs, is if you are editing an existing transaction, that already used that hidden account. Otherwise you wouldn’t be able to see that already-used account.

The time that it seems the program is displaying them anyways, when it shouldn’t, is when it’s a new transaction being edited (one you haven’t saved yet), but the main account you are working on (say, a bank account you are in the register window for) has ever in the past had some transaction that included that hidden account.

I can’t really see why I originally decided to program it that way, and now it appears to me that it is just annoying – you will always see hidden accounts in the drop-down account lists of a register window that ever had a transaction using that account.

The whole point, in my mind, of hidden accounts, is “this is an account I used to use, but don’t any more”. So I don’t want to see it, merely because I used it in the past in this same register!

The same probably applies to entering transactions in other windows like Write Cheques etc. – the wrong behaviour would apply if any past transaction on the bank account you were writing cheques for ever used that hidden account.

Does this make sense to you, that I should remove that behaviour, so the only time a hidden account is shown is when you are editing an existing transaction that already used it? Of course, if you need to use it again in a new transaction, for some reason, you can always go to the Chart of Accounts window, edit the account, and un-hide it.

As always, you can reply by adding a Comment on this blog post, or by direct email. Thank you.

By the way, out of interest, the way I ran into this bug was that I was doing what programmers call “eating your own dog food”, namely actually using the program in production for a real organization (a non-profit I’m involved with as Treasurer). I had some accounts that were used early last year, but that we stopped using, but they kept coming up when entering new transactions and it was annoying!

Custom Reports Ready for Testing

Hello ACCOUNTS beta testers. We have finally finished the Custom Reports feature, that I wrote to you earlier about (at https://software4nonprofitsbooks.wordpress.com/2017/03/06/accounts-custom-reporting/).

This is a pretty major feature, and the programming was pretty complex, so we would really appreciate it if as many of you as possible could give it a try and let us know what you think – especially if you run into any problems with it, incorrect results etc.!

As mentioned in that previous post, with Custom Reports you can specify a report of up to 4 columns, each of which is Income and Expenses, Budget, or a Difference between two previous columns. Each column has its own date range, either specified explicitly by you, or with a named range like “Last Month”, “Year to Date” etc., that will be recalculated every time you use the report (if you Memorize it).

You also get to specify the heading for each column in the report, the report’s title, whether it is for all funds combined or split out by fund, and the level of accounts to include (top-level etc.).

You get the beta test (pre-test) version 1.42 Beta1, that includes Custom Reports (on the Reports menu of course) from www.software4nonprofits.com/accounts/pretest.htm.

Be sure to click the Help button on the new Custom Reports window to learn all about it – though if you want to try without that, to see how self-explanatory it seems, that would be fine too!

Please reply with any testing results either with a regular Comment on this blog, or by direct email. Thank you!

Fund Income Statements by Months/Quarters

Hello ACCOUNTS beta testers and advisors.

First, can I ask again for any feedback on my recent previous post, https://software4nonprofitsbooks.wordpress.com/2017/03/06/accounts-custom-reporting/, about the design of the new Custom Reporting feature for ACCOUNTS? We’d really like to be sure we’re on the right track, and haven’t missed anything crucial, before completing the first version of that feature.

This post though is about some new reports and features of existing reports, that you can try out in version 1.41 Beta1, available from the page www.software4nonprofits.com/accounts/pretest.htm.

The new reports are Reports ⇒ Fund ⇒ Income Statement by Months and Income Statement by Quarters, that are like the same-named Reports ⇒ Summary reports, except split out by fund, with a summary section showing the change in fund balances for the entire reporting period. This is something some users had been asking for.

The improvement is that Reports ⇒ Summary ⇒ Income Statement by Months and Income Statement by Quarters both now also prompt for an “Include” setting to determine the levels of accounts and sub-accounts to be included in the report, like many other reports do, but those ones didn’t.

If you could give that a try and let us know what you think, especially including any problems you observe with those reports, it would be much appreciated. As always, you can reply with a comment on the blog, or by replying directly by email.

ACCOUNTS Custom Reporting

While we aren’t anywhere near done, we are working towards a Custom Reports option for ACCOUNTS. A draft of the window for specifying them, with a sample filled-in, looks like:

Draft ACCOUNTS Custom Reports window

As you can see, it can have from one to four columns of data in the report. Each report can be a Budget for a given date range, Income and Expenses for a given date range, or a Difference between the two previous columns. Differences must be between two Budget columns, two Income and Expenses columns, or one of each.

The report can be for all funds combined (like the existing reports under Reports -> Summary) or split out by fund (like the existing reports under Reports -> Fund).

As with many existing reports, you can set them to include All Levels of Account, Only Top-Level and Subaccounts, or Only Top-Level Accounts.

You also give it a Report Title.

The Date Ranges can be any of the following:

Last Month
Current Month to Date
Last Quarter
Current Quarter to Date
Year to Date
Year to Last Month End
Year to Last Quarter End
Last Year
Last Year to Date
Last Year to Last Month End
Last Year to Last Quarter End
Custom Date Range

The actual dates included in all of those are calculated for you, except for Custom Date Range, where you type in the dates.

If you Memorize and then replay such a report, the date ranges are re-calculated based on the current date, again except for Custom Date Range which uses the actual memorized dates. (There will be an option to redisplay the memorized Custom Report in the window above, so you can change such dates.)

There are going to be various rules about what ranges of dates are allowed for different columns, including:

  • Budget columns must have their range of dates within one fiscal year.
  • When you are showing a Difference between a Budget column and an Income and Expenses column, either the two columns must be for the exact same date range, or if the Income and Expenses is for less than a year, the Budget can be for the whole year.
  • As in the current Budget reports, partial-year budgets are calculated as appropriate fractions of the entire year’s budget.

We would appreciate any thoughts and feedback you might have about this. Is there anything we have missed that your organization might realistically want, and that isn’t already in one of the built-in reports?

As always, you can reply directly by email, or by adding a Comment on this blog post. Thank you.

New Software4Nonprofits Website

Hello ACCOUNTS beta testers and advisors. (If you also get the DONATION blog posts, please forgive this duplication!)

We have been working on updating our website to look good on any device, especially mobile devices like phones and tablets. It should have an appropriately adjusted display for those devices, so it’s not just squished pages as it is now. On your computer, it should look very much the same as before.

While we have been able to test the pages on a couple of different phones and tablets, obviously that testing is still limited. So we would like to invite you to please take a look at the draft version, which starts at www.software4nonprofits.com/NEW (the caps on “NEW” are required!) . If you can, look at it with both a regular web browser on your computer, and any devices you have. Please report any problems in the display and navigation of specific pages to us, so that we can fix them.

When reporting display and navigation problems, please include:

  • the device and the screen size (if known),
  • the problem web page,
  • and the description of the problem.

If you see any typos or anything that appears to be bad writing or factual errors, we’d also love to hear about that! (Those things probably haven’t changed from the current live website.)

Please enjoy the new experience of our website on your mobile devices. As soon as we have a reasonable number of replies, we will upload this draft to be the new official site for DONATION and ACCOUNTS at the main web address.

Thank you.

Payroll Samples for the U.S.A.

Hello ACCOUNTS advisors. This is specifically for any of you in the U.S.A. who have payrolls.

If you look in the Index of the program’s Help, there is a page “Payroll Samples”, with screen shots of Write Cheques (Write Checks for you Americans!) windows for Canada. That includes both a transaction for paying payroll cheques with appropriate deductions, and the monthly submission to the Canada Revenue Agency (equivalent to the IRS) to submit those deducted payroll taxes to them.

Could any of you please send us either screen shots or just written out samples of similar transactions for the U.S.A., so I can add them to that page? I just don’t know what exactly the right accounts would be named for your country, so I need a bit of help to get the details right.

Probably email would be best for replies about this – info@software4nonprofits.com as always.

Thank you.

One Account Details with Balances Reports

Hello ACCOUNTS advisors. A user is questioning the presence of the Starting Balance and Ending Balance figures included in Reports -> Details -> One Account Details and Balances and One Account Details and Running Balances, when you run them for income and expense accounts.

The problem is that those balances are the totals of all transactions over all years that you have been using the program, which makes a lot of sense (as being the current “balance”) for balance sheet accounts (assets, liabilities, and funds) but makes very little sense for income statement accounts (income and expenses).

The question is what exactly is the right fix, when running those reports for income statement accounts. (There will be no change for balance sheet accounts!)

One option (“Option 1”) is to just eliminate those lines for the balances entirely, when running for income statement accounts. For the Running Balances report, it would just start at $0. For the regular Balances report, it would just give a total for the selected time period at the bottom, instead of an ending balance.

Another option I considered (“Option 2”) is to have the opening balance be included, but it would just be the total in that account since the beginning of your fiscal year that includes the starting date for the report. (So if the start date was the start of a fiscal year, it would always be $0.) And the ending balance would be that starting balance plus the sum of all transactions for the dates included in the report. That makes some sense, but starts to make less sense if you run that report over a time period that includes parts of 2 or more fiscal years.

Which of these two options do you prefer?

The other problem of removing balances from these reports is that the reports’ names are then somewhat inaccurate, when run for income statement accounts, since the names say “with Balances” but we may have removed those balances! Any thoughts? Of course the report description in the Help, and in the Report Browser, could explain those differences.

Thank you in advance for your feedback.

ACCOUNTS non-numeric reference #s

Hello again ACCOUNTS advisors. I’m finally addressing an issue that someone brought up some months back, which is about entering reference numbers (also known as transaction numbers) for transactions that aren’t composed solely of digits, for instance “A1234”, for non-cheque transactions.

Currently the Register window allows such reference/transaction numbers, but warns you that if the transaction is a cheque, this will be a problem. (That message also states “you seem to be entering a cheque” regardless of what transaction type you entered, which seems clearly incorrect.)

In the Write Cheques window, however, although you can change the transaction type, only numeric reference/transaction numbers are allowed to be entered and saved. That needs to be fixed, so that other types of transactions that have non-numeric reference numbers can also be entered on that window.

So far so good. The problem comes in what do about the warning messages. I think it’s clear that if the entered transaction type is definitely for a cheque, and the transaction number is non-numeric, there should be a warning and confirmation question as there is now on the Register window. The transaction types that I’m clear indicate it’s a cheque are CHECK, CHEQUE, CHK, and CHQ. Any others? (I’m wondering about French and Spanish versions. Google Translate says the French is chèque and Spanish is cheque, so that’s pretty simple!)

Perhaps if the transaction type includes “CH” anywhere, or is empty, the warning should say something like “It appears that this might be a cheque …”.

And if the transaction type is anything else that doesn’t include “CH”, there would never be a warning about non-numeric reference/transaction numbers.

Make sense? Any other thoughts? Thanks.

ACCOUNTS Cloud Storage Technical Details

For those of you who have subscribed to the ACCOUNTS blog but not the DONATION blog, we just posted a blog for DONATION that also applies to you. It’s about the technical details of our proposed “cloud storage feature”, that we are doing rather than creating a true web-based version. If you are interested, you can read it and comment on it at:


Thank you.

Fund Balances and Asset Accounts

Hello ACCOUNTS program advisors. I’m having a discussion with a new user, who is switching to ACCOUNTS from the program Aplos. Aplos does one thing that ACCOUNTS does not do, which is track which amounts in each asset account (like a bank account or investment account) belongs to each fund. The user is having trouble seeing how he can do without that feature, seeing as how ACCOUNTS does not do that at all.

To be clear, this is a situation where the user does not have separate bank accounts for each fund. I know some of you may do that, but as I have discussed with some of you before, I see no real need for that.

My view is that in ACCOUNTS, you know two relevant things: how much total is in each asset account, and what each fund’s current (implicit) balance is. As you may recall, what we call the implicit balance is what shows up as the current fund balance on a Balance Sheet, or Fund Income Statement.

The user is concerned about having an expense that needs to come from a fund, that might exceed the amount of money in that fund in his bank account, even though there is enough in an investment amount to cover it. However, the bank account total is sufficient for the expense.

My argument is, it just doesn’t matter. In my not so humble opinion, there are only two questions to be asked (relevant to the accounting, at least) about an upcoming approved expense that will be from a specific fund. First, is there enough in that fund’s balance. Second, is there enough cash on hand in the bank.

If there’s not enough in the fund balance, you either can’t spend the money, or you put the fund into a negative balance, or you get approval for an inter-fund transfer (which may not require actually moving any money around in bank accounts, unless you keep separate bank accounts for each fund) to cover it.

If there’s not enough in the cash on hand in the bank, you need to cash in some investments (or wait for them to come due so their funds are available), get that money into the bank, and then you will have enough.

But I just can’t see how any questions of which funds’ income made up the current bank and investment account balances needs to come into this (or any other) question.

Can any of you think of anything I’m missing here, or alternatively back me up from your experience? Thank you in advance for any comments.