Accounting And Bookkeeping Specialist AR AP

Job Overview

Our client is seeking a highly organized, detail-driven Bookkeeper who is exceptional in Excel and comfortable managing financial records using custom-built spreadsheets. This role is critical to keeping our finances clean, accurate, and easy to understand—especially Accounts Receivable (AR), Accounts Payable (AP), and sales tracking.

If you enjoy building systems, maintaining structure, and making numbers tell a clear story, this role is for you.

Schedule

• Monday - Friday, 10:00 AM - 7:00 PM, PST, with 1 hour unpaid/paid break (40 work hours per week)

Key Responsibilities

Accounts Receivable (AR)

• Track all incoming payments, invoices, and outstanding balances
• Maintain up-to-date AR aging reports
• Follow up on unpaid invoices and flag overdue accounts
• Reconcile customer payments against sales records

Accounts Payable (AP)

• Track vendor bills, payment schedules, and due dates
• Maintain AP aging and ensure timely payments
• Reconcile vendor statements and resolve discrepancies
• Organize all invoices and payment records digitally

Sales & Revenue Tracking

• Track sales across multiple channels using a custom Excel system
• Ensure sales data ties out with AR and bank activity
• Maintain weekly and monthly sales summaries
• Identify inconsistencies or missing data proactively

Excel & Financial Systems

• Maintain and update custom-built Excel documents used for:AR & AP tracking
• Sales reporting
• Cash flow visibility
• Improve and organize the spreadsheet structure for accuracy and usability
• Ensure data integrity and version control
• Create clear reports for management review

General Bookkeeping

• Reconcile bank and credit card accounts
• Maintain clean, audit-ready financial records
• Assist with monthly close and financial reporting
• Support CPA or an external accountant as needed

Qualifications

• Proven experience as a Bookkeeper or Accounting Specialist
• Advanced Excel skills (formulas, pivot tables, lookups, structured tracking)
• Strong experience managing AR, AP, and sales tracking
• Highly organized with strong attention to detail
• Comfortable working with custom systems rather than off-the-shelf software
• Ability to spot errors and inconsistencies quickly
• Reliable, discreet, and trustworthy with financial data

Independent Contractor Perks

• Health Insurance Coverage for eligible locations
• Permanent work-from-home
• Immediate hiring

Note

• Please click the "Apply" button to complete your application, including the assessment questions, technical check, and voice recording. Your hourly pay rate will be established based on your performance in the application process; submissions with all requirements fulfilled will receive priority review.

51274379609