Accounting in Reports

Created by Erik Åkerlund, Modified on Mon, 20 Feb 2023 at 02:31 PM by Erik Åkerlund

It is possible to take out all accounting and accounting information in reports. To reconcile the accounting in the ERP system with the accounting created in TS. It is possible to sort and add information regarding Counterparty and all configured dimensions (Cost center, Profit center etc). It is also possible to do quick export to excel to get a clean excel file to easier compare with information in ERP system.   

  1. Create new report 
  2. Select template  Template accounting in reports 
  3. Add a name for the report 
  4. Choose date (use date codes FDOPM - LDOPM) 
  5. In TAB selection make your selection. (In accounts press shift or Ctrl to select multiple accounts)
  6. In TAB columns select all columns you want to see in the report

Note, the report should have report type Accounting.


Report columns available;

  • Global id
  • Deal ID
  • Account (general ledger)
  • Original amount
  • Accounting amount
  • FX rate accounting booking rate
  • Dimensions (counterparty &  dimension)
  • Coding text (amount type) 
  • Accounting Status
  • Debit / credit
  • Event time & reversal (Realiserad, orealiserad, reversal) 
  • Due date (payment date, maturity date month end date), accounting date.  
  • Accounting currency
  • Legal entity
  • Report date
  • Period (start date end date for report)
  • Deal Type (Accounting Program)

Note, If no accounting has been created during the month Opening and Closing balance the account will not be visable in the report. Please change the from date further back in time to when you have some accounting. 

Note, If no Legal entity is selected the Opening and Closing balance does not show any amounts. Select only one accounting status. Above will be fixed in the next version. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article