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.

What people have said about Account2


To report any problems please Contact me


Account Download version 1.27 (249kb)

TxtManual in text format (58kb) (application has full StrongHelp support throughout)

TxtDownload list of changes  


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


1) Entering transactions in general

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)


2) Entering the date of transactions

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!

2a) Postdated entries

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.


3) Entering a credit or debit

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


4) Moving around the account display

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


5) Adding a transaction to the statement balance

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.


6) Deleting, copying and pasting transactions

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.


6a) Copying transactions to a different account.

Although it is possible to tranfer transactions to another account by linking accounts, if you have finished editing the account in memory, you can also do this by
  1. selecting the rows to transfer
  2. copying them with [MENU] >Selected >Copy (or Ctrl_C)
  3. loading the other account
  4. pasting with [MENU] >Selected >Paste (or Ctrl_V)


7) Sorting of transactions

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.


8) Automatic entry of transfers and direct debits etc

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.

Editing a transfer is pretty much like creating one, except that you are only able to alter the details, amount and categories. If you want to alter the frequency or start or end dates of the transfer, it will be necessary to create a new one and delete the old one.

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).


9) Categories, Reports and Sub-accounts

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.


!Account2 started life as a single account facility, which was all I required of it. Feedback from users has shown that they would like to be able to make linked tranfers between different accounts, and I have tried to implement this option in a couple of different ways. One way from v 1.10 is by linking accounts ie. separate files which can pass data to each other. However, from v.1.13 the flexibility of the sub-account usage is much improved, almost to the point where you could treat sub-accounts as seperate accounts under a common master account. Which system you use would depend on your preference and needs. Try out both systems and see.

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.

  1. Start up Account2
  2. In the Sub-account window switch off Convert Debits/Credits
  3. Select [MENU] categories and create a "current account" category and a "credit card" category.
  4. Open the current account sub-account and enter a balance - say, £2000 in the credit column
  5. Open the credit card sub-account and enter some purchases- say, £20 ,£30 ,£40 in the debit column.
Suppose you want to pay the total of this from your current account -
  1. Open the credit card sub-account. Enter the total - £90 in the credit column.
  2. In the Category column of the credit card sub-account window select current account. Once you have entered this you need to make at least one more entry to that row (details or date) and on doing this you will notice that the letter code for the current account dissappears. This is to let you know that the transfer has taken place, and to stop you doing it again by accident.
If you open the current account sub-account you will see that a debit of £90 has been made and the balance is £1910.00. If you now check the main account window you will see the transactions and linked tranfers entered with the correct category codes, and the balance of the account is £1910.00.

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.


10) Loading and saving files

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


11) Exporting a CSV file

Select [MENU] > Export. Set the choices according to the program you are exporting to.

Options are-

Enter a CSV file name and drag the file icon to a suitable directory. CSV file import is not available.  

11a) Importing a CSV file

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!

12) Printing an account

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)


13) Linking accounts for transferring transactions

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.


14) Abbreviation tables

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. 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.

15) Calculator

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.

16) New Account Year

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.

17) Forecast Balance and Budgeting

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.

18) Search and Replace

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.


19) Known bugs and idiosyncrasies.

The direct debits "Day of month" entry is not checked for validity. If a transfer normally takes place on the 30th of a month, this will still appear as 30 even in February. I leave the user to enter sensible values.




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 version condition.

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.


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.