Sale Off
Small Business Bookkeeping Template | Profit and Loss Excel Spreadsheet | Income and Expense Tracker | Sales Tracker and Bank Rec Tool

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.

- 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.

- Bank Reconciliation Tool: This tool is one of my favorites. With this you can enter transactions into the register and track outstanding checks on your checking or savings account and reconcile each month with your bank statement. Pre-built for up to 3 checking or savings accounts.

- 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

Other Products