Transactions
Concepts
S8 Money is designed to relieve users from maintaining account balances beyond initial set up. The idea is to let users add transactions and update account balances automatically as transactions are added. It was also designed to provide flexibility to users in terms of what data they wish to maintain. These requirements led to two concepts - tracking and reconciliation.
Tracking
When you add a transaction, you can mark it as tracked or untracked. A tracked transactions reflects on the account balances while a untracked transaction doesn't. If you are adding every transaction on an account it's best to mark the transaction as tracked. This will relieve you of updating account balances and also make reconciliation easier.
Untracking is useful when you want to load older transactions (older than the as of date of your balance) for reporting purposes.
It can also be used when you might only be interested in adding a subset of transactions for an account. In such a case you will have to manually sync up your account balance with the bank balance periodically.
Reconciliation
Reconciliation refers to reconciling the data on the app with the bank. Once you verify you have entered the transaction data accurately you can reconcile the transaction by clicking on the reconcile action against the transaction on the transactions listing.
After all transactions have been entered it is important to ensure your account balance matches the bank balance. This will provide you confidence you haven't missed any transactions or incorrectly added any.
Transaction Attributes
The following transaction attributes are supported.
Account
The account the transaction should be recorded against.
Transaction Date
The date the transaction occurred.
Amount
The transaction amount. Use negative amount for debit transactions and positive for credit transactions.
Currency
This is a implied field. The currency of a transaction is the same as the currency of the account.
Labels
Description
Use this to make a note for special transactions. Generally use this field sparingly and rely on labels instead. Using verbose descriptions will increase data size and could impact app performance.
Transaction Maintenance
Add / Update / Delete
A transaction can a added with a simple self-explanatory form. When adding a transaction you can mark it is tracked or untracked - tracking is explained above. The form allows an option to Add More that simplifies data entry when adding multiple transactions on the same account/date.
To edit a transaction expand the transaction in the transactions listing. A reconciled transaction cannot be updated except for its labels and description. To update other fields, mark the transaction as unreconciled first.
To delete a transaction expand the transaction in the transactions listing and click Delete. A reconciled transaction cannot be deleted. To delete a reconciled transaction, mark the transaction as unreconciled first.
Transaction Bulk Upload
You can bulk load transactions to an account. This feature is available under Data Management tab of account details page.
To upload, create a file with one transaction per line with the following details. Use the comma ,character as the delimiter.
date (mandatory) - YYYYMMDD pattern
amount (mandatory) - Positive or negative number with up to 2 decimals
description (optional) - Cannot contain the comma
,character. Use sparingly.labels (optional) - semi-colon separated list of label names. The label names must exists else load will fail.
Tracked (optional) -
Yto track,Notherwise. Defaults toY.Reconciled (optional) -
Yto reconciled,Notherwise. Defaults toN.
Note
If trailing fields are not provided you can skip them altogether but if you do not want to provide intermediary fields you must account for the delimiters until your final field.
For example, this will load
However if you don't want to provide a description but have a label you must do this
Last updated