2020 Ebay Spreadsheet, Sales and Expenses Tracker for 12 Months and overall Year

Description

Overview:
Keep track of your monthly Sales and Expenses on Ebay with this useful Spreadsheet Workbook! This Spreadsheet Workbook enables users to include detailed information about their sales, fees that they have incurred, along with with their own purchases in order to calculate their overall net profit.
This worksheet contains thirteen Spreadsheets which include:
Twelve Spreadsheets
for each month (January through December)
A Spreadsheet that calculates cumulative amounts earned for each month, totals amounts for the entire year, and contains two graphs that exhibit the amount Gross Sales and Expenses for each month. This Spreadsheet is entitled “
Yearly Sales and Expenses
”.
Cumulative Amounts for Each Month include:
Each month’s Gross Sales Amount
Each month’s Cumulative Expense Amount
Each month’s Net Profit
Each month’s Number of Items Sold
Totals for the Year (Total Amounts for the
YEAR
)
Gross Sales
Expense Amount
Net Profit
Items Sold
Visual Representations of Data (Graphs)
Amount of Gross Sales by Month- Bar Graph
Expense Amount per month- Line Graph (Months represented by Numerical Values; i.e: January = 1, December = 12)
The Twelve Spreadsheets contain the following:
The User is able to input the following information in each of the Month Sales and Expenses Spreadsheets:
Sales Section (Main)
Date (of the Sale)
Invoice Number (if applicable)
Buyer’s Name
Buyer’s Ebay Account Name
Product Type (Drop Down menu- Choose from the Options)
Description (Name of Item being Sold)
Price per Unit
Quantity
Cost of Goods Sold (The Amount it Cost for the Seller to Obtain the Goods being sold)
Discount (Granted to the consumer in the sale)
Shipping Expense
PayPal Fee
Ebay Fee
External Expenses (Expenses you have incurred during the given month that do not have do do with any purchase, i.e. Bills, Payment to Employees, ect…)
Date (Expense was Incurred)
Description (Of Expense, i.e. Bill, Payment to Employees, ect…)
Amount Due
Paid? (Meaning did you pay for the item in full) (Question: Drop down and answer either “Yes” or “No”)
Date Paid
Amount Paid (Amount Paid thus far- Partial Payments or Full payments)
Method of Payment (i.e. Cash, Credit Card, Debit Card, ect…)
Each of the Month Sales and Expenses Spreadsheets will be able to calculate the following information:
Sales Section (Main)
Gross Profit
Net Profit
ENTIRE Sales and Expenses Summary (Calculates totals for the entire
MONTH
given)
Total Number of Items Sold
Month Gross Sales Amount
Total Cost of Goods Sold Amount
Total Discount Amount
Total shipping Expense
Total of PayPal Fees
Total of Ebay Fees
Other Expenses (Total Expenses from the External Expenses Section)
Month Expense Total
ENTIRE Gross Sales Amount for this Month
ENTIRE Cumulative Expense Amount for this Month
ENTIRE Net Profit Amount for the Month
System Requirements:
Works in either Microsoft Excel or Google Spreadsheets. This program will work best if you use
Microsoft Excel (Office).
Works on any Windows and/or Mac Operating System.
Customer Service:
If you have any questions or need any help whatsoever with navigating the Spreadsheet please feel free to contact us via the ebay “Contact Seller” link.
We will be more than happy to help you! Our goal is for our clients have products that meet their expectations and provide great customer service to enhance their overall experience.
Payment and Return Policy:
Payment:
As of now we mostly accept PayPal. Once you have bought the item via Ebay, we will send you the PayPal account link. If you are not able to do PayPal, we will accept any other form of direct deposit.
Return Policy:
Given that our product is digital and cannot, thus, be properly returned, we do not issue a full refund, but can instead issue a PARTIAL refund. HOWEVER, if you are having trouble with the product at any time, you can always contact us and
WE WILL ATTEMPT FIX THE PROBLEM FOR FREE.
Through this policy, we are able to better create an outcome that is both fair and beneficial to you, the consumer, and us.
Shipping Information:
This workbook will be dispatched via a downloadable link that you will receive
24 HOURS AFTER PAYMENT, IF NOT SOONER.
If requested, we can send you a copy via CD, HOWEVER, to receive a copy you will need to PAY ANY SHIPPING FEES ASSOCIATED WITH THE DELIVERY.