PSA Reports - Vendor Totals: How to Export Vendor Audit into Excel and Sort on Vendor Totals

How to Export Vendor Audit into Excel and Sort on Vendor Totals

In Ledger & Payables, click Reports→Vendors→Vendor Audit, select the Date Range and Vendors you would like to report and click Preview Report.
 
  1. Export the report using CSV (comma separated value) and open in Microsoft Excel.  **Note**  Please use the preceding link to export your file as you must save the file to disk before opening the file or it will open in a text editor.
  2. Insert two new blank columns (A and B) to the left of the vendor Name. 
  3. In column A, insert the following formula and copy down to all rows in your spreadsheet 
    • =IF(ISNUMBER(C9)=TRUE,"",IF(C9="","",IF(C9=" ","",VLOOKUP("Vendor Total:",F9:H9999,3,FALSE))))
  4. Copy column A, then right-click into column B and choose Paste Special. Choose Values and click OK.
  5. Delete Column A (which contains the formula) and the values which were in column B are now in column A.
  6. Sort the report on Column A (either Ascending or Descending) and delete the extra rows.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request