---
title: "Purchases Summary"
description: "View, filter, and export your purchase transactions, items, and payments for any date range."
url: https://help.juan.ac/en/articles/9994249-purchases-summary
collection: "Accounting Reports"
updated: 2026-10-09
language: en
---

# Purchases Summary

View, filter, and export your purchase transactions, items, and payments for any date range.

## Q1. What is Purchases Summary?

-   Purchases Summary is a report that gives you an overview of your purchase activity for a selected date range.
    
-   It is organized into four tabs:
    
    -   Summary
        
    -   Transactions
        
    -   Items
        
    -   Payments
        
-   It helps you review spending and export purchase data for analysis or reporting.
    

![](https://files.gleap.io/pf/gattachments/7UwyPgKupNZTT7c7IqmSerDiqklmQQRcgX9ZChzVwtZvcDGmvO8I7zGEQt0r1nny9GUnjFlUQdo.png?v=1&k=a&s=api&e=1795478400&sig=ZgIjYDLGb-yA_J6ZHfhDH_y9Z2FjpzvpYRa_YGSdYNc)

## Q2. Where can I access Purchases Summary?

-   Go to **Reports → Summaries → Purchases**.
    
-   You can also download the Purchases Summary from the Bills and Purchase Payments pages. Click the download button at the upper right of the page.
    

![](https://files.gleap.io/pf/gattachments/RyoKMxntfX54QI6mAZkXZRRmkgJG8p9shm09vBFv8gepYKIzOzFuGnDQJh5dhqQ3rBqW49NLLlW.png?v=1&k=a&s=api&e=1795478400&sig=vTwYQ5RqwgjLyNJ8ehCvQE6U0jZq3CadIMwCR5hqXps)

![](https://files.gleap.io/pf/gattachments/JC12gua9iyaczgiGYwNYID8ujILWc5iSkH9HQ9yaZbarsidsF5wanGQWPhTpxN5u0SsK1aoq2Ew.png?v=1&k=a&s=api&e=1795478400&sig=wDJlHlK-6Fum-4U-SrCjA7BlTEkQC636MZUyZJRkMRs)

## Q3. What does each tab in Purchases Summary show?

-   **Summary:** a line-level view of your purchases, including the items bought and the accounts they were recorded to.
    
-   **Transactions:** one row per purchase transaction, with its total, withholding tax, payments recorded, and remaining balance.
    
-   **Items:** the items purchased in each transaction, with quantities, accounts, and withholding tax details.
    
-   **Payments:** the payments made to your suppliers, including the payment method and payment account used.
    

## Q4. How do I set the date range?

-   Click the Date Range dropdown and choose a preset option:
    
    -   This Month
        
    -   This Financial Quarter
        
    -   This Financial Year
        
    -   Last Month
        
    -   Last Financial Quarter
        
    -   Last Financial Year
        
-   You can also set a custom start and end date using the date fields.
    
-   Click Refresh to reload the report with the new date range.
    
-   Note: The date range you select applies to all tabs: Summary, Transactions, Items, and Payments.
    

## Q5. Can I group the Summary report?

-   Yes. Click Group By and choose one of the following:
    
    -   Transaction
        
    -   Supplier
        
    -   None
        
-   Click Refresh to reload the report with your grouping applied.
    
-   Note: Group By is only available in the Summary tab. The Transactions, Items, and Payments tabs support filtering only.
    

## Q6. Can I filter the report?

-   Yes. Click Filter and apply the filters you need.
    
-   Click Refresh to reload the report with your filters applied.
    
-   To clear your filters, click the X beside Filter.
    
-   Note: Filters apply only to the tab you set them in.
    

## Q7. How do I adjust the columns in the report?

-   **Open the column settings**: click the adjust column icon at the upper right of the report
    
-   **Add or remove columns**: select the columns you want to show
    
-   **Reorder columns**: arrange the selected columns in the order you want them to appear
    
-   Your changes appear in the report right away. You do not need to click Refresh.
    
-   Note: Column settings are saved per tab. The next time you open Purchases Summary, each tab keeps the columns and order you set until you change them.
    

![](https://files.gleap.io/pf/gattachments/1vQOMlK7hd6tLurt2Ci1xY3iarKRhwVBT4JbsNbnuZdBVvkK2J8SWsMt1FC5bI2NKX2zKRixBBM.png?v=1&k=a&s=api&e=1795478400&sig=WI3N0MX4ZuwpWtbQ1j_ug-kmwQOxW_p2vSxQjejGGx0)

## Q8. How do I download the Purchases Summary report?

-   **Open the download options**: click the download icon beside Refresh
    
-   **Choose a format**: select Excel or PDF
    
-   The format you choose determines what is included:
    
    -   **Excel:** downloads all four tabs, with Summary, Transactions, Items, and Payments each saved as a separate sheet in one file. Each sheet reflects the filters, columns, and grouping set on its tab.
        
    -   **PDF:** downloads only the tab you are currently viewing.
        

## Q9. Can I refresh and download the report at the same time?

-   Yes. Click the arrow beside Refresh, then select Download.
    
-   Choose one of the following:
    
    -   Excel
        
    -   PDF
        
    -   Both
        
-   The report refreshes with your latest settings and downloads in the format you selected.
    
-   Note: If the tab has more than 12 visible columns, only Excel is available.
    

![](https://files.gleap.io/pf/gattachments/4QWAGryXAP19ls45wsOruYIMLJ4zF5NeWnxpFJUZJkLPHSlwcTwh0cGUvzqdzZdJNMDZOW2QzJU.png?v=1&k=a&s=api&e=1795478400&sig=mSZt8DEiYiuRuSZBE53XNHiJL8gI6J1TDQ1XOHZPvyY)

## Q10. Why can’t I download a tab as PDF?

-   PDF downloads support a maximum of 12 visible columns.
    
-   If the tab you are downloading shows more than 12 columns, an error appears when you try to download it as PDF.
    
-   To download it, reduce the visible columns to 12 or fewer using the adjust column icon, or download the report in Excel instead.
