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
Before 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.
Work type: Bookkeeping
Location: United States
Client industry: Generic
Version: 3 (Latest)
This template includes
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
|
Copyright © 2017-2025 Financial Cents LLC