eProfit Manager

eProfitManager is an Excel spreadsheet that will help you to track your online sales and MUCH more, including:

• Record Business Expenses
• Track Inventory
• Input Balance Sheet Items (Assets & Liabilities)
• Estimate Profit for New Products
• Help You Create Better Auction Titles (Title Tool)

Detailed Product Description

Dashboard

The Dashboard provides a single location that summarizes the financial information in eProfitManager. Cell A6 contains a drop down menu that will allow you to select different years, by default it is set to ‘All Years’. Use the drop down menu to select 2010 and the financial summaries below will update automatically. Please note that the larger charts, on the Sales Report worksheet, will change as well. Cell A6 on the Dashboard controls the charts on the Sales Report worksheet.

Sales Reports

The Sales Report worksheet has several charts, including: Revenue by Month, Expenses by Month, Gross Profit by Month, and Gross Margin by Month. It also includes data table for each chart that give the exact amounts that are displayed in the charts. The chart can show All Years or a only one specific year. To change to a different time period, go to the Dashboard and change cell A6.

Input – Sales Data

The Input – Sales Data worksheet records all sales transactions. You input the details, such as: date of sale, transaction number, sale price, shipping price, and expenses. Then, the spreadsheet will calculate the Total Revenue, Total Expense, Gross Profit, and Gross Margin (%). There is a field for Sale Location, which can be used to distinguish sales from different venues, like EBay.com, or Amazon.com, or Half.com. In addition, you can re-name the revenue and expense headers to suit your needs. After many transaction have been entered, it is easy to use Excel’s built-in filters to calculate different totals. For example, you could filter on all sales that happened on Esty.com in the current year; then, easily change the filter to show last year.

Input – Business Expenses

The Input – Business Expenses worksheet is the place to record expenses that are not directly related to a sale. For example, if you manufacture products to be sold, then the tool that you buy would be recorded here. Also, if you spend money on flyers, or Google Adwords, or office supplies, then recorded them here.

Input – Customer Information

Use the Input – Customer Info Report worksheet to keep track of customers. There is a column named ‘Group’, which can be used to separate customers based on what they purchased (Group Examples: Ipod, P90X, Coach Handbags, etc). After you have input multiple customer, use Excel’s built-in filter to bring up the customer from each group. This is useful if you want to send an e-mail to all of your customers that purchase a certain type of product (either for product updates or for marketing).

Input – Inventory

Input – Inventory can be used to track the current inventory on-hand. This should help to avoid out-of-stock situations and it will give a more realistic idea of the assets that you have. The Value on the Inventory worksheet are automatically populated onto the Balance Sheet as assets (auto-update).

Input – Balance Sheet

The Input – Balance Sheet worksheet automatically pulls the total value of everything on the Inventory worksheet. Then, you can input additional assets, such as: machines, tools, computers, etc, that your business owns. There is also a place to input any liabilities, such as loans or other debt. All of the information on this worksheet is pulled onto the Dashboard so that you can get a realistic financial summary of the business.

Profit Tool

The Profit Estimation Tool is a great way to experiment with new product ideas. If you have found a new product that you would like to sell, then begin to research suppliers. Based on that research, input the estimate expenses of the new product. Then, search online for other people that are selling the same product. Determine the average selling price of the product and input that into the Revenue area. The spreadsheet will automatically calculate the Estimated Profit for each sale. Hopefully, the estimated profit is positive and you can move forward with the new product.

Title Tool

Few Ebay seller truly understand the importance of a good title. The Title Tool will allow you to enter different titles, and it ensure that they meet the 55 character limit. Below the input area are links to several articles about writing great titles, including: Get The Title Right, Writing A Good Title And Description, and Tips For Writing Winning Auction Titles on Ebay.