About this template
Work type: Bookkeeping
Location: United States
Client industry: Generic
Version: 6 (Latest)
This template includes
- 13 tasks
- Automations
BKP'g - Manager File Review
75 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.
| 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
|
|