Using Microsoft Excel Businesses acquire several types of fixed assets or plant assets for their operations. Those long term assets benefit more than one period; thus, the cost must be allocated between reporting periods. As we know, various methods for allocating exist such as straight line, sum of the years, double declining and others. As…
Category: How to Excel
Creating Account Receivable Subsidiary and Aging
Using Microsoft Excel / Google Sheets Do you have credit sales? Do you feel cumbersome keeping track of due dates and aging accounts receivable? Would you like to have your clients on a worksheet easy to maintain? The answers to these and other questions can be answered with an Account Receivable Subsidiary with an Aging….
How to Create a Payroll Worksheet using Google Sheets or Microsoft
Using Google Sheets / Microsoft Excel This post is about creating a Payroll worksheet. You can create a functional payroll worksheet using Google Sheets or Microsoft Excel. You can keep track of one or more employees, with different rates and deductions. In the image, I show you an example with some data for purposes of…
How to Create a Table with Microsoft Excel
How to create a Table with Microsoft Excel Using spreadsheets such as Microsoft Excel should not be an intimidating task. Using the next steps, you can create a simple table summarizing your data and adding several features to make it more meaningful for your purposes. First, a simple rule: Use columns to segregate the same…
How to Calculate a Forecast/Projection?
In today’s fast-paced business environment, the ability to accurately forecast and project future performance is essential for decision-making and strategy development. Financial forecasting enables organizations to predict future revenues, expenses, and profitability, thereby supporting effective budgeting, resource allocation, and strategic planning. This comprehensive guide will explore the key concepts of forecasting, the methods used to…
How to use Standard Costs in your business
How to Use Standard Costs in Your Business: A Comprehensive Guide In the highly competitive world of business, effective cost management is crucial for maintaining profitability and ensuring long-term success. One of the most powerful tools available to businesses for managing costs is the concept of standard costs. This blog post will explore what standard…