Logicim's Ready-to-Use Sage 50 US Aged Payable- All transactions

Aged Payable- All transactions

Introduction

The Aged Payable- All transactions Report lists payables by vendor and aging period as of a selected date, including fully paid invoices when the Report is refreshed with Show all transactions set to Yes.

Prerequisites

- Latest Logicim XLGL version (https://www.logicimtech.com/en/Account/Profile under Download Logicim XLGL).

Report screenshot 1

Download the latest Logicim XLGL version from Account Profile > Download Logicim XLGL.

- Microsoft Excel 2016 or higher.

- Access to the Sage 50 US company data you want to review.

What the Report Does

This Report shows vendor payable details on the Report worksheet, including Vendor ID, Vendor, Contact, Phone Number, Invoice/CM#, Transaction Date, Date Due, Age, Invoice Amount, Payments, Amount Due, 0-30, 31-60, 61-90, and Over 90 Days. It groups lines by vendor and includes vendor totals and a Grand Total. The Chart worksheet includes Payables Breakdown by Aging Period, Monthly Payables Trend, and Top 20 Payables by Vendor views.

How to Use the Report

1. On the Instructions worksheet, enter or confirm the date in As of:.

2. Select whether to age invoices by Invoice date or Due date in Age Invoices by:.

3. Set Show all transactions: to Yes when you want the Report to include fully paid invoices and other completed payable activity.

Report screenshot 2

Use the Instructions worksheet to set the As of date, aging basis, and Show all transactions option before refreshing.

4. Click Refresh on the XLGL ribbon to update the Report.

5. Use Go to Report... or open the Report worksheet to review payable lines, vendor totals, aging columns, payments, and amount due.

Report screenshot 3

The Report worksheet shows payable lines, vendor totals, aging columns, payments, and amount due.

6. Use Go to Chart... or open the Chart worksheet to review the aging breakdown, monthly trend, and top payable vendors.

Report screenshot 4

The Chart worksheet summarizes payables by aging period, trend, and top vendors.

Customization Options

You can adjust the As of:, Age Invoices by:, and Show all transactions: inputs on the Instructions worksheet before refreshing. You can also use normal Excel formatting, sorting, filtering, or print settings on a saved copy. For additional columns, layout changes, or calculation changes, contact Logicim support.

Common Use Cases

- Review vendor payable balances by aging period as of a selected date.

- Compare invoice amounts, payments, and remaining amounts due by vendor.

- Include fully paid invoices when you need a complete payable transaction view for the selected aging date.

- Use the chart views to identify aging concentrations and vendors with the largest payable activity.

Troubleshooting

- Issue A: Expected paid invoices do not appear. Solution A: On the Instructions worksheet, set Show all transactions: to Yes, then click Refresh on the XLGL ribbon.

- Issue B: Aging amounts appear under the wrong aging basis. Solution B: Confirm whether Age Invoices by: is set to Invoice date or Due date, then refresh the Report.

- Issue C: The Report shows values from the wrong company. Solution C: Connect to the correct Sage 50 US company, then refresh the Report again.

- Issue D: You need a different payable layout or more vendor fields. Solution D: Contact Logicim support for customization.

FAQs

- Q: What does Show all transactions do? A: The workbook uses this input to include all payable transactions, including fully paid invoices, when the Report is refreshed.

- Q: Can I age invoices by due date instead of invoice date? A: Yes. Use the Age Invoices by: option on the Instructions worksheet before refreshing.

- Q: Does the Report include charts? A: Yes. The Chart worksheet includes aging breakdown, monthly trend, and top payable vendor views.

Best Practices

- Confirm the As of: date before refreshing the Report.

- Choose the aging basis consistently when comparing this Report across periods.

- Use Show all transactions: only when you need a full transaction view that includes fully paid invoices.

- Connect to the correct Sage 50 US company before refreshing the Report.

- Keep an unchanged copy of the workbook before making workbook-level changes.

- Logicim XLGL Installation and Activation: https://www.logicimtech.com/en/Support/KnowledgeBase/logicim-xlgl-installation-and-activation

- Logicim Reports: https://www.logicimtech.com/en/Products/Reports

- Logicim Knowledge Base: https://www.logicimtech.com/en/Support/KnowledgeBase/introduction

Contact Information

For further support or Report customization, contact Logicim support. Include the Report name, the Sage 50 company, and a short description of the issue or change you need.