TaxManager Complete User Guide

Introduction

Welcome to TaxManager, a secure, web-based tax return management system designed specifically for Pakistani tax consultants and their clients. This guide will walk you through every feature and help you make the most of the platform.

What You Can Do

• Create and manage tax returns for multiple years
• Enter financial data with automatic reconciliation
• Upload and manage encrypted attachments
• Import/export data via CSV files
• Create complete encrypted backups
• View multi-year reconciliation summaries
• Access comprehensive help and support

Getting Started

Registration

To create your account:

1. Visit the login page and click "Register"
2. Fill in your details:
   • Name: Your full name
   • Email: A valid email address (you'll need to verify it)
   • Password: Minimum 8 characters, mix of letters, numbers, and symbols
   • CNIC: Your Computerized National Identity Card number (encrypted)
   • NTN: Your National Tax Number (encrypted, optional)
   • Phone: Your contact number (encrypted)
3. Click "Register"
4. Check your email for a verification link
5. Click the verification link to activate your account

Login

Once registered and verified:

1. Enter your email and password
2. Click "Sign In"
3. If you have 2FA enabled, you'll be prompted to enter your authentication code
4. You'll be redirected to your dashboard

Two-Factor Authentication (2FA)

For enhanced security, enable two-factor authentication:

1. Click your profile icon in the top-right corner
2. Select "Profile"
3. Find the "Two-Factor Authentication" section
4. Click "Enable 2FA"
5. Scan the QR code with your authenticator app (Google Authenticator, Authy, etc.)
6. Enter the 6-digit code from your app to confirm
7. Save your backup codes in a secure location

Creating Your First Tax Return

After logging in, you'll see the Tax Returns dashboard. To create a new return:

1. Click the "Create Tax Return" button (usually in the top-right)
2. Enter the tax year (e.g., 2026)
3. Click "Create"
4. You'll be taken to the spreadsheet view for that year

Understanding the Dashboard

The dashboard displays:

• Year: The tax year
• Status: Draft or Submitted (dropdown to change)
• Total Income: Sum of all income entries
• Net Assets: Total Assets minus Total Liabilities
• Reconciliation: Badge showing if the return is balanced or unbalanced
• Actions: Edit, Delete, and Reconciliation Summary buttons

Understanding the Spreadsheet

The spreadsheet is the heart of TaxManager. It's divided into 8 categories, each serving a specific purpose in the tax calculation.

Categories Explained

1. Opening Balances

Cash and cash equivalents at the start of the tax year:

• Cash in hand
• Bank accounts (savings, current)
• Prize bonds
• Other liquid assets

2. Assets

Everything you own with monetary value:

• Real Estate: Residential, commercial, agricultural property
• Vehicles: Cars, motorcycles, etc.
• Investments: Stocks, mutual funds, bonds
• Bank Deposits: Fixed deposits, term certificates
• Personal Effects: Jewelry, electronics, furniture
• Other Assets: Any other valuable possessions

3. Liabilities

Debts and obligations you owe:

• Bank loans (home, car, personal)
• Credit card balances
• Tax payable
• Other liabilities

4. Income

All sources of income during the tax year:

• Salary: Government, private sector
• Business Income: Profit from business activities
• Rental Income: Income from property rentals
• Capital Gains: Profit from selling assets
• Online Income: Freelancing, e-commerce, etc.
• Other Income: Gifts, inheritance, etc.

5. Documented Expenses

Expenses with proof (receipts, invoices):

• Rent payments
• Utility bills (electricity, gas, water)
• Education fees
• Medical expenses
• Insurance premiums (excluding life insurance)
• Other documented expenses

6. Undocumented Expenses

Daily living expenses without formal receipts:

• Kitchen/groceries
• Clothing
• Medical (out-of-pocket)
• Transportation
• Entertainment
• Gifts and donations
• Balancing Expense: Auto-calculated to reconcile the return

7. Income Tax Expense (Auto-Calculated)

This is automatically calculated based on:

• Withholding tax (WHT) paid during the year
• Tax payable for the current year
• Tax receivable/refundable
• Previous year's tax position

Note: This field is read-only and cannot be manually edited.

8. Advance Tax (Withholding Tax)

Tax deducted at source on various transactions:

• WHT on salary
• WHT on bank transactions
• WHT on property transactions
• WHT on online income
• Other advance tax payments

Data Entry

Entering data is straightforward:

1. Add a new row: Click the "+ Add Row" button in any category section
2. Select Nature: Choose the appropriate nature from the dropdown (e.g., "Salary Government", "Real Estate Residential")
3. Enter Description: Add a brief description (e.g., "Honda Civic 2020", "Apartment DHA Phase 5")
4. Enter Amount: Input the monetary value
5. Save: Changes are auto-saved as drafts. Click "Permanent Save" to finalize

Historical Data Comparison

The spreadsheet shows up to 3 previous years of data side-by-side:

• Current Year: The year you're working on
• Prev 1: Previous year (e.g., 2025 if current is 2026)
• Prev 2: Two years ago
• Prev 3: Three years ago

This helps you:

• Track changes in assets and liabilities over time
• Identify trends in income and expenses
• Ensure consistency in your reporting

Reconciliation

Reconciliation ensures your tax return is mathematically correct. The system checks if your financial position makes sense based on the fundamental accounting equation.

The Reconciliation Formula

TaxManager uses a sophisticated tax-aware formula:

In simple terms:

• A represents how much your wealth actually changed
• B represents how much money you should have generated based on your income and expenses
• If A = B, your return is perfectly balanced
• If A ≠ B, there's a discrepancy that needs to be explained

Balancing Expense

When your return is unbalanced, the system calculates a "Balancing Expense" to make it balance. This represents unexplained changes in your financial position.

To apply the balancing expense:

1. Look at the top-right of the spreadsheet
2. You'll see a status indicator (green "Balanced" or red "Unbalanced")
3. If unbalanced, click the "⚖️ Apply" button
4. The system will automatically calculate and insert the balancing expense
5. The status will turn green, indicating the return is now balanced

Negative Balancing Expense:

Sometimes the balancing expense is negative. This is mathematically valid and means you need to reduce your total expenses (or increase income) to balance the return. The system handles this automatically.

Attachments

You can upload supporting documents (receipts, statements, contracts) for any entry in your tax return.

Uploading Attachments

1. In the spreadsheet, locate the row you want to attach files to
2. Click the 📎 (paperclip) icon in the "Files" column
3. A modal will open showing existing attachments (if any)
4. Click "Upload New Attachment"
5. Select your file (PDF, JPG, PNG, XLSX, CSV - max 5MB)
6. Click "Upload"
7. The file is encrypted and stored securely

Viewing Attachments

1. Click the 📎 icon for the row
2. You'll see a list of all attachments for that entry
3. Click "View" to download and open the file

Deleting Attachments

1. Click the 📎 icon for the row
2. Find the attachment you want to delete
3. Click "Delete"
4. Confirm the deletion

CSV Import/Export

TaxManager supports importing and exporting data via CSV files, making it easy to work with Excel or other spreadsheet applications.

Exporting Data

1. In the spreadsheet view, click the "Export CSV" button (usually in the header)
2. The system will generate a CSV file containing:
   • All tax years
   • All entries with their descriptions and amounts
   • Historical data columns
   • Special system rows for balancing and tax expense
3. The file will download automatically
4. Open it in Excel or any spreadsheet application

Importing Data

1. In the spreadsheet view, click the "Import CSV" button
2. Select your CSV file
3. Choose import mode:
   • Merge: Updates existing entries and adds new ones (recommended)
   • Replace: Deletes all existing data and imports fresh (use with caution)
4. Click "Preview" to see what will be imported
5. Review the preview:
   • 🟢 Green rows: New entries to be added
   • 🔵 Blue rows: Existing entries to be updated
   • 🔴 Red rows: Errors (invalid data, missing nature)
6. If everything looks correct, click "Execute Import"
7. The system will process the data and update your return

Two-Pass Import Logic

The import system uses a sophisticated two-pass approach:

1. Pass 1: Import current year data and save to database
2. Pass 2: Import other years' data, matching entry codes across years

This ensures that entry codes are preserved and reused consistently across all years, maintaining data integrity.

Backup & Restore

TaxManager provides a comprehensive backup system that creates a single encrypted file containing ALL your data.

Creating a Backup

1. From the dashboard, click "Backup All My Data"
2. The system will generate a .bak file containing:
   • All tax years
   • All financial entries
   • All attachments (encrypted)
   • User profile information
3. The file will download automatically
4. Store it in a secure location (external drive, cloud storage, etc.)

Restoring from Backup

1. From the dashboard, click "Restore Backup"
2. Select your .bak file
3. Click "Restore"
4. The system will:
   • Decrypt the file
   • Create any missing tax years
   • Update existing entries
   • Restore all attachments
   • Recalculate system rows (tax expense, balancing expense)
5. You'll see a success message when complete

Dashboard Features

The dashboard provides a comprehensive overview of all your tax returns.

Dashboard Columns

Action Buttons

Each row has three action buttons:

• 🔗 Reconciliation Summary: Opens a multi-year reconciliation view
• ✏️ Edit: Opens the spreadsheet for that year
• 🗑️ Delete: Deletes the entire tax year (with confirmation)

Reconciliation Summary

Click the reconciliation icon to view a professional, multi-year financial statement:

1. Shows current year + 3 previous years
2. Displays:
   • Total Income
   • Less: Documented Expenses (excluding life insurance)
   • Less: Undocumented Expenses (including balancing expense)
   • Less: Income Tax Expense
   • = Net Funds Generated
   • Change in Net Worth
   • Unreconciled Difference
3. Color-coded: Yellow for current year, white for historical years
4. Green checkmark (✓) for balanced years, warning (⚠️) for unbalanced

Help & Support

TaxManager provides multiple channels for help and support.

Help & Security Page

Accessible from the sidebar, this page contains:

• Data Security Information: Details about encryption and privacy
• How to Use This Website: Step-by-step guide for all features
• Video Tutorial: Embedded YouTube video with complete walkthrough
• FAQ: Answers to common questions
• Contact Support: Email support link

Feedback & Bug Reports

To submit feedback or report issues:

1. Click "Send Feedback" in the sidebar
2. Choose feedback type:
   • 💡 Feature Suggestion
   • 🐛 Bug / Error Report
   • 💬 General Question
3. Enter a subject and detailed message
4. Optionally attach a screenshot (max 2MB)
5. Choose to submit anonymously or with your name
6. Click "Submit Feedback"

Community Forum

For complex questions or discussions with other users:

1. On the Feedback page, click "Visit the Forum"
2. You'll be directed to the dedicated discussion area
3. Browse existing topics or create a new post
4. Engage with the community and get help from other users

Password Reset

If you forget your password, you can reset it via email.

Reset Process

1. On the login page, click "Forgot Password?"
2. Enter your registered email address
3. Click "Email Password Reset Link"
4. Check your email for a reset link
5. Click the link (valid for 1 hour)
6. Enter your new password (minimum 8 characters)
7. Confirm the new password
8. Click "Reset Password"
9. You'll be logged in automatically

Best Practices

Follow these recommendations to get the most out of TaxManager and keep your data secure.

Data Entry Best Practices

• Be Consistent: Use the same descriptions for similar items across years
• Be Detailed: Include specific information (e.g., "Honda Civic 2020 - ABC 123" instead of just "Car")
• Save Regularly: Click "Permanent Save" after major changes
• Review Historical Data: Compare with previous years to catch errors
• Document Everything: Upload receipts and supporting documents

Reconciliation Best Practices

• Aim for Balance: Always try to reconcile your return before submitting
• Understand Balancing Expense: A large balancing expense indicates missing data
• Review Before Applying: Don't blindly apply balancing expense; investigate the cause first
• Use the Summary: Check the multi-year reconciliation summary for trends

Backup Best Practices

• Backup Frequently: After every major editing session
• Multiple Locations: Store backups on external drives AND cloud storage
• Test Restores: Periodically test restoring a backup to ensure it works
• Keep Old Backups: Don't delete old backups; keep at least 6 years of history
• Secure Storage: Treat backup files like cash; keep them secure

Security Best Practices

• Enable 2FA: Always use two-factor authentication
• Strong Passwords: Use unique, complex passwords
• Log Out: Always log out when finished, especially on shared computers
• Check URLs: Ensure you're on the official TaxManager website
• Update Regularly: Keep your authenticator app and browser updated

Frequently Asked Questions

General Questions

Q: How often should I backup my data?

A: We recommend backing up after every major editing session. At minimum, backup weekly during tax season.

Q: What happens if I forget my password?

A: Click "Forgot Password" on the login page. You'll receive an email with a reset link. If you have 2FA enabled, you'll also need your authenticator app.

Q: Can I edit a return after it's been saved?

A: Yes! You can edit your returns at any time. Just click "Edit" on the dashboard, make your changes, and click "Permanent Save" again.

Q: What is the "Balancing Expense" row?

A: If your return is unbalanced, the Balancing Expense row automatically captures the difference. You can click "Apply" to fill it, or manually adjust your data. This helps you identify missing data or errors.

Q: Is my data safe on this server?

A: Yes. All sensitive data is encrypted in the database, attachments are encrypted on disk, and strict user isolation prevents unauthorized access. However, we strongly recommend regular backups to your own device for maximum safety.

Q: Will this service be free in the future?

A: The current year reconciliation is planned to remain free. Additional features may depend on user status. You can always download your data (CSV or BAK format) and remove it from the server.

Technical Questions

Q: What if I accidentally delete a tax year?

A: If you have a backup, you can restore it. If not, contact support immediately. Deletions are permanent, so always backup before deleting.

Q: Can I use this on my phone?

A: Yes! TaxManager is fully responsive and works on smartphones and tablets. However, for extensive data entry, we recommend using a computer with a keyboard.

Q: What browsers are supported?

A: TaxManager works on all modern browsers: Chrome, Firefox, Safari, Edge. We recommend keeping your browser updated for the best experience.

Q: Can I import data from other tax software?

A: You can import CSV files. If your other software can export to CSV, you can likely import it into TaxManager. You may need to adjust the column headers to match our format.

Q: What happens to my data if the service shuts down?

A: You own your data. Download regular backups (.bak files) and store them safely. You can also export to CSV format, which can be opened in any spreadsheet application.

Data Questions

Q: What's the difference between CSV and BAK files?

A:

• CSV: Plain text file, can be opened in Excel, portable to other systems, but doesn't include attachments
• BAK: Encrypted backup file, includes all data AND attachments, can only be restored to TaxManager

Q: Can I have multiple tax returns for the same year?

A: No. Each user can have only one tax return per year. If you need to start over, delete the existing return and create a new one.

Q: How far back can I view historical data?

A: The spreadsheet shows up to 3 previous years. However, you can create returns for any year and view them individually on the dashboard.

Q: What if I make a mistake in my return?

A: Simply edit the return, correct the error, and save again. The system will recalculate everything automatically. If you've already submitted, you can change the status back to "Draft", make corrections, and resubmit.