Tag Archives: Small Business

Excel Template – 5 Year Balance Sheet

5-year balance sheet forecast. Download this free excel balance sheet template to forecast your anticipated assets, liabilities, and equity over the next five years. These 5-Year balance sheet spreadsheets will help you calculate profit and loss, view your balance sheet and cash flow and more.  Balance Sheet Template Download Excel template Download: Balance Sheet Template File […]

Excel Template – Aging of Accounts Receivable

Use this Accounts Receivable – Aging excel spreadsheet to track invoices and accounts receivable. Download Excel template Download: Accounts Payable – Aging File format: Excel How to update charts Enter values in each of the cells. Right-click on the chart. Refresh the data. Accounts Receivables with Gradients indicators How to change conditional formatting Select the cells […]

Excel Template – Auto Travel Expense Tracker

Looking for a simple-to-use Auto Expense report spreadsheet to track your car mileage? Go no further, grasshopper! Track your auto expenses in this excel template. Auto Travel Expense Tracker with conditional text and chart Auto Travel Expense Tracker with blue and green gradient conditional text and column chart Download Excel template Download: Auto Expense Travel […]

Excel Template – Balance Sheet Forecast

Do you know how to project your balance sheet? Download this excel balance sheet template to forecast your anticipated assets, liabilities, and equity and compare them with historical values. Balance Sheet Forecast with automatic number calculations Download Excel template Download: Balance Sheet Forecast File format: Excel How to use the Excel template Enter values in each […]

Excel Template – Annual Expense Report

Looking for a simple to use Annual Expense report excel spreadsheet to track your annual expenses? Log business trip expenses in this easy-to-modify excel report template with 7 different layouts. Calculate phone, mileage, and other expenses by category. Download Excel template Download: Annual Expense Report File format: Excel How to update charts Enter values in […]

Excel Template – Accounts Payments Aging Report

Use this Accounts Payable (Aging) excel spreadsheet to categorize payables to suppliers based on time buckets. The report is typically set up with 30-day time buckets. Track invoices and accounts receivable with this accounts payment template.   Download Excel template Download: Accounts Payable – Aging File format: Excel How to update charts Enter values in each […]

Excel Template – Employee Expense Report

Use this Excel template to track your employee’s business expenses. Download Excel template Download: Expense Report File format: Excel.xlsx How to use the Excel template Enter values in each of the columns. The financial numbers are calculated automatically. Template Contents For each employee, capture the following: Name Position Social Ins # Department Manager Employee For […]

Excel Template – Blog Writing Schedule

Use this Excel template to coordinate your blog writing tasks. Modify this easy-to-use Excel spreadsheet to keep track of your blog posts, schedules, and the quality of your articles. How to use the Excel template Enter values in each of the columns. Then, when you have complete all cells, right-click on the charts, and REFRESH […]