Let's get started.
Monthly Sales Income Tracker
Configure the Settings sheet
Select the ‘Settings’ sheet and enter the following information:
- Dashboard title: Enter the title of your choice and it will automatically appear on the Overview dashboard.
- Year: Enter the year you're currently tracking. This is normally the current year.
Start logging Income & Sales
The Tracking sheet is used to log the total income & sales generated for each month. It's also used to log the grand total income & sales amounts for previous years.
- This year: Enter the income amount for each month, along with how many sales were made.
- Previous years: Enter the income amount for each year, along with how many sales were made.