Our templates have 300,000+ downloads and are used by many small businesses, non-profits and charities.
They are simple and easy to use, with full instructions available.ĭrop us a message if you need help with any of our free accounting spreadsheets or can not find what you are looking for. We have designed 25 Excel free accounting templates to help small business owners manage their own bookkeeping, including petty cash, cash book, business expenses, cash flow, sales invoice, statements, income statement and balance sheet. The most popular template is the Cash Book, suitable for recording your business transactions for Limited companies, self-employed and self-assessment. They are available to download for business or personal use. Our Free Excel Bookkeeping Templates are great for managing basic bookkeeping and accounting tasks using Microsoft. For example, if your budget balance is $2000 per month, and you initially invested $50,000 in your company, then you will get this money back after 25 months.25 FREE Excel templates to download and use for your small business. Payback period is the time required to cover the costs of the initial investment.Put this template to use, and get a clear perspective on the cost of running your business. This kind of figure means that you should probably change your business model. From recurring payments and investments to miscellaneous expenses, the template helps you keep track of every penny. A negative number indicates that something is very wrong with your company, as it loses money instead of earning it. If your business is profitable, it will be a positive number. Budget balance is the most critical number in this section.
You should always have this kind of funds available to cover all monthly expenses. Total expenses is the amount of money you need to spend every month.Total income is the monthly income, or revenue, that your company brings per month.Again, this applies only if your business is not running yet – otherwise, you can safely ignore it. This is the money that you have to invest in your business before it can start bringing profit. Initial investment is the same as the one-time costs.It will provide you with some statistics that will hopefully be useful for you. Now, you can take a look at the summary section at the bottom of the calculator. From rent and utilities, through insurances and leases, to travel costs and office supplies, all of these expenses decrease your monthly budget balance.įilling out the whole business budget template was probably a lot of work. Monthly expenses - Includes all other expenses that you need to make every month through the whole lifetime of your business.Salaries - Appears as a separate expense category because you might want to split it into a few subcategories for benefits or commissions your employees receive.These costs are the initial costs of setting up your business and include categories such as equipment, furniture, initial marketing, and the cost of building up an initial inventory.
One-time costs - This section applies to you only if you have not started a company yet.They include interest from funds you have placed in bank deposits or various grants and donations your business receives. Non-operating income - Streams of income that are not primary but also contribute to your business.We created four fields here so that you can separate your streams of income (for example, if you sell mugs and offer a customized print at an extra fee, you can enter income from basic sales and customization separately). Operating income - Primary sources of your income.You can use it in two ways – either input the figures from the last month to better understand your expenses or plan your ideal budget that you will try to stick to. This way, you can quickly overview your budget and decide which categories require additional funds (or require a cut, for that matter). We divided our business budget template into a few categories for your convenience.