Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Prepare a daily cash snapshot from bank balances taken at different times

Label each balance's time, currency and availability basis, then account for known commitments without counting transfers or pending payments twice.

By Institution3 minute readPublished View sources
In this guide

Choose a reporting time and keep the source times visible

Define when the daily cash snapshot is prepared and which accounts it covers. Record the bank's balance timestamp, extraction time, currency and balance label for each row. If one bank supplies yesterday's closing balance and another supplies a live available balance, keep that distinction visible before adding them together.

Use the bank account register to confirm completeness and ownership. Separate accounts belonging to different legal entities and identify balances that management cannot freely transfer. A group total can be useful, but the report should also show where each payment can actually be funded. Mark inaccessible accounts explicitly instead of silently excluding them from the total.

Understand what the bank's available balance already includes

Read the provider's balance definitions and identify known holds or pending activity included in the amount. Wells Fargo's business guidance warns that an available balance may omit written checks, upcoming automatic payments or card transactions not yet submitted. The portal therefore cannot be the only record of commitments.

At the same time, subtracting every pending payment again can understate cash if the bank already deducted it. Match each adjustment to the balance basis. Keep the calculation understandable: source balance, adjustments for items not already reflected, and the resulting operational view.

When the bank's treatment is unclear, label the uncertainty and obtain clarification. Do not conceal a doubtful adjustment in a miscellaneous deduction. The report is most useful when the payment approver knows which amounts are confirmed and which depend on an assumption.

References: Wells Fargo: Business balances and outstanding transactions

Bridge the source time to the decision time

List material transactions known to have occurred after a source balance was captured. Use actual payment or receipt evidence, with the account and time identified. A report prepared before a large payroll debit should not be reused unchanged for an afternoon supplier run.

Track transfers between included accounts as paired movements. If the source account has been debited but the receiving balance has not updated, show the in-transit amount once and explain its availability. If both balances are from different moments, check that the transfer has not been counted twice.

Separate confirmed receipts from expected customer collections. A promised payment belongs in the forecast with its confidence and date assumptions; it should not silently increase today's bank-based cash position. Similarly, an approved payment not yet submitted remains a commitment even when the bank does not display it.

Present the decision and preserve the calculation

Show balances by currency before converting them into a reporting total. Record the rate and time used for the summary, while retaining native amounts for payments. Do not assume funds in one currency can cover another currency's obligation without conversion, transfer timing and authorized access being considered.

Highlight the next funding decision: an account below its agreed buffer, a release awaiting bank confirmation or a payment due before an expected receipt. Give the responsible person the amount, deadline and supporting record. Avoid filling the report with every transaction when only a few affect the immediate decision.

Save the source extracts and the final version used for approval. Date later revisions and explain the material change. Compare the snapshot with subsequent settled activity and the monthly reconciliation to identify repeated omissions. The daily view supports immediate cash decisions; its usefulness depends on explicit timestamps, known commitments and a traceable bridge back to the bank records.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.