Aged payable 

The Aged payable Report overviews outstanding supplier invoices categorized by aging periods. This Report tracks due payments, manages cash flow, and avoids late fees by ensuring timely vendor payments.  

Prerequisites  

1. Logicim XLGL version 5.0 or higher 
2. Microsoft Excel 2016 or higher 
3. Familiarity with Excel PivotTables 
4. Sage 50 US edition (2021 and above)  

What the Report does 

The Aged Payable Report enables you to:  

1. Track outstanding payables: View supplier invoices grouped by aging periods.  
2. Choose aging method: Select whether to age invoices by Invoice Date or Due Date.  
3. Analyze trends: Identify trends in payables over time.  
4. Visualize payable data: Includes charts for:  
5. Payables breakdown by aging period  
6. Monthly payables trend  
7. Top 20 payables by vendor  

How to use the Report  

1. Open the Report workbook.  
2. Go to the Instructions sheet.  
3. Set Parameters:  
4. Provide the As of date (e.g., 12/31/2024) to define the aging reference point.  
5. Select Age Invoices by (choose between Invoice Date or Due Date from the dropdown list).  
6. Click the Refresh button on the Logicim XLGL tab to update the Report.   
7. Review the Report:  
8. Aging summary: View outstanding invoices grouped by aging periods  
9. Vendor details: See a breakdown of payables per supplier. 
10. Charts: Analyze trends and outstanding balances visually.  

Customization options  

1. Adjust the As of date and Age Invoices by based on business requirements. 
2. Modify filters to focus on specific suppliers or periods. 
3. Add conditional formatting to highlight overdue invoices.  

Common use cases  

1. Monthly vendor payment review.  
2. Identifying overdue invoices to prioritize payments.  

Troubleshooting  

1. Issue: The Report doesn’t update when a new date is entered.   
2. Solution: Ensure you are connected to your data source, and it is refreshed.  

FAQs  

1. Q: Can I add more Vendors to the Top 20 chart?  
2. A: Yes! You can adjust the chart settings to include more or fewer vendors.  

Best practices  

Use filters to focus on specific vendors or aging periods. Ensure you are connected to your data source. Save a backup before creating significant adjustments to the Report structure. 

Related article

See also: Aged receivable