Welcome to TRADETAL
Money going out of an account, "egress" is entered on the left side, money going into an account, "ingress" on the ride side.
Your cost basis is the amount you put into your trade system. The basis amount would go into the right/ingress side of the transaction entry, in the designated currency for the receiving account, while leaving the left/egress side blank. You use you cost basis to determine if you have a gain or loss.
Income - The "home basis" account is used to track income in your home currency. If you receive currency outside of your "home currency", you enter the value at the time of the activity in the home basis field.
Transfer between non-home currencies. This activity can be considered as a like-exchange, without consideration of home currency, or you can enter two transactions: one for the sale in your home currency, and a second transaction for the subsequent "buy".
Handling Bank/Exchange Errors - If the error is in your favor, put the income amount on the right side but leave the left side zero. You can optionally create a new account, for example "Exchange Error", and possibly make this new account hidden. The money does not go into the Error account, it is merely a placeholder. This method can also be used for gifts or outside income or free money, where the funds to not come from an account in the system. IE, you are not purchasing the funds. The left side stays zero.
Making a sale - When a transaction is entered with money leaving an egress account which is not in the home currency, and entering an account which is in the home currency, this is considered a sale, which changes your gain/loss position.
Spending Money - If you spend money out of an account, and it is not a trade, put the expenditure on the left side but leave the right side zero. This will adjust your value summary report. You can view your gain/loss using LIFO, FIFO or Average methods, described at the top.
This program is designed to track currency trades and associated costs and taxes. It uses a double-entry accounting method, without a mechanism of invoicing or paying money out. It is not intended to be a checkbook accounting program. The user can get a sense or estimate of current value in each currency selected, based on current published rates. Included are most commonly available currencies and cryptocurrencies.
You can also see a report of gain/loss using LIFO (Last In - First Out), FIFO (First In - Fist Out) or Average value.
Your financial data is stored in an SQLite3 database. It is encrypted using the Authenticated Encryption with Associated Data (AEAD) algorithm. (ChaCha20 stream cipher with the Poly1305 authenticator). The key is a BLAKE2b hash of the password you enter when creating the file. All data is encrypted with the exception of the following:
1) The account record index number, which is a sequential number assigned as next-available when the account is creatad in the system.
2) The transaction record index number, defined the same way as in #1.
3) The date specified for each transaction, to allow for filtering and sorting.
All other data you put into the program is encrypted. It is up to you to select a secure passphrase to encrypt the data, however if the passphrase is forgotten there is no chance at recovering the data. The minimum passphrase length is 1 character.
This program stores data on the user's computer, on their local hard drive, unless the user specifies a network drive as a save destination. No data is automatically transmitted over the Internet, or stored in any place which has not been designated by the user.
You may choose to back up the encrypted data using the BackBlaze service.
The user may choose to export their data, however the data file that is created shall not be encrypted. Also, the user may print the data.
Where to get help
If you have a question about using our software, or a bug report or security issue, please select the Support option from the Help Menu for up to date contact information.
Starting the program
Updating exchange rates
Use the "Update Exchange Rates" option in the File menu. A dialog will appear with a "Sync" Button. You must press the button to download the updated rates. On the dialog is also the option to automatically download the updates. When this option is checked, the program will check for updates when you first run the software, and every 10 minutes afterward, while the program is running. The program will no longer operate, or check for updates, after you close the program.
Creating a new file
To create a new file, use the "New" option found in the File menu. You can select the encryption type in the file type drop-down box in the Save dialog. Once you select an ecryption type, you cannot change the encryption type for the file.
You will be presented with a dialog to select the destination and filename. The program uses the file extension ".tradetal".
Also you will see a dialog where you will enter the password of your choice. The password must be at least one character. The password is used to encrypt your file. You may also use the "Password Generator" function to create a random password. Please keep your password in a safe place. If you forget or lose your password, you will never be able to access your data again. We do not have the facility or capability to decrypt your file without the password.
Opening an existing file
Select the encryption type using the file type drop down box in the Open file dialog. When you open an existing file, you will be prompted for the password to decrypt the file. Without the password the data cannot be decrypted or opened. The default file extension used by the program is ".tradetal"
Printing a Report
To print the current page, you can use the "Print" option from the File menu. Also, on the Summary Report there is a printer icon near the heading.
When you export data out of the database, it will be stored in clear text which is not encrypted. Anyone who has access to the exported file can read the data, without a password. GnuPG is a program you can use to encrypt the file, which is recommended in order to secure financial information.
You can select to export the accounts list with balances, a complete transaction ledger, or the transaction ledger for a specific account. The file will be stored in CSV format, which is compatible with various business softare. The first row will contain the field headings.
Creating a new account
To create a new account, use the form at the lower left side of the page. The reference field is optional and only appears when you edit the account or export the data. The description length is limited to 1,000 characters, however you might try to use a short description to keep the display clean.
Also select the currency and the "Pnts" for the account. Each account may have only one currency, and one decimal point definition. "Pnts" is the number of digits which will appear after the decimal point, in transactions relating to this account. For example, a USD account would normally have 2 points, while a cryptocurrency may have 6. You can specify up to 12 points.
There are four checkboxes to consider when creating a new account. If the account is to be hidden, and not show up in the Summary Report, check the "Hide" box. Hidden accounts may be viewed using the "Show hidden" link, which is only visible if there are hidden accounts.
A second check option to automatically create a corresponding Fees account is checked by default. For example, if you export funds from Magnolia Bank, you would create a corresponding fees account. The software will append the word "Fees" to the name of the account, when creating the fees account. Fees accounts only show up in the Fees accounts drop down list when entering a transaction.
The third check option is to specify the account as a Fees account. If you are creating a separate account for fees, and not a corresponding Fees account, you would check this box and uncheck the option to automatically create a fees account.
The fourth check option is used to designate the account as a Tax account. These accounts will appear in the Taxes section of the transaction entry options.
You would not normally have more than one checkbox selected for an account. If you make a mistake, you can edit the account after it has been created.
Hidden accounts will not appear in the summary report, or the chart of accounts on the left side. However, they will appear in the ledger.
Fees accounts appear in the Fees section when entering a new transaction. Fees show up in the ingress/egress Fees columns in the ledger.
Tax accounts appear in the Tax section when entering a new transaction.
Home accounts appear in the "home" section when entering a new transaction. The "home" account lets you track your cost basis and gain/loss based on your home currency. Note that there must be only one home account per file.
Editing an account
To edit an account, click the account in the chart of accounts on the left side, and use the edit icon which will appear near the balance at the top right.
Entering a transaction
Enter a new transaction at the top of the Ledger view. There are fields for egress/ingress. Egress is money going out of an account, and these are on the left side. Ingress is money coming into an account, and these are on the right side.
For example, you withdraw 200 from Magnolia Bank Account and they charge 1.50. The 1.50 goes in the egress column. Also consider that the ATM charges fees, these would go on the Ingress column. For example, the ATM charges 3.50. So you put in 200 in the destination account and 3.50 in the Ingress fees section. Some ATMs would charge tax separately so these taxes can be input in corresponding tax field.
As another example, consider being in a foreign country withdrawing cash from an ATM. You see a bank debit of 267.43 plus 5.00 in fees withdrawn from your account, and you receive 5000 pesos. The ATM charges 25.40 pesos plus 4.17 pesos in taxes. The ATM fees and taxes, in pesos, would go in the ingress fees/taxes in the columns on the right side.
The fees and taxes are used to calculate the "Real Rate" which is an adjusted exchange rate based on the expense of performing the transaction. The numbers you enter should be the actual numbers, be careful not to double-down on fees or taxes.
The "home basis" account is used to track your cost basis in terms of your home currency. There must be only one home currency per Tradetal file.
Editing or deleting a transaction
To edit a transaction, click the edit icon next to the transaction id. On the edit page, you may delete the transaction. There is no undo mechanism.
The ledger shows the list of transactions. You may choose a date range at the top. You can also filter the accounts in the transaction list using the account list on the left side.
The Summary Report
The summary report is used to show your gain/loss, and estimated present value of assets. It is based on the information available, and you may have different results at the actual time of trade.