Shiela Joy M. Aquino

Shiela Joy M. Aquino-- linkedin.com/in/shiela-joy-aquino Summary Experienced Freelance Bookkeeper. Experienced Logistics Staff with a demonstrated history of working in the consumer goods industry. Skilled in Online Data Entry, Microsoft Excel, Accounting, and Microsoft Office. Strong operations professional with a Bachelor of Science - BS focused in Business Administration major in Financial Management from Dalubhasaan ng Lungsod ng San Pablo, Laguna. Experience Freelance Bookkeeper Various Companies Jan 2020 - Present (1 year 5 months +) Responsibilities: • Recording of all transactions in Quickbooks Online/Xero • Bank and Credit Card reconciliations • Data Migration • Setup of accounts in Quickbooks Online/Xero • Tune up or Troubleshooting of accounts – fixing ending balances of all accounts • Quickbooks/Xero Consultation • Audit of transactions and balances • Inventory tracking and management • Accounts Receivable/Accounts Payable billing and Collection • Preparation of Cash Flow projections or budgets • Financial reporting and analysis Logistic Clerk Mideast Marketing Mar 2018 - Present (3 years 3 months +) Responsibilities: • Inventory Management • Ensure accurate and timely processing of purchase orders • Ensure accurate and timely encoding of stock received from principal • Audits inventory of main warehouse and truck branch every week • Bad Order Management • Ensure accurate encoding of sales returns from customers • Bi-weekly processing of sales returns to principal • Vendor Management Inventory and Daily Sales Offtake • Monitors receiving and deployment of promo stocks and other materials • Receives, processes, and releases allocation of POPs and other merchandising materials to DSPs • Reports shipment details discrepancy/ concerns to MNC Logistics Department, as deemed necessary. • Filing, sorting and arranging of documents Shiela Joy M. Aquino - page 1 • Performs other related duties as required Accounting Clerk - Sales Mideast Marketing Jan 2015 - Feb 2018 (3 years 2 months) Responsibilities: • Receives collection report with complete attachments from cashier, upon validation and confirmation of received cash or check collections • Validates data and information on the received report and attachments • Processes payment posting of reported invoices to the ERIC system • Files forms and reports for reference and archiving • Receives copy of delivered invoices from delivery team’s lead man for validation • Sorts copy of invoices based on scheduled return/ visit of DSP to the accounts and sales invoice jacketing • Summarizes list of accounts scheduled for collection, and accounts with overdue payments • Releases copy of collection report to DSP, with invoice attachments to facilitate collection of scheduled payments • Returns the collection report to validate collected invoices and attachments, and separates uncollected invoices and re-file for the next collection cycle • Submits summary of overdue accounts for collection to the Accounting Head, Operations Manager, and Distributor Owner on a regular basis • Performs other tasks as per instruction of immediate superior, as deemed necessary Accounting Clerk - Admin Mideast Marketing Jul 2013 - Jan 2015 (1 year 7 months) Responsibilities: • Ensures accuracy of posting salesman's remittance in ERIC • AR Aging report generation weekly • Overdue accounts and other AR issues are discussed with DSPs concerned at least twice a month • Monitoring of documentary requirements of billable promo programs • Monitoring of MNC CMs for returned goods and followed up if not received within the month following the return. • Prepares billing attachments. • Monitors check payment from MNC. • Ensures accuracy of encoding of MNC delivery by checking matching MNC invoice amount vs ERIC prior to payment processing. • Payment for MNC deliveries are computed and CV prepared within an hour after encoding of deliveries in MNDS to ensure prompt payment and availment of discount. • Collates and prepares OBCS attachments every end of the month and submitted before deadline. • Checks the approved vs the OBCS attachments submitted • Encodes CM for SD weekly advances Van Sales Encoder Mideast Marketing Apr 2013 - Jun 2013 (3 months) Responsibilities: Shiela Joy M. Aquino - page 2 • Checks the completeness and accuracy of information written in the sales invoices submitted by Sales Personnel (DSP) • Encodes all sales invoices to ERIC system • Reports issues and concerns to Logistics Clerk, in coordination with A/R Clerk to aid resolution to ensure smooth flow of systems operations • Responsible for the maintenance of assigned office tools and equipment and organized filing of documents. Education Dalubhasaan ng Lungsod ng San Pablo, Laguna Bachelor of Science - BS, Business Administration and Management, General 2009 - 2013 Licenses & Certifications Certified QuickBooks Proadvisor - Intuit Accountants Xero Certified Adviser - Xero SAP ERP Essential Training - LinkedIn Accounting Foundations: Bookkeeping - LinkedIn QuickBooks: Advanced Bookkeeping Techniques - LinkedIn QuickBooks Online Essential Training - LinkedIn Finance Essentials for Small Business - LinkedIn Running a Profitable Business: Understanding Cash Flow - LinkedIn QuickBooks Online Essential Training (2019) - LinkedIn QuickBooks Desktop: Tips and Tricks - LinkedIn Become a Bookkeeper - LinkedIn Excel for Accountants - LinkedIn Shiela Joy M. Aquino - page 3 QuickBooks Payroll Essential Training - LinkedIn Social Media Marketing Tips - LinkedIn Skills QuickBooks • Xero • Bookkeeping • Accounting • Inventory Management • Logistics Management • Data Entry • Online Research • Microsoft Office • Microsoft Excel Shiela Joy M. Aquino - page 4