Աջակցության կենտրոն

Մեր արտադրանքի գիտելիքների բազան հաճախորդների համար

Shadow ledger

Shadow ledger

The section is intended for analytical accounting of how client and broker funds are allocated among real accounts.

Note: The data specified on this tab does not affect actual account data.

The section allows you to reconcile the total balances in client and house accounts with the balances in real accounts and determine what portion of each account's funds is allocated to a particular real account.

Allocations are maintained separately for each asset and date. Funds in different assets are accounted for independently: cross rates and automatic conversions between assets do not apply.

Shadow ledger is used for analytical accounting only. Changing and saving allocations in this section does not change account balances in the trading platform.


shadow_ledger.png

The table filters allow you to select:

  • Date - the date for which you want to view or change the allocation;
  • Asset - an asset for which there is a discrepancy between the balances in client and provider accounts. An indicator is displayed for assets with unallocated funds. Otherwise, the table displays only data with a zero discrepancy: shadow_ledger_no_delta.png
  • Real account, if necessary - the account whose data you want to display;
  • Profile whose accounts will be displayed.

The following information is also displayed at the top of the page:

  • Suspense - the unallocated amount in the selected asset across all accounts. Excluded amounts are not included;
  • Clients with delta - the number of client accounts with a discrepancy in the asset relative to provider accounts.

Accounts in the table are grouped by type:

  • Client accounts - client accounts;
  • House accounts - the broker's house accounts.

In each group, accounts are divided into two blocks:

  • Awaiting verification - accounts with a balance change whose allocation has not yet been saved;
  • Allocated accounts - accounts for which an allocation has been saved.

The accounts in the table are grouped according to the profiles they belong to. The following information is displayed for each account:

  • A summary of the asset in the account:
    • Incoming - the incoming balance;
    • Δ - the existing balance change in the selected asset. Balance including the specified deltas / Current asset balance in the account;
    • Outgoing - the outgoing balance. Calculated as Incoming + Δ;
    • Excluded - the excluded amount. Displayed if the account is excluded (see the "Excluded accounts" section).
  • Allocation controls:
    • account ID and name;
    • Incoming - the incoming balance;
    • Δ - the existing balance change in the selected asset;
    • Outgoing - the outgoing balance. Calculated as Incoming + Δ;
    • % from total - the ratio of the Δ specified for the provider to the total Δ for the client account, expressed as a percentage.
For profiles, the total values of indicators for the accounts belonging to them are displayed.

Allocating a balance change

To allocate a balance change in a client or house account:

  1. Select a date and an asset.
  2. Find the account in the Awaiting verification block.
  3. In the field for the required real account, specify the delta - the amount by which the funds in this account changed in the selected real account (provider account).
  4. If necessary, allocate the change among multiple real accounts. After you enter the values, the Δ row displays the balance including the specified deltas.
  5. Click Save.

If the delta becomes zero after you enter the value, the account moves from the Awaiting verification block to the Allocated accounts block.

Note: If some funds remain unallocated when the table is saved, they are assigned to a provider account for which a delta has already been specified.

Excluded accounts

If part of an account's balance change cannot be allocated yet, you can exclude the account: the unallocated remainder is set aside as the Excluded amount and is not treated as a discrepancy. You can exclude a client, house, or provider account.

Excluded accounts are displayed on the Excluded accounts tab - a switch next to Shadow ledger at the top of the page. The number in parentheses is the number of excluded accounts in the selected asset.

shadow_ledger_excluded.png

To exclude an account:

  1. Select a date and an asset.
  2. Open the Excluded accounts tab.
  3. Select the account in the Exclude account field.
  4. Click Save.

The Excluded amount is the account's unallocated remainder: the asset balance minus the deltas allocated to real accounts. The amount cannot be set manually - it is recalculated each time the deltas of the excluded account change. If the remainder has the opposite sign to the account balance, the excluded amount is zero and the remainder stays in Δ.

