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
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
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"
]
}
]
}