Help Guide

Quick Start

The Freelancer Income Calculate and Timesheet Export tool helps you quickly calculate pre-tax income and export timesheet. Simply follow these steps:

Select a time range (Last Month, Current Month, Next Month, or Custom)
Choose start and end dates
Select your country/region (to determine holidays and currency)
If you have leave or overtime, add the corresponding date ranges
Select a salary type (Daily, Hourly, or Monthly) and enter the amount
Click the "Calculate Income" button

Feature Details

1. Time Range Selection

For quick selection, we provide the following options:

Last Month: Automatically sets to the first and last day of the previous month
Current Month: Automatically sets to the first and last day of the current month
Next Month: Automatically sets to the first and last day of the next month
Custom: Allows you to freely select any date range

Tip: If you manually modify dates, the time range will automatically switch to "Custom".

2. Country/Region Selection

After selecting a country/region, the system will:

Automatically identify statutory holidays for that country/region
Automatically display the corresponding currency (China: CNY, United States: USD, Europe: EUR)
Calculate income based on that country/region's workday rules

3. Leave Settings

If you have leave (unpaid days) during the calculation period, you can:

Select "Has Leave" as "Yes"
Click "Add Leave Range" to add leave date ranges
Choose "Full Day", "Half Day (Afternoon)", or "Half Day (Morning)"
Add multiple leave ranges

Note: Leave dates must be within the calculation date range, otherwise an error will be shown.

4. Overtime Settings

If you have overtime (paid) during the calculation period, you can:

Select "Has Overtime" as "Yes"
Click "Add Overtime Range" to add overtime date ranges
The system will automatically calculate overtime hours (default 8 hours per day)
You can manually adjust overtime hours (maximum 24 hours per day, equals 3 days)
Add multiple overtime ranges

Calculation Formula: 8 hours = 1 day, maximum 24 hours per calendar day = 3 days.

5. Salary Type

Three salary calculation methods are supported:

Daily: Enter your daily salary amount directly
Hourly: Enter your hourly rate, the system will automatically convert to daily (×8 hours)
Monthly: Enter your monthly salary, the system calculates using: Total Income = (Scheduled Workdays - Leave Days + Overtime Days) × (Monthly Salary ÷ Scheduled Workdays)

6. Viewing Results

After calculation, you can:

View total workdays and working hours
View total income (pre-tax)
View detailed paid days list and excluded dates list
Edit "Work Content" in the paid days table
Click "Export Results (Excel)" to export a detailed report

Frequently Asked Questions

Q: Why are certain dates excluded?

A: The system automatically excludes weekends and statutory holidays. You can view specific reasons in the "Excluded Dates" table.

Q: Why is monthly salary calculation different from daily/hourly?

A: Monthly salary calculation uses a special formula that considers scheduled workdays, leave days, and overtime days to ensure more accurate calculations.

Q: Can I calculate income across multiple years?

A: Yes, but the date range is limited to last year, current year, and next year. The system will automatically load holiday data for the corresponding years.

Q: What does the exported Excel file contain?

A: The Excel file contains: Basic information (country, currency, period, etc.), paid days details (date, days, note, work content), excluded dates details (date, reason, note).

Q: Is data saved to the server?

A: No. All calculations are performed locally in your browser, and data is not uploaded to the server. We only store your theme preference and holiday data cache locally.

Calculation Formulas

Daily/Hourly Calculation

Total Income = Workdays × Converted Daily Rate

Daily: Converted Daily Rate = Input Amount
Hourly: Converted Daily Rate = Input Amount × 8 hours

Monthly Calculation

Total Income = (Scheduled Workdays - Leave Days + Overtime Days) × (Monthly Salary ÷ Scheduled Workdays)

Where:

Scheduled Workdays = Total workdays in the calculation date range (excluding holidays and weekends, but not considering leave and overtime)
Leave Days = Total leave days you set
Overtime Days = Total overtime days you set (converted at 8 hours = 1 day)

Technical Support

If you encounter any issues while using the calculator, or have any suggestions, please contact us:

Email: bcboliverjames@gmail.com