Construction Business Financial Statement Generator is a simple bookkeeping spreadsheet for small business owners or financial persons to generate profit and loss report, balance sheet statement, cash flow report and equity report quickly for your construction business. It usually based on projects. And you can put any projects inside this spreadsheet, from simple/small projects like design or consultant projects until big projects like house/apartment renovation or building new house/apartments. The objective of this spreadsheet is to help you generating standard one year accounting report without any needs of accounting knowledge. You will see that there is a different report visualization between income and cash flow statement. And you will get balance sheet statement automatically to see whether your profit increasing your assets value. You don't need accounting background to record your business transactions. Just fill the transaction and all financial statements will be generated automatically. And there is a spreadsheet filled with samples to help you filling the transaction easily. In the spreadsheet sample, you will see how to fill any receivables and payables, project transactions, other income and expenses, asset purchase and sales, deposits etc. Basically all transactions that are related and not related with profit and loss where they are all needed to form complete financial statements automatically. ******************** You may check how this spreadsheet visualization in googlesheets (no editing or downloading feature) https://docs.google.com/spreadsheets/d/1G16C-yqAljJkcMUgLoTM3G0IcPh2ZW354UjmdVr-eeM/edit?usp=sharing You will get the Excel version that are compatible with Google Sheets (you can use in Excel or upload it to Googlesheets) and link to copy Google Sheets version directly (blank spreadsheet). ******************** In this spreadsheet, income statement is divided into 3 parts. Revenue, Cost of Sales and Expenses. In Construction Business, you can fill Cost of Sales with direct cost like material, labor, subcontractor. You can also add other related direct cost like overhead or others. Revenue and COGS that are related with Projects are filled in one particular tab. And there is another income and expenses tab to fill operating income and expenses that are not related with projects directly. There are additional report that could help you analyzing your business instead of 4 standard financial statements. Those additional reports are : Receivable, Payable, Project and Asset report. Also, I included Dashboard to help you to see financial summary for one year quickly. Fits to you who wants to monitor and track your business using Microsoft Excel or Google Sheets and don’t want to spend time on sophisticated and standalone accounting software. ******************** *** IT CAN START FROM ANY DATES TO MEET YOUR OWN FISCAL PERIOD *** You can use it as : - Your main spreadsheet to record any business transaction - Your supporting spreadsheet to record summary of daily, weekly or monthly transaction generated from your Point of Sales application or other sales application *** PAY ONCE AND YOU CAN RE-USE IT EVERY YEAR AND FOREVER ***. ******************** There is a spreadsheet with filled with general category and data samples. Different business might have different products and services. Use this data samples as references on how to fill your data. Use ready-to-use spreadsheet to entry your own data. Drop me a message if you have any questions. I will answer it within 24 hours. What's included: • 1 ready-to-use Excel spreadsheet compatible with Google Sheets • 1 Excel spreadsheet with data samples. • 1 User Guide in PDF Format • 1 Txt file with Google Link to copy Google Sheets version (You can also upload the Excel file and save it as Google Sheets after being uploaded successfully) ******************** Worksheets : > Setup | Financial Accounts : Edit financial accounts > Setup | Prepaid Revenue/Expenses : Fill previous year unused prepaid revenue/expenses > Setup | Projects > Data Entry | Transactions - Revenue & COGS > Data Entry | Income/Expenses : Fill other income and expenses > Data Entry | Cash/Bank Internal Transfer : Fill internal account cash/bank transfer > Data Entry | Purchase/Sale of Assets : Fill with your assets. Depreciation will be calculated automatically > Report | Income Statement - Monthly & One Year > Report | Balance Sheet - One Year > Report | Cash Flow - Monthly & One Year > Report | Equity - One Year > Report | Project Gross Profit/Loss - One Year > Report | Assets - One Year > Report | Receivable - One Year > Report | Payable - One Year > Dashboard You can use this spreadsheet without any modification. But, you can modify all shown worksheets layouts (change fonts, color, etc), tweak its formula to suit your needs. Remember that all worksheets are connected. You may need some Excel knowledge to modify the all formulas correctly. ******************** This is a digital download product - no physical product. Purchaser will receive an email with a download link within 24 hours of purchase. The email will be sent to the email address purchaser provided at time of purchase. ******************** How to get it: • Add this item to your cart, • Choose the payment method, • After you complete the payment you will see the link for downloading the files. They will be available in your purchase area (https://www.etsy.com/your/purchases), • Download the file(s), • Open the file using Microsoft Excel ******************** System Requirements: >> a minimum Microsoft Excel 2007 for Windows and Excel 2008 for Mac or Googlesheets ********************* Notes : • All sales are final. • All of the files included in this download are original and copyright to growSHEET. They are for your personal use only and cannot be resold in any shape or form. • If you have any problems or questions, please contact me via Etsy! Thank you for shopping.