API resource trial balance

API resource trial balance is available in 2 versions.

API resource trial balance V2

GET https://service.runmyaccounts.com/api/{version}/clients/{clientname}/gl/v2/saldo

Parameters/filters:

Parameter Description Mandatory Example
accno Filter by account number. You can use character x as wildcard. Ex. 15xx filters all account from 1500 to 1599 No 15xx
from Include transaction from date (yyyy-MM-dd) No 2019-01-01
to Include transaction until date (yyyy-MM-dd), default is today No 2019-05-31
department Count only transaction of specified department No
bookkeeping_main_curr Default value is true. Show balances in book keepings main currency No
exclude_yearend_bookings Ignore offsets at yearend No
include_openings With that parameter you can control to include or not include the opening balance into the report. Default = true. no false
project With project you get values marked with a certain project. Only one project at a time. Use project Name. no

Warning: Chart of the balance sheet do not need a from date. Charts of the income statement need from and to parameter.

Examples

https://service.runmyaccounts.com/api/latest/clients/apitest/gl/v2/saldo?from=2012-01-01&to=2012-12-31&accno=2xxx&api_key=d1bvbxkI8f1bnMBJ4sZiC-xupl4fOEzf

XML:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<table>
  <row>
    <accountnumber>2010</accountnumber>
    <accountname>Verbindlichkeiten für AHV</accountname>
    <amount>41557.6500</amount>
  </row>
  <row>
    <accountnumber>2011</accountnumber>
    <accountname>Verbindlichkeiten für BVG</accountname>
    <amount>-12827.8500</amount>
  </row>
  <row>
    <accountnumber>2012</accountnumber>
    <accountname>Verbindlichkeiten für UVG</accountname>
    <amount>7723.7000</amount>
  </row>
  <row>
    <accountnumber>2013</accountnumber>
    <accountname>Verbindlichkeiten für KTG</accountname>
    <amount>4776.0000</amount>
  </row>
  <row>
    <accountnumber>2014</accountnumber>
    <accountname>Verbindlichkeiten für Quellensteuer</accountname>
    <amount>2731.3000</amount>
  </row>
</table>

JSON:

{
"row": [
{
"accountnumber": "1000",
"accountname": "Kasse",
"amount": "23.8300"
},
{
"accountnumber": "1010",
"accountname": "Postcheck",
"amount": "0.0000"
},
{
"accountnumber": "1020",
"accountname": "ZKB CHF CH35 0070 0110 1234 1234 5",
"amount": "220210.0800"
},
{
"accountnumber": "1024",
"accountname": "ZKB EUR CH95 0070 1234 0075 1234 4",
"amount": "41719.7438"
},
{
"accountnumber": "1025",
"accountname": "ZKB Mieterkautionssparkonto",
"amount": "-0.0000"
},
{
"accountnumber": "1026",
"accountname": "ZKB USD CH96 0070 1234 1234 1234 6",
"amount": "50705.3100"
},
{
"accountnumber": "1030",
"accountname": "Revolut CHF",
"amount": "5731.0100"
}
]
}

 

API resource trial balance V1

GET https://service.runmyaccounts.com/api/{version}/clients/{clientname}/gl/saldo

Parameters/filters:

Parameter Description Mandatory Example
accno Filter by account number. You can use character x as wildcard. Ex. 15xx filters all account from 1500 to 1599 Yes 15xx
from Include transaction from date (yyyy-MM-dd) No 2019-01-01
to Include transaction until date (yyyy-MM-dd), default is today No 2019-05-31
department Count only transaction of specified department No
bookkeeping_main_curr Default value is true. Show balances in book keepings main currency No
exclude_yearend_bookings Ignore offsets at yearend No
include_openings With that parameter you can control to include or not include the opening balance into the report. Default = true. no false

Warning: Chart of the balance sheet do not need a from date. Charts of the income statement need from and to parameter.

Examples

https://service.runmyaccounts.com/api/latest/clients/apitest/gl/saldo?from=2012-01-01&to=2012-12-31&accno=2xxx&api_key=d1bvbxkI8f1bnMBJ4sZiC-xupl4fOEzf

XML:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<table>
  <row>
    <column>2010</column>
    <column>Verbindlichkeiten für AHV</column>
    <column>41557.6500</column>
  </row>
  <row>
    <column>2011</column>
    <column>Verbindlichkeiten für BVG</column>
    <column>-12827.8500</column>
  </row>
  <row>
    <column>2012</column>
    <column>Verbindlichkeiten für UVG</column>
    <column>7723.7000</column>
  </row>
  <row>
    <column>2013</column>
    <column>Verbindlichkeiten für KTG</column>
    <column>4776.0000</column>
  </row>
  <row>
    <column>2014</column>
    <column>Verbindlichkeiten für Quellensteuer</column>
    <column>2731.3000</column>
  </row>
</table>

JSON:

{
  "row": [
    {
      "column": [
        "2010",
        "Verbindlichkeiten für AHV",
        "41557.6500"
      ]
    },
    {
      "column": [
        "2011",
        "Verbindlichkeiten für BVG",
        "-12827.8500"
      ]
    },
    {
      "column": [
        "2012",
        "Verbindlichkeiten für UVG",
        "7723.7000"
      ]
    },
    {
      "column": [
        "2013",
        "Verbindlichkeiten für KTG",
        "4776.0000"
      ]
    },
    {
      "column": [
        "2014",
        "Verbindlichkeiten für Quellensteuer",
        "2731.3000"
      ]
    }
  ]
}

 

War dieser Artikel hilfreich?
Dislike 0
Ansichten: 540
Scroll to Top