- Perform Department of Treasury (TCIS) database research for payment confirmations and cancellations. Received a cancellation report from the Reports and Reconciliation department daily. Maintained the Check Cancellation Access database, researched the reason for the cancellation—bad address or bad banking—verified the type of payment, EFT or check, and verified the cancellation was not a duplicate payment. Obtained the EFT or check trace number, and processing date for research in the Treasury Check Information System – Bureau of the Fiscal Service (TCIS). If the payment was canceled, send a check or EFT cancellation letter to the assigned department.
- Research the IPP Invoice Processing Platform (IPP) system database to verify that the invoice was rejected for a canceled payment. Send a cancel check or EFT payment letter to the posting department.
- For canceling EFT or checking original payments, verified reissue payments were posted in GFMS and RFMS. Audited reissue payments for the correct payable amount, and in a timely manner.
- Participate in the 1099 Reporting and Task Force Team project, processing 1099 MISC, 1099 G, and 1099 INT tax forms with other DoS departments. Conduct research using DUN or CAGE identifiers, as well as TIN matching identifiers, on the IRS.gov database to verify vendor pertinent information. Followed ADR department flowchart procedures for missing TIN identifiers and incorrect TIN identifiers. Sent notifications to 1099 tax recipients for correct information. If GFMS or IRS information was incorrect, then updated data in the databases.
● Participated in the Quality Management Support task force project for reviewing department work instructions for Data Warehouse implementation. As well as updating several Audit, Distribution, and Reporting (ADR) department work instructions stored on the DoS Knowledge Base Internal Gateway for vendor management quality control processes.
Conduct research on the Invoice Processing Platform (IPP) system database to verify that purchase orders and invoices were paid in a timely manner. If invoice discrepancies exist for the amount, vendor code, address, or banking information, then contact the bureau certifying officer, vendor, or departments for corrective action.
- Perform reconciliation activities for the verification of vendor invoices to payments posted in RFMS and GFMS payment history details. Research invoice details for document or form ID, vendor activity query, invoice status query, payment detail query, and EFT/check query. If payment and invoices differ, such as in the case of duplicate payments or incorrect amounts, send corrective action with supporting documentation to the assigned staff and department.
- Assisted with the compilation and maintenance of the quarterly and annual financial statement Data Call Report for improper payments. The report data is sent to OMA for audit purposes.
● Maintained and reconciled the Improper Payment Access database for overpayments, underpayments, or payment record keeping. Export Access data into an Excel pivot table spreadsheet that is categorized for Claims/Invoices Outstanding, Claims/Invoices Collected, Accounts Receivables Outstanding, Accounts Receivables Collected, All Debt Collected, All Debt Outstanding, Invalid Debt, and Debt in Dispute. The Excel report is provided to ADR management and Accounts Receivable Management for decision-making.
Knowledgeable in federal tax rules and regulations regarding vendors. Access to the Sam.gov dataset for vendor management research. Ability to research vendor records linked from GFMS to the U.S. System for Award Management (SAM.gov) databases for accuracy and completeness. Posted vendor record modifications in GFMS to maintain a current and accurate vendor management database.
● Experience in completing, researching, and analyzing Vendor Reference file updates and modifications in the Department of State General Financial Management System (GFMS), the Department of Internal Revenue Service (IRS), and the U.S. System for Award Management (SAM.gov) databases.
- Adherence to Global Financial Operations ISO 9001 requirements by reviewing and following Quality Work instructions, reference documents, and DoS standards to ADR transactions met key performance indicators set by the DoS and the Audit, Reconciliation, and Distribution (ADR) department.
- Safeguard and secure PII information, and adhere to DoS standards and internal controls.
- Research and compile correspondence for the accuracy of the Potential Duplicate Payment Report received from the Office of Oversight Management and Analysis (OMA). Submit spreadsheet details in a timely manner to ADR management and OMA.
- Prepare and mail debt collection letters to parties that owe funds to DoS in compliance with the Fair Debt Collection Practices Act. If payments are received, then make copies and send them to AR for posting in a timely manner. If balances are cleared, send a cleared payment letter to the recipient, per debt collection requirements.
- Validate and audit accounting fiscal data lines, including fund appropriation and general ledger expense accounts, for invoices posted in GFMS or RFMS in a timely manner. If discrepancies exist on the invoice, then contact the bureau, department, or management for corrective action.
- Run the Invoice Approval Process Inventory report, and the Invoice Query Database report. The Invoice Process Inventory report shows the aged accounts payable invoices that are not marked as approved for payment, and their outstanding days past the due date. The Invoice Process Inventory database report shows rejected invoices that require correction before payment can be made.
- Create vendor and employee codes in the GFMS database, maintain vendor records, and update vendor records with changes to vendor names, addresses, or banking when necessary. When vendor records are posted to GFMS, and vendor codes are sent to the DoS department to post transactions in GFMS, such as the Wuhan project, new employee records, and new vendor records.
- Formulated oral and written responses to bureaus and internal departments on the creation, modification, and maintenance of the vendor management record database.
- Establish and maintain a cooperative relationship with bureaus, departments, and management.
- ● Maintain PII information in the information database in compliance with federal rules and regulations.