JPK_KR Default Data Sources

Version Date Comment
Current Version (v. 5) Mar 14, 2024 07:47 Kiro Franco
v. 4 Jan 28, 2022 08:40 Jhelver Layderos
v. 3 Jan 28, 2022 08:37 Jhelver Layderos
v. 2 Jan 28, 2022 08:22 Jhelver Layderos
v. 1 Oct 15, 2021 07:19 Lou Dizon

Default Saved Searches

JPK_KR Report Component

Saved Search Name

Saved Search ID

Trial Balance Account Information

JPK_KR ZOiS Account

customsearch_sta_pl_jpkkr_zois_account

Account Opening and Ending Balance

JPK_KR ZOiS Balance

customsearch_sta_jpkkr_zois_balance

Selected Period and Cumulative Turnover

JPK_KR ZOiS Turnover

customsearch_sta_jpkkr_zois_turnover

Journals

JPK_KR Dziennik

customsearch_sta_pl_dziennik

Accounting Records

JPK_KR KontoZapis

customsearch_sta_pl_kontozapis

Important: Do NOT change the column labels or summary labels assigned to each saved search index. Do NOT delete any of the columns specified in the following saved search tables.

Trial Balance Data Structure

Trial Balance Account Information

XML Tag

Content

NetSuite Field

KodKonta

Final write account identifier (secondary account or account ledger, if no entry on the accounts is required auxiliary) - a string field, e.g. 011-4-1

Account: Localized Number

OpisKonta

Account name - a string field, e.g. passenger cars

Account: Localized Display Name

TypKonta

Account type (balance sheet, off-balance sheet, settlement or result) string field, e.g. balance sheet

Account: Account type (Custom Field)

KodZespolu

Code of the group of accounts according to the List of Synthetic Accounts (general ledger accounts) character field 0-9, e.g. 0

Account: Team Code (Custom Field)

OpisZespolu

Description of the group of accounts - a string field, eg Fixed assets

Account: Team Description (Custom Field)

KodKategorii

Account category code by the Synthetic Accounts Group (ledger accounts main) - a string field, e.g. 011

Account: Category Code (Custom Field)

OpisKategorii

Account category name - a string field, e.g. fixed assets

Account: Category Description (Custom Field)

KodPodkategorii

Code of the subcategory of the subsidiary ledger account within each Category of the Synthetic Accounts Group - optional string field, e.g. 4-1 Account subcategory name - optional string field, e.g.

Account: Subcategory Code (Custom Field)

OpisPodkategorii

Account subcategory name - optional string field, e.g. cars

Account: Subcategory Description (Custom Field)

Opening and Ending Balance

XML Tag

Content

NetSuite Field

BilansOtwarciaWinien

Opening balance on the debit side in Polish currency

Sum of Transaction line : Debit amount – Sum of Transaction line : Credit Amount

BilansOtwarciaMa

Opening balance on credit side in Polish currency

Sum of Transaction line : Debit amount – Sum of Transaction line : Credit Amount

SaldoWinien

Balance on the Debit side in Polish currency as at the end date of the period JPK refers to, taking into account the opening balance

Sum of Transaction line : Debit amount – Sum of Transaction line : Credit Amount

SaldoMa

Balance on the credit side in Polish currency as at the end date of the period SAF relates to, taking into account the opening balance

Sum of Transaction line : Debit amount – Sum of Transaction line : Credit Amount

Period and Cumulative Turnover

XML Tag

Content

NetSuite Field

ObrotyWinien

Account turnover on the Debit side, in the period of which JPK relates

Transaction line : Credit Amount

ObrotyMa

Account turnover on the credit side, in the period of JPK

Transaction line : Debit amount

ObrotyWinienNarast

Account turnover on the Debit side, in the period from the opening of the books to the end date of the period to which JPK relates

Transaction line : Credit Amount

ObrotyMaNarast

Account turnover on the credit side in the period from the opening of the books to the end date of the period to which JPK relates

Transaction line : Debit amount

Dziennik - Journal

Journals

XML Tag

Content

NetSuite Field

LpZapisuDziennika

Sequential number of the entry in the structure of JPK / Journal - number natural greater than zero

N/A - Order of Internal ID

NrZapisuDziennika

Journal entry number, issued continuously throughout the year rotary, in accordance with the requirement specified in Art. 14 sec. 2 and paragraph 4 AA, i.e .:

  • entries in the journal must be sequentially numbered,

  • record when keeping accounting books using a computer the accountant should have an automatically assigned item number, under which was entered into the journal.

The chronology of entries in the journal should be kept by date accounting entries and not according to the dates of the operation economic.

With art. 15 section 1 of the Act, it follows that in the general ledger accounts it is valid presentation of previously or simultaneously registered in the journal events according to the double-write principle, which means that entries in

Journal cannot be secondary to the journal entries on the accounts ledger.

A string field (for individual logs), e.g. 1 / Zak / 01/2016,

280 / Sprz / 01/2016

