Excel Bookkeeping Templates
These free Excel bookkeeping templates can be used by anyone and any small business.
Excel is a fantastic spread sheeting program and if you already have it on your computer, you already have the means to start your bookkeeping.
Most of these excel bookkeeping templates are easy to customize to your requirements.
This means you change the background shading, and the fonts and layouts to get it to look how you like.
Small businesses starting up can take full advantage of Excel until they are in a position to afford bookkeeping software.
Yes! Send me your free eBook -
"Bookkeeping Forms and Templates.
Your email privacy is important to us
Did you know that Microsoft has an app you can download to your device so that you can view and edit your Excel and Word documents on the go?
It's called Office Mobile and you can access your documents in OneDrive, Dropbox and Sharepoint from your phone or tablet. It's available for Android and IOS devices.
Now to the templates...
Excel Cash Book
The cash book is designed to work in relation with your bank
statement, meaning that the entries in the cash book should match the entries
on your bank statement so that the final balances at the end of the month match each other.
You can delete unwanted columns and delete or insert more rows. Be mindful that it is formula heavy and careless editing can mess up the formulas - we left them deliberately unlocked so you can customize as much as you want.
This cash book also includes an Income Statement template so you can see if the business is making a profit or a loss, and a Balance Sheet template so you can see the value of your business.
Go to cash book...
Click on the graphic below to see the excel tutorial videos that go with the cash book above
Sales Invoice Template
Need to give your customers a sales invoice?
You can use this template for your business and edit it to suit.
Or you can simply use it to get an idea of what information you need to include on your self-designed template.
Go to sales invoice...
Statement of Account
This is what you need to send to your customers at the end of the month. Use it to list all the invoices you have sent them and include a total.
This tells your customers how much you owe them, and if for some reason they are missing an invoice, they can contact you for a copy.
A statement of account is the best way of reminding your customers that you sent them a certain number of invoices during the month, and that they owe you a certain amount of money and that it is due by a certain date, and that if they don’t pay on time you might charge a certain amount of interest.
Go to Statement...
Accounts Payable Ledger
This spreadsheet is a fantastic tool for keeping a record of your purchase invoices due for payment. You would only need to use this spreadsheet if you have bought goods on account and which you still owe payment to the supplier/vendor.
You would not use this spreadsheet if you paid for your goods at the time of purchase - eg. if you paid with cash or bank card or with some other means.
Go to Accounts Payable Ledger
Accounts Receivable Ledger
Much the same as the accounts payable ledger mentioned above, this is a great spreadsheet for recording all the invoices a business issues to a customer who have an account with the business.
The business can track customer payments, and keep notes on what a customer says if the business has to call them about overdue payments.
Go to Accounts Receivable Ledger
Also known as profit and loss statement.
All businesses need to know if a profit or loss is being made.
An income statement basically totals the income, totals the expenses, and subtracts the expenses from the income to arrive at a profit or loss figure.
Go to Income Statement...
This excel bookkeeping template provides a basic idea of the financial position of a business, although it can become tricky to monitor when you go into your second year of trading and have to start including things like retained earnings, separate from current year earnings.
Before your first year of trading is up I suggest you investigate bookkeeping software that you can use that will automatically produce a balance sheet for you.
You could try this free bookkeeping software called Manager.
Go to Balance Sheet...
Although this particular excel receipt is geared towards
rent, you can easily customize it to exclude anything to do with rent if you
require a receipt for other purposes.
This template has two versions, one has a shaded
background which just makes it look pretty, the other one has no shading so
saves the ink usage on your printer.
Go to Receipts...
Petty Cash Log and Slip
This excel bookkeeping template comes with two tabs, one for the log, wherein you list the daily cash in’s and out’s, and one for the slip, which can be printed out (might want to copy and paste the slip to fill up a page, and then cut them once printed).
Keep them in the cash box so that anyone with access can complete one whenever they take money or put change back in.
Go to Log and Slip...
This template cannot be downloaded to your computer. It is designed to be used within the webpage.
It allows you to practice entering the details of a business transaction in the top half and watch as the bookkeeping journal unfolds in the second half. It can be used for income and expenses paid into or out of a bank account, petty cash, credit card etc.
A great template to help you understand how journals work.
Go to Journal...
This particular cash flow report is really good to use if your business is tight on funds and you can only pay bills as income comes in. So you will update it every day and see what your current cash flow is looking like. It allows you to enter in all the bills coming up with their due date, enter in the daily bank balance, enter in the income and calculate how much you have available to pay the bills. This will enable you to prioritize payments for the most urgent and important bills such as wages or telephone.
Go to Cashflow...
A trial balance is a must have report if you want to move your accounts from one bookkeeping system to another, and it is something a tax accountant will check over at the end of the financial year to ensure all the debits and credits balance.
This excel template allows you to prepare one, and you can also view an example and read up how it works.
Go to Trial Balance...
Home Office Tax Expenses
Working from a home office? This excel template can be used to record all your personal bills each month (like power, city rates, home & contents insurance etc.), on which you are able to claim a portion as a deductible business expense. The claimable portion will be the percentage of your home office area vs the house area. We tell you how to calculate that and include it in the template so that the total claimable is automatically worked out.
Go to Home Office Expenses...
Conclusion to Excel Bookkeeping Templates
All of the Excel bookkeeping templates founds on this page can
be opened within OpenOffice.
If you are on this page you probably already own/subscribe
to Excel, but did you know that OpenOffice is completely free?
It is an excellent alternative to Excel and also has word
processing, presentations, graphics – all the things you can get from
Microsoft, but for free! And in many different languages.
Also, if you have have saved your excel bookkeeping templates to OneDrive or Dropbox, and you need to access your documents from your Android device, try installing the WPS Free Mobile Office App to your device. It allows you view and edit and save your excel and word documents. Great for when you are out and about.
Please contact me if you would like to see any other excel bookkeeping templates.
Oct 14, 16 12:16 AM
Putting time in to your online business but not seeing the results you want? Between 24-28 October join 10,000 like-minded women entrepreneurs for the free virtual summit guaranteed to make your incon…
Oct 12, 16 12:43 AM
Check out Wave Accounting, a 100% free accounting program perfect for service based businesses. It can be used world-wide as you can customize your sales tax options and connect your bank account.
Oct 05, 16 10:41 PM
What is a Trial Balance? Check out this Trial Balance example and information
Back to Top: Excel Bookkeeping Templates