See more of the important information on your screen

We’ve made several changes over the past few weeks to make it easier to see the most important information on your Seller Ledger screen.

Account balance details

When clicking into an account view from your Dashboard, we had previously shown the balance details at the top (including totals funds, available funds, etc.) by default. However, because customers tend not to rely on these details every time they click into the account, we have moved them under a new “Balance” button:

Click to expand

Click the green “Balance” button to see the balance detail information:

Click on the same button to hide these details. This reduces valuable vertical screen real estate and fits more transactions on the screen.

Rapidly categorizing transactions

Again, in an effort to make better use of vertical screen real estate, we’ve also changed the interaction for bulk editing of uncategorized transactions, pleasing everything on the same row:

Changing category of individual transactions

In an effort to make each transaction row more readable, and to save space, we have combined the visual cue for changing a transaction category with the category name, especially for uncategorized transactions:

Please let us know what you think of these changes by contacting us at [email protected]

View expenses by vendor

As we all work our way through the 2023 tax season, the team at Seller Ledger has begun working on improvements to help give you better insight into your business.

Expenses by vendor

You will notice a new report under the “Reports” tab – one called “Expenses by Vendor”:

This report is made possible because of some important functionality we’ve added to transaction tracking. As you can see from the following example, there is now a new “contact” field in Seller Ledger account views, labeled as “Transacted with”:

This field allows Seller Ledger to group spending amounts by the name of each “contact”.

Now, you may notice that the information coming in from banks and credit cards is hard to group unless the names here make sense. This can be due to a variety of reasons:

  • Paper checks – In those cases where you must write a paper check to a vendor, most banks simply provide a description about the check itself, not the name of the vendor.
  • Very long, hard to decipher descriptions – Sometimes we just can’t tell who the vendor or customer is. In those cases, we default to “Unassigned.”
  • Similar, but not quite identical names – This varies by bank, but sometimes they use very small variations in vendor names that can make it hard to group transactions together

Fortunately, Seller Ledger has implemented a number of features to help you quickly edit these contact names.

Editing Contacts

Next to each “Transacted with” name, you’ll now see an edit icon. Click that to either choose a “contact” that’s already in the system, or add a new one:

Now, editing each transaction one at a time might make sense for paper checks, but for most imported transactions, you’re going to want to edit them in bulk. And for that, we’ve added each of the following capabilities:

  1. Multiple select: choose multiple transactions and edit them in one step.
  2. Filter by “unassigned”: to see all of your transaction where we are unable to guess at a contact name, choose “unassigned” from the list of filter options.
  3. Sort by “Transacted with” and by “Description” fields: for those pesky, small variations of the same name, it sometimes helps to sort so that similar names are grouped together.

Hopefully, this helps provide a bit more insight into how your business is doing. Stay tuned for more updates along these lines, as we have big pans for 2024.

Upload inventory into Seller Ledger

For eCommerce merchants who want to track their inventory stock levels and per-item gross profit, we’ve now made it easier for higher volume sellers to load their inventory information into Seller Ledger.

If you make large purchases from certain vendors, and don’t want to type all of those items into Seller Ledger, there’s now an easy way to upload your items (and cost information) via a CSV file. Simply generate a comma-separated file that contains columns with headings of “sku“, “product name“, “quantity” and “total cost” and upload it inside of any of your inventory purchase transactions.

Not only can this help you save time when entering purchase information, but it comes in particularly handy if you want to start the year off fresh, or import inventory from another platform.

Read more about how it all works in our knowledge base article.

Better match 1099-K amounts with US time zone support

To help eCommerce sellers better match the 1099-Ks that get filed by online payment providers, Seller Ledger today announced support for local US based time zones.

Why is this important?

When Seller Ledger imports your transaction history from different online sales channels and banks, we receive them with timestamps (which, if you’re curious, might look something like “Tue, 26 Dec 2023 15:14:01.753000000 UTC +00:00”) You may notice the “UTC” in there – that stands for Universal Time Coordinated (it used to be called Greenwich Mean Time) and it’s 5 hours ahead of EST (or 4 hours ahead during daylight savings.)

However, online marketplaces, when providing transaction totals and reports, tend to use the customer’s local time zone to calculate those totals. So, to help make sure you can match the numbers that online marketplaces are reporting (and be consistent with the IRS from year to year,) we have now added the same time zone support.

How do I change my time zone?

To change your time zone, simply go to Settings -> Business and change the time zone like you see below:

That’s it. From now on, Seller Ledger will use your local time zone when reporting transactions.

Search transactions

Seller Ledger now allows you to search among your income and expense transactions. In addition to filtering transactions by date range or category, you can also now search using specific words that show up in your transaction descriptions.

For example, let’s take a look at a full list of “Income” transactions below:

