The Simple Monthly Bookkeeping for Amazon Sellers features

• Record Amazon Monthly Totals for Sales and Fees
• Track Cost of Goods Sold and Sales Tax Payable
• Calculate 1099K Monthly to Know if You’ll Receive One
• Profit and Loss Sheet Setup to Make Input Super Quick
• Spend Five to Ten Minutes Per Month on Bookkeeping
• Discount Offered for Online Course if Needed – Learn More Below

The Simple Monthly Bookkeeping for Amazon Sellers is a workbook for recording your monthly sales totals and fees, plus the Cost of Goods Sold and tracking Sales Tax Payable. 

The Profit and Loss spreadsheet in the workbook is actually so powerful it will reconcile your 1099K when completed. That’s a big deal.

You’ll need to pull the Date Range Summary Report in PDF to complete the monthly input on the Profit and Loss spreadsheet. Instructions for accessing the Date Range Summary Report in PDF are shown on the Profit and Loss tab and each monthly tab. 

I’ve put notes in many of the cells with instructions on what goes into the monthly cells.  These notes will pop up as you scroll over a cell with a note.  They are also identified by a small red triangle in the upper right corner of the affected cell.

Sample input with a report to follow in this package. 

To calculate your Cost of Goods Sold you will need your Beginning Inventory, your Ending Inventory, and your total purchases for each month.  If you are using an inventory management system, such as Inventory Lab, you can run a report to obtain the monthly COGS.

If you feel you need more help using the spreadsheet and/or finding your Beginning and Ending Inventory figures from Amazon, I have a course that utilizes this sheet.  It teaches how to pull your inventory and calculate it using Pivot Tables.  I’m offering a coupon code for the price of this spreadsheet. That’s $37 off the course!  The coupon code can be found on the Read First tab of the workbook. The course I am referring to is Catch Up Accounting for Amazon Sellers. 

The Profit and Loss spreadsheet is protected for the most part. 

I’ve tried to add protection only as needed to prevent accidental damage to the spreadsheet and to protect my proprietary calculations used in the 1099K portion.  This is not an easy calculation, and many CPAs would love to have it.  I sell reconciliation services using the spreadsheet, so I need to protect its integrity. You agree with this purchase not to share it or the formulas outside your business organization. 

I do not give the password out for personal updates.

CONTENTS

Excel files with .xlsx extension named Simple Monthly Bookkeeping for Amazon Sellers SMF.xlsx.  Save a copy in a folder on your computer.  Then make a copy to use for the current year.  Next year, you can make another copy from the original.

REQUIREMENTS

You will need Microsoft Office Excel installed on your computer, as well as a basic understanding of how the program works. OR Save to Google Drive and open in Google Sheets.  Some of the functions will need tweaking in Google Sheets, so use that option only if you have experience with the app. I do not offer support with Google Sheets.  I’m not familiar enough with it.  The template was created in Office 365, which has a .xlsx extension.

© SMART RESELLER SPREADSHEETS – All template designs and formulas are for personal use only and may not be resold, copied, or redistributed under any circumstances.

A little about Vicki

With more than 30 years of experience in accounting and 5 years in Amazon FBA, it is my desire to share with other sellers how to keep accurate records in the easiest way possible.  

When I’m not working on my business, I am homeschooling my high school son.  You think Amazon accounting is a challenge!  Just kidding.  My husband and I are blessed to be raising such a wonderful young man. Y’all can still pray for us, though.  🙂