Cashflow JS

Settings

Forecast Settings
Configure the starting point and currency for your cash flow forecast.

This will be used as the starting point for the balance chart on the dashboard.

This will be used for all monetary values across the application.

Set the default state for the 'Predicted Cashflow' toggle on the dashboard.

Set the default state for the 'Apply Exclusions' toggle on relevant pages.

File Column Mapping
Map the column names from your spreadsheet to the required fields. This ensures your data is parsed correctly.
Required FieldYour Column NameDescription & Format
Type
Transaction category. Expected values: 'Invoice', 'Bill', 'Bill Credit', 'Credit Memo'.
Document Number
Unique ID for the transaction (e.g., invoice #).
Name
The name of the client or vendor.
Due Date
The date the payment is due. Format should match selection below.
Date (Fallback)
Transaction date. Used if 'Due Date' is empty.
Amount (Original)
The total transaction amount.
Remaining Amount
The open or outstanding balance of the transaction.
Status
Optional
If missing, status is inferred from 'Date Closed'.
Date Closed
Optional
Used for status inference if 'Status' column is not found.
Date Format
The date format used in your file.
Installment Due Date
Optional
Optional: The installment's specific due date.
Installment Amount
Optional
Optional: The installment's specific amount.
Installment Number
Optional
Optional: The installment's identifier (e.g., 1/3).
Installment Status
Optional
Optional: The installment's specific status.