Part-Time Accounts Receivable / Accounts Payable (AR/AP) Clerk
Job Description
Job Description
Job Title: Accounts Receivable / Accounts Payable (AR/AP) Clerk – Reporting & Excel Pro
Location: Gahanna, OH – Hybrid (onsite & WFH)
Employment Type: Part-Time (1099)
Compensation: Based on Experience
Responsibilities:
-
Process and record accounts receivable and accounts payable transactions in accounting software
-
Generate invoices, track payments, and follow up on overdue accounts
-
Match purchase orders, invoices, and receipts for accuracy before processing payments
-
Create, maintain, and analyze financial reports using Excel (pivot tables, formulas, charts) and other reporting tools
-
Reconcile accounts and vendor statements, resolving discrepancies quickly
-
Prepare weekly, monthly, and ad-hoc reports for management decision-making
-
Maintain organized and accurate financial records
-
Assist with payroll preparation and other accounting/admin tasks as needed
-
Communicate with clients and vendors regarding account matters
Requirements:
-
1–2 years of AR/AP, bookkeeping, or accounting experience (small business experience a plus)
-
Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, formulas, data analysis)
-
Experience creating dashboards and automated reports a plus
-
Proficiency with QuickBooks, Xero, or similar accounting software
-
Strong attention to detail and accuracy
-
Excellent organizational and time management skills
-
Ability to handle sensitive information with confidentiality
-
Strong communication skills (written and verbal)
-
Self-motivated and able to work independently
Preferred Qualifications:
-
Experience in the construction, or service industry
-
Basic understanding of payroll processing
-
Bilingual (English/Spanish) is a plus