Helping You with Your Amazon FBA Business

How to Enter Amazon FBA Numbers into Quickbooks Online

Hello Everyone!  In this post, I’m going to show you how I manually add in my Amazon data into QuickBooks Online Simple Start.

Before we get started, please keep in mind that I’m not a professional accountant or bookkeeper.  If you’re uncomfortable with doing your own bookkeeping, I recommend hiring a bookkeeper.

*** 1/27/17 Update: Jim Cockrum & Team came out with a new course that has Amazon Specific Training with Quickbooks Online.  I have not taken the course, but have taken several of Jim’s other courses.  Here’s the link: Proven Accounting Training.

Amazon Payday
I enter my Amazon numbers at the end of my Amazon payment cycle.  I always start with the Payments -> Statement View report as it shows my deposit amount.  For the period from January 7 to January 21, I did $583.57 in sales and after Amazon deducted their fees, I received a deposit of $405.19 into my checking account.

Note: I picked this date range as it includes a reimbursement.


I have QuickBooks setup so that it syncs with my checking account at the bank and it categorizes the $405.19 deposit as FBA Sales Income.  At this point though, QuickBooks is showing an incorrect sales amount because my sales total was actually $583.57.  So, I need to correct that and also enter into QuickBooks all of those Amazon Fees that get deducted from our sales revenue.

Using the Transaction View Report
Unfortunately, the Summary View Report doesn’t go into detail on what the individual fees are.  Some people may like to lump all of their fees into one lump category called “Amazon Fees.”  Others may want to know every single fee down to the Order Handling and Pick and Pack fees.  I’m somewhere in the middle and this is what I like to track:

  • Inbound Shipping Fees
  • Inventory Placement Fees
  • Storage Fees
  • Monthly Professional Seller Fees
  • Return Fees
  • Amazon FBA Fees – Order Handling, Pick and Pack, Referral, Weight Handling

Each time I get a new fee, I make a decision as to whether I want to track it separately or add it to Amazon FBA Fees.

I use the Transaction View Report to calculate the different fees.  For example, to get your Inbound Shipping Fees, you can filter the view by “Service Fees” and then manually add up all of the “Inbound Transportation Charges.”


For those that track your numbers in InventoryLab or elsewhere, you should check to see if there’s a report that totals up the different fees for you and then you can just use that.  I’m actually able to get these same numbers from the Excel spreadsheet that I use, but I prefer calculating my fees from Seller Central.

I also use the Transaction View Report is to find the sales tax that I collected.  I’m sure I could get the same information from TaxJar or from one of Amazon’s other reports, but I prefer using this report.

What I do is print the Transaction View Report, then whenever there’s a number other than zero in the “Other” column, I click on the “Total” column to get the sales tax.  I then write that on my printout so I can add them all up in Excel in the next step.

Tip: To save on paper, change the setting on the bottom to show 50 results per page.

Using Excel
I love Excel and use this little worksheet to calculate my numbers so that I can enter them into QuickBooks:


I then verify that the Sales and Deposit amounts matches those from the Statement View Report.  As an additional check, I make sure the sum of the Inbound Shipping, Inventory Placement, Storage Fee and Professional Fee equals the Selling Fees -> FBA fees amount from the Statement View Report.  For this example, the fees are $47.23.  Also, my reimbursement of $22.89 shows up on the Statement View Report under Other Transactions -> Other.

Enter Numbers into QuickBooks
This is actually the easiest part.  You’ll just open your Amazon Liability register (see Balance Sheet post) and enter your numbers.  You can do this all in one entry but I like to split mine up between what I owe (fees) and what Amazon owes me (sales, tax, reimbursements).

Here’s an example of entering the fees:
041615 Blog Fees

Then I enter the sales, tax and reimbursements:

041615 Blog Sales

When I’m done, the number in red will be my deposit amount ($405.19) and then I reverse it out:


If I don’t reverse it, then QuickBooks will show an FBA Sales amount of $405.19 too much:

Run a Profit and Loss Statement
At this point, you can run a Profit and Loss Statement in QuickBooks to make sure your numbers match those from your Excel spreadsheet:


As you can see, all of the numbers match.  Please note that I don’t have the sales tax in the Profit or Loss Statement because that’s not an income or an expense.  The Sales Tax Payable account will show how much sales tax was collected and paid out.  Also, my COGS amount isn’t showing because I enter that on the last day of the month.  The P&L shown above is really for example purposes only on how to get your Amazon figures into QuickBooks and it’s not complete for the full month of January.

Split Months
In the example that I used above, the pay period of Jan 7 – Jan 21 is all in the same month.  This is the easiest case but you also have pay periods that are split between two months.  If you’re using the accrual accounting method, you’ll follow the same process but divide your entries between months.

So, for the payment period of Jan 21 – Feb 4, I would divide the sales and fees between:

  • Jan 21 – Jan 31
  • Feb 1 – Feb 4

When I do my entries, I’ll enter the January numbers on January 31 and the February numbers on Feb 4th.

I hope this post helps you with getting your Amazon number into QuickBooks.  If you have any questions, please ask in the comments below or on my Facebook page.


*** 1/27/17 Update: Jim Cockrum & Team came out with a new course that has Amazon Specific Training with Quickbooks Online.  I have not taken the course, but have taken several of Jim’s other courses.  Here’s the link: Proven Accounting Training.

Photo Credits:
Featured Image of Work and Wealth Money Tree: © freshidea –
All Pictures/Screenshots in this post: Diana Poisson

