Line configuration

Objective

The Line Configuration option is used to not only identify the information appearing in the Cash Flow Analysis, but also determine how that information is processed. The table’s default includes 14 lines  (such as Receipts, Disbursements, Labour, etc.); the description for each of these lines can be changed as needed. Additional parameters, such as rules and calculation methods and whether a line should be visible in the analysis, can also be specified to meet a customer’s requirements.

This option describes the steps to configuring the lines. Determining how the data is presented in the analysis is done through the Display Layout Configuration option.

 

prerequisites

• General Settings (General Ledger > General > Cash Flow Analysis)
• Chart of Accounts
• Bank Accounts
• Annual Budgets

The following modules must also be installed:

• Accounts Receivable
• Accounts Payable
• Payroll (Labour)

 

Icons

Icon	Title	Used to
	Calendar of dates for which funds transfers are made for labour	Open the calendar window to indicate on which dates the transfers will take place. Only displayed when the Labour line is selected.
	Display Layout Configuration	Directly access the Display Layout Configuration option.
	Configuration	Open the Options window where the Maximum Number of Lines in the Breakdown Grid can be specified.

 

STEPS

maestro* > Accounting > Financial Management > Cash Flow Analysis > Line Configuration

 

Configuring a Cash Flow Analysis Line

1. Select a line in the Line Configuration table.

Available default lines are described below. Click the line’s name to directly access its corresponding section in the document. Line Name Description Opening Balance Initial amount at the beginning of the period. Should always be the Closing Balance of the previous period. Receipts Amount expected to be received based on issued invoices. Receipt Adjustments Adjustment to the Receipts amount. Expected Sales Amount not yet invoiced, based on the Sales budget. Disbursements Amount expected to be paid based on received invoices. Includes invoices that have been posted in maestro*. Outstanding Cheques Disbursement amounting to the sum of outstanding cheques for that period that have not yet deposited; will reduce the balance when it is. Disbursement Adjustments Adjustment to the Disbursements amount. Future Expenses Amount not yet expensed, such as an expense account; based on budget. Generally, does not include salaries. Labour Amount allocated to salaries, based on the Labour budget. Labour Adjustments Adjustment to the Labour amount. Others Manual adjustment amounts. Immediate Adjustments Adjustment related to an event that has a major and immediate impact that must be considered right away. Applicable situations could be a postal strike; most customers now pay electronically, but some still use regular mail. Not receiving some payments has a major and immediate impact. One-Time Adjustments Adjustment related to the addition or removal of a non-recurring element. Closing Balance Final amount at the end of the period, obtained after all receipt, disbursement, and adjustment operations have been posted.

2. Fill out the top section of the Detail tab as needed.

The top section (which includes descriptions and visibility) applies to all lines. The following lines only require this section; once completed, go to step 4: Opening Balance Outstanding Cheques Immediate Adjustments One-Time Adjustments Closing Balance

 

Field	Description
French Description	Name of the line as it will appear in the maestro* French version.
English Description	Name of the line as it will appear in the maestro* English version.
Visible	When checked, indicates that the line will be visible in the Cash Flow Analysis layout.

3. Fill out the rest of the Detail tab as needed.

1. Receipts

Field	Description
Calculation Method	Receipts amount will be calculated based on either: the invoice’s Due Date; or the Invoice Date.
Number of Days	Number of days until which funds will become available; corresponds to the processing time. Consequently, according to the calculation method used, the system may display the transaction in the column 15 days after the due date.
Show Partial Balance Today	When checked, the Receipts cell will include the amounts of partially paid invoices that are expected to be paid in full before the end of the period. Note: If the box is not checked, partially paid invoices will be processed according the weighting.
Weight the expected revenue according to the age of the invoice	When checked, indicates that the expected revenue will be weighted based on the invoices’ age.
% of balance expected to be collected in the period
Invoice Age	Age of the invoices based on their issue date. Available values: 0 to 30 days 31 to 60 days 61 to 90 days Over 90 days Using the periods, indicate the percentage of invoices expected to be paid within that age range. Note: The total of percentages does not have to be 100.
Period	Period during which the invoices are expected to be paid. In conjunction with the invoice age, indicate the percentage of invoices expected to be paid during that period. Available values: Current Next Next + 1
Use due date if after than current date	When checked, indicates that the invoice’s due date will be used to calculate its age if it’s after the current date.
Select Status to Include
Invoices	Status of the invoices that should be included in the calculation of the Receipts amount: Available values: 0 – Invoice entered but not transferred 1 – Invoice transferred and awaiting print 7 – Invoice receivable 8 – Invoice with holdback due 9 – Invoice fully paid Note: The above statuses come defaulted with maestro*; additional statuses can be added.
Customers	Status of the customers whose invoices should be included in the calculation of the Receipts amount: Available values: 1 – Closed A – Active B – Blocked W – Warning

