Set Up Accounting for VAT Registers and JPK Extracts for Poland

To create the JPK accounting books extract, you must define an accurate and detailed JPK hierarchy structure where all the natural accounts are classified under the relative JPK account category.

To define the JPK account hierarchy structure, enter the JPK Group Category Accounts (0-9) and the Category Accounts (3 digits). If an existing internal hierarchy account is already being used, define the JPK hierarchy on an existing hierarchy without affecting the existing reporting setups.

Ensure that you enter the JPK related categories and group categories using an indicative prefix to differentiate them from the existing natural accounts. In addition to the accounts that correspond to the actual group categories and account categories, define one more parent account as the JPK top level account to use as the top reference point for the JPK hierarchy tree. You can upload the JPK accounts using a spreadsheet or manually entering the values in the application.

Setting Up Account Hierarchies

Set up your account hierarchies to report account balances at summary levels. You can enter up to a ten level hierarchy for information and other purposes. You must also define the following under the same hierarchy:

• JPK Top Level Account: At the P3 Parent Level.

• JPK Group Category Accounts: At the P2 Parent Level. They comprise 10 accounts in the range 0-9.

• JPK Category Accounts: At the P1 Parent Level. They comprise 3 digit accounts.

• All the existing postable accounts used by the user: As Child values.

You can create and update hierarchies by navigating to the Upload Chart of Accounts page from the Setup and Maintenance work area. Run the Upload Enterprise Structures and Hierarchies process to create a hierarchy, and create or update a version. You can specify JE_PL_ACCOUNT in the Value Set list. To create a hierarchy for the tree code, use the same name that you used for the account value set. You can also use the tree code of the existing hierarchy where the JPK classifications are stored.

Manually Adding JPK Accounts to the Chart of Accounts

You can manually create and upload a hierarchy by performing the following steps:

1. Navigate to the Manage Value Sets page from the Setup and Maintenance work area.

2. Search for the JE_PL_ACCOUNT value set in the Value Set Code field.

3. Click the Manage Values button.

4. Click the Create icon to add the JPK parent accounts.

Managing an Account Hierarchy

Perform the following steps to manage account hierarchies:

1. Navigate to the Manage Account Hierarchies page from the Setup and Maintenance work area.

2. From the Actions menu in the Manage Account Hierarchies: Specify Definition page, select Create Tree.

3. Define the account name, code, and tree structure.

4. Add the Accounting Flexfield Hierarchy parent and detail values in the Data Source Parameters section.

5. Click Save,

6. Click Next.

7. From the Actions menu, select New in the Specify Labels section to create labels. You can create labels for top level accounts, group category accounts, and category accounts.

8. Click OK.

9. Click Submit.

10. Search for the tree.

11. Select the JE_PL_ACCOUNT row.

12. From the Actions menu, select Create Tree Version.

13. Provide the required values, and click Next to specify nodes.

14. Select Add to add new rows. The Add Tree Node dialog box opens.

15. Select Specific values as the Tree Node Type.

16. Select the correct data source to view parent values.

17. Select JPK Top Level Account as the Label.

18. From the Available Nodes list, select JPK-JPK Top Level Account and move it to the Selected Nodes section.

19. Follow the steps from step 12 to add the second level JPK Group Category Accounts and next level JPK Category Accounts.

20. Select Accounting Flexfield Hierarchy Detail Values in the Data Source list of values.

The JPK structure is now successfully set up. You can now add the detailed nodes for every account you added at the top level, group category level, and category level.

Creating a Hybrid Structure

You can also create a single hybrid structure where a more conventional structure exists with the JPK structure. To create a hybrid structure, perform the following steps:

1. From the Actions menu, click Create Tree Version.

2. Select the relative data source and labels as you did while setting up the JPK structure.

3. Click Submit.

4. Click OK.

5. Select the tree structure row.

6. Select Column Flattening from the Actions menu.

7. Click Online Flattening, and then select the Force Flattening option.

8. Click OK.

9. Click Done.

10. Select the tree structure row.

11. Select Row Flattening from the Actions menu.

12. Click OK.

13. Click Done.

14. Select the tree structure row.

15. From the Actions menu, select Active for Set Status.

16. On the Manage Account Hierarchies page, select Offline Audit.