Accounting/Bookeeping - Reconcile 10 years of Accounting

Job ID: 30952327

Budget: $250 – $750 CAD

Hello,

I'm looking for help consolidating and reconciling 10 years of accounting into Excel and then populate into Quicken software. Transactions will be provided in statements from multiple Banks, Credit Cards, Accounts. Accounting needs to be categorized by types of transactions. ex. Travel, Fuel, ...etc)

Consult on best practices to ensure the following scope of work is completed.

1. Create Excel Master File with all transactions
2. Setup of Categories
3. Clean up transactions - match to categories
4. Separate Personal and Business transactions
5.preparation of financial statements
6. Import Validated transactions into Quicken using Import tools
Related categories: Accounting Excel Finance Intuit QuickBooks Bookkeeping