I will perform complex intercompany recon using excel power query
Senior US Accountant R2R Specialist Managing Financials for 90 Restaurant
Sobre este Serviço
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!
Tipo de serviço:
Outros
Software financeiro:
Outros
Setor:
Serviços financeiros
•
Outros
País de Destino:
Austrália
Os Serviços não são avaliados
Observe que não há processo de triagem para este serviço. Recomendamos enviar uma mensagem ao freelancer e verificar todos os detalhes necessários antes de fazer seu pedido. Leia mais sobre os serviços financeiros na Fiverr.
Meu portfólio
Outros serviços de Contabilidade que eu ofereço
Perguntas frequentes
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.

