A customer transfers S$28,000 into the company’s bank account. Several invoices are outstanding, but the payment reference contains only the customer’s name. Finance records the receipt, sales assumes the overdue account has been settled, and the collection report continues to show unpaid invoices.
When the next statement goes out, the customer objects. They believe payment has already been made, while the company cannot explain which amounts remain due. A receipt that should have improved the relationship instead creates uncertainty, repeated enquiries and potentially an unnecessary credit hold.
Gekonnt provides accounting services, including financial analysis and advisory support. For businesses receiving lump-sum customer payments, reliable reporting depends on connecting each receipt to the obligations it settles. Recording money in the bank is only part of the process. Management also needs to know what remains collectible and why.
Separate Receipt Recording From Invoice Allocation
A bank receipt confirms that money reached the company’s account. It does not necessarily identify the invoices paid or establish that the customer has settled every outstanding amount.
Record the receipt promptly using the information available and an appropriate accounting treatment. Do not delay recognising the bank movement merely because invoice allocation is incomplete. Keep the unresolved allocation visible so it can be investigated.
Equally, avoid recording an unidentified customer receipt as new revenue simply to complete the bank reconciliation. The revenue may already have been recorded through invoices, or the payment may relate to a future order, a deposit or another arrangement.
The company needs two connected controls: one confirming that the receipt is recorded accurately, and another establishing how it affects the customer’s account. Completing the first does not automatically complete the second.
Confirm Who Actually Made the Payment
The name on the bank statement may not match the customer name in the sales ledger. A parent company may pay for a subsidiary, a shared service centre may settle several accounts, or the bank may display an abbreviated trading name.
Check the payer’s identity using the transaction details and customer correspondence. Establish which legal entity owes the invoices and whether the payment has been made on its behalf.
Where several group companies are involved, do not allocate money across their balances solely because their names are similar. Confirm the intended settlement and ensure the records reflect the relevant entities and arrangements.
This initial check can prevent a difficult correction later. Allocating a receipt to the wrong customer may make one account appear settled while another continues receiving collection reminders despite having paid.
Ask for a Remittance Breakdown That Can Be Used
A request saying “please clarify your payment” may produce another incomplete response. Send the customer the payment date, amount and reference, and ask for the invoice numbers and amounts included.
Where deductions have been made, request the reason and supporting reference. A customer may have applied a credit note, withheld a disputed charge or deducted an amount they believe was agreed with the sales team.
Give the customer a clear contact point for remittance advice. If details are sent to individual salespeople, establish how those messages reach finance. Information should not remain dependent on one employee checking their inbox.
Retain the breakdown with the receipt record. Another team member should be able to understand the allocation without reopening the entire correspondence trail.
A Lump-Sum Payment Can Contain Several Different Decisions
Consider a hypothetical customer with three outstanding invoices: S$12,000, S$10,000 and S$8,000. The customer pays S$28,000 against the S$30,000 total.
Finance might assume the customer has paid the first two invoices in full and S$6,000 against the third. However, the remittance advice could show that the customer applied an agreed S$2,000 credit against the first invoice and paid the remaining amounts in full.
If the credit is valid and appropriately recorded, all three invoices may be settled. Without that information, the company could continue chasing S$2,000 that is no longer due.
Alternatively, the customer may have deducted S$2,000 without agreement because of a disputed delivery. That requires investigation and an accounting assessment; it is not automatically an approved discount.
The same receipt can therefore produce different outcomes. The allocation should follow supported facts rather than whichever combination makes the ledger easiest to clear.
Do Not Automatically Apply Every Receipt to the Oldest Invoice
Applying payments to the oldest invoices may be part of an established process where consistent with the relevant terms and payment instructions. It should not override clear customer information without review.
A customer may deliberately settle recent, undisputed invoices while an older invoice remains under discussion. Allocating the receipt to the oldest balance could hide that dispute and make the collection report misleading.
It can also affect operational decisions. A salesperson may believe the oldest problem has been resolved and approve more credit, while the customer continues to challenge the same transaction.
Where payment instructions are absent or unclear, follow the company’s approved process and obtain clarification where needed. Preserve the basis for the allocation, including any provisional treatment, rather than presenting an assumption as confirmed fact.
Investigate Short Payments Before Clearing the Difference
A payment below the invoice total can arise from several causes. The customer may have taken a settlement discount, applied a credit, deducted bank charges or withheld an amount because of a dispute.
Identify the cause before using a general write-off or discount account. Small differences can accumulate into a meaningful reporting problem if they are routinely cleared without explanation.
Check whether the deduction was authorised and whether the relevant agreement supports it. If sales promised a concession but finance never received it, the issue includes an internal communication failure as well as a customer reconciliation.
The accounting response should reflect the substance. A valid price adjustment, a processing charge and a disputed receivable are different matters. An unresolved difference should have an owner and a next action rather than remain indefinitely described as “short paid”.
Keep Foreign Currency and Bank Charges Separate
Cross-border payments can introduce differences between the invoice currency, the amount sent and the amount credited to the bank. An exchange movement is not necessarily a customer short payment.
Compare the original-currency amounts and review the bank’s transaction information. Establish whether intermediary or receiving-bank charges affected the receipt and what the payment terms say about responsibility for those charges.
Avoid using the reporting-currency difference alone to determine whether an invoice has been settled. The accounting records may translate the invoice and receipt at different rates while the customer has paid the agreed foreign-currency amount.
Keep the calculation and supporting evidence with the allocation. This allows finance to explain the exchange or fee component without repeatedly asking the customer to prove payment.
Distinguish Overpayments From Future-Order Deposits
A receipt larger than the outstanding invoices may represent an overpayment, a duplicate payment or money intended for a future order. The surplus should not automatically be recognised as income.
Ask the customer how the excess should be treated and review the underlying arrangement. A future-order deposit needs to connect to that order, while an amount refundable to the customer requires an appropriate settlement process.
If a refund is agreed, verify the original receipt and follow the company’s payment controls. Do not transfer money to a newly supplied account solely because an email requests it.
Track any amount retained as customer credit. When it is applied later, link the use to the original receipt so the same credit cannot be used again or forgotten in a separate spreadsheet.
Make Collection Reports Show the Uncertainty
An aged receivables report can overstate the amount to chase when known receipts remain unallocated. It can also understate specific overdue invoices if credits have been applied incorrectly.
Show material unallocated receipts alongside the relevant customer balances where the payer is established. Staff need to understand both the invoices still open in the system and the money already received.
This operational presentation does not automatically determine the financial statement treatment or permit balances belonging to different parties to be offset. Finance still needs to assess the appropriate classification and presentation.
Before issuing reminders or applying credit holds, review known allocation exceptions. A brief internal check can prevent a customer from being pursued for an amount they have already paid and allow attention to remain on genuinely outstanding debts.
Remove Already-Received Cash From Collection Forecasts
Unallocated receipts can distort cash planning as well as customer statements. If a receipt is included in the current bank balance while the related invoices remain in the forecast as future collections, management may count the same cash twice.
Review significant receipts against the collection forecast before finalising it. Where allocation is incomplete, identify the amount already received and avoid assuming all open invoices will generate additional cash.
Keep disputed deductions separate from expected collection dates. A forecast should reflect the latest evidence about what remains due and when it is likely to arrive.
Gekonnt’s financial analysis and advisory support connects to this practical need for dependable information. Clear customer reconciliations help management distinguish available cash from amounts still expected, improving the basis for spending and funding decisions.
Use Automation With Reviewable Matching Rules
Accounting software can suggest matches based on invoice numbers, amounts and customer references. These suggestions can reduce manual effort, but repeated invoice values or incomplete payment references can create false matches.
Set rules that reflect the company’s actual transactions. Exact references may support straightforward matching, while multi-invoice payments, deductions and payments from another entity should receive appropriate review.
Retain an audit trail of allocations and later changes. If a receipt is moved between invoices, the records should show what changed and why. Silent changes make historical customer statements difficult to explain.
Review recurring exceptions rather than accepting them as unavoidable. A change to invoice references, customer instructions or data imports may remove the cause of repeated manual work.
Make Unallocated Receipts Part of the Monthly Close
Prepare an outstanding-receipts schedule showing the amount, date, payer information, current status and responsible person. Reconcile it to the ledger and investigate older items.
Measure age from the original receipt date. Transferring an item to another account or assigning it to a new employee should not make it appear recently received.
Prioritise material amounts and items affecting customer relationships or reporting. An unidentified receipt deserves investigation, but it may require different evidence from a known customer payment awaiting a detailed remittance.
ACRA’s financial reporting guidance emphasises complete and accurate records and directors’ continuing responsibility for the financial statements. A documented allocation process supports that responsibility by making customer balances more understandable.
Give Each Exception a Clear Route to Resolution
Finance may need help from sales, account managers or the customer’s payment team. Define who follows up and when unresolved items should be escalated.
A useful action is specific: obtain the remittance for a particular receipt, confirm an agreed credit or establish which group entity made the payment. “Check with customer” is too vague when the same note appears every month.
Preserve evidence when staff leave or customer contacts change. A shared record prevents completed work from being lost and allows the next person to continue from the actual status.
Gekonnt’s accounting services can support the consistent records behind this process. Management and operational teams still need to provide the commercial information that explains deductions, disputes and payment arrangements.
Complete the Payment Story
Receiving money is positive, but the records should explain what that money settles. Without reliable allocation, the business can chase paid invoices, overlook disputes and overestimate future collections.
Start with the payer and remittance evidence, investigate differences and connect the final allocation to the original receipt. Keep unresolved items visible until the accounting and customer records agree on a supported position.
Speak with Gekonnt about its accounting, financial analysis and advisory services if unallocated receipts are making collection reports difficult to trust. A consistent process helps turn a bank deposit into clear information about what the customer has paid and what the business is still owed.