Introducing multi-user support

As bigger companies have started using Seller Ledger, we’ve started to get more requests for provide access to multiple team members. Well, we now have that!

Like we did when rolling out access for accounting professionals, Seller Ledger account owners can grant access to other team members. The same permission restrictions apply – team members will be unable to do the following:

  1. Add or remove connected accounts, banks or credit cards
  2. Change your billing information
  3. Change your business name

To add a team member, simply go to Settings -> Business and click the button to “Add Team Member”

This will pull up a form asking for an email address. Just enter that and click “Invite”

Invite team member

That’s it. Your team member will receive an invitation to create an account on Seller Ledger to access your business books.

And, just like with accounting professionals, you can revoke access at any time. And there are no additional costs for using this feature.

Improved handling of transfers between accounts

Handling transfers between accounts is one of the most basic elements of proper accounting. In the world of eCommerce sellers, this includes payouts that get withdrawn from a marketplace account, like Amazon or eBay, and get deposited into your bank account. It also includes transactions like payments from your bank account to a credit card account. Because these transactions represent money that moves between accounts, they don’t impact your profit and loss. Making sure that they are treated properly is critical to accurate record-keeping, so you don’t end up double counting anything.

Seller Ledger does a great job of automatically recognizing transfers between different accounts and matching them. However, sometimes, due to timing issues with banks, or even potential mistakes make by customers, these automatic matches of transactions can get mixed up. To help with these cases, we’ve rolled out some improved functionality.

Match to a specific transaction

Let’s take an example of a credit card payment from your business checking account. You may have categorized it as a transfer to the correct credit card account, but it’s not showing as matched.

Bank transfer to match

To help with that, just click the edit/pencil icon next to the current “Transfer” category. It will bring up a new “categorize” pop-up with a new option to “Pick matching transactions”

Click that button and Seller Ledger will now show you any transactions that match that same amount across different accounts you have in the software. In this case, it finds the payment made on that Wells Fargo credit card.

Just select the transaction, click “Match Selected”, and you’re all set.

Choose the date to start importing transactions

Since we launched, Seller Ledger has automatically imported up to 90 days of transaction history from connected marketplaces, eCommerce platforms, banks and credit cards. This was designed to give everyone a chance to really get to see how the software works for them, on real data, during the 30-day free trial.

However, a number of customers over the years have asked for the ability to choose a specific start date. This has been most prevalent at the beginning of tax years, as customers like to start “fresh” (often after switching from more expensive, more complex solutions:)

Setting your own start date

While Seller Ledger still imports 90 days automatically, it is now super simple to go in and change, on connected-account by connect-account basis, when you would like data to import from.

First, just click on the connected accounts whose import start date you’d like to change:

Next, click on the edit/pencil icon at the top of the account view:

You’ll see a new option to choose a start date. Just pick the start date you’d like:

Click “Save” and you’re all set.

If you had any transactions prior to the new date you’ve entered, they will be deleted from the system. If you don’t want those older transactions deleted, DO NOT set a more current date than you want transactions for.

Billing limitations still apply

If you are just starting a free trial, you won’t be able to enter a date from the start of the prior tax year (or longer.)

See your Walmart profit per order

As we have done with both eBay and Amazon, we also recently released the ability for Walmart customers to view the NET profit on each order.

Walmart profit per order

Click the “>>expand” link next to any order in your Walmart account. Under the category split totals that make up that order, you will see a new “related expenses” section that includes other fees and expenses that are tied to that order. This includes the Walmart commission charged for that order. In addition, if you purchase shipping labels through Walmart, we include that too.

Lastly, as mentioned when rolling out our Gross Profit report, if you track your inventory costs at the item level and use unique SKUs for each of your Walmart items, we will match those costs to the correct item. That, plus the other related expenses, helps you see the true NET profit for each order on Walmart.

If you are a Walmart seller who’d like this kind of visibility and automation in your accounting, give Seller Ledger a try. We offer a 30-day free trial, no credit card required.

Change the categories of Etsy transactions

While we’ve had this functionality around for a while, a recent customer email reminded us that we can always do a better job explaining how things work.

In this case, an Etsy seller wrote in and asked how she can change the category on Etsy ads from the default of “Commissions & fees” to “Advertising. And she’s not the first customer to ask this.

Fortunately, Seller Ledger makes it quit easy to make that change. Simply go to the Settings tab and click the “Customize” sub-tab. If will bring you to a screen that looks like this:

You’ll notice that there are a lot of different Etsy fees, including:

  • Generic fees
  • Listing fees
  • Prolist fees
  • Renew fees
  • Renew expired fees
  • Renew sold auto fees
  • Renew sold fees
  • Renew auto expired fees
  • Payment processing fees
  • Offsite ads fees
  • Transaction fees
  • Shipping transaction fees
  • Shipping label insurance fees

If, as our customer was asking, you wanted to categorize Offsite ad fees as “Advertising”, just click on the edit/pencil icon on the far right to be given this screen:

Then just change the category to “Advertising”, click the “Save” button and you’re all set. Seller Ledger will treat all of these transactions as “Advertising.” This applies not only to all future transactions, but all prior transactions.

What about regular Etsy Ads?

Unfortunately, Etsy does not make the fees for their “on site” ads available through their API. Learn how to handle them here.

Pro tip

