Financial Admin Business

Index

The Financial Administration Business Template

When I started I didn't have an accounting program. I am a fan of Excel and wanted to do my own administration. I have done my administration for years in this simple Excel template. It is easy to use and it only cost me having Excel.

Building My Administration In Excel 

The template in Excel consists of a tab for each month of the year and a tab called VAT. On the VAT tab, my turnover and VAT are calculated per month, more about that later. I do my actual administration on the monthly tabs. Let's start with that.

Income And Expenses 

Let's take the Jan tab as an example. The income is filled in the first orange box and the expenses in the second orange box. Each income or expense item is given a separate line on this tab. The first income item is therefore on line 24.

• The name of the customer is filled in A24 

• The description of the assignment is filled in B24

• The category of the type of work is filled in C24

• The date on which the invoice was paid is filled in D24. I fill in this schedule as soon as I write an invoice, but leave the date field blank until the invoice has been paid and then fill in the date

• The amount that the customer owes me excluding VAT is filled in E24

• The VAT that the customer owes me is filled in in F24

• In G24, the system automatically calculates the total amount that the customer owes me (amount excluding VAT + VAT).

This is how I fill in all my income for January. On line 34, the system gives my total income excluding VAT (E34). And in F34 the total VAT that I received this month. Finally, in G34 I calculate the total amount including VAT that I received in January. The costs are filled in the same way.

• A38 is where the supplier of a product or service comes in. In B38 the description of the service / product. In C38 the category of the product or service. Cost categories are: travel costs, network costs, study costs, operational costs, etc. 

• In D38 comes the purchase date of the product or service

• In E38 the amount excluding VAT and in F38 the VAT I paid for the product. In G38, the amount excluding VAT and VAT is added together. 

In this case I fill in all my costs for January. Each on a separate line. At the end the total costs appear in line 53. In E53 the amount of costs excluding VAT, in F53 the VAT paid by me and in G53 the total amount including VAT.

VAT & Turnover Per Quarter 

On the VAT tab, everything is calculated automatically when I fill in the months tabs. Column B shows the VAT paid by me, column C the VAT received. In column D the difference between VAT received and VAT paid is calculated. This is the amount that must be paid or received by the tax authorities. Column E shows my gross turnover excluding VAT. In column F the quarterly costs excluding VAT. And column G gives me my gross profit before tax per quarter.