Browse categories
Explore
Fiverr Pro
English
$
USD
I will perform complex bank reconciliation using excel
Senior US Accountant R2R Specialist Managing Financials for 90 Restaurant
Senior US Financial Controller and R2R Specialist with over 5 years of experience. I specialize in managing month-end closures for 90+ US restaurant locations, ensuring strict US GAAP compliance and a...
About this Gig
Get audit-ready books with the power of advanced Excel.
Standard accounting software often fails when dealing with high transaction volumes, fragmented data, or complex intercompany transfers. As a Senior Accountant who has managed 97-entity transformations, I specialize in using Excel Power Query to reconcile even the messiest financial records with 100% integrity.
What I will do for you:
- Automated Reconciliation: I will build a Power Query model to match your bank statements against your General Ledger (GL) instantly.
- Data Cleanup: Removing duplicates, fixing formatting errors, and categorizing uncategorized expenses.
- Discrepancy Reporting: Providing a clear "Difference Report" so you know exactly what is missing or incorrect.
- Multi-Account Support: Handling multiple bank accounts, credit cards, or payment gateways (Stripe/PayPal/Amazon).
Why choose me?
- Expert in US GAAP and accrual-based accounting.
- 5+ years of experience in high-volume, multi-unit accounting.
- Fast turnaround and audit-ready results.
Service type:
Bank reconciliation
Financial software:
Sage
•
Other
Industry:
Financial services
•
Other
Target Country:
Australia
Gigs are not screened
Please note that there is no screening process for this service. We recommend that you message the freelancer and check all necessary details before placing your order. Read more about Financial services at Fiverr.
My Portfolio
Other Accounting Services I Offer
FAQ
What documents do I need to provide?
I will need your Bank/Credit Card statements (in PDF or CSV/Excel format) and your internal accounting records or General Ledger export. If you have any specific notes about unrecorded transactions or missing checks, providing those upfront will speed up the process.
Can you handle high-volume accounts with thousands of transactions?
Yes. Unlike standard manual bookkeeping, I use Excel Power Query to automate the matching process. This allows me to process thousands of data lines quickly while maintaining 100% accuracy and integrity, even for complex multi-unit portfolios.
My data is a mess—can you still reconcile it?
Absolutely. I specialize in data cleanup. I can fix formatting errors, remove duplicates, and reorganize fragmented data to ensure it aligns perfectly with your bank records. I will provide a clear "Difference Report" showing exactly what was fixed.
Do you follow US GAAP standards?
Yes. I am a Senior Accountant with over 5 years of experience in US Accounting (GAAP). Every reconciliation I perform is audit-ready and follows accrual-based accounting principles to ensure your financial statements are accurate.
Can you build an Excel template for me to use in the future?
Yes! In the Premium Package, I can provide you with the actual Power Query model I build. This way, you can simply drop in your new data next month, and the model will perform the reconciliation automatically for you.
