I will perform complex bank reconciliation using excel
Senior US Accountant R2R Specialist Managing Financials for 90 Restaurant
À propos de ce service
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.
Type de service:
Rapprochement bancaire
Logiciel financier:
Sage
•
Autres
Industrie:
Services financiers
•
Autres
Pays cible:
Australie
Les services ne sont pas vérifiés
Veuillez noter qu'il n'y a pas de procédure de vérification pour ce service. Nous vous recommandons de contacter le freelance et de vérifier toutes les informations nécessaires avant de passer votre commande. Pour en savoir plus sur les services financiers, consultez le site Fiverr.
Mon portfolio
Autres services de comptabilité I Offre
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.

