Using the AP Aging Report
Introduction
If you're using a system such as Paragon, you are no doubt buying or producing products, raw materials, or both and therefore likely have to pay your vendors for their hard work. Once you have been issued vendor invoices from your vendors, you need the ability to see, at a glance, whom you owe and when is it due. That's where the AP Aging Report will come in handy. This report can be run from the vendor screen and will list which vendor invoices are still outstanding for each vendor, if you have any vendor credits you can apply to your account(s), and when this money is due to be paid.
Print the AP aging report for one vendor
From any screen in Paragon, click the more button.
Now click the vendor button.
Once you are in the vendor module, open the detail view of any vendor and click the action list button. You will see a print option for aged AP.
Click on aged AP. It will open a modal where you can select the template you want to use.
Select the template and click accept to print the AP aging report for this vendor.
Setting the date in the selection modal to the last day of the period will run the report as if it was that day and only include transactions dated on or before that date.
You also have the option to export directly to Excel.
Print the AP aging report for all vendors or specific vendors
Navigate to the list view and click bulk edit.
After clicking bulk edit your have the option to select multiple vendors. Simply check the boxes for the entries you want to see in the report and click the updated button that now says bulk actions.
Bulk action will open a mini modal that allows you to apply an action across your selected entries.
Click on aged AP. It will open a modal where you can select the template you want to use.
After you have selected the template, you have three options: all, as filtered and manually selected.
all: prints the report for all vendors regardless of the selection you made
as filtered: prints the report for the vendors currently displayed in list view with the advanced filtering regardless of the selection you made
manually selected: prints the vendors you previously selected with the checkbox column
Currency and vendor totals
The AP Aging report displays information by currency and vendor, listing each currency and then displaying each vendor and their transactions within that currency. If there is no due date, the transaction date is used.
- A total is calculated for each vendor (calculation = vendor invoice - payment - vendor credit)
- A total is calculated for each currency and shows the sum of all vendor totals within that currency.
The columns include:
- due date: the due date from the transaction (if applicable)
- transaction: type of transaction being displayed and the transaction number
- total: total dollar amount for that vendor amount
- total: total dollar amount for that vendor amount
- current, 0-30 days, 31-60 days, 61-90 days, and +90 days: these columns will be filled with the total dollar amount for each transaction based on their due dates (if applicable)
You also have the option to export directly to Excel.
What's next?
If you're looking to explore more reports in Paragon, or need help on how to use them, check out some of these articles:
Related Articles
Using the AR Aging Report
Introduction If you're using a system such as Paragon, you are no doubt selling products, services, or both and therefore would likely want to be paid for your hard work. Once you issue invoices to your clients, you need the ability to see, at a ...How to view a customer's balance through the AR Aging Report
In Paragon, you can see the balance owed by a customer through a variety of features. The AR aging report allows you to view your accounts receivable filtered by currency, due date, customer, and more. Here, we’ll show you how to view a customer ...How to view the A/P aging report
In Paragon, you can see the balance you owe to your vendors through a variety of features. The AP aging report allows you to view your accounts payable filtered by currency, due date, customer, and more. Here, we'll show you how to view your balance ...Paragon Financials - Trial balance report
The trial balance report allows accountants to confirm that all entries that were posted in the general ledger for a given fiscal period are balanced. In simplest terms, the trial balance confirms that all debits equal all credits. This article will ...Print the GL Balances Report
Introduction Standardized financial reports may give you a snapshot of your business’ financial health, but aren’t as useful for analyzing and investigating the activity within each GL account down to the journal level. Paragon’s GL balances WIGO ...