General Ledger System Admin

Virginia Estacio-Monteagudo

Ph 718-***-**** Email -***************@*****.*** Address: Bergenfield, NJ USA

TECHNICAL SKILLS:

NetSuite OneWorld, (Record-to-Report (R2R), Lead-to-Order (L2O), Order-to-Cash (O2C), Procure-to-Pay (P2P), NetSuite SCIS, NetSuite Suite Commerce point of sale., GCS, A2000, IBM AS400, PayPro, Pro Health, QuickBooks, Peachtree (aka Sage 50), Microsoft Great Plains, Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Medrina LLC August 1, 2024 – January 15, 2025

Netsuite/System Admin/Accountant/Consultant ( Medical/Physiatrists/Healthcare Provider)

Assist in reconstruction of books of multiple companies & subsidiaries from Quickbooks to Netsuite from 2023 to year 2024.

Preparation of Checks, deposit, journal entries to build up the general ledger book by book & bank accounts in Netsuite.

Review existing entries in Quickbooks to be able to correct and enter in Netsuite .

Perform bank reconciliations of more than 30 plus subsidiaries and bank accounts

Perform general ledger validations between Quickbooks and Netsuite

Review intercompany accounts and highlighted accounts to be reconciled.

General Foundries Inc. March 22, 2023 – July 14, 2023 & 1099 July 15 – Jan 22, 2024

NetSuite/System Admin/General Accountant /Consultant (Manufacturing /Fabrication Business)

Reviewed and updated current and initial implementation of NetSuite and its workflows

Reviewed and improved all customized daily reports of operations; A/P, A/R, Inventory, Purchases

Reviewed, correct and edit all users’ roles for workflow efficiency

Reviewed chart of accounts and its mapping

In charge of adding new users, employees, assigning roles, monitoring licenses and access.

Troubleshoot NetSuite login errors of internal users

Develop, test and deploy customizations on various reports needed by the users of NetSuite modules based on evolving business needs

Coordinate with all departments regarding their needs for daily reports, inquiries and searches

Constantly coordinate all problems and needs to NetSuite support, submit cases

Maintain up-to-date knowledge of NetSuite functionality, customization and integrations

Provide internal NetSuite Cases support (new saved searches, reports, KPI’s, and dashboards,

user roles, etc.)

Assist with data analysis, business process mapping, reporting needs, and improvement/simplification initiatives/import/export of CSV data files

Reviewed and cleaned up Accounts Payable, AR, PO register, Sales Orders, etc. to submit financial statements year end audit 2022 needed for bank for loan requirements

Perform monthly closing procedures, bank reconciliation

Review of PO Register & other purchasing transactions, re pending PO, PO matching

Review of Sales orders, invoicing, delivery and inventory management

Aquarian Management Holdings & its subsidiaries February 2022 – January 2023

NetSuite Accountant (Consultant)

Handled AP/Employee Expense Reports; Recorded expenses, application of payments

Recorded of customer payments

Managed bills/expenses of all Asset Management Companies.

Recorded credit card expenses; Bank Reconciliation/Credit Card expenses

Served as System Administrator of NetSuite

Processed monthly closing, accrual of expenses, bank activities, intercompany recording and reconciliation

NetSuite ERP Accountant/Consultant – Remote Projects Feb 2019- January 2022

Pret A Manger – Payroll Review /Analysis/Clean up NetSuite OneWorld (Consultant)

Review of payroll recordings from January to December 2021

Analysis of various payroll charges, weekly and monthly

Reconciliation of payroll and bank charges

Analysis of Journal entries made and provide recommendations

Import and exports of personnel csv files, payroll hours and all records to/from NetSuite

Archangel Tablets Inc - A/P, GL NetSuite One World (Consultant)

GL implementation/reconstruction from January to September 2021

Recording of transactions, invoicing, AP, GL, Record to Report (R2R), Lead to Order (L2O) Order to Cash (O2C), Procure -to-Pay (P2P)

Bank reconciliation

Scentbird Inc.

NetSuite ERP Accountant/Consultant – Remote Project

A/P Clean-up project (NetSuite)

Reviewed all incoming request for vendor payments; Handled all billing of all PO related transactions

Handled all Accounts payable transactions; Review receiving, vendor prepayments

Entered all bills related to consultants, social media influencers

LRN Corporation Sep 2019-Dec 2019; May 2020-Dec 2020

NetSuite ERP Accountant/Consultant

Reviewed existing business processes related to A/P and its NetSuite Setup, organization structure, review of chart of accounts, business units/department codes, project/product codes and other processes.

Recommended useful and efficient processes and accounting systems and procedures.

Assisted with the month end closing, in charge of bank recon, general ledger review, product/project costings review.

Handled all review of vendors inquiries and invoices, adhering to NetSuite AP setup.

Handled inter-department’s requests and AP inquiries

In-charge of review and approval of all pending invoices/purchases

Handled analysis of all corporate credit cards expenses

Recorded all journal entries related to expenses and cash/bank; Handled AP Accrual and reversal

Handled application of customers/vendors online & wire payments

Resolved NetSuite set up issues. Participates in discussion of functionality, procedures and other setup.

GL operating system used – NetSuite, Ap system -Mineral Tree

Wyng Inc. Feb 2019-June 2019

NetSuite Financial Accountant/Consultant (Project)

Handled Tax Provisioning for 2018, prepares all schedules requested by Tax Team

Handled Year End Annual Audit /Closing 2017 /2018, prepared all schedules

Reconciled intercompany transactions UK and USA and its consolidation

Reviewed Accounts Receivable & Accounts Payable Aging, deferred revenues

Reviewed & reconciled payrolls, entries, and proposed corrections

Handled Bank Reconciliation, Customer/Vendor Account Reconciliation

Trouble shooting of Errors in NetSuite, created cases to correct errors

Reviewed cumulative translation adjustments & elimination entries

GL operating system used – NetSuite, Salesforce

People Care Inc. (Employment Agency for HHA) – New York Mar 2017-Apr 2018

Accounting Supervisor

Reviewed of cash receipts & deposits of main companies & its subsidiaries

Reviewed of checks disbursements and payables

Handled monthly check requests for payment of Union dues (1199)

Reviewed of weekly payroll and its deductions & garnishments

Prepared of remittance of union dues and benefit funds (1199)

Updated Employee & HHA payroll deductions (Aflac/Medical/Vision & Dental)

Monthly Closing:

Bank reconciliation of all payroll and operating bank accounts

Reviewed of Payroll & Taxes and prepared Journal Entries, A/R Sales and Cash

Prepared Journal Entries for monthly estimated taxes accrual (SUI, FUTA, MTA&DBL)

Reviewed Unclaimed wages schedules for all companies

Reviewed Weekly Aid Hours prepared by Accounting Staff before submission to owners.

Reviewed and prepared journal entries of intercompany transactions & reconciliations

Reviewed and prepared Journal Entries for all tax electronic payments

Reviewed and ensured that all non-AR are recorded properly

Reviewed and ensured that all Private Deposits are tied up with bank and other schedules

Reviewed and prepared Write offs of accounts receivables

Reported to Department of Labor the monthly numbers of employees.

GL & Other Operating System Used – Great Plains, Paypro

Acme Cosmetic Components - New Jersey Oct 2016

Consultant

Analyzed accounts receivable /AR customer aging

Reviewed existing internal control procedures of billing; Verified contract terms

Reviewed all credit and debit memos+

Reviewed accounts receivable journal entries and review and audit invoice packets

Matched billings to shipping log; Audit the application of cash receipts and payments

Reviewed and reconciled deposits vs. Bank Statement

Finalized the realizable value of A/R for reporting to Balance Sheet

GL system used – NetSuite One World, AS400

Cameron Industries Inc./Soho Apparel (Fabric Wholesale/Apparel) – New York Oct 2014 – May 2016

Controller (Manufacturing/Wholesale/Import/Export)

Handled the initial setup, migration from Peachtree/AS400 to A2000 system (AP / AR / Sales / Production / Inventory / GL) (Admin Role)

Trained users/trouble shooting/analysis of system errors (Admin Role)

Reviewed monthly Importation, unit costing of materials and other cost of goods sold

Reviewed intercompany transactions, reconciliation and consolidations

Bank & Factor Reconciliation/Sales & Chargeback/Returns analysis

Monthly review of unit costing; per style; per vendor/per division/per company

Handled Sales Commission Reporting

Monitored and controlled inventory and warehouse transactions

Handled intercompany transactions, reconciliation and consolidations

Monthly closing and maintenance of General Ledger

Handled financial & payroll/sales tax reporting, monthly, quarterly, and year end, coordinating with outside auditors.

Installed all possible internal controls over all phases of operation

GL & Operation Systems Used- AS400, A2000, Peachtree

Minx New York/Vintage Home (Fashion/Home Deco/ E-commerce) Feb 2013 – Apr 2014

Controller

Handled the implementation & migration from QuickBooks to NetSuite.

Cash management & Weekly Cash Flow Reporting; Accounts payable and vendor management

Factored & non-factored sales, credit card sales monitoring & reporting.

Costing and monitoring of finished goods, and other shipping costs (duty, freight, etc.)

In-charge of recording & monitoring of commission of salesman

Handled intercompany transactions, reconciliation and consolidations

Handled accounting & monitoring of all e-commerce sales (USA & CANADA) (amazon, ebay, etc)

Handled monitoring of fulfillment & delivery of goods to customers & coordination with warehouses

Handled recording of importations of goods for sale

Handled payroll of all staff, monitoring A/R, chargebacks, factored A/R, EDI Transactions

Handled financial reporting, monthly, quarterly, and year end, coordinating with factors/outside

auditors

GL & Operation Systems Used: QuickBooks migrated to NetSuite One World. Record to Report (R2R), Lead to Order (L2O) Order to Cash (O2C), Procure -to-Pay (P2P

Lajell Smart Accounting & Business Solutions – New Jersey Oct 2008 – present

Bookkeeping/Tax Preparation (Self Employed)

Handled various small business companies on a project basis

Handled various software migration; NetSuite implementation

Tax preparation for individuals and small businesses

Bookkeeping service /Business Registration

QuickBooks set up & monthly reporting/(Fedex Authorized Shipper)

Collaborated with other local CPAs for other projects

GL & Operation Systems Used: QuickBooks and client GL System

Components By John Mcoy Inc/Leonor Romano LLC. – New York Aug 2006 – Oct 2008

Accountant

Reconstruction of books for Financial Reporting & Tax & Audit compliance using Peachtree

Bank/Cash & Factor recording, reconciliation & reporting/Handled intercompany transactions

Managed accounts payable and vendor management

Recording of intercompany transactions, reconciliations and consolidations

Monthly closing and maintenance of General Ledger

Handled financial reporting, monthly, quarterly, and year end, coordinating with factors/outside auditors

GL & Operation Systems Used: Peachtree and AS400

Lajell International Corporation – New Jersey Dec 2005 – Aug 2006

Manager (Employment Agency/Home & Health Care Services )

Tax preparation for individuals and small businesses.

Bookkeeping service for small businesses/Business Registration & other services.

GL & Operation Systems Used: QuickBooks and client GL System

Education & Training

Fairleigh Dickinson University – EMBA – Healthcare Management Spring 2015 (incomplete)

Asian Institute of Management - Philippines - Executive Development Program – October – November 1998

San Sebastian College of Law – Philippines – Law 1988 – 1989 (incomplete I got married)

Polytechnic University of the Philippines – Bachelor’s in Commerce Major in Accounting - 1978-1982

Skills & Certifications

Certified Public Accountant (Philippines)

Member – The Institute of Internal Auditors – NJ Chapter

Member – American Institute of Professional Bookkeepers

Contact this candidate