OBD'G - Onboarding File Review - Revised November 2024

17 downloads

Before we generate that file, please let us know more about you.

Get template

About this template

It is critical that you review a prospect’s accounting file before you price or solidify your engagement. This File Review workflow gives you a step-by-step process for vetting a QBO. Ensure you test it before using it on live clients, check that the roles are working for you, look at descriptions to vet for fit for your firm, and customize communication and tags.

Work type: Other

Location: United States

Client industry: Generic

This template includes

  • 12 tasks
  • 7 client tasks
Client Tasks Client Tasks
Upload Trial Balance Fiscal Year End
Last Period Bank & Credit Card Statements
Add Me As An Accountant User to QBO
Add 2FA to your FC portal
Accounting File Review Contract signed
Team Tasks
Engage Prospect For File review
Admin
Send quote/Invoice
Payment received
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
Accountant
Information Gather
Admin
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
Reviewer
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
Reviewer
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
Reviewer
Run & Review Balance Sheet
Due to/from shareholders reasonable?
Review Un Deposited Funds if applicable
Run/review AR report
Sales Tax current?
Verify General Ledger
Reviewer
Do the major bank/credit card accounts match the balance sheet (trial balance if you prefer)?
Do the major bank/credit card accounts match the reconcilations?
Do the major bank/credit card accounts match the statements?
AR matches the Balance Sheet (Trial Balance if you prefer)?
AP matches the Balance Sheet (Trial Balance if you prefer)?
Review Profit & Loss
Reviewer
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
Admin
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
File review findings into Doc or Slide deck
Record video of findings
Reviewer
Upload report and video to client tasks
Admin
Client Tasks Client Tasks
Download file review report and video
Book a file review call with us

Copyright © 2017-2024 Financial Cents LLC