Supplier balances reports

Supplier balances reports

The supplier balances report in ACCOXI gives details of all the supplier balances during the period. This report lists the supplier name, total due, excess payment, paid amount and balance. In ACCOXI supplier balance reports can be accessed from report modules and by selecting payables reports.

Supplier Balances

Supplier Balances Reports

FIELDS

DESCRIPTION

Customize report

Users can filter the report data using the customize report option. The reports can be filtered between certain due dates, with certain suppliers 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 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

Total due

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

Excess payment

Amount paid more than the total due will be shown 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

Pagination control

 

 

It controls the page navigation and fetches data

 

Exit

 

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

 

Options available in print report menu:

Supplier Balances (1)

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 the last page
  • And it also shows the current page number and the otal 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 the 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 the 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 supplier balances reports window by clicking the exit button.

 

Frequently Asked Questions?

01What is the content of Supplier balances report in Accoxi?

The Supplier Balances report in Accoxi gives details of all the Supplier Invoices during the period. This report lists the details of suppliers such as supplier name, total due, excess payment, paid amount and balance.

02Can I export the Supplier balances data in to Excel format?

Yes. You can export the Supplier Balances report by using the following steps,

  • Click on the Reports module.
  • Select the option Supplier Balances 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.

03How can I filter the Supplier Balances report?

  • Click on the Reports module.
  • Select the option Supplier Balances from Payables head.
  • Click on the Customize Report menu.
  • By clicking on the Customize report, you can filter the report by Date or by Supplier. Select any one of the option to filter the report.
  • Click on Run Report to get the customize data.

04What represent the Excess payment column in Supplier Balances report?

Excess payment column indicates, the amount paid more than the total due of amount towards the suppliers. In this report details of all the suppliers along with supplier name, total due, excess payment, paid amount and balance are shown.

05How to take print out of Supplier Balances data with complete list of Suppliers?

  • Click on the Reports module.
  • Select the option Supplier Balances 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 with the data of complete list of suppliers.
  • 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.