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.
Productivity
14 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 Exchange Rates Not Working? The Full Fix List
8apps Team ·
#N/A on a currency pair, rates that seem stale, historical dates that error out – every documented GOOGLEFINANCE failure mode, what causes it, and what actually fixes it.
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.
Where Google's Currency Data Actually Comes From
8apps Team ·
Millions of people trust the rate Google shows them. Here's what Google actually promises about that number – who supplies it, how delayed it is, and what it is not for – documented line by line.
Quarterly Google Drive Access Audit Checklist
8apps Team ·
A 30-minute quarterly Google Drive access audit checklist for Workspace admins: Drive log, current exposure, leavers, decisions, evidence log, console paths.
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.
How to Extract Email Addresses from Gmail to a Spreadsheet (4 Ways)
8apps Team ·
Gmail has no export-these-addresses button. Here are the four routes that actually work - Other contacts, Contacts export, Takeout and Apps Script - and which one fits your situation.