Android Edition Initialization


Like the desktop edition, the database for Android needs to be initialized before you can really get rolling.

While the concepts are all the same, the UI has some differences, due to the form-factor involved.

Read on to see how to set up your DB on Android.

Initializing Your Data

Out of the Box

Out of the box, BuxxIQ needs to create the initial database. Unlike the desktop edition, the DB will be created in your device’s Documents directory.

You’ll be prompted to set a passphase for the database. And to confirm that you’ve memorized, saved this passphrase somewhere safe. We have no way of reverse engineering db access if you lose this passphrase. Save it somewhere, maybe a password vault, or the like. But, do not forget it!

Confirm Passcode

Once confirmed, you’ll be presented with the initial dashboard view.

Initial Dashboard

Yeah, not a lot there; which makes sense, as there’s no data (yet). To get said data in, you have a couple of options

  1. Create the various entities by hand
  2. Create a .csv import file of your existing data.

Unlike the desktop version, all dashboard navigation happens via the tools menu.

Dashboard Tools Access

Importing Existing Data

Alas, we don’t know where your data is coming from. It could be from any of a number of other similar tool vendors, or it could be right out of a spreadsheet. Each of these will have their own format that needs special handling to convert to the expected import format. As a result, the creating of a csv file needs to be done by you.

Select the tools icon (three horizontal bars in the upper left), then ‘Import CSV’. You’ll be presented with the import screen. Click ‘Download Template’ Then select the text in the lower pane, cut&paste into a text editor of your choosing and go to town.

When you have a completed CSV file, you’ll need to make it available on your device and then select ‘Pick CSV File’, navigate to and select your .csv file, and then ‘Import’

CSV File Selector

The importer will do it’s thing. Note, depending on the size of your import file, this can take some time, as exchange rates for your noted transactions and transfers will be evaluated for any exchange savings you may have acrued.

Errors, if they occur, will be reported below the import data.

Finally, upon returning to the main dashboard you’ll see something like:

Initial Dashboard

Manual Setup

Ok, we get it, getting a .csv set up can be a pain. You can, instead, do this by hand.

Due to the underlying database relationships, the various entities do need to be done in order, however. Make sure to do things in this order:

  1. Settlement Currency
  2. Banks
  3. Categories
  4. Accounts
  5. Budgets
  6. Reminders

Settlement Currency

Out of the box, BuxxIQ ships with USD as the settlement currency. Change this if you like. Select the currency, and note the ‘Set as Settlement’ at the top right.

Settlement Currency

You’ll be prompted to confirm the change.

Also note, it can be a pain to have to scroll through 156 or so currencies to find what you’re interested in. You can set your favorite currencies to be ‘Visible’ and then select ‘Visible Only’ at the top left to filter the currency list to your favorites.

Banks

Next create one or more banks. As described in Terminology, a bank entity is simply a place to anchor accounts, and a place to allow tracking of overall fees that accrue to the bank as well as its efficiency in handling transfers.

You can access the bank view via the Tools menu from the dashboard.

Add Bank

When you’re done, you’ll have something like:

Added Bank

Categories

Now, you create Categories, the buckets used to track inflows and outflows of money.

Like with banks, select Category from tools menu on the dashboard. To add, tap the ‘+’ in the lower right.

Add Bank

When you’re done, you’ll have something like:

Added Bank

Repeat this process, adding additional categories and their associated currencies to create as many such buckets as you see fit. Note the name you choose will be text searchable in various dropdown menus. So, even if you add many such categories, they’ll be easy to find.

Accounts

Like Categories and Banks, you can access the Account form using the Tools menu on the dashboard.

Initial Account Add

You’ll be presented with the form to add account information:

Add Account Form

