How to record partial Invoice payments and outstanding balances

Create the Invoice register

Enter a unique Invoice ID, the relevant Customer or work description, issued amount and date. Keep the bill’s actual total distinct from the balance that will change as payments arrive. Do not repeatedly replace that total with the amount still unpaid.

Use references that distinguish several bills for the same Customer. A name alone may be insufficient where payments relate to different properties or stages. Keep the original document available in your normal records so an allocation can be checked.

Confirm the amount’s basis before comparing it with receipts. A gross charged total and money actually received belong to a consistent payment view. The ledger cannot infer VAT treatment or convert an incompatible net amount into the correct balance.

A named bill without an amount remains incomplete. The known-total subtotal can contain the information entered so far, while the outstanding result is withheld where relevant rows need review. Read the check labels rather than treating a subtotal as complete accounts.

Enter each actual receipt

The receipt register records a unique receipt ID, Invoice ID, actual receipt date, amount, bank or evidence reference and note. Use it for money actually received, not a customer promise or an expected future transfer.

Keep separate receipts as separate entries even when they concern the same bill. The example records £400 and £600 against INV-001, allowing the allocation to total £1,000 without hiding the two events.

Retain enough evidence to identify the source, through your appropriate business records. A bank reference can help investigate the payment, but a customer name or amount alone may not establish which Invoice it concerns.

The file supports positive receipts. Refunds, credits and issued-document corrections need their actual supported process rather than an unexplained negative entry inserted to force a balance. Keep those records and their relationship available separately.

Allocate the receipt to an identifiable bill

The Invoice ID links the two registers. A receipt with exactly one matching bill can be allocated on that reference. If none matches, the row shows Unknown Invoice; if the ID belongs to several listed bills, the relationship is ambiguous.

Investigate an unknown or unassigned receipt before choosing an allocation. Do not apply it to the nearest outstanding amount simply because the figures fit. The actual payer information and evidence should support the decision.

If one bank transfer covers several Invoices, retain the source and create uniquely identified allocations whose sum matches the transfer. Recording the full bank amount against every bill would count the same money several times.

Keep the unresolved reference visible in the note while obtaining clarification. An unmatched payment is money to investigate, not proof that one specific Customer owes less. That distinction matters before the next balance message is sent.

Read the worked balances

The worked register lists £1,440 for INV-001, £6,000 for INV-002 and £750 for INV-003. Their entered totals sum to £8,190. These are demonstration records with no real Customer data.

INV-001 receives £400 and £600, leaving £440. INV-002 receives £2,000, leaving £4,000. INV-003 has no allocated receipt entered and shows £750 remaining.

The three outstanding balances sum to £5,190. All entered receipts sum to £3,100 because another £100 row uses INV-MISSING. Allocated receipts are £3,000, with that unmatched £100 kept separately for investigation.

Those two receipt totals answer different questions. One describes what was entered in the receipt table; the other describes money linked to the listed bills. Neither alone proves that a bank account has been reconciled or every transaction recorded.

Resolve duplicate and incomplete references

Try copying the worked R-001 receipt into a new row in a saved test copy, retaining the same ID. The duplicate check marks the repeated reference and completed balances are withheld. Renaming a copied row would not establish a second payment; you need source evidence of a distinct event. Use the check to investigate the transaction rather than make a larger receipt total look valid through different labels.

The receipt check flags a repeated receipt ID and missing required receipt information. A duplicate or incomplete active receipt withholds completed Invoice allocation so its amount cannot quietly improve the apparent balances.

Repeated Invoice IDs are also a review problem. Two bills under one reference make the receipt relationship unclear. Establish the actual documents and correct the source information before using the allocation result.

Do not delete an entry merely to make the checks disappear. A repeated ID may represent one transaction copied twice or two different receipts assigned the same identifier. Those situations require different corrections.

An unknown reference is not automatically a duplicate. Keep each check’s meaning clear while investigating. The sheet can expose the inconsistency, but the source evidence determines which bill or transaction the corrected record should describe.

Keep overpayments and corrections visible

If allocated receipts exceed the listed Invoice total, the remaining balance stays negative and the position is marked for review. The file does not hide the difference by forcing the result to zero.

Check whether the allocation, total or actual transaction explains that position. Money may concern another bill or a different arrangement. A negative balance is a question to resolve rather than automatic permission to refund or rewrite an issued document.

Use your actual supported correction, credit or refund process where required. Keep the original bill and payment evidence traceable. A manual change in a worksheet should not silently substitute for the commercial and financial records involved.

Use the balance for the next conversation

Review recent receipts and correspondence before following up payment. A reminder for £1,440 would be wrong for the worked INV-001 after £1,000 is allocated. The current £440 balance supplies a more accurate starting point.

If the Customer has also asked about an item, retain that question alongside the financial position. A correct amount does not itself answer the scope query. Choose who will provide the explanation before repeating a generic payment request.

Distinguish No receipt entered from a claim about what happened outside your records. The ledger only knows the entries supplied. Check missing transactions or allocations before treating that status as evidence that no money arrived.

Reconcile one part-paid Invoice

Choose one actual issued bill and identify the separate receipts you can support from evidence. Enter unique references and dates, resolve the checks and compare the calculated balance with the original document and source records.

Then inspect any unmatched receipt separately rather than use it to tidy the selected balance. The useful ledger connects money with identifiable bills while keeping the information still to establish visible.