CONTAONE00 HELP
1 INTRODUCTION
2 REFERENCE MANUAL
2.1 THE MAIN WINDOW
2.2 INCOMES OR EXPENSES EDIT WINDOW
2.3 INCOMES OR EXPENSES LIST WINDOW
2.4 RECORD SELECTION WINDOW
2.5 INCOMES OR EXPENSES TOTALS WNDOW
1 INTRODUCTION
CONTAONE00 is an accountancy personal program. CONTAONE00 stores in a database file the accountancy notes that you insert. You can insert any kind of accountancy note. From the usual personal expenses to the accountancy notes of any economy activity, hobby etc.
The accountancy notes are called records. The records are stored in a SQLlite database file. The file name is miconta00.db . The file is stored in your phone hard drive. You can copy the file to your pc or to any hard drive.
CONTAONE stores three fields in each record. The date, the amount and the explanation.
There are to tables of records. The incomes table and the expenses table. The easier is to use both tables. But you also can use negative values in the amount field, if you prefer to use only one table for incomes and expenses. Usually use the incomes table if you are going to use only one table.
The date.
You have to insert the dates in an strict format used commonly in the accountancy. This is YYMMDD . Two digits for the year. Two digits for the month. And two digits for the day. In this order and without separators. For example 111231 (31 of December of the year 2011).
When the program prints the date in any window it will always do it with the standard YYYY-MM-DD . This is with the following format 2011-12-31 (31 of December of the year 2011).
You can use future dates. For example to know when you will have an expense or an income in the future months. You can make a records selection with dates of the next months and know the incomes or expenses you are going to have.
The amount
You can use any currency. But use always the same currency. The amount is inserted always without thousands or millions separators. And with a point for the decimals separator. This is with the following format
3120550.75
The program will print the number in the same format. You can use or not use decimals as you want or as you need it.
The explanation
Is a short comment up to 120 characters. You can insert any information. Try to use as less characters as possible. The less characters you use the fast you will finish. Using the shorter number of characters is also useful to make faster records selections. Record selections are explained later.
Try to use organized memory rules. If you are explaining a food expense. Start with the word food and then the rest of the explanation if needed. If you are inserting an income from a clothes selling of your shop. Start with the word shirt for example and then any explanation if needed.
Useful examples:
food hamburgers
clothes shirt
friends Peter
customers Peter P.
car petrol
bank mybank
investments my investments
2 REFERENCE MANUAL
2.1 THE MAIN WINDOW
The main window is the first window you can see. You will find six options.
INCOMES EDIT – Will show the incomes edit window.
INCOMES LIST – Will show the incomes list window.
INCOMES TOTALS – Will show the incomes totals window. The totals are calculated summing the value of the amount field, of each record of the table incomes that are included in the selection.
EXPENSES EDIT – Will show the expenses edit window.
EXPENSES LIST – Will show the expenses list window.
EXPENSES TOTALS – Will show the expenses totals window. The totals are calculated summing the value of the amount field, of each record of the table expenses that are included in the selection.
2.2 THE INCOMES OR EXPENSES EDIT WINDOW
Both edition records windows are the same. They are explained just once. In the records edition window you have to insert the information of each record. The edition window shows at the start, all the records of the table. The records are showed in the same order that have been inserted.
When you come from the main window, the last record inserted is the first presented. If you make a records selection with the SELECTOR button. The records will be ordered by the date, starting from the newest one. The newest record will be presented the first one. The record selections are explained later.
When you make a record selection, only the selected records will be accessible in the editing window. If you want to select all the records again, you can return to the main window and start again the editing window. You can also go back to the selection window and make a new record selection.
ADD BUTTON (RECORDS)
To insert a new record click the button ADD and then complete the fields. When the fields are completed then click always the UPDATE button in order to write the record in the table of the database file.
UPDATE BUTTON (RECORDS)
If you want to change any field of a record. First look for the record in the editing window with the buttons UP and DOWN. If there are many records then you should make a record selection. The less records you have in the selection, the faster you will find the desired record. Once you have find the record change the fields and click the button UPDATE. The new information will be written to the table of the database file. Remember that the UPDATE button is used also to save the new records after clicking the button ADD.
DELETE BUTTON (RECORDS)
If you want to delete a record. First look for the record in the editing window with the buttons UP and DOWN. If there are many records then you should make a record selection. The less records you have in the selection, the faster you will find the desired record. Once you have find the record click the button DELETE . The record will be deleted in the table of the database file.
UP AND DOWN BUTTONS
With this buttons you can move through the records of the table or through the selection of records.
SELECTION BUTTON
The SELECTION button shows you the record selection window. Complete a selection conditions in the selection window. When you come back to the edition window there will be available only the selected records.
2.3 THE INCOMES OR EXPENSES LIST WINDOW
Both list records windows are the same. They are explained just once. In the list window the records of the table (incomes or expenses) are shown in a list one after the other. In the list window, all the records have a field with a number, used by the program as the current number of the record in the database file. After this number you can find the rest of fields of the record.
The MENU button use to be located out of the window of your phone and in the left side. It usually shows a menu symbol. If you don't find the button MENU then look for it because it must be there necessarily. The MENU button will show you an menu with three options.
SELECTION
The SELECTION button shows you the record selection window. Complete a selection conditions in the selection window. When you come back to the edition window there will be available only the selected records.
DELETE ALL THE SELECTION
This option will delete all the records of the selection in the table of the database file. Be careful with this option because it delete many records at the same time. It can even delete all the record of the table if you have not made any deletion.
CANCEL
This option will show the MAIN window.
2.4 THE RECORDS SELECTION WINDOW
The records selection window shows all the information and the data fields needed to make a record selection. All the selection records windows are the same. They are explained just once. In the windows it can be set conditions for a record selection. In a selection you can use all the fields of the table (date, amount and explanation), some of them or just one. As you need.
The conditions with dates must specify two dates. First the older one and then the newer one. Both dates could be the same. For example between the 2011 January 01 and the 2011 January 31, this means all the January month of the year 2011. Then in the field
DATE 1 we insert 110101
and in the field
DATE 2 we insert 113101
Now we have the condition by date finished.
The conditions with amounts must specify two amounts. First the smaller then the bigger. Both amounts could be the same. For example between 1000 and 2000. Then in the field
AMOUNT 1 we insert 1000
and in the field
AMOUNT 2 we insert 2000
Now we have the condition by amount finished.
The conditions by the field EXPLANATION must be specified with words or characters. This words or character have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word investments, bank, food or any other one in the field explanation. You should insert the used words to set the condition that is used to make the record selection. For example the word bank , will select all the record with that word included in the words of the field explanation. This means that the selected records could have also other different words in the field explanation.
Once you have finished all the conditions for the selection. Click on the button OK to show again the editing or the list window. The current selection will be in use until you make a different selection or you return to the MAIN window. The button CANCEL finish the record selection without changing the selection that is in use.
2.5 THE INCOMES OR EXPENSES TOTALS WINDOW
The totals window calculate the sum of the values inserted in the field AMOUNT. The total will include the amount of each selected record of the table (incomes or expenses). Both TOTAL windows are the same. They are explained just once. It is also a similar window to the SELECTION window. Because this reason the explanation to make a record selection is the same. If you have any doubt about how selecting records all the information will be available in the previous section 2.4 THE RECORDS SELECTION WINDOW of this manual. Once you have set the conditions of the record selection click the OK button. The calculate sum of the amounts will be shown in the field TOTAL.
