San Diego, California, United States
A detailed-oriented Senior Accountant with 10 years+ of experience in government, public and private accounting. Knowledge of cash management, trust funds accounting, fiscal, audit, contracts, payroll, accounts payable, accounts receivable, financial and budget analysis, cost accounting and tax accounting.
Department of Public Works, Road – Financial Services, Reporting/Rates/Audits unit o Lead the Reporting/Rates/Audit unit. Manage hiring, training, coordinating, and overseeing team members. o Lead Director Transition Audit and other Audits in the unit and division. Review & audit Trial Balance. o Oracle Financial Authorizer (OFA): Approve CSRF, review, and maintain segregation of Oracle responsibilities, and respond to ERP inquiries. Sign off on ERP reports. o Review PNG Project Maintenance requests- projects & tasks creation/update/close in Oracle. o Review and approve Monthly Bank Recon. Approve DART allocation, Deposit, and Transfer batches. o Review and approve GASB87 Lease Inventory Accounting & External Audit Tracking for internal reporting to managers and Office of Audits & Advisory Services (OAAS) quarterly. o Review and approve Capital Asset Request Form 253 for add new asset or removal of old asset (salvage). o Review and approve Department of Public Works (DPW)- Form 163 for minor equipment and cell phone. o Handle Indirect Cost Proposal (ICRP) calculation and submit to Dept of Transportation (DOT) and California Dept of Transportation (CALTRANS) for approval. Overall Fiscal Year End (FYE) reporting coordinator. o Manage Overhead (Class & Burden) Rates calculation for DPW including submitting to supervisor for review and to Auditor & Controller (A&C) for approval, indexing rates in Oracle, and assist in providing fully loaded rates to Private Development Construction Inspection (PDCI) unit for Land Development’s Fees Package. o Handle Annual Road Fund Work Schedule State Report submit to Office of Financial Planning (OFP). o Update policies & procedure including research and analysis for assigned team/group. o Supervise an Associate Accountant (who supervises an Accounting Technician).
Department of Public Works, Road – Financial Services, Accounts Receivable (AR) unit o Handle AR Receipt write-off as request by program staff for refund or special adjustments. o Handle GASB 87 Lease Inventory Accounting- Revenue Leases including monthly maintenance, quarterly reporting, year-end reporting- AR. o Process- Private Development Construction Inspection (PDCI)- Developer Deposits including ACCELA (BCMS-county’s permit system) -PNG Recon on Developers Deposits. o Process AR Form AUD213 for quarterly and yearly reporting for all DPW AR accounts. o Manage PNG Award Maintenance- Create, close, and update/linking awards. Review and enter in Oracle o Manage PNG Event Entry for Accela Awards for PDCI (Private Development Construction Inspection). o Handle Public Works Airports (PWA) Deferred Customers AR balance and manual receipt application. o Tracking all long-term-account receivable, unearned revenues, and deferred revenues. o Update policies & procedure including research and analysis for assigned team/group. o Perform monthly TIF (Transportation Impact Fee), RTCIP (Regional Transportation Congestion Improvement Program), Pre-TIF (Future Improvement Program) Trust Funds reconciliation and reporting. o Review and approve Drainage, Rancho Del Campo & Live Oak Springs funds/accounts reconciliation. o Review and approve Quarterly Interest Income Allocation (Apportionment) for TIF, Pre-TIF, RTCIP, and Drainage Funds. Approve DART Reallocation and Transfer batches. o Handle daily Financial Risk Assessment & Controls (FRAC) reconciliation for AR accounts: 11179, 11192, and 11193 to report to Dept of Planning & Development Services for 44600 Trust Fund Monthly Recon. o Review and update PDCI AR Utilities billings and link records to AR Utilities sets. o An AR subject matter expert includes understanding general Accounting and Oracle GL accounting. Accela (BCMS- county’s permit system) subject matter expert. o Supervise two Accounting Technicians.
Department of Planning & Development Services, Trust Account Customer Service Unit o Prepare the daily Oracle DART Deposit for Accela collections for Planning & Development Services (PDS), Department of Environmental Health and Quality (DEHQ), Air Pollution Control District (APCD), Agriculture, Weights and Measures (AWM), Department of Public Works (DPW), Department of Parks and Recreation (DPR), and Fire Authority in the Office of Emergency Services (OES). This task includes but is not limited to a detailed bank reconciliation of PDS collections, the reconciliation of Accela collections deposited to multiple bank accounts for all 7 departments. o Perform monthly reconciliation for several funds and accounts such as the Community Service Agency Trust Fund (44600 fund with approximately $20 millions), the Accounts Receivable fund/account, Suspense Trust Fund, and PDS’s Clearing Account for Accela (the County’s permit/financial system) transactions. o Handle the County Counsel charges which record in Accela to bill the customer accounts. o Process the department’s Returned Checks/Items for both over the counter and online transactions. o Prepare and process several DART Transfer reallocations of expenses for the monthly merchant services credit card fees (over-the counter and online payments). o Prepare and process the quarterly billing services rendered by PDS cashiers to other departments. o Supervised one Staff Accountant responsible for the cashiering activities, returned warrant, unclaimed money, Change of FINRESP, discharge of accountability, bankruptcy, and bonds for the department. o Perform Fiscal Year End Reporting- Due To/Due From DART Transfers (cash in transit transfers) for 7 departments. o Backup for the trust account creations and labor corrections in Accela, finance related Public Act Requests, and Accela (BCMS-county’s permit system) Subject Matter Expert for Finance unit. o Supervise a Staff Accountant (Cashiers’ supervisor).
• A/P o Audit, analyze, & reconcile the budget control amounts. o Review Consultant Contracts, Employment Agreement, Clinical Research Agreements, & Purchase Agreements. o Prepare & organize supporting documents for internal & external audits by complying w/ SOX 404 (The Sarbanes-Oxley Act Section 404) & KPMG auditors. o Maintain, reconcile, and analyze variances of PO Invoices: Blanket PO, Contract Invoices, Lab Supplies Invoices, and Service Invoices. o Handle AP aging, accrued expenses reconciliation, open PO listings & other info needed for SEC fillings. o Maintain vendor records in the accounting system, including W-9s and new vendors. Knowledge in sales and used taxes. Prepare annual 1099’s for vendors. o Review and analyze General Ledger reports, e.g., Accruals, Pre-paid Expense, Depreciation, & International Exchange Rate Gain & Loss. o Reconcile the Reimbursement Reports, Banks Statements, General Ledger Accounts. o Able to access company’s checking, savings, and credit cards bank statements to reconcile & analyze the un-cleared transactions. • Payroll o Process payroll for approx 90 employees. o Comply with Internal Revenue Service (IRS) Regulations & Publication, i.e., Pub 15 for internal control. o Handle garnishments, hiring bonuses, annual bonuses & awards, severance pays, & adjustments. o Audit employees’ benefits reports. o Handle payroll audits such as EDD audit, worker compensation audit...etc.. o Prepares follow up Stop Payment & manual check requests. o Reconcile & approve journal entries from subordinates, e.g., Payroll Taxes Accruals, Vacation/PTO Accruals, & Bonus Accruals prior to close the accounting books. o Review Employees’ Salary records & report to Controller to ensure accurate info in Paylocity. o Reconcile W-2s with Labor Distribution YTD report at YE. o Review payroll batches in Paylocity, e.g., garnishments, one-time payments, hours worked, overtime, & adjustments. o Comply w/ the SOX 404 (The Sarbanes-Oxley Act Section 404).
• Accounts Payable o Perform accounts payable functions for manufacturing expenses, manage vendor accounts, and generate weekly checks. o Monitor, review, and analyze vendors’ invoices against Purchase Orders and receipts (3 ways matching) to find variances prior to post in accounting ERP system daily by using excel workbooks. o Verify around 300 to 400 invoices per week for services and purchases. o Code general ledger accounts for goods and services of Non-Purchase Order and Purchase Order invoices. o Accrue used and sales taxes as needed. Wired payments to domestic and foreign vendors. o Responsible for annual 1099 and 1042 tax forms for vendors, contractors, and licensors. • Royalty (a specific form of Accounts Payable) o Review and analyze Royalty Agreement with Licensors/Grantors before process payment for their percentage of gross or net revenues derived from the use of a fixed price per unit sold of an item of such by monthly, quarterly, and yearly. o Calculate the patents percentage to pay out to Licensors/Grantors by using Excel. o Monitor, review, and analyze the royalty accounts quarterly by using Excel. o Conduct a review in Royalty Database System to check licensors’ profiles, e.g., name, address, rate, terms and condition. o Generate around 500 royalty quarterly reports to analyze and reconcile with the Master report. • Accounts Receivable o Monitor, review, analyze, and reconcile customers’ payments against invoices and credit memo to uncover inconsistencies daily. o Record accounts receivable transactions into the accounting system for collaboration agreements. o Process income cash receipt against the receivables. o Process ACH/Wire payments in ERP Financial System. o Review and approve customers based on their payment history to provide the payment terms.
o Monitor, reconcile, and analyze trust funds accounts: Surplus Fund, Third-Party Funds, Reinstatement and Pay-off by using excel workbooks. o Process the company’s trust fund accounts and the transactions into automation financial system (TESS) and accounting ERP system. o Audit the trust funds accounts for refunds to customers. o Verify and enter the invoices to accounting system ERP System DAX (Microsoft Dynamic). o Verify invoices for fees and costs through Title/Escrow Company website and RVI automation system, o Review and analyze claims from employees, suppliers, and service providers.