AP Smart Spreadsheet Resources
- Warrant (check) pick-up is scheduled for Wednesdays.
- Electronic signatures or email approval will be accepted.
- Submit all vouchers at least 5 days prior to the payment due date.
If you have any questions, please email SpecialDist.AP@kingcounty.gov.
King County Oracle EBS Finance System - Documents and Downloads
On this page you will find information for Special Purpose Districts, Cities and Towns relating to the Oracle EBS financial system.
|This section is for special districts for which King County performs Warrant Issuance services.|
|AP "Smart" Spreadsheet: v2.0 | v2.1||v2.0 and v2.1||394 KB/247 KB||.xls|
|AP "Smart" Spreadsheet User Guide||v9||3.5 MB|
|AP "Smart" Spreadsheet Test Import CSV File (Warrant Data Entry)||v1.0||5 KB||.csv|
|AP Authorized Signature Form||073112||143 KB|
|AP Authorized Signature Form User Guide||101722||209 KB|
|Warrant Request Process - Quick Reference||101722||579 KB|
|If King County receives voucher payment requests from your district and prints your warrants, please contact Accounts Payable for questions regarding interfaced voucher files, warrants, affidavits, and warrant reports. Click here for contact information.|
Smart Spreadsheet and Axway FAQ
What should I do if I receive errors on the "Smart" Spreadsheet after upgrading to Windows 10 and Office 365?
Where can I find a newer version of the "Smart" Spreadsheet after encountering compatibility issues?
You may have experienced a connectivity issue or there may be invalid characters, such as extra double quotes, in the file.
Go to Axway and double check the uploads monitor to check if the .XLS file was uploaded instead of the csv file. If so, try uploading and selecting the csv file.
What should I do when my file is rejected for "The Total transaction value [AMOUNT VALUE]and the sum of transactions in the footer [FOOTER VALUE] does not match"?
What should I do when I receive the error "Duplicate Invoice Number - Invoice num - [INVOICE NUMBER VALUE] for Supplier [VENDOR NAME VALUE] already exists"?
Try using a fresh "Smart" Spreadsheet.
Go to "Configuration" tab and update the vendor options in Row 26 - "Use Vendor Tab for Warrant Entry?" You can choose "Yes" or "No" in the drop down menu.
Go to the "Configuration" tab of the "Smart" Spreadsheet to change the email address.