Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an excel spreadsheet for invoice and payment reconciliation
About this Gig
I will build an Excel workbook to reconcile invoices and payments using a shared reference ID.
With an accounting background, I focus on clear inputs and practical checks.
Your workbook will:
- Compare amounts and dates with adjustable tolerances
- Flag missing records, duplicate IDs and differences
- Show summary totals and review statuses
- Keep review notes linked to each ID
The Basic package includes one reusable .xlsx workbook, two input sources of up to 200 rows each, brief instructions and one revision within the agreed scope. Delivery: 3 days.
This service covers one-to-one matching in one currency. Duplicate IDs are flagged for review, not automatically combined. Split payments, grouped invoices, currency conversion, bank fees, macros and external data connections are outside this package.
Please provide clean Excel or CSV files with reference IDs, dates and amounts. Contact me before ordering to confirm your layout and matching rules.
Designed for Excel 2021 or Microsoft 365. Portfolio examples use synthetic data.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions
•
Data validation
FAQ
What do you need to start?
Please provide two Excel or CSV files with a shared reference ID, dates and amounts, up to 200 rows per source. Tell me your Excel version, currency and matching rules, including any allowed amount or date differences. You may send anonymized sample data before ordering so we can confirm the scope.
What does the included revision cover?
One revision covers one round of changes within the original agreed requirements. Additional data sources, new workflows, split payments or expanded functionality require a separate agreement. You receive an editable .xlsx workbook with formulas and brief instructions.
