Are you a Human Resource or Finance personnel that manages employees’ payroll computation? You will agree with me that in preparing staff payroll there are a number of computations that are required based on statutory requirements and the organization’s policies. In this training, we will look at how to design an Excel template that computes …
How To Compute Employee Seniority Bonus in Excel Automatically Read More »
Accounts receivable also known as debtors are customers that owe your business due to credit sales. This item is captured as current assets on the balance sheet and a vital area of any business financials. If this aspect of your business is not properly managed, it can result in a loss of assets. In this …
If you sell physical goods and tracking your inventory has been a challenge then here is an easy-to-use tool that will do the job for you. When I say tracking your inventory, I mean your ability to keep track of the movement of the goods you buy and sell. Here are the benefits of what …
How To Design An Inventory Tracker Excel Template Read More »
Imprest is a fixed amount of funds set aside for petty or small expenditures and replenished back to float when the balance is below the minimum level. In this tutorial, you will learn how to design an automated Excel template that keeps track of imprest and petty cash expenses. This template will help you track …
Excel For Accountants – How To Design A Petty Cash Excel Template Read More »
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. Watch the training here If you don’t want to go through the process, …
Record-keeping or Book-keeping is an integral part of any business that wants to grow and succeed. There are different parts to record-keeping and in this video, I will show you how to maintain a Credit Purchase Book in Excel. The Credit Purchase Book is an Excel template that helps you track all credit purchase transactions …
If you are an accountant, cashier, bookkeeper or finance person in any capacity, you will agree with me that the task of reconciliation can be daunting when you don’t have the right tool at your disposal to make it easier. Microsoft Excel is a tool that is used by a wide range of individuals across …
HOW TO RECONCILE BANK STATEMENT AND CASH BOOK IN EXCEL Read More »
