If you have the Office add on,   use the AP -> TRANSFER function -> Custom Exports,

- Create a Export of the AP Invoices (choose the fields need to complete the task) , Criteria Date range (your fiscal year) and STATE, sort by ZIP code. - run report to EXCEL . There will be work to figure out the counties by your ZIPs Codes, use google to help, if you have the ZIP code list with Towns & counties, there are cool tools in excel "LOOKUP, XLOOKUP" that can add to your export and speed the process up.

If you have the Office add on,   use the AP -> TRANSFER function -> Custom Exports,

- Create a Export of the AP Invoices (choose the fields need to complete the task) , Criteria Date range (your fiscal year) and STATE, sort by ZIP code. - run report to EXCEL . There will be work to figure out the counties by your ZIPs Codes, use google to help, if you have the ZIP code list with Towns & counties, there are cool tools in excel "LOOKUP, XLOOKUP" that can add to your export and speed the process up.

Thank you.  I can't seem to get the break down between invoice amount and sales tax.  It's only showing the full payment amount.

I'm sorry. I assumed the data should be there.  I've done this before for the Customer side of things(CA? & NV), but not on the Vendor side.

For the future, you could use one of the 5 CUSTOM FIELDS in AP Vendors to mark the county in your State, the field name can also be altered in MAINTAIN A/P Parameters ->Custom Fields