Question

Management wants a list of vendors with account balances as of 12/15/2024, sorted from the smallest to the largest amount outstanding. The following columns are to be included, from left to right: Active Status, Name (Vendor), Balance Total, Vendor Type, and Terms. Hint: Use the Vendor tab of the Vendor Center. Then change the view to include only vendors with open balances prior to sorting and printing.

Required:
Prepare and print the list requested by management.

Answer 1

The vendor list can be created by using the spreadsheet. The column 1 will show all the names of the vendor, the column next to the names of vendor will show the active status. This can be shown using the symbols or signs present in the tool bar of the spreadsheet.

Step-by-step explanation:

Spreadsheet makes the work easier for accountants. The list of vendor can be created with ease and it is easy for the user to sort and filter the data by just one click on the options. The vendor list will show the active list of the vendors along with their vendor type and balance totals.