2. Receipt Adjustments

Field	Description
Calculation Method	Adjustment will be entered manually.

3. Expected Sales

Field	Description
% of sales that is expected to cash in the period
Period	Percentage of sales expected to be invoiced over current and following periods. The amounts displayed are based on the budgets for the selected GL accounts (presented as groups). Available values: Current Next Next + 1 Note: The total of percentages does not have to be 100.
List of Groups of Accounts
Groups	Account groups used to calculate the expected sales. Note: Only revenue-type groups can be selected.

4. Disbursements

Field	Description
Calculation Method	Disbursements amount will be calculated based on either: the supplier invoice’s Due Date; the supplier’s Invoice Date; or Fixed Days during the Month.
Number of Days	Number of days until which funds will become available; corresponds to the processing time. Consequently, according to the calculation method used, the system may display the transaction in the column 15 days after the due date.
Show Partial Balance Today	When checked, the Disbursements cell will include the amounts of partially paid invoices that are expected to be paid in full before the end of the period. Note: If the box is not checked, partially paid invoices will be processed according the weighting.
Weight disburs. expected according to the aging of the invoice	When checked, indicates that the expected disbursement will be weighted based on the invoices’ age.
% of balance that is expected to be paid in the period
Invoice Age	Age of the supplier invoices based on their issue date. Using the periods, indicate the percentage of the balance expected to be paid within that age range. Available values: 0 to 30 days 31 to 60 days 61 to 90 days Over 90 days Note: The total of percentages does not have to be 100.
Period	Period during which the supplier invoices are expected to be paid. In conjunction with the invoice age, indicate the percentage of the balance expected to be paid during that period. Available values: Current Next Next + 1
Use due date if before the current date	When checked, indicates that the supplier invoice’s due date will be used to calculate its age if it’s before the current date.
Select Status to Include
Invoices	Status of the supplier invoices that should be included in the calculation of the Disbursements amount: Available values: 0 – Invoice entered but not transferred 1 – Invoice transferred and awaiting print 8 – Invoice transferred to payable 9 – Invoice fully paid Note: The above statuses come defaulted with maestro*; additional statuses can be added.
Suppliers	Status of the suppliers whose invoices Disbursements should be included in the calculation of the amount: Available values: 1 – Closed A – Active B – Blocked

5. Disbursement Adjustments

Field	Description
Calculation Method	Adjustment will be entered manually.

6. Future Expenses

Field	Description
% of expenses expected to be disbursed in the period
Period	Percentage of expenses expected to be disbursed over current and following periods. The amounts displayed are based on the budgets for the selected GL accounts (presented as groups). Available values: Current Next Next + 1 Note: The total of percentages does not have to be 100.
List of Groups of Accounts
Groups	Account groups used to calculate the future expenses. Note: Only expense-type groups can be selected.

7. Labour

If needed, click the Calendar icon to indicate on which dates funds will be transferred to pay for labour. Click each date on which a transfer will occur. Click Save. Click the Select Weekends icon to display weekends on the calendar. Click the Configuration icon for additional items including the background and text colours for selected and non-selected days, as well as how days are selected (single- or double-click). If required select another year for which transfer dates should be defined from the Year drop-down list. Click Quit to exit the Calendar window.

Field	Description
Calculation Method	Labour amount will be calculated based on either: the budgeted amount for a month according to projects (Labour Month Budget / Project); or the budgeted amount for a month according to GL accounts (Labour Month Budget / GL Acc.).
List of Projects
Project	Projects used to calculate the expected labour.
List of Groups
Groups	Account groups used to calculate the expected labour.

8. Labour Adjustments

Field	Description
Calculation Method	Adjustment will be entered manually.

9. Others

Field	Description
Calculation Method	Adjustment will be entered manually.

 

4. Click Save.
5. Click Quit to exit the window.

 

See also

Procedures

• Display Layout Configuration
• Define Manual Adjustment Types
• Cash Flow Analysis
• Manual Adjustments

How To

• Cash Flow Analysis

 

Last modification:March 19, 2025