Cashbook is a book where cash and bank transactions are recorded.
In other words, is a book that records transaction that affects cash and bank balances.
In this training, I will show you how to design an automated cash book in Excel.
If you don’t want to go through the process, you can get the already designed template here
Here is also a premium template that can help you achieve the following functions:
✔ Daily recording of cash and bank transactions
✔ Monthly reconciliation of cashbook and bank statement for each account
✔ Generates monthly and yearly Profit or Loss report
✔ Management of different business accounts
✔ Captures Value Added Tax and monitors the remittance of such tax.
Do well to try this out yourself. You learn by practice
Hey!
Did you get value from this tutorial?
Kindly use the comment section to send your feedback as this will help serve you better.
Do well to share this insightful tip with others.
Thank you!
Amaka Cares!