If there GL Audit numbering feature is OFF

Transaction: Internal ID

 

If there GL Audit numbering feature is ON

Transaction: GL#

OpisDziennika

Journal description - string field

Partial journals used by the unit as part of the books accounting, should be named and described in accordance with Art. 14 sec. 3 and 4 AA, eg Purchase, Sale

Transaction: Memo Main

NrDowoduKsiegowego

ID number from the issuer of the ID accountant, as required by Art. 21 sec. 1 point 1 UoR - field character

Transaction: ID

RodzajDowodu

Type of accounting voucher (which is the basis for the entry accountant, as referred to in art. 23 sec. 2 point 2 UoR) placed at an accounting voucher by the issuer, pursuant to Art. 21 sec. 1 point 1 UoR - string field.

Type of accounting voucher (e.g. invoice, PK, statement, bank statement, cash report, periodical report from the cash register fiscal, account closure, technical re-booking and other)

Transaction: Type or Transaction: Type of Evidence (Custom Field)

DataOperacji

The date of the economic operation referred to in Art. 23 sec. 2 point 1 UoR, placed on the accounting document by his the issuer, as required by Art. 21 sec. 1 point 4 of the Act - a date field, e.g. 1/2/2016

Transaction: Date

DataDowodu

The date of preparation of the accounting voucher referred to in Art. 23 sec. 2 point 2 UoR, placed on the accounting document by his the issuer, as  required by Art. 21 sec. 1 point 4 UoR. If the evidence was drawn up on the date of the operation economic and there is no date on which the proof was drawn up an accountant, in accordance with Art. 21 sec. 1 point 4, should be placed in the box the date of the economic operation. - a date field, e.g. 1/2/2016

Transaction: Date Created

DataKsiegowania

Date on which the voucher is entered in the books - a date field, e.g. 1/3/2016

Transaction: Accounting period start date or Transaction: Accounting period end date or Transaction: Date

KodOperatora

Data allowing to determine the person responsible for the content of the provision in accordance with the requirement specified in Art. 14 sec. 4 UoR - string field, eg E Nowak

Transaction: Created by

OpisOperacji

Description of the business operation referred to in Art. 23 sec. 2 point 3 of the Act, placed on an accounting voucher by its issuer, in accordance with the requirement set out in Art. 21 sec. 1 point 3 of the Act, or understandable text, abbreviation or code of the operation description, but must be owned written explanations of the content of abbreviations or codes - in accordance with art. 23 sec. 2 point 3 UoR - string field

Transaction: Memo Main

DziennikKwotaOperacji

The amount of the economic operation referred to in Art. 23 sec. 2 point 4 UoR, results from the value of the economic operation posted by issuer of an accounting voucher, pursuant to Art. 21 sec. 1 point 3 of the Act - amount field

Transaction: Debit Amount

Konto Zapis Structure

Accounting Records

XML Tag

Content

NETSUITE FIELD

LpZapisu

Account record sequence number - a natural number greater than zero

N/A - Order of Internal ID

NrZapisu

Number (code) of the account entry allowing it to be associated with entry in the Journal (identical to the element NrZapisuDziennika) string field, e.g. 1 / Zak / 01/2016, 280 / Sprz / 01/2016

If there GL Audit numbering feature is OFF

Transaction: Internal ID

 

If there GL Audit numbering feature is ON

Transaction: GL#

KodKontaWinien

Record account identifier (auxiliary account or ledger account main, if no entry in auxiliary accounts is required) for write on the debit side - a string field, e.g. 300-000

Account: Localized Number

KwotaWinien

Transaction record amount on the Debit side - an amount field, e.g. 2347.64

Transaction: Debit amount

KwotaWinienWaluta

Transaction Entry Amount Debit in foreign currency for the operation currency - optional amount field

Transaction: Foreign Currency Debit amount

KodWalutyWinien

Currency code for currency operations for debit-side postings - an optional field, consistent with the DomyslnyKodWaluty field of the element JPK header, e.g. USD, EUR

Transaction: Currency: Symbol

OpisZapisuWinien

Transaction record description on the debit side - string field optional

Transaction: Memo

KodKontaMa

Record account identifier (auxiliary account or ledger account main, if no entry in auxiliary accounts is required) for writing on the credit side - a string field, e.g. 201-001

Account: localized number

KwotaMa

Transaction record amount on the credit side - an amount field, e.g. 2347.64

Transaction: Credit amount

KwotaMaWaluta

Credit side transaction record amount in foreign currency for the operation currency - the amount field is optional, consistent with the field

Transaction: Foreign Currency Credit amount

KodWalutyMa

Currency code for foreign currency operations posted on the credit side optional field, e.g. USD, EUR

Transaction: Currency: Symbol

OpisZapisuMa

Description of the transaction record on the credit side - optional character field

Transaction: Memo


Send an email to support@staria.com for questions or concerns regarding this topic.

 

© 2023 Staria. All rights reserved. No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.