Lacy Ferguson

● Self-motivated and responsible: performs all duties required with minimal requests for assistance.

● Trains and provides support to colleagues across all divisions (construction, engineering, environmental science) with Excel formatting, formulas, and spreadsheets. Cross-trains colleagues in accounting among all departments.

● Completes sales tax filings (multiple states: monthly, quarterly, and annually).

● Aides with daily logistics coordination and permit acquisition: comparing load dimensions and weights to state limitations, reviewing potential routing to avoid construction and other delays, and pulling permits and/or requesting a third party to pull permits.

● Weekly preparation of spreadsheets related to credit card transactions and Accounts Payable invoices, to information-match to GL codes, job/project numbers, and vendor names, for import into QuickBooks and/or Spectrum. This includes a "receipt status review" to document support for charges or payments made.

● Bi-Weekly reviews and recording of payroll. This involves receiving payroll data from Dominion and TimeLedger, reviewing the data for variances, and allocating all costs (labor, mileage, per diem, reimbursable expenses) to the appropriate direct/indirect jobs.

● Monthly reviews of account reconciliations, equipment rentals, lease/rental agreements, and vendor Certificate of Insurance statuses.

● Quarterly reviews of capital leases, Form 2290/IFTA/IRP filings, and state Highway Use Tax filings.

● Quarterly profit-and-loss compilations, which involves combining labor/wage information from TimeLedger to job/project costs from Spectrum and reviewing for discrepancies.

● Quarterly reconciliation and review of Debt Schedules and preparation of Loan Projections.

● Annually assists with financial audits from external and internal parties.

● Annually completes business licenses, Form 2290/IFTA/IRP renewals, and property tax filings.

• Assisted with audit preparation as well as quarterly and year-end closings
• Completed and reviewed general account reconciliations, including but not limited to: bank statements, claim expenses, fixed assets, lease accruals, and telecommunication accruals/expenses
• Answered accounting questions by researching and interpreting data
• Compared Pivot and/or SQL data to analyze accuracy or outliers
• Translated information into diagram, oral, or written form.