Multiple Month Bookkeeping Clean Up Project

About this template

Use this template for scenarios where you bring on a new bookkeeping client and need to do a cleanup. We use Clickup to store our SOPs, and use Link My Books (LMB) and A2X for eCommerce connections.

Work type: Bookkeeping

Location: United States

Client industry: E-Commerce

This template includes

24 tasks
Automations

	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

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

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