How does Accounting Software get data from Online Marketplaces like Amazon, eBay and Walmart?

This article will explain how accounting software providers receive eCommerce data, how safe it is for sellers to use, and how to think about choosing which provider to go with if you want to automate your eCommerce accounting.

Accounting Software providers such as QuickBooks, Xero and Seller Ledger use something called an API to import eCommerce sales data from online marketplaces such as Amazon, eBay, Walmart and Etsy. API stands for “Application Programming Interface.” They have been in existence for decades, and they are safely used all over the internet.

How Do API’s work?

Think of an API as a private way for software programs to talk directly to each other and exchange information. In addition to providing a standardized way to exchange data, most uses of APIs also include permissions to manage customer data privacy and security.

In the case of accounting software getting information from online marketplaces, the first step is for the accounting software to get approved as a reliable partner. The large marketplaces, with tons of customer data, don’t want just any software accessing their data. Once approved, each accounting software is issued what’s effectively a digital ID, which they can use to identify themselves each time they request information.

The next major step is making sure that the accounting software actually has permission to get data on behalf of an actual customer. In order to get this permission, the accounting software sends the customer to a special page to let the marketplace know what data they are permitted to share. This happens on the marketplace’s website, so no passwords are exchanged. Once the user gives permission, the marketplace sends the accounting software a token that can be used in future requests for data. Think of that token as a permission slip that the accounting software presents each time it asks for data.

Do all software providers connect with marketplace API’s in the same way?

We’re glad you asked!  No, they do not.  This is one of the big differences in the various accounting software solutions for eCommerce sellers.  Some accounting software companies connect directly to the marketplaces, others require the use of 3rd party eCommerce connectors like A2X Accounting, Link My Books and Synder. And some choose to offer both.

Below is a diagram showing the various options used by leading eCommerce accounting platforms.

Let’s talk about some of the advantages and disadvantages of each option:

Direct connection

A direct connection means that not only has an accounting platform built their own access to marketplace data, but they have also taken the time to classify that information into the proper accounts, categories and tax lines that a business needs. Seller Ledger uses this approach.

Pros

Simplicity: Fewer moving parts means less work getting set up. And the connections and data are built into the core parts of the accounting software.

Lower costs: You don’t have to pay for extra software subscriptions.

Accountability: When marketplaces change their data, or introduce new fees, there’s only one party responsible for updating the software.

Cons

Less flexible: If your accounting needs are more unique, having the ability to choose between different methods of data connection (e.g. detailed vs summary) could be valuable.

3rd Party eCommerce connectors

Using 3rd party eCommerce connectors basically means an accounting platform is outsourcing the eCommerce data collection and classification to someone else. These 3rd parties specialize in eCommerce connectivity, so it’s a legitimate way to delegate responsibility. Xero has taken this approach.

Pros

Expertise of 3rd party connectors: The leading providers have been working with eCommerce Marketplaces for year, and are very familiar with the data.

Keeps books “clean and lean”: By delegating the task of collecting and summarizing eCommerce data, you can reduce the likelihood that your traditional accounting software gets bogged down by data it was never designed to handle.

Cons

Complexity: By using what some call “middleware”, you will have more setup to get things working as desired. And because the eCommerce connections are not baked into the core product, the user experience may feel disjointed.

Cost: Needing to use a separate software system will invariably cost more.

Choice of Direct OR 3rd part connectors

Then there’s the option for maximum flexibility. Some accounting platforms build their own direct connections to leading eCommerce marketplaces, but also allow you to choose a 3rd party connection instead. Quickbooks offers this choice.

Pros

Flexibility: You can choose which option works best for your business, even doing it on a marketplace by marketplace basis if so desired.

Experience: In the case of using 3rd party connectors, these tools have been used together for many years by many sellers.

Cons

Quality and coverage: Based on online commentary, there may be issues with how well the direct connection tools are managed. And Quickbooks, as of the time of this post, only provides a limited set of direct integrations (e.g. they don’t connect directly to Walmart.) As such, you could end up with a “kitchen sink” approach.

Complexity: Again, because the eCommerce connections are not a core part of the accounting software.

Cost: If you use a 3rd party connector in addition to a multi-channel tier of Quickbooks, prices could get up there.

Conclusion

As with any decision, your choice of accounting software to use for your eCommerce business comes down to the needs of your business and your personal preference. But, regardless of which option you choose, feel confident that there lots of ways to automate your eCommerce accounting using accounting software.

Etsy 1099-K doesn’t match!

“While reviewing our tax and sales information in the Etsy dashboard, I noticed a significant discrepancy between Etsy’s reported numbers and Seller Ledger’s figures regarding total sales and income.”

Thus began a recent email exchange with a customer. And because we take accuracy rather seriously here at Seller Ledger, we dug right in immediately. Fortunately, the customer attached a screenshot of what Etsy was showing (numbers hidden for privacy.)

For those want to follow along, you can find this same information by going to:

Etsy > Finances > Legal & Tax Info > Select Tax Year

How does this compare to Seller Ledger’s data?

In order to compare directly, I pulled up this customer’s account, went to the Profit and Loss report, set the year to 2024, selected view by month, and set the channel filter to “Etsy”. This allowed me to see just the Etsy income and expense by month for the year.

And do you know what? The customer was correct. Etsy was showing different totals that Seller Ledger was. The question became, why? Was Seller Ledger wrong?

It was time to find out.

I copied the top “Income” section of the Seller Ledger profit and loss report into a spreadsheet. I then added a new row for the numbers provided in that Etsy tax screen. Lastly, I calculated the difference between the Etsy number for each month and the Total Income amount.

That’s when I noticed an interesting pattern. The numbers matched precisely in 7 of the 12 months of the year. And in the months where they didn’t match, the difference was EXACTLY the same as the “Refund” amounts shown in Seller Ledger for that month.

So Seller Ledger got the numbers exactly right. But how could the numbers be different?

In short, what is happening is that Etsy’s totals are not being reduced by order refunds. And this is a common occurrence with 1099-Ks across payment platforms, as we’ve previously written about. In fact, you can browse Etsy’s help article on the subject, and find some interesting language:

“Gross sales” may include but are not limited to:

  • All of your sales
  • Shipping
  • Refunds
  • Card processing fees
  • Sales tax applied using the sales tax tool
  • Canceled orders

May include? That doesn’t sound very definitive. But perhaps the most confusing is language around “refunds being included”.

The customer shared that someone from Etsy customer support had stated that refunds were included in the totals. But does that mean they have been reduced by the amount of the refunds? Or are they saying that the original sales (that eventually get refunded) are included in the total, but not the actual refund? In this instance, it was the latter.

After a bit more research, we found that Etsy actually does spell this out in more detail – you just have to find the right support article:

Your gross sales is the total amount your buyers have paid you, for the entire year, without subtracting expenses, such as:

  • Fees
  • Refunds
  • Shipping costs

In general, we have found that platforms, when reporting Gross Sales, include all of the original sales, whether they get refunded or not, and do not subtract out the refunds when they happen.

Lessons learned

For me, there a few interesting learnings here:

  1. No matter how much the IRS and eCommerce platforms try to explain what goes into 1099-K numbers, any time you see different numbers in different places, it causes concern.
  2. Regardless of what you may read or be told about how numbers are calculated, there is simply no substitute for verifying them yourself. Math is your friend if you know how to use it.
  3. The best thing you can do to be prepared for any questions around numbers is to have a detailed accounting or bookkeeping solution that allows you to drill down on any totals to the underlying transactions and their components. This is exactly what Seller Ledger does, and why it took mere moments to figure out what was going on in this case.

I also want to give a shout out to the customer who worked with us on this case (you know who you are:), for being patient and sharing where they got the original source data so that we could share this experience and learning with others.

eBay fees too high? It depends.

One of the most common complaints we see among small eCommerce sellers is that eBay fees are too high. As are fees at Amazon, Etsy, Poshmark and other eCommerce marketplaces. This becomes especially common whenever new fee increases are announced.

While price increases often produce an emotional response (we are only human, after all – at least until AI starts writing these blog posts,) we thought it might be helpful to provide some context on marketplace fees and how you can evaluate them rationally (and analytically.)

What do marketplace fees get you?

To start, it might help to remember some of what you get from your online marketplace seller fees. For the sake of this article, we’ll use the example of selling on eBay versus selling on your own website.

1. A full-stack eCommerce platform on which to sell

What do I mean by “full stack”? Well, I mean everything that you would need to sign up for, configure and pay for yourself to start selling online through your own web storefront. For example, if you want to set up your own eCommerce storefront, you’d need to arrange (and pay for) the following:

  • A domain name. It’s the equivalent of a street address on the internet.
  • A hosting account which can handle the internet requests to visit and purchase from your online storefront. Oh, and you will likely want it to be secure, so you’ll want an SSL (secure socket layer) certificate.
  • Software to run your storefront. Your options here run anywhere from coding it yourself to using existing platforms like Woo Commerce or Shopify, which run from free to sizable monthly subscriptions.
  • A payment service, like Stripe or PayPal, to let you accept payments from your customers.

Online marketplaces provide all of the above for you. In additional to thinking about the cost savings with each item above, it might also help to think about the time savings of all the things you don’t have to spend figuring out, setting up, and, especially, fixing when they break. There is a very high probability that the large marketplaces have more reliable systems than what you might cobble together.

2. Marketing

This is the big one, and it’s not even close. The #1 thing you get from listing items for sale on a marketplace is traffic. Finding customers is one of the hardest things to do in business, let alone in an eCommerce business. Online marketplaces have done the heavy lifting to build large brands with huge numbers of customers who visit them every day. You benefit from that, though you do need to compete for attention among all other sellers on a marketplace.

To better understand why we focus on “marketing” so much, just imagine what you would try to do if you launched your own website. Let’s say you have a brand new eCommerce website, it’s live, it’s beautiful, it works perfectly and has amazing, unique, incredibly valuable items for sale at extremely reasonable prices.

How do you get people to visit your store?

If you google “how to drive traffic to your ecommerce website”, you will find a TON of content offering all kinds of advice (as well as some “experts” willing to help you, for a fee.) And you can compare that to what Shopify and Wix suggest. But let’s discuss a few of the common techniques you’ll likely find.

Word of mouth

Likely the very first thing to try is to reach out to your entire network of friends, family and professional colleagues. Ask them for help, ask them for advice, and of course, ask them to tell everyone they know about your amazing new web storefront.

Search engine optimization

In the brick and mortar world, you can choose a location with good foot traffic, though the rents will likely be higher. On the internet, there really isn’t a lot of foot traffic. The closest equivalent is search traffic, so you’ll want to make sure your website is optimized for key search terms. Of course, you’ll need to do this better than your competitors in order to get a high enough ranking. And some of those competitors are the very same online marketplaces, who’ve spent years developing expertise and credibility so that they can drive traffic to their customers’ listings.

Paid advertising

In the brick and mortar world, we used to be able to advertise in the Yellow Pages, but that’s been replaced by the online world. You can advertise on search engines like Google, as well as social media sites like Facebook and Instagram. You could sponsor podcasts from influencers who talk about products like the ones you sell. There are a lot of options out there that can help you reach your target customer, but it’s critical that you test and measure your ad campaigns on each of them, to be able to know whether you are making enough money to justify the continued investment.

eMail marketing

Even though it’s been around for a long time, email continues to be a very effective tool for communicating with customers. But in order for this to work, you need to get people to give your their email address, which requires a whole other step of finding prospective customers and giving them enough of a reason to give you their email address. This leads us to the next concept.

Content marketing

One of the most common techniques you’ll see to help drive traffic to your website is a more indirect method that is sometimes called “content” marketing. This means creating a bunch of content (or paying someone else to do it,) that is related to what you’re selling, but different enough that it can attract people who are not explicitly seeking out a specific item. Writing blog posts, sending newsletters, creating videos or reels on YouTube, Instagram and Tiktok, these are all examples of content marketing.

Social media

Perhaps the fastest growing technique for acquiring customers is to build up a presence on social media channels like Instagram, TikTok, Facebook, SnapChat, etc. Social media platforms make it much easier for you to build lightweight relationships with “followers” and “connections.” But you still have the challenge of creating interesting enough content to gain those followers. That said, because this is a much newer domain and is rapidly evolving, there may be more opportunity to do something new and unique.

Other ideas

There is no shortage of marketing ideas that you can try for your website. For example, you could create an affiliate program to get influencers to promote your store. Or roll out a customer loyalty program to get your happiest customers to spread the word. When you’re an entrepreneur, everything is worth a try:)

