Raj Sembhi Email & Phone Number

Surrey, Bc

*Supervising AP team - monitoring, mentoring & training AP team*Cleaned up AP aging report: Reconciled vendor statements, collected refunds for credits (above USD 20K). Recorded & deducted credit notes missed on AP sub ledger (worth $9,000.00).*Maintaining vendor relations by reaching out and followup. Monitoring the centralized AP inbox to ensure immediate reply to vendor inquiries. Follow up for stale dated cheques & issue replacements if required.*Reconciled AP Sub-ledger and GL balances from as back as Jan 2018 and resolved numerous differences, created system tickets (Eclipse) with our IT team where required. *Monthly Reconciling GRN issues -resolve differences due to quantity match, price match & system errors.*Ensuring AP tasks completion prior to deadline for month end.*Closely monitoring payment runs (EFT, Cheques & Wire transfers) ensure proper coding & approval for invoices (including WCB clearance letters & Statutory declarations from subcontractors). *Maintaining Petty Cash, Credit card balances & Gas card statements: Ensuring proper approvals as well as receipts for all corporate credit card transactions & maintaining funds for use on credit cards by replenishing when required (Spend Dynamics).*Processing Major steel vendor payables, wire transfers (BMO online) and over 9 Non-Operating entity payables including Multi currency payments. (Quickbooks, Excel & Eclipse)*Maintaining & set up of new vendors including EFT updates*Ensuring that Property taxes NAFTA certificates and Business licenses are up to date.*Assisting with Cash flow projection - updating Controller for major vendor upcoming payments.*Created AP Manual.*Work closely with project accountants and auditors*Process improvement for subcontractor payments (previous process - multiple duplicate payments and missed deductions)

Vancouver

My success story (achievements) at Metrie! (Updated June 2017)*Collected over 400K debts owed to Metrie from previous years on vendor aging*GRIR /GRN clean up - maintaining to ensure no items older than 10 days*SAP Training manual was completed and I trained the AP team*Major vendor accounts are current - past due invoices have been resolved*All discounts for major vendors that I own have been taken without any miss*Created a new proposal for Metrie on how ensure that no discounts are ever missed again for the other AP clerks that I am training, mentoring and assisting on a daily basis. Duties As SAP Trainer:*Tested various AP processes (scripts) and reporting / documenting defects*Prepared the AP training manual and demos as well as created exercises for the AP clerks*Provide ongoing support to the AP team on SAP Accounts Payable processes by daily mentoring, monitoring and training.Duties As Senior Accounts Payable:*Posting monthly Accruals, prepaid reporting and completing Month end procedures*GRIR /GRN clean up for vendor accounts and maintain vendor aging /follow up for refunds*Weekly wire (multi currency), check & ACH payment runs*Processing complex payables, coding invoices to the appropriate General Ledger codes and posting journal entries to re class where necessary*Daily monitor invoices blocked due to variances & work closely with junior AP, vendors, procurement & L&D to fix price & quantity variances*Vendor statement reconciliation and problem solving*Consignment account reconciliations and payments*In charge of all prepaid vendor accounts to ensure proper match of down payments upon goods receipt*Monitor AP processes identify issues and suggest process iprovement plans*First point of contact for all vendors, employees, directors and customers in resolving errors or payment issues*Monthly upload of invoices for fixed equipment lease and rent invoices for all branches

Vancouver

* High volume Accounts payables (Software - Agama & Netsuite) for branches within Canada and USA. (New Foundland/ Halifax, Orlando, Atlanta, Central USA - 7 branches, Monroe, Virginia, Detroit, Kansas City)* Posting 250+ invoices per day (ensuring that invoices are approved and matching POs), * 20+ payment runs per week, monitoring discount opportunities and scheduling payments accordingly & creating wire payment instructions for non ACH/ EFT vendors in Brazil, Mexico and other countries - 25 to 30 per week. Ensuring that confirmations of wire payments are emailed to vendors on a daily basis.* Updating vendor bank information for EFT/ ACH transfers and encouraging vendors to enroll for direct deposit.* Inter company accounts invoice posting and payments.* Resolving payment issues (8 to 10 per day) and ensuring utilities for all branches are paid on a timely manner.* Charge expenses to accounts and cost centers by analyzing invoice/expense reports. Obtaining missing receipts, approvals and providing employees with payment updates. * Preparing 1099 & 1096 forms for US vendors* Resolving purchase order, contract, invoice, or payment discrepancies and documentation; ensuring credit is received for outstanding memos; issuing stop-payments or purchase order amendments.* Maintain accounting ledgers by verifying and posting account transactions and posting journal entries.* Verify vendor accounts by reconciling monthly statements and related transactions.* Month end and quarter end prepayment and accrual reporting, resolving variances, * AP Import for simple GL coded invoices using CSV files, training other AP clerks when necessary.

