Excel Inventory Template
If you buy or make stock items and sell them, you can use this Excel inventory template to keep a track of all items purchased (made) and sold, having a record of the costs and prices, the quantities, the values and so one for each one.
There is an overall Inventory Report which updates automatically so you get to see the totals in one list and immediately see the quantities left in stock, and the overall value of stock on hand.
We also explain how to bring the total value of stock on hand into your bookkeeping software.
Go to Excel Inventory Template
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...
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
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...
Petty Cash Log and Voucher Templates
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...