...
Here you can check total balance, positive and negative accounts for necessary date and the whole period, and use functional calculation of profits.
Reports
You can check balance on all website users here:
Bill itemization
You can export all operations on users' accounts for certain period in this section:
Description
Tab contains 2 sections: filter by date and table with results:
Filter by date
Click dropdown list to view data for certain period:
Choose necessary option from dropdown list:
Chosen interval period will be shown below in dates fields:
Click ”Apply” button:
Click date field to set date range manually:
You can enter value from the keyboard or select from drop-down calendar:
Do the same thing with interval end date and click ”Apply” button:
Data table
All operations for chosen time period are available in the table with the following fields:
- Date – shows date and time of operation.
- Login – user login with whose account the operation was. You will be transferred to user personal page if you click login.
- Sum – shown in website internal currency. Green is deposit and red is withdrawal.
- Note. You can leave a comment on order page during deposit and withdrawal operations. This comment will be available here. A standard phrase (Order payment, Manual correction, etc.) is written if there is no comment.
...
Click ”Export” button to export data for certain time period:
See higher to check how to choose time period.
It's possible to open results or save them in xls-file:
Calculation of profits (Section is under construction)
...
This functional is a table divided by months. You can view each month by day. Some values can be adjusted at any time in hindsight any number of times.
Choose period
Click date field to set date range manually:
You can enter value from the keyboard or select from drop-down calendar:
Apply the same actions with end date of interval and click ”Apply”:
Export
Click ”Export” to export data for certain period:
See higher to check how to choose time period.
...
- Date – dates are grouped by months and days.
- Income Amount – amount of receipts to customers' personal accounts per day, including refunds from cancellations (in website internal currency).
- Providers – added if there are goods from different trade providers (Taobao, Warehouse, 1688, Yahoo Japan, etc.).
- Currency – currency is indicated if receipts were in different currencies.
- Orders Reserved Amount – amount withdrawn from customers' personal accounts for orders (in website internal currency).
- Number of purchases – the amount of costs for the redemption of goods of Goods Provider (Taobao). Includes shipping within China (yuan).
- Exchange rate – website internal currency exchange rate to yuan.
- Purchase Amount – the amount of redemption costs (in website internal currency).
- External Delivery Amount – delivery expenses (for example: agent sent parcels, trunks, packed a truck during a day and wrote into this column – delivery expenses for this day were: … I paid them on post or gave to truck driver).
- Revenue – difference between funds credited for orders and expenses for buying goods and external delivery.
- Percentage of Profit – percentage of income received from expenses for buying goods and external delivery.
Choice
Select period for viewing and editing in calendar:
View necessary date in column ”Date”:
Click necessary date. Detailed description will open:
Edit
It's possible to edit some fields in operations detalization on profit calculation. Field is available for editing if it is marked blue dotted:
Click blue dotted value to edit it:
Add necessary value in opened window:
Save selection with check mark:
You can close it without changes by clicking the cross:
