Neil Menard Email and Phone Number

-Experience in Oracle Netsuite-Prepare and post journal entries for prepaid expenses-Update supporting schedules -Bank Reconciliations-Petty Cash Reconciliations-Recording incoming payments as journal entries and payments against AR invoices-Reviewing AP invoices for proper coding-Billing of customer invoices-Filing monthly use tax returns in several different states

Posting customer payments and billing customer invoices in Sage Intact.Running credit checks on new customers.Producing employee man hour reports for customers and HR department.Maintaining Master Service Agreements and Certificates of Insurance.Completing Prequalification forms for new customers.Submitting customer invoices via E-Invoicing platforms(ADP, iSupplier).

Exporting customer invoices from RTMS billing database to SAP Accounting package.Knowledgeable in VLOOKUP and pivot table functions in Microsoft Excel.Knowledgeable in extracting and omitting select data from cells in Microsoft Excel (MID function).Knowledgeable in merging data from multiple worksheets and multiple cells in Microsoft Excel.Producing weekly and monthly consolidated Accounts Receivable reports in SAP for upper management.Reconciliation of the Accounts Receivable aging reports to the general ledger.Customer payment processing in SAP. Adjusting customer A/R balances in SAP and coding to the applicable GL accounts(revenue, sales tax, allowance for doubtful accounts).Netting of Accounts Receivable and Accounts Payable in SAP for customers who are also vendors.Producing customer revenue by top dollar analysis in pivot table format.Researching customer payment history in SAP.Completing vendor packets for new customers as credit has been established.Completing ACH enrollment forms for customers who transition their method of payment from paper check to direct deposit.Assistant to Treasury Manager-Wiring funds to pay vendors and employee benefits. Also, funding AP check runs and hourly/salary payrolls. Uploading AP positive pay files to the bank website and initiating stop payment requests as authorized. Setting up and modifying vendor ACH/Wire templates on the bank website. Processing deposits via remote deposit scanner.Producing monthly detailed revenue by GL and sales tax reports in RTMS.Providing information requested by auditors (A/R confirmation letters, customer payment support, customer invoice/delivery ticket backup) and responding to follow up questions during colatteral and annual audits.