Amazon FBA & MF Sales Monthly & Expenses Profit Google Sheets Excel Spreadsheet Report
With this spreadsheet, you can track everything you need to be ready to file your taxes.
↘ Purchases Sheet - Enter your purchased items to know exactly when and where you bought your items and how much you paid. You can use your total purchases to calculate the cost of goods sold on your taxes.
↘ Inventory Sheet - Keep track of your current inventory levels so you know exactly how much of an item you have left. Record the item’s location so you precisely know where your items are stored. See your item’s cost, sales price, and amount to be charged to the customer.
↘ Sales Sheet -One Sheet for FBA orders and one Sheet for MF orders. Automatically calculates Referral Fees and manually enter in FBA fees when an item sells. Quantities from Sales Sheet updates to the Inventory Sheet.
↘ Expense Purchases Sheet - This sheet allows you to record all your expenses and label them with customizable categories.
↘ Expense Report Sheet - Easily see where you are spending the most money each month. Be ready at tax time to record all your deductible expenses. Comes with charts.
↘ Mileage Sheet - Record your mileage from sourcing and post office trips so you can deduct the miles on your tax return.
↘ Monthly Profit & Loss Sheet - See how your business has been doing from month to month with this easy-to-comprehend profit and loss statement. Visually see your sales and costs for each month with graphs. Compare your MF and FBA sales.
↘ Year-to-Date Totals Sheet - This sheet combines all the other sheets into a condensed spreadsheet with charts to easily see where your business stands.
Get access to a Google Sheets Spreadsheet to assist you organize your Amazon Business and make accounting a breeze. Also A google Doc to help you navigate throughout the spreadsheet