Automate Your TCGplayer Accounting

Based on popular demand, we’ve just released an update to Seller Ledger to help automate your TCGplayer accounting.

Do you sell cards from top games like Magic: The Gathering, Pokémon, Yu-Gi-Oh!, One Piece and Disney Lorcana? Well, now there’s an easier way to track your sales and determine your profits. Using our updated Chrome browser extension, Seller Ledger will regularly import the key information you need to determine the profitability and taxes owed for your business, including:

  • Card and pack item prices
  • Shipping collected
  • Commissions
  • Transaction fees
  • Item fees
  • Payouts

Plus, if you track your inventory costs with unique SKUs, Seller Ledger will automatically tie those sales back to the item costs, reduce your inventory and update cost of goods sold.

Seller Ledger matches payouts to your bank deposits

Seller Ledger does something pretty powerful when we import your sales, fee and payout history from TCGplayer. We compare all imported transactions from TCGplayer to the payouts we receive and make sure the sum total of all of the transactions in the payout match the amount of each payout.

We even organize your transactions into two sections when you click into your TCGplayer account: “Not paid out” transactions and “Paid out” transactions. In fact, from the TCGplayer account summary view, you can click into any payout to see every single transaction that makes up that payout. This makes sure that your financial amounts from TCGplayer are accurate.

Lastly, if you choose to link your bank account to Seller Ledger, we will also automatically match the payouts that come from TCGplayer to the deposits when they show up in Seller Ledger. These are properly treated as transfers, so you avoid any risk of double counting.

How to automate your TCGplayer accounting

In order to link your TCGplayer account to Seller Ledger, you need only do the following:

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.

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

Automate Accounting for Square Sellers

In our continued efforts to simply eCommerce accounting, we’re pleased to announce the ability to sync your Square account with Seller Ledger. This provides the biggest step to better automate accounting for Square sellers. This functionality is now in open “beta”, meaning anyone can try it.

As we did before with our Shopify integration, we allow Square sellers to bring in both online and point-of-sale transactions.

To link your Square account, simply click the “Add Channels, Banks and Accounts” button on your dashboard. Then, click the Square logo:

Automate Square accounting

Log in to Square and, once you are returned to Seller Ledger, we will begin importing you transaction history. Doing so will allow us to bring in sales, returns, fees and even sales tax that you may have collected – all broken out in detail and summarized to help you with tax filing.

And as with any new functionality, we’d love to hear any constructive feedback you might have. Email us at [email protected].

Track Invoices in Seller Ledger

As we continue to improve the product based on customer feedback, today we’re announcing the release of improvements to tracking invoices. In accounting parlance, this involves accounts receivable (money owed to you) accounts.

Why would I need to track invoices?

For many small sellers, cash-based accounting works quite well. You simply recognize income and expenses when you receive or spend the money. But as your business grows, you may choose to use more of an accrual model, where you recognize income when you make the sale, since payment can come a bit later. For that, you’ll need some new accounts.

Tracking invoices

To track invoices in Seller Ledger, you’ll want to create a new account. Go to Settings -> Accounts, or just click “Manage accounts” at the bottom of the account list on your dashboard.

Click the “Add Asset Account” button to see the following:

Choose “Accounts Receivable” as the type, give the account a name and, optionally, a start date, and you’ve created an account that will let you keep track of the money people owe you.

Now, once you’ve created your invoice account just click into it to start recording invoice transactions.

At the top of the screen, you’ll see buttons to “Add an Invoice” or “Receive a Payment”

Click “Add an Invoice” and you’ll see a screen like the following:

You can even split the invoice amount into multiple categories if you would like.

Tracking invoice payments

When a customer pays an invoice, you can record that payment in a few different ways.

If you have connected the bank account where checks and payments get deposited, you should see the payment for an invoice show up there. Simply click to categorize that payment as a transfer to the new Invoices account.

Notice that, as soon as you choose the Transfer: Invoices option, a button appears to allow you to “Apply to Outstanding Invoice.” Click that and you can mark the specific invoice as having been paid.

And if you don’t have a connected bank account, just click into the Invoice account and choose the “Receive a payment” button.

Invoice amount tracking only

At the present time, Seller Ledger only allows you to track the amounts of your invoices. We do not provide electronic sending of invoices. Not do we yet support the ability for customers to pay your invoices electronically.

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