Small business guide
How to keep customer purchases and money records separate, but connected
Keep a record of what the customer purchased and a separate record of money actually received or paid. Link them by reference, then choose the relevant record for each question. This general method works with paper or a spreadsheet; it is not a product tutorial, accounting or tax advice, a debt-management plan, or a way to execute payments.
Start with two different questions
A customer purchase record describes who bought what and when. Include a date, customer reference, item or service, quantity, purchase amount and notes. A money record answers a different question: did money actually move? Record its date, incoming or outgoing direction, amount, payment method and the reference of any related purchase.
Completing a purchase or service does not establish that money arrived at the same moment. Only add an incoming money record after checking the actual receipt, and keep the two dates distinct when necessary. A customer reference may be enough for identification; do not add unrelated personal details just because a sheet has room for them.
Connect references instead of adding both amounts
Example: customer A receives a service priced at 300 yuan. Give the purchase record the reference C001. After checking that 300 yuan was received that day, add an incoming money record linked to C001. These are two views of one event, not two receipts. Adding them together would incorrectly produce a total of 600 yuan.
Check the date, description and source before linking records; equal amounts alone are not enough. A payment for shop supplies can stand on its own without a customer purchase. If a connection is uncertain, leave a review note. An honest gap is more useful than a guessed reference that makes the spreadsheet look complete.
Review duplicates and gaps while events are fresh
Review money records by the date money actually moved and compare each one with evidence you can check. Two entries on the same day with the same amount may still be different events. Read their descriptions and sources before removing anything. A purchase without a confirmed receipt is a difference to explain, not a reason to invent an incoming entry.
Keep the original reference, a reason for correction and a review date. If an amount changes from 30 to 300, someone reading it later should be able to understand why. A correction note is sufficient for a simple sheet. Back up important records before changing columns or making bulk edits so that the original context remains recoverable.
Name the question before choosing a total
Use purchase records to answer which services a customer has bought. Use money records to answer how much was actually received or paid today. State the date range and record type before calculating a total. Do not combine the two tables indiscriminately or treat a simple incoming-minus-outgoing figure as formal profit or a tax conclusion.
Keep consistent column names and an export copy so the records remain understandable if you change tools; OpsSense is in development around these everyday customer-purchase, money-record and human-confirmation tasks.