Income from long jobs like new homes should be entered using percentages that match your draw schedule. In this example, April shows a 10 percent down payment (.1), with draws of 20 (.2), 25 (.25), and 35 (.35) percent in May, June, and July, and a final completion payment of 10 percent in August.
Income from long jobs like new homes should be entered using percentages that match your draw schedule. In this example, April shows a 10 percent down payment (.1), with draws of 20 (.2), 25 (.25), and 35 (.35) percent in May, June, and July, and a final completion payment of 10 percent in August.

For this month’s column I’ve created the first part of an Excel-based system — a budgeting planner and break-even calculator that you can use to take some of the pain out of the yearly exercise of creating your jobs budget. Later, I’ll add a way to track your actual results against the budget you set up.

To download it, go to the library in the Business Technology forum at jlconline.com. Save the workbook to a safe spot on your hard drive and then make copies for your working data. If you fill in everything you can and save the workbook as an Excel template (.xltx), the bulk of the information will already be in place each time you open it. I...

or Register to read the full article.