Version 1.27 24 April 2005
Program by Kevin S.Edwards
This program is Freeware.
It is for use on a RiscOS computer (3.5 or greater) but works well (and is supplied) with Virtual Acorn also
A basic home accounts program which allows you to keep a record of credits
and debits to a single account. Although each account is individual (eg. current account, credit card,
building society etc.), from version 1.10 these accounts can now be linked, so making an entry
in one account can be transferred to another without needing to have the second account loaded. Also, from
v 1.13 the sub-accounts facility has been greatly extended so that links between different virtual accounts
are more flexible.
Direct debits, standing orders and other transfers can be automatically entered each month. Transactions which have been checked against your bank statement can be marked to keep a "statement balance". Account records can be sorted quickly by date, details, category, credit or debit amounts.
Individual account files can be password protected so they can only be loaded if the correct password is currently in place.
Please report any problems or suggestions to
The application is being developed continuously.
Download version 1.27 (249kb)
Manual in text format (58kb) (application has full StrongHelp support throughout)
Download list of changes
For information about future developments, send a blank e-mail with Subscribe as the subject to
To run, double click on the !account2 icon or the HELP file. This will load
the program onto the iconbar. The HELP file is a fictitious account with
help text added below the transactions. This is a good way to get the feel
of the program, and I would recommend using this first. However, the main
functions and operations of account2 are as follows -
|Entering transactions in general||Entering the date of transactions|
|Entering a credit or debit||Moving around the account display|
|Adding a transaction to the statement balance||Deleting, copying and pasting transactions|
|Sorting of transactions||Automatic entry of transfers and direct debits etc.|
|Deleting entries in the direct debit table||Categories, Reports and Sub-Accounts|
|Loading and saving files||Exporting a CSV file|
|Printing the account||Importing a CSV file|
|Abbreviation tables for easy details entry||Linking accounts for transferring transactions|
|The start of a new year||Calculator|
|Search and Replace||Forecasting balance and Budgeting|
When entering transactions into the an account2 window, please remember to press
<RETURN> after each entry.
You can enter and edit transactions in either the main account window or a sub-account window. It is not a good idea to have a sub-account window open, enter a transaction into the main account window and then enter another one into the open sub-account window. Open sub-account windows are not automatically updated when a change is made in the main window, so there is a danger that you will overwrite a transaction.
The icons at the top of the main window are (from left to right)
Take care to always enter the date of each transaction (unless the posting date is the current date) so that the sorting procedure can be put to best use. There are two ways to enter the date:
The program will not let you enter a day number higher than 31, but has not been designed to trap dates such as 31st February. That's up to you!
If you enter transactions with a date which has not yet arrived (postdated), you can either choose to include these in the present balance, or wait until the transaction date arrives, when the account balance will be automatically adjusted. This is selected from the iconbar menu "Choices". The default is not to include them. You can also set an alarm to warn you (when you load an account) that a postdated entry has reached its inclusion date and the account balance has been adjusted.
The Postdate exclusion and alarm are useful for reminding yourself to pay a bill on a certain date.
The first entry will probably be a current balance of the account, and should
be entered in the credit column of row one. As you add further debits and credits
the balance of your account will alter accordingly. Entries can also be calculations
The arrow keys on the right are as follows (from top to bottom)-
Move to start of account
Move back one page
Move back one transaction
Move forward one transaction
Move forward one page
Move to end of account
This is a very useful function when checking your account against your bank statements.
As each entry is checked, mark it by clicking [ADJUST] in the Details column. The details
should now be shaded and the transaction will be added to the statement total. Delete
the mark in the same manner.
To perform any of these operations, firstly select the transaction by double-clicking
[SELECT] in the Details column. If you want to select more than one transaction, hold down
the SHIFT key and click [SELECT] over the last transaction you want to select. You can
select up to 20 rows. Most of the row will invert in colour (not the details
column because this is used as described above).
Once a selection is made, the "selected" option in the main menu becomes available and you can delete the transactions or copy them for pasting elsewhere. The paste option becomes available once a transaction has been copied. To paste the copied transactions, simply click in the details column at the point where you wish to place it, and select [MENU] >selected >paste.
The usual RiscOS conventions - Ctrl X, Ctrl C and Ctrl V allow you to perform these operations from the keyboard. A "move" option is not available, since chronological date sorting is available.
From v1.09 accounts can be sorted by category, transactions details, debits and credits as well as by date order. To do any of these, place the cursor over a blue column header (eg."Details"). The cursor will change shape to a "sort" pointer and clicking this will sort the account by the header. The SORT icon on the toolbar still sorts by date order.
This useful function means you never have to remember to enter any transaction which
occurs each week, every two weeks or up to four times each month.
Select [MENU] > Direct debits.
This brings up a table of the direct debit transfers that you have in place. To look at one in more detail or to edit one, click anywhere over the row of the one you want to edit. This will open a new window with detailed information about the transfer.
To create a new direct debit transfer, select the "Add New" icon at the top of the "Direct Debit Information" window.
I will now explain how to set up a new direct debit in the "Direct Debit set up" window.
GENERAL POINTS - In the Direct Debit Information window, the Day of Month column either shows the day of transfer of a monthly direct debit, or the first of the four if you have chosen more than one, or the frequency (7 days or 14 days) if the transfer is not monthly (this number is shown in red).
Each transaction you enter can be given a category which marks it with the transaction type
(eg. Salary, Food purchase, Insurance). You define these in [MENU] > Categories. There are 20 Master Categories
with each one having 9 sub-categories. You can define each one as you wish.
Click [OK] when you have finished entering categories
and !Account2 will then make a menu of these categories which can be used as described below.
The categories appear in the main Account2 window (3rd column), and the direct debits window as letter codes a - t, with the sub-categories shown as numbers. It is probably a good idea to pick a letter which will help you see at a glance what the category is (eg. p for petrol, c for cash withdrawal, f for food etc.)
When you have entered some categories, you can mark transactions by clicking [SELECT] in the yellow 3rd column. A menu will pop up, and simply select the category you want. The last selection in the menu ("none") deletes any category mark. You can also do this by clicking [ADJUST] over the 3rd column.
It is possible to SAVE and LOAD category data so that it can be passed from one account to another (for example, at the start of a new year or any other new account). When in the category window - [MENU] > LOAD category and SAVE category act upon the category file in "<account2$DIR>.files.category".
One purpose of defining categories is to allow you to create a report of how much you spend or earn in each category. Selecting [MENU] > Sub-account (or clicking the graph-like icon at the top of the main window) opens the report (or Sub-Account) window. There is an option to convert credits into debits (and vice-versa) so that the sub-accounts appear credited when the master account is debited.
To give you an idea of how linking transfers between sub-accounts might work (compared with linking account files) try this example. It shows how records of a credit card and current account could be linked.
Date entry can be either quick or full (as in main account window). If you click on the account name (over the Details column) the category menu is displayed and you can select a different sub-account for editing etc. Sorting, deleting and copying transactions cannot be done from the sub-account window. You need to do this from the main account window.
Existing Account2 files can be loaded by clicking on the file if the program has been "seen" by the filer, or by dragging files to an Account2 window or iconbar icon.
"Load last file saved" feature
If you intend to use one main account file throughout the year, the red Account2 "pound" icon at the top of the main window gives a quick way to load this (or whatever the last file you saved was). This is initially set to load the help file, but will change when you save a file.
To save an account, select [MENU] > save and use the submenu to enter an account name and drag the file icon to a
suitable directory. The "files" Directory in Account2 is the default directory for saving
accounts. This can be accessed easily by clicking on the filing cabinet icon at the top of
the main window, or by pressing Ctrl_A
Select [MENU] > Export. Set the choices according to the program you are exporting to.
CSV and TSV files can be loaded into Account2 by dragging them to the main window
If there is already an account loaded, the imported file will be added to the end of it. The file being loaded must have only four fields - Date, Details, Debits, Credits.
If you need to re-organise the number or order of the fields in your CSV files there is a
very useful utility available from Ray Favre at
The Date format can be any of the following -
(each number should be separated by a space, a dash or a forward slash)
Day number d or dd
Month number m or mm or the short month name (Jan Feb Mar etc.)
Year number non, y, yy or yyyy. If no year is present Account2 assumes the current year. If only 2 digits are present Account2 assumes 20th century from 40 onwards (ie. 40 gives 1940) and 21st century upto 39 (ie. 39 gives 2039).
The American date system - mm/dd/yyyy can be set as default by selecting Choices from the iconbar menu. If dd/mm/yyyy is set as default Account2 will change to mm/dd/yyyy when importing if a month number greater than 12 is encountered. You will be warned that this has happened after importing, along with the row number where the change occured. If the imported file is made up of a mixed selection of dd/mm/yyyy and mm/dd/yyyy, your on your own in sorting it out after import!
Select [Menu] >Print, click the Printer icon in the main window or press the PRINT key to print from the main account. Click the Printer icon in the sub-account window to print a sub-account. If you have a suitable
printer driver loaded this will be named in the new window.
Select the number of copies you require. If you are printing from the main account window, you also need to set "Print All" or enter the actual range of row numbers you wish to print. (Row numbers are shown next to the file name in the main window). If you are printing from a sub-account these will be ignored.
If you select "Print All", the row numbers will be ignored. If you enter a "To" number higher than the total number of rows, printing will end with the last transaction.
(It is not possible to print part of a sub-account)
From version 1.10 it is now possible to transfer transactions from the account being edited to another account by linking the two accounts together.
For example, suppose you keep a credit card account (called "card") and a current account ("current"). You decide to pay off some of your credit card transactions using funds in your current account. To record this in both accounts at once, load the "card" account into !Account2 and drag the "current" account icon (from the "files" directory) to the small window top right.
Enter the repayment into your "card" account in the normal way as a credit (since you are crediting the card account). Select the transaction you have made by double-clicking over the details column (as you would for copying, deleting etc.), and click over the name in the linking window ("current"). This will send the transaction to the "current" account file and enter it as a debit. From version 1.11, multiple transactions (up to 20) can be transferred.
If you want to send a transaction to a linked file on the same accounting side (ie. a credit is sent as a credit), open the sub-account window and switch off the "Convert Debits/Credits" option.
To break the link between account files, un-tick the box next to the linking window. The file name will disappear and the link will be broken. Just drag any !Account2 file back to this window to link it with the account you are editing.
Linking files created using a version of the program before 1.19
Before you can link any files which you have already begun on an earlier version of !Account2, you need to make sure the files have been loaded into and saved from v.1.19 (or later) at least once. This is because v.1.19 uses a slightly different file format from earlier versions.
You can create a table of abbreviations to make it easier to write details
which you enter frequently. Click on the abbreviation table icon at the top
of the main window, or select [MENU] > Abreviations. Enter your abbreviation
(eg. am) in the "Abr." column enter (up to five characters) and what it stands
for (eg. Amazon.co.uk) in the "Replace with - " column.
Click OK to store the abbreviations for the session, and SAVE to store them for future use in Account2. Then, instead of entering the full description in the DETAILS column, you only need enter the abbreviated code for the details. There is space for 40 abbreviations. These are stored in "<account2$DIR>.resources" and therefor apply to all files.
Entries to the debit and credit fields can be the result of a calculation if you wish.
To do this, make sure the cursor is in a debit or credit column, and either click [ADJUST]
over the field, or click on the calculator icon at the top of the main window. When the
calculator window opens, enter your calculation and click OK (or press RETURN).
Operators +,-,/,* and brackets can be included.
I like to start a new account each year in January. Before this current version 1.14 I have had to manually carry over transactions which have not been seen on a statement, create a new BALANCE BROUGHT FORWARD, and refresh all direct debit transfers. This was tedious. Now you can select [MENU] > New Year - and Account2 will do all this for you. Only transactions which have not been added to the statement balance will be saved, and the statement balance will be carried over as BALANCE BROUGHT FORWARD. This leaves you with the same balance. You are also asked if you wish to refresh all direct debits. Beware of any transfers which did not run from the beginning of the last year. You would presumably want this to continue without break, so if you have any transfers like this you need to reset them individually in the Direct Debit set up window.
This facility allows you to select any date before the end of the year, and get a forecast of your balance on that date (for making sure you have sufficient funds in the account etc.). It is based on either direct debit transfers and postdated entries which will have been included in your balance by the date you select, or on average daily spending. Click on the crystal ball icon (next to NEW) and enter the day and month of the forecast date. You will then get a projected balance for that date. From version 1.20 it is possible to set category budgets and be warned if you exceed the budgeted amount.
Any entry in the DETAILS field can be globally changed by selecting [MENU] >Search and replace. Enter the word, words or part word that you want to change in the find box, and its replacement in the Replace with box and click Go.
The program is freeware and can be used and copied at will, providing
that the program is not altered, and is only distributed in an official
This program is supplied "as is". No warranty, express or implied,
of the merchantability of this program or its fitness for any particular
purpose is given. In no circumstances shall the author, or any provider or
distributor of this program, be liable for any damage, loss of profits, or
any indirect or consequential loss arising out of the use of this program.
If you have any queries or suggestions about this program, please e-mail me at
New versions will be available at http://www.account2.co.uk
Thanks especially to Andrew Ayre and Ray Favre for making programming a joy(!) with Dr Wimp, and to Martin Avison for the extremely useful sorting program ArmSort used in versions from 1.09 onwards.