Travel Expense Reconciliation
Budget: $10 – $30 USD
I have a folder full of physical and digital receipts, credit-card statements, and a record of cash withdrawals from a recent trip. I need every transaction logged, cross-checked, and balanced so that the grand total in the spreadsheet matches what actually left my accounts.
The job involves:
• Entering each receipt into a single master sheet (Excel or Google Sheets—use whichever you’re fastest with).
• Reconciling those entries against my card and bank statements, flagging any duplicates or mismatches for me to review.
• Highlighting any unspent advances or remaining funds once everything balances.
When you hand it back, I want two files:
1. The working spreadsheet with all formulas intact.
2. A brief one-page summary that states the total spent, any discrepancies you found, and the final balance.
I’ll share receipts via a cloud folder and can answer questions about unclear line items as you go. Accuracy is critical, so please double-check subtotals and currency conversions if any expenses are in foreign currency. Once the numbers tie out to the penny, the project is done.
The job involves:
• Entering each receipt into a single master sheet (Excel or Google Sheets—use whichever you’re fastest with).
• Reconciling those entries against my card and bank statements, flagging any duplicates or mismatches for me to review.
• Highlighting any unspent advances or remaining funds once everything balances.
When you hand it back, I want two files:
1. The working spreadsheet with all formulas intact.
2. A brief one-page summary that states the total spent, any discrepancies you found, and the final balance.
I’ll share receipts via a cloud folder and can answer questions about unclear line items as you go. Accuracy is critical, so please double-check subtotals and currency conversions if any expenses are in foreign currency. Once the numbers tie out to the penny, the project is done.
Related categories:
Data Processing
Data Entry
Accounting
Excel
Financial Analysis
Documentation
Google Sheets
Data Management