SIE
- Jhelver Layderos
Reference: The SIE file format
SIE File Type | Closing Balances | Period end balances #PSALDO | Object balances | Export Transactions | ||
Opening and Closing Balance #IB #UB | Profit and Loss #RES | Retained Earnings #IB #UB | ||||
Type 1 - Export of closing balances | Yes | Yes | Yes | No | No | No |
Type 2 - Export of period end balances | Yes | Yes | Yes | Yes | No | No |
Type 3 - Export of object balances | Yes | Yes | Yes | Yes | Yes | No |
Type 4E - Export of transactions | Yes | Yes | Yes | No | No | Yes |
Default Searches | SIE balance | SIE profit and loss account balance | SIE P&L | SIE period end balance | SIE balance | SIE transactions |
customsearch_sta_sie_search_ib | customsearch_sta_sie_search_res | customsearch_sta_sie_pl | customsearch_sta_sie_search_psaldo | customsearch_sta_sie_search_ib | customsearch_sta_sie_search_transactions | |
SIE balance - this is used for #IB Opening balance of a balance sheet account and #UB Closing balance for balance sheet account .
This shows balances for “Balance Sheet” accounts, including RE
Account must contain an SRU code (custom field)
SIE P&L - this is used for #IB Opening balance of a balance sheet account and #UB Closing balance for balance sheet account
This shows balances to get the Retained Earnings that was closed from P&L
SIE profit and loss account balance #RES Balance for profit and loss account
This shows net debit/credit for “P&L” accounts
SIE transactions
The account must have account numbers on all searches
Account must contain an SRU code (custom field)
When running the report, the user should set the User Preference: Accounting Context if they are using different set of Accounting Context for Sweden.
#SIETYP
#FNAMN Complete name of the exported company - this is based on Subsidiary: Legal Name
#RAR YYYYMMDD YYYYMMDD
First date is the Start Date or Accounting Period: Start Date
Second date is the End Date or Accounting Period: End Date
#RAR-1 YYYYMMDD YYYYMMDD
Year minus both dates
#DIM - dimension note: it seems that we always start with “20” increment of 1, not sure why, can we support hierarchy?
#OBJEKT obect
There is no #OUB closing balance for object