For businesses managing numerous transactions, financial clarity is non-negotiable. FishGoo presents a streamlined method to unify your transaction tracking—ensuring accuracy and transparency across all recharges, refunds, and fees in one master sheet.
The Core Principle: A Single Source of Truth
Disparate logs and scattered spreadsheets invite error. The cornerstone of consistent accounting is maintaining one centralized, living document—your financial command center. This single sheet provides an real-time, holistic view of cash flow across all orders.
Structuring Your Master Financial Sheet
An effective sheet captures every monetary movement. Organize columns to create a clear audit trail for each order.
Essential Columns for Your Sheet:
| Column Header | Purpose & Data Format |
|---|---|
| Order ID / Reference | Unique identifier linking all financial activities to a specific order. |
| Date & Time | Timestamp of the transaction (YYYY-MM-DD HH:MM). |
| Transaction Type | Category: [Recharge / Refund / Platform Fee / Service Fee / Adjustment]. |
| Amount In | Positive figure for recharges, refunds received, or corrections. |
| Amount Out | Positive figure for fees, refunds issued, or deductions. |
| Payment Method | Channel used (e.g., Credit Card, PayPal, Bank Transfer). |
| Running Balance | Calculated field showing cumulative total per order. |
| Notes / Reason | Context for the transaction (e.g., "Refund for delayed shipment"). |
Tracking Different Transaction Types
1. Recording Recharges (Customer Payments)
- Log immediately upon confirmation from your payment gateway.
- Enter the full amount in the "Amount In"
- Tag with Transaction Type: "Recharge".
- Include the gateway reference in the Notes column for reconciliation.
2. Logging Refunds (Issued or Received)
- Refunds Issued:"Amount Out". Type: "Refund - Issued". Note the reason.
- Refunds Received:"Amount In". Type: "Refund - Received". Note the source.
- Always link to the original Order ID for traceability.
3. Accounting for Fees
- Dedicate specific types: "Platform Fee", "Processing Fee", "Service Fee".
- Record all deducted amounts in the "Amount Out"
- Log fees as they occur, not in batches, to maintain daily accuracy.
Best Practices for Transparency & Accuracy
Real-Time Entry
Update the sheet concurrently with each financial event. Delayed entries are the primary source of discrepancies.
Regular Reconciliation
Schedule weekly checks to match your master sheet totals against bank statements and platform dashboards.
Clear Categorization
Use consistent, predefined labels in the "Transaction Type" column. Avoid free-form text here.
Audit Trail
Never delete rows. If a transaction is voided, add a new correcting row with a note explaining the change.
The FishGoo Advantage
By consolidating all financial activity into a single, well-structured sheet, you transform chaotic multi-order management into clear, actionable accounting. This discipline ensures accurate bookkeeping, builds trust through transparency, and provides the reliable data needed for strategic business decisions. Start implementing your master sheet today—your future financial clarity depends on it.