1. For Refunds
Clearly link the refund to the original transaction and state the reason.
Example Note:
MyCNBox: Maintaining Transparent Payment History for Full Financial Accuracy
2026-03-26
A practical guide to logging every transaction with detailed notes for a clear and accurate financial record.
The Importance of Transaction Transparency
In today's digital financial landscape, maintaining a clear and detailed payment history is not just good practice—it's essential for personal and business accountability. MyCNBox
Think of your transaction spreadsheet as the single source of truth
Building Your Master Spreadsheet: Core Columns
Start by creating a spreadsheet with the following essential columns. This structure is your foundation for transparency.
| Column Name | Purpose & Example |
|---|---|
| Date & Time | The exact timestamp of the transaction (e.g., 2023-10-27 14:30 UTC). |
| Transaction ID | The unique reference number from MyCNBox (e.g., TXN_789012). |
| Description | Brief purpose (e.g., "Service Payment from Client A", "Platform Top-up"). |
| Amount In | Funds received (in original currency). |
| Amount Out | Funds sent or spent (in original currency). |
| Currency | The currency of the transaction (e.g., USD, EUR, CNY). |
| Balance After | Your MyCNBox balance post-transaction. |
| NOTES | The most critical column for transparency (see details below). |
The Power of the "Notes" Column: Logging Special Cases
This is where you ensure full financial accuracy. Do not leave it blank. Use it to explain the why
Record the exchange rate used and any fees. This is crucial for calculating true cost. Example Note:
Document any manual corrections, bonus credits, or dispute resolutions provided by MyCNBox support. Example Note:
2. For Currency Conversions
3. For Adjustments
Best Practices for Ongoing Accuracy
- Log Immediately:
- Sync Regularly:
- Use Filters & Sorts:
- Backup Your File:
- Reconcile Monthly:
- Sync Regularly: