USD Quoting and Payment Tracker

Quote in dollars, track every payment and know what is left after fees. Excel and Google Sheets.

Guessing quotes, losing track of which payments are still due and discovering platform fees only when the money lands: that happens to almost every freelancer who starts working with clients abroad.

This spreadsheet puts the three things in one file: a sheet to quote in USD with automatic expiry dates, a sheet to log every payment with its platform fee, and a summary that shows what you quoted, what you collected net, what is still pending and how much to set aside for taxes.

No macros, no exotic formulas: it works the same in Excel, Google Sheets and LibreOffice.

What is included

  • Config sheet: your base rate, local currency, reference exchange rate, default fees and tax reserve percentage.
  • Platforms sheet: PayPal, Payoneer, Wise and Deel with example percentage and fixed fees, editable so you can enter the ones from your account.
  • Quotes sheet: one row per proposal, with hours times rate, subtotal, discount, total in USD, color-coded status and automatic expiry date.
  • Payments sheet: every payment with its platform (PayPal, Payoneer, Wise, Deel, bank transfer), the fee pulled automatically from the Platforms sheet (or the one you enter on that row), net in USD, net in your currency and suggested reserve.
  • Summary sheet: total quoted, accepted, collected gross and net, fees paid, pending, acceptance rate, suggested reserve and net in your currency.
  • Instructions sheet and a README: how to get started in five minutes.
  • Spanish version and English version, in the same purchase.

Who it is for

  • Latin American freelancers and remote workers who get paid in USD by international clients.
  • People who quote by the hour or by project and want a clear record without learning new software.
  • Anyone using PayPal, Payoneer, Wise or Deel who wants to see fees before the money arrives.

What it does not do

  • It does not compute taxes or issue legal invoices: the tax reserve is an editable estimate.
  • It does not fetch live exchange rates: you enter the rate.
  • It is not legal, accounting or tax advice.

Formats

.xlsx files (one in Spanish, one in English) inside a ZIP. Compatible with Excel 2016 or later, Google Sheets (File > Import) and LibreOffice Calc.

FAQ

Does it work in Google Sheets?

Yes. Import the .xlsx file from File > Import. Formulas, dropdowns and conditional formatting are preserved.

Are the PayPal and Wise fees up to date?

They ship as editable example values. Fees change by country and account type, so the spreadsheet asks you to enter the ones from your own account.

Do I need to know Excel?

No. You enter your details in the Config sheet once, then just fill in rows in Quotes and Payments; totals, expiry dates and the summary calculate themselves. The Instructions sheet explains every column.

Does it work with any local currency?

Yes. You enter your local currency and a reference exchange rate in the Config sheet, and the spreadsheet shows net amounts in USD and in your currency. Client amounts are entered in USD.

How is this different from the free rate calculator?

The calculator helps you decide what to charge per hour or per project. The spreadsheet covers what comes next: quoting with that number, tracking every payment and seeing what is left after fees. If you have not set your rate yet, start with the free calculator.

Can I get a refund?

Yes, within 14 days if the file does not open or does not do what this page describes. See the refund policy.

Do I get updates?

Yes. When we improve the spreadsheet you can download it again from your purchase link.

Our products and articles are practical tools and informational content. They are not legal, accounting or tax advice. Every country and every payment platform has its own rules: talk to a professional before making tax decisions.