OrientDig: How to Record Refunds and Balance Changes in the Spreadsheet
2025-11-16
Maintaining clear and accurate financial records is crucial for any project. This guide will walk you through the process of recording refunds, credits, and balance adjustments in your OrientDig spreadsheet, ensuring transparent accounting and eliminating confusion.
Why Detailed Record-Keeping Matters
Proper documentation of financial adjustments helps you:
- Track Project Finances Accurately:
- Maintain Transparency:
- Avoid Errors & Discrepancies:
- Simplify Audits:
- Maintain Transparency:
How to Record a Refund
A refund occurs when money is paid back to a customer or client. Follow these steps in the designated 'Refunds & Adjustments' sheet or section of your OrientDig spreadsheet
- Date:
- Description:
- Refund Amount:-150.00) to clearly indicate an outflow of funds.
- Reference/Transaction ID:
- Recipient/Client Name:
- Reason for Refund:
- Description:
Example Refund Entry
| Date | Description | Amount (USD) | Client Name | Reason |
|---|---|---|---|---|
| 2023-10-26 | Refund for Premium Plan - Annual Subscription | -299.00 | ABC Corp | Early Termination |
How to Record Other Balance Adjustments (Credits/Debits)
Not all balance changes are refunds. Sometimes you may need to apply a credit (adding funds) or a debit (deducting funds) to an account for various reasons.
- Credit (Positive Adjustment):positive
- Debit (Negative A t Adjustment):negative
ctio Example Balance Adjustment Entry
sDate Description Amount (USD) Client Name Type 2023-10-25 Goodwill Credit for Service Interruption +50.00 XYZ Ltd. Credit 2023-10-24 Adjustment for Bank Transfer Fee -25.00 Jane Smith Debit - Debit (Negative A t Adjustment):negative
y
s h">
e Step-by-Step Workflow for Accuracy
- Identify th lete Need:
e
- Gather Information:
- Open the Spread a she n et: er e
- ni Enter a New Row: k
- nal Review o e and Save:
one fe - Gather Information:
Pro n Tips i for Clarity
to
rt Be Consistent:
up lx L x Use Data Validation:Link to Original Invoices:> oSrong>Negative Formatting:
g a < < >Regular Reconciliation:
nt fi in />
onal rime xo res f n rfl g class c >
ml xain
c>
o>
nt ntp y, lan lseitli stha l stigtr tyi span