Accounting/Bookkeeping Archives - Page 2 of 5

eBay 1099-Ks are coming…electronically

Seller Ledger on November 11, 2024

Yesterday, we received the following email stating that eBay’s 1099-Ks are coming electronically for 2024.

Understandable confusion – but don’t worry

First, this email was received for a seller account that only sold personal items this year. This might raise concerns that personal sales may get reported as “taxable.” But that’s not the case – it just means you will want to properly account for them in your personal tax return, which we explain in this post about the relationship between personal sales and 1099-Ks.

Second, the seller account that received this email also sold less than $600 for all of 2024. This raises the question about the sales threshold for receiving 1099-Ks. eBay links to an article that discusses reportable criteria, so clearly not every seller will receive a 1099-K. As of the last IRS announcement, the threshold for 2024 is expected to be lowered to $5,000 in gross receipts. But, as we’ve seen before, this could still change.

As we’ve mentioned before in prior blog posts, 1099-Ks are “informational” documents designed to help identify eCommerce sales across platforms. So long as you are correctly tracking and reporting actual business profits, you should have nothing to worry about.

Get your business finances organized.

Need help making sure you only pay taxes on your net business profit? With automated bookkeeping through Seller Ledger, we pull in your detailed sales and expense information to make this as simple as possible. We also offer a 30-day free trial, no credit card required.

Try it free

Make sure to deduct your Etsy Ad fees

Seller Ledger on November 7, 2024

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] .

See your sales and expenses by channel with new Seller Ledger report

Seller Ledger on November 2, 2024

To help our multi-channel sellers compare metrics across sales channels, we have just released (in open beta,) a new “Channel Breakdown” report. Now you can see your sales and expenses by channel.

Sales and expense information that we import directly from each channel will show up in the proper categories. And don’t forget, we allow you to customize how all of those transactions get categorized, by channel.

In the future, we hope to make it easier to add additional channel cost information from other sources, like credit cards.

Automate your Poshmark accounting with updated Seller Ledger integration

Seller Ledger on October 18, 2024

When we first launched our Poshmark integration, the only option was to download sales history reports in CSV file format and upload them to Seller Ledger. While this provides an accurate view of your Poshmark financial performance, it required ongoing effort on your part to keep your finances up to date.

Fortunately, now users have a more automated choice. By using the Chrome browser and Seller Ledger’s custom-built Browser Extension, Poshmark sellers can now see their sales history import into Seller Ledger on a daily basis. Not only that, but we also now import your payout information (which is not included in the downloadable Sales Reports from Poshmark.)

To learn more about how to automate your Poshmark accounting, view this support article.

If you’re new to Seller Ledger and want to make your Poshmark accounting much easier, try it free for 30 days, no credit card required.

See your eCommerce sales by state

Seller Ledger on August 19, 2024

In response to a number of customer requests, we recently rolled out a new report called Sales by State. You can find it under the “Reports” tab:

