⭐⭐⭐⭐⭐ Awesome Excel Templates and Spreadsheets
Hi today we’ll have a look at how to use the complete business finance management template we’ll start by hiding the top ribbon to have more space great first let’s go into the settings page this is where you can enter parameters to set up the tool we can enter the month of the start of the financial year the year we want to report on a couple of taxes name
The beginning cash on hand and select a language let’s go to the translation tab this is where we can customize our three base languages which is english french and portuguese and set up a fourth one moving on to the category section this allows you to set up the list of income categories as well as the list of expense categories let’s add a new income category
We’ll call it property lease great next the budget this is split into two sections the budget income and the budget expense the budget income is a list of all income categories and sections to enter monthly budget let’s enter monthly budget for newly created category property lease great the budget expense tab is very similar to the budget income tab only
To list expenses let’s move on to the customer tab this is a table listing all clients and their details let’s add a new one we’ll call him elon musk and we’ll enter all his details looking into the supplier list you can see it is very similar to the customer list except it lists suppliers rather than customers let’s go into the income tab there are 12 tabs
One for each month each allowing you to enter a detailed list of all incomes the header indicates the total payment received for the month the account receivable which is the remainder left to be paid the total income the budget as set up in the income budget section and the percentage actual first budget let’s enter a new record together we’ll set a date
An invoice number select customer let’s add our newly created customer elon musk enter a category once again we’ll select our newly created category property lease enter an amount as you can see the two taxes auto calculate based on the amount that has been entered so does the total finally we’ll just indicate if the payment has been received or not this
Process has to be repeated for every month of the year moving on to the expense tab this is very similar to the income tab but allows you to enter the monthly expenses rather than incomes great we’re now ready to look at the reports we’ll start with the cash flow the filter in the top right allows you to visualize all incomes and expenses or only the one with
Payment already made received or only the one with invoices left to be paid out and expenses left to be paid the header indicates the beginning cash on hand total income total expenses the profit or loss and the ending cash on hand the graph underneath displays the monthly income and expenses and the monthly cash on hand further down a table indicates the
Total income total expenses profit or loss and the cash on hand for each month moving on to the receivable and payable report this report compares incomes and expenses side by side we first have the payments received and left to be paid and the total income the percent of payment receipt indicates the value that has already been paid and finally the accounts
Receivable per month indicates the total value that is left to be paid out per month on the expense side we can see the paid bills the account payable and the total as well as the percent of payment made and the accounts payable per month great let’s move on to the overview report this indicates the expenses and incomes actual verse budget let’s look at the
Income section we start with the donor chart indicating the actual first budget ratio we also have the budget income actual income and the difference on the site further down we have a chart indicating actual and budget income per month and finally further down a table indicating the budget actual difference and actual income percent of budget per month once
Again the same information is displayed on the right hand side for expenses let’s go to the budget by categories first thing to do is to refresh the report to ensure the latest data is being shown perfect let’s look at the incomes we can see the total budget income the total income the difference or balance and the percentage of budget for the year and per
Category the filter on the side allows you to choose a specific month to visualize the budget expense section is very similar to the budget income section but displays expenses rather than incomes let’s go to the income category section this report displays income per category either per month or per quarter the expense by category it’s very similar to the
Income by category but shows expenses rather than incomes let’s keep going on the income by customer which shows all of the incomes split out per customer and per month or per quarter same thing with the expense by supplier finally the taxes report this last report displays both the income and the expense categories per quarter and the difference and that’s
It you know everything you need to know about our complete business finance management template and you’re ready to start using it now enjoy
Transcribed from video
✅ Financial Management Excel Template By Daniel Granero Sarrión
