Category Archives for "Ecommerce"

Oct 31

How To Record Amazon Product Sales In QuickBooks Online

By zgraft

How To Record Amazon Product Sales In QuickBooks Online

This write up is perhaps the most simple, straightforward way of recording Amazon product sales in QuickBooks Online.  There are apps and other methods out there that may be better for you, especially if you deal in larger volumes of transactions.

The issue is that you have to create a separate step between the sales taking place on Amazon and the money being disbursed into your account because Amazon withdraws their fees prior to disbursing, so there is no way to accurately reflect the sales amount, and then really the secondary transaction of the processing expense by just entering the sales receipts into your main bank account.  This write up also assumes that you’re using QuickBooks Online to track inventory.

1. Create An Amazon Clearing Account

This is the first step!  You will want to create a separate bank account on your chart of accounts that is dedicated to Amazon sales and use it as a clearing account.  You’ll see the reasons for this in a second.

2. Great! You’ve Received A Sale On Amazon!

The seller notification email you receive from Amazon has all of the information in it that you need to accurately record this multi step transaction.

So you can see that the actual product sale was $66.29, with $5.49 paid for shipping.  And Amazon’s fees are a total of $11.76.  They will disburse to me $60.02 for this transaction.

3. Enter The Sales Receipt Into QuickBooks Online

Choosing to deposit this transaction into the Amazon clearing account, it allows me to accurately record the net margin that I made on this particular item so my books stay in order.  I’ve also added the shipping as a separate line item.  So the total deposit for this transaction is $71.78

4. Now Enter The Amazon Fees As An Expense

Now you will want to enter the Amazon fees as an expense that is being debited from the Amazon clearing account.  So in this case, I entered an expense for $11.76.

5. Now Review The Amazon Clearing Account on the COA

So upon reviewing the Amazon clearing account on my COA, I can see the balance in the clearing account is the amount of funds that Amazon states I will receive from this transaction.  At this time, I will leave it here for now(My income’s been recorded, the expense fees have been recorded-the P and L is fine).  Once Amazon disburses the funds into my bank account, I can then create a banking transfer between the Amazon clearing account and the account the money actually gets money deposited into, or I can create a journal entry.

Since Amazon and most e-commerce platforms disburse funds on a schedule and in batches rather than in individual transactions, by holding off until the money is disbursed into my account, I can add transactions to that future deposit seamlessly by using this method.

Hope that helps!

Nov 12

Some Of Our Website Builds

By zgraft

Hey Everybody!

 

We do some web design and website management using a wide variety of resources and platforms.  Some platforms that we use on a regular basis include Wix, WordPress, Shopify, GoDaddy, and Squarespace.

Some of our website builds include:

  • fishicestrong.com
  • ruggedandtactical.com
  • graftoutdoorsllc.com
  • antoniaruth.com
  • syvertsenaccounting.com

Part of what we do is to incorporate branding as well as onpage SEO into each and every one of our builds.  We’re Inbound Marketing certified so we try to take a wholistic approach to web design.

Have a great day!

 

Oct 09

E-Commerce Management Services

By zgraft

Hey Everybody!

With the growth of e-commerce portfolios we’re excited to announce that we are now offering comprehensive e-commerce management solutions!  Why us? We’ve worked with quite a few platforms and are more than capable to oversee and grow your e-commerce portfolios!

No matter if you have one shop or twenty, we’re able to help.  Some of our ecommerce website platforms that we’ve worked with in the past:

Wix

Shopify (we’re partners!)

3dCart

WordPress (Woocommerce, Marketo)

Squarespace

A sampling of our work includes ruggedandtactical.com as well as mioutdoorshop.com

What are we able to offer?

In addition to sales and administrative services, we can craft an entire digital (and non-digital) marketing strategy to implement and then implement it!  Using a mix of social media marketing, paid ads, analytical tools, and e-mail campaigns we’re able to really drive sales.

Platforms that we use include:

  • Amazon FBA
  • Google Adwords
  • Google Analytics
  • Google Merchant Center
  • Google Webmaster Tools
  • Google Tag Manager
  • eBay
  • Shopify
  • PayPal
  • WordPress
  • Bing Advertising
  • Pinterest
  • Facebook
  • Facebook Ads
  • Instagram
  • Instagram Ads
  • Tumblr
  • Inventory Source

And more.

It doesn’t matter if you have a drop shipping program in place now, or are currently looking at adding to your ecommerce portfolio and need a complete website buildout and integration, we can help with it.  

If you’re just looking for a small website to sell your handmade goods or to sell products from your store front as well, we’re able to help you with that also.  Whether you go to one integrated ecommerce and storefront pos system such as with Shopify or PayPal, or even SquareUp, we can definitely get you going.

Another area that you’re probably concerned with is cost.  And while this kind of service can be expensive, we’re flexible.  You may not want or need a complete solution, in fact, it may not be the best for your business and we’ll tell you that.  

The best way to get started?  Fill out the form below and we’ll get back to you shortly.

[contact-form-7 id=”69″ title=”Contact form 1″]