Matching cash withdrawals to several receipts
Learn how to match one cash withdrawal to several receipts, record change, explain timing differences and prepare a clear donor report.
A bank statement may show one cash withdrawal, while the money was used for several purchases. For example, a project officer withdraws 1,000 in local currency and returns with receipts for stationery, transport, refreshments and telephone credit. The donor report needs to show the real expenses, not simply one line called “cash withdrawal”.
The task is to create a clear link from the bank transaction to each receipt and to account for any money left over. You do not need complicated accounting software to do this. A cashbook, a simple batch cover sheet and careful filing can provide a practical audit trail.
Understand what the withdrawal represents
A cash withdrawal is normally a movement of money from the organisation’s bank account into its cash holdings. It does not, by itself, show what the project bought. The withdrawal slip or bank statement proves that cash left the bank, but it does not prove that the cash was spent on an eligible project activity.
The expenses arise when the cash is paid to suppliers, staff, transport providers or other recipients. Each payment should therefore be recorded according to its actual purpose. A stationery purchase belongs under stationery or office costs. A payment for fuel belongs under transport or vehicle costs, depending on the approved donor budget.
This distinction matters because reporting the whole withdrawal as an expense can hide unspent cash. It can also place several different types of cost under the wrong budget heading. Unless the donor gives different instructions, prepare the expense report from the supporting receipts and payment vouchers rather than from the withdrawal amount alone.
Bank charges are separate. If the bank statement shows a withdrawal of 1,000 and a cash withdrawal fee of 10, record the 10 as a bank charge if it is eligible. Do not add it to the cash available for spending.
- Bank statement: evidence that money left the bank account.
- Withdrawal slip: evidence of the cash collection, approval and recipient, if completed properly.
- Receipt or invoice: evidence of what was purchased.
- Payment voucher: evidence of who was paid, why and who approved the payment.
- Cashbook: the record connecting the withdrawal, individual payments and remaining balance.
Create one cash batch for the withdrawal
Give every withdrawal a unique reference, such as CW-042. Write this reference on the withdrawal slip, the cashbook entry, the batch cover sheet and every receipt paid from that cash. This makes it possible to move from the bank statement to the receipts and back again.
A batch cover sheet can be a spreadsheet, a printed form or a ruled page. Record the withdrawal date, amount, bank account, person who collected the cash, purpose and approval reference. Under that information, list every payment made from the withdrawal.
Suppose a project officer withdraws 1,000 on 8 April for a community training session. The officer later submits a stationery receipt for 320, a refreshments receipt for 250, a transport voucher for 180 and a telephone credit receipt for 100. The total spent is 850, leaving 150 in cash.
The donor expense report should include the four expenses under their relevant budget headings. The 150 should remain as cash on hand until it is spent on an approved item or returned to the bank. The batch still reconciles because the receipts plus the remaining cash equal the amount withdrawn.
The cover sheet might show: withdrawal CW-042, 1,000; stationery, 320; refreshments, 250; transport, 180; telephone credit, 100; total spent, 850; cash returned to the cashier, 150. Attach the receipts in the same order as the lines on the cover sheet.
If the officer gives the remaining 150 back to the cashier, obtain a signed cash return note. If the money stays with the officer temporarily, record it as an outstanding cash advance, not as an expense. Follow the organisation’s rules on how quickly advances must be cleared.
- Use one reference for the entire withdrawal batch.
- Number the receipts CW-042-01, CW-042-02 and so on.
- List the gross amount of each receipt and its budget category.
- Show cash returned, cash still held or money redeposited into the bank.
- Have the person preparing the batch and the reviewer sign or initial the cover sheet.
Reconcile the cash before reporting it
A simple cash reconciliation checks whether all money is accounted for. Start with the opening cash balance, add cash withdrawals and any other cash received, then deduct payments and bank redeposits. The result should equal the physical cash still held.
For example, the project begins May with 200 in the cash box. During May it withdraws another 1,500. Receipts and approved vouchers total 1,250, and 100 is redeposited into the bank. The expected closing cash is 350: opening cash of 200 plus withdrawals of 1,500, less expenses of 1,250 and the redeposit of 100.
Count the physical cash and compare it with the expected balance. If the cash box contains 330 rather than 350, there is an unexplained shortage of 20. Do not change a receipt or create a false expense to make the records balance. Record the difference, investigate it and ask the responsible person for an explanation.
Receipts linked to one withdrawal may cross reporting periods. A withdrawal made on 29 June might partly fund purchases made on 2 July. Do not force the July receipts into the June report simply to clear the withdrawal. Report expenses according to the donor’s required accounting basis and show the unused amount as cash or an uncleared advance at the June reporting date.
The opposite situation is also possible. Receipts may total more than one recent withdrawal because the cashier already had an opening balance. In that case, do not try to attach every receipt to the latest withdrawal alone. The full cash reconciliation should show that the payments were funded by opening cash plus new withdrawals.
- Opening cash balance
- Cash withdrawn from the bank
- Other cash received, such as refunds
- Cash expenses supported by receipts or approved vouchers
- Cash redeposited into the bank
- Closing cash counted and signed off
Deal honestly with weak or missing documents
A receipt can be unclear without being false. Small suppliers may issue handwritten receipts, and local transport providers may not issue formal documents. The important question is whether the evidence meets the donor’s rules and provides enough information to understand and verify the payment.
A useful receipt or payment voucher should show the date, amount, currency, supplier or recipient, goods or service, project purpose and payer. It should also show approval where required. If the supplier’s receipt only says “items”, add a separate note explaining what was purchased, but do not alter the supplier’s original writing.
Where no formal receipt is available, use an internal payment voucher only if the donor and the organisation’s policy permit it. The recipient should sign or add a thumbprint where appropriate. The voucher should explain why an external receipt could not be obtained. A staff member should not sign as both the recipient and the approver.
If a receipt is missing, mark the payment as unsupported while you search for the document. Ask the person who handled the cash, check photographs or scanned copies, and contact the supplier if practical. Do not quietly include the amount as fully supported. The donor may require it to be excluded, disclosed or repaid.
Also check for personal items, arithmetic errors, duplicate receipts and purchases outside the approved project period. If one receipt contains both eligible and ineligible items, record only the eligible lines and explain the split on the cover sheet.
For receipts in a different currency, retain the original amount and currency. Convert it using the exchange-rate method required by the donor, such as the actual bank rate or an approved monthly rate. Keep evidence of the rate and apply the method consistently. Do not choose a convenient informal rate merely to make the batch equal the withdrawal.
- Never create or rewrite a supplier receipt.
- Keep the original document even when you add an explanation.
- Mark document problems clearly for review.
- Separate unsupported or ineligible costs from the donor claim.
- Record who approved any exception and why.
Build the donor report from the receipt list
Once each cash batch reconciles, create the donor expense schedule from the individual payments. A useful schedule includes the payment date, batch reference, receipt number, supplier or recipient, description, budget line, local-currency amount, exchange rate where needed and reporting-currency amount.
Keep enough detail for a reviewer to understand the cost. “Training materials for 14 May community meeting” is more useful than “miscellaneous”. Avoid combining unrelated receipts into one vague expense line, even though they came from the same withdrawal.
Compare the schedule with the approved donor budget. A withdrawal may have been authorised for a training activity, but that does not automatically make every attached receipt eligible. Check the activity, budget line, reporting period, procurement requirements and any donor restrictions.
Next, compare the total cash expenses in the schedule with the cashbook. Then compare bank withdrawals in the cashbook with the bank statement. These are two different checks. Receipt totals should agree with recorded cash spending, while withdrawal totals should agree with movements out of the bank.
Finally, keep the documents in a consistent order. A practical file starts with the bank statement, followed by the withdrawal slip, approval, batch cover sheet, numbered receipts, payment vouchers, cash return note and any exchange-rate evidence. Electronic folders can follow the same structure.
A spreadsheet can handle this work, but formulas and references still need review. Where it fits the organisation’s process, Honest Record can help match bank withdrawals, cash batches and receipt records, while the report preparer remains responsible for checking eligibility, explanations and donor rules.
- Confirm that every reported cash expense has support.
- Confirm that each receipt appears only once.
- Explain differences between withdrawal dates and payment dates.
- Carry forward unspent cash rather than reporting it as an expense.
- Keep a review trail showing who prepared and checked the report.
Questions
Should the bank withdrawal date or receipt date go in the donor report?
Usually, use the date the expense was actually paid, which is generally the receipt or payment voucher date. Keep the withdrawal date in the cashbook and batch reference. However, follow the donor’s reporting instructions if they require a different basis.
What if several withdrawals were mixed in one cash box?
Use a full cashbook reconciliation rather than forcing each receipt to match one withdrawal exactly. Show opening cash, all withdrawals, all payments, redeposits and closing cash. Batch references can still identify which activity or advance produced each receipt.
Can change left from a withdrawal be reported as an expense?
No. Unspent change remains cash belonging to the organisation or donor-funded project. Record it as cash on hand, an outstanding advance or a bank redeposit. It becomes an expense only when it is used for an eligible, supported payment.
What if the receipts add up to slightly less than the withdrawal?
Identify the difference and confirm whether it is cash still held, money returned, a bank fee, a rounding issue or an unexplained shortage. Document the answer. Do not increase a receipt or add a made-up expense to remove the difference.
Do all receipts need to be sent to the donor?
That depends on the agreement. Some donors request every receipt, while others request a schedule and inspect documents later. Even when receipts are not submitted, keep them organised and linked to the reported transactions for review or audit.
Treat each cash withdrawal as money transferred into cash, not automatically as an expense. Give it a batch reference, list the individual payments, account for change and reconcile the closing balance. Then build the donor report from eligible, supported receipts under the correct budget lines. This creates a clear path from the bank statement to the cashbook, receipt and reported amount.
Honest Record reads the statement and receipts, matches them, applies your fund's rules and verifies every row before the Excel exists. Free 14-day trial, no card.
Upload your first month free See a sample report