Now let’s say I wanted to see just the sales of Hess Trucks with the “Dragster” included. Simply type “Dragster” into the “Search” box, hit return and voila:

We know folks have also requested similar search capability within Inventory, and that is on the list. In the meantime, please let us know what you think of this functionality, especially any ways that we can make it better by emailing us at [email protected].

Import Bank and Credit Card transactions via CSV

To help reduce data entry for poorly support banks and credit cards, Seller Ledger has now added the ability to import transaction history via CSV formatted files.

This will come in handy in a couple of scenarios:

Poorly supported banks

While we do have great coverage of most banks and credit cards through our banking partner, Plaid, we have learned of a few cases where a certain bank or account type isn’t well supported (often from small regional credit unions.) In these cases, if your bank or credit card account is not well supported via direct integration, you can add a new account that supports CSV-formatted files.

Just click “Add an account” from your dashboard, and on the right-hand side of your screen, you will see a new link under the Add Bank… button.

Clicking that link brings you to a new screen where you can choose the type and name of your bank or credit card account:

Choose the type of account, give it a name and click “Create Account.” Doing so will add a new account to your dashboard and allow you to upload a CSV file of your transaction history, much like you can do for Poshmark and Mercari.

Then go to your bank or credit card’s website and download transaction history using the CSV (aka “comma-separated”) format.

Because CSV files are less flexible than direct integrations, ensuring proper formatting is critical. We have outlined some guidance in this support article.

Also note: for any customers still in their trial period, Seller Ledger still applies the same 90-day history window, and will ignore transactions outside that range.

Banks with limited transaction history

As a policy, we ask customers to commit to an annual plan in order to go back and get more than 90 days of transaction history. While we have a good track record with online sales channels and many banks, some banks simply do not provide more than 60 or 90 days. Fortunately, this new CSV file support allows you to go back and upload older transaction history. Just click into your connected bank or credit card account, choose the Upload History tab (as seen above,) and upload the CSV file you downloaded from your bank.

We continue to make this new CSV feature more flexible, so if you come across an issue, please let us know at [email protected] and we’ll work to improve it.

Import Mercari sales report into Seller Ledger

We are pleased to announce that Mercari sellers can now import their sales report into Seller Ledger.

Like Poshmark, Mercari does not provide a public API, so we can’t automatically grab your transaction history like we can with Amazon, eBay and Etsy. But, just as we do with Poshmark, we allow you to upload the Mercari sales report.

mercari-handbags

Step 1: Download your Mercari sales history

In your Mercari account, navigate to the Seller dashboard (under your profile image.) From there, click on “Sales report.” You will be asked for both a beginning and end date for your transaction report. Once you have selected the date range, click the “Generate report” button.

You should see a .csv file generated, with a name that begins with “Custom-sales-report” and ends with the date range you selected. Download that file to your computer.

Step 2: Add a Mercari 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 Mercari.”

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

Step 3: Upload your Mercari sales report file

Once you’ve created your new Mercari account, you’ll see it among your list of connected accounts on the Dashboard. Note the icons that differentiate between accounts that automatically connect and those that require CSV files be uploaded.

Clicking into the balance shown for your new Mercari account and click the “Import History” tab. Here you will see the option to upload a CSV file. Choose the file you downloaded from Mercari 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 Mercari file is.

Step 4: Categorize your Mercari payouts properly

If you have connected a bank account to Seller Ledger, there’s a good chance your Mercari payout totals are showing up there. To ensure that nothing is getting double-counted, make sure to categorize those payouts as transfers. Simply scroll to the bottom of the categories list and find your new account.

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

Because we can’t pull in your new sales and expense information on the daily, 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.

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

Automate your Amazon accounting with Seller Ledger

We are proud to announce that Seller Ledger now connects directly with your Amazon Seller Central account to help automate much of your Amazon business accounting. As with eBay and Etsy, you can link your Amazon Seller Central account to Seller Ledger and we’ll regularly import your sales and expenses and automatically categorize them for you. Just log into your dashboard and click the “Add Account” button to link your Amazon account.

Also, like with eBay and Etsy, you can always change how you’d like to see your Amazon information categorized by customizing your settings.

Thanks again to the customers who helped us in testing this new integration. Amazon did limit the number of people we could link during the beta period, so we may yet see some new transaction types. If this happens, you may see your Amazon import pause, and we’ll be notified on the back-end to add support for the new transaction type.

Amazon has also listed us in their Selling Partner Appstore, where customers are able to learn more about the product and leave reviews. We’re big fans of customer word of mouth, so if you have an opinion about Seller Ledger and would be willing to share it with other prospective customers, please do.

Next up:

