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 .:
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.
Related content
©2024 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.