How do I create a journal pivot table?

Have more questions? Submit a request
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. 


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.

    The Pivot Display view appears.
  8. Include the Costs data and/or Liabilities data.
  9. Select the desired Rows and Headings.


    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.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful