Skip to content Skip to sidebar Skip to footer
Inicio / How to Upload Amazon Sales Reports Into Quickbooks Onlin

How to Upload Amazon Sales Reports Into Quickbooks Onlin

Publicar un comentario

In this blog we go through three methods on how to record Amazon sales in QuickBooks Online, based on your situation. For a visual walk-through, you can as well view our YouTube video here.

The challenge with e-commerce accounting is that information technology is fundamentally dissimilar from any other type of accounting because financial activity flows through your sales channels , not your depository financial institution accounts. There are different methods of due east-commerce bookkeeping, and where y'all are in your business concern determines which one will work best for you at present.

What works well at one level probably volition not work also for another level. And so, we advise asking yourself 3 questions to narrow down which method is best for you right at present:

  1. How big is your business organization right now?
  2. Where does getting fiscal data fall on your list of priorities?
  3. What kind of decisions are yous trying to make with this information?

Let's look at 3 different scenarios and methods to see which one may be a fit for yous.  Only commencement, nosotros need to set the phase (using Amazon as our sales aqueduct case).

Amazon deposits into your account every two weeks. What y'all're seeing when that deposit hits your account is really a summary of everything that has happened over the past 2 weeks. It includes all the activity with orders, refunds, aircraft services, selling fees, and other stuff. All of this is lumped into i eolith.

How yous record all of these activities depends on which method you lot choose.

Method 1 (all-time for pocket-sized Amazon Sellers): Record Amazon cash deposits every bit "Sales Income" in QuickBooks Online

We are assuming you are using QuickBooks Online (QBO).  You've synced your banking company accounts and your credit cards and at present the data is flowing into your Cyberbanking Centre.

  1. Find your "Amazon Settlements" deposit
  2. QBO will probably default to the category of Sales of Product Income and that is totally fine. Or, you tin can change information technology to Amazon Sales or whatever makes sense to you lot.
  3. After you decide where you want to put this deposit, just click Add together.  Information technology volition hit your financial statements and y'all're off and running!

This is by far the simplest, least time-consuming pick, and at the terminate of the day your net income is correct. This is best if y ou are a pocket-size east-commerce seller making less than $100K/twelvemonth. You are in the throes of figuring out how to build your business. You are driving revenue, learning how to market finer, figuring out how to pattern a great product and source it, figuring out how to work with your vendors…

Your to-do listing just goes on and on and on! T hese activities are significantly more important to the life of your business than spending hours digging into all the details of your e-commerce bookkeeping.

You lot simply need to know if your concern is making or losing coin, so have something to manus to your accountant at the cease of the yr so you can fulfill your obligation to the revenue enhancement human being. Some cons of this method are that information technology doesn't requite y'all a whole lot of detail, creates some timing bug, and it skews your margins at the gross profit level. There is a lot of information that you're non seeing, and that information is important if yous're trying to make decisions about your due east-commerce business, but you may non need to know all that item correct this minute.

If you're making over $100K a year AND yous're scaling your concern AND trying to employ your fiscal statements to brand skilful decisions, you probably need to look at the next method for recording Amazon sales information in QuickBooks Online.

Method 2 (for growing Amazon Sellers): Amazon activeness recording in detail

This method is usually all-time for Amazon Sellers making $100K-$500K a year. You've worked hard and you're starting to go the hang of all this! Take a moment to strut around town, acting similar you're the male monarch of the globe. You've earned it! Merely y ou still don't have time to spend hours analyzing a long list of numbers on an Excel spreadsheet to figure out the information y'all demand. Hey, we hear you lot and we've got your dorsum!

(Past the way, this may be a good time to consider outsourcing your accounting.)

This method will give y'all more detailed Amazon sales data in QuickBooks Online, but without having to go crazy getting it. Basically, the only difference is that you're going to break out your Amazon bookkeeping data into categories instead of lumping it all into one line item. You'll be able to come across information like the following:

Amazon Sales Data in QuickBooks Online
Amazon Sales $150,000
Aircraft Income $1,000
Sales Tax Collected $3,000
FBA Inventory Reimbursement $6,000
Amazon FBA Fees $36,000
Chargebacks/Refunds $20,000
Shipping Fees $3,000
Promo Rebates $1,000
Net Deposit In Depository financial institution Account $100,000

Heads upward!  This method does require a periodical entry in QBO. (Actually, don't allow this scare yous off.  We'll walk you through it to make information technology so simple and like shooting fish in a barrel that you lot'll exist shouting from the rooftops that you can make journal entries like a pro now! Become YOU!!)

1. Download your settlement report from Amazon:
      1. Sign into your Amazon Pay account on Seller Key.
      2. Click on the reports menu, and so click payments .  On the Statement View tab, a view of your current open settlement appears.
      3. To view and download copies of your settlement reports, click the All Statements tab.  Click the buttons to view or download the applicable reports. On this page you lot're going to see all the social club activity, refunds, shipping information, selling fees, and any other transactions that take happened in the past 2 weeks. Notice that the number at the bottom is what was deposited into your depository financial institution business relationship. And so, now you're going to put all this bookkeeping goodness into a journal entry.
ii. Create a journal entry in QuickBooks Online
      1. Click on the + NEW push button at the top left, and then click on Journal Entry . Within the journal entry window, you'll meet Accounts, Debits and Credits .
      2. Yous can map all these line items however you lot want to inside of QBO. Do what makes sense to you.Rule of Thumb:

        Blackness = Credits (money coming in)

        Red = Debits (coin going out)

      3. For instance, you can lump all the Order info together, the Refunds together, etc., OR you tin do individual line items.  What level of detail exercise you demand?
      4. At the bottom, you'll select which Bank Account information technology's existence deposited into and, if you've done all your debits and credits correctly, the total should default to the amount that'south beingness deposited. Whoopee!

Note:  You can as well generate and download custom reports from the Date Range Reports tab.

Method two Cons

The biggest problem with this method is the timing issue. For case, if Amazon is depositing into your account every ii weeks, it may not e'er line upwardly neatly with the stop of the month. What practice you practise if yous go a eolith on the five th ?  Most of that acquirement is actually from the previous month. If you lot're watching the trends of your business, trying to close out a month and match your income with the price of goods sold (read our COGS blog here), yous're actually going to intendance about period-ending stuff.

Also, this method doesn't give you a lot of control over seeing all the detail of what's going on behind the scenes. Did yous know there's literally over 400 different line items of how Amazon tin can be bringing money in and taking money out? To effigy all that out, you're going to have to exercise a deep swoop into the back-end reports, and sort information technology out according to date, and then sort that co-ordinate to activity, and and then…

Is your head spinning withal?

Ours, too! But Method 3 volition assistance y'all get everything under control

Method three (for established Amazon Sellers): Amazon accounting apps

This method is for established Amazon sellers, usually doing more than than $500K in annual sales. Yous have been doing your business long enough that y'all know you lot need to make your accounting be a source of truth for you.

Some of the complaints we hear from people before they start working with us are:

  • My accounting is not a source of truth for me
  • None of this looks right to me
  • My accounting doesn't match the reports coming off my channels
  • I accept no idea what'south really happening.

You're to the indicate in your business organisation where y'all need to do a deep dive into the Amazon activity, and every other aqueduct you're selling on, so you can make your accounting go a source of truth for you now and so you lot can reference it later to get really good, solid data.

Call back, good data makes good decisions possible.

Apps to improve tape Amazon sales data in QuickBooks Online

This requires a highly sophisticated knowledge of Amazon and your accounting tools OR a much better alternative is to adhere a tool that will allow y'all to sync the 2 systems together.

In an try to save you hours of learning and mastering time, let us introduce you to some tools that make this piece of cake and affordable:

  1. Go to your Apps in QuickBooks Online.
  2. Type in Amazon and information technology'll bring up a listing of applications that integrate with Amazon and QuickBooks Online.
  3. Two of our favorites are Webgility and A2X (view our A2X video here), though there are lots of others, too.
  4. When yous click on an app, it'll take y'all to an overview, ordinarily with a quick video to show you how it works, and what information technology costs.

When you lot wait at the pricing, you'll run across that these apps are very reasonably priced for the work they'll be doing for you.

Information technology is worth it to invest a little money to salvage yourself hours and hours of time figuring out your accounting with spreadsheets and columns and numbers and all that. Ugh!

Or, if y'all still don't have the time to dig into all this, call back that outsourcing is always a corking option. Come talk to us. This is what we practice best!

floresdautly36.blogspot.com

Source: https://ledgergurus.com/how-to-record-amazon-sales-in-quickbooks-online/

Publicar un comentario for "How to Upload Amazon Sales Reports Into Quickbooks Onlin"