About this template
Work type: Bookkeeping
Location: United States
Client industry: Generic
This template includes
- 13 tasks
- Automations
Before we generate that file, please let us know more about you.
Work type: Bookkeeping
Location: United States
Client industry: Generic
This template includes
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