---
title: "How do I create a journal pivot table?"
slug: "how-do-i-create-a-journal-pivot-table"
updated: 2026-06-10T11:26:25Z
published: 2026-06-10T11:26:25Z
canonical: "help.cintra.co.uk/how-do-i-create-a-journal-pivot-table"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.cintra.co.uk/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I create a journal pivot table?

**Cintra iQ** holds the functionality to produce a costing file that is relevant to your accounting system, so that you can upload the file without having to manually enter the data.

> [!TIP]
> **Example:** In my company, I have a monthly payroll for the office staff. I have a weekly payroll for the factory staff. My accounting year runs from 01 July to 30 June. It runs in months. There are twelve accounting months and the first will be in July. In July, I'll need Journals covering the month of July payroll and weeks 14-17 of the weekly payroll. I need to produce a journal for those weeks.

Once the **Journal** data is extracted, you can set up the **Journal Display** to see what monies are allocated against the cost codes and how they have been analysed. You can also generate output files within the **Journal Display** to either review or export directly to the desired location.

## To create a journal pivot table

1. Navigate to the **Payroll to Accounting Period Selection** window. Go to **Cintra iQ**: Payroll > Payroll Tools > Accounting > Journal Display
2. Choose the desired **Accounting Reporting Group** period.
3. Select the desired **Payrolls**.
4. Select the **Employees: All**.
5. Select the **Cost Codes: All**.
6. Click the **Next** button. The **Journal Display (columns)** window appears.
7. Check the **Pivot** check box.![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001063892.png)The **Pivot Display** view appears. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001063893.png)
8. Include the **Costs** data and/or **Liabilities** data. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001063894.png)
9. Select the desired **Rows** and **Headings**.

> [!NOTE]
> **Note:** When selecting a heading, you must enter the order in which the heading is to be displayed.
10. Click the **Next** button. The **Pivot** table is created. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001063895.png)