Downpayments

The Downpayments screen enables you to enter data about payments that are paid in advance before the actual sale takes place. The downpayments are reflected in the projected cash flow of the business.

The screen allows entering data for up to 50 projects, a "project" being a name for a certain activity for which downpayments are paid.

Each project has two lines. In the first line the description appears in yellow and you can change it to the name that matches the activity for which you want to enter the payments. In this line, in the periods cells, you enter the projected amounts that will be received as downpayments.

In the second line of each project you enter the amounts of the sales for which downpayments were received. Usually the amounts should match the total amounts of the downpayments, but they will be entered in the periods in which the sales were entered in the Sales Plan screen.

Example

Suppose that you have one sale of 100,000 Euro which is scheduled for July 2005. You enter this sale in the Sales Plan screen (e.g. define one product in the Products table, save the Products table, then open the Sales Plan screen, enter unit price of 1 Euro and enter 100,000 units in July 2005).

The result of this data entry will appear in the Profit and Loss report in July 2005 as sales of 100,000 Euro and in the Cash flow report there will be a cash receipt of the same amount in the same month.

Now assume that the agreement with the customer is that 60% of the sale amount will be received in advance in six monthly payments starting from January 2005.

In this case you should enter, in the Downpayments screen, receipts of 10,000 Euro in each of the months from January till June 2005, and in July 2005 you enter, in the second line, the total amount of payments that were received on account of this sale.

As a result of this data, the Cash flow report will show receipts of the downpayments in the first six months and then the rest of the sale amount in the seventh month.

In the Balance report the downpayments will appear as liabilities to Other Payables until the sale takes place.

Toolbar Buttons

The toolbar includes the following buttons:

OK - Close screen (and save all changes if applicable)

Exit - Close screen and discard any changes if applicable.

Print Table - Create a report for the current table, showing it on the print preview screen

Forecast - Copy cell values across next periods

Export to MS Excel file - Exports the displayed table to MS Excel