Freelance Payment Tracker in Google Sheets: Invoices, Fees and BDT Received

A client pays your USD 200 invoice, but only BDT 23,520 reaches your account. Use this Google Sheets tracker to reconcile the fee, record instalments, and see which invoices still need a follow-up.

A freelance payment tracker should tell you two things at a glance: how much landed in your account and how much each client still owes. Those numbers can differ even when everyone has paid correctly. Suppose a client pays your USD 200 invoice in full. At an example rate of BDT 120 per dollar, that is BDT 24,000 before fees. If your provider deducts BDT 480, your account receives BDT 23,520. The client’s balance is zero.

The Google Sheets template below keeps those figures separate. It also handles the opposite situation: a client sends two payments for one project, you receive every taka they sent, and part of the invoice is still outstanding.

Make a copy of the freelance payment tracker in Google Sheets

The copy opens with three sample invoices. Follow one through the workbook before replacing the examples. The exchange rate and fee are illustrative. For your own entries, use the figures on the transaction statement.

How the freelance payment tracker works

The tracker has two tabs. In Invoices, one row represents one bill. In Payments, one row represents one payment against that bill. The invoice ID connects them. If a client pays in three instalments, keep the original invoice row and add three payment rows with the same ID.

When this happensWhere to enter itWhat to do
You issue an invoiceInvoices, columns A–EEnter a unique invoice ID, client or project, due date, currency, and amount billed.
A payment reaches your accountPayments, columns A–FEnter the receipt date, invoice ID, gross payment, conversion rate, fee in BDT, and actual BDT credited.
You want to identify a transfer laterPayments, column IAdd a short note such as “Booking advance” or the payout reference from your statement.
You need the outstanding balanceInvoices, columns F–JRead the calculated gross paid, balance due, fees, net BDT received, and payment status.

The template includes formulas for 200 invoices and 1,000 payment entries. When clearing the examples, clear only the input cells listed above. Keep the formula cells in place. Give each new invoice its own ID, even if you bill the same client every month. Two invoice rows with the same ID would both pick up the same payments.

Example 1. Track two instalments on a BDT 12,000 project

Imagine you build a WordPress website for a training centre in Dhaka. The project fee is BDT 12,000. The client sends BDT 4,000 to book the work and BDT 6,000 after approving the design. The final instalment has yet to arrive.

In Invoices, enter BH-024 once, with BDT as the currency and 12000 as the billed amount. Then record the two transfers in Payments. Use a conversion rate of 1 for a BDT payment. If the full amount reached you, enter 0 in the fee column.

ReceivedInvoice IDGross paidFeeNet BDT credited
1 NovemberBH-024BDT 4,000BDT 0BDT 4,000
9 NovemberBH-024BDT 6,000BDT 0BDT 6,000

Back on the invoice row, you should see BDT 10,000 paid, BDT 2,000 due, and Part-paid. You now have the figures for a precise client update: “I’ve received the BDT 4,000 advance and the BDT 6,000 second instalment. The remaining balance on BH-024 is BDT 2,000.”

Try it in your copy: Add a third payment row for BH-024. Enter 2000 as the gross amount, 1 as the rate, 0 as the fee, and 2000 as the net credit. The invoice balance should fall to zero and its status should change to Paid. Undo that practice entry if you want to keep the original example for reference.

Example 2. Record a USD invoice, a fee, and the BDT received

For invoice BH-025, a client pays USD 200 for a landing page. In this example, the payout statement shows a rate of BDT 120 per USD and an identifiable fee equivalent to BDT 480. Your receiving account shows a credit of BDT 23,520.

Payment fieldEnterWhere the figure comes from
Gross paid200The amount settled against the USD invoice, before your fee
Rate BDT per unit120The conversion rate used for this payout
Fee in BDT480The stated deduction, expressed in taka
Net BDT credited23520The amount that actually reached your account

The tracker multiplies 200 by 120 and subtracts 480. Its calculated net is BDT 23,520. Because you independently entered the actual credit from your account, the sheet can compare the two numbers. The Difference column shows zero.

Look at the same transaction on the Invoices tab. It shows USD 0 due, BDT 480 in fees, and BDT 23,520 received. If you divided the net credit by 120 and entered USD 196 as the client payment, the tracker would report a USD 4 shortfall. The statement tells you who paid that USD 4: in this example, it was your processing cost.

What if the exchange rate changes between instalments?

