IPOxCardsHow to plan IPO funding without losing the cash trail
Build a clear IPO funding calendar using daily bank closing balances, planned application amounts, refund dates and overlapping issue windows.
When several IPOs overlap, the difficult question is not “how much money do I have?” It is “which account has how much available on the exact day each application is planned, and when will blocked money become available again?”
Closing balance by account
IPO + lots + accounts
Planned requirement
Date and amount gaps
Refund / debit event
Actual record vs plan
Each step should have one clear owner, one source record and one review point.
Start with a daily closing-balance ledger
Enter the closing balance for each bank account on a specific date. Keep the bank name, account owner, masked identifier, source, note and revision visible. If no new balance is entered, carry forward the previous value as a labelled carry-forward row rather than pretending it was manually verified that day.
Assign a funding source to every planned application
For each selected IPO, choose the accounts expected to fund the applications or enter the intended lot count. The planner should show the planned amount per account and the combined requirement. Keep the selection reversible before saving so a mistaken account is not silently included.
Do not confuse the planned requirement with the final debit. Allotment may be partial or unsuccessful, and unblocking may happen later according to the issue schedule.
Identify overlaps before the application window
Compare the issue closing date, expected allotment, expected refund or unblocking and listing date for every selected IPO. A clash can occur when two applications draw on the same account on one day or when the expected refund is after another application’s funding need.
| Calendar item | What to compare | Action |
|---|---|---|
| Issue close | Another issue close on the same date | Review combined requirement |
| Allotment result | Expected debit or release | Keep pending until published |
| Refund / unblocking | Next IPO’s planned need | Flag if cash may overlap |
| Daily balance | Available closing balance | Check shortfall per account |
Make shortfalls visible, not hidden
For each date, calculate the closing cash selected, the base requirement, the optional safety buffer, the peak blocked amount and the projected shortfall. A zero shortfall means the plan fits the recorded inputs; it does not guarantee a bank will process an application or that an allotment will occur.
- Every selected IPO has a close date or an explicit pending state.
- Every planned account has a latest balance snapshot.
- Refund or unblocking dates are labelled as published or estimated.
- The same account is not double-booked without a visible warning.
- Buffer percentage is an explicit setting, not a hidden assumption.
- The plan is saved with a name, status and revision date.
Reconcile actuals after the issue
Once the outcome is known, update the application and bank records separately. Record the actual debit, release or carry-forward balance where your process tracks it, then compare it against the plan. Preserve the original plan for review rather than replacing it with the final number.
Quick answers
Is the funding planner a bank account or wallet?+
No. A planning ledger records manually entered closing balances and planned blocks. It does not connect to a bank, hold funds or move money.
What is a date clash?+
A clash happens when one account is planned for more than one cash requirement on the same date or when an expected refund is not available before another requirement begins.
Should I add a safety buffer?+
That is an operational choice. Show the buffer as an explicit input and make its default clear. Never hide it inside the amount calculation.