NetSuite Specialist

Job DescriptionWe are seeking a highly skilled NetSuite expert to join our team as a Financial Analyst. The successful candidate will be responsible for managing financial data, ensuring accuracy and compliance with US accounting principles.The ideal candidate will have extensive experience with NetSuite, including bank and payment reconciliation, daily/weekly bank data import and matching using Bank Feeds, automated bank reconciliation rules setup, and investigating unmatched bank transactions and creating missing GL entries.Key Responsibilities:Bank & Payment ReconciliationDaily/weekly bank data import & matching using Bank FeedsAutomated bank reconciliation rules setup (mapping payees, transaction types, variances)Investigating unmatched bank transactions & creating missing GL entriesCredit Card Expense ReconciliationImporting corporate card transactions into NetSuite (Amex, Chase, Capital One, etc.)Mapping transactions to expense categories and departments/classesMatching credit card transactions to vendor billsMonthly reconciliation of credit card statements to GL balancesE-commerce ReconciliationShopifyMatching up payments with their ordersAdjusting for variances – reviewing order totals against discounts, taxes, shipping, fees, etc.WalmartMatching up payments with their ordersAdjusting for chargebacks, returns, and fee deductionseBayMatching up payments with their ordersAdjusting for fees, commission, etc.Home Depot EDI reconciliationMatch up payments with invoicesAmazon Vendor Central ReconciliationMapping Amazon invoices & orders to NetSuite sales orders.Reconciliation of Amazon remittances (Vendor Central remittance statements).Adjustments for chargebacks, fees, shortages, and allowances.General Ledger & Financial CloseMonthly and annual accounting period close in NetSuite.Reviewing & posting adjusting journal entries.Reconciling balance sheet accounts:Accounts ReceivableAccounts PayableInventory & COGSDeferred revenueFixed assets & depreciationInventory & COGS ReconciliationMatching inventory receipts, vendor bills, and landed cost calculations.Resolving variances between purchase orders, item receipts, and bills.Ensuring the correct costing method (FIFO/average/standard).Reporting & Automation SetupBuilding saved searches for reconciliation workflows.Creating dashboards for stakeholders.KPI reporting on AR aging, cash flow, chargebacks, and profitability by channel.