Machining ACH remittance allocation worksheet
Trace one receipt to its supported invoice allocations.
No signup. Enter reference codes, add records and download a CSV. Entries stay in the browser tab. Filled fields do not establish completion, approval or compliance.
| Receipt reference | Confirmed buyer reference | Invoice reference | Proposed allocation | Remittance evidence reference | Unresolved difference | Office owner role |
|---|---|---|---|---|---|---|
| ACH-example-1 | Buyer-record-example | Invoice-example-A | 4800, illustrative | Review full receipt allocation | Bookkeeper-role |
- Starting records are fictional examples, not merchant evidence.
- Keep private documents and actual contacts in your approved business system. Use internal reference codes here.
- Missing required fields indicate an unresolved record. Filled fields do not prove authorization, completion, compatibility or compliance.
- Export to approved business storage. Browser edits are cleared on reload.
A bank receipt without an invoice reference needs investigation before you close a machining balance. Start with the recorded amount and payer evidence, then obtain the buyer’s remittance detail through the established accounts-payable contact. Do not assign the money to whichever open invoice happens to match. One transfer might cover several orders, a partial balance or a separately approved adjustment.
Use with this guide
machining buyer and invoice mapping
The machining buyer and invoice mapping connects the commercial references behind an allocation.
ACH return exception sheet
Use the ACH return exception sheet if the provider later reports a collection exception.
Browse the complete machine shop guides and worksheets.
Find the receipt without guessing the customer
Retrieve the actual bank or provider record and its available reference. Keep receipt timing, payer identity and allocation as separate questions. A familiar company description helps the investigation but does not establish the full invoice breakdown. Confirm whether the entry is an incoming transfer, a provider payout or another movement before recording customer payment. A processor payout might combine several unrelated collections.
When dealing with an unexpected payment, you should refer to your established accounts-payable contact for the buyer in question. Try to establish what remittance was made against the payment, and what invoice(s) and/or purchase order(s) it relates to. Do not release any confidential drawings in a bid to try and establish a basic payment question , the purchasing office will not be interested in such. Private bank records must be kept in a controlled business environment. The machining buyer and invoice mapping connects the commercial references behind an allocation.
Build an allocation record the bookkeeper understands
List the accepted invoices and open amounts linked to the confirmed buyer. Separate previously collected deposits, reviewed credits and new money. An invoice balance equal to the receipt is still a candidate until the allocation is supported. Record who owns the unresolved question and when to review the answer. Avoid marking the entire customer account paid while one receipt remains unidentified.
The remittance worksheet records the receipt reference, confirmed buyer reference, invoice reference, proposed allocation, evidence reference, unresolved difference and office owner. Use one row for each proposed allocation and internal codes only. The worksheet does not connect to a bank or validate a payer. Its completed fields describe your review record, not proof the underlying allocation is correct or the payment is irreversible.
Reconcile a fictional combined payment
Suppose a fictional buyer sends $7,200. Its remittance identifies $4,800 against one invoice and $2,400 against another. The allocations total $7,200 and leave no unexplained amount in this example. Recording the whole receipt against both invoices would falsely report $14,400 collected. Record one receipt with two allocations and retain the source reference linking them.
If the remittance instead lists $7,100 of allocations, the remaining $100 needs its own explanation. Do not call the difference a fee, tip or overpayment without evidence. Stripe describes ACH Direct Debit as a delayed-notification method with failure and dispute risk. That provider-specific documentation does not describe every incoming bank transfer or guarantee the finality of the receipt in your account.
Sources for this section: Stripe: ACH Direct Debit authorization and delayed payment risk
Close only the supported invoice balances
Work through any corrections using the accounting system’s supported allocation procedures and keep a full record of the original receipt, including the updated invoice balances. In particular, it’s very important to make sure that any remaining unallocated portion of the receipt is assigned to an office owner, so that someone else doesn’t subsequently allocate the same money.
Review recurring missing-reference receipts with the buyer and your payment provider. Ask whether the current collection process supports a clearer invoice reference or a separate remittance notification. Test the proposed change on the actual account before promising automatic matching. Your objective is a repeatable payment handoff with fewer unresolved receipts, not a claim that every ACH collection is free, immediate or immune from return. Use the ACH return exception sheet if the provider later reports a collection exception.
Primary sources
BlueFinch last reviewed these sources on October 4, 2026. Payment rules and state requirements can change.
Use this page for general business information. It is not legal, tax, or accounting advice.