Navigation: REVISION HISTORY AND BUGS / FEATURES >
Revision History - Latest Version
This page lists all of the history of changes and fixes in all officially released versions of the program, starting at version 1.00.
For anyone that is interested in seeing the list of future work that we are considering doing, a read-only login to our internal project management system is available. Please contact us by email for the login information, if you would like to get access to that.
Release 2.42 (March 24, 2021):
•Added an option to the Startup Accounts window for importing your chart of accounts from QuickBooks Online, with the existing option on that window that used to be called just "QuickBooks" renamed to "QuickBooks Desktop", for clarity.
•Prevented a rare bug where if you have a recurring transaction set up for the 27th or 28th of the month, with the option to move the day forward if it's a weekend selected, and February 27th or 28th happen to be on a weekend, it could keep inserting the transaction on the same weekday of February prior to that day (the 26th or 27th) repeatedly, with no way to stop it.
•Using the Save PDF button in Reports ⇒ Summary ⇒ Income Statement by Months, and by Quarters, doesn't work quite right. Added a note in the descriptions of those two reports in the Help topic on Summary Reports, and in the Report Browser, explaining that, and what to do about it.
•Changed a lot of places in the program that accessed web pages or utilities (such as for requesting license keys) on our website, that were using insecure web pages (http://...), to instead access the same pages securely, with https://... addresses.
Release 2.41e (February 25, 2021):
•Further improvements for users of the OnDemand version who have been trying to open files from, or save files to, the C: drive, which is the OnDemand server's drive. Your local computer's C: drive shows up as J: under OnDemand, with subsequent drives like USBs showing up as K: or L:. All File Open or File Save type dialog boxes now give you warning messages if you navigate to a folder on the C: drive, telling you to use J: etc. instead, and prevent you from clicking Open or Save if you are in a folder on the C: drive.
•Message boxes that have a Help button on them now work in a more convenient way: the Help file is opened immediately, and you can switch between it and the program. Previously, you had to close the Help file that was opened, before you could resume working in the program.
Release 2.41d (February 17, 2021):
•Users of the OnDemand version who try to save files such as backups, PDFs, data exports etc. to the C: drive, which is the OnDemand server's local drive, not their own computer's local drive, are now given a message about that not being allowed, and asked to try again. (Under OnDemand, your local computer's C: drive shows up as J:, and additional local drives, like USB memory keys, show up as subsequent letters like K: etc.) There's also a message warning you about that before you try to do any database restores.
•If you start the program and your licensing file accountsl.txt is not present in the program's Data Directory, it is now automatically created, with data in it that starts a 60-day evaluation period starting on the current date. This is particularly for the OnDemand version, to make sure that new users start with an appropriate evaluation period, because their setups never have that licensing file pre-installed.
Release 2.41c (February 10, 2021):
•The Tools ⇒ Check for Updates window now has a Print button when an update is available and thus revision history is being displayed, to print that revision history.
•Made some changes in the OnDemand User Management Help page to reflect some changes to the User Management application.
•Fixed a bug when you use the Database ⇒ Find Transactions menu option, where part of a date was appearing to the right of the Amount in the window of results.
Release 2.41b (January 27, 2021):
•Some improvements to the OnDemand help topics.
•In the OnDemand Administer All Users window, user names are now forced to upper case, to match the User Management application. (Logins can still be done wit the user name in any case, though passwords have to be in the right case.)
Release 2.41 (January 20, 2021):
•When you add a first sub-account under an existing top-level account, or first sub-sub-account under an existing sub-account, the program now checks to make sure there are no memorized or recurring transactions, tax code accounts, vendor expense accounts, or bank rules using that account. If so, you are prompted to allow the program to switch those things to use the new sub-account instead. (This type of checking and adjusting had previously already been done for existing transactions, budget lines, fund accounts with associated income and expense accounts, and government form lines.)
•Added a check, as part of the Database ⇒ Validate Transactions menu option, that makes sure that none of the problems prevented by the checks mentioned in the previous bullet point are present in your database, and reports on any such problems. And the Help topic for that menu option now tells you how to fix any such problems that are found. Also, this check is automatically done the first time you upgrade to this release, to make sure you do catch any existing problems. (We believe that these problems are all very unlikely!)
•Fixed a weakness in Reports ⇒ Fund ⇒ One Fund Income Statement: if you selected to run it on a fund account that had hidden sub-accounts under it, they would not be included in the output if they actually had transactions that affected them during the selected time period, leading to incomplete results. This also fixes a bug that could give a techie error message if all of the sub-accounts under your selected fund account were hidden.
•Fixed several bugs that would cause the Database ⇒ Delete Old Data menu option to fail, initially with an error message that starts "Cannot set a filter to eliminate $0 rows in the starting Trial Balances". That is now fixed. However, for some reason that we have not yet determined, after successfully completing the processing, and telling you that it has done so, the program may immediately exit with no further message. That's OK, the action has been completed successfully and the program opens again fine after that.
Release 2.40d (January 5, 2021):
•For users of the cloud-based OnDemand Version, added a warning when they are backing up, if they choose to back up to the J: drive, which is their local C: drive. This is similar to the warnings given to other users if they back up to their C: drive, that if it dies, they could lose all of their data.
•Fixed a bug that could show just a number instead of an account name in the drop-down for the Parent account and linked Fund account in the Edit Account window, if the selected Parent or Fund account was a hidden account. Now hidden accounts are included in those drop-down lists (which was not the case before). The hidden accounts have their names in italics.
•Similarly, added the hidden accounts, with their names in italics, to the Fund drop-down lists in the Funds for Accounts window. (The same bug could happen there, with hidden accounts showing just a number instead of their name.)
•When you are saving a hidden Fund account, if it has linked Income or Expense accounts that are not hidden, you are now warned of that, and given an option to make all of them be hidden.
•Technical point mostly for our internal memory: If you chose "Run ACCOUNTS" from the last screen of the installation program, it used to run it with elevated Administrator privileges, the same way the installer itself ran. That was different from how ACCOUNTS was normally run, and could cause some unusual errors during that first run done directly from the installer. Now if you do that, ACCOUNTS is run with your normal user privileges.
•Put in a fix in the Tools ⇒ Check for Updates window, that may prevent an error message about "Error ... in destructor event of ole_web" when the program is being closed in order to run the downloaded installation program.
Release 2.40c (December 17, 2020):
•Added a couple of further places explaining about our licensing and payment rules for multiple user with multiple databases, like the existing information about that here.
•Added a check when the program starts up that it has all of the expected database permissions. There was a potential problem about that with our initial version of the instructions on the website for switching from the Remote Database version to the OnDemand version. (Those instructions have been changed to avoid the problem.)
Release 2.40b (December 15, 2020):
•Added instructions for automatic logins with the OnDemand client program to the Command Line Arguments page.
•Various additions and improvements to the OnDemand help pages.
Release 2.40 (December 14, 2020):
•This release introduces the entirely cloud-based OnDemand Version, which runs on a server, through a small remote-control client program, and does not require installation of the ACCOUNTS program itself. Like the Remote Database Version, multiple users can access the same database at the same time, each with their own login, but it is much faster than the Remote Database Version.
•Backups can now always back up to mapped network drives, and also to UNC paths (\\computername etc.), except for the Local Network Client version. Restores can now always restore from mapped network drives, and also from UNC paths.
•When you are Importing Transactions, which are usually bank deposit exports from the DONATION program, it does not work if the import file has account numbers preceding the account names. The program now explains that error more specifically.
•Fixed a failure to import Online Banking Download files from Desjardins Credit Unions in Quebec. The failure was caused because the files were missing a blank line at a place it was expected to be included. Now they will work.
•When you get errors configuring emails in Maintenance ⇒ Email Sending Configuration, the technical log file that is generated is now shown to you in a special window with a button on it that allows you to email it to us for our suggestions.
•Fixed a bug where if you are in the last field of the last row of a Register window (including the Register-like windows for Online Banking Download importing) and press Tab, you get an error message and the program crashes.
Release 2.36g (November 9, 2020):
•Added new Sort radio buttons to the Reconciliation Details window, to allow you to change the sort to be by Cheque # or Reference # and then by Date, to help you find cheques.
Release 2.36f (November 6, 2020):
•Fixed a bug in the first Reconciliation screen: the Delete Latest button almost drops off the screen, with just a top sliver of it showing, when you are reconciling liability accounts such as credit cards.
•Fixed an inappropriate error message when installing the Local Network Client version, where it would say "Could not copy file ... ACCOUNTS.DB ... Source file(s) does not exist...". (There was more text where each "..." was in that quoted message.) Clicking Cancel on that messagebox would allow the install to complete successfully.
•Fixed an error in installs of the Local Network Server version, on computers on which it had never been installed before, that could prevent the Local Network Client installs from succeeding. That error could be fixed by copying the file ACCOUNTS.DB on the Local Network Server computer, from the directory in which the program files had been installed, to the Data subdirectory of the program's Data Directory.
•All users of the Remote Database Version can now use the Maintenance ⇒ User Administration ⇒ Administer All Users menu option. However, only users who are Administrators can make changes in the window that comes up - everyone else can just see the information about the users.
•Fixed a bug that can cause an error message "Common Dialog Error: Error Number 65535" to come up when you use certain parts of the program that bring up a window for selecting a file to open, or specifying a file to save, if certain other parts of the program that also do that have been used first.
Release 2.36e (August 26, 2020):
•Fixed a bug, that in the Write Cheques window, only "CHEQUE" or "CHECK" was appearing in the Transaction Type drop-down list, rather than what it should have been - all types you have used for payments on that bank account in the last 13 months.
•Fixed two small bugs: When you drill down into a summary field in a report (such as an Income Statement) to see the details making up that summary amount, then you use the details report's Back button to come back, the paging controls (the icon buttons for First Page, Previous Page, Next Page, and Last Page) were not necessarily re-enabled or disabled properly based on whether or not the main report you returned to had multiple pages. Now they are. Similarly, if you create or change a Filter in a way that changes the report from one page to many, or vice-versa, those paging controls are now appropriately enabled or disabled. (The controls are disabled when there's only one page.)
•Made it clearer when those report paging controls are enabled by adding a solid black border around them in that case. When they are disabled (when the report is only one page) their border is grey.
•Added a Help topic on making Screenshots for tech support emails.
Release 2.36d (July 29, 2020):
•Prevent a crash when clicking OK on a Register Splits window, if you have made a change to an Amount but not tabbed out or clicked out of that field to another field before clicking OK. The error message was "Error at line 8 in of_fill_last_amount of nvo_entry_window_service." A version of this bug might also have been possible in the Write Cheques, Enter Deposits, Credit Card Charges and Enter Bill windows.
•Also prevented a problem in any of the windows in the previous point, where after adjusting some splits values, the program could put $0.00 into a blank row at the bottom, as part of its feature of automatically balancing the splits to the transaction's total. (In those cases where it put $0.00 in, it was already balanced, and should not have put anything into a blank row.) One time this could definitely happen when it should have happened is if you clicked the Adjust Total button.
Release 2.36c (July 24, 2020):
•To help prevent any future bug like the ones introduced in Release 2.36 and fixed in 2.36b, where transactions could be unbalanced, the program now checks each transaction before saving it, to make sure it is balanced, and refuses to save it if so. That way if we somehow put in such a bug in the future, it will be immediately found in our testing.
•Fixed a subtle bug that can crash the single-transaction entries windows like Write Cheques if you enter exactly the number of splits rows as are displayed in your window, and then click one of the Save buttons. (This could come up as "Error at line 18 in of_pre_save of nvo_entry_window_service ...".)
•Fixed an issue that was causing the Register Splits window to unnecessarily show a bunch of extra blank rows at the bottom, that you would have to scroll to see. (That wasn't a real problem for users, just odd.)
•Fixed a weird behaviour in the Register window, where if you resize the window to be taller, the transactions scrolled to show the first one in that account, rather than continuing to display the one you were on.
Release 2.36b (July 23, 2020):
•Fixed very serious bugs introduced in Release 2.36 to the Write Cheques, Enter Deposits, Credit Card Charges and Enter Bill windows. All of them might reverse their debits and credits (and thus whether they were viewed as being a Payment or a Deposit on a chequing account etc.) and they might also create unbalanced transactions!
If you installed Release 2.36 you MUST run Database ⇒ Validate Transactions to check for such problems. You must also review all transactions that you recently entered using one of those special-purpose data entry windows in a Register window to make sure they aren't reversed.
•Fixed both Database ⇒ Validate Transactions and Reports ⇒ Administrative ⇒ Unbalanced Transactions to catch some unbalanced ones that they were not catching before. The ones they were missing appear to be ones where all of the included splits (including the main part of the transaction) were debits, or all of them were credits.
•In the confirmations introduced in Release 2.35 for the words Fund or Funds in fund account names, also allow the user's specified entity names for "Equity / Fund (singular)" and "Equities / Funds (plural)" from the Maintenance ⇒ Entity Names window. Also, even in Release 2.35 the French word "Fonds" was also allowed.
Release 2.36 (July 19, 2020):
•Removed several named date ranges, that are unlikely to be used, from windows prompting for Date Ranges, except for reports where two date ranges can be compared (namely, other than Reports ⇒ Summary ⇒ Income Statement General Comparison, and Reports ⇒ Custom Reports). The ones that were removed from windows prompting only for one range of dates were Last Month Last Year, Last Quarter Last Year, Last Year to Date, Last Year to Last Month End and Last Year to Last Quarter End. This makes the drop-down list shorter and easier to use.
•Added a "Show Hidden Accounts" checkbox on the Maintenance ⇒ Budgets window, to determine whether or not hidden accounts are shown.
•In Reports ⇒ Listing ⇒ Annual or Monthly Budget, if a hidden account is shown (because it has a budget!), its name and number will now be in italics.
•Changed some reports that have three columns of figures from landscape mode to portrait mode, as long as there is room - which is if you have checked "Hide Account Numbers except in Chart of Accounts" in the Maintenance ⇒ Main Options window, and if you have not checked "Use A4 Paper" in the Maintenance ⇒ Organization Info window. The affected reports are Summary ⇒ Income Statement Yr/Yr Comparison, Summary ⇒ Income Statement General Comparison, Summary ⇒ Balance Sheet Comparison, Summary ⇒ Budget Comparison, and Fund ⇒ Budget Comparison.
•Added some confirmation messages about unusual account names that might indicate an error, when you are creating or editing Fund accounts in the Edit Account window:
oIf the name doesn't include "Fund", give a warning. (All of these tests are not case-sensitive, so for instance it would be fine if it includes "fund" or "FUND".)
oIf the name includes "Income", "Revenue", "Expense" or "Expenditure", give a warning. (This would likely indicate that the account really ought to be an Income or Expense account, not a Fund account!)
oIf you change the name of the original General Fund account to anything different, give a warning, pointing out the special properties of this account, which will still be the same with any different name. (Those properties are that the account cannot be deleted, it cannot have other funds under it as sub-accounts or sub-sub-accounts, and new Income and Expense accounts will default to having it as their associated Fund account.)
oIf it is a sub-account or sub-sub-account, and its Parent account's name doesn't include "Funds", and it's Parent account didn't previously have any accounts under it, give a warning. Normally a parent account with accounts under it would have a plural name.
oIf it has sub-accounts or sub-sub-accounts under it, and its name doesn't include "Funds", give a warning.
•Merged some common code in the following windows: Register Splits, Write Cheques, Enter Deposits, Credit Card Charges and Enter Bill. (This is primarily a note for us at Software4Nonprofits, but if you see any new or weird behaviour in any of these windows, please let us know!)
Release 2.35 (June 16, 2020):
•Changed most windows that prompt for a range of dates for reports to have a Date Range drop-down that you can use to select most commonly-used ranges of dates. You can select Custom Date Range on the drop-down to allow you to instead directly enter the dates, as you did in previous releases. (All Date Range options other than Custom Date Range make the actual date fields not be editable, because the Date Range option determines what the dates should be.) An explanation of the Date Range values, which were first introduced with the Custom Reports, is here.
•Made the Write Cheques, Enter Deposits, Credit Card Charges and Enter Bill windows resizable. When you resize them horizontally, the Memo field will expand to fill the space. When you resize them vertically, extra splits rows will be added to fill the space, if necessary.
•The Journal Entry and Opening Balances windows were already resizable vertically. Adjusted the way they resize to behave just as described for the other windows like Write Cheques, in the previous point.
•Added some tests to the Tools ⇒ Network Client Information menu option (which is only in the Local Network Server Version). The tests check for some of the things that would prevent the Local Network Client Version installation from working. If any of them are detected, you will be given a message and told to contact us.
•Restored the title bar at the top of the Write Cheques window, which had been accidentally removed in the last release. (Not having that title bar also prevented users from being able to move that window to a different location.)
Release 2.34 (May 28, 2020):
•Made changes to how the program determines the date of the latest transaction in the database. This date is used when deciding whether to warn you before restoring a backup (including automatically restoring via the Cloud Storage Service). The warning shows up when your current database appears to contain newer transactions than the backup database that will replace it. The changes include:
oDeleting a transaction will now be registered as an update to your database, which wasn't the case previously.
oSome changes to existing transactions in the Register, such as changing only the dollar amount, will now register as updates to your database when they previously didn't.
•Significantly redesigned the Check for Updates window, including now displaying the changes since your last update on the window itself. The program also now always prompts you to check for updates once a month, to encourage you to get the latest features and bug fixes. (Previously you could opt out of those once a month checks, with an option on that window.)
•Made the displayed part of the Memo field in the splits area wider, to allow more of it to be displayed without scrolling within the field horizontally, in the following windows: Register Splits, Enter Bills, Write Cheques, Enter Deposits, and Credit Card Charges.
•For users in countries other than Canada or the U.S.A. who checked Use A4 Paper in the Maintenance ⇒ Organization Info window, fixed a lot of reports. They were cutting off a tiny bit at the right edge, and/or printing extra blank (or almost blank) pages after each page.
Release 2.33c (April 28, 2020):
•Made a technical change that should prevent a problem that a few users were having where they were shown a log file saying that the Chilkat function UnlockBundle needed to be called.
Release 2.33b (April 24, 2020):
•Changed the default for the range of dates that Reports ⇒ Details ⇒ One Accounts Details, Reports ⇒ Details ⇒ One Account with Running Balances, and Reports ⇒ Fund ⇒ One Fund Details and Balances all prompt for. Now that default is the current fiscal year, if it is different from the calendar year, rather than the current calendar year, which it was previously. This makes them match most other reports.
•Made some improvements to both the messaging in the program, and the relevant Help topic about Gmail problems, when you are configuring email sending for a Gmail account and it doesn't work at first. Also improved the Help and the program's messaging about email configuration problems for several other email services, which either need or might need you to set up a special "application password" for use only with this program.
•Updated the Help topics for the Register Window, and for Writing Cheques, with the following information: If the Type (or Transaction Type) field is any of "CHECK", "CHEQUE", "CHÈQUE", "CHK", or "CHQ", or even just includes "CH" anywhere within it, then when you go to save a transaction, if the Number (or Chq / Ref #) field value is not just a number, you will get a warning message, to let you confirm that you have not made an error. This also implies that if the Type is not as described here, Number values that are not entirely numeric are allowed, with no warning messages to bother you!
Release 2.33 (April 9, 2020):
•Renamed two of the versions of ACCOUNTS to better describe them: the Standalone version is now called Standard, and the Web Network version is now called Remote Database. This does not affect their features in any way, just their names!
•Removed an apparently incorrect restriction (added in release 2.30) stopping the Local Network Server version from backing up to mapped network drives. The Local Network Client version still cannot write to mapped drives on the server (which is making the backups), for technical reasons. Trying to do that now gives a nice error message explaining that that doesn't work, rather than a techie error window.
•Fixed a bad bug in the Journal Entry window, where if you entered a bad date in the Date field and tabbed or clicked out of the field, or were in the Description field, left it blank, and tabbed or clicked out of the field, you would get an endless series of error messages and have to kill the program with Windows Task Manager.
•Fixed a problem that could cause incorrect error messages when installing the Local Network Client version, where the installation program could give an incorrect message about needing to upgrade the Local Network Server version first, when it had already been upgraded.
•Added a message to the installation programs, to give an error message and ask for confirmation if you were trying to install an older version on top of a newer version. However, that will only take effect if the older version being installed on top of the newer one is this version or later.
•Organization Names with leading or trailing spaces in the name can cause problems with license keys not matching properly, so we made a couple of small changes to prevent and/or fix that.
Release 2.32c (February 25, 2020):
•The Help ⇒ Email Software4Nonprofits.com menu option now gives a choice between using your default Windows email program to send the email (which is what it always did prior to this) or using a plain-text form within the program to do so.
•Changed the To Email field in the window for sending emails to arbitrary people to allow multiple semicolon-separated emails to be included in that field. That window is used for emailing backups, for emailing reports saved with the Save As button, and a few other places. For instance, "firstname.lastname@example.org;email@example.com", without the quotes, would now be a valid entry. When entries like that are used, any emails sent to the the people listed in that field will go as one email, with the To line for the email including both email addresses.
•Updated the Help topic Move the Program from One Computer to Another to include a much shorter simplified instructions section to cover the simplest cases.
•Added some messages to help catch weird situations that have happened to a few users, where their database was messed up in a way that making a backup then immediately restoring that backup would fix. (Please do not try that yourself unless we advise you to do so.)
•Changed the behaviour of picking Vendors from the Vendor, Description, Payee or "Pay to the Order of" field in the Enter Bills, Write Cheques, Credit Card Charges, and Register windows. The change is relevant when your vendors have associated default Expense Accounts and Tax Codes. Previously, if you dropped down the list and were moving your cursor through the vendors, or typing letters to select them, the first one you encountered with a default Expense Account and Tax Code would update those fields on the window, and a subsequent actual final selection would not change that. Now, those defaults from the vendors are not applied until you have moved out of the field that included the vendors to another field or another part of the window, and the values used are from the actual vendor you selected. (In all of those windows except for Enter Bills, if you select one of the descriptions that are included in the list that is not a vendor, no defaults will be applied.)
•Fixed a problem that could happen in the Journal Entry window. If the Date field was left empty (including if you entered it with the Duplicate button from the Journal Entry List window) you could get a continuing series of messages about having to enter that date, with no way to stop them.
•Restored a missing column heading, Tax Code, in the Register window.
•Improved some messaging around the automatic retrieval versus manual requesting of license keys. Also changed the Evaluation and Licensing window to normally automatically close after a successful request of a license key or of an evaluation extension.
•Each page of this Help now has a footer that tells when it was last updated. However, for technical reasons, all pages will initially show as December 13, 2019 if they have not been updated after that.
•Fixed a small bug in Reports ⇒ Fund ⇒ Budget Comparison: If you have the Main Options set to Hide Account Numbers on reports, and you run it for Only Top-Level Accounts, you get extra lines showing the top-level account numbers, which should not be there.
•Fixed problems in many summary reports: If you used the Save As button to export them to formatted Excel, some of the numbers in the first (or only) column could be missing in the resulting Excel file. The fixed reports are Reports ⇒ Listing ⇒ Annual or Monthly Budget, Reports ⇒ Summary ⇒ Balance Sheet, Reports ⇒ Summary ⇒ Balance Sheet Comparison, Reports ⇒ Summary ⇒ Income Statement, Reports ⇒ Summary ⇒ Income Statement Yr/Yr Comparison, Reports ⇒ Summary ⇒ Income Statement General Comparison, Reports ⇒ Summary ⇒ Budget Comparison, Reports ⇒ Fund ⇒ Income Statement and Reports ⇒ Fund ⇒ Budget Comparison.
•Added some additional warnings in a number of help topics about the fact that exporting reports to formatted Excel (with the Save As button) can be imperfect.
•Fixed a bug where Reports ⇒ Fund ⇒ One Fund Income Statement could crash the program if you used the Rerun button and chose different options for the 2nd run.
•Improved the wording of the email sent with Email Backups about how to restore the backup.
•Altered the Help topic on Opening Balances, and some of the messaging in that window in the program, to make it even clearer that entering them is a one-time thing, not something you update every year. (This was something that a few users misunderstood recently, leading to something that was quite hard for them to fix.)
•When you are displaying a report and click Print, the printer dialog box will have an option to select only a range of pages to print. If you do that, and when that is done, click Save PDF, previously it would automatically only save the same range of pages to your PDF file. Now it will ask you whether you want to save the same range, or all pages.
•Made a change to the installation program that should fix the very infrequent errors where the program cannot properly access 3rd-party controls installed with it, leading to error messages such as "Cannot connect to global object in ChilkatAx-9.5.0-win32.dll ...".
•Changed all budget and income statement comparison reports, and Difference columns in Custom Reports, to switch the sign of the Difference column for Expense accounts (positive becomes negative and vice versa). The effect of this is that the Difference now shows how much "better" one thing is than the other. So for instance for a Budget Comparison, for Income accounts a Difference is "better", and so positive, if the actual amount is more than the budget amount. For Expense accounts it is positive if the actual is less than the budget. Previously for Expense accounts, the Difference was positive if the actual was more than budget, which was not intuitive.
The Balance Sheet Comparison report has not been changed.
•Changed Reports ⇒ Summary ⇒ Balance Sheet Comparison to default to putting the newer year in the 1st column instead of the 2nd column, the first time you run it. (This is in accordance with common national accounting standards, and matches the change we made in release 2.22 to Reports ⇒ Summary ⇒ Income Statement Yr/Yr Comparison.) You can switch the dates if you want, and if you do, the program will remember the order that you want the dates to default to for subsequent runs of the same report.
•Fixed a bug causing error messages if you tried to save reports to formatted Excel with the Save As button.
•In the Maintenance ⇒ Organization Info window, added an option to select the A4 paper size if your country is Other (not Canada or U.S.A.).
•When running reports, your paper size will now always be set to Letter, unless A4 paper size was set in Maintenance ⇒ Organization Info in which case it will be A4. This will override any default paper size set for your printer in Windows.
•Added the function "IF" to the function selection box for complex sort expressions, and added an explanation of to that Help topic.
•Did a complete spelling and grammar check of this Help file, and made lots of small corrections.
•Fixed a bug when switching between databases with File ⇒ Open Database, which would particularly affect users of the Standalone version with the Cloud Storage Service who have multiple databases. (The program could get confused between the databases because of the bug.)
•Added back in a file that had been accidentally omitted from the significantly rewritten installation program first used by one of the earlier 2.30 releases - ACCOUNTS.DB, the empty database file used to create new databases.
•Added a missing scrollbar on the drop-down list of Funds in the Associating Accounts with Funds window. (Without that, if you had more funds than fit in the drop-down, you could only scroll between them with the up and down arrow keys.)
•In that same Associating Accounts with Funds window, added radio buttons at the top for sorting by Account or by Fund, and a Re-Sort by Fund button for sorting after making changes, when the sort is already by Fund.
•Improved the message you get on startup, if the program thinks your screen resolution may not be sufficient to show the program's main window and other windows.
•Fixed the fact that if you clicked Sort in Reports ⇒ Details ⇒ One Account Details or Reports ⇒ Details ⇒ One Account with Running Balances, you would get a warning about the report having group breaks, which might make changing the sort mess up the report. That was not actually true for that report.
•Fixed an possible small bug on the Account editing window, caused by a change we made in Release 2.30. If you created a new account there and then clicked Save and New and only then clicked See Existing Accounts, the account you just added would not show up on the list. A similar smaller problem could occur if you edited an existing account in a way that would change its sort order, then clicked those same two buttons - the existing account's sort order would not have changed appropriately.
•Fixed a bug in an internal function in the program that determined whether you were running the Local Network Client version, that could think that was the case if you were running the Web Network Version. The only place we are aware this affected is when you used the Tools ⇒ Check for Updates menu option in the Web Network Version - it would ask you an inappropriate question about whether you had first updated the Local Network Server version.
•Corrected an error if you downloaded a Web Network Version database to become a local database, with the Upload/Download ⇒ Download Web Database to Local menu option, as part of converting back to a local version such as Standalone. This version fixes that, even if the download has already been done and you have switched to Standalone.
(Technical details for our internal memory: It had failed to grant appropriate permissions to a new database stored procedure named SP_UPDATE_SEQNO, which could lead to error messages about that, and perhaps crashes of the program, likely harmless, if you were making any changes to your Chart of Accounts.)
•Updated a number of Help pages, including Multiple User Options, to reflect the fact that we are discontinuing the one simultaneous user Web Network Version option. (The five simultaneous user Web Network Version will still be available.) We are doing this because we believe that when you only need one user at a time accessing a shared database, the Standalone version with the Cloud Storage Service is a much better option than the Web Network Version, because it is much faster, and potentially cheaper.
•Made a minor revision to the Database ⇒ Validate Database menu option so that for the Web Network Version, there is not a significant delay caused by reloading the main window when the validation is finished.
•The Chart of Accounts window has a new Copy button that allows you to make a similar copy to the currently selected account, with a suggested account number that is the next reasonable choice after the number of the account being copied.
•The Enter Deposits window now allows for the entry of a Reference # for the deposit.
•When making Bill Payments, the Chq / Ref # can now be filled in with non-numeric values (reference numbers other than a cheque number).
•Various things in the maintenance of the chart of accounts have been speeded up for users of the Web Network Version. (They were never slow for any other version!)
•When recurring transactions are being inserted, there may be cases where more than one of the same transaction needs to be inserted. As an example, if it is a weekly recurrence, and you have not run ACCOUNTS for over two weeks, two or more of them will be due. Previously, only the first such transaction would be inserted when you started ACCOUNTS, and the next one would be inserted the next time you started ACCOUNTS. Now after you attempt to close the window to accept the first occurrence of that transaction that is due, the next one will be displayed, and so on until all of the transactions that are due have been processed.
•The program has never been able to successfully restore a backup from a mapped network drive. Now it has a clear error message about that, with instructions of what to do about it (copy the file to your local computer then restore it), rather than a more technical one that just says it cannot open the backup file to be restored. Also changed the previous messaging and Help file information for if you were trying to use a UNC path (like \\othercomputer\c\...) to also state that you have to copy the file to your local computer in order to restore it. The Standalone and Lite versions can actually make backups to and restore backups from network paths, so the messages preventing that have been removed for those versions.
•Fixed the fact that the Help button in the Calculator window didn't go the right help page.
•Did a significant re-write of some common program code shared between our two programs DONATION and ACCOUNTS, leading to related changes in the code that is unique to each program. This is not intended to change any program behaviour. (This note is primarily for our own memory of when this was done, since this should not affect users of the software. The technical change was to stop injecting global variables into program objects.)
•The Cloud Storage Service now requires an email address for notifications to be set on each computer running ACCOUNTS, which should be the email address of the main user ACCOUNTS on that computer. You will be prompted for it when you first use this (or a later) version, if it has not yet been set up, and it can also be set or changed in the Backup/Restore ⇒ Backup Frequency and Options window.
•Fixed an unlikely but possible crash when clicking Save and New in the Enter Deposits, Write Cheques, Enter Bills and Credit Card Charges windows, if the total amount of the transaction in the top half of the window had not been entered before the splits in the bottom half were entered.
•Fixed a problem that a few users were having in the Register where when they opened it, the first row rather than the new last empty row was highlighted.
•Added the options of assigning a default expense account and default tax code to Vendor details. If they are set up, any time you enter a payment type transaction and choose that vendor for the Payee, if the Account or Tax Code are not yet filled in, they will be copied in from the vendor defaults. That includes transactions entered on a Register window, Write Cheques, Credit Card Charges, or Enter Bills.
•Simplified the installation of the Local Network Client version of the program: you no longer have to enter the full path to the folder containing the database files. Also improved error handling on connection errors when running that version. Those improvements include now having the option to prompt for a changed Local Network Server computer name from the program itself, which could previously only be done by re-installing the Local Network Client.
•Improved the messaging if you have a memorized report that you memorized after loading a variation of the SQL for it with the Load SQL button, and then when you run the memorized report the saved SQL no longer works. (That would most likely because we have changed the definition of that built-in report in a newer release of the program.) Also improved the error messages if you are just viewing a non-memorized report and use Load SQL, and the loaded SQL doesn't work.
•Fixed a problem where the Load SQL button failed if there were any double quotes (") in the SQL.
•Added the option of creating and using monthly budgets (that can have different amounts for the same account in different months) rather than just annual budgets, which was all that was possible before. As a result of this change, Reports ⇒ Listing ⇒ Annual Budget was renamed to Annual or Monthly Budget, and it shows whichever type of budget you have defined for the selected year. All reports that include budget columns will now use the monthly figures if they have been defined, to determine the total budget amount for the selected range of dates.
•For reports that prompt for something (like a date, or range of dates) added a Rerun button to the report-viewing window, that lets you respecify those prompted-for values, and redisplay the report with your new values.
•Fixed a bug for Memorized Reports with saved Simple Filters: If the Simple Filter had two or more criteria, when you re-run the memorized report, although that filter would be applied correctly, but if you clicked the Filter button to further edit the filter, only the first line of criteria would be displayed in the Simple Filter window. Ones saved in this release or later will not have that problem.
•Adjusted the behaviour of changing the Memo field of an existing transaction on a Register window, when the change is saved. If all of the split lines (as seen in the Register Splits window) had the exact same memo as what was on the Register window before you made that change, then after the save all of them are also changed to what you changed it to on the Register window. If any of them were different, however, only the one on the Register window will be changed.
•Made the Register window a bit wider, so that the Payee/Description, Account and Memo fields could all be wider.
•Made some fixes for computers with a 2nd monitor attached:
oFor the windows that remember their last-used size and position when you next use them (including the program's main window and reports-viewing window), if you had moved the window to that 2nd monitor, it will again come up there when you next open it.
oIt takes care of the case where you last had such a window on the 2nd monitor, then unplugged that 2nd monitor from your computer and used the window again: it puts the window back onto your main screen.
oIt could still be a problem if you last had such a window on the 2nd monitor, then turned off that monitor and forgot to turn it back on. In that case, the program will still think it can put the window on that 2nd monitor, since Windows cannot detect that the monitor is attached but turned off. So the window will just appear to not come up, and the program may appear to be hanging!
•This release uses a new version of PowerBuilder, the program we use to build DONATION.
•Changed the installation program so it will no longer install on Windows XP (which Microsoft stopped regular support for in 2009) or Windows Server 2003 (which Microsoft stopped regular support for in 2010). Because of this lack of support for security fixes, we do not feel it is at all safe to continue using these versions of Windows, and in addition, some time back we started using some functions in the program that do not exist in those versions. The program can be installed on all later versions of Windows: Vista, 7, 8, 8.1, 10 or later, or Windows Server 2008 or later.
•Made the Online Banking Transaction Importing able to handle files using a newer version of the OFX specification for such files. (Previously all such files we had seen were using version 1.02 of the specification, then two different users sent us files from one bank using version 2.02 of the specification, which ACCOUNTS was rejecting because of the unexpected format.) Also handled weird data in those files which did not separate fields to go into the Payee / Description field and the Memo fields into two different fields in the import file.
•Added some extra messages in the program if you are using the Maintenance ⇒ Email Sending Configuration menu option, for handling new issues we have become aware of for configuring Apple-supplied email addresses (@me.com or @icloud.com).
•Changed the installation programs so that they don't try to put the uninstallation program in a C:\Windows\Accounts folder, which some users may not have permission to write files to.
•Replaced the somewhat technical Sort window for Reports with a new easier Sort window, that only shows fields that you are likely to sort on.
•Changed the font size of most of the text in this Help file from 10pt to 11pt, to make it easier to read on screen or if you print out topics. (On screen, you can also zoom the help text to read it more easily, by holding down Ctrl and scrolling your mouse wheel up, or pressing Ctrl with +.)
•Various small updates and improvements to the automatic configuration available for various email addresses, by using the 2nd option on the first window that comes up for the Maintenance ⇒ Email Sending Configuration menu option.
•Fixed a bad bug in full installers downloaded from the website (but not updates done with Tools ⇒ Check for Updates) that would cause errors such as "Internal error: The internal transaction ID for this transaction is not filled in."
•Fixed a bug in budget comparison reports where certain date ranges (like exactly 4 months) could cause the report to crash with a message about "Integer overflow".
•Fix the fact that the "As of date" in the report header had somehow disappeared from the Balance Sheet report.
•Fixed some issues in release 2.24 that could make it more likely for anti-virus programs to object to the installation. (In fact, there was absolutely nothing bad in it. We had just accidentally omitted what is called "code signing" that makes anti-virus programs trust installations more.)
•Replaced the rather technical Filter window for Reports with a new much easier Simple Filter window.
•Reviewed all of the field names in reports available for filtering. Changed some to be clearer, and removed some that it wouldn't make sense to filter on.
•Improved sorting in most reports to prevent a problem where you add a filter, then remove that filter, and then the report ends up out of sort order.
•Fixed filtering of all reports that can show Income Statement or Balance Sheet amounts. Filtering on the amounts in the Income part of Income Statements, or the Liability and Fund Balances part of Balance Sheets, didn't work, because the displayed amounts were not actually what the filter would be acting on (it was acting on the same number with a reversed sign - negative vs positive). Now you can filter on all displayed amounts in those reports.
•Fixed filtering of all reports that can show budget comparisons. If they were run for a part of a year rather than a whole year, you could not successfully filter on the displayed Budget column amounts, because the displayed amounts were not actually what the filter would be acting on (it was acting on the full year budget amounts). Now you can filter on the actual displayed Budget amounts.
•In the Register Splits, Enter Deposits, Write Cheques, Enter Bills, and Credit Card Charges, windows, made some minor but we think intuitive changes to how it recalculates the Amount on the last line when previous lines' Amounts are entered or changed. Also, a last line Amount is recalculated if you right-click and choose Delete Row on those windows, or if you change the total amount field's value in the windows that allow that (the ones other than Register Splits).
•Fixed Reports ⇒ Administrative ⇒ User Login History which except for the Web Network Version, was never displaying anything in the User column. Now it correctly shows the Windows username of the user who was running it.
•The following was actually changed in Release 2.22, but we failed to mention it at that time: When running Reports ⇒ Banking ⇒ Prior Reconciliation, added a checkbox for "Only include uncleared transactions up to the ending date". When running the reconciliation report as part of the actual reconciliation process, it is treated as if that checkbox was not checked, so it still includes later-dated transactions, as it did in all previous versions.
•Fixed a problem that prevented successful Web Network Version registrations from its Log In window, or if you are prompted to register as a first time user, for users that were not previously using another version.
•Fixed some potential problems printing Help topics with screen shots that could be too wide for the page.
•Improved the messaging and options for Web Network Version registrations from the program to help prevent multiple independent registrations for the same organization which could cause duplicate databases. The change also allows for additional registrations for different organizations.
•The program now detects when the current version of the licensing.dll file has not been properly updated by an update, and sends users to the DOWNLOAD page on the website to download and re-install their current version, which fixes the problem. (We are unfortunately not sure exactly why this problem is happening to a few users, but this at least gives an easy way to fix it.)
•Added a display of your Unique ID for Internet Backups on the Backup Frequency and Options window. You can click into that field and press Ctrl+C to copy it to the clipboard, for sending to a new user who might need it.
•Prevented a possible repeating error message, that you cannot get out of, in a very unusual circumstance when trying to make or restore a backup, or import a transaction file or online banking download file, if the last-used directory for that type of action was on the C: drive and cannot be found or recreated for some reason.
•Fixed a problem where non-English characters could not always be successfully saved to and retrieved from the program's settings file DONATION.INI, including if they were part of things like the last-used backup directory, or import directory.
•When exiting the program to install an update downloaded by the Tools ⇒ Check for Updates menu option, avoid some of the normal extra prompts that can come up when you exit the program, such as to backup, validate your database, even check for updates itself!
•Enhanced a number of error messages about bad date entry, to now show what the acceptable Short Date style from the Region settings in Windows Control Panel is (such as MM/DD/YYYY).
•The new Reports ⇒ Fund ⇒ One Fund Income Statement report was actually added in release 2.22, but not mentioned until now. In this release, fixed a bug in it that could cause it to break weirdly between pages, with a lot of empty space left at the bottom of one page. However, it unfortunately still sometimes does that - it depends on your exact data. It appears that this is something we cannot control in the tool we use to create reports.
•When using the Maintenance ⇒ Email Sending Configuration menu option, fixed the fact that the "Determine the setting from your default email program" option in the initial configuration window wasn't working if that default email program was a recent version (such as 16) of Outlook.
•Improved the handling and messaging in the situation where you run ACCOUNTS and it says that another instance of ACCOUNTS is already running.
•Fixed two bugs when importing online banking downloads:
oIf you edited the splits on a transaction from the importing window, when you went to save it back on that window there would be an error message about a SQL problem, ending in "Sqlda variable has zero length", which fortunately was relatively harmless.
oIf you tried to import into an account where some Payee/Description field value in an existing transaction included a double quote, the program would crash with a message that started "Error at line 79 of ue_postopen event of w_import_online_banking".
•The Cloud Storage Service is now available in ACCOUNTS. It is an improved way for users with the Standalone version of ACCOUNTS on multiple computers (not on a local network) to transfer their data between computers, using Internet backups, but without having to worry about whose turn it is to have control of the database, because it takes care of that for you. This service has been available in our other program, DONATION, since late 2015. The Web Network Version is another way of sharing access to one database. All ways of doing that are discussed, with pros and cons of each one, in the Multiple User Options help page.
•The program now prompts you to validate your database once a month, if you haven't done so in the last month. This is the same action that is done by the Database ⇒ Validate Database menu option.
•Fixed a case in the Bill List window where the Edit and Delete buttons could initially come up disabled when they should be enabled. (Normally they are enabled only if there are bills showing in the list.)
•Removed the option "Authorize ACCOUNTS" for authorizing sending emails from the program from a Gmail address. We did that because Google recently added a lot of complex criteria to allow software companies to do that, which unfortunately seemed prohibitively complicated for Software4Nonprofits to satisfy. Instead you can use the other option, "Allow less secure applications".
•Changed Reports ⇒ Summary ⇒ Income Statement Yr/Yr Comparison to put the newer year in the 1st column instead of the 2nd column. (This is in accordance with common national accounting standards.) If you want it the other way around, you can do that instead with Income Statement General Comparison.
•Changed Reports ⇒ Summary ⇒ Income Statement General Comparison to add in a Difference column, which is the difference between the amount for the newer date range and the amount for the older date range. That extra column required changing the report from being in portrait mode to landscape mode. If you want a report like this without the Difference column, and thus still in portrait mode, you can do that with a Custom Report instead.
•Changed Reports ⇒ Summary ⇒ Balance Sheet Comparison to just prompt for "Date 1" and "Date 2", rather than "Start" and "End" dates, and allows those dates to be in either order (newer first, or older first).
•Fixed two bugs in Reports ⇒ Banking ⇒ Prior Reconciliation: First, you could only see the last 5 or 6 reconciliation dates on the drop-down list. Second, if you were importing online banking downloads, imported or matched transactions that had not yet been reconciled (so they had cleared status "c" in the Register) were completely messing up the report. That has been fixed.
•Fixed a bug related to settings saved in the database: In the Tools ⇒ View Saved Settings menu option, when showing Current Database settings stored in the Database, each setting could show twice. (And the underlying problem that caused that could potentially have caused some other subtle problems with settings as well.)
•Fixed a case where a certain bank's online banking download files could not be imported, because they were not following the specification for that type of file properly. Now that particular error (a missing blank line between the headers of the file and the main body section) can be accommodated.
•A few users have been having problems requesting license keys over the Internet. This seems to be due to an internal programming change made (but not noted below) in a recent Release that should not have affected anything, but obviously did. Undid that change so it should work for everyone.
•On the Bill List, trying to delete a credit memo (a "bill" with a negative Amount) that had already been fully or partly used (to offset bills) was giving a tech error message, rather than a sensible non-techie one. That is fixed. Also, when the window is opened the first row now shows as being selected.
•If you have displayed the Report Browser once, then make some changes to memorized reports (in the Memorized Reports window, or with the Memorize button in the report-viewing window, or the SQL Select window, or the Custom Reports window), previously if you then went back to the Report Browser, and looked at the memorized reports there, they would not be changed appropriately based on what you had done. Now that is fixed.
•Fixed a problem that would allow the database filename for the database for a new organization, the name of which includes French (or other) accented characters, to include the same accented characters. That would then prevent Internet Backups from being able to be successfully restored, although they seem to be made correctly! (If you have French accents in your Organization Name, you should check the File Name field in the Maintenance ⇒ Organization Info window - if the File Name has accents in it, please contact us for assistance to make sure your Internet Backups will be able to be restored!)
•Major New Feature: Importing downloaded online banking transaction files is now supported in the program.
•Previously, if ACCOUNTS was already running, you could not start an Import of a file containing transactions (for instance, one exported from DONATION's Bank Deposits feature), or a restore of a database backup or emailed backup, by opening or double-clicking such files. Now those actions do work if ACCOUNTS is already running.
•On the Entity Names window, we removed the line for Cash Flow Statement, because the program doesn't contain a report with that name or purpose, so it's misleading to have a name for it shown there.
•Corrected the fact that Read Only users were allowed to Print Cheques. Also adjusted a few minor places in other windows that allowed editing for Read Only users.
•Removed the menu option Tools ⇒ Fix novaPDF Problems, because saving to PDF files in ACCOUNTS is no longer ever done by using the novaPDF program.
•Fixed a bug introduced in release 2.12: In Reports ⇒ Summary ⇒ Budget Comparison, a mystery number had appeared at the right of every line of data, that continued onto an otherwise blank extra page.
•Fixed a bug for the Web Network Version: The menu option Upload/Download ⇒ Download Web Database to Local was failing with an error message. (That menu option was normally only needed if you decided to switch back from the Web Network Version to another version such as Standalone.)
•Fixed a bug for the Web Network Version: If it was an Evaluation version, or your payment had expired, it could prompt you to retrieve a license key from our server, even though that version does not need and cannot use license keys.
•Fixed a bug in the initial setup of a database: If you canceled the window for specifying what accounts you want to start with, when you restarted it would not prompt for that again, but rather open up with no accounts, which would cause problems. Also seemed to solve a problem where you get to the main window after that initial setup and no accounts show, when accounts do exist.
•Fixed a bug on the main window: any accounts with only future-dated transactions in them were being omitted from the list on the right side of the window. (They will now be present, and will show a balance of $0, since those balances are always as of today's date.)
•Fixed a bug in the Journal Entry List window: it was supposed to scroll to show the latest journal entry when it opened, but it did not do so. Now it does.
•Added a scroll bar to the list of bills in the Edit Bill Payment window, to handle the unusual case where there were more bills included in that one payment than would fit in whatever size you have resized that window to.
•Fixed a bug that somehow recently appeared in the Register window: if you made changes in the empty row at the bottom of the window, then clicked into another row, or tried to close the window, without first pressing Enter to save your changes, you were not being prompted about saving those changes. (There was no such problem when editing existing transactions.)
•Fixed an obscure and unlikely bug. (This note is mostly for ourselves, as the bug is very unlikely to occur to users!) If you are running the Web Network Version and download your web database to local, then switch to a local version (likely Standalone), then re-restore the backup file that was stored as part of that download process, the program will halt with an error about not being able to execute sp_validate_connection. You subsequently cannot open the program, because it keeps getting that same error.
•When a new user with a so-far empty database was trying to start by restoring an Internet Backup from a previous user in their organization, the window that came up to prompt them for the Unique ID for Internet Backups didn't allow typing or directly pasting into the entry field for that value. (You had to use a Paste ID from Clipboard button.) Now you can directly type or paste into that field, to avoid confusion.
•Fixed a bug introduced in release 2.12: restoring backups, and the Database ⇒ Validate Database menu option, would fail with a technical error message if you upgraded from a previous release to 2.12 by using the Tools ⇒ Check for Updates menu option. Now Tools ⇒ Check for Updates is fine.
•Added drill-down capability for fields in many reports that include an Income Statement. Values in those reports for accounts that don't have sub-accounts (the ones you can post transactions to) are shown in blue and you can click on them. Clicking on them shows a detail report of the transactions included in the displayed total for that account that you clicked on. A Back button at the top-left corner of the detail report takes you back to the original report.
•The Journal Entry List window, reached via the Journal Entries quick link on the main window, or the Actions ⇒ Journal Entries menu option, now has a Duplicate button that can be used to create an editable duplicate version of an existing journal entry. That will be particularly useful for journal entry transactions that cannot be viewed on a register window, namely ones that do not include any asset, liability or fund accounts. (For journal entries that can be viewed on a register window, you can instead use the Copy and Paste or Memorized Transaction facilities there.) There is also an equivalent Duplicate button on the Journal Entry Editing window, which is enabled if you have entered that window through the Edit button on the Journal Entry List window, and have not made any changes.
•Restoring database backups is now done in a new way internally. (You should not see any difference.) With this change, users of the BitDefender anti-virus software, who have its SafeFiles module turned on, will no longer have to turn off that module to be able to successfully restore.
•A similar change was made to the Database ⇒ Validate Database menu option, doing it in a new way that should not cause problems if BitDefender anti-virus has its SafeFiles module turned on. Also, that menu option is now allowed for the Local Network Client version.
•Fixed a error introduced by release 2.10: You can now cut/copy/paste transactions between different register windows, as you could in releases prior to 2.10. Of course you can still also do it within the same register window.
•Fixed a bug when first initializing a Web Network Version, when you already had another version of ACCOUNTS on that computer, with some data in it. After uploading your local database, it would erroneously take you to a setup window that applied only to new empty databases. (Exiting and re-starting the program at that point would still, fortunately, take you to the properly uploaded database.)
•Fixed a bug introduced by release 2.10: The Delete button in the Bill List window didn't work, giving a technical error message about "DataWindow does not have UPDATE capability."
•Fixed a bug in the Tools ⇒ Check for Updates menu option, for users of the Web Network Version - in some cases it could incorrectly switch them to the Local Network Server version instead of retaining the correct Web Network Version. (Specifically, this would happen to users upgrading to release 2.10 or higher, from releases prior to that.)
•Especially for users of the 5 simultaneous user Web Network Version, made some changes that may speed up some activities that read program settings from the database. However, they also mean that if another simultaneous user changes certain settings, your program may not "see" those changes until you exit and restart it.
•Fixed a problem experienced by some users where the Save button in the Opening Balances window didn't work in some cases, so they could not be saved.
•Fixed a bug introduced by a recent version: if you edited an existing bill payment from the Bill Payment List window, and made changes, you would get an error message when you tried to Save, and the save would not be completed successfully.
•Added the Tools Menu option Explore Temp Directory, which can be helpful in some tech support situations.
•In windows with a drop-down list of Tax Codes, ones with no associated accounts are now omitted from the list, since they would have no effect.
•This version was created with a new release of the program we use to create ACCOUNTS, called PowerBuilder 2017 R3.
•Fixed a problem introduced by version 2.05 where in the Standalone version, in some places in the program (including when switching databases, or after making a database backup) you could get a message that didn't make sense, like: "You are using the Standalone version of ACCOUNTS, but your license key is not authorized for that. Rather, it is authorized for the normal Standalone version ...".
•There's some new behaviour in date fields, in addition to the existing keyboard shortcuts for them: When you enter a date field, normally its first component (before the first slash or dash) will become selected (highlighted). Pressing the left or right arrow keys or the forward slash key (/) will cycle through the three components of the date field (month, day and year, in whatever order they are displayed on your computer). That can make it easy to just change one of those components, for instance the day of the month. Once it is highlighted, just type what you want to replace it with - there's no need to delete what is there first.
•When you are setting up a new empty database for the first time, if you fill in and save the Organization Info window, then when it comes to the Options for Chart of Accounts setup window you click the Cancel button, previously that would undo what you did in the Organization Info window before exiting the program. Now it no longer undoes what you did in the Organization Info window, and thus when you start the program again, it just goes straight back to the Options for Chart of Accounts window.
•Added some text to the Chart of Accounts help topic to point out that you cannot delete the program's original General Fund, and to the Editing Accounts help topic to point out that the General Fund account cannot have sub-accounts. Also, the original General Fund account can now be identified because when you hover over its Number or Name in the Chart of Accounts window, a message to that effect will pop up.
•Made another correction to the new feature in release 4.04b where entering any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign, popped up the Calculator window. It also popped up if you typed an x or X for times, which was intended, but unfortunately it also popped up if you typed Ctrl+X or Alt+X, which was not intended, and has been corrected.
•Fixed a bug in the update installation program for the Web Network Version, when you use Tools ⇒ Check for Updates: you would get an error message like "On Post Install ... Attempt to concatenate global pwd1 (a nil value) ...". Although that message should not have come up, it did not actually indicate any problem with the update.
•Fixed a problem that could occur when registering from the program, if your Windows username included a space (like "Dan Cooperstock"), and your default web browser was not Internet Explorer or Microsoft Edge. In those cases, the registration could fail. This same problem could also affect certain other cases where the program opens web-type files that are on your local computer.
•Fixed a problem where the new automated license key retrieval could try to get a license key that was already older than the version of ACCOUNTS that you are running, which would not have been appropriate.
•Fixed a missing field (INTU_FID) in the database table for the chart of accounts that was causing error messages, though only in the Web Network Version.
•Made a correction to the new feature in release 2.04b where entering any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign, popped up the Calculator window. It should have popped up only when you had actually just typed one of those characters, but instead, it would pop up any time you typed any character at all, if one of those arithmetic operators was contained in what you had already typed.
•Made a change to data entry and editing of currency amounts: Negative amounts are now always displayed with a leading minus sign, even if your display format for negative currency values, set in Windows Control Panel's Region and Language tool, says to instead use parentheses for negative numbers. That change was required because if a number was displayed as say "(1.23)", to mean negative 1.23, and you made any change to it then moved out of the field, you would get a message saying "That is not a valid number".
•The Maintenance ⇒ User Administration ⇒ Administer All Users window for the Web Network Version now allows Administrators to reset passwords for other users, and unlock other users who have become locked out by too many unsuccessful login attempts.
•Many fields for entering currency amounts will now open a new Calculator window, if you enter any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign.
•If you are prompted to insert Recurring Transactions when you start the program, and they change any of the balances, those balances are updated on the main window when you return to it. (That sort of updating of the balances on the main window was already happening for every other window that can insert transactions.) The revision history for release 2.04 originally said this correction was included in that release, but it actually only appeared in this release.
•For users of the Standalone and Local Network versions, the software licensing has been changed. Now in most cases, if you have an Internet connection, new or updated license keys can be retrieved directly and instantly from our server, rather than having to send an email request to Software4Nonprofits and wait for a person to send you the key.
•Creation of new empty databases (for instance during an initial install of the program, or with the File ⇒ New Database menu option) is now done by copying from the empty database file ACCOUNTS.DB, rather than by doing a database restore from the database structure backup file ACCOUNTS.metadata. That should solve some problems caused by some anti-virus programs, that prevent certain writing to directories under C:\Users\Public, which is where the program's Data Directory is created.
•Changes to your Organization Name in the Maintenance ⇒ Organization Info window no longer require licensed users of the Standalone or Local Network versions to request an updated license key. Instead, the changed name will automatically be written into your license key file.
•Fixed a problem that caused a couple of techie, but harmless, error messages to appear for a new install of the Web Network Version. It happened only on computers that never had any other version installed on them, when you followed the start-up prompt to Register.
•In the Web Network Version, if you leave the program inactive - not doing anything in it - for 2 hours, you will be disconnected, so as to stop using up server resources and not block other users from using it. The best practice if you will not be using it for a while is to exit the program, and restart it when you wish to use it again.
•In the Web Network Version, if someone who is not an Administrator uses Maintenance ⇒ User Administration ⇒ Administer All Users, rather than doing nothing (which was a bug) it offers to show you who the Administrators are. (They are the ones who can really use that menu option for adding and removing users, and changing their permissions.)
•Fixed the fact that a user of the regular versions (not Web Network Version) who enters the program with a Read Only Password could see and use the Maintenance ⇒ Change Password sub-menu options.
•Any action in the program that needs Internet access now first checks that you are connected to the Internet, and if not, gives you a chance to connect and try again.
•Added a small section on getting Yahoo email accounts configured for successful email sending in the Email Sending Configuration help page.
•The installation program is now digitally signed with what is called an "Extended Validation Code Signing Certificate", which may help prevent things like Microsoft's SmartScreen Filter or Windows Defender from incorrectly objecting to downloads - which have nothing wrong with them.
•Changed both Reports ⇒ Summary ⇒ Balance Sheet and Reports ⇒ Summary ⇒ Balance Sheet Comparison to omit rows for hidden accounts with zero balances. (For the Balance Sheet Comparison, and account is only omitted if it is hidden and has a zero balance at both dates.)
•Changed Backup/Restore ⇒ Backup Database so that if you choose to back up to a USB memory key, it does the backup directly to there in one step, as long as there seems to be sufficient space on the USB. Previously it always first did the backup to the Backup subdirectory of the program's Data Directory, then copied it from there to the USB.
•For the Web Network Version, when there has never been a local database on the same computer from another version of ACCOUNTS, fixed a minor problem with the registration window.
•For the versions other than the Web Network Version, the submenu Maintenance ⇒ Change Password had somehow disappeared. It has been put back.
•The File ⇒ Open Database window now opens highlighting your current database. Also, when using that window in the Web Network Version, it no longer prompts you to log in again after opening that window, which was not needed.
•Fixed a problem with registrations done within the program, which weren't always working properly when they were forwarded to the website. Also removed a step from this process, so you no longer have to also click Submit on a web page to complete the registration, when it is started within the program.
•Fixed a bug in the Web Network Version, when it was opened by DONATION to import a Bank Deposit transaction (or opened by double-clicking on a transaction import file), it would crash with a message about a "null object reference".
•In the Web Network Version, any of the following changes will now invisibly send an email to us, to make sure we keep our contact information for your organization up to date: Changing the Organization Name in Maintenance ⇒ Organization Info, changing your name or login email address in Maintenance ⇒ User Administration ⇒ Edit Your Login, or any additions or deletions of users or changes of user access levels in Maintenance ⇒ User Administration ⇒ Administer All Users.
•There's a new option in the Maintenance ⇒ Main Options window: "Don't prompt before open Register Splits window with Ctrl+S". If that is checked, you are no longer asked whether to open that window when you press Ctrl+S in the Register window, to open the Splits window.
•Fixed a problem when installing and registering a new Web Network Version, when you already had a database from another version on the same computer: the Unique ID for your database that got sent to Software4Nonprofits in your registration was not the correct one.
•Fixed a bug introduced by release 2.01: New users in the USA choosing a sample database were getting errors loading that sample, preventing the load of the Chart of Accounts from completing.
•Improved the management of connections to the server database in the Web Network Version.
•Changed the wording of version numbers, like this 2.01c, to "Release #2.01c", to avoid confusion with how we use the same word "version" for the named versions of the program - Lite, Standalone, Local Network and Web Network Versions.
•Fixed a couple of things about Custom Reports: having a non-empty Heading (and not just spaces) is now always required, and stopped a program crash when trying to run reports that were somehow saved without a Heading for a row, which should not have been possible.
•Removed some erroneous references to "DONATION" that should have said "ACCOUNTS", on some Help pages.
•For users of the Web Network Version, if a Program Entry Password had been set in a previous version, don't still prompt for it after doing the Web Network Version login.
•Added a new version of ACCOUNTS, the Web Network Version, that is still installed on your Windows computer but has its database on a Software4Nonprofits server. See Multiple User Options for the pros and cons of using this version.
•The program is now using a newer version of the Firebird database software. This means that if you are sharing the same database between multiple users, all of the computers running ACCOUNTS must be upgraded. Otherwise, when you transfer a database from a program running the new versions of ACCOUNTS and Firebird to one running the older versions of both, the database will not be able to be restored.
•Fixed a weird bug where deleting multiple rows from the splits window for a transaction in a register, then using the Adjust Total button and saving the change, can leave you with an unbalanced transaction, because one or more of the deleted rows don't actually end up deleted. (This is the very first time anyone has ever found a way to create an unbalanced transaction in ACCOUNTS!)
•Fixed a bug, where the program somehow allowed at least one user to have Income or Expense accounts that were not associated with a Fund account, which caused their Balance Sheet to appear to be unbalanced. Now on start-up of this version, any such problem accounts are fixed, by associating them with the General Fund, and you are given a message telling you how to review those changes. In addition, all windows where you can edit accounts now force you to have a Fund selected for each Income or Expense account.
•Added the menu option Database ⇒ Validate Transactions which tells you whether you have any unbalanced transactions. Renamed Database ⇒ Validate to Database ⇒ Validate Database to better distinguish those two menu options.
•Added Reports ⇒ Administrative ⇒ Unbalanced Transactions to actually display any such unbalanced transactions so you can find them and fix them.
•All reports that show a column for budget amounts have now been adjusted to divide the budget amount by appropriate fractions of 12 if the report is for some number of full months. Previously the fraction used of the budget was always an exact count of days, divided by 365.
•Renamed the existing Network Versions of ACCOUNTS to be called the "Local Network Versions", to more clearly distinguish them from the new Web Network Version.
•Saving reports to PDF now usually uses a new facility for doing that which is built into PowerBuilder, the program we use to build ACCOUNTS, rather than the 3rd party PDF printer novaPDF that is included with ACCOUNTS.
•Changed the validation of email addresses you enter in the program to allow for the final part after the last period to be up to 18 characters long (the previous limit was 8).
•Added Reports ⇒ Administrative ⇒ User Login History, which shows all dates and times that any user logged on or off of the program, in descending date order (latest first), for any range of dates.
•Fixed a weakness where Maintenance ⇒ Entity Names would allow you to save one of its fields as just one or more spaces, instead of an actual name.
•Fixed a bug: drop-down lists of accounts, for instance in the Register or Register Splits window, could include hidden accounts when they should not have done so.
•Fixed potential problem data in Memorized Reports contents, that could allow your database to be backed up, but not restored, with the new version of the Firebird database software.
•Changed the installation program to automatically fix problems that a few users were having, where for some reason it could not overwrite files in the program's installation directory, so the install failed.
Version 2.00 (August 25, 2017):
•This version uses a newer version of PowerBuilder, the program we use to create ACCOUNTS, and as such we are giving this release a new main version number (2.00).
Version 1.42 (June 29, 2017):
•Added the Reports ⇒ Custom Reports menu option, which allows you to create custom reports with up to 4 columns, each for their own range of dates. Each column can be Income and Expenses, Budget, or a Difference between two previous columns. This now allows the creation of various reports that users have asked us for over the years that were not included as built-in reports, and that we weren't sure would be of interest to sufficient users to be added.
•Memorized Reports can now have optional Descriptions added to them, in addition to their name. The Descriptions can be added when you are memorizing them, or on the Memorized Reports window itself.
•Reports ⇒ Summary ⇒ Government Form Amounts now defaults the dates to your fiscal year start and end, if they are different from the calendar year. It also has a new option to omit $0 lines.
•In the Reports ⇒ Memorized Reports window, after running a report, and closing the window(s) doing that took you to, you return to the Memorized Reports window. (Those other windows can be the main Reports window, the SQL Select window, or the Custom Reports window.) Fixed a weakness where the information about the list of reports in the Memorized Reports window is not updated on that return. That could be necessary if you made changes and re-memorized the report in one of the windows you were taken to. Without this fix, re-running the same memorized report immediately would ignore those changes. Also, any new memorized reports with new names would not have appeared on the list in this window when you returned to it.
•Fixed a bug where if you added a Filter to any of Reports ⇒ Summary ⇒ Income Statement by Months, Reports ⇒ Summary ⇒ Income Statement by Quarters, Reports ⇒ Fund ⇒ Income Statement by Months, or Reports ⇒ Fund ⇒ Income Statement by Quarters, the filter expression wouldn't get displayed on the report. (In almost all other reports, that does happen.)
Version 1.41 (March 23, 2017):
•Added 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. See here for details.
•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.
•Changed the messages that come up if you try to backup or restore using a UNC path (such as \\computername\path\...). Previously that never (or at least almost never) worked, but you got a techie error message from the Firebird database software. Now you get a clearer message, earlier, directly from the program.
•Corrected a couple of places in this Help file where it said that Journal Entries was on the Maintenance menu - it is on the Actions menu. You can also get to it via the Journal Entries quick link on the main window.
•When saving reports to files with the Save As button, there is now an option to open reports saved as HTML in Excel, in addition to opening them in your default web browser. However, that is likely to come out worse in most cases than if you save them directly as Excel.
•Reorganized the Tools ⇒ Register Online window, splitting the fields up into groups for Organization Information, Contact Person, and Other Comments.
Version 1.40 (February 23, 2017):
•Added Reports ⇒ Summary ⇒ Income Statement General Comparison, which lists your income/revenue and expenses, consolidated across all funds, for one specified range of dates, and a second specified range of dates.
Version 1.39c (January 21, 2017):
•Sometimes the Tools ⇒ Fix novaPDF Problems menu option would not succeed because ACCOUNTS was running while the fix program was running. Now you are prompted to allow ACCOUNTS to exit prior to running the fix.
Version 1.39b (December 28, 2016):
•Fixed a crash in the program if trying to memorize a transaction with a name that is over 40 characters long.
•Fixed a crash in the Maintenance ⇒ Recurring Transactions window if you try to delete the last memorized or recurring transaction displayed on that window.
Version 1.39 (October 18, 2016):
•Added Recurring Transactions, which are memorized transactions for which a schedule has been assigned (for instance, monthly) for automatic or prompted-for insertion into the database.
•When you are memorizing transactions, you are now always prompted with a suggested memorized name (which you can of course change). For transactions previously memorized with this version 1.39 or later of ACCOUNTS, that you are re-memorizing, you are prompted to save it with the same memorized transaction name. For all others, the name it prompts you with is the Payee / Description for the transaction.
•Added the Help ⇒ Search by Topic or Keyword menu option, that actually just brings up a messagebox giving you instructions for how to do that, but also has buttons that take you either to the Help file where you can use the Index for searching, or to the How to Use Help help page for further instructions.
•Changed Help ⇒ Contents and Index so that it always opens on with the Index showing, which we believe is the most commonly helpful option. Previously it would show whichever of the Contents, Index, Search or Favorites tabs that you had last been on when you used the Help file.
Version 1.38c (August 30, 2016):
•Fixed another bug in Reports ⇒ Accountant ⇒ Trial Balance (introduced for at least one user by the fix in version 1.38) that for some dates and combinations of prior transactions could cause balances for fund accounts to be missing, and thus the whole report to not be balanced. (This only occurred if there had never been any transactions that directly affected that fund account at all, including no opening balance, but there were transactions on linked income or expense accounts.)
•In the Database ⇒ SQL Select window, more types of SQL statements (beyond the normal SELECT statement) are now allowed, with the provision of a SQL updating password from Cooperstock Software, than were previously allowed. This will allow our support people to fix certain types of rare problems in users' databases without having to have those databases sent to us by email backup, fixed here, and sent back for restoring.
Version 1.38b (August 23, 2016):
•Added a Help topic with instructions on Deleting Databases.
•When you are installing a license key or evaluation extension key, the program now removes unexpected characters (which might be invisible!) from the lines before doing anything else, to correct unusual errors in the copy and paste process of putting the key into that window.
Version 1.38 (August 18, 2016):
•There's a new option on the Maintenance ⇒ Main Options window, Drop down Account fields on entry to them, which determines whether that happens. (Previously it always happened.)
•In all windows that show transaction splits (Journal Entries, Register Splits, Write Cheques, Enter Deposits, Enter Bills, and Credit Card Charges) there is now better handling of rows with an Account selected but no amount(s) on that row. Also added the ability to right-click on a row and pick Delete Row from a popup menu, to clear that up.
•Added a new Database ⇒ Delete Old Data menu option, which deletes most transactions prior to a given fiscal year-end date (at least 2 full years in the past) and creates a new "rollup" Opening Balances transaction so that the balances at that date are the same as they were before this action.
•Corrected a bug in Reports ⇒ Accountant ⇒ Trial Balance that for some dates and combinations of prior transactions could cause balances for fund accounts to be wrong, and thus the whole report to not be balanced.
•There is a new Tools ⇒ Fix novaPDF Problems menu option, which downloads and runs a program from our website to uninstall and reinstall the novaPDF PDF printer, to fix problems that sometimes come up (for instance if you uninstall the printer driver, or delete some of its files). The program is also using a newer version of novaPDF.
•When you are installing a license key or evaluation extension key, the program now checks the lengths of the lines before doing anything else, and doesn't proceed if they are not the expected length, to watch for unusual errors in the copy and paste process of putting the key into that window.
Version 1.37b (May 26, 2016):
•Fixed a bug: The new option on the Maintenance ⇒ Main Options window that determines whether the account names for the split accounts are included on the printed cheques, or only the memos and amounts, was not working - the account names were printed however you set that option.
Version 1.37 (May 25, 2016):
•On the main window, added a Current Balance column to the accounts list on the right-hand side, showing the balance in each displayed account as of the current date.
•Printed cheques now print the splits for the transaction on the voucher parts (the 2nd and 3rd sections of the cheque page). There is a new option on the Maintenance ⇒ Main Options window that determines whether the account names for the split accounts are included with that, or only the memos and amounts.
•Fixed a bug where blank pages could be printed between cheques (or a blank page after a single cheque).
•Fixed a weird but obscure bug: If you entered a cheque through the Write Cheques window or the Register, and selected a previously entered Vendor as the Payee, then changed that to a Payee that isn't a Vendor (whether it's on the drop-down list or a new one), then when you printed that cheque, it would show the name of the Vendor as the payee on the printed cheque! This would also happen if you saved the cheque with the Payee being a Vendor, then subsequently edited it in the Register and changed the Payee to a non-vendor, and tried to print the cheque. Now that doesn't happen - it correctly shows the new Payee on the cheque.
•Fixed a bug that could allow the database to store data thinking that certain bill payments had paid $0 on one or more bills, which doesn't make sense. Such $0 payments could then not allow you to delete that bill if that payment was the only payment on it. All such existing $0 payments are removed when you first start this version.
•Removed a harmless message that should not have been there when returning from displaying the report showing your Unique ID for Internet Backups, which is displayed after you click the Setup button in the Backup/Restore ⇒ Backup Frequency and Options window, that said "Cannot activate the program's main window."
Version 1.36c (March 22, 2016):
•If you enter an incorrect password in the program (such as a Program Entry password), the message you get now includes the Organization Name from the database you are trying to access. That can be helpful if you have multiple databases, and might be putting in a password for the wrong one. It's also helpful if you forget your password and we have to give you a temporary one to get in, because it is based on the exact Organization Name, which you can then tell us.
•Fixed a bug introduced by version 1.36, if you are trying to install an evaluation extension: the program exits, after giving a message "Internal error: licensing object not passed when opening w_new_eval_date".
Version 1.36b (March 18, 2016):
•Fixed a bug introduced by version 1.36, where if you exported a Bank Deposit file from the DONATION program and allowed it to automatically launch ACCOUNTS to import that file, the program crashed with a techie error message about "Error at line 8 of uf_post_getfocus event of u_dw". (This would also happen if you double-clicked such a Bank Deposit export file, to import it into ACCOUNTS when ACCOUNTS wasn't running.)
Version 1.36 (March 15, 2016):
•Significantly sped up the loading of the Register window for accounts with a lot of transactions in them (up to 10 times faster).
•Users have been having trouble configuring email sending with Gmail in the Maintenance ⇒ Email Sending Configuration window. There are now two different solutions available in the program for that. Details are in the Help page Gmail Configuration.
•In the first Maintenance ⇒ Email Sending Configuration window, made the figuring out of the settings from an account in Microsoft Outlook work for newer versions of Outlook (Office 2016 and 2015).
•For users of the Network Versions of ACCOUNTS, enhanced the window displayed by the Tools ⇒ Network Client Information menu option in the Local Network Server version, to add buttons for Print, Open in Word, and Help.
•Made some improvements to the messaging for the unusual cases where there is something wrong with the program's licensing file, to allow you to better understand what is wrong and what to do about it. If it is necessary to re-download and install the program to fix such problems, the program will give you an option to go to the DOWNLOAD page on the website to do that.
•Improved the Help topic Restoring Backups to explain what to do if the OrganizationName part of a database backup you want to restore doesn't match the current database's filename (the File Name field in the Maintenance ⇒ Organization Info window in the program).
•Removed a harmless message that should not have been there when returning from displaying a Memorized Report, that said "Cannot activate the program's main window."
•The program now comes with a newer composite version of the 3rd-party controls that used to be separated, for sending emails (Chilkat Mail), for communication with websites (Chilkat Http) and for extracting files from compressed files (Chilkat Zip).
•Added some improvements to how the program figures out how to launch Microsoft Excel, for some users where those Microsoft programs were present on the system but not being found by ACCOUNTS.
•Some aspects of the program code have been significantly re-organized to allow us to share more code between this program and our DONATION program.
Version 1.35h (January 3, 2016):
•Fixed a problem that caused the program to hang when trying to import a chart of accounts from Simply Accounting / Sage 50 Canada, when you first create a new database.
Version 1.35g (December 29, 2015):
•Removed the menu option Help ⇒ Support Forum on the Web. We have discontinued the use of the Support Forum because so few people were using it. Please just contact us directly if you need support.
•Added comments at various places in this Help file explaining that you should not try to move your database to a 3rd-party cloud storage location like Dropbox, Google Drive, Microsoft OneDrive etc.
Version 1.35f (November 19, 2015):
•Fixed a bug: for some users, the cheque amount in numbers on cheques printed with the program could be wrong, with the currency symbol (e.g. dollar sign) missing, and no decimal places (e.g. for cents).
•Changed Tools ⇒ Register Online, and the Register page on the website, so that the field for the organization's website address allows up to 70 characters (previously 50).
Version 1.35e (November 6, 2015):
•Correctly fixed the bug that version 1.35d below claimed to fix, but didn't!
Version 1.35d (October 25, 2015):
•Fixed a bug - if you were registering for the first time with Tools ⇒ Register Online, and you hadn't previously set up an email address with Maintenance ⇒ Email Sending Configuration, the email address field would be both empty and uneditable, and you would not be able to submit the registration because the program would ask you to enter an email address!
Version 1.35c (October 21, 2015):
•Fixed a bug where if you try to install an expired license key, the error message you get states an incorrect date as being the expiry date of that license key.
Version 1.35b (October 19, 2015):
•Updated several Help topics to explain how to delete a split row in a transaction entry window (e.g. the Register Splits, Writing Cheques, Enter Deposits, Credit Card Charges, or Enter Bills windows) that was entered in error, by clearing all fields on that row. (It was already explained in the Help topic for entering Journal Entries.)
•Fixed a very unusual potential problem where in the Database ⇒ SQL Select window, if you are given a password by Cooperstock Software to allow you to do some form of data updating in that window, that password could fail to work because it had an unprintable character in it.
Version 1.35 (September 21, 2015):
•Renamed the Reports ⇒ Details ⇒ One Account Details and Balances report to be just called One Account Details, because when it is run on Income or Expense accounts, it no longer shows the starting and ending balances (totals over all time the program has been used) because those figures don't really make sense. The starting and ending balances are still there when you run the report for Asset, Liability or Fund accounts.
•Similarly, Reports ⇒ Details ⇒ One Account with Running Balances is still called that, but no longer shows a starting balance for Income or Expense accounts, and the running balance just starts at $0 for such accounts.
•In both of those reports, added a note in the footer of the report, when running them for a Fund account, explaining that the report only includes explicit transactions in the report and the balances, and excludes changes to the implicit fund balance made by linked Income and Expense accounts. If you want those to be included, use Reports ⇒ Fund ⇒ One Fund Details and Balances instead.
•Fixed a problem where certain complex numeric expressions (that aren't for currency amounts) get formatted as currency when they shouldn't, in the Database ⇒ SQL Select menu option.
•Improved the clarity of messages you can receive if you run a Network Version of ACCOUNTS but only have a license key for the Standalone version. Previously those messages referred to the fact that you were using the Firebird Server, which most users wouldn't understand - now it just refers to the Network Version of the program.
Version 1.34b (June 18, 2015):
•Made a fix in the installation program so it will work on the upcoming Microsoft Windows version 10.
•Made a fix related to the change about reference numbers made in version 1.34: now you do not get any confirmation questions in either the Register window (for payments) or the Write Cheques window, if you leave both the transaction Type and Number fields blank. We assume you know what you are doing in that case.
•All backup filenames now have a time component as well as a date component, such as OrganizationName-YYYY-MM-DD.HH.MM.SS.S4ABackup, where YYYY-MM-DD is the date the backup was made, and HH.MM.SS is the time.
•The Write Cheques window now allows the entry of non-numeric reference numbers, which might come up when entering payments with transaction types other than "CHEQUE" or "CHECK". The field for entering that number has been changed from saying "Cheque #" or "Check #" to saying "Chq / Ref #" or "Chk / Ref #".
•Fixed a weakness in the Pay Bills window: you couldn't use it to "pay" a bill for $0, composed of a bill and a credit note (a bill with a negative amount) for the same dollar amounts, or any other combination adding up to $0.
•Both Reports ⇒ Vendors and Bills ⇒ Overdue Bills Aging Summary and All Bills Aging Summary omitted to add in any credit notes (ones with negative amounts) to the displayed totals. They are now included.
•Added a menu option Maintenance ⇒ Change Password ⇒ Read Only Password, that allows you to set a Read Only Password. Entering ACCOUNTS with that password means you can view data and reports, but not enter transactions or change any data.
•Changed a number of data entry windows to prompt about saving the work if you have made changes, not saved those changes, and then close the window by using the "X" at the top right corner or Alt+F4 or a Close button. (A Cancel button will always allow you to abandon unsaved changes without prompting.)
•When you are reconciling an account, added a validation in the initial Reconciliation Summary screen so you can't enter a Statement Ending Date earlier than the date of the latest reconciliation on the account, if any. (You already couldn't actually run a reconciliation prior to that date, but you didn't get a message about that until you clicked the Reconcile button to go on to the Reconciliation Details window.)
•Fixed some problems that can happen in the installation program if you are installing into a non-standard location for the program files, or re-installing to one location when a prior install went to a different location.
•Added a section on "Creating your own Import Files" (which we do not recommend!) to the Help page on Importing Transactions. Also allowed more transaction type values when importing transactions, and allowed the import to be a CSV file (in addition to the currently allowed tab separated text file format).
•Improved the messages you receive if the program tries to send an email and is unsuccessful, to be clearer and more helpful about what the problem likely is, and how to fix it. (This applies whether you are doing so from the Test button in the Maintenance ⇒ Email Sending Configuration window, or trying to actually email a report or database backup.)
•Fixed an inconsistency between the program itself and the installation program about how they find the program's Data Directory - a couple of users were finding that the different methods used, which we thought always gave the same answer, did not do so.
•Improved the wording in the Evaluation and Licensing window (accessed via Tools ⇒ Request or Install License Key) when you are already licensed. If it tells you that your eligibility for support and upgrades has expired, and you need to pay to renew that, it makes it clear that this is "according to your most recently installed license key", which may or may not be correct. (You might have paid more recently, but just not requested, received and installed an updated license key yet.)
•Added some content to the Help page on the Data Directory, to avoid possible confusions about the Data Directory itself versus its Data subdirectory, and about the "Documents" versus "Public Documents" subdirectory under C:\Users\Public in recent versions of Windows.
•Hopefully fixed a problem that occurred very occasionally (we believe on 64-bit computers) when the installation program tried to install the novaPDF PDF printer, and it would not install, giving the message "Error 1 installing novaPDF".
•In the Bill Payment List window, changed it so that after any changes to the Vendor drop-down or that new checkbox, it scrolls to show the latest bill payment (the bottom of the list).
•Fixed a bug: when printing cheques for vendors in the Vendor List that have an apostrophe (single quote) or double quote in their name, their address would not be printed on the cheque. Note: This fix may will probably not work for previously existing transactions with quotes in the vendor name, unless you edit those transactions before you try to print them, first changing the Payee to anything else, moving out of that field, then going back and changing it back to the desired Payee.
•Fixed a bug introduced by version 1.30, where in some cases when it went to get the next cheque number it would give an error message and show number 1.
•Made some improvements to the Help page Move the Program from One Computer to Another, relevant to the changes in version 1.28.
•Changed the way the program calculates the next available cheque number (used in the Register, Write Cheques and Pay Bills windows). Now it suggests the number after the cheque number that was most recently entered for that bank account (not the one with the most recent transaction date - which is the date you enter). Also added a new Help page explaining Getting the Next Cheque Number.
•Fixed a bug in Importing Transactions, which is most commonly done for bank deposits from the DONATION program, where it would give error messages and not do the import if any of the included accounts had either an apostrophe (single quote) or a double quote in their names.
•In the Reports ⇒ Memorized Reports window, added a Delete button to delete reports that are no longer needed.
Made several changes to the Reconciliation Summary window:
•Added a Delete Latest button to allow you to completely remove the latest reconciliation done on that account, if it was done in error (for instance, for the wrong date).
•Added a test that the selected Statement Ending Date is no earlier than the Statement Ending Date of the latest reconciliation done on that account, because it does not make sense to do them out of order.
•Added a warning, if the Statement Ending Date is more than one calendar month after the Statement Ending Date of the latest reconciliation done on that account, to confirm you really want to do that. (Normally you would do the reconciliations one month at a time, but the program does allow you to do multiple months at once.)
•Added a new Maintenance ⇒ Funds for Accounts menu option (also available from a new Funds button on the Chart of Accounts window). It allows you to set the funds associated with each income and expense account, all on one window. (Previously that could only be done one income or expense account at a time, on the editing window from the Chart of Accounts.)
•Fixed a bug in the addition of storing memorized reports in the database, rather than in separate files on your hard drive, in version 1.28. That worked for new installations of ACCOUNTS, but when existing installations were updated, if you had any existing memorized reports you would get a technical error message about not being able to save them in the database.
•There appears to be a bug in the Quicken exporting of accounts, for importing into an initial chart of accounts into ACCOUNTS, where the types shown for some accounts consist of garbage characters. Previously that would stop the import - now those accounts are imported (arbitrarily) as Bank accounts, and you can fix them after the import. You are shown a file of problems in the import that includes a note about each such account.
•Corrected broken links to the four helpful blog posts explaining fund accounting from the competitor company IconCMO, in the Funds and Fund Accounting section of the Accounting Concepts help page.
•Memorized reports are now stored in the database, rather than in separate files on your hard drive, so they no longer have to be backed up and restored separately. The first time this version (or any subsequent version) is run when you have previously been using version 1.27 or earlier, all memorized reports are picked up from your hard drive and inserted into the database. If you are using ACCOUNTS on multiple computers, this is done on each computer, though only newer reports are updated when a given report is already present in the database.
•The sample charts of accounts for Canada Charity and Canada Church have had their government form lines for the T3010 form updated to include the section or schedule number as part of the form line, in the form (for instance) "SD 1234" for lines in Section D or "S6 1234" for lines in Schedule 6. Lines for both Section D and Schedule 6 (only one of which is filled in by each organization, depending on its size) are included, and a new comment has been added to Reports ⇒ Summary ⇒ Government Form Amounts, when it is run for the T3010, pointing out that only one of those groups should be used.
•The installation program for the Network Client version now has clearer instructions, and clear error messages for problems, on the screen for specifying the computer name that the Network Server version is running on, and the path where the database files are stored.
•Occasionally the program fails to start because a user has moved either the program's data directory or the "Cooperstock Software" directory above it. Now the program will give a clearer error message about this problem, with a suggestion of how to fix it.
•In all windows where you can enter a list of splits for a transaction (like the Register Splits window, Write Cheques, Enter Deposits, Journal Entries etc.) make the Account field a bit wider to show more of long account names.
•In the Edit Bill window, if you make a change to the Total Bill Amount and tab or click out of the field, in cases where you were using Sales Tax Codes and there was only one expense account, it would automatically re-calculate the splits for you when you tabbed out of the field. However, if you clicked either Save button without first moving out of the field, it would not do that, and would give you an unneeded error message about the splits not adding up to the total. That has been fixed.
•Also in the Edit Bill window, when you are editing a bill that already has a partial or total bill payment on it, you are now given a warning about that fact when you enter the window, pointing out that you need to be cautious about changing the Total Bill Amount. And if you do change that amount, in most cases (except where it was a partial payment before, and is still a partial payment after the change) it will ask you to confirm the change when you click either Save button, explaining what the effect of your change was.
•Changed the installation programs to give a message on their startup screens, saying that you may need to temporarily stop your anti-virus or security programs if you get a message about "Sharing Violation" during the install, which a few users were having.
•Reports ⇒ Summary ⇒ Income Statement, Reports ⇒ Summary ⇒ Income Statement Yr/Yr Comparison, Reports ⇒ Summary ⇒ Balance Sheet, Reports ⇒ Summary ⇒ Balance Sheet Comparison, Reports ⇒ Summary ⇒ Budget Comparison, Reports ⇒ Fund ⇒ Income Statement, Reports ⇒ Fund ⇒ Budget Comparison and Reports ⇒ Listing ⇒ Budget now all prompt for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.
•Reports created with the Database ⇒ SQL Select menu option now do a better job of making the columns only as wide as they need to be to hold the longest retrieved data, and leaving spaces between columns. This fixes problems both where some data could be cut off because columns were too narrow, and reports were unnecessarily wide because columns were too wide.
•In all windows where you can enter a list of splits for a transaction (like the Register Splits window, Write Cheques, Enter Deposits, Journal Entries etc.) made the drop-down area for the accounts wider, to show long account names in their entirety rather than in some cases cutting them off.
•Reports ⇒ Details ⇒ One Account with Running Balances was incorrectly showing the ending balance as the starting balance, and then adding up running balances from there. That has been fixed, so the starting balance is correct.
•This version was created with a newer version of PowerBuilder, the program used to create ACCOUNTS.
•Fixed a support problem, where if the program cannot find one of its 3rd party components (ChilkatHttp, ChilkatMail, or wodCrypt), a re-install of the full version did not always fix them, and further steps were required to fix the problem.
•Fixed a problem in the installation program, for re-installs, where if you need to let it delete an expired license key file (a very unusual situation) that gives an error message and the whole install ends up failing to upgrade.
•Reports ⇒ Vendors and Bills ⇒ All Bills Aging Summary was not obeying the setting for "Show Cents in Reports" in the Maintenance ⇒ Main Options window. In some cases it would show no cents, and could also in some cases in some fields show 4 decimal places. That has been corrected.
•Reports ⇒ Accountant ⇒ Audit Trail now shows the user for each transaction as being the logged-in Windows user, rather than always "Admin", for all transactions entered after you upgrade to this version.
•Fixed a bug when editing accounts: A hidden account that was a sub-account of another hidden account could not be edited, because its hidden parent account was not displayed on the "Of parent account" drop-down list. That drop-down list now includes hidden accounts, if the "Hidden" checkbox on the window is checked.
•Added a new table, USER_LOG, to the database, which tracks each user of the program (based on the Windows username they logged onto their computer with). It records the time they logged on (started) and logged off (exited) the program. You can retrieve data from it with queries in the Database ⇒ SQL Select window such as "SELECT * from USER_LOG where ACTION_DATE between '2014-01-1' and '2014-01-31 23:59:59'", to see all of the activity in January 2014.
•On Register windows, the Splits and Delete buttons now only appear on the currently selected row (if they are available for that row at all), rather than all rows for which they are available. This gives a less cluttered appearance.
•In the Print Cheques window, there is a new Adjustments button, that opens up an area that allows you to adjust the positioning of the various elements printed on the cheque, in case the cheques are not quite lining up properly on your cheque forms. (The only forms that are supported, however, are still 3-part voucher cheques with the cheque on top, designed for use in QuickBooks.)
•Added a new report, Reports ⇒ Details ⇒ One Account with Running Balances, which lists detailed transactions with running balances for one account over a range of dates.
•Added a new report, Reports ⇒ Vendors and Bills ⇒ Vendor List, which just lists each vendor's name, account number and name for cheques.
•In the Network versions, fixed a problem where if the program loses its connection to the database for some reason, it could get a large pile of error messages, one on top of another, if the user wasn't at their computer at the time, and then be hard to close. Also, it now gives an option to reconnect to the database.
•Fixed a bug in Reports ⇒ Summary ⇒ Government Form Amounts that could cause the dollar figures for some accounts to be missing or $0, when they should have been actual non-zero amounts.
•When you used the Tools ⇒ Check for Updates menu option, if for some reason the download of the upgrade file failed, the "Please Wait" window for the download would remain up after an error message, leading you to think that the download was hanging, and with no obvious way to get out of it. Now that window closes after such an error.
•Fixed a problem in the installation programs that caused exporting to formatted Excel in the Save As window when viewing reports to give an error message and fail.
•A lot of strange warning messages (one or two per line of the report!) would come up if you ran Reports ⇒ Summary ⇒ Government Form Amounts, and then clicked Save As, and did the save to Excel, with the option "Formatted Data for Display" selected. That has been fixed.
•When you used the Tools ⇒ Check for Updates menu option, many users were finding that it failed, with an incorrect message saying that they did not seem to be connected to the Internet. That is fixed by this version, however, to get this version successfully, you have to download it from the DOWNLOAD page on the website, at https://www.software4nonprofits.com/accounts/download.htm, since Check for Updates isn't working in your current version!
•Fixed a bug in the window for installing a new license key that in some cases would accept an out-of-date key and indicate it was valid.
•Prevented installation of the program in a path whose name contains a single quote character, because for some reason that prevents the program from starting properly
•Fixed a minor problem, where the progress bar in the window showing an Internet Backup uploading never changed.
•Switched to using a new version of the program that creates the installation programs, which introduces some new capabilities, but also drops support for installing ACCOUNTS on the 13-year-old version of Windows called Windows 2000.
•Fixed a bug when installing the Network Client version of the program, where if the Database Directory on the Network Server version's computer has been changed from its standard location, you may get a message about that directory not existing on the Network Client computer, and be unable to complete the install. (The database directory doesn't have to exist on the Network Client computer!)
•Changed the installation program, so that a tile for ACCOUNTS shows up on the Windows 8 "All Apps" area, and ACCOUNTS can be searched for with the Windows 8 feature for searching for applications. For earlier versions of Windows, ACCOUNTS now also shows up under Start Menu ⇒ Programs ⇒ Software4Nonprofits, as well as the Windows Desktop (where it always showed up).
•In Reports ⇒ Listing ⇒ Revenue and Expense Accounts by Fund, added the account number of the fund to the header with the name of the fund, and changed to always show account numbers (regardless of the setting about that in the Maintenance ⇒ Main Options window).
•In Reports ⇒ Details ⇒ Transaction by Account, made the Memo field much wider, so long memo values aren't as likely to be cut off.
•Added a new feature about the Memo field in the Register, Write Cheques, Enter Deposits, Enter Bills and Credit Card Charges windows. Now, when you save those transactions, if the overall Memo you entered for the transaction is filled in, any individual split lines' Memo fields that have been left blank will have the transaction's Memo copied into them. Split lines' Memo fields that you filled in specifically will not be overwritten. Previously, the Memo was actually only applied to the transaction's main account's split line (such as the register account, the bank account used for Write Cheques, etc.).
•When this version is first run, all transactions other than Journal Entries and Opening Balances transactions are updated as if the new Memo feature in the previous point had always been in effect. I.e. non-empty memos on the first splits line of transactions are copied to empty memos on subsequent splits lines.
•Added Reports ⇒ Vendors and Bills ⇒ All Bills Aging Summary, that lists summaries by vendor of all unpaid bills, with the amounts broken out by in how many days in the future or past they are due: Future over 30 days, Future 1-30 days, Current (due today), Overdue 1 - 30, Overdue 31 - 60, Overdue 61 - 90, or Overdue over 90 days.
•Added a Tools ⇒ Run Windows Calculator menu option, that starts the built-in Calculator application from Windows.
•Added a section to the Help topic on Handling Sales Taxes about "Transactions that are only Partly Taxable", to explain what to do for them.
•In the reconciliation details report (also printable after the fact with the Reports ⇒ Banking ⇒ Prior Reconciliation menu option), allowed for more characters in the Num field (which is usually a cheque number).
•Added Reports ⇒ Summary ⇒ Balance Sheet Comparison, that shows the balance sheet for two specified dates (normally defaulting to the previous fiscal year-end date, and today's date), and the difference between them.
•Added protections against accidentally entering fractional cents (for example amounts like 123.456) in any of the data-entry windows. Doing so was previously allowed (because we never thought about it!), but could not be detected, because only cents were displayed in data entry windows and reports. Entering fractional cents could cause problems including a bank reconciliation saying it was out by $-0.00! Also on your first startup of this version, any previously entered fractional cents are removed, to prevent further such problems.
•Added a small section on Voiding a Cheque to the Help topic on Register Samples.
•When the register, Write Cheques or Pay Bills windows display the next available cheque number for an account (done in the register when you press the "+" key in the Number field), it used to always use one more than the highest cheque number recorded in that account, within the 13 months prior to today's date. Now, it uses one more than the latest cheque number used in that account, within the last 13 months of transactions in the account (which could end before or after today's date, depending on the entries you have made).
•Similarly, when selecting lists of previously used transactions types and descriptions, for the drop-down lists of them in various windows, it now selects them from the last 13 months of transactions in the account (back to 13 months prior to the latest transaction date in the account) rather than from the 13 months up to today's date. (This would make a difference, for instance, if you were starting by entering your transactions from two years ago.)
•When you use Print Cheques, the To Cheque # (ending cheque number to print) is now automatically initialized to be the last cheque number in the selected bank account. You can still change that, if desired.
•When importing transactions, which are most commonly bank deposit transactions exported from the DONATION program, give a more helpful error message if the same account name is erroneously used with two different account types, for example for both the bank account and an income account.
•Fixed a problem during a re-installation, if you have configured your database to be located on a USB memory key, and the memory key containing your database has not been inserted into your computer. Now it will prompt you to do that before continuing the installation.
•On the Pay Bills window, added a small Pay button between the Outstanding Amount field and the Payment Amount field. Clicking it transfers the Outstanding Amount into the Payment Amount (as long as the Payment Amount is currently zero), to save you re-typing it. Renamed the main Pay button on the window to Pay Now.
•When printing cheques, for the version where you do not check "The Payee goes above the line for the Amount in words", moved the memo on the cheque up a bit, because it could be too close to the micro-encoded account number at the bottom of the cheque.
•Fixed a bug where if you had an account with a budget, then made another account with a budget a sub-account of that first account, the budget for that first account would continue to show up on the three reports related to budgets, causing the budget totals on those reports to be incorrect. Now when you make the second account a sub-account of the first account, the budget for the first account will be moved to be the new budget for the second account, which is now the first account's sub-account.
•The same problem occurred with Government Form Lines associated with an account, when that account was changed to be a sub-account of another account that also had Government Form Lines. They are now moved from the new parent account to the new sub-account.
•Fixed an oversight where the Maintenance ⇒ Budgets window never showed account numbers, even when "Hide Account Numbers except in Chart of Accounts" was unchecked in the Maintenance ⇒ Main Options window.
•Fixed a weird behaviour when editing accounts from the Chart of Accounts, where if you switched between an account being a sub-account and a sub-sub-account or vice-versa, and then dropped down the list of parent accounts, the accounts in that list could be in descending order by account number, rather than the normal ascending order.
•Added a new checkbox for Don't Indent Amounts in Reports in the Maintenance ⇒ Main Options window. If it is checked, all amounts in reports like the Income Statement and Balance Sheet are completely aligned vertically, rather than being indented by sub-account level if is unchecked (which is the default).
•Added a drop-down arrow to show previously used values, and autocomplete functionality (you start typing, and matching values pop up) to the Type field on register windows, and the Transaction Type field on the Write Cheques window.
•Fixed a bug introduced by version 1.13, where resizable windows (including the program's main window) were always centered on your screen, rather than located where you had moved them the last time you ran the program.
•Added Reports ⇒ Fund ⇒ One Fund Details and Balances, which shows all of the transaction details in all accounts affecting one selected fund balance over a specified date range, plus the starting and ending implicit balances in that fund.
•Added Reports ⇒ Fund ⇒ Budget Comparison, which is like Reports ⇒ Summary ⇒ Budget Comparison except that it breaks it out into one statement per fund.
•The window for entering a new bill now has Save and New and Save and Close buttons, like most other special purpose data entry windows, so that you can enter several bills in a row without exiting the window.
•When you are entering a new bill, the Bill Date is now set to the last-used transaction date from that or any other data-entry window during the current run of the program, and any date that you set as the Bill Date becomes the last-used transaction date for use in other windows.
•When you are paying a bill, or editing a prior bill payment, a Total Amount of the payment is now displayed at the bottom of the list of bills to be paid, and there is a new confirmation question to confirm you want to pay the bill for the entered total amount.
•When you are entering credit card charges, you can now enter negative amounts, which represent credits/refunds on your credit card bill.
•In any field for an account that automatically drops down its list when you enter it, pressing ESC will now pop it back up. (In most of those windows, ESC normally closes the window, and will do so again after you press ESC the first time in such a field to pop the account drop-down back up.)
•When you pop up a calendar control for a date field, previously the only way to get rid of it without making a selection was by pressing ESC. Now you can get rid of it by clicking the same popup button again, or clicking back into the date field, or in most other places on the same window.
•Fixed a bug that affected some users where you could not enter a negative Amount for a bill (representing a credit note from the vendor), because you would get a techie error message when you tried to save it. The same bug may also have caused some other strange problems in other parts of the program.
•Fixed a bug when editing an existing Bill from the Bill List window, if the Payables Account for that bill has been hidden, when the editing window was opened the Payables Account field would display "0". If you didn't change that (to select a non-hidden account), then when you tried to save it, you would get a techie error message. Now in this situation, the Payables Account field is automatically changed to show your first non-hidden Accounts Payable account from the drop-down list, so that error cannot occur.
•Fixed a bug that prevents successfully deleting a bill from the Bill List window, where it gives a message starting with "Cannot run procedure SP_DELETE_TRANSACTION".
•Fixed the fact that two totals at the bottom of Reports ⇒ Summary ⇒ Budget Comparison, and all amounts in Reports ⇒ Summary ⇒ Government Form Amounts, showed dollar signs (which aren't normally shown in reports) and didn't obey the "Show Cents in Reports" setting (if it was unchecked) in the Maintenance ⇒ Main Options window.
•Fixed a bug in Reports ⇒ Summary ⇒ Balance Sheet: if there were no explicit transactions in a fund account (not even an Opening Balance) prior to the "as of" date you specified for the report, but there were transactions on income or expense accounts linked to that fund account after that "as of" date, those later transactions were erroneously added to the fund balance, causing the balance sheet to be incorrect (and unbalanced). Only transactions on linked income or expense accounts up to the "as of" date should have been added into the fund balance.
•Added a Help page on Mortgage Samples and Building Fund.
•When you start the program, if there are bills that you have entered with Enter Bills that are due or overdue, you will now receive a message about that, and be given an option to immediately open the Pay Bills window to view them and perhaps pay them.
•Added an option in the Maintenance ⇒ Main Options window that controls whether the messages mentioned in the previous point are shown.
•When you run Reports ⇒ Summary ⇒ Budget Comparison, the program now checks that you have defined a budget for the year you are trying to run the report for, and advises you to define the budget with the Maintenance ⇒ Budgets menu option if you haven't defined it.
•Added an option when running Reports ⇒ Details ⇒ One Account Details and Balances to include or exclude the splits / counter accounts in the transaction details that it shows. (Previously it always included them.)
•When creating a new database for a new organization, in the Startup Accounts window, you are now allowed to specify that an organization in the U.S.A. is a non-profit that does submit a form 990 or 990-EZ. (Previously you had to select "No 990" if you specified that your organization was a US non-profit.)
•Added some further helpful details to the Help topic on Entering Opening Balances.
•Added a new Help page Payroll Samples, with sample payroll transactions.
•Made some changes to the program's License Agreement, and various places in both this Help file and the program's website, to clarify the following existing policies: Older versions of the program are never made available, so users whose paid support and upgrades eligibility period has expired need to pay an appropriate fee to download and re-install the current version of the program, unless they keep their own secure permanent copy of the installation program from before their upgrades eligibility period ended, which they can use instead. Also, renamed the "Full License" fee to the "Initial Purchase" fee, for clarity.
•Added Reports ⇒ Details ⇒ One Account Details and Balances, which lists all transactions affecting one selected account for a selected date range, with the details of the splits, plus starting and ending balances for that account, and a summary of the transactions in that range of dates by transaction type.
•In Reports ⇒ Fund ⇒ Income Statement, prevented a problem where using Filter multiple times (for example to select the income statement for only one fund) could make the accounts in the report show up out of order (Expenses first, then Income). Also, if account numbers are being shown (as set in Maintenance ⇒ Main Options), also show the account number for the fund in the report's header section.
•Prevented a crash if you right-click on a partial blank row in a register window, when you scroll to the bottom, if the window size is between exact numbers of rows.
•Added Reports ⇒ Listing ⇒ Annual Budget, which shows just an annual budget for a specified year, with no corresponding actual amounts.
•Fixed a minor problem where some figures in Reports ⇒ Summary ⇒ Budget Comparison were not being displayed with the correct formatting (including not obeying the "Show Cents in Reports" setting in the Maintenance ⇒ Main Options window).
•Added a Help page on Using the Database on a USB Memory Key (another way to handle having copies of the Standalone version of ACCOUNTS on multiple computers).
•Added better messages if the program's database cannot be found when you are starting the program (for example if it is on a USB memory key which you have not plugged in).
•Some users were getting a message "Unlicensed HTMLMessageBox" at the top of any message box from the program, because the program file that displayed the message boxes had not been updated by an upgrade when it should have been. The program now gives a message on startup if this unexpected situation is still a problem, with instructions to contact us for help resolving it.
•There is a new checkbox in the Maintenance ⇒ Main Options window for "Show Cents in Reports", which defaults to showing them. If you uncheck that, all reports omit the cents, and show only rounded-off full dollar amounts.
•Made a fix so that if you manually copy a database file to another file with a different filename (for example to make a 2nd independent copy of a database for some reason), that does not cause a problem when opening and using the new file. (Previously that would have caused some subtle problems.)
•Improved a few things in the appearance of the new Reports ⇒ Summary ⇒ Income Statement by Months, and Income Statement by Quarters. Also in these reports, fixed something that caused a warning message when opening the file in Excel, if you used the Save As button and saved to a formatted Excel file.
•In reports created with Database ⇒ SQL Select, if the Grid display style was chosen and there were a large number of columns, the order of the columns in the resulting report could come out completely incorrect. That has been corrected.
•Added two new reports: Reports ⇒ Summary ⇒ Income Statement by Months, and Income Statement by Quarters. Each one breaks down the income and expenses by respectively month or quarter, within a specified range of dates, and also includes a Grand Total column at the end.
•Fixed a number of issues that could cause problems when Importing Accounts from Simply Accounting, with certain organizations of accounts in your Simply Accounting chart of accounts.
•Fixed a bug in Reports ⇒ Summary ⇒ Budget Comparison: for accounts with budgets, if there were transactions in the database that were later than the selected date range for the report, they could be included in the "Actuals" totals. Also fixed a tiny bug: the calculation of the number of days for the displayed proportional budget amount, if you weren't running the report for a full year, was one day too low. (It also ignores leap years, but that will not be fixed.)
•On the Pay Bills window, if you delete the Cheque #, you are no longer prompted to confirm that that's what you want, in the case where the selected Account is a credit card account rather than a bank account.
•Added new settings in the Maintenance ⇒ Main Options window, to allow you to have the program warn you about entering transactions whose dates are too far in the past or future, or even prevent you from entering such transactions. The default, if you have not changed the settings in that window, is to warn you if a transaction is more than 31 days in the past, or the future.
•When you use the right-click menu in the register window to Copy a transaction, then when you Paste that transaction, the date field is now cleared. (That helps prevent errors where you accidentally save a pasted transaction with the same date as the one you copied, when that was not desired.) The date field is not cleared when you use Cut and then Paste.
•When you run the Government Form Amounts report, you are now first prompted for whether you would like to see the Chart of Accounts with Government Form Lines report instead, to make sure it's all correct.
•Added the hotkey Ctrl+A to bring up the Chart of Accounts window from the program's main window.
•When you are in the window for editing government form lines, added a "Flip Sign?" checkbox to deal with some unusual situations. Also, if you click the New button, now if there is only one government form defined, it is automatically selected for you in the Form field, and you are put into the Line field.
•In that same window for editing government form lines, for lines associated with a form called exactly "T2" (for incorporated Canadian non-profits), there are a number of new validation rules for the line values (which are GIFI codes), some of which will automatically check the "Flip Sign?" field for you, after giving a message explaining why.
•In Reports ⇒ Listing ⇒ Chart of Accounts with Government Form Lines, added a field for "Flip Sign?".
•Updated the sample chart of accounts for a Canadian non-profit, including adding in the connections to the T2 tax form's lines, which will apply if the non-profit is incorporated. (This will only affect new databases you create with the program after installing this version.)
•Fixed two bugs in Reports ⇒ Summary ⇒ Government Form Amounts: The amounts would likely be wrong if you were running them for dates in the past, and the page numbering at the top right was cut off.
•Added memorized transactions capabilities to the register windows, that allow you to memorize a transaction, give that a name, and then re-insert it into the same account's register window at any time in the future, selecting it by name.
•Added subtotals by payee/description to the new Reports ⇒ Details ⇒ Transactions by Payee/Description report.
•The right-click menu option Paste Transaction in the register window can now only paste onto a basically empty row at the bottom of the register. (It could previously overwrite an existing transaction, after confirmation.)
•When you are printing cheques, the memo line is now filled in with "Acct #" followed by the vendor's Account Number, if this is a cheque to a vendor that has that field filled in. Otherwise, the Memo field from the transaction is used (as it was in prior versions).
•When you are paying bills, if the bill (or first bill) being paid had a Memo on it, that memo is now correctly copied to be the memo of the transaction on the Pay from Account. That means that it might be printed as a memo on the cheque for this payment, if there is no vendor Account Number, as mentioned in the previous point. (Previously, the memo from the bill was being put as the memo on the Accounts Payable account by mistake.)
•Fixed a problem where sometimes you got an error message when you tried to save a transaction pasted by the right-click menu option Paste Transaction in the register window, after using Cut Transaction.
•Fixed an oversight where the last Payment Date used in the Pay Bills window doesn't set the default transaction date for the next transaction to be entered on any other window, during the same run of the program. (That was working on all other windows that allow you to enter a transaction, except for Enter Bills, where it does not make as much sense.)
•Fixed a problem when you open a register window, the cursor is in the Number field in the blank row at the bottom, rather than in the Date field, where it should be.
•Fixed a small problem: On the Find Transactions window, there was no scroll bar on the drop-down list for the Payee / Description field.
•Fixed a bug: If you were on a register window for a Fund account, and you deleted a transaction (for example an inter-fund transfer) the Implicit Balance at the bottom of the window wasn't updated.
•Fixed an obscure bug when editing existing accounts, that would allow you to change the Type of the account in some cases where you aren't supposed to be allowed to do so, if after getting an error message about that, you change the account's sub-account level.
•Added the Database ⇒ Delete All Transactions menu option, which users could use after entering some initial fake transactions just for testing, to remove them all so that they could really start using the program.
•Added Reports ⇒ Details ⇒ Transactions by Payee/Description, that lists all transactions over a specified range of dates, broken out by the payee or other description of the transaction.
•Added a "Name for Cheques" field when editing vendor details. If that is filled in, for cheques where the payee is that vendor, that field will be printed as the payee on the cheque, rather than the regular vendor Name field which is displayed in the transaction details in the Write Cheques or register window.
•On the register window, changed the right-click menu option Splits to be named View/Edit Splits. That menu option changes to read Edit Bill or Edit Bill Payment if the current transaction is a bill or a bill payment, and those two new options can also be done by the hotkey Ctrl+E. If you choose those new options, the transaction is opened in the regular window for editing bills or bill payments respectively.
•Also on the register window, if the current transaction is a journal entry, changed the right-click menu option View as Journal Entry to read Edit Journal Entry, which can also be done with the hotkey Ctrl+E. That version opens an editable window for editing that journal entry (instead of the regular read-only one for viewing normal transactions as journal entries).
•Similarly, on the register window, if the current transaction is your Opening Balances transaction, changed the right-click menu option View as Journal Entry to read Edit Opening Balances, which can also be done with the hotkey Ctrl+E. That version opens an editable window for editing that transaction as a journal entry (instead of the regular read-only one for viewing normal transactions as journal entries).
•On the register window, made all fields of rows for journal entries or Opening Balances transactions non-editable, except for the Number field. (While the Number field is editable, if you actually change it, you will receive an error message and your change will be undone.) This makes them behave just like bill and bill payment transactions displayed on a register window.
•Some users who had been using very early beta test versions found that a database conversion done invisibly by version 1.02 or later failed, which meant they could not open the program. This version fixes that.
•Fixed a bug: When editing an existing bill, it would change the Cheque # to the next available number in the selected bank account, rather than leaving it as is.
•Improved the options for Importing Accounts from QuickBooks and Importing Accounts from Quicken on startup, to handle cases where there are duplicate account names, possibly at different account/sub-account levels, in different accounts classes (Asset / Liability / Fund / Income / Expense). Previously problems like that would prevent an import from being completed.
•There is now a warning in the register window, if you appear to be entering a cheque on a bank account, but you have entered a Deposit amount rather than a Payment amount.
•Related to the previous point, when you use Print Cheques, bank transactions that have a value in the Number field but have a Deposit amount rather than a Payment amount will never be printed, as they are not considered to actually be cheques.
•If you start a reconciliation by using the Reconcile Account menu option from the right-click menu in a register window, and the current transaction in the register was not the empty one at the end, you are now returned to the same transaction after you finish the reconciliation. (Previously it would always go back to the empty one at the end.)
•On some computers with Intel video adaptors, the feature that causes the auto-drop-down of most Account fields could cause your screen display to flip, so it was upside down! Fixed that. (If that happens in version 1.02b, press Ctrl+Alt-UpArrow, to fix it.)
•In autocomplete fields, like the Payee / Description in a register window, fixed a bug where if the current text wasn't entirely selected (highlighted), and you added a character at the end of text, it could act as if there was no current text and show the first match to the letter you just typed.
•Found some cases where the new auto-drop-down of most Account fields, and then the sort of them alphabetically if you pressed a letter, didn't always work, and fixed them.
•The various resizable windows in the program did not have the usual expected controls on the title bar, including the "X" to close the window at the top right. Those controls are now there.
•Fixed a problem in the Sales Tax Accounts window, where if you activated the New button with the Alt+N key combination rather than clicking it with the mouse, it immediately prompted you for whether you wanted to close the window.
•Some users who had been using early beta-test versions of the program, and then tried to use the Actions ⇒ Opening Balances menu option, could receive an unhelpful error message like "Unable to retrieve transaction" and be unable to continue with that option. That has been fixed.
•Fixed a problem where the Database ⇒ Export Chart of Accounts menu option was broken, giving an error message "Unexpected subtype ID 0: Cancelling export."
•You can now search for and find transactions in ACCOUNTS, from two places - the right-click menu or Ctrl+F on register windows, or the File ⇒ Find Transactions menu option or Ctrl+F on the main window. Finding can be on any or all of the Payee / Description, Number (for example cheque or journal entry number), Memo, and Amount.
•Changed some of the behaviour of most fields for selecting an account (unless there are usually only a few options, like in the top part of the Write Cheques, Enter Deposits, Credit Card Charges or Enter Bills windows). First, the fields now drop down their lists automatically, as soon as you Tab or click into them. Second, if you press a letter, it immediately goes to the first account that starts with that letter (as it did before) but it also re-sorts the list in alphabetical order, to make it easier to see and select other accounts that start with that letter. If you press Backspace after that, or Tab out of the field, the list is returned to chart of accounts order.
•In the Enter Deposits window, when the Account drop-down is first displayed for an Account field that current has no value in it, the list is scrolled to show the first Income account for you.
•In the Write Cheques, Credit Card Charges and Enter Bills windows, when the Account drop-down is first displayed for an Account field that current has no value in it, the list is scrolled to show the first Expense account for you.
•Made the list of accounts on the main window obey the "Hide Account Numbers except in Chart of Accounts" setting on the Maintenance ⇒ Main Options window. Previously account numbers were always shown there.
•Fixed a problem in the Trial Balance report where some rows could show a real value for the Debit or Credit, with $0.00 showing in the other one of those two fields (when it should have been blank). It could also unnecessarily show rows for Fund/Equity accounts that had zero balances (with no transactions).
•Fixed problems on the Income Statement, Income Statement Yr/Yr Comparison, Balance Sheet, Budget Comparison, Fund Income Statement and Trial Balance reports. In some cases account names with no dollar amounts were displayed, that should not have been there. And in some cases parent accounts of sub-accounts that had dollar amounts, that should have been shown as a heading, were omitted. (The actual data that was there, that had dollar amounts, was both correct and complete, and the totals were correct.)
•Fixed a few small typos in account names in the sample charts of accounts. (This will only be corrected in new databases / installations using those samples, not charts of accounts in databases that have already been created.)
•Fix a problem in the reconciliation summary window, where if changing the Statement Ending Date should cause the Opening Balance to be recalculated, that didn't happen if you changed it with the popup calendar control. (It only happened if you typed in the new date and Tabbed out of the field.)
•Fixed a problem in the reconciliation details window, where if your Ending Balance entered on the summary window was a negative number, when you go to click Finish, you get a techie error message and you cannot save the reconciliation.
•Created a new Reports ⇒ Details sub-menu, and moved Reports ⇒ Accountant ⇒ Transaction Details to there (renamed to Transactions by Date).
•Added Reports ⇒ Details ⇒ Transactions by Account, which groups and subtotals the transaction details by account.
•Changed the Print Cheques option so that it will only print cheques dated within the last year. This prevents accidentally reprinting duplicates from long ago, if you have a new batch of cheques that duplicate earlier cheque numbers.
•When using the <Add New> option from Account drop-down lists in any window for entering or editing transactions, don't allow an account being added to be set to be Hidden - that doesn't make sense, and causes problems.
•Fixed an error in the Opening Balances window, that prevented the up and down arrows in the final column from showing whether each account balance or total was being increased or decreased (as in a Journal Entry transaction). Also explained this feature in the Help on Opening Balances.
•Added to the Help topics on Importing accounts from QuickBooks, Quicken and Simply Accounting, to explain why transactions cannot also be imported from them, and what to do instead. (What you do instead is start with an Opening Balances transaction in ACCOUNTS, based on reports such as a Trial Balance in your previous program.)
•Added to the Help on entering Opening Balances, to explain what to do if you have outstanding bills at your opening date that you also want to enter.
•In the Sales Tax Codes window, there is now a warning if you have set up a code with no associated accounts. Also, in the Sales Tax Accounts window, added an "<Add New>" option to the Account drop-down list, so you can add any accounts you need that were not already there.
•This was the first full official release of ACCOUNTS. It was functionally the same as the last beta test version, 0.99c.