Overview
By default, Castaway reports Trade Debtors and Trade Creditors as a single consolidated line in the Cash Flow report for actuals periods. From the forecast period onwards, these can be reported separately by their underlying Sales or Expense elements. This article walks through how to configure individual debtor and creditor reporting lines and bring in the corresponding actuals data.
Only the following element types offer the Debtor Reporting or Creditor Reporting setting:
- Sales - Debtor Reporting
- Cost - Creditor Reporting
- Inventory - Creditor Reporting
- Fixed Assets - Creditor Reporting
Changing the Reporting Setting
- Go to Forecast > Element Settings and open the element you wish to report separately.
- Under Settings, locate the Debtor Reporting or Creditor Reporting setting.
- Click the dropdown and select your preferred option.
For Sales elements, a Link to Debtor Element option is also available. To use this, first create a Debtor element in the chart of accounts under the Debtor Elements folder, located above the Fixed Assets folder in the Balance Sheet section.
- Once an option other than Trade Debtors/Creditors or Link to Debtor Element is selected, you can configure the Opening Cashflow Method and adjust opening payment or receipt terms under the Cashflow tab. Actual values entered in Forecast > Actuals Data will then appear in the element data entry screen.
- Navigate to Forecast > Actuals Data > Balance Sheet Data. Elements you have updated will now appear as individual reporting lines under Trade Debtors or Trade Creditors, allowing you to bring in actuals data separately for each.
If you are importing actuals and have separate debtor or creditor account balances in your accounting system, these can now be mapped to the individually reported elements.
Confirming the Cash Flow Report
Once actuals have been imported, review your Cash Flow report via Analysis > Reports > Key Reports > Cash Flow to confirm the structure reflects your expected reporting.