BKP'g - Manager File Review

44 downloads

About this template

This template is a stand-alone QBO manager file review to ensure client work is clean and compliant. It is an international version that can be used in any country. Here is a video on implementing the Manager File Review template. 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 the automated email template and tags. https://www.loom.com/share/eebe9293ad4e423a99890d6bc6f7c9a0?sid=000a96fc-6d41-4236-93a0-02a88b22a866

Work type: Bookkeeping

Location: United States

Client industry: Generic

This template includes

  • 13 tasks
  • Automations
Team Tasks
Confirm Reconciliation Statements have Been Uploaded
Reviewer
Ensure they have been named correctly
Review QBO Overview Module
Reviewer
All bank feeds cleared for previous period
Reconciliations completed for previous period
No unusual uncleared transactions
General Review
Reviewer
Check for large purchases that may be fixed assets - duplicate transaction numbers and transactions with no name associated
Vendors and Customers. Check for duplicates and run a quick general review
Review Undeposited Funds
Reviewer
Check to see if there are "Undeposited Funds" by clicking the "+" sign in QBO and selecting "Bank Deposit"
Bank Feed Review
Reviewer
Review last dates accounts reconciled.
Open AP, AR and Un Deposited Funds to review for transactions that should have cleared bank feeds and may not have.
Review the bank feed for open transactions—sort by oldest date. There should be no old uncleared transactions that may have come in post-reconciliation.
Balance Sheet Review
Reviewer
Accounts in their expected position?
Due to/from Shareholders - Owners Equity reasonable?
Prepaids reasonable?
Current liabilities reasonable (short term loans...)?
Sales tax current?
Verify General Ledger and Statement Ending Balances
Reviewer
Open GL report and set start and finish dates as the last day of the previous month
Open BS report and set start and finish dates as the last day of the previous month
Open rec reports for overview accounts
Open statements for bank/credit card/merchant accounts (overview accounts being fetched)
Run down the GL to ensure it matches the BS
Ensure the rec report ending balances match the statements and the GL/BS
AR Review
Reviewer
Negative balances to be reviewed?
Aging over 60-90 days?
AP Review
Reviewer
Negative balances to be reviewed?
Aging over 60-90 days?
P&L Review
Reviewer
Income/expenses reasonable to comparative period?
Any un-categorized transactions?
Other income or expenses coded correctly?
Automobile expenses being treated correctly?
Meals & Entertainment Reasonable?
Travel & Conferences Reasonable?
Products & services review - tracking to reasonable accounts (use P&S report - add income accounts)?
Class tracking review.
Job costing review.
Unbilled transactions review.
Roll through Book Review in QBO to check for anomalies
Reviewer
Reports Uploaded - Books Closed Email Sent
Reviewer
Open/refresh AP, AR, P&L and BS
AP review, upload
AR review, upload
P&L review, upload
Balance Sheet review, upload
Upload to where client accesses reports
Close Books With Password
Reviewer

Copyright © 2017-2024 Financial Cents LLC