Payables aging summary reports

Payables aging summary reports

Accounts payable aging summary shows the number of overdue dates and amounts of the payables to a particular supplier. The debts consist of inventory, supplies, and services you buy to operate your business. The aging of accounts payable tracks who your creditors are, how much you owe, and how long you’ve owed debts. An aging report is a tool that organizes your business’s accounts payable balances. Accounts payables are amounts you owe to vendors. You incur payables when you receive a good or service on credit. The supplier invoices you, and then you pay them on a later date. Accounts payable aging summary helps you visualize amounts you owe. Using the accounts payable aging summary gives you an easy way to handle your debts. Accounts payable aging (tabulated via an aged payables report) is a periodic report that categorizes a company's accounts payables according to the length of time an invoice has been outstanding. It is used as a gauge to determine the financial health of a company.

Payables Aging Summary Reports

In ACCOXI aging reports can be accessed from report modules and by selecting payables reports.

Aging Summary

FIELDS

DESCRIPTION

Customize report

Users can filter the report data using the customize report option. The reports can be filtered using the name of the supplier and Then by clicking run report user will get the filtered details of the report.

 

Print

Users can print the reports in the reports module  by clicking the print button user will be redirected to the report view menu where the user can print the reports and the user can also export the report data into an excel sheet, pdf file etc. 

#

Serial number of the data included in the table.

Supplier name

Shows the supplier name of the particular transaction in this column

Current

The current column includes the amount to be paid to a supplier which is on the due date. Or in other words the amounts that will due on the current date be shown in this column.

1-15 days

In this column the amounts due to a supplier between 1-15 days are included here

16-30 days

In this column the amounts due to a supplier between 16-30 days are included here

31-45days

In this column the amounts due to a supplier between 31-45 days are included here

>45 days

In this column the amounts due to a supplier more than 45 days are included here

Total

The total overdue amount to a supplier is shown in this column

Pagination control

 

 

It controls the page navigation and fetches data

 

Exit

 

Below the pagination control, there is an exit button. If the user wants to exit the reports page click on the exit button.

 

Aging Summary Print

1.Page setup option bar:

2.Users can adjust the page view using the page setup option bar.

  • Users can refresh the page to update any changes made.
  • Users can navigate the page using the first page, previous page, next page and the last page
  • And it also shows the current page number and the total number of pages of the report.
  • And by giving page number in the current page number box and pressing enter. It jumps to the said page.
  • The page setup button allows the user to define the paper size, orientation and margins of the report.
  • User can switch between interactive layout and print preview layout using the switch button
  • The adjustment of the zoom size of the report is also available in the page setup bar.

3.Print: Users can print the reports in the reports module by clicking the print button user will be redirected to print setup window where the user can adjust the print options.

4.Export: ACCOXI provides the feature for the user to export the report data into different file formats like excel, pdf, rtf, csv, MHTML, image etc.by clicking the export button user will be redirected to save as window where user can input the file save location and file format.

5.Exit:  Users can close the aging summary reports window by clicking the exit button.

Frequently Asked Questions?

01What is the content of aging summary of payables report in Accoxi?

ACCOXI provides the module of Reports and Aging Summary of Payables are included in it. This report shows the Over Due Amount payable and the No of Days the amount crossed the due date. The debts consist of inventory purchase, supplies, and services you buy to operate your business. The aging of accounts payable tracks your creditors, how much you owe, and how long you’ve owed debts. An aging report is a tool that organizes your business’s accounts payable balances. 

02How can I export the Aging summary data in to Excel format?

  • Click on the Reports module.
  • Select the option Aging Summary from Payables head.
  • At the right hand side of the report, there is a Print menu.
  • Click on the Print menu and it opens the print view form.
  • Click on the Export menu at the bottom right side of the page.
  • New tab will appear for save the file. You can select the location to save the file.
  • Click on save button to save the data in Excel format.

03If I pay the amount on due date, will it reflect in Aging Summary report?

No. It will not reflect in Aging Summary report. The due amount payable to the suppliers are shown in this report.

04How can I check the aging summary of paid suppliers?

  • Click on the Reports module.
  • Select the option Aging Summary from Payables head.
  • Aging summary details to the supplier opens and aging days of payment towards the suppliers are included in the table data.

 

05How to take print out of aging summary with complete list of suppliers?

  • Click on the Reports module.
  • Select the option Aging Summary from Payables head.
  • At the right hand side of the report, there is a Print menu.
  • Click on the Print menu and it opens the print view form.
  • You can set the page range, page height, width and can enter the required number of copies here.
  • Click on the Print menu to get the printout of the aging summary report.