How to make a budget in Excel step by step

[jrineakter]

Paper has long been relegated to the background in companies as computer programs become more important. Therefore, it is essential to use the computer tools at our disposal in order to make our tasks much simpler and complete them in the shortest possible time. Today, we will explain how to create a basic budget for a client with Excel.

The Microsoft Office 365 and Google Drive software packages have the following operational advantages: it has constant updates, you can access the same project from different devices, it has secure storage and it is used, above all, for teamwork , since several people can have access to the same file in real time.

Today we are going to learn how to create a basic budget for your entity for a client using Excel, a spreadsheet that allows us to manage numerical data and text to organize information in tables made up of rows and columns.

Why this program? The person in charge of digital infographics at El Economista and professor at Villanueva University, Javier Barriocanal , explains that one of the great virtues of japan number data Excel is its simplicity when it comes to creating or reusing templates and its visual nature, since “it is quite attractive and offers us the advantage of being able to generate visual aids such as graphs that will help us read and understand our budgets.”

In addition, with Excel you can create your own templates or use some basic ones that already exist. “The advantage of creating your own is that they will adapt perfectly to your needs and you will save time in the future,” says Barriocanal.

To make the work easier, “it is best to always use the same system and make it common for everyone,” that is, “if every time we create a new budget we modify the color code or the name of the items, we will make it very difficult for anyone else to understand the budget or for the files to be compatible with each other,” Barriocanal emphasizes.


What elements and information should a budget contain?
A budget should have the following key elements that we are going to see:


Holded allows you to centralize your invoices, accounting, projects, CRM and HR in an intuitive way.

Get started for free today
Steps to follow to make a budget in Excel
Below we'll walk through the key steps, with some extra tips from Business Insider on how to use Excel functions correctly.

1. Open a spreadsheet

If you have decided to prepare your budget manually, and not using an ERP-type tool, then the ideal thing to do is to use Excel or Google Sheets. Start by customizing the design to your liking, or following the corporate aesthetic, if it is a business budget.

2. Choose the main titles

In cell A1, you should put the budget title ; in cell A3, you can put products/services ; in cell B3, income ; and in cell C3, expenses . In this way, you can begin to enter your income and expenses in each row (the first ones in column B and the second ones in C).