Stop duplicate vendors from splitting a property's project costs

Duplicate vendor records make one contractor look like two suppliers. That can split a property’s costs, hide open documentation and make a project report harder to review. Use one vendor identity card, then assign each transaction to its property or project.

Build the vendor identity card

Before someone adds a vendor, keep a short card with the legal or trading name, remittance address, contact email, phone, tax-document status where applicable, and the name the company uses on invoices. This card identifies the company; it does not decide the accounting or tax treatment of a cost.

Keep invoices, approvals and payment support with the project file. The IRS says business records should support income and expense items, so a clean vendor name should accompany rather than replace the underlying documents.¹

Search before creating a vendor

Use a repeatable check before a new entry:

1. Search the accounting file for the business name and its common abbreviation.
2. Search by email, phone or remittance address when the name is close but not exact.
3. Check the open invoice list and the current project report.
4. If the company already exists, use that record and put the property identity on the transaction.
5. If it is genuinely new, create the record from the identity card and record who entered it.

QuickBooks Online allows vendor records to be added and later merged when duplicates are found, subject to the product’s current workflow.² A merge is a controlled cleanup step, not a quick fix to take after payments are entered.

Put the property assignment on the transaction

Vendor identity and project allocation solve different questions. The vendor answers “who supplied the work?” The project field, property ID, class, customer/job, or approved equivalent answers “which investment received it?”

Illustrative example. Bright Wire Electric invoices $2,400 for electrical rough-in at FL-427 and $1,180 for a panel at FL-431. The team uses one Bright Wire vendor record. Each invoice carries its own property ID, document link and approval status. The project report can now show $2,400 and $1,180 separately without turning the same electrician into two vendors.

Use the same property ID that appears in the weekly flip cost snapshot. When a deposit and final invoice belong to the same scope, the contractor deposit guide can help the reviewer keep the evidence trail together.

Clean up an existing duplicate carefully

First list every open bill, unapplied credit, recent payment and attached document under both names. Decide the surviving vendor record, preserve the evidence trail and have the responsible accounting reviewer confirm the plan. Intuit documents a vendor-merge process; review its current instructions and the effects in your file before applying it.³

Afterward, run the active-project report and open-payables report. Investigate a changed project total, missing attachment or unmatched payment before treating the cleanup as complete.

Make it a monthly control

Once a month, review new vendors, same-address vendors, and suppliers whose names differ only by punctuation or “LLC.” Put unresolved matches on a short exception list with an owner and due date. The goal is not a perfectly uniform spelling; it is a report where each supplier’s activity can be traced to the right property and source documents.