We’re actively working on a Mercari import solution (similar to what we recently announced with Poshmark) and the ability to upload CSV files for poorly or unsupported banks. If you would be interested in beta testing either of these features, please email us at [email protected].

Until next time…

The Seller Ledger team

Seller Ledger adds easy inventory tracking for eCommerce sellers

eCommerce sellers, large and small, now have the ability to track inventory with Seller Ledger. Until now, customers could only write off inventory as “cost of goods sold” when purchased. But no longer!

Why track inventory in Seller Ledger?

There are a number of reasons to track inventory:

  1. For most eCommerce sellers, the IRS requires that you do so.
  2. It better aligns costs with your sale.
  3. If done properly at the item level, it can help automate accurate stock levels (avoid stockouts,) as well as tell you how much money you make on individual orders and items.

So what does Seller Ledger offer in terms of eCommerce inventory tracking?

There are now 2 main ways to track inventory in Seller Ledger: what we call “balance-level” and “item-level” tracking.

Option 1: Balance level tracking (a.k.a. “periodic inventory”)

For those sellers who don’t want to track every item of inventory, the IRS uses a simple formula to help you calculate “cost of goods sold”:

Cost of Goods Sold = Beginning balance + Purchases – Ending balance

We’ve modeled our new inventory view after this simple formula:

Using this approach is pretty straightforward – you only have to do a few things:

  1. Count/estimate the cost of all of your unsold inventory once per year (or quarter, or month – you choose)
  2. Track purchased goods/materials for resale throughout the year
  3. Do some simple math (or let Seller Ledger do it for you)

Read a more detailed explanation of exactly how this works in practice.

Option 2: Item level tracking (a.k.a. “continuous inventory”)

Do you already keep a spreadsheet of all of your inventory, including how much you paid for each item? When an item sells, do you have to go back and update it? Have you tried to figure out how much money you make on each sale? If you can answer “yes” to any of these questions, then this option is for you.

While a bit more effort is required, the steps are quite simple:

  1. When you purchase goods for resale, categorize them as Inventory purchases
  2. Within each purchase, enter each item, including a unique SKU value, and the item’s cost. This process works very similar to splitting transactions.
  3. Alternatively, you can start from your list of sold items (the order history we’ve already imported for you) and just tell us which purchase transaction included the item sold.

If you provide Seller Ledger with this level of detail, we do a few things for you automatically when an item sells (matching first based on SKU first, then by name):

  1. We reduce the stock level for that item in your inventory
  2. We calculate and generate the cost of goods for that item
  3. We show you your gross profit for that order

Learn more about how to use “item level” inventory tracking.

Do I have to track inventory in Seller Ledger?

You do not. If you would prefer to just categorize inventory purchases as “cost of goods sold,” you are free to do so. But, you might want to make sure you understand the risks with that approach. We’ll be writing another post about that option soon.

How do I try this out?

Just discovering Seller Ledger? Start a 30 day free trial right now – no credit card required.


For existing customers, just log into Seller Ledger, and you will see two new changes to the website. First, on the left of your Dashboard, we have added and made visible a new “Inventory” asset account. Second, there is a new top-level navigation link for Inventory. For those who previously categorized inventory purchases as “cost of goods sold,” you can elect to switch to properly tracking inventory. We explain more about how that works here.

Is there an additional charge for tracking inventory in Seller Ledger?

No – this feature is available to all customers at no additional charge. Unlike other accounting/bookkeeping platforms, we think even the smallest sellers should be able to see how much money they make on each item and keep on top of their inventory stock levels.

Please tell us what you think

This is a pretty big release, and represents weeks of work and planning. It’s also something we never got to tackle with Outright/GoDaddy Bookkeeping. As such, we’d love to hear from you as you try this new functionality – the good, the bad and the ugly.

Thanks from the Seller Ledger Team

Split a transaction into multiple categories

Another one of the most frequently requested enhancements has arrived: the ability to split transactions into multiple categories.

Do you have charges on your credit card for multiple items that belong in different categories? Do you have deposits in your bank account from marketplace payouts that represent net amounts, after combining sales, shipping and subtracting fees. Well, you no longer need to choose a single category for each of those. Now, when you click the button to “Categorize” a transaction, you will see a new option to “Split” that transaction:

Now, click on the “Split Transaction” to break that transaction into multiple categories:

Notice that as you enter an amount in each row, the remaining difference is updated, to let you know how much of the original transaction you still need to account for. As you can see, you also have the ability to “Add Splits” to provide more detail.

For those of you selling on platforms like Poshmark, Mercari and others, who don’t provide APIs, this feature should help you get your numbers more accurate (in order to better match any 1099-k’s you may received.) Though feel free to contact those platforms and tell them to “get with the times”:)

As always, please let us know what you think of this change by emailing us at [email protected].