1. Recording a Standard Refund
When processing a refund for a previous sale:
- Date:
- Transaction ID:
- Description:
- Amount:NEGATIVE
- Type:
- Balance:
- Notes:
- Transaction ID:
OrientDig: How to Record Refunds and Balance Changes in the Spreadsheet
2026-03-13
Maintaining clear and transparent financial records is crucial for any business. In the OrientDig system, accurately logging refunds and balance adjustments in your master spreadsheet is key to avoiding confusion and ensuring accounting integrity. This guide outlines the recommended process.
The Importance of Detailed Tracking
Without a systematic approach, refunds and ad-hoc adjustments
Recommended Spreadsheet Structure
Ensure your OrientDig ledger has, at minimum, the following columns for effective tracking: Date, Transaction ID, Description, Customer/Client Name, Amount, Type (Sale/Refund/Adjustment), Balance, and Notes.
Step-by-Step Recording Procedure
2. Recording Non-Refund Balance Adjustments
For corrections, fees, or credits not tied to a specific sale:
- Date:
- Transaction ID:
- Description:
- Amount:
- Type:
- Notes:
- Transaction ID:
Best Practices for Transparency
- Link Transactions:
- Immediate Entry:
- Monthly Reconciliation:
- Consistent Format:
- Immediate Entry:
Quick Example
| Date | ID | Description | Amount | Type | Balance | Notes |
|---|---|---|---|---|---|---|
| 2023-10-26 | INV-100 | Sale - Product A | $100.00 | Sale | $100.00 | Paid via Stripe |
| 2023-10-28 | INV-100-REF | Refund for Product A | -$100.00 | Refund | $0.00 | Customer cancellation. Ref to INV-100. |
| 2023-10-30 | ADJ-005 | Adjustment - Bank Fee Reversal | $20.00 | Adjustment | $20.00 | Bank error correction per statement. |
By following this structured approach in your OrientDig spreadsheet, you create a single source of truth for all financial movements. This discipline is the foundation for transparent accounting, informed decision-making, and long-term business clarity.