The Cash Flow export helps you evaluate which team invoiced how much, what costs were assigned to that work, and what the estimated revenue was for a given period. You can use it to track how your accounting position develops over time.
Where to find Cashflow Export
Finance → Outgoing Invoices → Export → Cash flow
Note: Before downloading Cashflow export, you set a Date of Supply - invoices falling within that period are included. Unlike some other exports, this one is always based on that date criterion as it includes invoices from separate listings (expenses and issued invoices)
What is in Cashflow export?
The export contains four sheets:
1. Outgoing invoices
Every issued (non-proforma) outgoing invoice within the selected date range.
Legal Entity – The legal entity the invoice was issued under.
IBAN (Legal Entity) – The bank account associated with that legal entity.
Due Date
Date of Supply
Date of Supply Month – The month derived from the date of supply.
Paid Date – The date the invoice was paid.
Paid Amount
Billing Entity – The client's billing entity, as entered on the invoice.
Client
Brand
ID Invoice – The invoice number.
Invoice Items – The names of the invoiced budget items/tasks, combined into one field.
VAT Rate (%)
Total with VAT
VAT – The VAT amount.
Total excl. VAT
Total with VAT (for currencies other than workspace currency) / VAT (for currencies other than workspace currency) / Total excl. VAT (for currencies other than workspace currency) – The same three totals, shown in the invoice's original currency when it isn't in workspace currency.
Currency Rate – The exchange rate used for the conversion.
Currency
Team
Projects titles / Projects codes / Projects statuses – The project(s) linked to the invoice, and their current status (e.g. Active, Finished).
Project category
Purchase order No – The client's PO number, if entered.
Internal Note
Created on
2. Outgoing invoices proforma
Proforma invoices within the selected date range (paid and unpaid). Same structure as the Outgoing invoices sheet, with two differences:
Issue Date appears instead of Date of Supply.
There's no Purchase order No column.
3. Expenses
All incoming costs recorded in Allfred (invoices, receipts, bills, and card payments), one row per expense document.
Type – The document type, e.g. Bill, Receipt, Invoice, Card payment, or Other.
Due Date
Date of Supply
Date of Supply Month
Paid Date
Paid Amount
Variable Symbol
Contractor – The supplier/vendor on the expense.
Note
Total with VAT
VAT
Total excl. VAT
Total with VAT (for currencies other than workspace currency) / VAT (for currencies other than workspace currency) / Total excl. VAT (for currencies other than workspace currency)
Currency
Teams
Projects Titles / Projects Codes / Project Statuses
Project Category
Billing Category – e.g. Billable, Non-billable.
Expense ID
ID Invoice – The expense's invoice/document number.
Expense No – Allfred's internal sequence number for the expense.
Internal Note
Created On
4. Expense items
The same expenses, broken down to individual line items (each expense can contain several). Includes everything from the Expenses sheet, plus:
VAT Rate (%)
Currency Rate
Expense Item ID – Identifier for the individual line item.
Accounting Account – The accounting account the line item is assigned to.
Cost Center
Tag