About this template
Work type: Bookkeeping
Location: Canada
Client industry: Generic
Version: 1 (Latest)
This template includes
- 12 tasks
- 6 client tasks
ONBD'G - A4A Canadian Onboarding File Review
2 downloadsBefore we generate that file, please let us know more about you.
Sorry, but you can only download 5 Excel files per day.
Please come back tomorrow to download 5 more.
| Client Tasks Client Tasks | ||
|---|---|---|
| Upload Trial Balance Fiscal Year End | ||
| Upload Last Verified Period Bank & Credit Card Statements | ||
| Add Calmwaters As An Accountant User to QBO | ||
| Add 2FA to your FC portal | ||
| Team Tasks | ||
|---|---|---|
| Engage Prospect For File review | ||
| Send quote/Invoice | ||
| Payment received | ||
| Accounting File Review Contract sent | ||
| Accounting File Review Contract signed | ||
| Create shared folder | ||
| Create Review Summary Doc This doc is where you can summarize your findings in order of the file review. Add to shared folder. Be careful with the template, the standard findings have been pre-filled (attached). | ||
| Check out their website. | ||
| Send FC portal email | ||
| Information Gather | ||
| Send e-mail: YEAR END/FILE REVIEW - APP AGNOSTIC - ACCOUNTING FILE REVIEW NEXT STEPS | ||
| Confirm Trial Balance has been uploaded | ||
| Confirm Reconciliation Statements have been uploaded | ||
| Confirm that the file access has been granted. | ||
| Review Company Settings | ||
| Vendors and Customers. Check for duplicates and run a quick general review. | ||
| Non QBO Files: Check for large purchases that may be fixed assets, duplicate transaction numbers and transactions with no name associated | ||
| Review chart of accounts for accounts to be reconciled | ||
| Review chart of accounts - logical, tax codes? | ||
| Review Overview for Bank Feeds, Reconciliation Statuses | ||
| Review bank feed for un-matched transactions for reconciliation accounts - sort by oldest date | ||
| Un-accepted transactions, don't need all trans, just the number, make notes on it of suggestions, name [account] un-matched transactions | ||
| Review last dates accounts reconciled | ||
| Review each reconciliation account for uncleared transactions | ||
| Review Balance Sheet | ||
| Run & Review Balance Sheet | ||
| Due to/from shareholders reasonable? | ||
| Review Un Deposited Funds if applicable | ||
| Run/review AR report | ||
| Sales Tax current? | ||
| Review Profit & Loss | ||
| Run/review Profit&Loss report | ||
| Any un-categorized transactions? | ||
| Automobile expenses being treated correctly? | ||
| Meals & Entertainment Reasonable? | ||
| Travel & Conferences Reasonable? | ||
| "Other" income or expenses coded correctly? | ||
| Review tax codes applied correctly | ||
| Review for unbilled transactions | ||
| Review billable expenses - time or expenses | ||
| Class tracking review | ||
| Job costing review | ||
| Report Findings | ||
| Complete File Review Summary Doc | ||
| Suggest applications for document management and payments | ||
| Enter Adjusting JE's if part of review | ||
| Host Zoom Meeting | ||
| Send e-mail: YEAR END/FILE REVIEW - REVOKE [DOCUMENT MANAGEMENT / ACCOUNTING PROGRAM/OTHER APPS] ACCESS | ||
| Verify General Ledger | ||
| File review results into slide deck | ||
| Video results in Loom | ||
| Upload report and video to client tasks | ||
| Client Tasks Client Tasks | ||
|---|---|---|
| Download file review report and video | ||
| Book a file review call with us | ||