---
title: How to Analyze a Purchase Order and Invoice Item Reports
description: An Item Report in Precoro contains all raw data. With this data in one spreadsheet, you can do any calculations, and create infographics, comps, or any other type of report. In Precoro, you can calcul
---

[Skip to content](https://help.precoro.com/how-to-use-a-purchase-order-and-invoice-item-reports#main-content)

[Contact us](https://help.precoro.com/kb-tickets/new?hsLang=en) [Customer portal](https://help.precoro.com/tickets-view?hsLang=en)

[![Property 1=Default](https://help.precoro.com/hubfs/Property%201=Default.svg)](https://app.precoro.com/login)

Open main navigation

Close main navigation

- [Contact us](https://help.precoro.com/kb-tickets/new)
- [Customer portal](https://help.precoro.com/tickets-view)
- [Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf)

[Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf)

 Hi there! How can we help you today?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.precoro.com/?hsLang=en)
2. [How to use Precoro](https://help.precoro.com/how-to-use-precoro?hsLang=en)
3. [Reports](https://help.precoro.com/how-to-use-precoro?hsLang=en#reports)

# How to Analyze a Purchase Order and Invoice Item Reports

## Learn how to analyze a Purchase Order and Invoice Item reports in Precoro.

#### TABLE OF CONTENTS

- [How to Calculate Spending by the Needed Variable](https://help.precoro.com/how-to-use-a-purchase-order-and-invoice-item-reports#calculate_spends)
- [How to Create a Payment Calendar](https://help.precoro.com/how-to-use-a-purchase-order-and-invoice-item-reports#payment)

An **Item Report** in Precoro contains all raw data. With this data in one spreadsheet, you can do any calculations, and create infographics, comps, or any other type of report.

### How to Calculate Spends by the Needed Variable

In Precoro, you can calculate your company’s spending by Supplier, Department, Project, Issuer, Budget, or Location / Shipping Address. 

1. Filter and export the Item Report for **Purchase Orders** or **Invoices**.
2. Copy the data into a Google spreadsheet.
3. Create a pivot table.
4. Select a Supplier for the Rows
5. Tick the **Show Totals** checkbox and Net Total for the Values.

<iframe data-hsv-src="https://play.hubspotvideo.com/v/1903299/id/139531510963" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="139531510963" data-hsv-style="" data-hsv-width="688" data-hsv-height="442" data-hsv-autoplay="false" data-hsv-loop="false" data-hsv-muted="false" data-hsv-hidden-controls="false" data-hsv-full-width="false"></iframe>

### How to Create a Payment Calendar

1. Filter and export the Item Report for **Purchase Orders** or **Invoices**.
2. Copy the data into a Google spreadsheet.
3. Create a pivot table:
   
     - Select a Supplier for the Rows
     - Tick the **Show totals** checkbox, the Due date for the Columns, and Net Total for the Values.

<iframe data-hsv-src="https://play.hubspotvideo.com/v/1903299/id/139530888004" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="139530888004" data-hsv-style="" data-hsv-width="688" data-hsv-height="402" data-hsv-autoplay="false" data-hsv-loop="false" data-hsv-muted="false" data-hsv-hidden-controls="false" data-hsv-full-width="false"></iframe>

- [Precoro Setup](https://help.precoro.com/precoro-setup?hsLang=en#main-content)

    - [Configurations](https://help.precoro.com/precoro-setup?hsLang=en#configurations)
    - [User Management](https://help.precoro.com/precoro-setup?hsLang=en#user-management)
    - [Custom Fields and Forms](https://help.precoro.com/precoro-setup?hsLang=en#custom-fields-and-forms)
    - [Supplier management](https://help.precoro.com/precoro-setup?hsLang=en#supplier-management)
    - [Working with Items](https://help.precoro.com/precoro-setup?hsLang=en#working-with-items)
    - [Approval Workflow](https://help.precoro.com/precoro-setup?hsLang=en#approval-workflow)
    - [Location Management](https://help.precoro.com/precoro-setup?hsLang=en#location-management)
    - [Precoro Payments](https://help.precoro.com/precoro-setup?hsLang=en#precoro-payments)
    - [Two-factor authentication](https://help.precoro.com/precoro-setup?hsLang=en#two-factor-authentication)
    - [Security](https://help.precoro.com/precoro-setup?hsLang=en#security)
    - [US Based Server](https://help.precoro.com/precoro-setup?hsLang=en#us-based-server)
- [How to use Precoro](https://help.precoro.com/how-to-use-precoro?hsLang=en#main-content)

    - [Warehouse Requests](https://help.precoro.com/how-to-use-precoro?hsLang=en#warehouse-requests)
    - [Requests for Proposals](https://help.precoro.com/how-to-use-precoro?hsLang=en#requests-for-proposals)
    - [Purchase Requisitions](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-requisitions)
    - [Purchase Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-orders)
    - [Service Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#service-orders)
    - [Receipts](https://help.precoro.com/how-to-use-precoro?hsLang=en#receipts)
    - [Invoices](https://help.precoro.com/how-to-use-precoro?hsLang=en#invoices)
    - [Expenses](https://help.precoro.com/how-to-use-precoro?hsLang=en#expenses)
    - [Budgeting](https://help.precoro.com/how-to-use-precoro?hsLang=en#budgeting)
    - [Inventory](https://help.precoro.com/how-to-use-precoro?hsLang=en#inventory)
    - [Reports](https://help.precoro.com/how-to-use-precoro?hsLang=en#reports)
    - [AP Inbox and Intelligent AP Automation](https://help.precoro.com/how-to-use-precoro?hsLang=en#ap-inbox-and-intelligent-ap-automation)
    - [Working with documents](https://help.precoro.com/how-to-use-precoro?hsLang=en#working-with-documents)
    - [Suppliers Portal](https://help.precoro.com/how-to-use-precoro?hsLang=en#suppliers-portal)
    - [Supplier Registration](https://help.precoro.com/how-to-use-precoro?hsLang=en#supplier-registration)
    - [Attachments, Filters, and Search](https://help.precoro.com/how-to-use-precoro?hsLang=en#attachments-filters-and-search)
    - [Mobile App](https://help.precoro.com/how-to-use-precoro?hsLang=en#mobile-app)
    - [FAQs and Troubleshooting](https://help.precoro.com/how-to-use-precoro?hsLang=en#faqs-and-troubleshooting)
- [Precoro Integrations](https://help.precoro.com/precoro-integrations?hsLang=en#main-content)

    - [QuickBooks Online Integration](https://help.precoro.com/precoro-integrations?hsLang=en#quickbooks-online-integration)
    - [NetSuite Integration](https://help.precoro.com/precoro-integrations?hsLang=en#netsuite-integration)
    - [Xero Integration](https://help.precoro.com/precoro-integrations?hsLang=en#xero-integration)
    - [API Requests and Webhooks](https://help.precoro.com/precoro-integrations?hsLang=en#api-requests-and-webhooks)
    - [SSO Setting](https://help.precoro.com/precoro-integrations?hsLang=en#sso-setting)
    - [Google Integration](https://help.precoro.com/precoro-integrations?hsLang=en#google-integration)
    - [Power BI](https://help.precoro.com/precoro-integrations?hsLang=en#power-bi)
    - [Integration with Slack](https://help.precoro.com/precoro-integrations?hsLang=en#integration-with-slack)
    - [PunchOut Catalogs](https://help.precoro.com/precoro-integrations?hsLang=en#punchout-catalogs)
    - [Integrations via Connectors](https://help.precoro.com/precoro-integrations?hsLang=en#integrations-via-connectors)
    - [Bill.com Integration](https://help.precoro.com/precoro-integrations?hsLang=en#bill-com-integration)
- [Precoro Updates](https://help.precoro.com/precoro-updates?hsLang=en#main-content)

    - [Releases, 2026](https://help.precoro.com/precoro-updates?hsLang=en#releases-2026)
    - [Releases, 2025](https://help.precoro.com/precoro-updates?hsLang=en#releases-2025)
    - [Releases, 2024](https://help.precoro.com/precoro-updates?hsLang=en#releases-2024)
    - [Releases, 2023](https://help.precoro.com/precoro-updates?hsLang=en#releases-2023)
    - [API Updates](https://help.precoro.com/precoro-updates?hsLang=en#api-updates)
    - [General changes](https://help.precoro.com/precoro-updates?hsLang=en#general-changes)

[![Precoro](https://help.precoro.com/hubfs/Precoro.svg "Precoro")](https://precoro.com/)

<https://www.facebook.com/precoro> <https://x.com/PrecoroHQ> <https://www.youtube.com/@precoro> <https://www.linkedin.com/company/precoro>

Copyright © 2026, Precoro

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029956401originalst8O2hJU-eeT07Df_p7ARSZAJSUWnUPzCw.mp4",
  "dateModified" : "2023-10-25T05:59:09.583Z",
  "duration" : "PT9S",
  "height" : 540,
  "name" : "s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029956401originalst8O2hJU-eeT07Df_p7ARSZAJSUWnUPzCw",
  "thumbnailUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029956401originalst8O2hJU-eeT07Df_p7ARSZAJSUWnUPzCw.mp4/medium.jpg",
  "uploadDate" : "2023-10-10T16:12:53.652Z",
  "width" : 840
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029959683originaltKkrC3pbMQBJGa8UsINzblEeGMIskjWFgw.mp4",
  "dateModified" : "2023-10-25T05:59:04.547Z",
  "duration" : "PT8S",
  "height" : 540,
  "name" : "s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029959683originaltKkrC3pbMQBJGa8UsINzblEeGMIskjWFgw",
  "thumbnailUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction35029959683originaltKkrC3pbMQBJGa8UsINzblEeGMIskjWFgw.mp4/medium.jpg",
  "uploadDate" : "2023-10-10T16:14:22.197Z",
  "width" : 924
}
```