This script-based Google Sheet includes a form to enter new sales transactions. It also includes a date-based report to view total sales, as well as breakdown by category.
Accurate data entry
Use the embedded form to enter your sales transactions accurately and consistently. You can add your own fields to the form, and they will be automatically added to the Sales tracking tab.
When you click the "Add" button, the transaction will be recorded in the Sales tab, and the form will reset for the next entry.
Centralized sales data
All form submissions are recorded in the sales tab for easy access. You can manually add rows to this tab if you wish.
All reporting is done based on this tab.
Customizable categories
Use the Settings tab to define your report categories. Categories are optional and also flexible: you can have none, or as many as you need. The tab makes it easy to update your categories going forward.
The categories are used to break down sales inside the report.
Date-based reporting
The Report tab sums up the sales transactions. You can filter the report using a From/To date range. The report will display the sum of transactions with a date that falls within the specified date range.
The report provides both a total dollar amount for all sales, as well as a breakdown by category.
BUY THIS PRODUCT
$25
The price is a one-time fee for the purchase of a script-based Google Sheet.
- Spreadsheet-bound Google Apps Script
- Unlimited script use
- Fully customizable
- Free email support for 30 days