Ebay, Amazon & Etsy Accounting Excel Database (Inventory Pedia)

Description

Inventory & Sales Database
www.inventorypedia.com
Delivery:
Customer will receive an ebay message containing a Download Link (No Hard Copy will be sent)
.
We aim for a fast delivery - usually within
24 hours
Download Link will be sent in an eBay message.
Compatible With Windows OS:
This database was designed using MS Office 2013 on Windows OS so this should work fine on windows computer uisng Microsoft Office 2013, 2016, 2019. The built in macros and forms might not function properly on Mac OS. I am working on making this database compatible with Mac OS. Once it is available then I will update the listing with that variation.
For urgent delivery please drop us a message on ebay.
Otherwise please use the send message facility when ordering to notify us of which email address to send them to, or we will use the email registered to the eBay account. Any questions send us an eBay message.
Best Accounting Software for E commerce Sellers (Intro) - YouTube
Video will open in a new window
[isdntekvideo]
Best Accounting Software for E commerce Sellers (Tutorial) - YouTube
Video will open in a new window
[isdntekvideo]
I am an Amazon FBA Seller, When I started selling on Amazon I was looking for a software which I could use to track my inventory, sales, expenses, refunds and miles driven for the business. I tried to find a cheaper software as I didn’t want to add a lot to my startup cost. After looking at various software’s, I couldn’t find anything less than . At this point, I decided to put my Excel Expertise to work and designed this application. Once the application was completed, I decided to share this application with other eCommerce sellers too as there are a lot of people who are struggling with their Ecommerce Business bookkeeping.
This Database is a spreadsheet but when you start using it, it hardly feels like that you are using a spreadsheet. I have designed this application to make it easier for myself to track my inventory, sales, expenses, refunds and miles driven for the business. Data Entry is done by using forms. Barcode scanner can also be used to enter data.
Dashboard
Dashboard will give you updates on profit, Sales Products Sold, Cost of Goods Sold, Estimated Revenue, and Expenses by using the charts. This page will also keep you updated about you current Inventory in Stock, return on investment, Profit and Loss, Miles you drove your car for your business and the reimbursement amount. This page has filters where you can filter the data displayed on the Dashboard,
Dashboard contains the links to all the sheets like, Inventory, Sales, Expenses, Mileage, Refunds, Product Data, Calculator, Product Report, Database, Settings.
You will also be able to perform the following functions from the Dashboard Page.
Add New Inventory, Add New Sale, Add New Expense, Add New Trip, Search Product, Modify Inventory, Add New Refund, F
BA Calculator and Seller Central are the links to Webpages.
Inventory
Inventory page is displayed as a report. It contains
Cost of Inventory in Stock
and
Cost of Inventory Purchased
. You can filter the data by using Date column in the table. This report is easy to print for annual accounting purposes. Printing Instructions are available on this page. An option to data is also available on this page.
·
Add New Inventory Form
To Add New Inventory, click on *Add New Inventory* Enter UPC Code, Purchase Date and Shipment ID Automatically populates, fill up the reset of the form and click save. Purchase Date can be modified. Fields marked with * are mandatory fields.
·
Modify Inventory Form
To Modify Inventory, click on *Modify Inventory* Enter Merchant SKU, once entered, all the fields will automatically populate. Make and changes needed and click Save. Fields marked with * are mandatory fields.
Sales
Sales page is displayed as a report. It contains
Total Sales
,
Total selling fees
paid and
Total Revenue
Received. These totals are displayed as subtotals. So, if you filter the data by using data column in the table these values will change.
Printing Instructions are available on this page. An option to data is also available on this page.
·
Add New Sale Form
To Add New Sale, click on *Add New Sale* Enter Merchant SKU, once entered all the fields will automatically populate, fill up the reset of the form and click save. Sale Date can be modified. Fields marked with * are mandatory fields.
Expense
Expenses page is displayed as a report. It contains
Total Expenses
. These totals as displayed as subtotals which will change if data is filtered by using data column in the table. Printing Instructions are available on this page. An option to data is also available on this page.
·
Add New Expense Form
To Add New Expense, click on *Add New Sale* Enter Description, once entered Date will automatically populate, fill up the reset of the form and click save. Date can be modified. Fields marked with * are mandatory fields.
Mileage
Mileage page contains Total Miles Driven and amount. The amount reflects
Reimbursement Amount
. You can claim 0.54 Cents \ Per Mile. This table automatically calculates the amount when miles are added.
Reimbursement Amount
can be changed from the settings page. (Reimbursement Per Mile) table. Printing Instructions are available on this page. An option to data is also available on this page.
·
Add New Trip Form
To Add New Trip, click on *Add New Trip* Enter Description, once entered Date will automatically populate, fill up the reset of the form and click save. Date can be modified. Fields marked with * are mandatory fields.
Refund
Refunds report displays
Total Refunds
issued to customers This report is in a table format. Total amount on top of the report is calculated as a subtotal which will change when data is filtered using Date column in the table. Printing Instructions are available on this page.  An option to data is also available on this page.
·
Add New Refund Form
To Add New Refund, click on *Add New Refund* Enter Merchant SKU, once entered all the fields will automatically populate, fill up the reset of the form and click save. Date can be modified. Fields marked with * are mandatory fields.
Profit & Loss Statement
Profit & Loss page is created to be printed as a report at the end of the month or Year. Detailed Instructions on how print the report are on the page. Date From & Date To on top of the page will be used to generate a report between a certain time period. Also New Stores and Expenses can be added to this report. Instructions on how add a store and expense are available on this page.
Printing Instructions are available on this page.
Product Data
Product Data Page is created to display all the SKU’s as Barcodes. This page has barcodes for UPC codes and Merchant SKU. This report can be used to enter sales, Modify Inventory, Add Refunds, Search Product. You will receive two files of fonts with the database which you have to install on your computer. Without installing those fonts the barcode font won't work.
Calculator
Calculator Page can be used to calculate the bundle price, Shipping cost per Unit and Sales Price based on a certain ROI.
Product report
Product report is a report where you can get detailed information on a certain product. This page contains formulas that look up information on a certain product from the database and displays them as a report. You can search data by using Merchant SKU Barcode to lookup data. This file can be used with a Barcode Scanner.
·
Search Product
To Search Product, click on *Search Product* Enter Merchant SKU, once entered click Search, all the fields will automatically populate. Click Clear to search another product and click close to close the from. Fields marked with * are mandatory fields.
Database
Database Page is the backend page where all the data is saved and all the calculations happen. If any change is made on this page that change will reflect on every page of the database.
DO NOT TRY TO MAKE CHANGE ON THIS PAGE.
You can Modify Inventory by using Modify Inventory Form.
Returns\Refunds Not Accepted
1. This item will not be returned under any circumstances as this is Database Application (Soft Copy).
2. If you have any inquiries about this Database you can contact us through Ebay message or watch the Tutorial Videos.
Payment
1. We accept Paypal only. Please kindly check if you can do the payment via PayPal before placing an order.
Contact us
Please feel free to contact us via eBay message, if you have any inquiry regarding the item or our service, We will try to reply any message within 24 working hours.
Please remember the best way to contact us is via "eBay message" from your bidding item that will help us response you promptly. Emails may not be monitored quickly.
Your satisfaction is very important to us, please contact us first before leaving Neutral or Negative feedback as we can always sort out issues to your full satisfaction,thank you!
Thank you for shopping with us. Please let us know what we can do for you!