Website Grand Opening: 20% off purchases of 20% or more!
If you are a small business needing a quick, simple solution to track you’re income and expenses, then this automated profit and loss excel template is perfect for you.
To see a YouTube walkthrough of this template please go to https://youtu.be/qzNjc4F_cXQ , please note this video may show some features not included in this listing.
Features of this income statement template include:
- Automated Profit and Loss and Register: Enter transactions into an easy to use register (similar to a checkbook) and the profit and loss template automatically calculates your total income and expenses. The register includes drop downs to make entering transactions easier.
- Fully customizable: Easily add, remove, or rename any income or expense name on the setup page.
- Customize your fiscal year. Easily change your fiscal year end on the setup page.
- Detailed Monthly Income Statement: See every month’s profit and loss report side-by-side with an automated monthly income statement.
- Interactive Summary “Dashboard” Report: The summary dashboard report shows income and expenses over the last twelve months and includes easy to use charts. It also includes an interactive income and expense section that allows you to select any specific income or expense account to see its trends over the past 12 months.
- Budgeting: Includes an area to enter your income and expense budget by month and then automatically compare to actual results.
- Revenue Channel Tracker: Allows you to track your income and expense specific to the sales channels you’re using (Etsy, Amazon, eBay, Shopify, etc.). This helps you to see which platforms are the most successful and profitable for you.
- Paycheck Tracker: This report allows you to input paycheck information to show income, taxes withheld, and deductions by employee, and then totals it for the current month and year-to-date.
- Customer Payor Tracker: This feature allows you to automatically total all payments received by customers and paid to vendors solely based off of the entries you enter into the register. The tracker totals by current month, current year-to-date, and prior year-to-date.
As with any of my templates, if you have any small modifications need or questions, please always feel free to message me on Etsy.
Thanks for viewing my listing! Andrew