Automating Data Entry using Data Validation in Excel
Profits is backed by revenue and revenue is backed by products entity is selling. Accountants often on daily basis have to prepare sales report. Two of the important ingredients of every sales report is the product name itself and price per unit. For such reports accountants often have to type products’ names and per unit […]
Payroll Calculation in Excel - Differential Piecework with Multiple Scales - How To
Differential piece work wage payments with multiple rate brackets or scales Excel Skill Level: Intermediate [It is strongly recommended if you are new to excel then go through previous tutorials in the series] For the purpose of this tutorial you need to download this excel file In our previous examples things were simpler as we […]
Payroll calculation in Excel - Simple Differential Piecework - How To
Differential Piece Work Wage Payments Excel Skills level: Beginner to Intermediate For the purpose of this tutorial you need to download this excel file In this wage system employees are given incentive for increased productivity. In this system different tiers slabs or scales of output are defined and progressive slab has increased wage rate. Calculating […]
Payroll calculator with Piece Work wage payments in Excel - How to Series
In every organization small or big we have to process salaries and wages also known as payroll. And this process is carried out sometimes on monthly basis or weekly and sometimes on daily basis as well. This is a repetitive process that accountants cannot escape and if wage calculation basis are little complex then one […]
Payroll calculation in Excel - Straight Piecework Wage System - How To
Straight Piecework Wage System Excel Skill level: Absolute Beginner For this tutorial download this excel file In this system a fixed wage is given for each unit produced and whatever number of units are produced by the labour are multiplied with that particular rate. In short it is: no. of units produced x wage rate […]
Calculating Depreciation of assets in Excel - How to
In accounting world depreciation is one key calculation to be done for every period to make the reports and is also an important part of financial management decision making process in some cases. However, depreciation calculations can sometimes be tedious and long if we have to do it for multiple classes of assets for multiple […]
Running totals and Running balance in Excel - How to
On daily basis accountants prepare day books and ledgers as regular part of accounting cycle. Usually students in the beginning learn to prepare accounts in T format. However, professional accountants maintain accounting books in dedicated accounting software in which bookkeeping is a little different. If accounts are maintained using T format then user can know […]