01 RECORD
Log it when it happens
Date, category, kind, original currency and amount—all on one transaction row.
- Income or expense kind for each row
- Works with irregular dates
- No preset category or currency list
For independent work across borders
Track money
as it moves.
One Google Sheets-ready income and expense tracker for freelancers and small business owners managing irregular payments across currencies.
.xlsx file · Import it into Google Sheets
CROSSPOCKET / INCOME & EXPENSE TRACKER
SAMPLE ENTRIES · NOT REAL RECORDS
ANY DATETransactions
DATE · CATEGORY · TYPEORIGINAL · OPTIONAL LOCAL
03 Feb · Design · IncomeUSD 450 · —
14 Feb · Internet · ExpenseNGN 18,000 · —
02 Mar · Contract · IncomeGBP 250 · KES 42,000*
* MANUAL SAMPLE EQUIVALENTTotals grouped by currency
↔Original amounts stay intactLocal equivalents are optional
For cross-border work in
NigeriaKenyaGhanaand beyond
No recurring schedule. Record a transaction when it happens.One practical spreadsheet
A clearer record,
currency by currency.
Enter the date, category, income or expense, original currency and amount. Categories and currency codes are open fields, so you can use the terms that fit your business.
02 ADD
Keep local amounts manual
Add an optional local-equivalent amount and currency when you have one. The original amount is kept as entered.
- Leave the equivalent blank when needed
- No exchange-rate assumptions
- Fill the amount and its currency together
03 REVIEW
Read totals in their own currencies
Add each currency code once on the Totals tab. Formulas calculate income, expenses and net for original amounts and entered equivalents separately.
- Net is income minus expenses
- Blank equivalents do not affect original totals
- Never adds unlike currencies together
Use it in Google Sheets
Download the .xlsx file, then choose File → Import → Upload in Google Sheets.
A simple rhythm
Made for uneven months and money in motion.
The workbook starts blank, ready for the way your business actually earns and spends. It is one tracker for recording transactions and reviewing currency-separated totals.
01
Download and importOpen the .xlsx in Google Sheets with File → Import → Upload.
02
Enter your transactionsUse the Transactions tab; leave local equivalents blank when unknown.
03
Add currencies to TotalsType each code once to see its income, expense and net formulas.
Your records, your currency choices
Start with
what came
in and went out.
Download the blank tracker and make a copy in Google Sheets. Add the categories and currency codes your work needs.
Download the tracker.xlsx · Google Sheets import