---
title: "PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson (Loket.nl REST)"
description: "itgen_loketnl_payrollrunbalancesheetbypayrollrunid__embeddedjournalallocationasjson_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/loketnl/LoketNlRest.PayrollRunDownloads.PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson
original: https://documentation.invantive.eu/en/datamodels/loketnl/LoketNlRest.PayrollRunDownloads.PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson
updated: 2024-06-10T18:51:26Z
license: https://documentation.invantive.eu/en/
---

# PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson: Loket.nl REST itgen_loketnl_payrollrunbalancesheetbypayrollrunid__embeddedjournalallocationasjson_plural

`read only` `REST`

- Catalog: `LoketNlRest`
- Schema: `PayrollRunDownloads`
- Label: itgen_loketnl_payrollrunbalancesheetbypayrollrunid__embeddedjournalallocationasjson_plural

Get payroll run balance sheet
__Activity name :__ GetPayrollRunBalanceSheetByPayrollRunId

This endpoint returns per payroll components, marked as relevant for the general ledge (balance sheet), the sum of the values.

If for the given payroll period of the payroll run a "journal profile" is configured the endpoint also returns the ledger account and costcenter/costunit linked to the given payroll component in the "journal profile"


Can only retrieve data.

## API Source

- Endpoint: `/providers/employers/payrolladministrations/payrollruns/{payrollrunId}/BalanceSheet`
- Operation: `get /providers/employers/payrolladministrations/payrollruns/{payrollrunId}/BalanceSheet`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `payrollrunId` | `` | [x] |  | The unique identifier of the payroll run |

## Table Columns

The columns of the table `PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `costCenter_code` | `varchar2(20)` | Cost Centre Code | [ ] |  | The code of the cost center  |
| `costCenter_key` | `int32` | Cost Centre Key | [ ] |  | The key of the cost center  |
| `costCenter_value` | `varchar2(50)` | itgen_loketnl_costcenter_value | [ ] |  | The description of the cost center  |
| `costUnit_code` | `varchar2(20)` | Cost Unit Code | [ ] |  | The code of the cost unit  |
| `costUnit_key` | `int32` | Cost Unit Key | [ ] |  | The key of the cost unit  |
| `costUnit_value` | `varchar2(50)` | itgen_loketnl_costunit_value | [ ] |  | The description of the cost unit  |
| `generalLedgerAccount_generalLedgerAccountnumber` | `varchar2(20)` | itgen_loketnl_generalledgeraccount_generalledgeraccountnumber | [ ] |  | The account number for the general ledger account  |
| `generalLedgerAccount_key` | `int32` | General Ledger Account Key | [ ] |  | The key of the general ledger account  |
| `generalLedgerAccount_value` | `varchar2(50)` | itgen_loketnl_generalledgeraccount_value | [ ] |  | The description of the general ledger account  |
| `payrollComponent_balanceSheetSide_key` | `int32` | itgen_loketnl_payrollcomponent_balancesheetside_key | [ ] |  | Indicates on what side (debit or credit) the value should go  |
| `payrollComponent_balanceSheetSide_value` | `varchar2(50)` | itgen_loketnl_payrollcomponent_balancesheetside_value | [ ] |  | The description of the side of the balance sheet  |
| `payrollComponent_description` | `varchar2(14)` | Payroll Component Description | [ ] |  | The description of the payroll component  |
| `payrollComponent_key` | `int32` | Payroll Component Key | [ ] |  | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart.  |
| `value` | `decimal` | Value | [ ] |  | The sum of all the values for the payrollcomponent in the specific payroll run.  Payroll period, employment and normal/tarif payslip are not taken into account and simply summed up. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Loket.nl REST](/en/release-notes/drivers?driver=loket-nl-rest)

