selected_accounts_and_reconciliation_texts

Root: export

This drop can only be used in the Detail text section within "Style settings".

Methods

Method

Return type

Description

accounts

accounts drop

Returns an Accounts drop with all the accounts selected on the export

all_unreconciled

array

Returns a collection of unreconciled RTs and Accounts

assets

array

Returns only RTs and Accounts of type "assets"

equity

array

An array of all calendar years in the fiscal year. The information for each calendar year is: start_date, end_date, amount_of_days for the number of days the bookyear has in the calendar year, and amount_of_days_in_full_year for the total number of days in the calendar year.

empty?

boolean

Returns true if no accounts and RTs are selected

expenses

array

Returns only RTs and Accounts of type "expense"

incomes

array

Returns only RTs and Accounts of type "income"

include_zeros

array

Same as the 'include_zeros' method in accounts ]

liabilities

array

Returns only RTs and Accounts of type "liabilities"

p_and_l

array

Returns only RTs and Accounts of type "p_and_l"

reconciliation_texts

array

Returns a ReconciliationTexts drop with all the RTs selected on the export

unreconciled_accounts

array

Returns an Accounts drop with the unreconciled accounts selected on the export

unreconciled_reconciliation_texts

array

Returns a ReconciliationTexts drop with the unreconciled RTs selected on the export

Filter reconciled/unreconciled RTs and accounts in your export

The below code was entered in the "detail text" section within export

{% assign all_unreconciled = export.selected_accounts_and_reconciliation_texts.all_unreconciled %}
{% assign unreconciled_reconciliation_texts = export.selected_accounts_and_reconciliation_texts.unreconciled_reconciliation_texts %}


{% for account_or_rt in export.selected_accounts_and_reconciliation_texts %}
  {% if account_or_rt.is_account %}
  {% comment %}Unreconciled & Reconciled Accounts{% endcomment %}
    {% if unreconciled_accounts contains account_or_rt %}
      Unreconciled account: {{ account_or_rt.name }}
    {% else %}
      Reconciled account: {{ account_or_rt.name }}
    {% endif %}
  {% else %}
  {% comment %}Unreconciled & Reconciled RTs{% endcomment %}
    {% if unreconciled_reconciliation_texts contains account_or_rt %}
        Unreconciled RT: {{ account_or_rt.name }}
    {% else %}
        Reconciled RT: {{ account_or_rt.name }}
    {% endif %}
  {% endif %}
{% endfor %}
Output
Reconciled RT: P&L analytical review
Unreconciled account: Other Intangible assets - Cost
Reconciled account: Land and building - Cost