About this template
Work type: Bookkeeping
Location: United States
Client industry: Generic
Version: 3 (Latest)
This template includes
- 25 tasks
- 4 client tasks
- Automations
- Resources
CLEAN UP - JR
293 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.
| PREP & SETUP | ||
|---|---|---|
| Details & Recordings |
Lead Bookkeeper
|
|
| Prep |
Lead Bookkeeper
|
|
| Link DR review video to Details tasks | ||
| Save Financial Reports in Excel and PDF to cleanup file | ||
| Enter any additional notes about the cleanup on the Details task | ||
| Delete all QBO Bank feed rules | ||
| In QBO create Cleanup Tag Group - Cleanup | ||
| Add Client to Recat | ||
| Review/Delete any Recurring templates/transactions in QBO | ||
| Settings, Subscription & Formatting |
Lead Bookkeeper
|
|
| QBO Books Review |
Lead Bookkeeper
|
|
| CHART OF ACCOUNTS | ||
|---|---|---|
| Create clean-up clearing accounts |
Lead Bookkeeper
|
|
| Revise the Chart of Accounts |
Lead Bookkeeper
|
| RECONCILIATIONS | ||
|---|---|---|
| Reconcile Balance Sheet to Schedule L Tax Return |
Lead Bookkeeper
|
|
| Determine accounts and dates to reconcile |
Lead Bookkeeper
|
| TRANSACTIONS | ||
|---|---|---|
| Transaction Review |
Lead Bookkeeper
|
|
| Bank feed & registers |
Lead Bookkeeper
|
|
| Catch up transactions in the bank feed |
Lead Bookkeeper
|
|
| Create Bank Feed Rules |
Lead Bookkeeper
|
|
| Personal Transactions |
Lead Bookkeeper
|
| BALANCE SHEET | ||
|---|---|---|
| Opening Balances |
Lead Bookkeeper
|
| SALES TAX AND B&O | ||
|---|---|---|
| Sales Tax Review |
Lead Bookkeeper
|
|
| Create the QBO DOR report | ||
| Create the DOR workbook to audit reported against what's in QBO | ||
| Plan for Sales Tax Paid at Source |
Lead Bookkeeper
|
|
| AP & AR | ||
|---|---|---|
| Update Products & Services | ||
| Update Products & Services List | ||
| Correct linked income/expense accounts | ||
| Send AP Aging Report for Review |
Lead Bookkeeper
|
|
| Send AR Aging Report for Review |
Lead Bookkeeper
|
|
| CLOSE OUT | ||
|---|---|---|
| Re-review Balance Sheet recon to Tax Return Schedule L |
Lead Bookkeeper
|
|
| Close out cleanup clearing account balances. |
Lead Bookkeeper
|
|
| Run and save updated Financial Statements | ||
| Wrap-up with client |
Lead Bookkeeper
|
|
| Client Tasks Client Tasks | ||
|---|---|---|
| Answer Transaction questions in Keeper/Recat | ||
| Here is a quick overview video of the cleanup we completed. Please let us know if you have any questions. | ||
| Review AR Report | ||
| Review AP Report | ||
| INVOICE & PRICING | ||
|---|---|---|
| Pricing adjustments |
Manager
|
|
| Send final Cleanup invoice |
Manager
|