A purchase return can leave an expense log confusing if the original charge, refund, and tax are recorded as separate or mismatched entries. Use the steps below to preserve the transaction history, show the net cost accurately, and keep supporting documents together.
Start with the original transaction
Before entering a return, find the original purchase in your log and confirm what actually happened. A return may result in a refund to the payment method, a store credit, an exchange, a partial refund, or a supplier credit that will be applied to a later bill. These outcomes should not all be recorded as if cash came back immediately.
Gather the receipt or invoice, proof of return, refund confirmation, and any credit note. Check the purchase date, supplier, item or purpose, original amount, tax shown, and payment method. If the return covers only some items, identify the returned portion rather than reversing the whole purchase.
An expense log is a tracking record, not a substitute for complete bookkeeping or tax records. If your organization uses accounting software or a prescribed chart of accounts, follow its workflow and use the log as a companion record. For personal budgeting, the same method helps explain why a later bank deposit or card credit does not match the original expense.
Choose how to represent the return
There are two common approaches. The first keeps the original expense intact and adds a clearly labeled negative entry for the refund or credit. The second edits or reverses the original line. For a log that needs an audit trail, the first is usually easier to follow: it shows what was bought and what was subsequently returned.
Avoid deleting the original entry merely to make the net total look right. Deletion can hide when the purchase occurred, how it was paid, and why a later refund appeared. If an entry was genuinely a duplicate or a data-entry mistake, correct it according to your bookkeeping process and retain an explanation where practical.
| Outcome | Suggested log treatment | What to verify |
|---|---|---|
| Full refund to card or bank | Add a negative return entry | Refund amount and posting date |
| Partial refund | Add a negative entry for the returned portion | Which items and taxes were included |
| Store credit | Record the credit separately from cash received | Whether it is restricted or expires |
| Exchange | Record the new purchase and the return/credit | Difference paid or credited |
| Supplier credit on account | Record a credit against the supplier balance | How and when it is applied |
Use the date the return or refund occurred in the return line, and include the original purchase date or log reference. If your accounting system treats transaction date and posting date differently, keep both dates where the distinction matters.
Record a refund step by step
A useful return entry should explain the connection to the original purchase and how the money or credit was handled. Add a negative amount only if your log’s total formula treats negative values as reductions. If it does not, use a separate “Refunds and credits” column and subtract that column when calculating net expense.
- Locate the original line. Note its date, supplier, description, amount, tax, and payment method. Assign it a unique reference if your log does not already have one.
- Check the return evidence. Use the retailer’s return receipt, supplier credit note, refund email, or account statement. Confirm the returned items and amount accepted.
- Add a linked return line. Enter the return date, supplier, a description such as “Return of unopened supplies—original purchase 14 May,” and the original reference number.
- Enter the amount in the right direction. For a refund of $40, enter -$40 in a negative-entry log, or $40 in a dedicated refunds column. Do not use both methods at once.
- Separate tax when your records do. If the log tracks tax separately, use the refund documentation to identify the tax portion. Do not estimate a tax split when the receipt or credit note provides the amount.
- Mark the settlement method. Record whether the amount went back to a card, bank account, cash, store credit, or supplier balance. A credit is not the same as cash received.
- Attach or reference documents. Store the return proof with the original receipt, digitally or on paper, and write the file name or folder location in the log if useful.
- Reconcile later. Match the refund to the payment statement or supplier account when it appears. Note timing differences rather than changing the return amount to force a match.
For example, if a business buys office supplies and later returns one item, preserve the original purchase line. Add a second line with the returned amount as a reduction, link both lines, and use the supplier’s evidence to determine whether tax was also credited. The net expense is the original recorded cost less the documented credit, subject to your bookkeeping system’s treatment.
Handle sales tax with care
A return may reverse some or all of the tax associated with a purchase, but the correct treatment depends on the transaction, the documentation, and the buyer’s circumstances. In British Columbia, people and businesses may encounter different taxes and tax treatments, and not every purchase or seller is handled the same way. Do not assume a single percentage applies to every receipt or that the refund’s tax portion can be calculated by applying a rate to the total.
If the original receipt and return document show the tax amounts, preserve those figures in your records. For a purchase where tax was recorded separately, enter the corresponding documented tax adjustment in the relevant field. If the seller refunded only part of the purchase, check whether the credit note shows the tax adjustment for the returned items. If the seller’s paperwork is unclear, ask the seller for an itemized return or credit document rather than inventing a split.
For personal budgeting, you can simply track the total refund received and keep the receipt. For a business, tax reporting may depend on whether the purchase was eligible for a tax credit, how the original transaction was recorded, and whether the credit has been received or applied. Expense-log guidance cannot determine your particular filing treatment. Use the records and method required by your accounting system, and consult a qualified tax professional or the relevant tax authority when the treatment is uncertain or material.
A practical rule is to keep the original tax figure visible and record the return adjustment separately. This makes it possible to see both the original transaction and the change without erasing the history.
Plan purchases to make returns easier
A little planning can prevent incomplete return entries later. At purchase time, capture the supplier, date, business purpose, item description, amount, taxes shown, and payment method. For online orders, save the order confirmation and final invoice; the order confirmation may not be the final record if the seller ships items separately or changes the total.
Use a consistent naming convention for receipts, such as YYYY-MM-DD_supplier_amount.
For a return, retain the return authorization, shipping or drop-off confirmation, and final credit document.
If a supplier has not yet issued a credit, record the return as pending in a notes or status field; do not record an expected refund as money received.
For purchases made on a personal card for a business, record the actual payment method and follow the organization’s reimbursement procedure. A refund may return to the employee’s card, while the original expense was reimbursed by the business. That situation needs a clear note so the business does not treat the credit as cash it received.
Organize the log for quick reconciliation
A simple spreadsheet can include these columns:
- Transaction date
- Supplier or store
- Description and business purpose
- Original purchase reference
- Expense category
- Payment method
- Amount before tax, if tracked
- Tax amount, if tracked
- Total paid or credited
- Return or refund status
- Document reference
Keep one row per event: purchase, return, refund settlement, or later application of a supplier credit. If a return was initiated on one date and refunded later, the return line can note the initiation date while a separate settlement note or column records when the money arrived. Choose a convention and use it consistently.
At month end, compare the log with bank, card, cash, or supplier statements. Look for refunds that appear without matching return records and returns that have not yet appeared as credits. A pending refund is a follow-up item, not a reason to alter the purchase entry. Record the date you checked and any next action if the amount remains unresolved.
Restrict access to business logs and receipt folders to people who need them, and keep backups according to your ordinary records process. Avoid putting full card numbers, passwords, or unnecessary personal information in the log. A payment method label such as “business Visa ending 1234” is generally more useful than storing sensitive account details; omit the final digits too if your process does not need them.
Common problems and how to resolve them
The card statement shows a different amount than the receipt. Check for partial shipment, a separate shipping charge, an exchange, or a partial return. Use the seller’s final transaction documents and statement entries to explain the difference. Keep any currency conversion or card adjustment distinct from the seller’s refund amount.
The refund has not arrived. Keep the return marked pending and retain proof that the seller accepted it. Check the expected processing information provided by the seller or payment provider. If the delay exceeds what they indicated, contact the seller through its normal support route and record the follow-up. Do not mark a refund as received before it appears or the supplier confirms it has been applied.
The store issued credit instead of money. Record the credit as a credit, not as a bank deposit. When you use it, link the later purchase to the credit so the log shows how much was consumed and whether you paid any remaining balance. If the credit is unused, keep its status visible.
Only part of a bundle or order was returned. Use the itemized return record to identify the value and tax credited. If the seller gives only a total credit, retain that document and do not allocate it across categories without a defensible basis. Ask the seller for clarification if the allocation affects business records.
The original receipt is missing. Search email, the retailer’s account, card records, or an expense app for a duplicate. A bank statement can help establish payment but may not show item details or tax. Note what evidence is available and follow your organization’s documentation policy; do not recreate details from memory as though they were confirmed.
An exchange has no obvious net refund. Record the returned item and replacement item as linked events when your bookkeeping system supports it. Show any difference paid or credited. For a simple personal log, you may record only the net cost if that still answers your budgeting question, while retaining the documents that explain the exchange.
Know when a basic expense log is not enough
A spreadsheet is useful for visibility, but it may not capture inventory movements, accounts payable, employee reimbursements, or tax adjustments in the way formal books require. A business that tracks inventory may need to adjust inventory and cost records when goods are returned. A supplier credit may reduce an outstanding payable rather than create income. Software setups also differ: some expect a credit note, some a negative expense, and some a reversal linked to the original bill.
Use the accounting method already established for the business, and avoid entering the same credit in both the expense log and a system-generated import if those records feed the same totals. When the return crosses a reporting period, involves a large or unusual amount, affects inventory, or changes a tax claim, ask the person responsible for the books or a qualified tax professional how to classify it. The log should make the facts easy to verify; it cannot replace that judgment.