How do I compare the costs of marketplaces vs doing it myself?

While there is no “easy” answer to this, as everyone’s business is different, we have tried to pull together some resources to help you get a better sense of where your costs should fall. So if you are thinking that eBay’s fees are too high, compare that to some of the statistics below.

The CMO Survey from 2021 states that “B2C Product companies spent 18.4% of their revenue on marketing in 2021.”

This blog post from Boldist suggests “The Small Business Association recommends 7-8% of revenue should be spent on marketing, but what we see, in reality, is that ecommerce companies will spend up to 30% of their revenue on Customer Acquisition Costs.”

And if you have time to dig through a LOT of great detail, check out Marketing Sherpa’s 2015 eCommerce Benchmark Study. Notice that most respondents talked about how their customer acquisition costs are expected to go up over time.

Final Thoughts

Every small business owner needs to decide for himself/herself how best to spend their money. But we are big fans of making informed, data driven decisions to help grow your business. Hopefully this article helps provide some context for evaluating the true cost of online marketplace fees and whether your money would be better spent elsewhere.

Want an easy way to see your fees per online sales channel? Remember to check out our recently added Channel Breakdown report.

Not yet a Seller Ledger user? We offer a 30-day free trial, co credit card required.

Make sure to deduct your Etsy Ad fees

We recently received an interesting question from one of our newer Etsy sellers. Where in Seller Ledger does one find Etsy ad fees? While we import 13 different Etsy fees, including one for “Offsite ads”, we do not show any for “Etsy Ads”.

What are Etsy Ads?

Like Offsite Ads, which promote your Etsy listings on platforms like Google, Facebook, Instagram and more, Etsy Ads allow you to also promote your listings, but on Etsy itself. You pay each time a user clicks on an ad and Etsy charges you.

So what’s the problem?

While these onsite Etsy Ads sound quite similar to “Offsite Ads”, the costs and payments of these ad fees are NOT included in any endpoints from Etsy’s API (application programming interface.) As a reminder, the API is what allows third party software platforms like Seller Ledger to access information from your Etsy store. We have confirmed with Etsy’s developer program that these fees are not included, though they did take our request to add them in the future.

Because these Etsy Ad fees/costs are not made available in the API, financial programs like Seller Ledger can’t automate as much of the accounting/bookkeeping as we’d like. But, we do want to remind sellers that these Etsy Ad fees are still valid business costs, and therefore legitimate deductions.

How should I track/deduct Etsy Ad fees?

Fortunately, Etsy does make this information available to you through their website. All you need to do in Seller Ledger is to go under the Expenses tab, click the “Add Expense” button and record the expenses. At minimum, you should do this at the end of the year to record all of your ad fees, but feel free to also make entries as often as you like (e.g. monthly, quarterly, etc.)

Etsy made clear in their response to us that they, like us, prioritize features based on customer feedback, so if this is something you’d like to see added to their API, please let them know at [email protected] .

Connect your Etsy store to Seller Ledger

We are now officially multi-channel!

Seller Ledger now supports a direct integration with Etsy to bring in your product sales, expenses and fee information.

How to link Etsy

From your Dashboard, below your current connected account(s), simply click the “Add Connected Account” button and you will see an updated screen with a new option:

Connect to Etsy
Connect your Etsy store to Seller Ledger

Click on the button with the Etsy logo and follow the steps to give Seller Ledger permission to import your information. If you have more than one Etsy store, just repeat the process for each store.

By default, Seller Ledger will import 90 days worth of transaction history when you connect Etsy. We will then categorize them as follows:

Etsy valueSeller Ledger Category
Order valueProduct Sales
ShippingShipping Collected
Discount amountDiscounts
Refund amountRefunds
Shipping LabelOffice expense
Etsy feesCommissions & Fees

If you’d prefer, Seller Ledger also allows you to customize how you’d like to see your Etsy information to be categorized. Just go to the Settings tab and click the Customize button:

We posted earlier about ways you might want to consider using this feature.

Help spread the word to other Etsy sellers

We have seen a number of posts on the Etsy Community about GoDaddy Bookkeeping going away. If you have a chance, we’d love your help in letting folks there know that a new solution is available.

Let us know what you think

We’re always looking for constructive feedback, so please let us know what we can do to make Etsy bookkeeping easier and better. Email us at [email protected]