The details to be added are:

  1. Name - how you want to reference the account. This name will be displayed on the dashboard as well as in dropdowns.
  2. Currency - the currency in which the account is denominated.
  3. Bank - which of your pre-configured financial institutions holds the account.
  4. Account Type - one of the following:
    1. Cash - an account that has no associated fees and pays no interest. Cash in your wallet might be a good example.
    2. Credit - an account that allows you to take on debt and pay it back later; albeit with service fees and assessed interest.
    3. Bank - an account that may have associated service fees and perhaps pay you interest. A checking account or interest bearing Savings account are good examples.
  5. Initial Balance and Date - the balance and date of that balance in the account’s currency. For Credit accounts, this should be a negative value; ie you owe them money.
  6. Initial Settlement Rate - if you happen to know what the Account Currency to Settlement Currency exchange rate for the initial funds are, enter it here. If you do not know, the mid-market rate for the Initial Balance Date will be used.
  7. Visible - Yes or No - do you want this account to be visible in account lists. For infrequently used accounts, hiding them can make it easier to find the accounts you use regularly. This can be changed after initialization, if your needs change.

After confirming, you’ll see your account on the account list:

Added Account

Note the display of the current balance in the account’s currency, and the settled value (converted to your settlement currency) in parentheses.

Clicking through the account icon, you’ll see the account details.

Initial Account Details

No transactions (yet), but in the details note the settlement rate - this will change over time as funds are added via deposits or via transfers from other BuxxIQ accounts.

Budgets

Budgets have two aspects

  1. The budget itself - which is the Budget’s name
  2. Budget Line Items - a set of budgetary line items associated with the budget in question. Generally, each of your defined categories has a budget line item.

Create the Budget itself, accessing the budget form as you did with Banks, Categories and Accounts.

Add Budget Form

Added Budget

Now it’s time to add budget line items. Tap the budget itself and the tap ‘+ Add Item’, and you’ll get the following:

Add Budget Line Item

Select the cateogory, frequency, type (inflow represents funds entering the system, outflows are funds exiting the system) and the per-period budget amount in the category’s currency.

For example, if you have a category called DE_Rent, for rent payments in Euros that you pay monthly, your form may look like:

Added Budget Line Item

Repeat this for all your categories.

Once done, you’ll see all the budget line items. Note, that due to the device form factor, you will have to rotate the device 90 degrees to see the full data set.

Populated Budget

Each category presents the yearly total in local and settled currency, with a monthly breakdown (in local currency) to the right.

Reminders

Not strictly necessary, but helpful! They remind you of upcoming transactions and can be used to gauge whether you have funds sufficient to cover your planned spending.

By creating a Reminder, you’re planning a recurring future transaction or transfer. When it’s due, enter it, and it will be rescheduled for the future based on the frequency you set.

You know the drill, from the dashboard tool’s menu, tap ‘Reminders’, then ‘+’. You’ll then be presented with:

Add Reminder

Choose the following:

  1. The account to which the resulting transaction or transfer applies.
  2. Type
    1. PYMT - a debit transaction - funds are going to leave the Account
    2. DEP - a credit transaction - funds are going to enter the Account
    3. TXFR - a transfer event - funds are going to move from one account to another
  3. Frequency - how often this reminder should occur.
  4. First Date - the first day for which this reminder should be scheduled
    1. If you selected ‘Twice Monthly’ for frequency, you’ll also need to select the second day in the monthly for the second event
  5. Payee - What you want to use to help you recoginize the ledger entry
  6. Amount - the value of the transaction in account currency
  7. To Account - if you selected TXFR in the type, enter the name of the destination account
  8. Bank Reference - optional, but allows you to capture specific bank supplied info about the entry
  9. Memo - optional, but allows you to capture any other details with which you wish to annotate the entry

For PYMT and DEP reminders, there will be a couple of other fields

  1. The currency for the transaction - which may be different from the account currency
  2. Whether the account’s settlement rate should be used for converting to the settled value, or whether the mid-market rate should be used.
  3. Whether the last day of the month should be used for rescheduled reminders; ie, if your first day is 31 Jan 2026, your next would be 31 Feb 2026. Oops! Use Last Day will make sure it properly uses 28 Feb.

Saving, you’ll see:

Added Reminder

Repeat for as many reminders as you see fit.

That’s It

You have initialized your data. Returning to the dashboard you’ll see something like:

Initialized Database

Move on to other blog posts for entering transactions and transfers, and how to use the dashboard to fully understand your financial state of affairs.