Browse categories
Explore
Fiverr Pro
English
$
USD
I will perform complex intercompany recon using excel power query
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
INTERCOMPANY RECONCILIATION | Excel Power Query | Multi-Entity Consolidation
Managing multiple business entities? I'll reconcile intercompany transactions and create consolidated financial statements using advanced Excel automation.
WHAT YOU GET:
-Complete intercompany account reconciliations
- Multi-entity consolidation with eliminations
- Automated Excel Power Query solutions (reusable)
- Consolidated P&L and Balance Sheet reports
- Variance analysis between entities
- Journal entry recommendations
- Documentation for auditors
WHY CHOOSE ME:
-Specialized in complex multi-unit consolidations
-Expert in Excel Power Query automation (saves 10+ hours monthly)
-Handles 5-50+ entity consolidations Experience with restaurant, retail, and distribution businesses
-Audit-ready documentation & GAAP compliance
-Creates reusable templates for recurring consolidations
-QuickBooks Pro Advisory Certification (Completing in 2 months)
-5+ years managing 90+ restaurant locations
IDEAL FOR:
-Multi-location businesses
-Franchise consolidations
-Year-end audit prep
-Automated monthly consolidations
Ready to automate your consolidation process? Let's talk!
Service type:
Other
Financial software:
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 data do I need to provide?
I require the General Ledger exports for the Intercompany AR/AP accounts from both entities, or a trial balance for all subsidiaries involved.
Can you handle multi-currency entities?
Yes. I am proficient in reconciling entities with different functional currencies and identifying realized/unrealized FX variances.
Will you fix the errors in my software directly?
I provide the adjustment journal entries and a reconciliation report. If requested, I can log into your software (Sage, QBO, Xero) to post them for an additional fee.
How many entities/companies can you handle?
2-50+. Power Query saves time on larger consolidations.
What's Basic vs Standard vs Premium?
Basic=manual (5 days) | Standard=Power Query (3 days) | Premium=Dashboard+call (24 hrs)
Do you work with QuickBooks?
Yes! I pull data directly from backups.
