Spreadsheet:
Bank Balance Book
Your bank balance is one of the most important pieces of information in your business. You need to know what it is on a daily basis. To save time ringing the bank every day, since you have all the information you need to calculate it yourself, keep a Bank Balance Book.
This can be a simple ledger book (you’ll find cheap versions in any stationery shop), with columns for:
- Date
- Transaction details
- Cash into the bank account
- Cash out of the bank account
- Balance
or use the Bank Balance Book spreadsheet, which will help you to record transactions on your bank account and maintain an up-to-date balance position.
Download the Bank Balance Book spreadsheet.
- Locked version - with this version, you can only enter data in specific cells and cannot alter the spreadsheet.
- Unlocked version - you can alter this spreadsheet to suit your own circumstances.
Save the spreadsheet to your hard disk and use the back button on the Toolbar to return to this page.
Note that you will need to copy this spreadsheet for each account and period for which you want to record a bank balance.
Record every transaction that goes through your bank account in this book, and you will always know what your balance is. Get into the habit of checking the balance before you write cheques (even if they are essential) and you will avoid unpleasant surprises.
Note:
By downloading this spreadsheet, you accept it "as is".
Oak Tree Press accepts no responsibility for any consequences arising from the use of this spreadsheet.
|