This reports shows you sales by state, broken into Non-taxable Sales (e.g. any sales collected and remitted by a marketplace facilitator like eBay, Etsy, Amazon, etc, as well as any shipping collected in states where shipping is not tabale) and Taxable Sales (e.g. sales on store platforms or other channels where sales tax need to be collected. We also show any sales tax that has been collected by not remitted.

You also can click to sort by any of the columns provided.

At the time of this post, the feature is currently in an open “beta” period. Please let us know of any feedback you have at [email protected].

Thanks!

A more flexible dashboard

Seller Ledger on August 9, 2024

The “At a glance” section of the Seller Ledger dashboard hasn’t received a lot attention since we first launched. Based on feedback from customers, we recently added the ability to choose from a few time periods that you can view.

Have you ever logged into Seller Ledger and seen your data at the top of the screen changed to all zeros? Well, that’s because the default view was “This month”, which, on the first of a month, often reverts to zero because we haven’t imported any new transactions yet. It’s even more alarming when you get to January first.

Well, we’ve made a couple of changes to help with that.

First, we now offer a few different time periods to choose from:

As you can see, instead of always being “Month to date”, you can now choose “Prior 30 days” and “Year to date”.

Second, we now default to “Prior 30 days” so that this section is likely to always have data displayed.

While a small change, we hope it helps avoid some confusion and adds value to the customer experience.

Add new accounts more easily

Seller Ledger on June 27, 2024

In our continued efforts to make Seller Ledger easier to use, we rolled out some improvements to how accounts are linked and displayed on the Dashboard page

The first thing you might notice is that, if you have multiple accounts from the same sales channel or bank, they are now grouped more obviously together:

But the biggest change is the addition of the new “plus” icon within each channel/bank header:

Clicking this icon allows you to quickly add another account from that same bank or sales channel.

To add a new sales channel, or accounts from a new bank or credit card, you would still click the button below your accounts, now more accurately labeled “Add Channels & Banks”

As always, we welcome feedback on our product changes, so feel free to email us at [email protected]

Import Whatnot sales history into Seller Ledger

Seller Ledger on June 17, 2024

We are excited to announce that Whatnot sellers can now import their “ledger” details into Seller Ledger.

While Whatnot does not yet provide a public API (which means we can’t automatically grab your transaction history like we can with Amazon, eBay, Etsy and Shopify,) they did release the ability to export ledger details in CSV format earlier this spring. We can import these files directly into Seller Ledger, like we do for both Poshmark and Mercari.

Step 1: Download your Whatnot sales history

Go to Seller Hub, under Financials, and then under Ledger – you should see an option to export your history in a CSV formatted file. Go ahead and download and save that file.

Step 2: Add a Whatnot account in Seller Ledger

When you click the “Add account” button under Connected Accounts on your Seller Ledger dashboard, you will now see an option to “Connect to Whatnot.”

After clicking the Whatnot button, enter a name for your new account and click “Create Account”

Step 3: Upload your Whatnot ledger file

Once you’ve created your new Whatnot account, you’ll be taken directly into that new account, to a screen that allows you to upload your Whatnot ledger file. Choose the file you downloaded from Whatnot and click “Save.” Your file will be uploaded and your transaction history will be imported into Seller Ledger.

Trial users

If you are still in your trial period, Seller Ledger will only import the last 90 days of transaction history, regardless of how large your Whatnot file is.

Step 4: Categorize your Whatnot payouts properly

Whatnot currently pays sellers via Stripe (often to a bank account) and PayPal. If you link your bank or PayPal account to Seller Ledger, you’ll want to make sure that your payouts from Whatnot don’t get double-counted. So, when you see your Whatnot payouts hit your bank or PayPal account, make sure to categorize them as “Transfer: My Whatnot Sales” – or whatever you named your Whatnot account.

Step 5: Remember to regularly update your Whatnot sales in Seller Ledger

Because we can’t pull in your new sales and expense information on a dailybasis, you’ll want to make sure to come back every once in a while to upload your latest sales history. How often you choose to do so is your choice. We show the date of the most recent imported transaction on the Seller Ledger dashboard to help remind you.

Lastly, if you make a mistake with any of your uploaded information, it’s not a problem. The “Import History” tab shows you all of the files you’ve uploaded over time, with the ability to simply delete one or more and try again.

New to Seller Ledger?

Try it free

We know there are other channels out there that provide CSV files of transaction history. If you would like to see other channels supported, please request a new platform or email us at [email protected] with your interest and, if you’d like to be particularly helpful, a sample of a transaction history file from that channel.

Cheers,

The Seller Ledger Team

Add inventory costs from receipts

Seller Ledger on June 13, 2024

In our continuing efforts to make eCommerce accounting easier, today we announce a big step forward for inventory tracking.

In short, you can now take a picture of your receipt and upload it to Seller Ledger. We use the latest “artificial intelligence” technology to extract item cost information from the image and pre-populate the inventory purchase form.

To show you exactly what’s possible, here is a picture, taken from an iPhone, of a receipt from a trip to our local Marshall’s store:

Within Seller Ledger, if this purchases came in from a linked bank or credit card, make sure to categorize it as “inventory” and then go to Inventory -> Purchases and click “Add details.” If this was a cash purchase, or from a source not connected to Seller Ledger, just go to this same screen and click the “Add Inventory” button.

You will see a new option at the bottom of the screen to “Upload image or pdf”:

Click the “Upload receipt” button and choose the picture that you took of your receipt (or try the example we’ve posted above.) Seller Ledger will then process the image and extract as much information as possible. In the above example, you will end up with the following:

And scroll down to see the remaining information that we were able to extract from the image…

Notice that we found 4 unique items with descriptions and the correct per-item costs. Not only that, but we were able to recognize the $6.32 in sales tax. And given our recent feature that allocates extra cost of goods amounts, we automatically allocated that $6.32 across the 4 items.

The one piece of work left for you to complete is to either identify or create the unique SKU for each item, which will then allow Seller Ledger to match to sold items, thereby updating inventory and cost of goods amounts automatically when it sells.

To help us improve this feature over time, it helps to get as may customers trying it as possible. Please give it a try and let us know how we can make it better.

Automatically allocate other charges to cost of goods

Seller Ledger on May 26, 2024

When you purchase inventory, there are often other costs besides the cost of the individual items that must be accounted for as part of “cost of goods.” In fact, we wrote a blog post about it a while back.

Until now, deciding how to handle those extra costs was something that customers had to figure out on their own. Well, no more. Now, Seller Ledger allows you to enter those additional costs and we automatically adjust the per-item cost of goods for your inventory.

You will now see a new “Other costs” field at the top of the form for entering inventory purchase details. Enter the total of any extra costs paid, be it sales tax, inbound shipping, processing fees, whatever. Then, as you record the item-level purchase details, you will see the “other costs” amount divvied up among the items, based on the weighted average cost of those items within the overall purchase.

This feature saves you time so you don’t have to attempt any calculations yourself. And it sets us up well to support the next big feature we’re working on: the ability to upload a picture of a receipt and have us create inventory purchase details from it. Stay tuned.