QuickBooks AR/AP Annual Reconciliation
Budget: $8 – $15 USD
I need my entire fiscal year of Accounts Receivable and Accounts Payable brought fully into line inside QuickBooks Online. The books contain a mixture of automated bank feeds and manually entered bills/invoices, so the clean-up will require a balanced approach that blends QuickBooks’ built-in auto-matching tools with a careful manual review of every exception.
Once every customer and vendor balance is verified, I also want fresh management reports: a Profit & Loss Statement, Balance Sheet and Cash Flow Statement that all tie back to the reconciled ledgers.
Deliverables
• Reconciled AR and AP detail that matches the General Ledger to the penny
• Updated QuickBooks file (or portable copy) reflecting every adjustment with clear memos
• Final P&L, Balance Sheet and Cash Flow PDF exports dated the last day of the fiscal year
• Brief summary of issues found and the corrective steps taken
Acceptance criteria
• No unreconciled items older than 30 days
• Customer and vendor balances agree with subsidiary reports
• All three financial statements agree with the post-reconciliation trial balance
A CPA or QuickBooks ProAdvisor with experience in year-end clean-ups will feel right at home here, but anyone confident with both automated and hands-on reconciliation techniques is welcome. I’m ready to provide the current company file, bank statements and any missing vendor invoices the moment we start.
Once every customer and vendor balance is verified, I also want fresh management reports: a Profit & Loss Statement, Balance Sheet and Cash Flow Statement that all tie back to the reconciled ledgers.
Deliverables
• Reconciled AR and AP detail that matches the General Ledger to the penny
• Updated QuickBooks file (or portable copy) reflecting every adjustment with clear memos
• Final P&L, Balance Sheet and Cash Flow PDF exports dated the last day of the fiscal year
• Brief summary of issues found and the corrective steps taken
Acceptance criteria
• No unreconciled items older than 30 days
• Customer and vendor balances agree with subsidiary reports
• All three financial statements agree with the post-reconciliation trial balance
A CPA or QuickBooks ProAdvisor with experience in year-end clean-ups will feel right at home here, but anyone confident with both automated and hands-on reconciliation techniques is welcome. I’m ready to provide the current company file, bank statements and any missing vendor invoices the moment we start.