About this template
Work type: Bookkeeping
Location: United States
Client industry: E-Commerce
Version: 1 (Latest)
This template includes
- 24 tasks
- Automations
Multiple Month Bookkeeping Clean Up Project
62 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.
| Initial Cleanup Tasks | ||
|---|---|---|
| Update the roster in ClickUp with any status change throughout project! |
Bookkeeping Team Lead
|
|
| Review client notes and contract |
Bookkeeping Team Lead
|
|
| Ensure COA meets SOP requirements |
Bookkeeping Team Lead
|
|
| Ensure all statements are saved in FC before starting bookkeeping |
Bookkeeping Team Lead
|
|
| Setup LMB or A2X (whichever is applicable) |
Bookkeeping Team Lead
|
|
| Verify opening balance equity (banks, credit cards, and inventory) |
Bookkeeping Team Lead
|
| Regular Bookkeeping Tasks | ||
|---|---|---|
| Send eCom sales settlements to QBO / Xero via LMB / A2X |
Bookkeeper
|
|
| Record COGS entries from LMB / A2X |
Bookkeeper
|
|
| Categorize bank/credit card account transactions using bank feeds |
Bookkeeper
|
|
| Leave transaction comments in ReCat and share to client |
Bookkeeper
|
|
| Check client responses to unknown transactions |
Bookkeeper
|
|
| Record reimbursements and sellable returns |
Bookkeeper
|
|
| Check client responses to unknown transactions |
Bookkeeper
|
|
| Remind client to review the uncategorized transactions (if they haven't yet) |
Bookkeeper
|
|
| Remind client of any outstanding tasks |
Bookkeeper
|
|
| Record other monthly journal entries (payroll, lending, etc) |
Bookkeeper
|
|
| Reconcile bank/credit card accounts to bank statements |
Bookkeeper
|
|
| Reconcile loans |
Bookkeeper
|
|
| Reconcile balance sheet accounts |
Bookkeeper
|
|
| Perform a self-review on client's books |
Bookkeeper
|
|
| Create a new TL Review project for this client in FC |
Bookkeeper
|
|
| Create a new "Monthly/Cleanup Review (Team Lead) project in FC for this client | ||
| Assign the project tasks to your TL | ||
| Change Project Status in ClickUp roster to "TL Pending" | ||
| Verify that the TL review project is complete and issues found are resolved |
Bookkeeper
|
|
| Change the "Financials Ready?" field in the roster to "YES" |
Bookkeeper
|
|
| Prepare financials report for the client |
Admin
|
|