---
title: "Aged Receivables (Line Items) Template"
description: ""
url: https://help.juan.ac/en/articles/9994157-aged-receivables-line-items-template
collection: "Operational Templates"
updated: 2026-03-31
language: en
---

# Aged Receivables (Line Items) Template



## Aged Receivables (Line Items) Template

## Q1. How do I create a new Aged Receivables (Line Items) template?

-   Go to **Settings** > **Templates** > **Reports** > **Additional Tab**, then click **New Template** (Aged Receivables (Line Items)).
    
-   Alternatively, in **Reports** > **Aged Receivables (Line Items)**, click the template selector (top right) and choose New Template.
    

## **Q2. What settings can I customize in my Aged Receivables (Line Items) template?**

-   The Aged Receivables (Line Items) template has two tabs: General and PDF.
    
    -   General: Edit template name, baseline period, header, and footer.
        
    -   PDF: Customize layout, header, and footer for PDF version of the report.
        
        -   Note: PDF preview and export are only supported for up to 8 columns.
            

![](https://staticfiles.gleap.io/gattachments/KSoVlM42ODLapg1Nj1RRKEohvoJ7obR4oXYfiWNm0t5kFRQMzOX4jgkVywwBlH436hOLxU2y8hW.png)

![](https://staticfiles.gleap.io/gattachments/qw1zM61bkr1Vt6fIVCXPIcf9yyhhXLxtJFlv53vpiQzmoFgIQim34nLRlXB3VzeZTtwXarl5Iyh.png)

## **Q3. What columns are supported in the Aged Receivables (Line Items) template?**

-   The Aged Receivables (Line Items) template supports the following columns:
    
    -   Adjustable:
        
        -   Transaction Date (locked)
            
        -   Due Date (locked)
            
        -   Customer Name (locked)
            
        -   Transaction
            
        -   Reference
            
        -   Current (PHP)
            
        -   < 1 Month (PHP)
            
        -   1 Month (PHP)
            
        -   2 Months (PHP)
            
        -   3 Months (PHP)
            
        -   Older (PHP)
            
        -   Balance (PHP)
            
        -   Currency
            
        -   Current (Source)
            
        -   < 1 Month (Source)
            
        -   1 Month (Source)
            
        -   2 Months (Source)
            
        -   3 Months (Source)
            
        -   Older (Source)
            
        -   Contact Group
            
        -   Contact Relationship
            
        -   Note: Transaction Date, Due Date, and Customer Name are locked. This means you cannot hide or re-arrange them. (PHP) pertains to the org’s default currency.
            

## **Q4. How do I select/hide/arrange columns in the Aged Receivables (Line Items) template?**

-   To show or hide columns:
    
    -   Click the column icon at the top right of the template.
        
    -   In the panel, you’ll see two lists: Hidden Columns and Selected Columns.
        
    -   To show a column, move it from Hidden Columns to Selected Columns.
        
    -   To hide a column, hover over it in the Selected Columns list and click the hide icon.
        
-   To arrange columns:
    
    -   Click the column icon at the top right of the template.
        
    -   In the Selected Columns list, hover over a row and drag it to your preferred position.
        

![](https://staticfiles.gleap.io/gattachments/a1xrnfQ5v3DheTgVmEXKDsxgZMGU2fkq9pfKEV07rpPdGRkovOhEJud0XWzAw5byS4oMzK7LIp4.png)

## **Q5. What is the decorator function in Template Style for?**

-   Turning on decorators for Template styles adds a horizontal line on top of the report.
    

## **Q6. What is the uppercase function in Fonts for?**

-   Turning on uppercase converts all text in the report to uppercase.
    

## **Q7. Can I add a logo to my Aged Receivables (Line Items) Template?**

-   Yes, go to **Template Settings** > **PDF** > Add a logo
    
-   Logo file should only be up to 1mb with min width: 120px and min height: 60px
    

## **Q8. What is the dynamic string in the PDF Date Title for?**

-   You can use the dynamic string for dates to configure your date title according to your preferred format.
    

![](https://staticfiles.gleap.io/gattachments/TKvq1vo1OEpazC3k1hmZmQ20aXj0Peh5EGDO3056rk8FnGXioRuCCeIZkiUSlxyShQ1xk5Jr4Ke.png)

## **Q9. How do I duplicate an Aged Receivables (Line Items) template?**

-   Go to **Settings** > **Templates** > **Reports > Additional Tab**, hover over the template, click the three-dot icon, and select **Duplicate**.
    

## Q6. What happens when I update an Aged Receivables (Line Items) template?

-   Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
    

## **Q10. What happens when I update an Aged Receivables (Line Items) template?**

-   Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
