📚 How to Use the Calculator

🚀 Quick Start Guide

Get started in less than 5 minutes with these simple steps:

Start Calculator Now →

📝 Detailed Step-by-Step Instructions

Step 1: Initial Setup

Choose Your Currency:

• Select from PKR, USD, EUR, GBP, INR, AED, SAR, CAD, or AUD
• All amounts will be calculated in this currency

Add Partners:

• Click on the number of partners (2-10)
• Enter each partner's name
• Set their ownership percentage
• Calculator validates percentages add up to 100%

Step 2: Track Expenses

You have TWO options to add expenses:

Option A: Add Manually

• Click "+ Add Manually" button
• Enter expense description (e.g., "Office Rent")
• Enter amount
• Select who paid for it
• Repeat for each expense

Option B: Import from Excel (⚡ Recommended)

• Click "📋 Import from Excel" button
• Choose "Paste Rows" or "Paste Columns"
• Copy data from Excel/Google Sheets
• Paste into calculator
• Import 100+ expenses in seconds!

Step 3: Record Payments

Same as expenses - add manually or import from Excel:

• Payment description (e.g., "Client ABC Payment")
• Amount received
• Who received the payment

Step 4: Calculate & Review Results

Click "Calculate Results" button to see:

• Total income, expenses, and net profit
• Each partner's profit share
• Money received and paid by each partner
• Net received after settlements
• Settlement instructions (who pays whom)
• Final balance confirmation

📊 How to Import from Excel/Google Sheets

Method 1: Paste Rows (Fastest)

Best for: Complete Excel data with all columns

Step 1: Prepare your Excel data:

Step 2: Copy rows from Excel (Ctrl+C or Cmd+C)

Step 3: In calculator:

• Click "📋 Import from Excel"
• Select "Paste Rows" tab
• Paste data (Ctrl+V or Cmd+V)
• Click "Import Data"

Supported Formats:

• ✓ Tab-separated (Excel default)
• ✓ Comma-separated (CSV)
• ✓ Auto-detects format automatically

Method 2: Paste Columns (Flexible)

Best for: Data from different sources or partial updates

Step 1: Copy first column (names) from Excel

Step 2: Paste into "Expense Names" field

Step 3: Copy second column (amounts)

Step 4: Paste into "Amounts" field

Step 5: Copy third column (paid by)

Step 6: Paste into "Paid By" field

Step 7: Click "Import Data"

Excel Import Examples

Example 1: Tab-Separated (Excel Default)

Example 2: Comma-Separated (CSV)

Both formats work automatically! ✓

📊 Understanding Your Results

Summary Section

Shows overall business finances:

• Total Income: All payments received combined
• Total Expenses: All costs paid combined
• Net Profit: Income minus Expenses

Partner Results

For each partner, you'll see:

Profit Share: Their portion of net profit based on percentage

Money Received: Total income/payments they collected for the business

Money Paid: Total expenses they paid out of pocket

Settlements Received: Money received from other partners during settlement

Settlements Paid: Money sent to other partners during settlement

Net Received: Total money in hand after all settlements

Initial Balance: Amount owed before settlements

• Positive = Must SEND money
• Negative = Should RECEIVE money
• Zero = Already balanced

Partner End With: Final balance after all settlements

• When this shows $0.00 with "✓ Account Settled" → Perfect! All balanced!

Settlement Instructions

Clear step-by-step instructions on who should pay whom:

💡 Pro Tips & Best Practices

Before You Start

• Gather all expense receipts and payment records
• Agree on partner percentages with all partners
• Have partner names consistent across all records
• Organize data in Excel if you have 10+ items

Using Excel Import

• Format your Excel data before copying (3 columns)
• Remove currency symbols from amounts (5000 not 5,000 PKR)
• Check partner names match exactly (case doesn't matter)
• Use "Paste Rows" for speed, "Paste Columns" for flexibility

Data Entry Tips

• Use clear descriptions (not just "Expense 1")
• Record expenses as soon as they happen
• Keep receipts for verification
• Save your calculation by printing or bookmarking page

Settlement Tips

• Follow settlement instructions in order
• Verify amounts before transferring
• Get confirmation after each settlement
• Print summary for records

Security Best Practices

• All data stays in your browser (100% private)
• No login required = no account to hack
• Clear browser cache to remove saved data
• Print or save results before closing browser

🔧 Troubleshooting Common Issues

Excel Import Errors

Problem: "Partner not found" error

Solution:

• Check partner name spelling in Excel matches calculator exactly
• Case doesn't matter (Ali = ali = ALI)
• Remove extra spaces
• Go back to Step 2 to verify partner names

Problem: "Expected 3 columns, got 2"

Solution:

• Ensure each row has: Name, Amount, Partner
• Check for missing data
• Verify you copied all columns

Problem: "Invalid amount" error

Solution:

• Remove currency symbols ($ £ PKR etc.)
• Remove commas from numbers (5,000 → 5000)
• Use only numbers and decimal point
• Check for text in amount column

Percentage Issues

Problem: "Percentages don't add up to 100%"

Solution:

• Add up all percentages manually
• Adjust until total = 100%
• Example: 50% + 30% + 20% = 100% ✓

Settlement Not Showing Zero

Problem: Partner ends with $0.01 or $0.02 instead of $0.00

Solution:

• This is normal! Rounding differences are common
• Anything under $0.05 is considered settled
• No action needed

Data Lost After Closing Browser

Problem: My data disappeared

Solution:

• Calculator uses localStorage (saved in browser)
• Clearing browser cache removes data
• Use same browser to access saved data
• Print summary before closing

Still Need Help?

Can't find your answer? Contact us and we'll help you out!

Ready to Get Started?

100% Free - No Login Required - Secure & Private

Start Calculator Now → Read More Articles