{ 51 comments… add one }
  • Jeff January 6, 2016, 4:51 pm

    Great article! It all makes perfect sense to me how you explained it except for the part where you divide your entries between months. If a 2 week period is over a month end boundary, how do you know what your numbers are for each month?

    • Diana January 6, 2016, 5:20 pm

      Hi Jeff,
      When that happens, I pull my Payment->Summary and Payment->Transactions reports as normal. Then I get an Excel Spreadsheet and make 3 columns: One for last month, one for this month and the total of the two.

      For example, my current payout runs from Dec 23 to Jan 6. So, I’ll do the numbers for Dec 23 to Dec 31 and then from Jan 1 to Jan 6. I get those numbers from from the Payment -> Transaction report. Then I add the two columns together and the numbers should equal the totals on the Payment->Summary report.

      It’s a bit of a hassle, but that’s how I do it. I know that InventoryLab has sales reports but unfortunately, they don’t allow you to select a custom date range.


  • Jeff January 7, 2016, 12:55 am

    Thanks for the response. That makes sense. The problem I have when I do that is that it doesn’t show all of my data because there are too many transactions. The report says, “Transactions: 600 This report has been truncated because it exceeds the maximum limit of 600 transactions. For larger reports, use the Payments reports on the All Statements or Date Range Reports tabs.”

    And then when I run a Date Range Report like it suggests and I can’t get it to reconcile with the Payments>Summary amounts. I think part of the problem might be not using the exact same dates. You’ll notice that the Payments>Summary reports have a 2-week time period, but they use the same date to end the last period and start the next period. For example, my reports show 11/25/15 – 12/09/15, and then the next report shows 12/09/15-12/23/15. So…do 12/09/15 transactions show up on both reports? Any ideas?

    • Diana January 7, 2016, 1:28 am

      Even though both reports show 12/09 transactions, there won’t be duplicate transactions between the two. So you can go to the Payments Transactions Report for 11/25 to 12/09 and find the 12/09 transactions that match that report. Then go to the 12/09/15 to 12/23/15 report and find the 12/09 transactions that match that report. Then when you run the Summary Report for 12/09 to 12/23, subtract out the 12/09 numbers that aren’t included in that report.

      You can also copy the 12/09 rows from your Amazon reports from Seller Central and paste them to Excel. Be sure to use “Destination Formatting” and then have Excel do the calculations.

      That’s great that you have 600+ transactions as it means your selling. My volume is much lower so I’ve always had everything in the same report and have not run into the challenges that you’re having. However, since my volume went up over Q4, I’m finding that it does take longer to get the accounting done and my current method isn’t going to work with numerous transactions. Unfortunately, Amazon doesn’t make it easy and I don’t have a simple solution.

      If you’re on FB, there’s an accounting group on there for Amazon FBA Sellers and someone from there may have a better answer. I just joined it a few weeks ago and it’s at

      Most of the instruction is for Sellers using QB Online. Let me know if you have any more questions!


  • tif February 4, 2016, 5:12 pm

    how do you calculate the cost of good sold hoe do know which and how from each product you sell through fba

  • tif February 5, 2016, 5:10 pm

    i see your excel sheet but i need one to to show me how much sold from each product that will show me each transaction separate

    • Diana February 7, 2016, 4:13 am

      To my knowledge, there isn’t an Excel spreadsheet that will pull your Amazon sales transactions for a specific product. Usually with Excel, you have to enter the information manually, download an Amazon report and copy the data to Excel or copy and paste the data like I explained in my COGS post. I guess you can copy and paste all of your data and then sort the worksheet by Product Name so each product will be grouped together and you can see the sales transactions for that product.

      Depending how far back you need to go, this may be time-consuming. I would also contact InventoryLab and see how far back they go in pulling the Amazon Data from when you first start IL. With IL, you can go into your “FBA Sales” and search by product title and get a list of all of the sales transactions for that listing. Plus it’ll have your COG amount (as long as you entered it).


  • Mike July 12, 2016, 3:02 am

    I’m currently using Go Daddy but I’m seeking an alternative because Go Daddy is a bit too simple and doesn’t provide me with enough reports (Balance sheet etc). But this seems like soooo much more work compared to Go Daddy..with Go Daddy all I have to do is categorize every expense and add my mileage..sigh

    • Diana July 13, 2016, 2:21 am

      Hi Mike,
      It does take time to learn how to use QB, but once you’ve done it a few times, then it’s pretty easy. It’s the same process repeated over and over, just with different numbers.

      One thing you might consider is taking Anna Hill’s Quickbook class. She runs the Accounting We Will Go Facebook group. I haven’t taken the class, but it looks like it covers a lot.

      No matter which system you use, there is a learning curve. And to be honest, I’m sure there are better ways to add the Amazon Data to QB than how I’m doing it. I had to pretty much figure it out on my own.

      Good luck and let me know what you decide to do!


  • MJ December 12, 2016, 7:39 pm

    Great article! How do you deal with “reserve” amount, when Amazon holds back funds in the current period and pays out in the next?

    • Diana December 12, 2016, 9:34 pm

      Hi MJ,
      Good question! I’ve never had to deal with “reserve” amounts, but I would think it would be almost the same process. Unfortunately, I think I would confuse you and me if I tried explaining how I would do it.

      I recommend joining the Facebook Group Accounting We Would Go. I’m not affiliated with them, but it’s run by an accountant that’s also an FBA Seller. She is very good at answering questions and she knows QuickBooks.

  • Ana January 9, 2017, 12:19 am

    Hi Diana,

    Great post. I think this is the most useful amazon accounting related post I’ve found.

    I have a question for you though. I know it sounds like a silly one, but what classification do you use for both your “Amazon FBA” and “FBA Sales” Accounts? I guess that “FBA sales” is your Revenue (Income) Account , but then how do you classify “Amazon FBA”, which I guess is the account of your Amazon disbursement?

    Thank you in advance,

    • Diana January 9, 2017, 4:40 am

      hi Ana,
      I have the “Amazon FBA Sales” account classified as income.

      I have the “Amazon FBA” account classified as an “Other Current Liability” account.

      It probably make more sense to make it an “Other Current Asset” account since usually Amazon is the one owing me money after every sale. But either should work as it’s just a temporary holding spot because once you get your disbursement, the account balance goes back down to zero.

      I’m sure there’s probably a better method to input the Amazon FBA numbers, but this is how I do it and it works for me. You might also check out the Accounting We Will Go Facebook group because the leader Anna Hill knows a lot more than I do. I’m not affiliated with the group, but have learned a lot from it.

      Anyway, I’m glad you found this post helpful and let me know if you have any other questions!


  • Giovanni January 17, 2017, 4:57 am

    Hi Diana! I just discovered your blog today and I feel like I learnt a week’s worth of QB/FBA heavy-duty number crunching already. Thank you for all the work! I have a couple questions: When setting up the Amazon FBA Liabilities Register, are both Amazon’s Fees (what they charge us) and the Sales, tax and reimbursements (money for us) all under the same Amazon FBA Current Liabilities register?

    And… this might be a bit embarrassing to admit, but during the first couple cycles the Amazon fees were higher than my actual income, so they billed my credit card. How do I pair that charge to the Liabilities Register?

    Thank you!

    • Diana January 17, 2017, 1:58 pm

      Hi Giovanni,
      I have separate liability accounts for most things:

      Amazon FBA Liability account for what Amazon owes me (sales) and what I owe them (FBA fees). They cancel themselves out every pay period.

      Liability accounts for every credit card. It’s better to keep each credit card account separate so you can easily track the balance on each one.

      Sales Tax Payable account for the sales collected that I need to remit to the state. I do not have separate liability accounts for each state though.

      Hope that helps!


      • Giovanni January 17, 2017, 3:48 pm

        Hi, it does help a lot. Thank you Diana!

  • Giovanni January 17, 2017, 7:10 am

    whoops! I just realized you answered a similar question a few days ago right before my comment.

  • Sophia January 27, 2017, 10:14 am

    Can you give me a breakdown of how you found, because they don’t match with the amazon fees on your statement view, and I am getting confused with how to find my numbers. Thanks

    • Sophia January 27, 2017, 10:15 am

      oops, didn’t finish the first sentence, Can you give me a breakdown of how you found your amazon fees?

      • Diana January 27, 2017, 2:20 pm

        Hi Sophia,
        I just go into Seller Central -> Payments -> Transaction View. Then choose the pay period or date range you’re interested in. Then you can filter by all transactions, service fees, etc. Then you either have to manually add them up (since Amazon doesn’t) or copy/paste them into Excel and let Excel add them up.

        If you’re using QuickBooks Online, a new course came out to help with it. I have not tried the course, but it’s from Jim Cockrum & Team and I’ve been though several of their other courses. It’s called Proven Accounting Training (aff).

        Good luck and let me know if you have any other questions!

  • James Schwartz February 2, 2017, 5:02 pm

    Also, check out for an automatic solution to importing amazon transactions to quickbooks!

    • Diana February 2, 2017, 7:24 pm

      Hi James,

      I’ll check it out!


  • Devon February 24, 2017, 10:41 pm

    Hey so looking over this and trying to apply this to my Amazon FBA accounting. I’m in the liability register for Amazon FBA and I am creating a Journal Entry. I don’t understand how to fill out the fields though in my QuickBooks as it’s different than yours. Payee, Account, Memo, Increase, Decrease are my fields. Lets use just my FBA fees as the example entry I want to add.

    I’m in Amazon FBA liability register and I’ve created a journal entry. Do I create a new customer or vendor as “Amazon” in the payee? For Accounts, would I create a new account as a Liability that is “FBA Fees”? Then add it in Decrease as it’s a fee that I owe? Sorry if this is confusing. I’ve read this post and your balance sheet post and I understand but it doesn’t seem as straightforward as your setup is.

    • Diana February 25, 2017, 12:39 am

      Hi Devon,
      In my Quickbooks, I have Amazon set as a customer. I’m not 100% sure if that’s correct, but that’s how I’ve been doing it for the last 3 years without any problems.

      For your Amazon FBA Fees, you want to create a new expense and not a liability account. I have mine set as “other misc detail costs” and again, I’m not sure if that’s the correct expense type.

      But you do need to make your fees as an expense. You can make it as detailed or general that you want. I know that some people lump all of their FBA fees into one expense account called “FBA Fees.” I like to break mine down into storage fees, inbound shipping, selling fees, etc. so I know how much I spent on each specific type of fee. Then I enter the Fees as an “increase.”

      A good way to know if your “increases” or “decreases” are correct is to run a Profit and Loss statement after you make the entry. The fees should be subtracted from your sales income in the P&L Report. If they’re not, then you have it backwards.


  • Val March 24, 2017, 3:02 pm

    Great post Diana. I have been looking for away to learn how to book my FBA fees actually. I am having a hard time understanding how you don’t duplicate income after you post the entry since Amazon already deposited the money on your bank account?

    • Diana March 24, 2017, 7:20 pm

      Hi Val,
      If you do your Amazon entries in an “Amazon FBA” Liability account like I do, then you just reverse the deposit amount out. Here’s what I do:

      1. Add FBA entries into the Amazon FBA Liability account at the end of your disbursement period.
      2. Then record your Amazon FBA Deposit that goes into your checking account as “FBA Sales” or something like that.
      3. Then go back to your Amazon FBA Liability account and reverse out the deposit amount. So you would CREDIT Amazon FBA Liability Account and DEBIT the FBA Sales income account.
      4. If done correctly, your Amazon FBA Liability account will go to a zero balance.

      I don’t know if this is the best way to do the entries, but it works.

      Hope this helps, if not, let me know.


      • Val March 24, 2017, 8:49 pm

        I see.. So is your ” FBA Sales income account” your checking out where Amazon deposit the funds? Because I am having a hard time take Amazon Fees in consideration..

        • Diana March 24, 2017, 10:56 pm

          It is kind of confusing.

          So, when I get a deposit, it goes into my checking account and I categorize it as FBA Sales Income. Then I’m done with the checking account.

          Its in the Amazon FBA Liability account that I enter my sales and all Amazon Fees. And because the Sales is entered twice (once in the bank deposit & once in the Liability Account), I reverse out the deposit amount from the Liability account.

          Also I have a spreadsheet to calculate my fees. I’ll see if I can clean it up and make it available and hopefully that’ll help.


          • Val March 27, 2017, 5:23 pm

            So is that mean your “Amazon FBA Liability ” always at zero by the end of the month?

          • Diana March 27, 2017, 6:13 pm

            No, not at the end of the month. At the end of each deposit payout.

            The Amazon FBA Liability account is just a temporary holding spot for you to enter your Amazon income and fees. If you do those entries in your checking account, then it will mess up your checking account balance.

            So, here’s what I do:
            My payment cycle ends every 2nd Wednesday. So on the Thursday after my cycle, I enter my Amazon Income and Fees in the liability account.

            Then on the following Monday, the deposit hits my checking account and this is when you see the sales income twice.

            So then I go to the liablitiy account and reverse out the deposit amount. At this point, it goes to zero.

  • Val March 28, 2017, 2:52 am

    Thank you Diana for your help.. One last question, what will be the JE for the reversal then?

    • Diana March 28, 2017, 3:08 am

      You do the JE in the Amazon FBA Liability Account.

      Then Debit FBA Sales Income by your deposit amount:

      Example: Your deposit amount is $1000:

      Credit Amazon FBA Liability Account by $1000.00.
      Debit: FBA Sales by $1000.

      If done correctly, your liability account should be 0.00.

      If it’s $2000.00, then you did it backwards.

      • Val March 28, 2017, 5:01 pm

        Oh I see.. That’s why I was a little bit confuse because I don’t have an account call “FBA Sales Income “. I only register the income once I receive payment from Amazon.

        • Diana March 28, 2017, 8:32 pm

          When you receive a deposit into your checking account from Amazon, you record it as Income or FBA Income or whatever. The name really doesn’t matter.

          But then you use the same “Income” name as your reversal journal entry account.

          Hope that makes sense.

          • Val March 30, 2017, 1:59 pm

            It makes perfect sense..

            Thanks for your help dear..

            I really appreciate it…

  • Meir April 16, 2017, 11:00 pm

    Hi Diana,

    I just started to work with the amazon FBA and I find your article GREAT!

    I have a question regarding the inventory change and the COGS.
    What would be the best way to subtract the goods sold in this period of time from the inventory?
    is there a way to connect the inventory change to the journal entry?

    Thank you


    • Diana April 17, 2017, 2:38 am

      Hello –

      COGS tracking is a pain because Amazon doesn’t allow us to input the Buy Costs into Seller Central. Therefore, you need to calculate your COGS in a separate program. When you’re starting out, you can use Excel but as your volume increases, I do recommend either purchasing Caleb Roth’s Tracking Spreadsheet or subscribing to InventoryLab. I have links to both on my Amazon FBA Resources Page.

      Once you have your monthly COGS number, then it’s just a quick journal entry. I go into my Inventory Asset account and create a journal entry:

      Credit Inventory Asset Account by COGS amount.
      Debit COGS Expense Account by COGS amount.

      Also, if you are using Excel to calculate your COGS manually, I recommend that you code your Merchant SKUS so that the price is part of the number. Mine are formatted like this: SH-040116-STP-1599. You can do it how you want, but my SKU number means that it’s a shoe, purchased on 04/01/16 from Sierra Trading Post and the cost was $15.99. This will save you time from having to manually look up the buy costs for your sold items.

      Hope this helps and let me know if you have any other questions!


      • Frank July 7, 2017, 2:03 am

        This is all super helpful.

        Per the cogs do you do a single monthly amount rather than one per Amazon deposit for a reason? Also do you do one per item or item type or do you do one amalgamated cogs cost JE? I have many items selling at different quantities and costs so grouped sounds great BUT if I have the data in excel anyways (I do in a pivot) to get the total… maybe worth multiple entries In QB for some gain? No?

        • Diana July 9, 2017, 1:37 pm

          Hi Frank,

          Sorry for the delay in getting back to you. I don’t always receive notifications that someone commented! Something I need to check into.

          For my Quickbooks entry, I just do one monthly COGS Journal Entry because I don’t really need to see everything broken down in Quickbooks. I use QB to view my business as a whole and am not concerned about viewing COGS separated by group.

          With that said, I do view my COGS in more detail in the InventoryLab reports and every 2 weeks when I do my Profit First Calculations.

          Let me know if you have any more questions!


          • Frank July 10, 2017, 12:18 pm

            Thanks for your confirmation. I do also have the data elsewhere in pivot tables so I suppose I don’t need it all in QB either. I was going back and forth whether to use QB for inventory tracking as well. I’m guessing you have a single inventory asset in QB and don’t keep track of each item there?

            If you had multiple revenue sources would you see a value in one COGS monthly recon per revenue partner or still just one lump thru a single JE end of month catching everything?

          • Diana July 13, 2017, 5:01 pm

            Hi Frank,
            I apologize for being late on answering this. WordPress used to email me comment notifications and then they stopped.

            For Inventory, I have one Inventory Asset Account. So, every time that I buy new inventory, I add that Buy Cost to the Inventory Account. Then once a month, I move the COGS number from Inventory to my COGS Expense account.

            I do not track every individual inventory in QB as that’ll be too time consuming. You can track inventory on a per-item basis in spreadsheets, InventoryLab and even check in Seller Central.

            I do have multiple revenue sources – Amazon, Blog, Merch, etc. I track each of those separately. It’s still one Quickbooks file, but I have FBA Income, Merch Income, Affiliate Income, etc. I also separate the expenses the same way too.

            For Revenue Vendors – where I purchase my products from, I don’t track the COGS amounts separately. Again, that’ll be too much work. I can run a Vendors report to see where I purchase the most products from and also get Vendors reports in Caleb’s spreadsheets and InventoryLab.

            For me, I use QuickBooks to get the company info as a “whole,” and to track individual vendors or inventory items.


  • Frank July 10, 2017, 11:30 pm

    Also, you had zero for refunds and as such zero credits in refunds for refunded fees 🙂 confusing on mine for sure . Do I want refunds to reduce the product sales? Probably not? So a separate “account” for refunds I guess ? But for the fees that are credited back because of the refunds I suppose I could group them with the new fees thus lowering them.

    • Diana July 13, 2017, 5:10 pm

      You’re right, I don’t have refunds numbers entered. Can’t remember why….

      However, for refunds, there are different ways to do it:
      1. Customer returned item and you will sell it again: In this case, you move the “buy cost” of the product from your COGS Expense Account back into Your Inventory Asset Account.
      2. Customer returned item but it’s damaged so you can’t sell it again – I’m not exactly sure, but you can move the “Buy Cost” from your COGS Expense Account to a Donated or Damaged Goods Category.

      I typically adjust the Buy Costs for inventory that is returned but in sellable condition once a month.
      For the damaged/donated, I just keep a list of them in the spreadsheet and do one journal entry on Dec 31. But you can do it monthly too.

      Hope that helps!

  • Frank July 14, 2017, 12:04 am

    Thank you for all your answers and help!!

    • Diana July 14, 2017, 3:23 pm

      Your welcome! Let me know if you have any more questions. 🙂

  • Drew December 18, 2017, 2:18 am

    Hi, Diana.
    Beautiful blog. You’re really helping me grasp all this mentally taxing accounting jargon and processes. There’s just one thing I’m experiencing when following along, making my first journal entries. In your examples your pay period starts and ends nothing in and all out. I almost always have a carryover balance and not all my sales are dispersed for the two week standard period. I’m unsure about how to log when I have all my correct fees and sales info but my payments are always going to be in a partial quantity of my total balance. It feels like my books could never be balanced at that rate. Do you have any advice?

    GREATLY appreciated,

    • Diana December 18, 2017, 5:32 am

      Hi Drew,

      You wrote – “but my payments are always going to be in a partial quantity of my total balance.”

      For “total balance”, are you talking about your unsold inventory? If so, then that should be listed as an asset in your bookkeeping. So whenever you purchase new inventory, you put that in an “inventory asset” account. Once your inventory sells, the cost of the inventory is moved out of the asset account and then classified as a Cost of Goods Sold (COGS) expense.

      Or for “total balance” are you talking about Amazon holding some of your funds? That has never happened to me but I heard that they started doing that for newer Sellers. If that’s what you’re referring to, the method that I use should still work. In the Amazon Liability file, it should show how much Amazons still owes you. Then that amount will get cleared out once they pay you during your next cycle.

      Hope that helps! If not, let me know and I’ll try and help more.


  • Drew December 18, 2017, 10:42 pm

    Hi Diana,
    Thank you so much for the speedy response. Your dedication to helping others is so admirable. We’ve been running our FBA business for 20 weeks and set payments weekly, so it was pretty daunting when it came time to get serious with bookkeeping. I followed your system regardless of my confusion and sure enough, I started to notice the trend lol. One more question, about reversing journal entries, I’m pretty sure my debits and credits in liability are correct. But, when I record payments I’m debiting my bank and crediting fba liability. I’m doing this manually since we only recently started using QBO. I set up an old bank and new bank and have QBO linked to the new bank. So when accounting for the payments it is leaving me with my total revenue but as a negative. If this is right, how to I reverse it and make it show a positive balance?

    Again thanks so much!

    • Diana December 19, 2017, 12:08 am

      Hi Drew,

      I’m not near my regular computer with QB installed on it, so I can’t tell you right now if my entries are debits or credits. They always confuse me. So, here’s what I do:

      I get paid every two weeks. If you get paid weekly, the same system will apply.

      Then for my two-week payout, I enter the Sale Income and Fees in the Amazon Liability Account. When I’m done, the account should match the payment amount that Amazon owes me and will be deposted into my bank account.

      Then a few days later, the bank receives the deposit. I enter this in my checking account as a deposit and categorize it as FBA Sales Income.

      If you run the P&L report now, you’ll have FBA Sales Income twice. So then I go back into my Amazon Liability Account and enter the payment amount as FBA Sales Income. But it’ll go in the other column so it reduces the FBA Sales Income by that amount.

      Then just run another P&L and then your Sales income should only be showing once.

      Hope that helps, if not, let me know.

      Also, I recommend Anna Hill’s “Accounting We Can Go” Facebook Group. She is an accountant that also sells on Amazon. She offers Quickbook training. I never took her training, so can’t comment on it, but it’s something to look into. Even if you don’t want to take the QB training, you can ask questions in the FB group. She is very nice and answers everything.

      Otherwise, I’m always here to answer questions!



Leave a Comment

Next Post:

Previous Post:

About Diana

I am working towards creating a full-time income by selling on Amazon. It's a lot of work but very fun! If you're interested in selling on Amazon, be sure to follow my blog as I'll be providing you with lots of tips!

Free Amazon FBA Files!

Amazon FBA Supplies

Find the Topic That You’re Looking For!