Why run an aged accounts payable report?
You can use the Aged Accounts Payables Report in Wiise to show purchase invoices that the business hasn’t paid for yet. You can run this report periodically to see what is and will be due to help you keep track of payments.
1. Log in to Wiise from your mobile, tablet or any browser.
2. Search for the Aged Accounts Payable report. Or select Reports and then Aged Accounts Payable.
3. In the Options page that opens, enter the details like this:
- Aged As of: this is the date from when you want to calculate the invoices are due. If the Aged As of date is the last day of the month, it compares that to the due date of the invoice to decide whether it’s due or not.
- Ageing By: select Due Date if you know the payment terms code that was selected on the invoice. Select the Posting Date if you want the due date calculation to start from when the invoice was actually completed. Usually this is Due Date.
- Period Length: enter the period that will be shown in the report. For example, enter ‘1M’ for one month, ‘30D’ for thirty days, ‘3Q’ for three quarters or ‘2Y’ for two years. Usually this is 1M (1 month).
- Print Amounts in LCY: This is only used if you have invoices posted in a foreign currency. Usually, this is set to OFF.
- Print Details: Select ON if you want to see the detailed entries of each vendor balance.
- Heading Type: Select if the heading for the periods will show a date interval or the number of days overdue.
- New Page per Vendor: this is where you select if each vendor’s information is printed on a new page of the report.
12. In the Vendor section, you can filter by a field on the Vendor record if you don’t want to run the report for all vendors. You would usually leave this blank, so all vendors are included.
13. Then to run the report, select Preview or Send To… (PDF, Word or Excel Document).
Great! Now you'll now be able to see the amounts the business owes its suppliers.