Job Description

FULL TIME / LONG TERM JOB

Work with international customers / suppliers in a vibrant and learning environment. This position requires long term commitment to the job.

Key Responsibilities:

Working in Excel / Google Sheets with VLOOKUP, PIVOT TABLES, FORMATTING, REMOVING & HIGHLIGHTING DUPLICATES, CONVERT PDF TO EXCEL and other LOGICAL FUNCTIONS to perform following tasks:

1) Order Processing

Maintaining & track open / closed customer purchase orders in google sheets Processing open orders by emailing purchase orders to suppliers correctly Following up over email with suppliers for proforma Verify & Process supplier proforma against purchase order and approving for payment Ensure timely payments to suppliers and updating entries in google sheet Verify & Process invoice from supplier and enter correctly in google sheet
2) Shipment processing

Follow-up over email and phone with US/UK/INDIA suppliers for tracking number and shipment deliveries Maintaining in google sheet / excel records of received shipments (Goods Received) in UK/ INDIA / US warehouse. Including shorts / damages and credit notes Prepare customer invoice or shipping plans Prepare export invoice & packaging list for UK / INDIA warehouse Coordinate with US/UK/ India warehouse regarding deliveries of shipments Coordinating over emails and phone with freight forwarders for moving shipments Giving detailed shipping instructions to US warehouse and coordinating with them on email and WhatsApp Emailing customers and suppliers invoices, BOL's, payment information, reminders on shipments, etc. Manage communication with vendors regarding billing and payment inquiries
3) Reconciliation

Bank reconciliation in Google Sheets Supplier Ledger Reconciliation in Google Sheets Maintain accurate financial records

Key Qualifications & Skills:

Experienced candidates only

Minimum 2-3 years of work experience in advanced Excel is essential for this role.

EXPERT of MS Excel is MUST FOR THIS JOB

Must have expertise in Excel with VLOOKUP, PIVOT TABLES, FORMATTING, REMOVING / HIGHLIGHTING DUPLICATES, CONVERT PDF TO EXCEL and other LOGICAL FUNCTIONS.

Must be fluent in spoken & written English

Great attention to detail and accuracy. Quality minded; motivated to seek out errors and inquire when something appears inaccurate Well settled in Vadodara/ Married / B. Com / M. Com with vision to work as admin executive in a company for long term. If you have advanced excel skills & knowledge of QuickBooks then you will be given preference over other candidates. Ability to coordinate with US/UK suppliers and warehouse staff over email and calls. Working knowledge and experience of handling files on Google Drive.
Work Environment:

Office-based role, requiring regular attendance. Collaborative team environment with opportunities for professional growth. This role offers a competitive salary and an opportunity to work with a dynamic team in a growing organization. We provide holidays on national holidays and festivals as per company rules. No paid leaves, casual leaves or PF is provided by our company. Incentives based on excellent performance. You must be willing to work for long term with the company to get incentives and other benefits / salary increases. This is not a BPO / KPO job, please apply only if you want to work in the publishing industry, education industry for very long term.
Job Timings: Mon-Sat, 10am-7pm. (we do not operate night shift and working hours are normal day shift only) High salary, Overtime payment and incentives.

Please view the link below for more details about our company & job openings
https://edubooks.com/careers/

Job Type: Full-time

Pay: ₹30,000.00 - ₹40,000.00 per month

Education:

Bachelor's (Required)
Experience:

Back Office Executive: 3 years (Required)
Language:

English (Required)
Location:

Gorwa, Vadodara, Gujarat (Required)
Work Location: In person