Give each instalment its own payment row and its own rate. Suppose the first USD 100 converts at 120 and the next USD 100 converts at 121, with no fees. Enter the two credits as BDT 12,000 and BDT 12,100. The invoice is fully paid at USD 200, and your total receipt is BDT 24,100. Reusing the second rate for both payments would overstate the total by BDT 100.

Read the three sample invoices together

The third sample, BH-026, is a BDT 6,000 invoice for content updates. It has no payment entries yet. This is what the original sample looks like before you add any transactions of your own.

InvoiceAmount billedClient still owesFees in BDTNet BDT receivedStatus
BH-024BDT 12,000BDT 2,000010,000Part-paid
BH-025USD 200USD 048023,520Paid
BH-026BDT 6,000BDT 6,00000Unpaid

You can add the net-received column across all three invoices because every value in it is in BDT. That gives you BDT 33,520 received. For balances due, add each currency separately. Here the open balances happen to be BDT 2,000 and BDT 6,000, so the outstanding total is BDT 8,000. If a fourth client owes USD 50, report “BDT 8,000 and USD 50 outstanding” until you have a reason to convert the USD figure at a stated rate.

Three useful Google Sheets formulas for your payment tracker

The template already calculates each invoice row. If you want totals above your desk at month-end, create a blank tab called Summary. Enter one label in column A and its formula in column B. These formulas use the column positions in the supplied template.

LabelFormula to pasteOriginal sample result
Total BDT received=SUM(Payments!F2:F1001)33,520
Total fees in BDT=SUM(Payments!E2:E1001)480
Outstanding BDT invoices=SUMIFS(Invoices!G2:G201,Invoices!D2:D201,"BDT",Invoices!G2:G201,">0")8,000

The last formula includes only positive BDT balances. That matters if one client overpays while another still owes you money. A BDT 500 overpayment from one client should stay visible on that client’s invoice; it should not shrink the balance you follow up with someone else about.

What to check when the numbers disagree

The payment row shows a difference. Suppose the sheet calculates BDT 23,520 and your account shows BDT 23,500. The difference will be −20. Check the statement for a separate BDT 20 receiving charge or a more precise conversion rate. If you find the charge, update the fee and add a note. If you cannot explain the difference yet, leave the actual credit as BDT 23,500. That keeps the discrepancy visible.

The invoice still says Unpaid after you entered a payment. Compare the ID in both tabs. A receipt labelled BH-025A will not update invoice BH-025. Copy the ID from the invoice row, correct the payment row, and check the balance again.

You received one transfer for two invoices. Split the transfer across two payment rows using the client’s payment breakdown. For example, if a BDT 8,000 transfer settles BDT 2,000 on BH-024 and BDT 6,000 on BH-026, enter one row for each amount. Use the same transfer reference in both notes. Together the rows should add up to the single bank credit. If the client has not said how to allocate the money, confirm that detail first.

The client paid a platform, but your withdrawal is still pending. This particular template records settled receipts. Its payment row links the client’s gross payment to an actual BDT credit. If those events fall on different dates, retain the platform settlement reference and enter the receipt when the payout reaches you. Until then, check the platform record before sending any reminder. An invoice marked Unpaid in this sheet can also mean the payout has yet to be recorded.

Use the tracker to decide which client to follow up with

At the end of the week, compare new credits with your payment entries. Then review each Part-paid or Unpaid invoice alongside its due date. Payment status tells you how much has been received. The due date tells you whether a reminder makes sense. An invoice due next Friday can have a full outstanding balance and still be on schedule.

For BH-024, a follow-up after the due date can be one sentence: “Thanks for the two instalments totalling BDT 10,000. Could you confirm the transfer date for the remaining BDT 2,000 on invoice BH-024?” For BH-025, mark the receipt reconciled in your notes. The client has paid in full, and the BDT 480 fee is already accounted for.

If you are still choosing how a client will pay you, see the guide to freelance payment methods in Bangladesh. Once you have agreed on the method, keep the invoice currency, expected deductions, and due date together. Those three details make the first payment much easier to reconcile.

Razib Chandra Ghosh

Editor at Blogerhub

Razib Chandra is the founder of BlogerHub, a website focused on helping people learn how to earn money online and build sustainable digital income streams.He writes about online income, remote jobs, blogging, SEO, and Google AdSense strategies. Through practical guides and tutorials, Razib shares real methods, tools, and insights to help beginners start earning money online and grow profitable websites.

Reviewed for accuracy · No unrealistic income claims

← Previous
Freelance Portfolio Case Study Template: A Landing Page Before and After
Next →
Freelance Invoice Template for Bangladesh: A BDT Example