You may wish to group some of these Etsy fees into more granular categories. For that, we recommend creating sub-categories, and then mapping these details fees to those sub-categories.

Automate your Whatnot accounting with updated Seller Ledger integration

When we first launched our Whatnot integration, the only sales data available to Whatnot sellers was their Ledger history. Customers could download those reports and then upload the CSV-formatted files to Seller Ledger. Since then, Whatnot has added weekly order reports, which provides much more transaction detail, including:

  • Item prices
  • Coupon costs
  • Shipping costs
  • Commission fees
  • Payment processing fees

To take advantage of that, Seller Ledger has rolled out new functionality to automate Whatnot accounting. Customers no longer need to download files from Whatnot and upload them to Seller Ledger. All of that is taken care of.

How to automate your Whatnot accounting

In order to fully automate your Whatnot account within Seller Ledger, you only need two things:

1. You should use the Chrome browser when accessing Seller Ledger so that you can also make use of the second tool (below.)

2. Once you are using Chrome, you will want to install Seller Ledger’s custom-built Browser Extension. This extension allows Seller Ledger to automatically pull down and import the proper transaction details.

You can learn more on how to get set up properly in this support article.

Once you are properly set up, Seller Ledger will regularly access your Whatnot account, retrieve the order, coupon, shipping and fee information.

New Walmart Channel summary page

Continuing the work with did for both Amazon and eBay, we’ve just rolled out a new channel summary page for Walmart. While Seller Ledger has been importing Walmart sales, refunds and fees for more than a year now, we’ve made it even easier to make sense of all of that detailed data.

From your Seller Ledger dashboard, just click into your Walmart account to view a screen like the following:

Walmart summary

You can choose from a number of date ranges to see your data. You can click into any payout to view a summary of (and mini profit and loss statement for) that payout. You can even drill down to see every single transaction that makes up each payout.

You can also see a summary of your sales and expenses for the period, with a breakdown among selling costs.

Want help automating your Walmart accounting? Learn more about how Seller Ledger can help.

Closing entries

To better support accounting pros and some of our bigger customers who use more traditional double entry accounting, we are pleased to announce the ability to record year-end closing entries within Seller Ledger.

What are closing entries?

In essence, closing entries “reset” a businesses profit and loss each year. Think of the profit and loss report as a scoreboard, showing you how much money you made (or lost) in a year. When a new year starts, your profit and loss starts all over. But, you don’t want to lose track of the prior year scores. That’s where closing entries come in. These entries take the profit and loss amounts and move them to the balance sheet.

How to I record closing entries?

If you click on the Settings tab, you will see a new sub-tab for “Journal Entries.” This is has been updated since we first rolled out support for journal entries.

Click the button to “Add Closing Entry. You will then see a pop-up asking which year you would like to close.

Click “Review and Confirm” and you will be presented with the complete profit & loss for that year, as well as the net profit or loss that will be transferred to retained earnings.

Click the button to “Create Closing Entry” and Seller Ledger does the rest of the work for you. Your Profit and Loss will be reset for the next year, and your balance sheet will be updated to reflect the change to retained earnings.

Attach receipts to your transactions

To help eCommerce sellers stay more organized, we are pleased to announce that Seller Ledger now supports the ability to attach receipts to transactions. And we do it in a couple of ways.

Start with just your receipt

Do you have a cash purchase that you need to put into Seller Ledger? Take a picture of the receipt and upload it first. Seller Ledger, using some AI magic, will try to parse the image. We also support other file formats.

In this example, go to the Expenses tab and click the “Add Expense” button:

Then, click the option to “Choose File” and select the receipt file from your hard drive.

After choosing the file, Seller Ledger will extract as much information as possible and pre-populate the fields below. In this case, it got the date and amount correct, but I had to edit the Vendor and Description.

Click the save button and your new expense is recorded, with a copy of the receipt that you can view at any time by clicking on it.

Attach a receipt to an existing transaction

You can also upload a receipt to an existing transaction that has been imported into Seller Ledger. Just click into your bank or credit card account and you’ll see a new paperclip icon to the far right of the transaction.

Clicking the paperclip icon pops up a simple dialog box:

Find the image or file of your receipt and click Done. In your transaction list, you will now see the icon has changed to a small receipt, which you can click on to preview the file you just uploaded.

As always, we want to thank all of the customers who wrote in suggesting this feature. Keep ’em coming!

Reconcile Amazon payouts to bank deposits

If you are trying to tackle eCommerce accounting, you know how critical it is to be able to reconcile marketplace sales and expenses to the payouts that hit your bank account. Well, just like we previously did for eBay, we are pleased to announce the ability to drill into any Amazon payout to see the precise data that makes up that payout amount.

When you click into your Amazon account from your Seller Ledger dashboard and review your transactions, you have likely seen your payouts listed with an “>>expand” link next to them:

When you click expand, you’ll see some important additional information. Not only do we show the bank account details that the transfer was made to, but we show the summary totals by category.

And if that’s not enough, we also provide a button to be able to drill down and see EXACTLY which transactions make up that payout.

And as a reminder, if you link Seller Ledger to the bank account where those payouts get deposited, we will automatically match the payouts from your Amazon account to the deposit in that bank account.

This means you can look at any Amazon payout deposit and drill all the way back down to see the transactions that are included.

If you haven’t yet tried to automate your Amazon accounting with Seller Ledger, now might be a good time to try. No 3rd party connectors needed.