The tab displays:

  • Clients - excluded client and house accounts. Each account has the same allocation controls as on the Shadow ledger tab, plus the Excluded amount. You can allocate deltas among real accounts here as well;
  • Providers - excluded real accounts: Total - the asset balance, Allocated - the allocated amount, Excluded - the excluded amount, Not allocated - the unallocated remainder.

The excluded amount is not included in Suspense and is not treated as a discrepancy: if the rest of the account's funds are allocated, the account is displayed in the Allocated accounts block, is not counted in Clients with delta, and does not trigger the asset indicator. The allocated part of an excluded account's funds is accounted for as usual.

To return an account to regular accounting, click Include in the account row and then Save. The unallocated remainder is displayed as a discrepancy again and must be allocated on the Shadow ledger tab.

Note: An account remains excluded as long as its excluded amount is not zero. If you allocate the entire balance of an excluded account to real accounts, the account disappears from the Excluded accounts tab after saving.

Allocation between dates

When a new date is selected, the allocation from the previous trading day is used as the initial state. Therefore, only balance changes that occurred since then need to be reviewed and allocated.

If the allocation for subsequent dates has not been edited manually, changes made for an earlier date are automatically carried over to those dates.

If the allocation for a date has been edited manually, the Edited manually indicator is displayed next to the section parameters.

If all of the client's funds for an asset were allocated to a single real account, the system automatically recalculates the allocation after the balance changes. If part of the account's funds is excluded, the balance minus the excluded amount is allocated to the real account.

The exception is when the client has withdrawn all funds in an asset. If they were allocated to a single real account, the allocation is removed and the account is no longer displayed in the table: a new deposit must be allocated manually. If the funds were allocated to several real accounts, the allocations are kept: the allocated amount exceeds the zero account balance, and the unallocated amount becomes negative. In this case, the allocations must be reduced manually on the real accounts from which the funds were withdrawn.

In all other cases, the change must be allocated manually.

Exclusions are also carried over to subsequent dates if the allocation for those dates has not been edited manually:

  • if the entire account balance was excluded, the entire new balance is excluded on the new date;
  • if part of the funds was excluded, the same amount is carried over, even if the account balance has decreased. If the rest of the account's funds are allocated to a single real account, the delta for that real account can become negative;
  • if the account balance is zero on a date, the excluded amount on that date is zero and the exclusion is not carried over to the next date - the new balance change must be allocated or excluded again.

Resetting the allocation

To discard changes made for the selected date and restore the allocation from the previous trading day:

  1. Select the date and asset and click Reset.

  2. In the confirmation window, check the date from which the allocation will be restored and click Reset.

    shadow_ledger_reset.png

After the reset, the allocation and exclusions for the selected asset return to their state from the previous trading day.

Viewing allocations by real account

To check which accounts have funds allocated to a particular real account, select the asset and the Real account (provider account).

The Allocated accounts block displays client and house accounts with saved allocations to the selected real account:

shadow_ledger_allocated.png

Real account summary

The bottom of the page contains a summary table showing the allocation of the selected asset among real accounts.

shadow_ledger_table.png

The summary allows you to reconcile the funds allocated among client and house accounts with the actual balance of each real account, as well as review the unallocated amount and any resulting difference.

The table contains the following values:

ValueDescription
ProvidersThe row displays the real accounts (provider accounts) to which funds were allocated. A real account with a zero balance is displayed if funds are allocated to it.
Total ClientsThe number of client accounts for which funds were allocated among real accounts.
House accountThe number of broker house accounts for which funds were allocated among real accounts.
SuspenseThe amount of funds that remains unallocated. It can be negative if more than the real account balance is allocated. A non-zero value is highlighted in red.
ExcludedThe excluded amount of the real account, if it is excluded. Not included in Suspense.
Total Providers (Real balance)The actual asset balance in the provider's real account at the end of the day.
Total SharesThe total amount of funds, including unallocated funds and funds allocated to client and house accounts.
DifferenceThe discrepancy between the actual balance of the real account and the allocated funds.

