Apply on
Entry – Invoicing:
· DTC Order Data Pull the order data from the various portals (i.e. Shopify)
· Reformat the data via excel into a template that can be imported into QB via Transaction Pro
· Make appropriate G/L entry to offset DTC sales data
· B2B Order Data Pull the order data from the various sources (i.e. Shopify, WMS, etc.)
· Reformat the data via excel into a template that can be imported into QB via Transaction Pro
· Send Out Invoices to Clients via QB from the appropriate client email
· Amazon Seller Data Pull & Record all sales, returns, fees, etc. from the Amazon Seller Central portal & upload into QB, based on disbursements
DTC - Payment Reconciliations
· Pull Payout Data from various portals (ie. Shopify, Stripe, PayPal, etc.)
· Enter all deposits into QB, accounting for any refunds and fees.
· Issue credit memos as needed
· Will also need to pull order data from Shopify to determine which orders are unfulfilled for refund purposes.
In addition to the above, the candidate may eventually have some general accounts receivable responsibilities, including Collections, Cash application, Chargeback reconciliation, Invoicing, Credit memos, and Assisting with reporting
Requirements· Ability to read, interpret, and verify data from multiple formats.
· Problem-solving skills, process improvement, and analysis skills.
· Must have meticulous approach to information verification.
· Excellent communication skills
· Requires Advanced Microsoft Excel knowledge (specifically VLOOKUP & pivot tables).
· Familiarity with Quickbooks Enterprises Desktop or minimally Quickbooks Online
· Familiarity with big chain retailers (Nordstrom, Neiman Marcus, Target, etc.)
· Experience/Familiarity with Preferred but not Required: Transaction Pro for Quickbooks
o Shopify
· Amazon Seller Central
o Payment platforms (i.e. Shopify Pay, Authorize.net, PayPal, Stripe, Amazon Pay, Google Pay, etc.)
o Other ERP Systems such as Oracle NetSuite, SAP By Design.