Payables aging details reports

Payables aging details reports

Accounts payable aging report shows the balances you owe to others. 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 report helps you visualize amounts you owe. Using accounts payable aging report 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 Details Reports

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

Aging Details

FIELDS

DESCRIPTION

Customize report

Users can filter the report data using the customize report option. The reports can filter between certain due dates, according to a particular product, certain suppliers, type of invoice which is purchase/bill, and by reference number. 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.

#

The Serial number of the data included in the table.

Supplier name

Shows the supplier name of the particular transaction in this column

Type

The type of transaction which is bill/purchase is mentioned in this column

Ref no

The reference number of the transaction is included in this column

Purchase date

The date of the transaction is mentioned here

Due date

This column refers to the payment due date of the transaction

Age(days)

Age days refers to the number of days passed after the due date. Or the overdue date.

Amount

The total amount of the transaction is referred to in this column.

Paid amount

The amount paid to the supplier by the user is included in this column

Balance

The balance amount to be paid will be shown in here

Summary

Shows the summary of that particular transaction which is due between how many days is represented here for example. Due between 1-15 days, 16-30 etc.

Exit

Users can close the aging details reports window by clicking the exit button.

Aging Details.

1.Page setup option bar: 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 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.

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

 

3.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.

4.Exit:  Users can close the aging details reports window by clicking the exit button.

 

Frequently Asked Questions?

01How to check payment details of my supplier?

  • Click on the Reports module.
  • Select the report Aging Details from Payables head.
  • At the right hand side of the data table, supplier payment details are included.
  • It shows details of total invoice amount, Paid amount and balance payment amount towards the supplier.

02What is the use of Customize Report option in Aging Details report?

In the report, Customize menu helps you to filter the aging details data. By clicking on the customize report, you can filter the report by selecting a particular supplier, entering a reference number or by selecting due date between.

  • Click on the Reports module.
  • Select the report Aging Details from Payables head.
  • Click on the Customize Report menu.
  • By clicking on the customize report, you can filter the report by supplier, reference number or by due date between. Select any one of the option to filter the report.
  • Click on Run Report to get the customize data.

03What type of invoice details are shown in the Aging Details report?

The report shows the details of two types of invoices. They are purchase invoices and Bills.

04How can I export the data in to Excel format?

  • Click on the Reports module.
  • Select the reports Aging Details 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.

05How can I take print out of the Aging Details report?

  • Click on the Reports module.
  • Select the reports Aging Details 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 report.