P/T Bookkeeper

Job Location: Ala Moana Compensation: $20-23/hour Employment Type: Temp to Hire - Part Time Work Schedule: Mon/Wed/Fri 10am-4pm Key Responsibilities Daily Operations Maintain the daily cash flow data worksheet by logging into the bank, tracking transactions, and recording sales from both retail and online store platforms. Complete and double‑check daily sales worksheets using bank records and online POS data. Post bank deposits and ACH/EFT transactions into QuickBooks, recording journal entry numbers accurately. Review company emails for incoming vendor invoices and monitor the physical mailbox. Execute bank runs to deposit cash sales from the retail store and assist with register change fund exchanges. Email updated cash flow sheets to management. Monthly Duties Prepare and complete G‑45 General Excise tax forms online by the 20th of each month. Process semi‑monthly payroll, post data to QuickBooks, and update yearly audit worksheets simultaneously. Complete marketing fund and percentage rent calculation worksheets for the retail store, and issue payments to the head quarter. Input and reconcile retail and online store inventory/transfer data into the cost of goods sold (COGS) worksheet, then post to QuickBooks. Conduct monthly bank reconciliations within QuickBooks once statements are available. Issue payments and cut checks for vendor bills, shipping labels, freight invoices, and employee reimbursements. Process monthly rent payments for the store, office, and seasonal warehouse by the 22nd of the month. Communicate with the retail team to request stock control reports and invoices via Lightspeed POS. Process invoices in QuickBooks based on store sales and pickup data. Attach digital copies of bank statements and monthly vendor bills (e.g., HMSA, Kaiser, FedEx) into QuickBooks for record‑keeping. Year‑End & Annual Duties Prepare and distribute Form 1099s via QuickBooks before the end of January. Complete the annual G‑49 GE tax filing online during October or November. Manage annual insurance audits by organizing and double‑checking monthly audit worksheets. Complete the yearly Temporary Disability Insurance (TDI) payment calculations using bi‑monthly payroll data. Generate the annual HEC report using figures from the W‑3 form. Provide necessary financial reports to external CPAs, input calculated depreciation amounts, and close/lock the fiscal year upon completion. Monitor and reorder administrative supplies (checks, envelopes) as needed. Required Skills and Qualifications Software Proficiency: Proven experience working with QuickBooks and POS systems (experience with Lightspeed POS is a plus). Technical Skills: Strong proficiency in Microsoft Excel for compiling data worksheets. Tax & Compliance Knowledge: Familiarity with payroll processing, 1099 compliance, and Hawaii General Excise Tax filings (G‑45 and G‑49) is preferred. Organization & Time Management: High level of efficiency with a proven ability to manage time‑sensitive daily and monthly financial deadlines. Transportation: Ability to travel locally to complete routine bank deposits as needed. #J-18808-Ljbffr Alliance Personnel Inc