Export to Excel

The Export button at the top of the page allows you to export the allocation for a closed trading day to an .xlsx file - for example, for the daily archive, reconciliation with a provider, or a statement for a client or auditor. The button opens the Export Shadow Ledger sidepage:

shadow_ledger_export.png

In the sidepage, select:

  • the export mode:
    • Full - the entire allocation for the day;
    • Providers - for the selected real accounts;
    • Client accounts - for the selected client and house accounts;
    • Profiles - for the selected profiles;
  • Trade date - the trading day. Only finally closed days are available (Close day finally in the Daily operations section). By default, the page date is selected if that day is closed; otherwise, the last closed day;
  • in all modes except Full - real accounts, accounts or profiles. You can select several; the list shows only those present in the Shadow ledger on the selected date. Broker house accounts are selected in the Client accounts mode;
  • Currency - the asset to export. If one real account, account or profile is selected, the list contains only the currencies in which it has a non-zero balance on the selected date.

Changing the date or the mode clears the selected accounts.

If one real account, account or profile is selected in the Providers, Client accounts or Profiles mode, the All currencies checkbox is available: all currencies in which it has a balance are exported as a zip archive with a separate file for each currency. Currency selection is unavailable in this case:

shadow_ledger_export_currencies.png

If the allocation for the date has not been formed - the section was not opened for that day before the day was closed - No Shadow Ledger data for this date is displayed under the date, and the export is unavailable. The allocation for a day is formed when the section is opened for that date before the day is finally closed; it is not formed for a closed day.

Click Export to download the file.

File contents

One file contains data in one currency. The file name is ShadowLedger_<mode>_<date>_<currency>.xlsx, where the mode is Full, Provider, Client or Profile. The archive name is ShadowLedger_<mode>_<date>.zip.

Each sheet starts with a header: the broker logo for reports (REPORT in the broker settings), the date, the currency and the export time in the broker's time zone. The table displays non-zero allocation amounts: client accounts are grouped by profile, house accounts are in the House Accounts group. Profile rows can be collapsed. The file text is in English.

ModeFile sheets
FullData - the allocation amounts of each account by real account and the totals by real account; Matrix - the same data with real accounts in columns.
ProvidersP<ID> for each real account: the accounts allocated to it and the reconciliation of the Total Outgoing total with the real account balance Platform balance (from import) - the same value as Total Providers (Real balance) in the summary.
Client accountsC<ID> for each account: the real accounts its funds are allocated to and the reconciliation of the Client account total with the account balance in the platform.
ProfilesProf<ID> for each profile: the profile accounts with their real accounts and the reconciliation of the Profile Total with the total balance of the profile accounts.

Suspense in the file is always 0.00: the export is generated only when there are no unallocated funds. If there is no data in the selected currency, the sheet contains No data.

A closed day is exported as its allocation was last saved. A repeated export of the same day differs only in the export time.

When the export is unavailable

The export is not generated if there are unallocated funds in the selected currency on that date (Suspense is not zero). The error lists the accounts with their balance and allocated amount. A remainder that rounds to 0.00 at two decimal places (less than 0.005 in absolute value) is treated as zero.

The allocation for a closed day cannot be edited or reset: to correct it, the day must be reopened in the broker profile (see Daily operations).

When exporting with All currencies, the archive is not generated if there are unallocated funds in at least one of the currencies.

Accounts with an excluded amount (Excluded) are not included in the export together with their allocations. If such an account is selected in the Client accounts or Providers mode, the export is not generated. In the Profiles mode, excluded accounts of the profile are not included in the file.

The export requires the View accounts permission in the user's role. Without it, the section data is not displayed either.

Չե՞ք գտել այն, ինչ փնտրում էիք։ Գրեք support@unity.finance հասցեին։ Մենք սիրով կօգնենք 24/7