The key to any accounting system is a cash book, used to record money coming in and money going out of your bank account. Every business needs at least one, and they must be reconciled before accounts can be prepared.
There should be exactly ONE cash book per bank account.
We have written many Excel based cash books over the past 20 years, and you will find a number of examples here. If you need some help, or want one tweaked to suit your needs, please do call us.
Please follow the instructions on the instructions tab and be sure to reconcile the cash book to your bank statements. If you do not reconcile the bank account to the cash book, besides not knowing where you are, you will incur further fees from your accountant in doing the reconciliation.