Move off Spreadsheets Even Faster – Upload Expenses and Income via CSV file

Have you been tracking business expenses in a spreadsheet for a while? Does the leap to traditional accounting software feel like more work than it’s worth? Well, no more.

In our never-ending quest to save sellers time, we’ve added the ability to upload expenses (and income transactions, if you so desire) in bulk, using CSV formatted files. Seller Ledger lets you keep all of that hard work and gives you a leg up when you want to try automating your accounting and bookkeeping.

How to upload your expenses

Just go to the Expenses tab, and you will now see a tab that says “Expense Uploads”. This is also where you can find the ability to upload many mileage trips at once.

Just follow the formatting guidelines on the screen (or take a look at our sample CSV template) and load your transactions. Plus, as an added bonus, you can include category names in there which, if they are the same as the ones you have in Seller Ledger, will group and total up your expenses and ensure they show up in the correct line of your tax report.

For income transactions, just do the same thing from the Income tab.

Simplify cost of goods sold if you don’t track inventory

If you don’t track inventory, but do have a running list of your cost of goods sold purchases, just include the “category” column and make sure to label those transactions as “Cost of Goods Sold.” Then check out how much more accurate your numbers look, including seeing your overall gross profit.

Stay tuned for more improvements in this general area. And keep sending us your feedback!

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.