User FAQs

Table of contents

  1. Manual Transactions
    1. How to record a new deposit manually?
    2. How to record a transfer between accounts?
    3. How to record a new trade manually?
    4. What are the different transaction "Types"?
    5. How are tokens marked as illiquid or staked?
    6. How can I create additional sub-accounts for my portfolios?
  3. Performance
    1. How is the dollar P&L calculated?
    2. How are percentage returns calculated?
    3. Can the performance numbers match my audited figures?
    4. What is the Performance Adjustment script?
    5. How do I identify issues with the historical ingest?

Manual Transactions

How to record a new deposit manually?

1. Navigate to the "Trades" page.

2. Click on the button marked "+" to add a new transaction.

3. Select the token to deposit, then specify the amount.

4. Select the account to credit the deposit on the "Portfolio" field.

5. Click "Save" to record the transaction.

How to record a transfer between accounts?

Manual transfers in QIS can credit and/or debit an instrument quantity to a single account. A transaction cannot affect multiple accounts. A transfer between accounts should be recorded as 2 separate transactions: a deposit to one account and a separate withdrawal from another account for the same amount.

How to record a new trade manually?

1. Navigate to the "Trades" page.

2. Click on the button marked "+" to add a new transaction.

3. Select the instrument being bought under "Buy QIS Id". Enter the quantity bought.

4. Select the instrument being sold under "Sell QIS Id". The enter the amount sold.

Example 1: 5 ETH sold for $10K should be recorded as "Buy QIS Id" USD 10000 and "Sell QIS Id" ETHEREUM 5.

Example 2: 10 BTC Dec Calls @ 20K bought for a 0.5 BTC premium should be recorded as "Buy QIS Id" BTC-30DEC23-20000-C and "Sell QIS Id" BITCOIN 0.5.

5. Change the transaction "Type" to "Trade".

6. Select the account to apply the trade on the "Portfolio" field.

7. Click "Save" to record the transaction.

What are the different transaction "Types"?

Manual transactions need to be classified as Income, Trade or Transfer (default). This is used mainly for calculating PnL and Performance calculations.

Automatic transactions are automatically classified into one of these types as well.

How are tokens marked as illiquid or staked?

Illiquid and staked positions are special types of sub-accounts in QIS. You can record credits and debits to theses sub-accounts using the same approach as you would for recording manual transactions to the main account.

If needed you can specify this in the transaction editor under the "Sub Account" field. 

Note however that a transaction can only affect a single sub-account at a time. An operation like staking tokens would therefore be recorded as 2 separate transactions: one to withdraw the tokens from the main account and another to deposit the balance with "Sub Account" marked "staked". 

How can I create additional sub-accounts for my portfolios?

On the transaction editor, you can enter up to 5 name/value tags. These can later be used to search and group positions into your own user-defined sub-accounts.

For example, you may want to classify all trades according to investment strategy. For this you should mark all transactions with a tag named "strategy" and the respective value ("yield", "arbitrage", etc.).

This is an advance use case and we suggest discussing it with the QIS Team who can help.

Performance

How is the dollar P&L calculated?

The profit and lost (P&L) for a position is calculated as the NAV change in the period, exclusive of transfers, plus any dollar trading proceeds. This is a simple and robust methodology that only requires accurate:

  1. Market Prices
  2. Position Quantities
  3. Transaction Classifications (Transfer/Trade/Income)

How are percentage returns calculated?

Time-weighted returns are calculated as the dollar PNL divided by the starting NAV for the period. The Performance tabs calculates these metrics daily, but also reports monthly values, which more accurately reflect typical fund accounting periods.

Can the performance numbers match my audited figures?

Yes. Performance is driven entirely by mark prices and transaction quantity/classification. To match your audited figures, ensure that the historical data in QIS perfectly matches the fund admin data.

What is the Performance Adjustment script?

To more quickly match monthly performance numbers, QIS runs a daily script that records a monthly journal entry to force the performance to match figures provided by the client.

This allows users to use the Performance tab, but hides data quality issues in the historical ingest.

Our suggested approach is to use this feature for a few months as you work through the historical data issues.

How do I identify issues with the historical ingest?

You'll need access to your fund administrator data. Our suggested approach is:

  • Unselect the automatic 'Performance Adjustment' portfolio in QIS.
  • Work forward, month-by-month from inception. Perfectly match each period before moving on to the next.
  • Verify the period starting NAV in QIS perfectly matches your audited figures, including cash balances.
  • Verify the period trading gains in QIS perfectly match your audited figures.
  • Verify subscription and redemption amounts and timing perfectly match your audited figures.
  • Verify any accruals, including fees, are correctly recorded in QIS and match your audited figures.
  • Make any necessary adjustments in a separate manual portfolio.
  • Final check: Monthly Performance = PNL / Starting NAV. This should hold true in both QIS and for your audited figures.

Note the auto adjustment script will take your fixes into account only overnight and should reduce the journal entries in the Performance Adjustment portfolio