Excelling
This Excel function allows you to search for a value in one column and return a corresponding value from another column.
What is x/v/h/lookup?
This is Stephen's latest calculation tool.
What is the Tariff calculator?
Karlie Lester and Chelsea Lyman both have husbands who do this for a living.
What is ranching?
This person adjusts the financials as needed to file taxes properly.
Shopify, Big Commerce, Woo Commerce, Amazon
What are Sales Channels?
In Excel, this symbol is used before a cell reference to make it absolute, preventing it from changing when copied.
What is the dollar sign ($)?
This rule allows imports under $800 to enter the United States duty-free.
What is the de minimis rule?
This "newer" Manager has parakeets and lives in Kansas.
Who is Elizabeth?
This state imposes a Franchise tax on all businesses.
What is Texas?
Afterpay, Sezzle, PayPal, Shop Installments are all.
What is a Payment Processor?
This function allows you to count how many numbers in a range meet a certain condition, such as all expenses over $500.
What is COUNTIF?
Effective March 10th, Amazon will reimburse you based on the product manufacturing costs of the affected inventory instead of this price.
What is the selling price?
When this person has a free night, they enjoy trying out new restaurants with a nice outdoor patio, often with their pups in tow. If they’re flying solo, you might find them rock climbing or skateboarding with friends. (Although with a new baby they might not have much time for that anymore.)
Who is Dillon?
Shopify and this partner are "divorcing."
What is Ava Tax or Avalara?
They type of sales taxes collected by "Shop" channel, Facebook, TikTok
What is Marketplace Facilitator Tax?
What if the first place you check if you have a reconciliation that isn't working?
What is review that the sales reports are pasted properly?
This sales channel engages in "Social Commerce" more than others.
What is TikTok?
What is hiking?
This agreement allows states to simplify the collection and administration of sales tax for interstate commerce.
What is the Streamlined Sales and Use Tax Agreement (SSUTA)?
Gifts cards issued by Loop, Redo, rise.ai etc are examples of.
What is Gift Cards issued by a 3rd party app?
This feature lets you consolidate data from multiple sheets into one, often used for financial reporting across different departments.
What is Power Query?
This reporting requirement is now back in play after a federal judge lifted a "pause."
What is beneficial ownership information reporting?
Natalie Selbe has this in common with two Managers from Pod 2.
What is lives in Idaho? (Teri and Cole)
This M-3 adjustment refers to the difference between the income recognized for financial reporting purposes versus tax purposes due to different rules for timing of recognition.
What is a temporary difference? (depreciation, bad debt, inventory valuation, interest expense, NOLs.)
This happens when the transactions on a transaction tab don't add up to the amounts keyed into the finance summary section.
What is a statement variance?