A client who is an architect asked us for a template created with Excel, in order to be able to track the costs of his works. The template is an Excel book, composed of five sheets, connected to each other. The sheets are: Journal, Plot Expenses, Construction Expenses, Non-Construction Expenses, Total Expenses Summary.
Below we explain in more detail, each of them.
- Journal: This involves recording the invoices, their date, the concept, the amount, the amount paid, the amount outstanding, the amount of tax, the Total, the income tax, the withholding and any discounts.
Since the number of entries can be long, the Journal is already presented by segmenting the number of lines that fit on a paper. For this reason there are several tables that give continuity to the entries. For each table, there is a corresponding print button, to facilitate the user’s tasks.
Application made with Excel. To use this application you need to have the MS Excel program. The application is made in Spanish language. Note: The data inserted in the images are fictitious.