PIQInfo.rsc!:\system\OPL\PIQInfo.rscPIQInfo.opo!:\system\OPL\PIQInfo.opoPIQInfo.mbm!:\system\OPL\PIQInfo.mbmPocket IQ Library!
Copyright
Version:Visit us at www.PocketIQ.comPocket IQ information noticeThis file is an essential shared elementof Pocket IQ applications. Please do notdelete or alter in way, as doing so mayaffect applications in the Pocket IQ range.ContinuePutting the IQ back in shareware
c:\PIQInfo
C:\SYSTEM\OPL\PIQInfo.rscW
C:\SYSTEM\OPL\PIQInfo.rsc
D:\SYSTEM\OPL\PIQInfo.rscW
D:\SYSTEM\OPL\PIQInfo.rsc
E:\SYSTEM\OPL\PIQInfo.rscW
E:\SYSTEM\OPL\PIQInfo.rsc
Pocket IQ information notice
+(This file is an essential shared element
+(of Pocket IQ applications. Please do not
+'delete or alter in way, as doing so may
++affect applications in the Pocket IQ range.
ContinueO
APPYEAR$
APPAUTHOR$
APPTITLE$
APPVER$
APPEMAIL$
C:\SYSTEM\OPL\PIQInfo.rscW
C:\SYSTEM\OPL\PIQInfo.rsc
D:\SYSTEM\OPL\PIQInfo.rscW
D:\SYSTEM\OPL\PIQInfo.rsc
E:\SYSTEM\OPL\PIQInfo.rscW
E:\SYSTEM\OPL\PIQInfo.rsc
C:\SYSTEM\OPL\PIQInfo.mbmW
C:\SYSTEM\OPL\PIQInfo.mbm
D:\SYSTEM\OPL\PIQInfo.mbmW
D:\SYSTEM\OPL\PIQInfo.mbm
E:\SYSTEM\OPL\PIQInfo.mbmW
E:\SYSTEM\OPL\PIQInfo.mbm
C:\SYSTEM\APPS\
.aifKW
C:\SYSTEM\APPS\
.aifK
D:\SYSTEM\APPS\
.aifKW
D:\SYSTEM\APPS\
.aifK
E:\SYSTEM\APPS\
.aifKW
E:\SYSTEM\APPS\
.aifK
& Pocket IQK
O0O0O
WELCOME
SPLASHO
SYSTEM\
gE3""
"2CTe
gVUD3"
"2CTefw
wgVUD33#""23"
"2CTefw
xwfUv
xwfUD3"
!2CTUfw
wfUD3"
!2CTUv
The Pocket IQ End User Licence Agreement (EULA) is a legal agreement
between you and Pocket IQ Limited. By downloading or installing this
SOFTWARE, you agree to be bound by the terms of this Agreement. If
you do not agree to the terms of this Agreement, remove this SOFTWARE
immediately.
-------------------------------------------
Pocket IQ END USER LICENCE AGREEMENT (EULA)
-------------------------------------------
This licence refers to any product which is distributed by Pocket IQ.
GRANT OF LICENCE
This Pocket IQ Licence Agreement ("Licence") permits you to use one
copy of this product, on multiple machines which may include user
documentation provided in electronic form ("SOFTWARE"), providing it
is for the sole, exclusive use of the registered user. The SOFTWARE
is licensed as a single product. Its component parts may not be
separated for use on more than one computer or by more than one user
at any one time.
COPYRIGHT
The SOFTWARE (including any images and text incorporated into the
product) is owned by Pocket IQ and the independent application author
or its suppliers, and is protected by English copyright laws and
international treaty provisions.
REVERSE TRANSLATION
The SOFTWARE, including all related program files may not be altered
in any way. Reverse translation is expressly forbidden without
written permission of the Pocket IQ and the independent application
author.
LIMITED WARRANTY
To the maximum extent permitted by applicable law, Pocket IQ and the
independent application author disclaims all warranties, either
express or implied, including but not limited to warranties of mer-
chantability and fitness for a particular purpose. In no event shall
Pocket IQ, the independent application author or its suppliers be
liable for any damages whatsoever (including, without limitation,
damages for loss of business profits, business interruption, loss of
business information, or other pecuniary loss) arising out of the use
or inability to use this Pocket IQ product.
The SOFTWARE is supplied 'as is' and no advice or technical support
is guaranteed from Pocket IQ or any third party.y
Sound
EDBMS[100000df].dll
EFSRV[100000BD].dll
BAFL[1000004e].dll
APGRFX[1000011b].dll
euser[100000C1].dll
OPLR[10000077].dll
0,0@0P0\0h0
; ;$;(;,;0;4;8;<;@;D;H;
=(=4=@=L=X=d=p=|=
>$>0><>H>T>`>l>x>
? ?,?8?D?P?\?h?
gpdraw
gppages
Invalid OPX procedure
GPSetPenColor
GPSetPenWidth
GPSetPenStyle
GPSetBrushColor
GPSetBrushStyle
GPSetDrawMode
GPSetClipRect
GPCancelClipRect
GPMove
GPLineBy
GPLineTo
GPBox
GPFill
GPSetFont
GPGetFontSpec
GPTWidth
GPPrint
GPPrintb
GPPrintClip
GPSetCallback
Roman
Page
%-B%:0%J%:1%T%:3%+B
%D%M%Y%/0%1%/1%2%/2%3%/3
\system\printers\*
euser[100000C1].dll
OPLR[10000077].dll
ETEXT[100000d0].dll
EFSRV[100000BD].dll
EIKON[100001c2].dll
PRINT[100000e8].dll
GDI[10000175].dll
FBSCLI[10000176].dll
FIELD[100000d1].dll
0,0@0P0\0h0
2P2T2X2\2`2d2h2l2p2t2x2|2
3 3$3(3,3034383<3@3D3H3L3P3T3
4 6$6(6,6H6t7
T1$5(5,5054585<5
8`9l9x9
: :,:8:D:P:\:h:t:
;(;4;@;L;X;d;p;|;
<$<0<<<H<T<`<l<x<
= =,=
0$0(040@0L0X0\0h0l0p0
D:\OPM\pc_bar\pc_bar.pre!
PC_BAR_VERSION%
Progress bar module
1999 SymbianK(
This module can only be usedO
within an OPL applicationO
_PC_FONTSIZE&
_PC_COLOUR%
O {WK
_PC_BAR_INITIALISE&
_PC_DESTROY_STRUCT
O?8`[
_PC_BAR_INITIALISE&
_PC_DESTROY_STRUCT
_PC_BAR_INITIALISE&
_PC_DESTROY_STRUCT
_PC_DESTROY_STRUCT
{IWCO
_PC_DESTROY_STRUCT
{IWCO
_PC_DESTROY_STRUCT
{IWCO
|VWB}O
PC_MAIN-
_PC_DESTROY_STRUCT
_PC_BAR_INITIALISE&
_PC_COLOUR%
_PC_FONTSIZE&2
PC_FREEBAR&v
PC_GIBAR&
PC_ALERTBAR&
PC_DESTROY_FREEBAR~
PC_DESTROY_GIBAR
PC_DESTROY_ALERTBAR8
PC_BAR_UPDATE%
PC_BAR_VERSION%^
"data.appe@i
Table1
ColA9
ColB9
ColA11
ColB11
ColA12
ColB12
Index1
ColA11
Table1
Topic
Order
Arial
Arial
AWelcome to 5Account, a home banking system especially developed for the Psion Series 5, Series 5mx, Series 7 and GeoFox-One machines.
Please read the Overview section for a description of 5Account.
For first time users it is strongly suggested that you read the 'How do I start?' section. This section gives a detailed overview of all the processes involved in creating a new database and setting up for the first time.
GThe Pocket IQ End User Licence Agreement (EULA) is a legal agreement between you and Pocket IQ Limited. By downloading or installing this SOFTWARE, you agree to be bound by the terms of this Agreement. If you do not agree to the terms of this Agreement, remove this SOFTWARE immediately.
Pocket IQ END USER LICENCE AGREEMENT (EULA)
This licence refers to any product which is distributed by Pocket IQ.
GRANT OF LICENCE
This Pocket IQ Licence Agreement ("Licence") permits you to use one copy of this product, on multiple machines which may include user documentation provided in electronic form ("SOFTWARE"), providing it is for the sole, exclusive use of the registered user. The SOFTWARE is licensed as a single product. Its component parts may not be separated for use on more than one computer or by more than one user at any one time.
COPYRIGHT
The SOFTWARE (including any images and text incorporated into the product) is owned by Pocket IQ and the independent application author, or its suppliers and is protected by English copyright laws and international treaty provisions.
REVERSE TRANSLATION
The SOFTWARE, including all related program files may not be altered in any way. Reverse Translation is expressly forbidden without written permission of the Pocket IQ and the independent application author.
LIMITED WARRANTY
To the maximum extent permitted by applicable law, Pocket IQ and the independent application author disclaims all warranties, either express or implied, including but not limited to warranties of merchantability and fitness for a particular purpose. In no event shall Pocket IQ, the independent application author or its suppliers be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use or inability to use this Pocket IQ product.
The SOFTWARE is supplied 'as is' and no advice or technical support is guaranteed from Pocket IQ or any third party.
CTo register this product simply visit the Pocket IQ internet site and follow the registration instructions.
Alternatively you can register directly with Palmscape in any of the following ways:
Online Orders:
Purchase online via Palmscape's secure online service. Simply visit www.palmscape.com, and select the "Buy now" link. Palmscape accept most major credit cards (see below).
Telephone \ Fax orders:
Palmscape accept telephone orders via the United Kingdom office which can be reached on +44 (0)1234 353970.
Postal Orders:
Payment can be made by UK Cheque, Cash or Credit Card direct to the Palmscape office, located at:
44 Harpur Street
Bedford
Bedfordshire
MK40 2QT
England.
Please mark clearly that you wish to purchase this application.
Payment types:
Palmscape accept major Credit cards, Switch, Delta as well as UK Cheque, Eurocheque and Cash. If you are paying in any currency other than GB Pounds please add 10% to cover conversion fees.
Sketch
&Paint.app
PARegistration of 5Account can be performed by accessing the PocketIQ web site. The URL for PocketIQ is:
http://www.pocketiq.com/
or you can register from my own web page, the URL is
BIf you have not registered 5Account then there are certain limitations placed upon the software.
The unregistered version of 5Account will accept up to 20 transactions, thereafter the 'Unregistered' dialog box will be displayed when you attempt to add another transaction.
The unregistered version displays an Unregistered nag screen when you start and close 5Account.
Unregistered users will not be able to export data files that can be read by the PC companion to 5Account, PC5Account.
These are the only restrictions placed upon the software so you can fully evaluate its capabilities, but for a limited number of transactions.
Of course, the registered version allows the full facilities to be operated.
The Space Bar
The Space bar is used to add a new account, category, standing order or transaction within an account transaction view.
The 'Del' Key
The Del key is used to delete an account, category or standing order. It is also used to delete a transaction within an account transactions list.
The 'Tab' Key
The Tab key is used when in a transaction view to bring up a dialog box that describes the complete transaction, including the other side of the posting. In addition, the Tab key is used to display the Account/Category Details dialog box when you are in either the Accounts or Categories View. Pressing Tab on a highlighted Account/Category will open the Additional Details dialog where you can store a reference of up to 30 characters (the account number, for instance) and up to 255 characters of additional information.
Account, PC5Account.
These are the only restrictions placed upon the software so you can fully evaluate its capabilities, but for a limited number of transactions.
Of course, the registered version allows the full facilities to be operated.
gH5Account is a banking and personal ledger system designed specifically to take advantage of the Psion Series 5, 5mx, Series 7 and GeoFox-One available functions and databases.
5Account features:
many accounts
many categories
many standing orders
multi-currency
many transactions
support for Expense Accounts
QIF Import/Export
Export of CSV files
fast updating
Client Invoicing
PC Software free to registered users
5Account has been designed to be a friendly intuitive environment and supports pen, pointer and keyboard entries so that the user can use 5Account as and how he feels most comfortable.
Considerable enhancements have been made over the last year or so to enable 5Account to be as friendly as possible. All the latest technical improvements have been incorporated as well as user-friendly dialog boxes and an intuitive interface that helps to lead you through the complexities of accounting. It is the author's intention to ensure ease of use whilst using 5Account, yet ensuring that the concept of double entry book-keeping is maintained.
5Account will show the user his net worth at a glance, he can review the transactions within the system, reconcile those transactions, add new transactions, set up standing orders which can be for always or limited by a number of entries or an end date, and modify entries.
5Account is a multi-currency system which allows for many currencies. All you have to do is add a new currency, set its conversion rate to your home currency and from then on you can add a transaction in the new currency and the result will be automatically converted to your home currency.
5Account lets you maintain these currency conversion rates at any time without affecting the existing written transactions, thereby allowing for daily fluctuations in the rate.
Upon starting 5Account the system will check to see if there are any standing orders that should be paid, based upon the current system date set on your machine. If there are outstanding standing orders then 5Account will tell you of this fact and give you the immediate opportunity of invoking the standing orders update job.
@5Account is a double-entry bookkeeping system. This means that every transaction that you enter will be entered into an Account and the second (balancing) side of the transaction will be entered into a Category. Obviously, you can transfer money between accounts but the basic entry principle is Account -> Category.
As a user of 5Account you should not be too worried about this statement as the system has been designed for many types of users - from the person who just wants to reconcile his bank account right up to a small business user.
Step One
For this step you do not need your Series 5 or a computer, just a pen and some paper (and a calculator).
The first step is to create a chart of your accounts. This is simpler than it seems as there are two basic categories; the money I have and the money I owe; and where I spend my money and where I get my money from.
In the first part, create a list of where your money is and to whom you owe money. This will be your bank account, deposit accounts, savings accounts etc. and your loan accounts, credit cards, mortgage etc.
Categorise these accounts as either Bank, Credit Card, Asset or Liability. This resultant list will be your ACCOUNTS within 5Account.
Now categorise your Income and your Expenditure. Income will be Salary, Investments, Interest Received etc. and Expenditure will be Food and Drink, Lighting, Heating etc.
Categorise these accounts as either Income or Expenses. This resultant list will be your CATEGORIES within 5Account.
Lastly, generate a list of the regular payments that you have or receive. Make a note of the value and the number of payments/receipts left or the date upon which the regular payment will cease. Also make a note of which account the money will be transferred from and to which account/category the money will be transferred to.
This list will be your STANDING ORDERS within 5Account.
Step Two
Now you have to determine the opening balances of all your 5Account Accounts. For bank accounts and credit cards this will be the closing balance shown on the last statement that you received.
For the other accounts you will have to determine what these balances were at a fixed point in time.
Step Three
Now you need to enter this information into 5Account.
Create your new accounts and ensure that you enter the opening balances. It does not matter, really, if you do not enter the correct opening balance or even enter an opening balance at all as you can change this at any time by highlighting the account and pressing Ctrl-C.
Switch to the Categories View and enter your new categories.
itch to the Standing Orders View and enter your new Standing Orders.
Step Four
Now you need to enter the outstanding (that is, the unreconciled) transactions against each of your accounts.
An example would be your bank account. The opening balance in 5Account will be the closing balance shown on the last bank statement that you received. Since then there have been transactions that affect the balance but are not shown yet by your bank. It is these transactions that should be entered within 5Account.
Select each account in turn and press the Enter key to bring up the Transaction View. Then enter each transaction.
Step Five
Make a cup of tea or have something stronger - you deserve it!
AIf you intend using 5Account for raising invoices to Clients then you should complete this information for the invoice production.
There are two header fields that will be printed in bigger type at the top of the invoice, followed by four free-format fields for your address. In addition, there are fields for your telephone, fax numbers and email address. Lastly, there is a field that traps your VAT Registration Number.
You only need to complete this information once.
^AThere are two basic types of category:
Income
Expense
and one special category type:
Company Expense Category
An income category is an area from which you derive an income, like your salary. An expense is something that costs you money, like food, rent etc.
For more help on the Company Expense Category see the help for 'Expense Accounts'.
nformation.
R5Account will use the number format that you have set within your International Setting under Control Panel for the number format (thousands separator, comma separator) but has its own preferences settings for the other formats.
These preferences are:
Password protection
Home Currency
Decimal Places
VAT Percentage
Negative display format
Currency Symbol
Currency symbol position
Balance Order
Font
Switch the progress indicator on or off
Single tap reconciliation
Show Personal Details
VAT String
Next Invoice Number
The whole preferences dialogue is held within one dialogue box but using the concept of multi-pages. The following descriptions, therefore, are for each of the options available within the preferences dialogue.
Password protection:
The first available preference is password protection. This is a simple check box (checked means a password will be required at startup) that is defaulted to unchecked (no password required at startup).
If you would like to protect your data then check this box. Checking or unchecking this box has a dynamic effect within the preferences dialogue under the password tab. If the box is unchecked this means that no password is required within the system and there are no data fields to enter within password tab. However, if the box is checked then it will be a requirement to complete the password entry under the password tab.
Note that the password is case sensitive so the passwords 'simon' and 'Simon' will be different in 5Account.
Home Currency:
Select from the drop-down list your home currency. Note that this list will only display those currencies that you have defined within 5Account so it is necessary to set up your own home currency before selecting this preference.
Decimal Places:
The default number of decimal places is 2. The acceptable range of decimal places for 5Account is 0 to 10. Enter the number of decimal places that you require 5Account to use.
VAT Percentage:
5Account defaults the VAT percentage to 0. It can be modified here to your local rate. A rate of 10% will be keyed as 10.0.
Negative display format:
There are three options:
-100
100-
(100) - default
Selecting -100 will display the negative sign before the number. Selecting 100- will display a trailing negative sign and selecting (100) will display a negative number in brackets.
Currency Symbol:
Type in here the symbol that you would like to use.
Currency symbol position:
There are three options:
$100 - default
100$
Selecting $100 will display currency with a leading currency symbol (the one you have set). Selecting 100$ will display currency with a trailing currency symbol (the one you have set) and selecting 100 will not display a currency symbol at all.
Balance Order:
The default for this option is 'off' but it can be switched on by tapping on the checkbox. 'Off' means that the balance shown in the transaction view follows the line items being written to the screen. It follows, therefore, that each line item increases or decreases the previous balance by its own amount. The 'On' selection will follow a logical date order and will reflect the actual balance recorded on any particular date.
Font:
There are three options:
Courier
Arial - default
Times Roman
Select your preferred font. The size of the font is controlled by the zoom (Ctrl-M or Shift-Ctrl-M).
Switch the progress indicator on or off:
This is the progress bar indicator that is used to show 5Account's progress in certain functions. Setting this switch turns the indicator on or off.
Single tap reconciliation:
With this switch set you can reconcile a transaction by just tapping on a highlighted item. To use the normal 5Account pop-up menu press the Enter key instead.
Show Personal Details
This option allows you to select whether 5Account should print your personal details on the top of an Invoice. The default is to print the personal details as 5Account assumes that you will be using blank paper.
If, however, you wish to use a letterhead then uncheck this option and your personal details will be suppressed and five line feeds will be made instead.
Please note that this option does not apply to the HTML invoice print.
VAT String
5Account defaults the characters 'VAT' for VAT. You have the option to change this string within the preferences section to one of your choice, up to a maximum of 3 characters (e.g. GST).
Next Invoice Number
This is the seed number for the next invoice that 5Account generates. Upon installation this will default to 1, but you can overwrite this directly.
IACategory transactions may be viewed by selecting the category and pressing the Enter key or by double tapping on the category.
The Transaction View will be displayed that will show all the transactions that have been linked to this category.
It also displays those transactions that have been reconciled via the Accounts View.
numbers and email address. Lastly, there is a field that traps your VAT Registration Number.
You only need to complete this information once.
:T2@:8J
Welcome To 5Account
A0000
Welcome to 5Account, a quality application from Pocket IQ and Simon Berridge.
Support: simon@pocketiq.com
Internet: www.PocketIQ.com
1998-2000 PocketIQ & Simon Berridge
How To Register
A0010
Licence Agreement
A0020
5Account
B00000
Author & Contact
B00005
The author of 5Account is Simon Berridge. Simon can be contacted on either of these email addresses:
SimonBerridge@compuserve.com
Simon@pocketiq.com
Registration
B00008
Unregistered Restrictions
B00010
Overview
B00050
How Do I Start?
B00060
Special Keys
B00065
Preferences
B00070
Personal Information
B00080
Accounts
B00100
What is an Account
Adding an Account
Account Details
Entering a Transaction
Changing a transaction
Reconciling an Account
Removing an Account/Category
CThere are five basic types of account:
Asset
Liability
Bank Account
Credit Card
Cash Account
and one special account type:
Expense Account
An asset is something you own that has a value, like your house or your car.
A liability is something that you owe, like the mortgage on your house or the outstanding loan on your car.
It follows, therefore, that a bank account is an asset (even though for some of us running under an overdraft it is actually a liability!) and a credit card is a liability.
The reason that 5Account allows for separate accounts for Bank and Credit Cards is that most of us think in that way. Our bank account is viewed separately from our house as is our credit cards. 5Account just gives you a simple mechanism of keeping them logically separate.
The Cash Account type is used like your wallet - it s to keep a record of the actual cash that you have available at any one time.
For a description of the Expense Account type see the topic 'Expense Accounts'.
DAn account is added to 5Account from the Accounts view. Navigate to the Accounts view by pressing Shift-Ctrl-A, or by tapping on the Accounts box in the top of the main window or by using the menu items View, Switch View, Accounts.
When you are in the Accounts view press the spacebar, Ctrl-I or Menu, Accounts, Add Account to open the Add Account dialog box.
In this dialog box give your new account a meaningful descriptive name, select the type of account from the list of Bank, Credit Card, Asset or Liability, enter an opening balance as a positive number and then select the sign by selecting Asset or Liability.
An example would be a credit card with an opening balance of
600 owing. This would be entered as follows:
Account Name : Mastercard
Account Type : Credit Card
Opening Balance : 600
Type of balance : Liability
An asset, like a bank account with a positive balance would be entered as follows:
Account Name : Barclays Bank
Account Type : Bank
Opening Balance : 1104.56
Type of balance : Asset
It is important that you ensure the opening balance of an account is correct. Usually you will obtain this number from the closing balance on a bank statement or such like.
A5Account can hold additional account details for an account or a category.
The details are accessed by highlihting the required account/category and pressing the Tab key.
The additional details are:
Reference
Information
Reference
This is up to 30 characters for reference. Typically this will be the actual 'real' account number.
Information
This is a memo style field that allows up to 255 characters of additional information to be stored. This is a free format field.
lGTransactions are entered via the 'Accounts View', and are entered against the account highlighted.
To enter a transaction switch to the Accounts View and select the account in which you wish the transaction to appear. Press Enter or double tap on the account to display the transactions view within the account selected.
When the transaction list is displayed you may then enter a new transaction by pressing the space bar which will open up the transaction entry dialog box.
The transaction entry dialog box assumes that the other side of the transaction posting will be allocated to a category and the category list is an option within this dialog box. However, if you wish to make a transfer between accounts then select 'Transfer' instead of 'Debit' or 'Credit' and 5Account will hide the category list field. A second dialog box will then appear after pressing the OK button which will give you a list of the accounts to which you can transfer the amount entered in the transaction entry dialog box.
5Account has a switch at the beginning of the dialog box that allows you to determine whether the transaction is for a bank account or not. If the transaction is for a bank account then 5Account assumes that the next cheque number will be used and defaults this next value in the 'Reference' field. If the transaction being entered is not a cheque just press the backspace key when the field is highlighted or uncheck the 'Bank Transaction' checkbox. 5Account initialises this field to the value '1' the first time that you use 5Account. You can change the value by overriding it with the actual next cheque number and, from that point onwards, 5Account will use the correct cheque numbering sequence.
You have the ability to add a transaction in an unreconciled or reconciled state. The 5Account default is unreconciled but this can be changed simply by checking the Reconciled check box.
CTo change a transaction it is necessary to open the account where the transaction originated (that is, the account which you used to add the transaction) and highlight the transaction that you wish to change.
Pressing Enter or double tapping on the transaction will open a pop-up menu that has three options:
Reconcile
Modify
Delete
Select the Modify option and the original dialog box will be opened with the details of the transaction. From here you can change any of the fields, change the Debit/Credit flag or Transfer the money somewhere other than the original account etc.
If the transaction is in the 'transfer to' account then the only option diplayed in the pop-up menu will be Reconcile.
Please note that you can only modify an unreconciled item.
EWhen you receive a bank statement or statement of account you can reconcile this against the 5Account account type simply.
Reconciliation is done from the Transaction View within the Accounts View. Switch to the Accounts View and highlight the Account you wish to reconcile. Press Enter on the account or double tap on the account to display the transaction view of the account.
Double tap on each transaction entry that you wish to reconcile and a pop-up menu will be displayed, one of the items being Reconcile. Select the reconcile item and the transaction entry will be reconciled and a tick will appear under the reconciled column. Alternatively highlight the transaction entry and press Ctrl-R.
If you make a mistake and reconcile the wrong line item then just press Ctrl-R again (or Unreconcile from the pop-up menu) and the line item will be unreconciled.
Watch the bottom window whilst reconciling entries. The Reconciled Balance box will change and will show you the running balance of reconciled items.
When you have finished reconciling the statement check this reconciled balance. If the value displayed there is the same balance as shown on the bottom of the statement then your account is correctly reconciled. If the balance is different then your account is not reconciled correctly and either you have missed an item, you reconciled an item that you should not have or the opening balance on the account was incorrectly keyed.
,CAn account can be removed from 5Account by simply highlighting the account and pressing the Delete (backspace) key.
There are some rules surrounding the removal of an account. These are simply that there must be no attached transactions. 5Account will check that there are no transactions attached to the account before allowing the removal. If there are no attached transactions then 5Account will delete the account.
If you wish to remove an account but there are attached transactions then you will either have to modify the transaction(s) to point to a different category (if it is a category you are removing) or delete the transaction, or archive the transactions (remember that the archiving only works on reconciled transactions).
Once there are no attached transactions then the removal can proceed.
B00200
B00480
B00755
B01000
@Periodically it is necessary to reset the opening balances of your categories to zero.
Typically this would be at the end of an accounting period or at leat on an annual basis.
From the Categories View access the menu, then Categories, then Reset Balances.
This job will run through all your categories and reset the opening balance to zero. The Reconciled and Current Balances will be changed to reflect this reset to the o|
pening balance and will show you the total current expenditure and income for each category since the last reset.
In practice it is best to reset the category balances after each and every archive or archive recovery operation. The category balance reset does not affect the archiving at all as it is only the transactions that are archived, not the category information itself.
!AA Standing Order is a regular payment between accounts.
An example would be the regular monthly payment of mortgage, rent or loan on a car and is, generally, a fixed sum with either a fixed number of payments or an end date.
5Account allows for either of these types of regular payment.
LAFirstly, switch to the Standing Orders View.
Highlight the Standing Order that you wish to modify and then press the Enter key, this will open and display the Standing Orders modify dialog box.
You can then modify any or all of the fields displayed. The rules for the entry are the same as in the topic 'Adding a Standing Order'.
AFirstly, switch to the Standing Orders View.
Press the Menu key, select Standing Orders and then Update Standing Orders.
The Update Standing Orders dialog box will be displayed which asks for the date to which Standing Orders should be updated. The default will be today but this can be overwritten to any date. Pressing the OK button will start the Updating process.
Please note that this may take a few minutes if there are a large number of standing orders to process.
all as it is only the transactions that are archived, not the category information itself.
ISince Release 4.0 Expense Accounts have been an integral part of 5Account.
An Expense Account is an account type that allows you to trap expenses that you have incurred on behalf of another party, typically a company expense account. As the Expense Account has been introduced into 5Account as an account type it follows, therefore, that you may define as many Expense Accounts as you wish. This means that you can set up a specific expense account for every client for which you undertake work or just one expense account for your main employer.
The transactions linked to any Expense Accounts can only be posted to categories designated as type 'Company Expense Category'. This means that to set up an Expense Account you should also set up a corresponding number of Company Expense Categories under Categories.
In all respects an Expense Account type works in the same way as any other account within 5Account with the following exceptions:
Any account of type 'Expense Account' is masked from the Net Worth view or print (Balance Sheet).
Any category of type 'Company Expense Category' is masked from the Profit and Loss view or print.
Transactions can be added as normal within the Transactions View but the Category Types that appear within the drop-down list view will be only those that have been designated a 'Company Expense Category' within Categories.
Transactions added within a 'normal' account type will not allow the posting category to be a 'Company Expense Category' type.
As the expense account is handled by 5Account the same way it does with a 'normal' account you have the ability to export the transactions to a spreadsheet (via the CSV output) for whichever view you currently have for the expense account. It follows, therefore, that you can create a company specific spreadsheet from you data and import this data into the spreadsheet on a month by month basis.
Alternatively, you can print the account directly from 5Account (or produce an HTML output) and use this as the submission form for your expense claim. Once the claim has been agreed you can just reconcile those items and mask them from future prints.
For statistical purposes you can trap the expense categories within the Categories section of 5Account to give various reports at any time within your expense year.
Overview
Add a Client
Modify a Client
Delete a Client
List Clients
Invoices Overview
Creating an Invoice
Adding Line Items
Viewing an Unfinished Invoice
Finishing an Invoice
Viewing a Finished Invoice
Viewing List of Finished Invoices
Printing an Invoice
ment.
GFirstly, switch to the Standing Orders View.
Press the space bar, this will open and display the Standing Orders entry dialog box.
Enter a description of the Standing Order and the amount. Select a 'From Account' from the list box and then select the 'To Account' from the list box. Both the From and To accounts can be either Accounts or Categories, but must not be the same. 5Account will check this when you press the OK button and will not allow a Standing Order to be created where the From and To accounts/categories are the same.
You may use the standing orders section to set up a regular payment where you do not know the actual value until a later date. This could be a variable direct debit or a credit card payment where the amount is unknown. To do this you need to set up a standing order with a value of zero. 5Account checks when you press the OK button whether there is a value entered. If this value is zero 5Account will not display an error but will request confirmation that a zero value is what you intended to enter. Assuming that this is correct 5Account will accept this new standing order. At the time of payment 5Account will create a transaction with a zero value. 5Account will assume that you will modify the transaction value when you have the confirmation of the actual value.
The number of transactions defaults to '9999'. This means to 5Account that there is no end date or number of transactions - in other words the Standing Order will occur forever.
If you wish to enter a fixed number of payments (a car loan, for example, is typically over a two year period and would get the number 24 if monthly payments) then overwrite the 9999 default to the number of periodic payments that will be made.
If you wish to enter an end date then overwrite the number of payments from 9999 to 0. Pressing OK will then display a second dialog box that will request the entry of the end date.
JHDRRR^E
What is an Account
B00110
Adding an Account
B00120
Account Details
B00125
Entering a Transaction
B00130
Changing a transaction
B00135
Reconciling an Account
B00140
Removing an Account/Category
B00150
Categories
B00200}
What is a Category
Adding a Category
Viewing Transactions
Removing an Account/Category
Resetting Category Balances
What is a Category
B00210!
Adding a Category
B00230$
Removing an Account/Category
B002405See:
Removing an Account/Category
under
Accounts
Resetting Category Balances
B00250%
Expense Accounts
B00260&
Standing Orders
B00300x
Overview
Adding a Standing Order
Changing a Standing Order
Deleting a Standing Order
Updating Standing Orders
Overview
B00310'
Adding a Standing Order
B00320(
BClients and Invoices go together in 5Account.
The whole purpose of holding Client information is so that you can raise an invoice to a client and 5Account has sufficient information to generate an invoice to that client.
All Client and Invoice maintenance is performed from the main 'Client' menu item.
An invoice cannot be created until at least one client is registered within the database. Use the menu option Client, Add a Client to add a new client. You will also see the Invoices option on the same menu, with its own sub-menu attached.
See the Invoices Overview topic for a detailed description of how invoicing works within 5Account.
2AIf you intend using 5Account to raise invoices to a Client then you will need to add a client.
This is performed by accessing the menu, selecting Clients, Add Client. The short cut key is Ctrl-L.
The Client Add dialog box will be opened. Complete the information as you wish it to appear on the invoice.
9AThis is performed by accessing the menu, selecting Clients, Modify Client. The short cut key is Shift-Ctrl-O.
The Client Selection dialog box will open, select the client that you wish to modify.
The Client Modify dialog box will now be opened. Complete the information as you wish it to appear on the invoice.
]AThis is performed by accessing the menu, selecting Clients, Delete Client. The short cut key is Shift-Ctrl-D.
The Client Selection dialog box will open, select the client that you wish to delete.
The Client Delete dialog box will now be opened. If this is the client that you wish to delete press the Delete button and the client will be deleted.
;AThis option is accessed from the menu, select Clients, Client List. The short cut key is Shift-Ctrl-L.
This action will open a window that will display all the clients within the 5Account database. Double tapping on any item will open the Client Enquiry dialog box. From here you canmodify the client if you wish.
=AThis is performed by accessing Clients, Invoices, Create Invoice. The shortcut key is Ctrl-S.
The Invoice create dialog box will be opened that allows you to select the client for whom you wish to create the invoice. Once selected the invoice header is now created and you are able to add line items to the invoice.
BThis is accessed from Clients, Invoices, View Unfinished Invoices. The short cut key is Shift-Ctrl-U.
The Select Unfinished Invoice dialog box will be opened where you select which invoice you wish to use.
The View Unfinished Invoice window will now be opened for use.
Pressing the Enter key or double tapping on any line item will open a pop-up menu with the options Modify, Delete or Add displayed. If you double tap on the total line only the Add option is displayed.
It is the author's preference to use this View option to adjust the invoice before finishing it rather than using the menu options and it is suggested that you follow this practice too.
e tapping on any item will open the Client Enquiry dialog box. From here you canmodify the client if you wish.
HCreating an invoice in 5Account is a three step process. These processes are:
Create Invoice
Add Line Items
Finish an Invoice
The Create Invoice option (from the Clients, Invoices menu) just creates a simple Invoice Header record within the database with a new invoice number. Once this header has been created you can add, modify and remove line items before 'Finishing' the invoice.
Until an Invoice is 'Finished' it is flagged within 5Account as 'Unfinished' and, therefore, is not a real invoice and can be modified and played with at will. This means that an invoice can be used to capture an expense account during the month, or add line items one at a time.
Once the Invoice Header has been created you can now add line items to the invoice. This is done by accessing Clients, Invoice, Add Line Items. A dialog box will be displayed that asks for the details of the line item to be added. This dialog box will be refreshed after each line item is added as 5Account assumes that you will wish to add more than one line item at a time. When you have finished adding items just press the Esc key to close the dialog box.
You can review any unfinished invoice at any time by accessing Clients, Invoices, View Unfinished. This will open a dialog box that will ask which unfinished invoice you wish to view and, after selection, will display the invoice as it will appear to the client. This window will list all the line items added to this point with a cursor highlighting the top item.
Pressing the Enter key or double tapping on any line item will open a pop-up menu with the options Modify, Delete or Add displayed. If you double tap on the total line only the Add option is displayed.
It is the author's preference to use this View option to adjust the invoice before finishing it rather than using the menu options and it is suggested that you follow this practice too.
When you are happy that the invoice is at you wish it to be then use the Clients, Invoice, Finish Invoice option to 'finish' an outstanding invoice. Please note that once you have 'finished' an invoice it cannot be modified in any way.
You can now print the finished invoice directly to your printer or to an HTML file.
=AThis is performed by accessing Clients, Invoices, Create Invoice. The shortcut key is Ctrl-S.
The Invoice create dialog box will be opened that allows you to select the client for whom you wish to create the invoice. Once selected the invoice header is now created and you are able to add line items to the invoice.
;EOnce you have an Invoice Header created you can add a line item by accessing Clients, Invoices, Add Line Item. The short cut key is Ctrl-T.
The Select Unfinished Invoice dialog box will be opened where you select which invoice you wish to use.
The Add Line Item dialog box will now be opened for use.
The date will default to today. This can be obverwritten.
Details
Enter in this field the details of the line item. Note that this will appear on the invoice as written by you.
Quantity
Enter in here the number of items being sold (or days if a daily rate charge is being utilised). From R2.2 onwards this quantity field can be expressed as a decimal number. This was introduced to allow for charging by hours at a user request.
Item Value
Enter in here the individual value of each sold item.
Currency
Select the currency of the line item.
Total Value
This is a field that can be calculated by 5Account. The value of this field will be the result of:
Quantity * Item Value
Pressing the OK button will add the line item to the database and then refresh the dialog box. To close the dialog box after entering all the line items that you wish to in this transaction just press the Cancel button.
Please note that the actual total value of each line item will be converted to your home currency for final invoice production.
>BOnce you have Finished an Invoice it is possible to send it to your printer or to an HTML file.
Access the print function from Clients, Invoices, Print Invoice. The short cut key is Shift-Ctrl-K.
This will open the Select Finished Invoices dialog box. From here select the finished invoice that you want to print. Select from here also the destination of the print, Printer or HTML file. If you select HTML file a further dialog box will open that asks for the HTML file name and destination.
Pressing the OK button will now print the invoice to your chosen destination.
r than using the menu options and it is suggested that you follow this practice too.
BWhen you are happy that the invoice is at you wish it to be then use the Clients, Invoice, Finish Invoice option to 'finish' an outstanding invoice. The short cut key is Shift-Ctrl-F.
The Select Unfinished Invoice dialog box will be opened where you select which invoice you wish to finish.
From here you will see a dialog box that will allow the calculation of the invoice for VAT purposes, if necessary. The next dialog box will ask for the accounts/categories that are associated with the invoice and then the invoice will be finished.
Please note that once you have 'finished' an invoice it cannot be modified in any way.
You can now print the finished invoice directly to your printer or to an HTML file.
xAFrom any view within 5Account press the Menu key. Select Currency then select 'Add Currency'.
Enter the currency key (typically the currency symbol) of up to 3 characters.
Enter a description of the Currency (like Sterling or US Dollars) and then enter the conversion rate to your home currency. If this currency is your home currency then set the conversion rate to 1.00.
VF6>DD>HLH`N
Changing a Standing Order
B00330*
Deleting a Standing Order
B00340
Firstly, switch to the Standing Orders View.
Highlight the Standing Order that you wish to delete and then press the backspace key. This will delete the Standing Order.
Updating Standing Orders
B00350+
Clients & Invoices
B00400,
Overview
B00410-
Add a Client
B00420.
Modify a Client
B00430/
Delete a Client
B004400
List Clients
B004421
Invoices Overview
B004502
Creating
an Invoice
B004603
Adding Line Items
B004704
Viewing an Unfinished Invoice
B004805
Finishing an Invoice
B004906
Viewing a Finished Invoice
B00491
This is simply a window that displays the finished invoice details together with the VAT, if applicable.
This view is accessed from Clients, Invoices, Invoice Views, View Finished Invoice. The shortcut key is Shift-Ctrl-F.
Viewing List of Finished Invoices
B00492
This window displays all the finished invoices and their reconciled status.
This view is accessed from Clients, Invoices, Invoice Views, View Invoice List. The shortcut key is Shift-Ctrl-W.
BOnce you have added your own home currency and set the conversion rate to 1.0 you need to ensure that 5Account will always know which is your home currency.
This is undertaken within the Preferences settings.
Press the Menu Key, then Access the File Menu, then Preferences.
The first field shown is the Home Currency. Select your home currency in this field. Then set the way in which you wish 5Account to display the currency by selecting the currency options.
See the 'Preferences' section for further help.
on will now print the invoice to your chosen destination.
F5Account is a multi-currency accounting system.
The basic premise is that all accounts, categories and transactions will be displayed in your home currency, but can be entered in a foreign currency.
By default, 5Account starts up assuming the home currency to be UK pounds Sterling and that is the only currency available to the system.
Currencies are maintained from the menu item - Currency. You can add or modify a currency from here.
A home currency is designated simply by setting the exchange rate for that currency to 1.00. Whenever you add a currency and set its exchange rate the rate is set according to your home currency, not published rates.
An example would help. My home currency is UKP (
). I have a USD currency in 5Account where I have set the exchange rate as 1.60 ($1.60 =
1.00). Any USD entry that I make will result in an entry within 5Account of the converted amount, that is the amount entered divided by 1.60. So, if I make a transaction for $16.00 5Account will convert this sum to my home currency (UK Pounds) by using the following formula:
EnteredAmount / EnteredCurrentRate = HomeAmount
16.00 / 1.60 = 10.00
Conversely, if my home currency is USD ($) and I have a UK Pounds (
) currency then I would set the conversion rate of $ to 1.00 and the conversion rate of
to 1 / 1.60, or 0.625. If I then make a
10.00 transaction 5Account would convert this to my home currency using the same formula as above like so:
EnteredAmount / EnteredCurrentRate = HomeAmount
10.00 / 0.625 = 16.00
5Account gives you the ability to change this conversion rate at any time and the next transactiuon entered will use the latest conversion rate.
sAThe exchange rate is the rate at which 5Account should convert a foreign currency transaction to your home currency.
The exchange rate for a particular currency can be changed at any time by modifying the currency and entering the new exchange (conversion) rate.
See the 'Overview' section under 'Currency' for a description of how exchange rates work within 5Account.
mBThis view shows all the Standing Orders that are held within 5Account.
Each Standing Order has a next due date shown, the details of the Standing Order, the amount and the currency.
Entry of a new standing order is undertaken by pressing the space bar in this view and the New Standing Order dialog box will be displayed.
Modifying a standing order is undertaken by highlighting the standing order and pressing the Enter key or double tapping on the entry. This will open the Modify Standing Order dialog box.
Deleting a Standing Order is undertaken by highlighting the standing order and pressing the Backspace key.
home currency.
The exchange rate for a particular currency can be changed at any time by modifying the currency and entering the new exchange (conversion) rate.
See the 'Overview' section under 'Currency' for a description of how exchange rates work within 5Account.
zDThis view shows all Bank Accounts, Credit Cards, Asset and Liability Accounts and, therefore, detail the balance sheet or Net Worth. An account differs from a category in that the balance of the account rolls forward and is never zeroised.
The main window shows the type of the account (Bank, Credit Card, Asset or Liability), the name of the account, the current balance of the account as a liability or as an asset and the last column shows the running total of all the accounts shown.
The bottom part of the window shows the specific detail for the account which is highlighted by the scroll bar. Using the up/down/PgUp and PgDn keys will scroll the highlight bar over the accounts and the bottom window will reflect the change in the account highlighted. There are three fields shown in this bottom window, the opening balance on the account, the reconciled balance on the account and the account's current balance (which is also shown in the main window).
If you wish to see the transactions associated with the highlighted account just press the Enter key or double tap on the account and the Transactions View window will be displayed.
]DThis view shows all Income and Expense Categories and, therefore, detail the profit and loss. A Category differs from an Account in that the balance of the Category does not roll forward and is zeroised periodically.
The main window shows the type of the category (Income or Expense), the name of the category, the current balance of the category as an income or as an expense and the last column shows the running total of all the categories shown.
The bottom part of the window shows the specific detail for the category which is highlighted by the scroll bar. Using the up/down/PgUp and PgDn keys will scroll the highlight bar over the categories and the bottom window will reflect the change in the category highlighted. There are three fields shown in this bottom window, the opening balance on the category, the reconciled balance on the category and the category's current balance (which is also shown in the main window).
If you wish to see the transactions associated with the highlighted category just press the Enter key or double tap on the category and the Transactions View window will be displayed.
RBThe Transactions View is accessed from either the Accounts View or the Categories View.
Highlight the Account or Category which you wish to look at and press Enter, or double tap. This opens the Transactions View on that particular Account or Category.
If you are viewing the transactions linked to an account rather than the transactions linked to a category you can 'jump' to another transaction view by pressing the hotkey Ctrl-J. This 'jump' hotkey will open a dialog box that allows you to select the account to jump to and will then display the transactions linked to this new account.
AQIF files are the data import/export files that are used by Quicken and have become the industry standard for transferring financial information between computer systems.
QIF files are supported by
Quicken
Microsoft Money
and other good quality PC and palmtop systems.
5Account supports both the export to and import from QIF files. This enables you to transfer your financial information between your Series 5/GeoFox-1 and your PC.
ng the hotkey Ctrl-J. This 'jump' hotkey will open a dialog box that allows you to select the account to jump to and will then display the transactions linked to this new account.
DThere are two data views supplied with this version of 5Account. These views are:
Net Worth
Profit and Loss
Each of these views are described below.
Net Worth
This view is invoked with the hot key combination of Shift-Ctrl-N or by accessing the menu, selecting View, Data Views and then Net Worth.
You will be presented with a dialog box that will ask where the output should be directed.
There are three options:
Screen
Printer
HTML File
5Account will then spend a few seconds processing the data and will then send the details of your current net worth to your chosen output device.
Profit and Loss
This view is invoked with the hot key combination of Shift-Ctrl-I or by accessing the menu, selecting View, Data Views and then Income & Expenses.
5Account will open a dialog box that asks for from and to dates to be entered and where the output should be directed. There are three options:
Screen
Printer
HTML File
5Account will then extract all the transactions between these two dates and will send the movements within your categories for the required period to your chosen print device.
The end result will be a profit or loss over the period and this will be displayed line by line.
A5Account has a selection of three fonts, Arial, Courier and Times Roman.
These fonts may be zoomed in and out for three sizes to allow for your own preferences.
5Account defaults to Arial, middle size.
The font can be changed from within the Preferences section, which can be found under File, Preferences.
Zooming is performed by tapping on the zoom in/out button on the Series 5 screen or by pressing Ctrl-M or Shift-Ctrl-M.
r PC.
BCreating a QIF export file is a simple matter.
Select File, then QIF Export/Import (Ctrl-X).
A dialog box will be opened that asks whether you wish to import a QIF file or export a QIF file. Select Export QIF and press the OK button.
The next dialog box is asking for the account which it should export and then the name of the file and its location where the QIF file will be created. The default is C:\Documents\QIFExp.qif but this can be overtyped with your own chosen filename and location. 5Account will check that the extension of 'QIF' has been added and, if not, will add the extension for you.
Pressing the OK button will now create the QIF file, which can then be transferred to your chosen target platform for import.
KImporting financial data from a QIF file is relatively simple but may be time consuming if there are a lot of unknown accounts.
Select File, then QIF Export/Import (Ctrl-X).
A dialog box will be opened that asks whether you wish to import a QIF file or export a QIF file. Select Import QIF and press the OK button.
The next dialog box is asking for the name and location of the import QIF file. Navigate to the location of the file and select the file name.
5Account will ask that you tell it which date setup to use. Microsoft Money, for example, typically uses the 'mm/dd/yyyy' format whereas 5Account uses the 'dd/mm/yyyy' format.
Lastly, 5Account needs to know whether the Category Creation should be be made automatically or request for an account from you, the user. The default for this is to request a category name from you. If you check this checkbox then 5Account will create a new Category for each different category within the QIF. Of course, if 5Account can find a category that matches then it will use that one.
Then press the OK button.
5Account will check that the import file is a valid QIF file and will then display a dialog box that is asking which account within 5Account should receive the imported data. If there are no accounts defined within 5Account (in other words this is a new database) then the account selection drop-down list will not be displayed. 5Account displays within this dialog box the name of the import account, its type (Credit Card, Bank etc.) and the opening balance.
Now you have two choices. You select an existing account within 5Account to receive this QIF file or you Add a new account. Adding a new account is a simple matter of pressing the 'Add' button and the Add Account dialog box will be displayed. If you add a new account 5Account will redisplay this dialog box and allow you to select an account.
Once you have selected the receiving account pressing the OK button will start the import process.
Please Note:
Once you have started the import process it cannot be stopped.
5Account will then undergo the following processes:
read the QIF file transactions
create a working file of the read transactions
create a working list of the secondary accounts/categories referred to by the individual transactions
update those accounts/categories that it can match by name
ask for user input for the accounts/categories that it cannot match (if a manual import)
write the transactions to the 5Account transactions file
When 5Account reaches step 5 it will display to you each of those accounts/categories where it cannot find a match. This dialog box is only displayed if you left the automated create category checkbox unchecked in the start dialog. You will be asked to select the correct matching account/category from the drop-down list. If the account/category is not held within 5Account you can create one at this time by pressing either the Account or Category button displayed in the dialog box.
@DNH:
Printing an Invoice
B004959
Currency
B00500A
Overview
Adding a Currency
Setting as Home
Exchange Rate
Overview
B00510:
Setting as Home
B00530;
Adding a Currency
B00520<
Exchange Rate
B00540=
Windows
B00600Z
Accounts View
Categories View
Standing Orders View
Transactions View
Data Views
Accounts View
B00610>
Categories View
B00620?
Standing Orders View
B00630@
Transactions View
B00640A
Data Views
B00650B
5 QIF Files
B00700>
What are QIF Files?
Exporting to QIF
Importing from QIF
What are QIF Files?
B00710C
Exporting to QIF
B00720D
Importing from QIF
B00730E
@DIt is possible to create a CSV (Comma Separated Value) file from 5Account for an individual account or for all the accounts. The CSV export file contains all the transactions for the selected account or for all accounts (which means that all the transactions are exported).
CSV files can be read by most common PC spreadsheet programs (Excel, 1-2-3 etc.) and will be imported into the spreadsheet automatically.
The shortcut key is Shift-Ctrl-X, and the item is accessed from the Accounts Menu.
The dialog box presented defaults the filename to 'Account.CSV' in your C:\Documents folder. These may be changed, and you do not have to specify the extension as 5Account will automatically add CSV to the filename specified. The default also for accounts is ALL accounts. If you only wish to export one account uncheck this default.
5Account also defaults the Text Qualifier to the double quote character and the Label Separator as a Semi-Colon (;). To change these values press the 'Options' button in the dialog box which will bring up a separate dialog box with the options specified.
EUnfortunately this is a multi-step process.
Export the Data
This is done from within 5Account. Select the Export to CSV option (Menu, Accounts, Export or Shift-Ctrl-X).
Press the Options button. The Options dialog box will open.
Change the Label Separator from 'Comma Separator' to 'Tab Delimiter'.
Change the Text Qualifier from the default double-quote to a space (' ').
Press the 'OK' button.
Back in the Data Extract dialog box type the filename that you want, the folder and disk and whether you want all or a single account exported. Then press the 'OK' button.
If you unchecked the 'All Accounts' checkbox a further dialog box will open which asks for the Account that you wish to export. Select the Account and press the 'OK' button.
The data will now be exported in to your chosen file. Note that the file extension will be CSV.
Now open a new Psion Word document. From the File menu select 'More' then select 'Import Text File...'. Navigate to where you saved your data extract file and select that file. The file will be imported to Word. Press Ctrl-Fn-UpArrow to get to the top of the file.
Now press Shift-Ctrl-Fn-DownArrow to highlight the whole document. Then press Ctrl-C to copy the whole document to the Psion Clipboard. Now exit Word with Ctrl-E.
Now create a new Psion Sheet document. Then just press Ctrl-V to copy the contents of the Psion Clipboard to the Sheet application and after a few seconds your data will appear within the Spreadsheet.
@It is a common problem whenq
you have many transactions and you want to make an adjustment yet the other side of the transaction has been reconciled. To see the other side of any transaction just highlight the transaction in question and press the Tab key.
A dialog box will open that will display the full details of the transaction, including the other account/category to which is was posted.
E5Accounts allows you to archive reconciled transactions in a separate archive file. This archive file will have the file extension 'arc' which describes the type of file. 5Account allows for two types of archiving procedure, archive by date the whole database or archive a single account by date. Conversely the restoration of an archive has these two functions also.
Each 5Account database may have many associated archives, but you cannot import an archive from one database into another. The reason for this is simple. 5Account uses an internal number to reference an account or category and these must match in a restore otherwise the restored transactions will be added into the wrong account or category, or the account/category will not be found by the restore procedure.
Archiving reconciled transactions removes those transactions from within 5Account itself, and will change the opening balances of all the accounts/categories affected by the archive operation.
Conversely, restoring an archive also changes the opening balance of any accounts/categories affected by the restoration.
Restoration is by a date range, so you can restore all or part of an archive. Restoring transactions from an archive deletes those transactions from within the archive itself so it is not possible to restore the same transaction twice. This can occur, though, if you restore from a backup file and then overwrite the resultant archive with an older copy.
ESelect 'Archiving' from the File Menu, then select Archive reconciled items. The shortcut key is Ctrl-V. You may also archive one account, in this instance select the Archive Single Account option, shortcut Ctrl-Q.
The archive dialog box will be displayed that defaults to an archive called 5Account.arc, within the C:\Documents folder. If you have already created an archive previously then the previously used archive will be displayed. Change these to whatever you wish them to be. If you have chosen the single account archive option then there will be a drop-down list box of all accounts displayed and you should select the specific account that you wish to archive. The default is all reconciled items to be archived. If you wish to archive transactions by a date range then uncheck this default and press the OK button. A second dialog box will appear that requests an 'up to date' for archiving.
If you are archiving to an existing archive data file 5Account will ask the question whether you wish to replace the file. The answer is 'Yes' as 5Account does not actually replace the file but adds the next set of transactions to it. However, if the archive selected is not associated with the 5Account database being archived 5Account will not allow you to proceed.
Please note that this may be a relatively long procedure due to the complexity of the archiving procedure and the checking that must occur amongst the accounts/categories. A progress bar in the bottom right hand of the screen will show the progress to date.
CSelect 'Archiving' from the File Menu, then select Recover Archived Data. The shortcut key is Shift-Ctrl-V. You may also recover one account, in this instance select the Recover Single Account option, shortcut Shift-Ctrl-Q.
The restore dialog box will be displayed. Select the archive from which you wish to restore the data from and then set the date range to use. If you have selected the single account recovery then a drop-down list box will be diaplayed where you should select the account to recover. Press OK to start the restoration procedure.
Restored transactions will be set to 'Reconciled' and the affected accounts/categories will be updated.
Please note that this may be a relatively long procedure due to the complexity of the restoration procedure and the checking that must occur amongst the accounts/categories. A progress bar in the bottom right hand of the screen will show the progress to date.
MEPlease note that this option is only available for registered users.
The import of data from 5Account running on the Series 5/GeoFox-One is undertaken with the following steps.
From 5Account.
From the menu select File, then Archiving, then PC Export. 5Account will then create a file called PCExport.csv which will be in the folder C:\
PC Connection.
Ensure that your Psion is connected to your PC and that the Remote Link is set to Cable.
Invoke Windows Explorer on your PC and navigate to My Psion, then Internal (C:)
Within this directory you will find a file called PCExport.csv. Using Windows Explorer drag this file from the open directory to the following directory on the PC:
C:\PC5Account (or the directory to which you installed PC5Account)
Start the PC version of PC5Account.
Start up PC5Account.
Now you have two choices, import the data into an existing database or import the data into a fresh database. If you wish to import the data into your existing database miss out the following step.
Clear Database.
Select File|Clear Database.
This function will reset the PC database and remove all the data.
Import the data.
Select File|Import Series 5 data.
This function will open the PCExport.exp file and import the data into the PC5Account
database.
You have now successfully imported your Series 5 data into PC5Account.
aFThe left and right arrow keys will switch you between the views.
Pressing the Enter key on an Account or a Category will open the Transactions View associated with that account or category. In the Transactions View for Accounts you can enter a new transaction by pressing the space bar. This has no effect in the Transactions View within Categories.
Pressing the Enter key on a transaction within the Transactions View within the Accounts View will open a pop-up menu that will allow you to Reconcile/Unreconcile the transaction, modify it or delete it. Pressing Ctrl-R in this view will reconcile/unreconcile the highlighted transaction.
Pressing the Enter key in the Standing Orders view will automatically open the modify Standing Order dialog box. Pressing the spacebar within this view will add a new Standing Order.
Pressing the PgUp (Fn UpArrow) and PgDn (Fn DownArrow) keys within any view will scroll the list up/down one full page (depending upon your screen size).
Pressing the Home (Fn LeftArrow) or End (Fn RightArrow) keys will place the cursor at the top or bottom of the list of the currently selected view.
Pressing the Tab key on a highlighted account or category will open the Account/Category Details dialog box. In here you can specify a reference for the account/category and store up to 255 characters of information for each account/category. If you press the Tab key on a transaction line then the Transaction Details dialog box will open that will show you the full details of the particular transaction.
The Escape key is used to 'go back'.
CTapping in the top right hand side button bar will switch the view left if tapping on the left icon, right if tapping on the right icon, up/down a line if tapping on the single up/down arrows or page up/page down if tapping on the double up or double down arrows. Tapping on the close window icon will close 5Account.
Tapping on one of the three tabs (Accounts/Categories/Standing Orders) will switch the current view to the view tapped.
Double tapping on an account or a category will open the transactions view for that account/category. Double tapping on a transaction within the Accounts View will open a pop-up menu that will allow you to Reconcile/Unreconcile the transaction, modify it or delete it. Double tapping on a transaction within the Categories view has no effect.
"BIn both the Accounts and categories Views there are two filters that may be invoked to display the data.
Date Up/Down
Tapping on the grey Date Header will sort the listed transactions in ascending or descending order. 5Account defaults to descending (showing the latest first).
Reconciled/Unreconciled
Tapping on the 'Tick' header will filter only those transactions that are unreconciled or all transactions. This is a useful feature when reconciling an account.
Note that these filters are in addition to the fonts and font sizes available.
A5Account has a selection of three fonts, Arial, Courier and Times Roman.
These fonts may be zoomed in and out for three sizes to allow for your own preferences.
5Account defaults to Arial, middle size.
The font can be changed from within the Preferences section, which can be found under File, Preferences.
Zooming is performed by tapping on the zoom in/out button on the Series 5 screen or by pressing Ctrl-M or Shift-Ctrl-M.
rCIn the current version of 5Account there is a print option in the Transaction List View within Accounts and Categories.
When in either of these views the printer button will be displayed in the bottom window. Tapping on this button will open a dialog box that offers you the choice of printing the transactions directly to the printer, an HTML file or create a CSV output file (this can be imported into a spreadsheet). If you select either the HTML or CSV options then a further dialog box will be opened that allows you to specify the name and location of the resultant file that will be created. If there is an existing file of that name you will receive a warning, which can be ignored if desired.
Please note that the print will be the same as that displayed, so the options that you have set will be used for the printed output.
See 'Display Options' for more information.
NSimply put, double-entry bookkeeping means that each transaction in the system will result in the value being booked in to two separate accounts. The only difference between the two is that one side of the booking is positive whilst the other side is negative.
In a basic general ledger there are only four account types:
Asset
Liability
Expense
Revenue
Typically, a Revenue (Income) posting will post, on the other side, to an Asset account and an Expense posting will post, on the other side, to a Liability account.
The most 'odd' thing about a double-entry bookkeeping system is that Income accounts appear in the negative, whilst Expense accounts appear positive.
The easiest way in which to explain why this occurs is to think of a bank account. If money is paid in to the bank account this is a positive entry to the account. The other side of the posting has to be a negative value of the same amount and, typically, money paid in is income. This means that if you received $100 as income and paid this in to your bank account the result will be as follows:
Bank Account: +100
Income Account : -100
Therefore Income is treated as a negative value in a double-entry bookkeeping system.
Generally a small business runs with a few customers and a few suppliers. The customers are set up in the accounting system by name and their associated accounts are Assets. The suppliers are set up in the accounting system by name and their corresponding accounts are Liabilities.
An example would be a business with one customer 'Joe Bloggs' and one supplier 'A Supplier'. Two accounts would be created:
Joe Bloggs - Asset
A Supplier - Liability
This business would have a bank account, set up as 'Bank Account':
Bank Account - Asset (Bank in 5Account)
This business would need to know about the Income and Expenses incurred and this would result in two new acccounts:
Sales - Revenue (Income category in 5Account)
Expenditure - Expense (Expense category in 5Account)
A small business could run on these five accounts. In summary, they are as follows:
Bank Account (Asset)
Joe Bloggs (Asset)
A Supplier (Liability)
Sales (Revenue)
Expenditure (Expense)
The business gets an order from 'Joe Bloggs' and has to buy some goods. This would result in an invoice from 'A Supplier' for, say, $1000. This invoice would be entered as follows:
A Supplier - $1000 debit, category 'Expenditure'
After resupplying these goods to 'Joe Bloggs' the business would raise an invoice to 'Joe Bloggs' for, say, $1500. This sales invoice would be entered as follows:
Joe Bloggs - $1500 credit, category 'Sales'
At this point the accounts would look like:
Bank Account - $0
Joe Bloggs - $1500
A Supplier - $1000-
Sales - $1500-
Expenditure - $1000
'Joe Bloggs' pays the invoice and this sum is entered into the bank account as follows:
Joe Bloggs - $1500 Transfer, transfer account 'Bank Account'
Now the accounts will look like this:
Bank Account - $1500
Joe Bloggs - $0
A Supplier - $1000-
Sales - $1500-
Expenditure - $1000
The business now pays the supplier with acheque and this entry will be entered in the system as:
Bank Account - $1000 transfer, transfer account 'A Supplier'
Bank Account - $500
Joe Bloggs - $0
A Supplier - $0
Sales - $1500-
Expenditure - $1000
We can now see that the business has received $1500 in sales, with $1000 in expenditure, resulting in a profit of $500. This $500 is now sitting in the bank account.
The above example was a very simple example to demonstrate how you would build a chart of accounts. Of course, it will not be as simple as the example as most of us would want to know a little more about our spending patterns and would, therefore, have a lot more expense accounts.
Export to CSV
B00750#
Overview
Series 5 Sheet Import
Overview
B00755G
Series 5 Sheet Import
B00760H
5 Archiving
B00800-
Overview
Archiving Data
Restoring Data
Overview
B00810J
Archiving Data
B00820K
Restoring Data
B00830L
PC Data Export
B00840M
Navigation
B00900?
Using the keyboard
Using the pen/pointer
Display Options
Using the keyboard
B00910N
Using the pen/pointer
B00920O
Display Options
B00930P
Miscellaneous
B01000;
Fonts and suchlike
Printing
Double-entry bookkeeping
Fonts and suchlike
B01010Q
Printing
B01020R
Double-entry bookkeeping
B01030S
DAn account is added to 5Account from the Accounts view. Navigate to the Accounts view by pressing Shift-Ctrl-A, or by tapping on the Accounts box in the top of the main window or by using the menu items View, Switch View, Accounts.
When you are in the Accounts view press the spacebar, Ctrl-I or Menu, Accounts, Add Account to open the Add Account dialog box.
In this dialog box give your new account a meaningful descriptive name, select the type of account from the list of Bank, Credit Card, Asset or Liability, enter an opening balance as a positive number and then select the sign by selecting Asset or Liability.
An example would be a credit card with an opening balance of
600 owing. This would be entered as follows:
Account Name : Mastercard
Account Type : Credit Card
Opening Balance : 600
Type of balance : Liability
An asset, like a bank account with a positive balance would be entered as follows:
Account Name : Barclays Bank
Account Type : Bank
Opening Balance : 1104.56
Type of balance : Asset
It is important that you ensure the opening balance of an account is correct. Usually you will obtain this number from the closing balance on a bank statement or such like.
@A category is added to 5Account from the Categories view. Navigate to the Categories view by pressing Shift-Ctrl-T, or by tapping on the Categories box in the top of the main window or by using the menu items View, Switch View, Categories.
When you are in the Categories view press the spacebar, Ctrl-I or Menu, Categories, Add Category to open the Add Category dialog box.
In this dialog box give your new category a meaningful descriptive name, select the type of account from the list of Income or Expense, enter an opening balance as a positive number and then select the sign by selecting Debit or Credit.
An example would be your salaryR
with an opening balance of
6000 accrued to date. This would be entered as follows:
Category Name : My Salary
Category Type : Income
Opening Balance : 6000
Type of balance : Debit
An expense category would be entered as follows:
Category Name : Food and drink
Category Type : Expense
Opening Balance : 455.67
Type of balance : Credit
|DFirstly, switch to the Standing Orders View.
Press the space bar, this will open and display the Standing Orders entry dialog box.
Enter a description of the Standing Order and the amount. Select a 'From Account' from the list box and then select the 'To Account' from the list box. Both the From and To accounts can be either Accounts or Categories, but must not be the same. 5Account will check this when you press the OK button and will not allow a Standing Order to be created where the From and To accounts/categories are the same.
The number of transactions defaults to '9999'. This means to 5Account that there is no end date or number of transactions - in other words the Standing Order will occur forever.
If you wish to enter a fixed number of payments (a car loan, for example, is typically over a two year period and would get the number 24 if monthly payments) then overwrite the 9999 default to the number of periodic payments that will be made.
If you wish to enter an end date then overwrite the number of payments from 9999 to 0. Pressing OK will then display a second dialog box that will request the entry of the end date.
CTransactions are entered via the 'Accounts View', and are entered against the account highlighted.
To enter a transaction switch to the Accounts View and select the account in which you wish the transaction to appear. Press Enter or double tap on the account to display the transactions view within the account selected.
When the transaction list is displayed you may then enter a new transaction by pressing the space bar which will open up the transaction entry dialog box.
The transaction entry dialog box assumes that the other side of the transaction posting will be allocated to a category and the category list is an option within this box. However, if you wish to make a transafer between accounts then select 'Transfer' instead of 'Debit' or 'Credit' and ignore the category selection list box. A second dialog box will appear after pressing the OK button which gives you a list of the accounts to which you can transfer the amount entered in the transaction entry dialog box.
AIt is a common problem when you have many transactions and you want to make an adjustment yet the other side of the transaction has been reconciled. To see the other side of any transaction just highlight the transaction in question and press the Tab key.
A dialog box will open that will display the full details of the transaction, including the other account/category to which is was posted.
BOnce you have added your own home currency and set the conversion rate to 1.0 you need to ensure that 5Account will always know which is your home currency.
This is undertaken within the Preferences settings.
Press the Menu Key, then Access the File Menu, then Preferences.
The first field shown is the Home Currency. Select your home currency in this field. Then set the way in which you wish 5Account to display the currency by selecting the currency options.
See the 'Preferences' section for further help.
B01010
B01020
B01030
B01100
B01110
B01120
B01130
B01140
B01142
B01145
B01150
B01160
BThe Archiving system within 5Account will only allow the archive and recovery to be performed within its own database so it is not possible to recover an archive created by one 5Account database into another, different, 5Account database.
So, how do you undertake this transfer of data between 5Account databases?
The answer is to use the QIF Import/Export facility.
Load the 5Account database from which you will be transferring data from and export a QIF file of the account. Close this 5Account database and load the receiving database.
Use the QIF Import option to import the previously exported account.
In essence, this is the same as importing/exporting data to another money-based system, QIF files are the answer!
BBNLy
How Do I ... ?
B01100
Add an Account
Add a Category
Add a Standing Order
Enter a Transaction
Enter regular unknown transactions
See the 'other' side of a transaction
Set my home currency
Transfer data
Add an Account
B01110U
Add a Category
B01120V
Add a Standing Order
B01130W
Enter a Transaction
B01140X
Enter regular unknown transactions
B01142
This is done by creating a standing order with a value of zero.
This is explained more fully under the topic 'Adding a Standing Order' under the 'Standing Orders' main topic.
See the 'other' side of a transaction
B01145Y
Set my home currency
B01150Z
Transfer data
B01160\
B00760
B00800
B00810
B00820
B00830
B00840
B00900
B00910
B00920
B00930
B01000
B01010
B01020
B01030
B01100
B01110
B01120
B01130
B01140
B01142
B01145
B00490
B00491
B00492
B00495
B00500
B00510
B00520
B00530
B00540
B00600
B00610
B00620
B00630
B00640
B00650
B00700
B00710
B00720
B00730
B00750
B00755
B00210
B00230
B00240
B00250
B00260
B00300
B00310
B00320
B00330
B00340
B00350
B00400
B00410
B00420
B00430
B00440
B00442
B00450
B00460
B00470
B00480
A0000
A0010
A0020
B00000
B00005
B00008
B00010
B00050
B00060
B00065
B00070
B00080
B00100
B00110
B00120
B00125
B00130
B00135
B00140
B00150
B00200
9d9Gl
VUUUlUUU
TUUUEUUUUTUUU
WUUU|UUU
WUUU|UUU
UUUU\UUU
UUUU\UUU
WUUU|UUU
WUUU|UUU
UUUU\UUU
UUUU\UUU
WUUU|UUU
WUUU|UUU
UUUU\UUU
UUUU\UUU
|UUUU
\UUUU
"5Account
D:\OPP\5Account\5Account.pre)
DATEFORMAT%
PRINTERPAGESIZE%
PRINTERMEASURE%
PRINTERFONTHEIGHT%
PRINTERORIENTATION%
PRINTERMARGIN
PRINTERNUMBERTABS%
PRINTERHEADER$
PRINTERFOOTER$
PRINTERCURRENTPOSITION&
PRINTERLEFTMARGIN&
PRINTERPRINTWIDTH&
PRINTERPRINTHEIGHT&
TABPOS&
TABALIGN%
NUMHEADERS%
HEADER$
TABSTOP%
TABPOS$
TABWIDTH%
TEXTWIDTH%
STARTLINE%
NUMBERLINES%
TOTALSELECTION%
STARTPOSITION%
ENDLINE%
CURRENTSELECTION%
WINDOWFONT&
WINDOWCAPTION$
DOWNB%
CLOSEB%
WINDOWSBITMAP$
UPDOWNBUTTONS%
PC_BAR&
PCB_START&
PCB_TOTAL&
PCB_OLD%
PCB_SHOW%
APPTITLE$
APPVER$
APPEMAIL$
APPYEAR$
APPAUTHOR$
SPLASHID&
SPLASHXPOS%
SPLASHYPOS%
GEOFOX1%
REVO%
OSARIS%
SERIES5%
ACTLINES%
SOLINES%
TRNLINES1%
TRNLINES2%
BTLINE%
SCREENHEIGHT%
SCREENWIDTH%
MAINSCREENHEIGHT%
MENUSELECT%
THREAD&
MAINWINDOW%
TOPWINDOW%
HEADERWINDOW%
BOTTOMWINDOW%
CLOSEWINDOW%
BUTBARWINDOW%
CONTROLWINDOW%
PRINTBWINDOW%
CLOSEB&
HEADACCT&
TRANACCT&
TRANACCT2&
TRANACCT3&
TRANACCT4&
BUTBAR&
BUTBAR2&
BUTBAR3&
TICK&
TICK2&
NOTICK&
BOT01&
SOHEAD&
HEADCAT&
SCRUP&
SCRDN&
CONTROL&
PRINTB&
BMPFILENAME$
PREFS&
FIRSTTIME%
REGISTEREDUSER%
REGTRANS%
USERNAME2$
TVIEW%
FROMDATE&
TODATE&
CURRENTFONTHEIGHT%
PRINTLINES%
UPDATEFAST%
FASTACCOUNTS%
FASTCATEGORIES%
FASTEXPENSES%
NUMBERACCOUNTS%
NUMBERTRANSACTIONS%
NUMBERSORDERS%
NUMBERSUORDERS%
CURRENTPOINTER%
TOPRECORD%
TRANSACTIONVIEW%
TRANSACTIONPOINTER%
ACCOUNTPOINTER%
TRANSACTIONACCOUNT$
NUMINVLINES%
P_INUM&
STARTDT&
ENDDT&
ACDETS&
MBUFFER&
MBUFFER2&
X_ACNO%
X_AT$
POPULATEWINDOW
CHECKSO
KEYLOOP
(^!%'
SHOWSPLASH
INITIALISE
APPTITLE$
APPVER$
APPEMAIL$
APPYEAR$
APPAUTHOR$
SPLASHXPOS%
SPLASHYPOS%
SPLASHID&
5Account
Simon@PocketIQ.com
+ 1998-2000
Simon Berridge
APPYEAR$
APPAUTHOR$
SPLASHID&
SPLASHXPOS%
SPLASHYPOS%
APPTITLE$
APPVER$
APPEMAIL$
C:\SYSTEM\OPL\PIQInfo.rscW
C:\SYSTEM\OPL\PIQInfo.rsc
D:\SYSTEM\OPL\PIQInfo.rscW
D:\SYSTEM\OPL\PIQInfo.rsc
E:\SYSTEM\OPL\PIQInfo.rscW
E:\SYSTEM\OPL\PIQInfo.rsc
C:\SYSTEM\OPL\PIQInfo.mbmW
C:\SYSTEM\OPL\PIQInfo.mbm
D:\SYSTEM\OPL\PIQInfo.mbmW
D:\SYSTEM\OPL\PIQInfo.mbm
E:\SYSTEM\OPL\PIQInfo.mbmW
E:\SYSTEM\OPL\PIQInfo.mbm
+$C:\SYSTEM\APPS\5Account\5Account.aifW
+$C:\SYSTEM\APPS\5Account\5Account.aif
+$D:\SYSTEM\APPS\5Account\5Account.aifW
+$D:\SYSTEM\APPS\5Account\5Account.aif
+$E:\SYSTEM\APPS\5Account\5Account.aifW
+$E:\SYSTEM\APPS\5Account\5Account.aif
& Pocket IQK
OxO,O
SPLASH
SPLASHXPOS%
SPLASHYPOS%
APPTITLE$
APPVER$
APPYEAR$
APPAUTHOR$
APPEMAIL$
C:\SYSTEM\OPL\PIQInfo.opoW
C:\SYSTEM\OPL\PIQInfo.opo
D:\SYSTEM\OPL\PIQInfo.opoW
D:\SYSTEM\OPL\PIQInfo.opo
E:\SYSTEM\OPL\PIQInfo.opoW
E:\SYSTEM\OPL\PIQInfo.opo
5AccountO
About
+ version K
Copyright (C)
& Pocket IQKO
http://www.pocketIQ.comO
PCBARLOAD
SYSTEMPATH$
GETPREFS
SETUPLINES
CREATEWINDOWS
INPP$
SHOWREGISTRATION
PAPEROUT%
PUTPREFS
WRAP$
NEWDATABASE
CHECKDATABASE%
OPENDATABASE
ALLCHECKS
OPENALLTRANSACTIONS
REGISTEREDUSER%
WINDOWSBITMAP$
UPDOWNBUTTONS%
ACDETS&
UPDATEFAST%
FASTACCOUNTS%
FASTCATEGORIES%
FASTEXPENSES%
TVIEW%
FIRSTTIME%
TRANSACTIONVIEW%
BMPFILENAME$
NUMBERACCOUNTS%
NUMBERTRANSACTIONS%
NUMBERSORDERS%
NUMBERSUORDERS%
PREFS&
DATEFORMAT%
SCREENHEIGHT%
SCREENWIDTH%
MAINSCREENHEIGHT%
GEOFOX1%
REVO%
OSARIS%
SERIES5%
USERNAME2$
REGTRANS%
(^!%'
Initialising
Windows.mbmK
OT{WK
OT{WK
5Account.mbmK
Password protection failed
Initialising
Registered to+
Cannot Continue
Cannot Continue
(^!%'
Password Entry
Password
CancelO
DOSTOP
DOMENU
FONTUP
FONTDOWN
MWKEYPRESS
MWOTHERPRESS
DOPENTAP
DOSWITCHING
CHECKOTHERKEYS
(^!%'
O {AO
O {AO
O`{Ix
O@{Ix
DOSWITCHING
REGISTEREDUSER%
PREFS&
TRANSACTIONVIEW%
NUMBERACCOUNTS%
NUMBERTRANSACTIONS%
NUMBERSORDERS%
MENUSELECT%
(^!%'
+ Archiving+
Archive reconciled itemsOv+
Archive One AccountOqh+
Recover Archived DataOV+
Recover Specific AccountOQh+ PC ExportO
+ Archiving+
Archive reconciled itemsOv+
Archive One AccountOqh+
Recover Archived DataOV+
Recover Specific AccountOQ
File+
Personal InformationOP+
PreferencesOph+
New...On+
Open...Oo+
Database InformationOdh+
QIF Export/ImportOx+
Archiving>O
ExitOe
Accounts+
Add AccountOi
Accounts+
Add AccountOi+
Modify AccountOC+
Adjust BalancesOJh+
Extract DataOX
Transactions+
Add TransactionOih+
Jump To AccountOj
Transactions+
Add TransactionOi+
Reconcile TransactionOrh+
Delete TransactionOkh+
Jump To AccountOj
Category+
Add CategoryOi
Category+
Add CategoryOi+
Modify CategoryOCh+
Reset BalancesOr+
Adjust BalancesOJh+
Extract DataOX
Orders+
Add Standing OrderOi
Orders+
Add Standing OrderOi+
Modify Standing OrderOCh+
Update Standing OrdersOuh+
Delete Standing OrderOk
Invoice Views+
Finished Invoice ListOW+
Unfinished InvoicesOU+
View Finished InvoicesOF
Invoices+
Create InvoiceOs+
Add Line ItemOt+
Finalise InvoiceOfh+
Invoice Views>O
Print InvoiceOK
Clients+
Add ClientOl+
Modify ClientOO+
Delete ClientODh+
Client ListOLh+ Invoices>O
Data Views+ Net WorthON+
Income and ExpensesOI
Switch View+
AccountsOA+
CategoriesOT+
Standing OrdersOS
View+
Data Views>O
Zoom InOm+
Zoom OutOMh+
Switch View>O
Currency+
Add CurrencyOc+
Modify CurrencyOuh+
Currency ConverterOy
Printing+
Balance SheetOB+
Profit & LossOH
Help+
ContentsOh+
AboutOa
Help+
ContentsOh+
AboutOah+
Register 5AccountOR
TRANSWITCHING
ACCTSWITCHING
GENSWITCHING
CATSWITCHING
SOSWITCHING
PREFS&
TRANSACTIONVIEW%
(^!%'
ADDACCOUNT
MODACCOUNT
ADJUSTACCOUNT
EXTRACTDATA
GENSWITCHING
(^!%'
ADDCATEGORY
POPULATEWINDOW
MODCATEGORY
ADJUSTACCOUNT
RESETBALANCES
EXTRACTCATDATA
GENSWITCHING
(^!%'
ADDSO
MODSO
UPDATESTANDINGORDERS
DELSORDER
GENSWITCHING
(^!%'
ADDTRANSACTION
RECONTRANSACTION
DELETETRANSACTION
JUMPTOACCOUNT
GENSWITCHING
(^!%'
DOSTOP
NEWDATABASE
POPULATEWINDOW
DOOPENFILE
PREFERENCES
SHOWDBNAME
ARCHIVERECON
ARCHIVEONE
RECOVERARCHIVE
RECOVERSPECACCOUNT
EXPIMP
PERSONALINFO
EXPORTTOPC
CREATEINVOICE
ADDLINEITEM
VIEWUNFINISHED
VIEWFINISHED
FINISHINVOICE
PRINTINVOICE
FININVOICELIST
ADDCLIENT
VIEWCLIENTS
MODIFYCLIENT
DELETECLIENT
FONTUP
FONTDOWN
SWITCHACCOUNTS
SWITCHCATEGORIES
SWITCHSORDERS
VIEWBALSHT
VIEWPROFITANDLOSS
ADDCURRENCY
MODCURRENCY
CONCUR
PRINTBALANCESHEET
PRINTPROFITANDLOSS
ABOUT
REGISTERACCT
(^!%'
SYSTEMPATH$
THREAD&
(^!%'
5Account.hlpK
Cannot find help file
PCBARUNLOAD
WRAP$
SHOWREGISTRATION
PUTPREFS
THREAD&
PREFS&
(^!%'
Shutting down, please wait...
Shutting down, please wait...
DOSTOP
BUTBARTAP
MAINWINDOWTAP
HEADERWINDOWTAP
CONTROLWINDOWTAP
PRINTBWINDOWTAP
CLOSEWINDOW%
BUTBARWINDOW%
MAINWINDOW%
HEADERWINDOW%
CONTROLWINDOW%
PRINTBWINDOW%
(^!%'
TODAY&
POPULATEDATETRANSACTIONS
PRINTTRANSACTIONS
HTMLTRANSACTIONS
CSVTRANSACTIONS
POPULATETRANSACTIONS
FROMDATE&
TODATE&
(^!%'
Output
+ Output to+
Printer,HTML file,CSV Output
Date Range
CancelO
Date Range
+ From dateO
Up to dateO
CancelO
From date > To Date
SWITCHACCOUNTS
SWITCHCATEGORIES
SWITCHSORDERS
SERIES5%
REVO%
(^!%'
OM{1[
OM{9 C
O1{1[
O1{9 C
Ob{1\[
Ob{9[
ACCOUNTSARROW
(^!%'
FINDLINE%
REPOSCURSOR
PREFS&
TRANSACTIONVIEW%
(^!%'
O`{9 *
O{{1\[
O {Mx
O@{9 *
O[{1\[
ADDTRANSACTION
ADDACCOUNT
ADDCATEGORY
POPULATEWINDOW
ADDSO
TRANTAP2
HIGHLIGHT
MODSO
FINDLINE%
REPOSCURSOR
DELSORDER
DELETEACCOUNT
DELETETRANSACTION
SHOWTRAN
SHOWACCOUNTDETAILS
PREFS&
TRANSACTIONVIEW%
NUMBERACCOUNTS%
TRANSACTIONPOINTER%
TOPRECORD%
CURRENTPOINTER%
TRANSACTIONACCOUNT$
(^!%'
+ Add transaction in Accounts only
O @[2
OPENDATABASE
(^!%'
UPDATEBUTBAR
UPDATEHEADERWINDOW
UPDATEBOTTOMWINDOW
CALCULATENUMBERS
SERIES5%
TRANACCT&
BMPFILENAME$
SOHEAD&
HEADACCT&
HEADCAT&
BOT01&
CONTROL&
TRANACCT3&
REVO%
BUTBAR&
BUTBAR2&
BUTBAR3&
TICK&
NOTICK&
CLOSEB&
SCRUP&
SCRDN&
PRINTB&
TRANACCT2&
TRANACCT4&
TICK2&
TOPWINDOW%
SCREENWIDTH%
CLOSEWINDOW%
BUTBARWINDOW%
CONTROLWINDOW%
HEADERWINDOW%
MAINWINDOW%
SCREENHEIGHT%
BOTTOMWINDOW%
PRINTBWINDOW%
(^!%'
CALCULATENUMBERS
HIGHLIGHT
DRAWMAINWINDOW
PREFS&
(^!%'
CHANGEFONT
PREFS&
(^!%'
Maximum Font Size reached
CHANGEFONT
PREFS&
(^!%'
Minimum font size reached
FONTHEIGHT&
MAINWINDOW%
PREFS&
CURRENTFONTHEIGHT%
NUMBERLINES%
MAINSCREENHEIGHT%
(^!%'
UPDATECONTROL
TOPWINDOW%
SERIES5%
REVO%
(^!%'
CONTROLWINDOW%
PREFS&
CONTROL&
(^!%'
N_UNREGISTERED5ACCOUNT%
(^!%'
ACCOUNTSARROW
TAPLEFT
TAPRIGHT
TRANTAPLEFT
PREFS&
TRANSACTIONVIEW%
(^!%'
O${1\[
O${9 A
O6{1\[
O6{9 A
OH{1\[
OH{9 A
OZ{1\[
OZ{9[
O${1\[
O${9 A
O6{1\[
O6{9 A
OH{1\[
OH{9 A
OZ{1\[
POPULATEWINDOW
PREFS&
(^!%'
POPULATEWINDOW
PREFS&
TRANSACTIONVIEW%
(^!%'
POPULATEWINDOW
PREFS&
TRANSACTIONVIEW%
(^!%'
POPULATEWINDOW
PREFS&
TRANSACTIONVIEW%
(^!%'
POPULATEWINDOW
PREFS&
(^!%'
PREFS&
TRANSACTIONVIEW%
BUTBAR2&
BUTBAR&
BUTBAR3&
BUTBARWINDOW%
(^!%'
TRANSACTIONVIEW%
HEADERWINDOW%
PREFS&
SCRDN&
SCRUP&
(^!%'
{IWC_
HEADERWINDOW%
PREFS&
SOHEAD&
TRANSACTIONVIEW%
TVIEW%
TRANACCT&
TRANACCT3&
TRANACCT2&
TRANACCT4&
HEADACCT&
HEADCAT&
(^!%'
BOTTOMWINDOW%
PREFS&
BOT01&
SCREENWIDTH%
PRINTBWINDOW%
TRANSACTIONVIEW%
(^!%'
MONEY$
BOTTOMWINDOW%
PREFS&
BTLINE%
ACCOUNTPOINTER%
(^!%'
O#{IW
O+{IW
O3{IW
FINDLINE%
POPULATEWINDOW
REPOSCURSOR
TRANSACTIONACCOUNT$
TRANSACTIONVIEW%
TRANSACTIONPOINTER%
(^!%'
USERNAME2$
(^!%'
NHSCIZDQ_AMWLRGYTJVBOXEKUPF
OTZ_AFCHYQJGBVMWKDRXNSLEPIU
Z_DRXYQJCHGBIVMPNSAFKUTOEWL
JCZWLUTQBDHMPGRXKEYIVNS_FAO
(^!%'
ABCDEFGHIJKLMNOPQRSTUVWXYZ
(^!%'
(^!%'
(^!%'
PAPEROUT%
PUTPREFS
REGISTEREDUSER%
PREFS&
USERNAME2$
(^!%'
Already registered
(^!%'
5Account Registration
PasswordO
CancelO
(^!%'
Not a correct password!
(^!%'
Welcome!
Welcome to 5Account(
N_ADDACCOUNT%
NEXTNUMBER&
OPENACCOUNTS
POPULATEWINDOW
UPDATEFAST%
(^!%'
ACCOUNTO
ACKEY%$
ACNAME$'
ACTYPE%$
OPBAL&
RECBAL&
CURBAL&
BSPL$'
N_ADDCAT%
NEXTNUMBER&
OPENCATEGORIES
UPDATEFAST%
(^!%'
ACCOUNTO
ACKEY%$
ACNAME$'
ACTYPE%$
OPBAL&
RECBAL&
CURBAL&
BSPL$'
OPENACCOUNT
N_MODIFYACCOUNT%
POPULATEWINDOW
TOPRECORD%
CURRENTPOINTER%
UPDATEFAST%
(^!%'
ACNAME$#
ACTYPE%
OPBAL"
OPBAL"
OPBAL"
ACNAME$'
ACTYPE%$
RECBAL&
RECBAL"
OPBAL"
CURBAL&
CURBAL"
OPBAL"
OPBAL&
O+{I+
RECBAL"
O3{I+
CURBAL"
OPENACCOUNT
N_MODIFYCAT%
POPULATEWINDOW
TOPRECORD%
CURRENTPOINTER%
UPDATEFAST%
(^!%'
ACNAME$#
ACTYPE%
OPBAL"
OPBAL"
OPBAL"
ACNAME$'
ACTYPE%$
RECBAL&
RECBAL"
OPBAL"
CURBAL&
CURBAL"
OPBAL"
OPBAL&
O+{I+
RECBAL"
O3{I+
CURBAL"
TRANSACTIONSTHERE%
OPENACCOUNT
POPULATEWINDOW
PREFS&
TOPRECORD%
CURRENTPOINTER%
(^!%'
Delete Account
Delete Category
+$Are you sure you want to delete thisO
Account+
Category+
NoOn(
YesOy(
+"Transactions exist, cannot delete.
OPBAL"
RECBAL"
CURBAL"
|F`[$
Balances not equal to zero!
Account removed
Category removed
OPENCATEGORIES
INIT_BAR
CURRENCY
UPDATEBAR
DESTROYBAR
POPULATEWINDOW
PREFS&
(^!%'
OPBAL"
RECBAL"
CURBAL"
RECBAL&
CURBAL&
OPBAL&
OPENACCOUNT
CURRENCY
POPULATEWINDOW
FINDLINE%
REPOSCURSOR
TOPRECORD%
CURRENTPOINTER%
X_ACNO%
X_AT$
TRANSACTIONACCOUNT$
PREFS&
(^!%'
CURBAL"
OPBAL"
RECBAL"
Adjust Account Balances
CalcOc+
CalcItCB+
CancelO
CheckBalCB+
Opening Balance+
Reconciled Balance+
Current Balance+
CURBAL&
OPBAL&
RECBAL&
CHECKTHESEBALANCES%
X_ACNO%
X_AT$
(^!%'
CURRENCY
CALCNEWBALS
X_ACNO%
PREFS&
X_AT$
(^!%'
OPENACCOUNTTRANSACTIONS
OPENCATEGORYTRANSACTIONS
CURRENCY
MONEY$
PREFS&
(^!%'
Checking, please wait...
TSIGN$#
TCONV"
TCONV"
TSIGN$#
TCONV"
TCONV"
TREC$#
Warning!O
I calculate different values:
Opening Balance
Reconciled Balance
Current Balance
+ Do you wish to use your numbers?O
NoOn(
YesOy(
CURRENCY
OPENACCOUNTTRANSACTIONS
OPENCATEGORYTRANSACTIONS
PREFS&
(^!%'
Checking, please wait...
TSIGN$#
TCONV"
TCONV"
TSIGN$#
TCONV"
TCONV"
TREC$#
N_ADDCURRENCY%
OPENCURRENCY
(^!%'
CURKEY$'
CURNAME$'
CONVRATE&
OPENCURRENCY
(^!%'
Modify Currencies
CURKEY$#
Currency+
+ LookCurCBO
Name+
Rate+
Update?+
Store new information+
UpdateCurCB+
+ LookCurCB+
OPENCURRENCY
(^!%'
CURNAME$#
CONVRATE"
OPENCURRENCY
(^!%'
CURNAME$'
CONVRATE&
OPENCURRENCY
CURRENCY
PREFS&
(^!%'
CONVRATE"
OPENCURRENCY
DOERROR
MONEY3$
(^!%'
Not enough currencies availableO
Currency ConverterO
Currency+
CURNAME$#
Currency+
CURNAME$#
,...K
Currency+
CURNAME$#
Currency+
CURNAME$#
,...K
Amount to convert)
ConvertO
CancelO
Both the same currency!O
CURNAME$#
CONVRATE"
CURNAME$#
CONVRATE"
ConversionO
From CurrencyO
Amount
To CurrencyO
Converted to
AgainO
CancelO
OPENCURRENCY
(^!%'
CURKEY$#
CURNAME$#
OPENCURRENCY
(^!%'
CURKEY$#
WRAP$
OPENCURRENCY
CREATECLIENTDATA
CREATEPERSONAL
CREATEPERSONAL2
CREATEACCOUNTDETS
PUTPREFS
PREFS&
(^!%'
Creating New Database
+% FIELDS numkey(10),nextnum TO NumbersK
NUMKEY$
NEXTNUM&
numkey_
ByKey
Numbers
SELECT * FROM NumbersK
NUMKEY$
NEXTNUM&
NUMKEY$'
ACCOUNT
NEXTNUM&%
NUMKEY$'
SORDER
NEXTNUM&%
NUMKEY$'
TRANS
NEXTNUM&%
+G FIELDS ackey,acname(30),actype,opbal,recbal,curbal,bspl(1) TO AccountsK
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
acname_
ByName
Accounts
actype_
acname_
ByType
Accounts
+x FIELDS tranno,tdate,tref(10),tdets(30),tsign(1),tamount,tcurr(3),tconv,tprim,talloc(1),tsec,trec(1),tsectranno TO TransK
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
tprim_
tdate_
+ ByPrimary
Trans
tsec_
tdate_
BySecondary
Trans
tprim_
tdate_
ByPrimaryA
Trans
tsec_
tdate_
BySecondaryA
Trans
+2 FIELDS curkey(3),curname(30),convrate TO CurrencyK
CURKEY$
CURNAME$
CONVRATE
curname_
ByName
Currency
CURKEY$'
CURNAME$'
UK Sterling
CONVRATE&
+V FIELDS ref(10),details(30),fromac,toac,amt,cur(3),nextdt,frq,nument,lastdt TO SOrdersK
DETAILS$
FROMAC%
TOAC%
NEXTDT&
NUMENT&
LASTDT&
nextdt_
ByDate
SOrders
FIELDS details(30) TO FreqUsedK
DETAILS$
details_
ByDets
FreqUsed
WRAP$
PREFS&
(^!%'
+m FIELDS clkey, cname(60),ccon(50),cad1(30),cad2(30),cad3(30),cad4(30),ctel(20),cfax(20),cemail(60) TO ClientsK
CLKEY&
CNAME$
CCON$
CAD1$
CAD2$
CAD3$
CAD4$
EMAIL$
cname_
ByName
Clients
+I FIELDS invnum,clnum,invdt,netamt,vatamt,totamt,fin(1),rec(1) TO InvoicesK
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
invnum_
ByNumber
Invoices
clnum_
invnum_
ByClient
Invoices
+J FIELDS invnum,lndt,lndet(30),lnquant,lnamt,lncur(3),lntot,lnconv TO LinesK
INVNUM&
LNDT&
LNDET$
LNQUANT
LNAMT
LNCUR$
LNTOT
LNCONV
invnum_
lndt_
ByDate
Lines
SELECT * FROM NumbersK
NUMKEY$
NEXTNUM&
NUMKEY$'
CLIENT
NEXTNUM&%
NUMKEY$'
INVOICE
NEXTNUM&%
PREFS&
(^!%'
+t FIELDS head1(50),head2(50),ad1(30),ad2(30),ad3(30),ad4(30),tel(20),fax(20),eml(60),vat(30),pfooter(255) TO PersonalK
HEAD1$
HEAD2$
PFOOTER$
PREFS&
(^!%'
+! FIELDS pfooter(255) TO Personal2K
PFOOTER$
WRAP$
PREFS&
(^!%'
+0 FIELDS ackey, ref(30), info(255) TO AccountDetsK
ACKEY%
INFO$
PREFS&
(^!%'
SELECT * FROM PersonalK
HEAD1$
HEAD2$
PREFS&
(^!%'
SELECT * FROM Personal2K
PFOOTER$
PREFS&
(^!%'
SELECT * FROM AccountDetsK
ACKEY%
INFO$
ACDETS&
PREFS&
(^!%'
O!{I+
SELECT * FROM AccountDetsK
WHERE ackey = K
ACKEY%
INFO$
ACKEY%
REF$#
O!{I+
INFO$#
PREFS&
ACDETS&
(^!%'
SELECT * FROM AccountDetsK
WHERE ackey = K
ACKEY%
INFO$
ACKEY%$
REF$'
INFO$'
O!{IW
PREFS&
(^!%'
SELECT * FROM LinesK
INVNUM&
LNDT&
LNDET$
LNQUANT
LNAMT
LNCUR$
LNTOT
LNCONV
PREFS&
(^!%'
SELECT * FROM LinesK
WHERE invnum = K
INVNUM&
LNDT&
LNDET$
LNQUANT
LNAMT
LNCUR$
LNTOT
LNCONV
PREFS&
(^!%'
SELECT * FROM ClientsK
ORDER BY cnameK
CLKEY&
CNAME$
CCON$
CAD1$
CAD2$
CAD3$
CAD4$
EMAIL$
PREFS&
(^!%'
SELECT * FROM ClientsK
WHERE clkey = K
CLKEY&
CNAME$
CCON$
CAD1$
CAD2$
CAD3$
CAD4$
EMAIL$
PREFS&
(^!%'
SELECT * FROM NumbersK
WHERE numkey = 'K
NUMKEY$
NEXTNUM&
NEXTNUM&!
NEXTNUM&%
NEXTNUM&!
PREFS&
(^!%'
SELECT * FROM NumbersK
WHERE numkey = 'TRANS'K
NUMKEY$
NEXTNUM&
NEXTNUM&%
PREFS&
(^!%'
SELECT * FROM FreqUsedK
ORDER BY detailsK
DETAILS$
OPENFREQUSED
(^!%'
DETAILS$'
PREFS&
(^!%'
SELECT * FROM SOrdersK
ORDER BY nextdtK
DETAILS$
FROMAC%
TOAC%
NEXTDT&
NUMENT&
LASTDT&
N_DATABASECREATE%
CHECKEXTENSION$
N_CONFIRMATION%
CREATEDATABASE
PREFS&
UPDATEFAST%
(^!%'
C:\Documents\5Account.act
New Database cancelled
WRAP$
N_OPENDATABASE%
CHECKEXTENSION$
CHECKDATABASE%
PUTPREFS
ALLCHECKS
POPULATEWINDOW
PREFS&
UPDATEFAST%
(^!%'
Not a valid database
(^!%'
SELECT * FROM Currency K
ORDER BY curnameK
CURKEY$
CURNAME$
CONVRATE
PREFS&
(^!%'
SELECT * FROM Currency K
ORDER BY curnameK
CURKEY$
CURNAME$
CONVRATE
PREFS&
(^!%'
SELECT * FROM Currency K
WHERE curkey = 'K
CURKEY$
CURNAME$
CONVRATE
WRAP$
PREFS&
(^!%'
SELECT * FROM Accounts K
WHERE bspl = 'B' K
ORDER BY actype, acname ascK
ORDER BY acname ascK
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
PREFS&
(^!%'
SELECT * FROM Accounts K
ORDER BY acname ascK
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
PREFS&
(^!%'
SELECT * FROM Accounts K
WHERE ackey = K
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
PREFS&
(^!%'
SELECT * FROM Accounts K
WHERE acname = 'K
ACKEY%
ACNAME$
ACKEY%
OPENACCOUNT
(^!%'
ACTYPE%
PREFS&
(^!%'
SELECT * FROM Accounts K
WHERE ackey = K
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
BSPL$#
WRAP$
PREFS&
(^!%'
SELECT * FROM Accounts K
WHERE bspl = 'P' K
ORDER BY acname ascK
ACKEY%
ACNAME$
ACTYPE%
OPBAL
RECBAL
CURBAL
BSPL$
PREFS&
TRANSACTIONPOINTER%
(^!%'
SELECT * FROM Trans K
WHERE tprim = K
AND trec = 'N'K
{IWC_
ORDER BY tprim asc, tdate descK
ORDER BY tprim asc, tdate ascK
WHERE tsec = K
AND trec = 'N'K
{IWC_
ORDER BY tsec asc, tdate descK
ORDER BY tsec asc, tdate ascK
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
WHERE tprim = K
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
WHERE tsec = K
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
WHERE tprim = K
WHERE tsec = K
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
WHERE tranno = K
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
PREFS&
(^!%'
SELECT * FROM Trans K
ORDER BY tprim, tdateK
TRANNO&
TDATE&
TREF$
TDETS$
TSIGN$
TAMOUNT
TCURR$
TCONV
TPRIM%
TALLOC$
TSEC%
TREC$
TSECTRANNO&
OPENACCOUNTS
OPENCATEGORIES
OPENSORDERS
OPENALLTRANSACTIONS
PREFS&
(^!%'
Database Information
Accounts
Categories
S/Orders
Transactions
ContinueO
PREFS&
(^!%'
SELECT * FROM InvoicesK
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
PREFS&
(^!%'
SELECT * FROM InvoicesK
WHERE fin = 'N'K
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
PREFS&
(^!%'
SELECT * FROM InvoicesK
WHERE fin = 'N'K
AND invnum = K
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
PREFS&
(^!%'
SELECT * FROM InvoicesK
WHERE fin = 'Y'K
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
PREFS&
(^!%'
SELECT * FROM InvoicesK
WHERE fin = 'Y'K
AND invnum = K
INVNUM&
CLNUM&
INVDT&
NETAMT
VATAMT
TOTAMT
REGISTERACCT
(^!%'
Unregistered - 5Account
This is unregistered software.O
+-You will be able to use this software subjectO
+.to certain restrictions on numbers of accountsO
and transactions.(
+1Please register and support software development.O
(.txt)