Accounts
Payable
—
Hard
Skills
M O S T
I N
-
D E M AN D
—
R AN K E D
01
Full
-
cycle
invoice
processing
Appears
in
~92%
of
postings
02
Three
-
way
match
(
PO
·
receipt
·
invoice
)
Core
AP
control
03
ERP
/
AP
automation
software
SAP
,
NetSuite
,
Oracle
,
Dynamics
04
General
ledger
coding
&
month
-
end
close
Accounting
fundamentals
05
Advanced
Excel
XLOOKUP
,
PivotTables
,
Power
Query
06
ACH
&
wire
payment
processing
Payment
run
execution
07
Vendor
statement
reconciliation
Discrepancy
resolution
08
1099 /
W
-9
preparation
&
TIN
matching
US
tax
compliance
09
SOX
internal
controls
&
segregation
of
duties
Audit
-
facing
10
Aging
report
&
AP
KPI
analysis
DPO
,
cycle
time
,
cost
per
invoice
FU L L
S K I L L
BR E AK D O WN
1 / 3
01
Core
Accounts
Payable
Functions
02
Invoice
&
Document
Processing
03
Accounting
&
Reconciliation
04
AP
Software
&
ERP
Systems
Full
-
cycle
accounts
payable
processing
end
to
end
Invoice
intake
,
coding
,
and
approval
routing
Three
-
way
match
—
purchase
order
,
goods
receipt
,
invoice
Two
-
way
and
four
-
way
invoice
matching
Payment
run
scheduling
and
batch
preparation
Vendor
statement
reconciliation
AP
aging
analysis
and
past
-
due
management
Employee
expense
report
review
and
reimbursement
Petty
cash
and
imprest
fund
administration
Check
run
coordination
and
payment
release
PO
-
based
and
non
-
PO
invoice
processing
High
-
volume
invoice
entry
(500+
invoices
per
week
)
OCR
and
intelligent
document
capture
workflows
E
-
invoicing
and
EDI
810
invoice
transmission
Duplicate
invoice
detection
and
prevention
Invoice
exception
and
hold
-
queue
resolution
Credit
memo
and
debit
memo
application
Recurring
,
subscription
,
and
utility
invoice
handling
Vendor
invoice
portal
management
Document
imaging
,
indexing
,
and
archiving
General
ledger
account
coding
Month
-
end
AP
close
procedures
Accrual
and
prepaid
expense
entries
Journal
entry
preparation
and
posting
Vendor
balance
and
subledger
reconciliation
AP
subledger
-
to
-
GL
reconciliation
Bank
reconciliation
and
cash
clearing
accounts
Intercompany
payable
processing
and
settlement
Unapplied
cash
and
unvouchered
liability
resolution
Year
-
end
close
and
audit
schedule
preparation
SAP
S
/4
HANA
—
FI
-
AP
module
SAP
ECC
accounts
payable
Oracle
NetSuite
Oracle
Fusion
Cloud
Financials
Oracle
E
-
Business
Suite
(
AP
)
Microsoft
Dynamics
365
Finance
Microsoft
Dynamics
GP
Workday
Financial
Management
Sage
Intacct
QuickBooks
Online
and
Desktop
Coupa
and
SAP
Ariba
procure
-
to
-
pay
Concur
Invoice
and
Bill
.
com
Tipalti
,
AvidXchange
,
Stampli
2 / 3
05
Payments
,
Banking
&
Treasury
06
Compliance
,
Controls
&
Tax
07
Reporting
,
Analysis
&
Tools
08
Vendor
&
Stakeholder
Management
ACH
payment
origination
and
processing
Domestic
and
international
wire
transfers
Check
printing
and
positive
pay
administration
Virtual
card
and
p
-
card
program
administration
Payment
file
formats
—
NACHA
,
ISO
20022,
BAI
2
Multi
-
currency
payment
processing
FX
rate
application
and
settlement
handling
Early
payment
discount
capture
(
e
.
g
. 2/10
net
30)
Payment
term
setup
and
renegotiation
Cash
forecasting
data
inputs
and
payment
float
tracking
SOX
404
internal
controls
over
AP
processes
Segregation
of
duties
design
and
monitoring
Vendor
master
data
governance
W
-9
collection
and
IRS
TIN
matching
1099-
NEC
and
1099-
MISC
preparation
and
filing
1042-
S
reporting
for
foreign
vendors
Sales
and
use
tax
accrual
on
invoices
VAT
and
GST
input
tax
recovery
Unclaimed
property
and
escheatment
compliance
Internal
and
external
audit
support
Duplicate
and
fictitious
vendor
fraud
detection
Policy
exception
tracking
and
remediation
Accounts
payable
aging
report
preparation
Days
payable
outstanding
(
DPO
)
calculation
and
analysis
Spend
analysis
by
category
,
vendor
,
and
cost
center
AP
KPI
dashboards
—
cycle
time
,
cost
per
invoice
,
error
rate
Advanced
Excel
—
XLOOKUP
,
INDEX
/
MATCH
,
SUMIFS
,
PivotTables
Power
Query
and
Power
Pivot
data
modeling
Power
BI
and
Tableau
reporting
SQL
querying
for
AP
and
vendor
datasets
RPA
and
workflow
automation
—
Power
Automate
,
UiPath
Process
documentation
and
SOP
writing
Vendor
relationship
management
Vendor
dispute
and
open
inquiry
resolution
Statement
and
balance
confirmation
requests
Vendor
onboarding
and
due
diligence
Approval
workflow
design
and
management
Cross
-
functional
collaboration
—
procurement
,
treasury
,
department
heads
Contract
and
payment
term
review
SLA
monitoring
and
escalation
handling
Month
-
end
and
audit
inquiry
request
handling
3 / 3