Roberto Arranguez

Received payments, reconciled remittance advice, and created reconciliation reports for each client program. Corrected price discrepancies and assisted in audit compliance.

Prepared drafts and sent weekly invoices, updated billing entries, and ensured attorney and paralegal rates are correct. Assigned and consolidated emails/e-filings, recorded documents, and produced daily reports for billing corrections.

Updated transaction categories and manually created a dashboard report for budgeting and variance analysis. Maintained bank reconciliation, Income Statement, and Statement of Financial Position.

Updated eCommerce product listings, prices, and tax/shipping rates.

Updated bank reconciliation and Income Statement. Performed ad hoc tasks including data entry, research, event booking, and compiling and submitting answer sheets for all students in the program.

Added new cases, replenishment retainers, attorneys, and paralegals; created and sent monthly case bills and weekly billing/collections updates. Entered credit card and check payments, timeslips, and vendor expense slips; resolved billing discrepancies and revised amounts charged as needed.

Categorized all transactions; performed monthly bank and credit card reconciliations; reviewed duplicate and fraudulent charges; created journal entries for missing transactions and sales report discrepancies; updated the Chart of Accounts. Reviewed payroll reports for PH and US employees; computed PTO and quarterly bonuses; entered new US employee details; sent yearly W-2s; updated monthly attorn

Created recurring transactions for Accounts Receivable and updated bank reconciliation. Entered adjusting entries for advance payments and vendor bills.

Updated QuickBooks Desktop transaction categories and bank reconciliation.

Maintained Accounts Receivable, Accounts Payable, and Income Statement; updated vendor bills and payments in QuickBooks Desktop; performed monthly bank reconciliation. Linked Amazon and Walmart eCommerce products to ConnectBooks, checking for duplicate and incorrect invoices.

Updated prices and logos of eCommerce products.

Updated Income Statement and Statement of Financial Position. Submitted BIR tax filings (individual and quarterly).

Prepared financial reports, commission reports, income statements, and revenue forecasts for an eCommerce store selling hearing aids and accessories.

Updated job postings in the USA and Europe (Oracle experience) and for the PPG Ad Campaign. Trained new hires for the job search role.

Monitored phone numbers across campaigns using XenCall; imported and updated status of 1,800+ numbers three times daily using Zoho Sheets. Added and purchased new phone numbers for each campaign; assigned and monitored workstations for callers and admin staff.

Followed up on missing receipts from credit card users and sorted receipts uploaded in Wave. Entered vendor bills in QuickBooks Desktop; updated spreadsheets for new hires; assisted with accounting and HR tasks.

Updated shipment status in ChannelAdvisor with reference to ShipStation; scheduled meetings and supported the Internet Marketing Manager; managed the Trello taskboard. Updated Linnworks, eBay, BigCommerce, Newegg, and OfferUp with data and images, and resolved errors; added/imported products and ensured listing content was relevant. Revalued product prices in Google Sheets; imported products to Qu

Managed the entire AP process from vendor bill entry to payment; monitored the AP mailbox and assigned bills to team members. Researched and resolved invoice discrepancies and cost disputes; built vendor relationships. Submitted wires and ACH payments for approval; paid weekly bills ranging from $600K to $1M in QuickBooks Desktop. Recorded prepaid and accrual journal entries; managed credit card p

Handled the AP mailbox and inquiries; processed AP invoices in QuickBooks; reconciled large vendor bills and resolved cost disputes. Investigated duplicate charges and outstanding balances; obtained W-9 forms; paid vendors via credit card platforms. Sent monthly billing to customers and agencies, recorded Accounts Receivable, and collected outstanding balances. Performed daily bank reconciliation

Reviewed images for client websites, approving those that met client requests and rejecting those violating content policies.

Identified customer service needs and offered appropriate solutions; diagnosed and resolved basic network and modem issues. Guided customers through hardware/software configurations, scheduled technician dispatches, and escalated technical issues when needed.

Ranked top agent in the Online Refill team for consecutive months; processed 120+ patients daily. Resolved inquiries on first call (benefits, eligibility, claims, financial spending accounts, correspondence) and coordinated with doctors’ offices for scheduling and specialist connections. Met goals for efficiency, call quality, customer satisfaction, first call resolution, and attendance.

Prepared Cash Disbursements Book, Cash Receipts Book, General Ledger, and General Journal; prepared monthly bank reconciliations. Issued and filed Journal Vouchers; checked liquidation reports and petty cash expenses; recorded meeting minutes.

Prepared books and ledgers, inventoried main office assets, issued Journal Vouchers, and assisted the accountant with timely reports. Prepared monthly meeting minutes and checked petty cash liquidations.

Pursued a Bachelor's degree in Accounting.

Pursued a Bachelor's degree in Accounting Technology/Technician and Bookkeeping.