Record all financial transactions to ensure consistency between your account balance and real expenses.
Why Consistent Record-Keeping is Essential
When using a shopping agent servicepersonal transaction spreadsheet
Setting Up Your Transaction Spreadsheet
Create a simple spreadsheet (using Google Sheets, Excel, or similar) with the following column headers:
| Date | Transaction Type | Description | Amount (USD/¥) | Running Balance | LoveGoBuy Order # / Note |
|---|---|---|---|---|---|
| 2023-10-26 | Payment In | Account Top-Up | +100.00 | 100.00 | Payment via PayPal |
| 2023-10-27 | Payment Out | Product Payment | -25.50 | 74.50 | Order #LOVEGO12345 |
| 2023-10-28 | Refund In | Item Refund | +15.00 | 89.50 | Refund for cancelled item |
Step-by-Step Logging Process
1. Recording Payments (Money Added to Your LoveGoBuy Balance)
Whenever you top up your account via PayPal, credit card, or other methods:
- Log the Date
- Set Transaction Type
- Write a clear Description
- Enter the Amount
- Update the Running Balance
- Add any transaction ID from the payment method as a note.
- Set Transaction Type
2. Recording Expenses (Payments for Orders & Shipping)
When LoveGoBuy deducts money for product purchases, service fees, or shipping:
- Log the Date
- Set Transaction Type
- Write a detailed Description
- Enter the Amount
- Update the Running Balance.
- Always include the LoveGoBuy Order Number
- Set Transaction Type
3. Recording Refunds (Money Returned to Your Balance)
When you receive a refund for a cancelled item, a service fee, or a shipping overpayment:
- Log the Date
- Set Transaction Type
- Describe the source
- Enter the Amount
- Update the Running Balance.
- Reference the original Order Number the refund is associated with.
- Set Transaction Type
Security and Consistency Tips
- Verify Daily:
- Save Receipts:
- Use Formulas:
Example Formula (Cell E3): =E2 + D3- Regular Reconciliation:
- Save Receipts: