Expense Reports Across Currencies, Without the Arguments
8apps Team ·
A remote team's receipts arrive in five currencies; reimbursement goes out in one. The rate-date policy that prevents disputes, and the sheet that implements it.
#Google Sheets
12 articles
Freelancers: Billing in USD When Your Bank Isn't
8apps Team ·
Bill in the client's currency, get paid into yours, and stop being surprised by the difference. The invoice clause, the tracking sheet, and the rate habits that protect your margin.
GOOGLEFINANCE vs a Currency Add-On: When a Formula Is Enough
8apps Team ·
Three ways to convert currency in Google Workspace – the free formula, your own script, an add-on – and an honest decision table for which fits which job.
Historical Exchange Rates in Google Sheets: What's Actually Possible
8apps Team ·
Rate-on-a-date is what invoices, expenses and audits actually need. What GOOGLEFINANCE can do historically, the formula that unwraps it, and the wall Google wrote into the docs.
Multi-Currency Invoice Tracker in Google Sheets
8apps Team ·
Bill in three currencies, report in one. The column layout, the rate-date policy, and the formulas – a multi-currency invoice tracker you can build in ten minutes.
Clean a Messy Contact Column in Google Sheets
8apps Team ·
A pasted contact column arrives fused, mis-cased and duplicated. Here are the Google Sheets formulas that turn it into clean name and email columns.
Format Phone Numbers to E.164 in Google Sheets
8apps Team ·
E.164 is the format ad platforms and APIs expect – and the one spreadsheets quietly destroy. Here's how to get +6591234567 out of whatever your column holds now.
Prepare a Google Ads Customer Match List in Sheets
8apps Team ·
The upload succeeds either way – the match rate is what fails. Here's the Sheets-to-Customer-Match workflow with Google's own formatting rules at each step.
Hash Email Addresses Correctly in Google Sheets
8apps Team ·
Email hashing fails on casing, invisible spaces and Gmail's dot rules – not on the hash. The normalisation order that makes digests actually match, platform by platform.
Prepare a Meta Custom Audience File from Google Sheets
8apps Team ·
Meta's phone format is not Google's – the same number needs two different hashes. Here's the Sheets workflow that follows Meta's documented rules exactly.