Assist the AR staff to receive debit, credit and cash payments from customers and allocated receivables.Handled customer complaints and discrepancies and work closely with the marketers to resolve pricing and other problems. Prepared student fee refunds per VEC policy.Assisted to prepare Bank deposits, Daily Credit card, Debit card and other AR reconciliation.Maintained AR electronic files on a Fiscal Year basis.Year end procedures and opening of new files.Data transfer from SAS to Accpac - csv files.Signed and assisted to prepare T2202A forms (Year End tax receipts for students).Petty cash disbursements, prepare petty cash reports and replenish funds.Financial Year Reports Preparation and year end closing.GST reports and payments.Train other accounting staff members and assist the business development manager with financial reports.Monitoring monthly sales report for the different language groups.Schedule weekend shifts for accounting staff.Prepared AP and AR manual for the organization.Carried out Performance Reviews for accounting staff and registrar. Created goals and looked at ways to improve productivity in the department.

Vancouver, Canada Area

After effectively covering for the Registrar position for two weeks, was promoted to the position of Accounts Payable Position:Main accomplishments:Improved the accounts payable system and reduced time taken for cheque runs by changing the incorrect previous default GL codes setup upon creating new Vendors. Changed the default printer. (Saved approximately half an hour a day that was being wasted by repeatedly changing the printer and wrong GL codes for vendor invoices)Implemented a better system to effectively handle payment inquires by creating specialized email templates for first time, second time and third time payment inquiries (this highly reduced the stress rate and time consumed on answering emails by 80%). As a result, I had more time to take on additional duties and contribute more to the organization's efficiencyImprovised an Electronic Filing system which reduced time taken for filing, reduced stationery (filing) expenses and storage space requiredDuties:Prepared payments and commission cheques on Accpac and SAS programs as per deadlines. Data transfer from SAS to Accpac.Completed the deferred financial report for the year 2011-2012. Prepared EFT payments as per deadlines.Ordered new medical cards and prepare insurance claimsProcessed Journal entries, deferred calculations, GST reports, Refund approvals and group discount calculationsMaintained financial reports on a Fiscal Year basis

New Westminster

After Maternity Leave, unable to return back to work at Logotex due to family reasons

Vancouver

Coded batched and posted all accounts payables and receivables on GoldmineMaintained filing systems for the organizationPrepared bank deposits, and processed debit, cash and credit card transactionsProcessing purchase orders, follow up with vendors Resolving Vendor and Customer discrepanciesVendor statement reconciliations

Nairobi, Kenya

Supervised 5+ Accounts Payable Clerks and provided support and trainingAudited accounting entries and updated payables, receivables, cash, bank and general ledger accounts on the Scala computerized softwarePrepared month and year end tax reports and payments before the deadline Month end reconciliations, bank reconciliations, payable and receivable reconciliation and processed payable chequesProduced financial statements, period cost statements and reports for the auditors on ExcelPrepared cash flow, VAT (Monthy Tax) and budget reportsNegotiated foreign currency rates with bank for overseas payablesPlanning of all bank loans / contracts due dates and repayments with the CEOMaintained good relations and solved customer and vendor disputes

Nairobi, Kenya

Posted and processed Accounts payables and receivables.Weekly check runsDaily banking Prepared payroll including remittance of taxes on a monthly basisBank reconciliations, monthly trial balance, profit and loss and balance sheetCollection of debts from customersPrepared weekly statements for the sales representatives Vendor statement reconciliation and problem solving

Nairobi, Kenya

Verified airway-bills from airlines and billed customers per the chargesDaily banking, cash ledger entries and payable processingMonthly airline reports and remittances prepared – ExcelMonthly payroll payments and payroll tax and benefit payments and remittancePrepared customer statements on a monthly basisBank reconciliationsMaintain Ledger postings on a daily basisTrial balance, Profit and Loss and Balance sheets prepared monthly – Excel.

Diploma Practical Bookkeeping And Accounts

Diploma Accounting In Business And Management

Advanced Certificate In Financial Bookkeeping And Accounts

Certificate, Quickbooks, Advanced Word And Excel

Internal Quality Audit Course & Iso 9001:2000 Documentation And Implementation Course

Diploma, Diploma Business Economics And Commerce

Certificate Basic Ms Excel

Diploma Business Management /Administration, Diploma Communication In Business And Management

Certificate In Computerised Accounts Level 2

Information Techology Diploma Spreadsheet

Information Technology Certificate In Accounting Package

Practical Spreadsheet Processing