Xero Analytics | Short-term cash flows - Add tax payments
It would be very useful if the cashflow report could intelligently add VAT payments to Cashflow automatically.
For example when a VAT return if filed, automatically add the payment amount and date to the report, learning as it does with repeating outgoings what the date might be - if you're paying by DD this is pretty predictable.
As invoices are generated (payable and receivable) the report already picks up the amount of VAT payable to HMRC and it would not be a stretch to calculate what is due back on purchases, or to use the known VAT reporting date to forecast the amount of VAT due and when.

-
Jan Flowers commented
Totally needs a cashflow projection up to 90 days
-
Mark Ferguson commented
Analytics Plus Short-term Cash Flow forecast is a great feature, particulary now that it includes BAS/PAYG payments. However it uses the default ATO lodgement date rather than the ATO supplied date that Xero obviously knows because it is shown on the Activity Statement report. The one month timing difference makes cash flow projection meaninless for all following transactions.
-
Mark Ferguson commented
Analytics | Short term cashflow - Use ATO supplied date for projecting BAS & PAYG Payments
-
Karen Bennett commented
Very important as the amounts can have a huge impact on the cash flow.
Without this the cash flow is meaningless in my opinion.
-
Afroz Ali commented
I agree , this is a must have for cash flow projection
-
Michael Crooks commented
We use Analytics Plus Short-term cash flow projection, and it is great.
Given the GST returns are generated through the information entered into Xero (Bills & Invoices etc.), and the payment date also known, is it possible to incorporate a prediction of the future GST payment?
-
Michael Crooks commented
We would like the same for GST and have the GST payment due based on the draft return until it is finalised.