David Hands Email & Phone Number

Boca Raton, Florida, United States

• Reconstructed three previous years of the general ledger for two clients in Boca Raton, by obtaining supporting documentation, bank statements, credit card statements, purchase orders, sales orders, and meeting with management to understand the various one-off transactions. • Reconciled and analyzed all balance sheet accounts once reconstructed and established depreciation and amortization schedules as needed, set forth accrual and prepaid expense guidelines and proper accounting for each transaction.• Worked with Clarity Group and Sage Intacct support group to program and correct how the receipt of inventory and unit cost posted into the subledger and the timing of the entry onto the general ledger inventory account line for meaningful reconciliations.• Collaborated with the Sage Intacct support group to create a program to distribute freight cost to inventory units received for more meaningful inventory valuation and cost of goods sold.• Worked with the sales order and collection team to leverage future orders with any past dues and to departments to communicate daily.• Set guidelines and standards for the Accounts Receivable team for discounts taken based on terms and collecting discounts improperly taken.

Fort Lauderdale, Florida, United States

• Forecast and update the 12-month cash flow for the association and report and review with the Board of Directors• Create the annual budget for the Association, report and review with the Board of Directors and present it to the unit owners at the Annual General Meeting.• Collaborate with our Insurance agent for each year’s Flood and General Insurance for our commercial building, arranging annual building appraisals for insurance purposes.• Work with our property management company, Avalon Properties, and their bookkeeping department for proper coding of all invoices, and to review and approve monthly financial reports.• Coordinated with our bank’s loan department to reset the pass-through loan to those unit owners in the loan pool to finance their portion of the $2M current assessment.

Fort Lauderdale, Florida, United States

• Detected and corrected pricing issues with the three big retailers (Walmart, Walgreens, and Target) producing an additional $1.5M cashflow to the company.• Established monthly inventory reconciliation procedures on company’s NetSuite platform to the third-party fulfillment center platforms resulting in tighter control of the company’s assets.• Maintained the chart of accounts, coordinated with the outside accounting firm to realign the general ledger accounts for financial presentation, and restated 2016 through current year financial statements, creating year after year comparison reporting. • Developed an organizational chart, set up accounting controls, documented accounting procedures, cross trained accounting staff, and managed the accounting department.• Established financial statements with NetSuite, and QuickBooks for the various LLC companies, reconciled the intercompany accounts, and presented tax issues to the outside accounting firm.

Purchase, New York, United States

• Contributed to Sarbanes-Oxley (SOX) compliance by supporting prompt and accurate delivery of PepsiCo Headquarters financial statements; ensured alignment with internal control to allow for compliance certification. • Managed the PepsiCo Headquarters (HQ) income statement, balance sheet analytics, the tax provision, and all supporting schedules, divisional cross-charges and billings, bank reconciliations, and various general ledger closing procedures.• Led the periodic payroll account review meetings between management and Aon Hewitt.Select Contributions• Facilitated a smooth SAP general ledger blueprinting and conversion process while serving as business integration lead (BIL); additionally, led the conversion and implementation of SAP Human Capital Management software as subject matter expert (SME). Improved financial statement accuracy and reporting timelines and enabled real-time sales data by migrating to a single platform reporting environment for PepsiCo North America. Allowed for a central call center for customers and vendors across divisional lines. Identified and resolved post-conversion reporting requirement gaps. Delivered a single platform for payroll records for PepsiCo North America by achieving 100% consensus with the uniform mapping table for general ledger interface accounts. Eliminated the potential for FICA restart with team members transferring from one sector to another.• Played a key role in reducing the year-over-year year-end reporting timeline by 2 weeks; served on a team that streamlined year-end accrual processes and periodic reconciliations by defining and implementing guidelines and deliverable dates approved by senior management.• Served on a team that evaluated, analyzed, and supported the Corporate Treasury Department's implementation of Quantum software and mapping of the general ledger interface on the corporate and divisional levels; ran parallel data in a test environment and resolved all discrepancies.